Skip to content

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

0 stars

Watchers

1 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors