Project Overview
End-to-end healthcare analytics project analyzing hospital performance, patient outcomes, and operational KPIs across 15 Saudi Arabian hospitals. Built with Python, Power BI, and SQL, aligned with Saudi Vision 2030 healthcare transformation goals.
Key Findings
- Analyzed 3,000+ admissions and 5,000+ treatments across 15 hospitals.
- Calculated 12 industry-standard healthcare KPIs.
- Identified Hajj season impact on hospital capacity (7.4% increase).
- Compared Government vs Private hospital performance.
- Built interactive 4-page Power BI dashboard.
Tools & Technologies
- Python:
pandas,matplotlib,seaborn,numpy - Power BI: Interactive dashboard with DAX measures
- SQL: Complex queries with JOINs, CTEs, Window Functions
- Excel: Multi-sheet report with pivot tables
Healthcare KPIs Tracked
| KPI | Value | Benchmark | Status |
|---|---|---|---|
| Average Length of Stay | 7.97 days | 4-5 days | ⚠️ High |
| Bed Occupancy Rate | 78.7% | 80-85% | ⬇️ Low |
| 30-Day Readmission Rate | 14.9% | <10% | ⚠️ High |
| Patient Satisfaction | 3.86/5 | >4.0 | 👍 Good |
Project Structure
Saudi-Healthcare-Analytics-Dashboard/
├── data/ # 10 CSV datasets
├── charts/ # 8 Python visualizations
├── Healthcare_Analysis.ipynb
├── Healthcare_KPI_Dashboard.xlsx
├── Healthcare_Analytics_Report.xlsx
├── Healthcare_Analytics_Dashboard.pbix
└── Healthcare_Analytics_Dashboard.pdf
Dataset Description
Detailed breakdown of the multi-dimensional dataset used for this analysis:
- 15 Hospitals: A diverse mix of facilities across various regions in Saudi Arabia.
- 500 Patients: Detailed demographics including age, gender, and nationality.
- 3,000 Admission Records: Complete tracking from check-in to discharge.
- 5,000 Treatment Records: Documented medical procedures and clinical interventions.
- 4,000 Lab Results: Integrated laboratory data for comprehensive clinical insights.
- 2,000 Satisfaction Surveys: Patient-reported experience measures (PREMs).
Vision 2030 Alignment
Strategic Goal: This project is directly aligned with the Health Sector Transformation Program under Saudi Vision 2030.
By leveraging advanced analytics to optimize hospital operations, improve patient outcomes, and enhance resource allocation, this work demonstrates the power of data-driven decision making in building a world-class healthcare ecosystem for the Kingdom.