DATA ANALYST

TOOLS

 

  • Microsoft Excel

  • Microsoft Word

  • Tableau

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.

DATA

 

  • ​​​U.S. Census Population Data by Geography from the U.S. Census Bureau Agency 2009-2017

  • Influenza deaths from CDC (center for disease control and prevention) 2009-2017

  • Influenza visits from CDC (Fluview) 2010-2019

  • Project Brief

OBJECTIVE

 

To help the medical staffing agency that provides temporary workers to clinics and hospitals on planning for influenza season, and a time when additional staff are in high demand.

Prepare for the next influenza season in the United States by helping a medical staffing agency determine when, where, and how many staff to send to each state.

INFLUENZA SEASON

This map breaks down states by priority using the average population of those over 65 and the average number of deaths.

The high priority states are New York, Tennessee, Florida, Hawaii, Missouri, North Carolina.

HAWAII

ALASKA

Prioritizing States

The line graph shows forecast that Hawaii and Mississippi will have the highest mortality by influenza for the next two years comparing to other states.

Influenza High season Starts from December to March. That is when influenza deaths are at their highest. Some states, like Florida and New Jersey, show an increase in the months before the high season.

Seasonality and Staff Allocation

Vulnerable Population Analysis

We do not have data for all the vulnerable population (those under age 5 or having certain pre-existing conditions) data was excluded for privacy matters, but we do have data for the population age 65 and over. More people ages 65 and older die from influenza than those under age 65, unfortunately it is for all states from (2009-2017.)

States with the most deaths continue to be those with large populations and large vulnerable populations.

Comparison of the population by age across the United States. We can see the vulnerable population is from 65+, As we can see the most populated states with citizens over 65+ Years Old have the higher deaths by Influenza.

Population age and percentage of Deaths

  • Send results and determine next steps in collaboration with the stakeholders.

 

  • Focus Vaccination Campaigns for the group age 65+ by prioritizing that campaign in the age group.

 

  • Increase the staff number in those states with the higher rates of mortality by influenza, start sending staff by October-November.

 

  • Provide educational material to increase knowledge to change the perceptions towards influenza to increase healthy and preventive behavioral practices, especially in the most vulnerable population.

Recommendations and Conclusions

Ivonne Aspilcueta 

Data Analyst

 

Hermosa Beach, CA, United States