Back to Gallery
Power BICapstone Project
Hospital ER Patient Flow & Wait-Time Dashboard
AT
BUILT BYAamna Tariq
BEFOREMedical Graduate
→
OUTCOMEHealthcare Analyst at Shaukat Khanum
Status: Live DeployedInteractive Live Demo (Sandbox)→
Project Overview
A Power BI dashboard tracking patient triage times, ER occupancy bottlenecks, and discharge delays.
Data Scrubbing & Cleaning Pipeline
The student imported raw messy CSV database backups, scrubbed redundant column entries, normalized data structures, handled duplicate records, and configured relationship models using SQL schemas and Power BI.
Analytical Insights Generated
Configured cohort retention models, isolated regional operational leakages, tracked active customer churn risk, and mapped average revenue metrics across locations.
Project Specs
CORE TOOLPower BI
DATA ROWS PROCESSED500,000+ Records
TIME TO BUILD3 Weeks
COMPLEXITY LEVELHiring Grade