Healthcare Analysis with Power BI

Case Study: Analyzing Healthcare Data in Power BI

Lyndsay Girard

Healthcare Analytics Consultant

What is a case study?

  • Apply Power BI Skills
  • Combine previously learned concepts
  • Solve an example real-world problem

Prerequisite Courses:

  • Data Visualization in Power BI
  • DAX Functions in Power BI

Young female character writing code on a desktop computer

Case Study: Analyzing Healthcare Data in Power BI

Case study goals

Hospital building exterior

A fictitious consulting company (HealthStat) has hired you to uncover insights on potential hospital efficiency opportunities.

  • Analyze an anonymized dataset from hospitals.
  • Leverage Power BI to create an engaging dashboard.
Case Study: Analyzing Healthcare Data in Power BI

Framework for healthcare quality

Institute of Medicine (IOM) quality framework listing the six domains of healthcare quality

  • Analytical framework for healthcare quality.
  • Focus for this case study is efficiency domain.
1 https://www.ahrq.gov/talkingquality/measures/six-domains.html
Case Study: Analyzing Healthcare Data in Power BI

Measuring Hospital efficiency

Length of stay (LOS) is the duration in days for a patient stay in a hospital.

  • Reducing LOS can lower costs, increase capacity, and improve throughput.
  • Factors impacting LOS: patient age, health status, procedure, complications, mortality risk, hospital size, etc.

hospital bed with wheels and health symbol above

1 https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5898738/
Case Study: Analyzing Healthcare Data in Power BI

Terminology overview

doctor gesturing to a chart with listed information

  • Inpatient: person who has been admitted to a hospital bed.
  • Discharge: release of a patient from hospital care by a medical worker.
  • Disposition: the patient destination or status upon discharge.
  • Elective: reason for surgery was planned (not an emergency).
Case Study: Analyzing Healthcare Data in Power BI

Patient population for analysis

doctor characters with magnifying glass viewing human pelvic bones with hip prosthesis

Elective hip replacement surgery

  • Patients with hip pain, typically arthritis, may require elective hip replacement surgery.
  • Damaged bone and cartilage is removed and replaced with prosthetic components.
  • Arrival to hospital with surgery on day zero, stay 0-2 days.
1 https://orthoinfo.aaos.org/en/treatment/total-hip-replacement/
Case Study: Analyzing Healthcare Data in Power BI

The dataset

Key characteristics

  • New York state-wide hospital discharge data for 2016.
  • Elective hip replacement surgery patients.
  • One single table with 30 columns.
  • Each row represents a single inpatient stay, or discharge.

laptop screen displaying electronic medical record

Case Study: Analyzing Healthcare Data in Power BI

Dataset outcome attributes

Key outcome attributes of interest for the case study

Column name Description
length_of_stay Total days the patient stayed in hospital, including surgery and recovery time.
total_costs Total cost for the stay.
Case Study: Analyzing Healthcare Data in Power BI

Dataset explanatory attributes

Key attributes of interest for the case study

Column name Description
facility_id A unique id that identifies each distinct hospital.
age_group Age of patient at the time of discharge.
patient_disposition The patient's destination status upon discharge.
ccs_diagnosis_description Most responsible diagnosis code associated with the hospital stay.
apr_severity_of_illness_description Illness severity level assigned standard score on scale from 1 (Minor) to 4 (Extreme).
apr_risk_of_mortality Mortality risk assigned standard score on scale from 1 (Minor) to 4 (Extreme).
Case Study: Analyzing Healthcare Data in Power BI

Your final deliverable

Create a dashboard that enables your stakeholders to:

  • Progress through key insights in a logical flow.
  • View informative, concise visuals.
  • Get data to make business decisions to improve efficiency.

Dashboard_Compilation_Final.png

Case Study: Analyzing Healthcare Data in Power BI

Let's start analyzing!

Case Study: Analyzing Healthcare Data in Power BI

Preparing Video For Download...