🏥 Hospital Emergency Room Dashboard
An interactive Hospital Emergency Room Dashboard built in Microsoft Excel to analyze patient flow, wait times, admission status, satisfaction scores, gender distribution, age groups, and department referrals.
This project transforms raw hospital data into meaningful insights using Pivot Tables, Pivot Charts, KPIs, Slicers, and Data Visualization techniques. datasetlink= Hospital_data_set dashboard link: =Final_Dashboard
📊 Dashboard Features Total Patient Analysis Average Wait Time Tracking Patient Satisfaction Score Admission vs Non-Admission Analysis Gender-wise Patient Distribution Patient Attend Status (On-time vs Delay) Age Group Analysis Department Referral Insights Interactive Year & Month Filters 🛠 Tools & Skills Used Microsoft Excel Pivot Tables & Pivot Charts Data Cleaning & Transformation KPI Dashboard Design Conditional Formatting Interactive Slicers Data Visualization 📈 Key Insights Total Patients: 513 Average Wait Time: 36.32 mins Satisfaction Score: 4.96 Admission Rate: 52.44% Delay Attendance: 62% 🎯 Objective
The goal of this project is to create a user-friendly healthcare analytics dashboard that helps monitor emergency room performance and supports better decision-making through data-driven insights.
🚀 Learning Outcome
Through this project, I improved my skills in:
Dashboard designing Healthcare data analysis Excel reporting automation KPI visualization Interactive reporting
#Excel #DataAnalytics #Dashboard #HealthcareAnalytics #ExcelDashboard #DataVisualization #DataAnalyst