Analyzing Hospital Performance and Benchmarking

Case Study: Analyzing Healthcare Data in Power BI

Lyndsay Girard

Healthcare Analytics Consultant

Looking back

Illustration of five various hospital exteriors

151 hospitals in New York State performed elective hip replacement surgeries.
26,286 total discharges.
The average LOS was 2.65 days.
Variability between hospitals not yet explained.

Average cost per discharge = total costs / total discharges.
Useful benchmark to compare cost efficiency between hospitals.
Cost variance is driven by multiple factors (e.g. patient severity, age, hospital size, procedures and equipment used).

Image of a hospital bed with a dollar bill above

Which hospitals stand out with highest cost and LOS relative to the state average?
Which hospitals stand out as biggest outliers overall?
Does larger surgical program size impact LOS and cost?
Root cause analysis: what factors influence LOS and cost the most?

Illustration of four healthcare professionals looking at a medical data dashboard

Case Study: Analyzing Healthcare Data in Power BI