Healthcare Analytics Intelligence
An end-to-end healthcare analytics solution designed to transform patient, hospital, admission, diagnosis and billing data into actionable business and clinical insights.
The project combines Python, SQL, MySQL, Snowflake, Power BI and DAX to analyze patient populations, hospital performance, operations, financial outcomes and clinical activity.
Project Overview
The healthcare dataset contains 597,774 records across patients, admissions, billing, diagnoses and hospitals. The project follows a complete analytics workflow from raw data preparation to business intelligence dashboards.
Analytics Areas
Patient Analytics
Patient demographics, population trends, admissions and patient-level patterns.
Hospital Performance
Hospital capacity, performance indicators, admissions and operational activity.
Operations
Length of stay, admissions, procedures, ICU activity and operational performance.
Financial Analytics
Healthcare cost, government subsidy and patient out-of-pocket expenditure.
Power BI Dashboards
01 — Healthcare Executive Overview
02 — Patient Population Intelligence
03 — Operations & Financial Intelligence
04 — Clinical Patient Journey
05 — Hospital Performance & Clinical Intelligence
Key Insights
Patient
Analyzed patient population, admissions, readmissions and length of stay.
Clinical
Examined diagnoses, procedures and clinical indicators including Charlson index.
Hospital
Evaluated hospital capacity, beds, admissions and operational performance.
Financial
Compared healthcare costs, subsidies and patient out-of-pocket expenditure.