Understanding Influenza Seasonal Patterns for Medical Staffing Agencies

About

Medical staffing agencies provide temporary workers to clinics and hospitals as needed. The analysis will help plan for influenza season, a time when additional staff are in high demand.

Data

Goals

  • Identify populations most vulnerable to the flu.
  • Identify the highest concentration  areas of vulnerable population
  • Make recommendations on where to send additional aid.

Skills

  • Data cleaning
  • Data integration
  • Data transformation
  • Statical hypothesis testing

Tools

  • Excel
  • Tableau

Key Questions

  1. Who are the vulnerable populations?
  2. Which states are most vulnerable?
  3. When does the flu season begin and end?

Analysis

  • The most vulnerable group are those over the age of 65
  • States with a higher population of people over 65 tend to have more influenza deaths.

Influenza occurs seasonally, beginning in October and ending in April. The influenza season usually hits its peak in January.

Recommendations

  • The 65+ population is the most vulnerable for hospitalization and death due to influenza
  • The 10 states listed on the left represent 57% of the 65+ population and 52% of all influenza deaths
  • •Increasing staffing for these states during peak influenza times could reduce deaths and ease stresses on hospitals

Deliverables