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
Case Study: Analyzing Healthcare Data in Tableau

Introducing cost to the equation

  • Average cost per discharge:

$$\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

Case Study: Analyzing Healthcare Data in Tableau

Insights to explore

  • 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

Let's practice!

Case Study: Analyzing Healthcare Data in Tableau

Preparing Video For Download...