Skip to content

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.

Notifications You must be signed in to change notification settings

kylecalbert/flushots_dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 

Repository files navigation

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

Dashboard Screenshot

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.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published