Designed an interactive Hospital Emergency Room Dashboard using Power BI to analyze patient admissions, waiting times, satisfaction scores, and departmental referrals. Built KPIs, DAX measures, and data visuals to deliver actionable insights for healthcare management and improve hospital efficiency.
📊 Hospital Emergency Room Dashboard
🧑💻 Role: Data Analyst (Project)
📅 Timeline: August 2025
🛠 Tools Used: Power BI, MS Excel
🔑 Key Insights Uncovered
- 👥 Patient Demographics: Majority of patients admitted were female (47%), with the highest admissions from the 20–29 age group.
- ⏱ Waiting Time Analysis: Average ER waiting time was 36.3 minutes, with only 62% of patients seen within 30 minutes.
- 😊 Satisfaction Score: Overall patient satisfaction stood at 4.86, highlighting strong service quality despite wait time issues.
- 🏥 Admission Status: About 52% of patients admitted, while 48% were discharged/not admitted.
- 🕒 Peak Hours & Days: Heatmap revealed higher patient inflow during evenings (5–9 PM) and weekdays compared to weekends.
- 🩺 Departmental Load: General Medicine and Cardiology handled the most referrals, pointing to potential areas for resource allocation.
📊 Dashboard Views