Preparing for influenza seasonEach year the United States has a Flu season where more people than usual suffer from the Flu. Vulnerable populations can develop serious complications and end up in the hospital. Hospitals and clinics need additional staff to adequately treat these extra patients. The medical staffing agency provides this temporary staff
Objective: To help a medical staffing agency determine when to send staff and how many to each state for the upcoming flu season
Procedures: Translating Business Requirements Data Integration, Hypothesis Testing, Data Cleaning, Data Transformation, Visual Analysis & Forecasting, Data Storytelling in Tableau, Presentation of Results
Tools used: Excel, Tableau, Youtube
Data: From the CDC and US Census Bureau
Who are the vulnerable populations?
Which states are most vulnerable?
When does flu season begin/end?
KEY QUESTIONS
RESULTS
Individuals over the age of 65 are most vulnerable to flu
Some states are more impacted than others - California, New York, Texas, Florida & Pennsylvania are the most severe
The Flu season is the same in all regions of the United States
The Flu runs from October through April
The Flu peaks in January
RECOMMENDATIONS
Send additional staff to the high-need states during flu season
California, New York, Texas, Florida, Pennsylvania
Send in October and monitor hospitalizations/flu death
Monitor and evaluate next-tier states as needed
