The Healthcare Performance Analytics Dashboard is an end-to-end operational analytics system designed to improve healthcare system efficiency through data-driven insights. This project integrates CMS hospital data, readmission datasets, and quality metrics to deliver actionable visibility into hospital performance across clinical, operational, and outcome dimensions.
The system:
- Improves operational transparency by centralizing fragmented hospital data into a unified performance view
- Supports data-driven healthcare management by surfacing KPIs that administrators, clinicians, and analysts need to make informed decisions
- Helps institutions monitor performance over time with trend analysis, benchmarking, and early-warning indicators
healthcare-analytics/
│
├── README.md ← Project overview (you are here)
│
├── sql/
│ ├── 01_schema_setup.sql ← Database schema & table definitions
│ ├── 02_data_cleaning.sql ← Data cleaning & standardization
│ ├── 03_hospital_performance.sql ← Hospital performance metric queries
│ ├── 04_operational_efficiency.sql← Operational efficiency queries
│ ├── 05_outcome_analytics.sql ← Outcome & quality indicator queries
│ └── 06_views_and_aggregates.sql ← Reusable views for Power BI
│
├── excel/
│ ├── Healthcare_Data_Model.xlsx ← Cleaned dataset with pivot tables
│ └── Data_Dictionary.xlsx ← Field definitions & source mapping
│
├── powerbi/
│ └── Healthcare_Dashboard.pbix ← Power BI report file
│
├── data/
│ ├── sample_cms_hospital.csv ← Sample CMS hospital data (anonymized)
│ ├── sample_readmissions.csv ← Sample readmission dataset
│ └── sample_quality_metrics.csv ← Sample quality indicators
│
└── docs/
├── Data_Sources.md ← Dataset sources & access instructions
├── Dashboard_Guide.md ← How to use the Power BI dashboard
└── SQL_Query_Guide.md ← Query documentation & usage notes
| Metric | Description | Source |
|---|---|---|
| Readmission Rate | 30-day all-cause readmission % by hospital | CMS Hospital Readmissions |
| Patient Satisfaction | HCAHPS survey scores (overall & domain) | CMS HCAHPS Data |
| Average Length of Stay | Mean LOS by DRG, department & hospital | CMS Inpatient Data |
| Metric | Description | Source |
|---|---|---|
| Patient Volume Trends | Monthly admissions & ED visits over time | Hospital discharge data |
| Department Utilization | Bed occupancy & throughput by department | CMS cost report data |
| Metric | Description | Source |
|---|---|---|
| Quality Indicators | Mortality, complication, infection rates | CMS quality measures |
| Performance Comparisons | Peer benchmarking by hospital size/region | CMS compare datasets |
| Tool | Version | Purpose |
|---|---|---|
| SQL (Microsoft SQL Server) | 14+ | Data storage, cleaning, transformation |
| Microsoft Excel | 2019+ | Data modeling, pivot analysis, staging |
| Power BI Desktop | Latest | Interactive dashboard & visualizations |
- Microsoft SQL Server 2019+ installed locally or cloud instance (Azure, AWS RDS)
- Microsoft Excel 2019 or Microsoft 365
- Power BI Desktop (free download from Microsoft)
-- Run scripts in order
sqlcmd -S your_server -d your_db -i sql�_schema_setup.sql
sqlcmd -S your_server -d your_db -i sql�_data_cleaning.sql
sqlcmd -S your_server -d your_db -i sql�_hospital_performance.sql
sqlcmd -S your_server -d your_db -i sql�_operational_efficiency.sql
sqlcmd -S your_server -d your_db -i sql�_outcome_analytics.sql
sqlcmd -S your_server -d your_db -i sql�_views_and_aggregates.sql-- Load CSV data into staging tables
BULK INSERT staging.cms_hospital FROM 'C:\your_path\data\sample_cms_hospital.csv'
WITH (FORMAT = 'CSV', FIRSTROW = 2, FIELDTERMINATOR = ',', TABLOCK);
BULK INSERT staging.readmissions FROM 'C:\your_path\data\sample_readmissions.csv'
WITH (FORMAT = 'CSV', FIRSTROW = 2, FIELDTERMINATOR = ',', TABLOCK);
BULK INSERT staging.quality_metrics FROM 'C:\your_path\data\sample_quality_metrics.csv'
WITH (FORMAT = 'CSV', FIRSTROW = 2, FIELDTERMINATOR = ',', TABLOCK);- Open
excel/Healthcare_Data_Model.xlsx - Navigate to the Data tab → Refresh All to pull from your database
- Review pivot tables on each sheet for pre-built summaries
- Open
powerbi/Healthcare_Dashboard.pbixin Power BI Desktop - Go to Transform Data → Data Source Settings
- Update the server/database connection to your SQL Server instance
- Click Refresh — all visuals will populate automatically
| Dataset | Source | Access |
|---|---|---|
| CMS Hospital General Information | data.cms.gov | Free / Public |
| Hospital Readmissions Reduction Program | data.cms.gov | Free / Public |
| HCAHPS Patient Survey | data.cms.gov | Free / Public |
| Hospital Compare Quality Measures | data.cms.gov | Free / Public |
📌 See
docs/Data_Sources.mdfor full download instructions and field mapping.
- Which hospitals have above-average readmission rates compared to state and national benchmarks
- Correlation between patient satisfaction scores and length of stay
- Department-level utilization bottlenecks driving extended average LOS
- Year-over-year trends in quality indicators to track improvement initiatives
- Peer group benchmarking — compare similar hospitals by bed count, teaching status, and region
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
- Fork the repository
- Create a feature branch (
git checkout -b feature/new-metric) - Commit your changes (
git commit -m 'Add new metric') - Push to the branch (
git push origin feature/new-metric) - Open a Pull Request
This project is licensed under the MIT License — see the LICENSE file for details.
Built as a portfolio project demonstrating healthcare analytics capabilities using SQL, Excel, and Power BI.
Data used in this project is publicly available from CMS (Centers for Medicare & Medicaid Services) and does not contain any protected health information (PHI).