Influenza Season Staffing

Prepare for the upcoming Influenza season by cleaning and integrating government data in Excel. Using Tableau for visualizations and to better understand what area and age group need the most help.

Data

Analytical Techniques

Translating business requirements
Data Cleaning
Data Integration and Transformation Statistical Hypothesis
Testing Visual Analysis
Forecasting
Storytelling in Tableau
Presenting findings to stakeholders

I used Tableau to visualize the relationship between region and the average influenza death within the state and forecasting for future years.

High vulnerability states such as New York have some of the highest death rates. However, large vulnerable populations do not directly relate to death rate as states with low vulnerable populations.
Vulnerability populations include people over the age 65, children under the age 5, and people with preexisting conditions

The top 4 states with the highest rate of Influenza Deaths.

I used Tableau to see what age group has the most deaths and what age would make up the vulnerable group.

Results

When deciding what states will need the most staffing help during the peak influenza season looking at overall influenza rates and vulnerable death rates is going to be most helpful. Looking at the previous information we can see that California, New York, Pennsylvania, and Texas have the highest death rates and overall death due to influenza.

Recommendations

The recommendations would be to send the staffing to California, New York, Pennsylvania, and Texas as they are seeing the most death cases.
If we could get more in death data from the clinics, we may better be able to plain for the next influenza season.
Additional insights are needed from staff or locations, to analyses and plan on a deeper level