CityCare Analysis
An end-to-end Power BI analysis of a multi-national hospital trust (4,000 admissions across 8 departments, 36 facilities and 24 countries). The raw data arrived as a single flat file, which I normalised into a star schema. One fact table with dimension tables for departments, facilities and dates, before building the DAX measures behind every KPI: recovery rate, readmission rate, net margin, average length of stay and death rate.
The dashboard spans three pages (Overview, Service Quality, Finance) with synced slicers and a page-navigation rail. Beyond the headline numbers, the analysis surfaced findings that reframed the surface story: Oncology's poor recovery and high death rates are explained by case-mix severity rather than care quality, and a facility-level review revealed the revenue-to-margin gap is volume-driven across satellite sites, not a case of any single loss-making location.
Built with Power Query, a star-schema data model and DAX. Data is synthetic, created for analytical practice.