Influenza Staffing Analysis

Prescriptive Analysis of Medical Staffing during Flu Season
Project Overview
Data gathered from the US Census Bureau and the CDC was used to provide insights towards Influenza season for the purposes of medical staffing. Microsoft Excel was used to clean, explore, and analyze the data. Tableau was used to create a storyboard of the data.
Tools and Datasets
The software tools included:
    - Microsoft Excel
    - Tableau

The datasets included:
    - population data by geography from the US Census Bureau
    - influenza deaths by geography, time, age, and gender from the CDC
Project Details
The initial focus was on identifying states with the most urgent staffing needs. California and New York emerged as the primary areas requiring attention. Subsequently, the temporal aspect of flu season became a key consideration, revealing a concentration of cases between December and March. Further exploration delved into factors influencing state-specific flu deaths, with a particular emphasis on vulnerable age populations.
The analysis identified New York, Texas, and Florida as outliers in the relationship between annual flu deaths and vulnerable age populations. Notably, New York exhibited a higher ratio of flu deaths compared to its vulnerable age population, possibly attributable to the density of urban centers such as New York City. In contrast, Texas and Florida, despite having high vulnerable age populations, experienced relatively lower annual flu deaths, potentially influenced by lower population density in key cities.

In conclusion, the data-driven approach recommends prioritizing states with higher vulnerable age populations and elevated flu deaths for medical staffing deployment. States such as California, New York, and Texas should receive increased attention. Conversely, regions with lower flu mortality rates, exemplified by Washington DC or Alaska, necessitate proportionately reduced staffing allocation. This comprehensive analysis, encapsulated in a structured spreadsheet, ensures informed decision-making for optimizing medical personnel deployment during influenza outbreaks.

Want to get in touch?
Drop me a line!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.