Hospital Network Analytics · Power BI · DAX · SQL
Healthcare Operations & Finance
Overview
An end-to-end analytics solution for a network of medical facilities covering 2019–2024. Three interactive pages consolidate clinical outcomes, patient demographics, billing records and admission details into a single decision-making toolkit for hospital leadership.
Key Metrics
Methodology
Data Preparation
Standardised all source tables, removed duplicates, checked for nulls and irrelevant columns, and created a calculated date column linked to the primary table.
Analytical Approach
Descriptive and diagnostic analytics using DAX. Trend analysis, demographic segmentation and admission-type breakdowns were layered to enable root-cause investigation.
Visual Design
Monochromatic purple theme with KPI cards, bar and donut charts, trend lines and detailed tabular views, optimised for executive and clinical audiences simultaneously.
Key Findings
- 1
Hypertension, Diabetes and Obesity are the three largest cost centres at ~$350M each; chronic disease management is the single biggest financial lever.
- 2
Revenue growth of 20% is entirely volume-driven, not price-driven. Average cost per patient remained flat, masking potential under-billing.
- 3
Patient demand peaks July through August and dips in February; staffing and bed allocation should mirror this seasonal pattern.
- 4
Houston Methodist leads significantly in both volume (20,402 patients) and billing ($520M), and its operational model is worth replicating network-wide.
- 5
31,000 of 55,500 patients had abnormal test results, a 56% rate that warrants a review of care protocols and follow-up pathways.
- 6
Admission types (Elective, Emergency, Urgent) are evenly distributed at roughly 33% each, suggesting balanced demand that supports capacity planning.
Recommendations
Invest in chronic disease management programmes for Hypertension, Diabetes and Obesity; prevention is cheaper than acute care.
Scale summer staffing and bed capacity before July peaks; avoid under-resourcing a predictable demand surge.
Investigate and standardise billing practices across hospitals. Flat average cost despite volume growth suggests pricing inconsistency.
Replicate Houston Methodist's operational model across lower-performing network hospitals.
Implement structured follow-up protocols for the 31,000 patients with abnormal results. This is both a clinical and financial priority.
Live dashboard
Open in Power BI