Problem? Emergency departments experienced long wait times and inefficiencies, reducing patient satisfaction and straining hospital resources.

Steps taken: Developed a Power BI dashboard using historical ER data, modeled with a star schema; implemented DAX-based KPIs (e.g., Avg Wait Time, Satisfaction Score), enabled drill-downs and predictive volume trends (24/48/72 hrs), and applied row-level security for department-level insights.

Result! Achieved a 25% reduction in average wait times, identified peak bottlenecks by department, and improved satisfaction tracking with real-time metrics—empowering staff to make faster, data-informed operational decisions.