top of page

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

​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.

flu2.png

Impact of Vulnerable population size on mortality rates

Screenshot 2025-01-14 at 10.22.13 PM.png

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 

​

flu4.png

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

flu5_edited.jpg

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 ?

flu6.png

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

flu7.png
  • 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.

bottom of page