Oluwapelumi-Portfolio

Healthcare Patient Management & Treatment Pathway Dashboard

πŸ“Š Project Overview

Interactive Power BI dashboard analyzing patient visit patterns, treatment pathways, and healthcare operations across 62,561 patient visits. This analysis provides insights into insurance utilization, departure dispositions, and length of stay to optimize hospital operations and improve patient care delivery.

Tools Used: Power BI (DAX, Data Modeling, Interactive Visualizations, Custom Measures)

🎯 Key Objectives

πŸ“ˆ Dashboard Pages

This comprehensive 4-page Power BI dashboard provides end-to-end analysis of patient visits, from arrival through treatment to discharge outcomes.

Page 1: Patient Visit & Emergency Care Analysis

Emergency Care Dashboard

Focus Areas:

Page 2: Diagnosis & Care Outcome Analysis

Diagnosis Dashboard

Focus Areas:

Page 3: Management & Treatment Pathway Analysis

Treatment Pathway Dashboard

Focus Areas:

Volume Trends Dashboard

Focus Areas:

πŸ“₯ Download Dashboard

Download Power BI File (.pbix)

Note: Requires Power BI Desktop (free) to open

πŸ” Key Insights

Patient Volume & Emergency Care (Page 1):

Diagnosis & Patient Demographics (Page 2):

Treatment & Insurance (Page 3):

Volume Trends & Timing (Page 4):

πŸ’‘ Recommendations

Emergency Care & Capacity Management:

  1. Address Green Valley Hospital wait times (950 min) - significantly higher than Oceanview (887) and Riverside (830)
  2. Optimize 8AM-12PM operations handling 40,255 arrivals (64% of daily volume)
  3. Expand Room 102 capacity (5.6K patients) or redistribute load to underutilized rooms
  4. Prepare for December surge (14.96% growth) with enhanced staffing and bed availability

Clinical Care Optimization:

  1. Develop specialized cardiac care pathways for 2.9K heart attack cases (top diagnosis)
  2. Create pediatric care protocols for 10K child patients requiring age-appropriate treatment
  3. Target 21-40 age demographic (14.0K patients - highest volume) with preventive care programs
  4. Reduce average length of stay from 5.23 days through enhanced discharge planning

Treatment & Resource Allocation:

  1. Streamline medication pathway serving 25K patients (40% of volume) - largest treatment group
  2. Optimize discharge processes for 31K home-discharge patients (50% of total)
  3. Reduce 1-3 day stays (23K patients) through same-day discharge opportunities where appropriate
  4. Balance Medium priority volume (31K cases) with Low (19K) and High (12K) for optimal triage

Financial & Access:

  1. Strengthen Medicare operations for 18.8K visits (30% of volume - largest payer)
  2. Address 9.4K Self-Pay patients with financial counseling and insurance enrollment assistance
  3. Negotiate improved rates with Private insurance (15.5K visits - second largest segment)

Operational Efficiency:

  1. Maintain 30.10% admission rate as benchmark - current triage is effective
  2. Synchronize discharge timing with arrivals (both peak 8AM-12PM) to manage bed turnover
  3. Monitor December admission rate spike (4.50%) and plan surge capacity annually
  4. Address 12% β€œOther” patient gender category for improved demographic data collection

πŸ› οΈ Technical Skills Demonstrated

Power BI Features Used:

Analytical Capabilities:

πŸŽ“ Skills Demonstrated