works

Power Bi visualizations

Client • 

Category • 

Date • 

October 1, 2024

Seasonal Influenza Surge

Flu season leads to increasedhospitalizations: especially in vulnerable populations. (below 5 years &above 65 years)

Hospitals require additional staff tomanage the higher patient load.

Staffing Agency's Role

A medical staffing agency providestemporary workers to hospitals across all 50 US. states.

The agency aims to efficiently plan forstaff distribution during flu season: ensuring adequate care Withoutoverburdening resources.

Why It Matters

Adequate staffing prevents understaffingrisks (patient care quality) and overstaffing inefficiencies (resource waste).

Prioritizing states with largervulnerable populations is critical for proactive staffing.

Objectives Project Objective& SuccessFactors

Objective

Develop a staffing plan to send the rightnumber of healthcare workers to each state based on flu season trends andstate—specific needs.

Focus on states with large vulnerablepopulations and adapt staffing according to flu severity and timing.

Key Success Factors

Ensure staffing matches patient needs(target: 90%-110% stag-to-patient ratio).

Use historical influenza data, populationvulnerability: and flu-shot rates to inform staffing decisions.

Data Insights

Analyze flu patterns and prioritizestates with greater vulnerability for timely resource allocation.

Recommendations

Key Findings

-High mortality in states with largevulnerable populations (under 5, over 65)

-Correlation of 0.84 between general andvulnerable population mortality

Geographic Disparities

- Elevated death rates in Midwest andSoutheast

- Visualization: Top 10 states withhighest influenza related deaths

Recommendations

-Vaccination: Prioritize high-mortalitystates, focus on vulnerable groups

-Healthcare: Increase resources and staffin affected states during critical periods

-Public Health: Boost awareness andprevention in high—risk states

-Monitoring: Keep track of and supportregions with increasing deaths among vulnerable groups

No items found.