You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Dashboard Presentation: Flu Shots Distribution 2022
Dashboard Metrics:
A. Portion (%) of patients getting flu shots stratified by:
Age
Race
County
Overall
B. Running total of flu shots over the year 2022
C. Total number of flu shots given in 2022
D. A list of patients identifying whether they received the flu shots (for follow-up)
Requirements:
Patients must have been recently "Active at our hospital" (have 'encounters' within the last 2 years)
Patients must be at least 6 months old to receive the flu shots
About
Designed a Healthcare dashboard using PostgreSQL and Tableau to visualiSe flu vaccination trends for 2022. Employing SQL CTEs, I filtered active patients within a two-year period and merged patient data with flu shot records.The dashboard features segmented bar charts for demographic insights and an interactive map for regional trends.