- Tableau
- Microsoft Excel
Medical Staffing Agency
Overview
During the Influenza season, hospitals and clinics need additional staff to adequately treat the extra patients. The medical staffing agency provides this temporary staff in the US.
Objective
Determine when to send staff, and how many, to each state.
- Project Scale: One month
- Analysis based on: Last 9 years (2009- 2017)
- Scope: The agency covers all hospitals in each of the 50 states of the United States.
- - If the vulnerable population ratio increases in a US state, we need more medical staff to be sent to their healthcare providers.
- A state is understaffed if the staff-to-patient ratio is <90% of the required ratio and overstaffed if >110%.
- Data cleaning
- Data transformation
- Data integration
- Statistical Hypothesis testing
- Storyboard & storytelling
- Pivot tables
- Calculated fields
- presentation and communication with stakeholders
- Format: Excel-CSV
- Records: ~29K
- Information: CDC Influenza Deaths, US Census
-
Data Citation:
CDC,
US Census Bureau,
Influenza Lab Test,
Influenza Visits,
Survey of Flu Shot
Last update: 2017
Recommendation
- California, New York, and Texas are the top three states with the highest demand of medical staff help. All the states are categorized in three priorities (High, Medium, Low) in the storyboard here.
- It would be great if we had the number of permanent staff in each location, in addition to the population and influenza deaths report in each city and location, so that we could have a detailed plan for each location in the next step
Tableau Story