💻 Build this Flu Shots Dashboard with SQL and Tableau!

In this tutorial we build a SQL extract to plug into Tableau so that we can build a flu shots dasboard! This is a good example of how I might approach a project in my day to day work.

To follow the SQL tutorial, check this video out if you haven't already, as you will need it to install PostgreSQL, pgAdmin, and the data files for this lesson:    • 👉 SQL Basics with Healthcare Data | 1...  

If you would like to skip ahead to the Tableau tutorial, click on 31:14. If you do skip the SQL tutorial, just remember to download the csv spreadsheet; you can get it at my website: https://datawizardry.academy/flu-shot...

Update Sept 2023: My formula in the video for age is setup incorrectly (kudos to @JoelTorres1237 for finding the bug). Try using this formula instead for the age calculation
EXTRACT(EPOCH FROM age('2022-12-31',pat.birthdate)) / 2592000

Update Oct 2023: I realize that I around 14:00, I forgot to pull in the age calculation as one of the columns I'm selecting. Which should be something like this:

extract(YEAR FROM age('12-31-2022', birthdate)) as age
-------------------------------
HTML codes I used:
#57ecb2
#5c5a74
#005f9c
#2b3048

31:14 Skip to Tableau Lesson
------------------------------------------------
00:00 Intro
01:13 SQL Setup
01:55 SQL Demo
28:18 Tableau Setup
33:00 Tableau Demo

My GitHub SQL code:
https://github.com/Data-Wizardry/Yout...

My Tableau file is downloadable here:
https://public.tableau.com/app/profil...

Note: all of this data is synthetically generated (i.e. fake), and comes from a project called Synthea. No real patient data was used in this lesson.

// ABOUT DATA WIZARDRY:
Hey I'm Josh! I've been a data analyst in the healthcare industry since 2015. Join me as I teach you how to get a job as a data analyst. I do SQL, Python, Tableau, and Networking tutorials.

// BECOME A CLINICAL DATA ANALYST!
My course teaches you everything you need to know in just 10-12 weeks:
https://datawizardry.academy/clinical...

// FREE WEBINAR!
In this 1-hour webinar, I lay out a roadmap for you to learn how to become a data analyst, and gain healthcare domain knowledge:
https://datawizardry.easywebinar.live...

🔴 YouTube:    / @datawizardry  
🟢 TikTok:   / data.wizardry  
🔵 LinkedIn:   / joshuamatlock  
🔗 Website: https://datawizardry.academy

#sql #tableau #dataanalytics #dataanalyst #healthcaretechnology #healthcare #career