Influenza
Improving medical staffing response to influenza outbreaks across the United States.
Objective
Improve flu season preparedness by optimizing staffing in healthcare facilities from 2009-2017. The goal was to better support vulnerable populations during peak flu periods.
Data
-
Influenza deaths in 2009-2017 sourced from CDC
-
Population data from 2009-2017 sourced from US Census Bureau
-
Influenza visits from 2010-2019 sourced from CDC (Fluview)
​Skills
-
Designing a data research project
-
Sourcing, cleaning, and profiling data
-
Data integration and transformation
-
Statistical hypothesis testing
-
Visual analysis and forecasting
-
Visualization in Tableau
Tools
-
Microsoft Excel
-
Microsoft Word
-
Tableau
Flu Deaths
The number of flu deaths generally increases with age. This is evident from the overall height of the boxes in the box plot, with the older age groups (65-74, 75-84, 85+) having significantly higher death counts compared to younger age groups.

Impact of Vulnerable population size on mortality rates

A valuable overview of population distribution and the vunerable population in the United States. A larger vulnerable population is associated with increased mortality rates
Correlation between population size and mortality rates
​

The graph suggests a positive association between population density and mortality rates, indicating that states with higher
population densities tend to have higher death rates.
Priority Map

The map visually demonstrates that California, New York, Texas, Pennsylvania, and Florida have the highest staffing needs priority, followed by other states
Is Flu Seasonal ?

Flu activity across most states typically peaks during the winter months, from November to March.

-
The historical mortality trends from 2009 to 2017 for the top 10 states and presents a forecast for 2018.
-
The forecast indicates a projected increase in mortality rates for most of the states in 2018.
Conclusions & Recommendations
​Surveillance and Monitoring
-
Create different staffing scenarios based on forecasted demand and resource availability.
Vaccination Access
-
Improve access to affordable and convenient vaccination services for all populations, with a focus on vulnerable groups.
Healthcare System Preparedness
-
Improve staffing levels and ensure adequate supplies of medical equipment and pharmaceuticals.
Targeted Interventions
-
Implement targeted interventions to protect vulnerable populations, including the elderly, young children, pregnant women, and individuals with chronic health conditions.