🚨 From 9,994 patient visits to actionable insight built an end to end Emergency Operations & Patient Flow Analytics dashboard in Power BI.

3 pages. 11 hospitals (NHS + private). One goal: turn raw ER data into decisions that save time and lives.

🔍 What the data revealed:

→ Treatment is the #1 bottleneck in the patient journey - 74 min avg delay before clinical intervention begins
→ Nuffield Health Woking Hospital has the longest wait (108 min); Sandwell General the highest mortality rate (4.02%) - both flagged for priority staffing support
→ Private hospitals (Spire, Nuffield) run a 1.8x higher staff ratio than NHS trusts, driving stronger efficiency scores
→ Wait time and patient satisfaction are directly linked - the longer the wait, the lower the experience score

🛠️ Built with:
✅ Custom DAX measures for risk scoring, readmission %, and efficiency index
✅ ZoomCharts visuals for interactive drill downs
✅ A 3 page narrative arc: Overview → Patient Journey → Clinical Outcomes.

eyJrIjoiMzIzYjJjYWEtZmRhYi00MmJmLWE1ZjctZGExNzkxNTJkOTY0IiwidCI6IjQ2NTRiNmYxLTBlNDctNDU3OS1hOGExLTAyZmU5ZDk0M2M3YiIsImMiOjl9