Preparing for Influenza season
PROBLEM
The United States has an influenza season where more people than usual suffer from the flu. Some people, particularly those in vulnerable populations, 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.
GOAL
Determine who is most vulnerable , when to send staff, and how many, to each state.
Skills Used
Data cleaning
​
Data integration
​
Data transformation
​
Forecasting
​
Visualization
​
Storytelling with Tableau
Tools Used
Microsoft Excel
​
Microsoft Powerpoint
​
Tableau
Data Source
Influenza deaths by geography:CDC
​
Counts of influenza laboratory test results by state (survey):CDC(fluview)
​
Survey of flu shot rates in children:CDC1
Preparing for Influenza season Insights
Who is most vulnerable to Influenza?
Total flu death by age group from 2009-2017
-
The most vulnerable population are those of 65+ years.
​​
-
The people with age 65+ are at a higher risk of hospitalization and death.
Relation between Influenza death and population of 65+
Hypotheis:
If a state has a higher proportion of persons aged 65 and up, then there will be a positive correlation with a higher influenza-related death rate in that state.
Created trend line inorder to understand relationship between flu death and age of population above 65+ years:
-
Shows strong relationship
​​
-
Most of the datapoints are close to Trendline which means vulnerable population of age above 65+ years are high risk of death due to Influenza.
Why some states in United states are more affected by Influenza?
Average Influenza death by state (2009-2017)
-
The state California has high number of influenza death and the state has highest population of people above 65+.
​
-
The states like New York, Florida and Texas also have high influenza deaths.
​
-
The states like wyomig,North Dakoda, Vermont has lowest number of influenza death.
-
Need to give priority to the California state in case assigning staffing health workers.
​​
-
Followed priority for New York, Florida and Texas also have high influenza deaths.
​
-
Give least priority to states like wyomig,North Dakoda, Vermont.
