Preparing for the flu season in the US
Objective
This project is to help a medical staffing agency that provides temporary workers to clinics and hospitals as needed. The analysis will help plan for influenza season when additional staff are in high demand. The final results will examine trends in influenza and how they can be used to proactively prepare for staffing needs across the country.
Data set
Influenza deaths by geography, time, age, and gender
Source: CDC
​
Population data by geography
Source: US Census Bure
​
Counts of influenza laboratory test results by State (survey)
​
Download Influenza Visits Data Set
​
Survey of flu shot rates in Children
Source: CDC
Skills and Tools Used in the Project
-
Excel
​
-
Translating business requirements
​
-
Data cleaning
​
-
Data integration & transformation
​
-
Statistical hypothesis testing
​
-
Visual Analysis & Forecasting
​
-
Storytelling in Tableau
​
-
Presenting results
Links to the project resources
Stakeholders requirements
-
Provide information to support a staffing plan, detailing what data can help inform medical personnel's timing and spatial distribution throughout the United States.'
​
-
Determine whether influenza occurs seasonally or throughout the entire year. If seasonal, does it start and end simultaneously (month) in every state?
​
-
Prioritise states with large vulnerable populations. Consider categorising each state as low-, medium-, or high-need based on its vulnerable population count.
​
-
Assess data limitations that may prevent you from conducting your desired analyses.
Visualisation using Tableau
-
Identifying vulnerable age groups affected highly by flu using composition and comparison charts in Tableau.
​
​
-
Statistical Visualizations using Histograms & Box Plots.
​
​
-
Tableau temporal visualisations & forecasting were used to find the most affected region and to allocate sufficient medical staff demand.
​
​
-
Creating visualisation to find regional flu-affected patients through spatial analyses.
​
Conclusion
