📊 Project Overview
Comprehensive analysis of hospital readmission patterns using CMS data
I analyzed 2,496 U.S. hospitals using CMS readmission and HCAHPS data to uncover $207.42M in potential savings. This 3-page Power BI dashboard provides national benchmarking, hospital-level comparisons, and financial improvement strategies.
The analysis combines Hospital Readmissions Reduction Program data with patient satisfaction metrics to identify cost-saving opportunities and performance improvement strategies across the U.S. healthcare system.
❗ Problem Statement
The Challenge
Hospital readmissions within 30 days cost Medicare billions annually and indicate gaps in care quality. Despite risk-adjustment models, significant variation exists across hospitals and states. Healthcare administrators lack comprehensive tools to:
- → Identify geographic patterns in readmission performance
- → Compare hospital-level outcomes against national benchmarks
- → Quantify financial impact of excess readmissions
- → Prioritize improvement initiatives based on ROI
🔍 What I Did
Data Acquisition & Preparation
- Downloaded CMS Hospital Compare datasets
- Cleaned data using Power Query
- Removed duplicates and handled missing values
- Standardized formats across tables
- Created star schema data model
Analysis & Development
- Built 15+ DAX measures
- Designed 3-page interactive dashboard
- Implemented conditional formatting
- Created cross-filtering and drill-through
- Calculated performance metrics
Key Techniques
- Dynamic filtering with ALLSELECTED
- RANKX for state rankings
- AVERAGEX for aggregations
- Financial calculations and ROI
- Performance categorization with SWITCH
💡 Key Findings
Data-driven insights revealing opportunities for improvement
$207.42M Annual Opportunity
Identified potential Medicare savings if all hospitals achieved top-quartile performance (excess ratio < 0.87)
242% Performance Variation
Hospital excess readmission ratios range from 0.48 (52% better than benchmark) to 1.64 (64% worse than benchmark)
Geographic Disparities
State-level performance varies from 0.92 to 1.03, suggesting regional differences in care quality and infrastructure
Weak Satisfaction Correlation
Patient satisfaction shows minimal relationship with readmission rates, indicating distinct quality dimensions
Pneumonia = Highest Cost
Identified highest-cost condition for targeted intervention programs
56% Above Benchmark
Majority of hospitals exceed national readmission expectations, highlighting systemic improvement opportunities
🎯 Strategic Recommendations
Actionable strategies for reducing readmissions and improving outcomes
- Targeted Interventions Focus improvement efforts on pneumonia readmissions (highest cost driver) with evidence-based discharge protocols
- Best Practice Sharing Implement knowledge transfer programs from top-performing states (ratio < 0.90) to underperforming regions
- High-Impact Hospitals Prioritize the top 100 hospitals by excess cost for intensive quality improvement initiatives - potential for maximum ROI
- Condition-Specific Protocols Develop standardized post-acute follow-up procedures for high-readmission conditions
- State-Level Collaboration Share resources and strategies among hospitals within underperforming states to address systemic issues
📱 Dashboard Pages
Three comprehensive views for different analytical needs
Page 1: National Overview
Geographic visualization and state-level performance analysis
Features
- Geographic heat map showing state performance
- State performance rankings
- National KPIs and benchmarks
- Performance distribution charts
- Interactive filters by state/type/ownership/condition
Insights
- Visualizes geographic disparities across the U.S.
- Identifies top and bottom performing states
- Shows distribution of hospital performance categories
Page 2: Hospital Comparison & Drill-Down
Hospital-level analysis with comparative benchmarking
Features
- Scatter plot: satisfaction vs. readmission performance
- Searchable hospital-level table
- Conditional formatting for performance categories
- Dynamic KPIs (selected/best/worst hospitals)
- Drill-through to hospital details
Insights
- Enables detailed hospital-level analysis
- Reveals satisfaction-performance relationships
- Supports comparative benchmarking for improvements
Page 3: Financial Impact & ROI Analysis
Cost analysis and financial optimization opportunities
Features
- Waterfall chart breaking down costs by condition
- Top 10 states by total readmission cost
- Cost distribution by performance category
- ROI calculations for improvement initiatives
- Financial metrics and projections
Insights
- Quantifies financial impact of readmissions
- Identifies highest-cost conditions and states
- Demonstrates potential savings from improvement
🛠️ Technical Implementation
Data Sources
CMS Hospital Compare (2024): Hospital Readmissions Reduction Program data
- • Hospital Readmissions: 11,927 records
- • Hospital General Info: 2,496 hospitals
- • Patient Satisfaction: 3,975 records
Data Model
Schema Design
- Star schema architecture
- Hospital General Info as dimension table
- Proper relationships and cardinality
- Bidirectional cross-filtering
Key DAX Measures
- ALLSELECTED for dynamic filtering
- RANKX for state rankings
- SWITCH for performance quartiles
- CALCULATE with filters
- AVERAGEX for aggregations
Visualization Techniques
- ArcGIS map with color saturation
- Scatter plots with dynamic legends
- Waterfall charts for cost buildup
- Conditional formatting
- Cross-page navigation
📈 Business Impact
Enabling data-driven decision-making for healthcare administrators
Identify underperforming hospitals requiring intervention
Quantify ROI of quality improvement initiatives
Benchmark performance against national and state averages
Prioritize resources based on financial impact
Track geographic trends for policy development
Support data-driven decision-making for operations
🔗 Related Projects
Healthcare Analytics Portfolio
This Power BI dashboard is part of my comprehensive healthcare analytics portfolio:
- → Hospital Database Management System - SQL database with advanced queries and analytics
- → CNN Emotion Recognition - Machine learning research on computational modeling
- → Higher Education Analytics - Tableau dashboard on student retention (coming soon)