Healthcare & Clinical Operations Analytics Dashboard

Business Problem: Hospital executives needed to monitor financial health (revenue vs. margins), admission velocities, and demographic distributions to manage clinical capacity. Tools Used: Power BI, Data Modeling, Relational Star Schema (Fact_Patient_Visit, Dim_Patient, Dim_Hospital) KPIs Tracked: Total Patients (1K), Total Cost ($28M), Total Revenue ($44M), Net Profit ($16M), Average Length of Stay (5.71 days). Insights Discovered: Department Profitability: The Diagnostics and Cardiology departments function as the primary revenue engines for the medical system. Age & Gender Dynamics: Female patients account for the majority slice of admissions (53.3%), with the 18–30 age bracket representing the highest volume segment (29.67%). Facility Ranking: Max Hospital leads the healthcare network's financial footprint, generating $9.1M in revenue.