Analyzing hospital performance and benchmarking

Case Study: Analyzing Healthcare Data in Tableau

Maarten Van den Broeck

Senior Content Developer, DataCamp

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

$$\frac{\text{total costs}}{\text{total discharges}}$$

Useful benchmark to compare cost efficiency between hospitals
Cost variance is driven by multiple factors
- 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?
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 Tableau