Emergency rooms are the backbone of healthcare, but long wait times and overcrowding can impact patient care. This interactive ER dashboard dives deep into patient admissions, wait times, peak hours, referrals, and satisfaction scores to uncover critical insights that can help hospitals optimize efficiency and improve patient outcomes.
🔹 Total Patients Analyzed: 9,216 (Apr 2023 - Oct 2024) 🔹 ⏳ Average Wait Time: 35.3 minutes – highlighting potential delays 🔹 😊 Patient Satisfaction Score: 4.99/10 – room for improvement! 🔹 🏥 Admission Rate: 50.04% admitted vs. 49.96% not admitted 🔹 📅 Busiest Days: Monday (1,377 patients), Saturday (1,322), and Tuesday (1,318) 🔹 ⏰ Peak Hours: 11 AM, 7 PM, 1 PM, and 11 PM – crucial times for resource allocation 🔹 🔄 Top Referrals: General Practice (1,840 cases), Orthopedics (995 cases)
This dashboard empowers hospital administrators and ER managers with actionable insights to: ✅ Reduce patient wait times ✅ Optimize staff scheduling during peak hours ✅ Improve overall patient satisfaction and hospital efficiency
This project showcases data visualization, trend analysis, and decision-making insights, making it a great addition to any data analyst portfolio.
