Hospital-Emergency-Room-Dashboard-Using-Excel

📊 Project Overview:

This is an interactive Excel dashboard designed to visualize and monitor key metrics of a hospital's emergency room on a monthly basis. The dashboard dynamically updates based on user-selected filters and slicers, allowing real-time exploration of the data.

🎯 Objectives:

• To provide a quick snapshot of emergency room performance.
• To analyze patient demographics such as gender and age.
• To monitor wait times and admission rates for process improvements.
• To evaluate departmental workload and patient distribution.
• To track attendance status and patient satisfaction scores.

✅ Key Performance Indicators (KPIs):

• Total Patients
• Average Wait Time
• Average Satisfaction Score
• Admission Status: Admitted vs. Not Admitted
• Gender Distribution: Male vs. Female
• Attendance Status: On-Time vs. Delayed
• Patient Distribution by Department
• Age Group Segregation

Note: All KPI values automatically update based on slicer selections.

📂 Files Included:

• Final Dashboard.jpg - Screenshot of the dashboard.
• Hospital Emergency Room Dashboard.xlsx - Excel dashboard file (optional, if you plan to upload).

🚀 Getting Started:

To view or interact with the dashboard:

1. Download the Excel file.
2. Open in Microsoft Excel (recommended) for full interactivity.
3. Use slicers to filter by month and year to see dynamic changes in KPIs and visualizations.

🔧 Tools Used:

• Microsoft Excel
• Data visualization techniques (charts, slicers, conditional formatting)
• Interactive dashboard design

📚 Acknowledgements:

This project was created by following the YouTube tutorial by Satish Dhawale on Complete Excel Project with Interactive Dashboard | Resume Project | Step-by-Step Tutorial . Special thanks to the creator for their detailed and educational content.

📬 Contact:

For feedback or collaboration, please contact Aryan Patil at patilavs03@gmail.com .