In this project, I created a dashboard tracking influenza (flu) vaccines administered in a simulated Massachusetts healthcare system. I use synthetic patient data generated by  SyntheaTM, an open-source patient population simulation, and modified and shared by Joshua Matlock.

I use PostgreSQL 16/pgAdmin 4 to select and prepare the data (queries linked below) and use the output data to create a dashboard in Tableau that provides access to flu vaccination coverage data for 2022. 

In selecting the data for the dashboard, I limited the selection to patients who had been active at the hospital (defined as having at least one encounter within the past three years and not deceased) and patients 6 months of age or older and therefore eligible for a flu shot.

Using output from the PostgreSQL queries, I created a dashboard in Tableau providing access to:

• total number of flu vaccine doses given in 2022

• overall percentage of patients receiving flu vaccinations

• percentages of patients given flu vaccines stratified by age, race, and county

• a list of patients showing whether or not they received a flu vaccine

• running total of flu vaccinations over the course of 2022

The county map allows selection and filtering of data presented in the dashboard, filtered by county.

I chose high contrast font colors and the color blind palette for accessibility.

Additional Healthcare Dashboard Samples: