Project 2 – Emergency Room (ER) Patient Data Analysis

📌 Topics Covered

• Cleaning and preprocessing hospital ER data
• Analyzing patient visits, waiting times, and admission trends
• Pivot Tables and Pivot Charts for summarization
• Tracking KPIs such as patient count and average waiting time
• Designing interactive ER dashboards

📝 Project Summary
In this project, you will create a structured, interactive Excel dashboard to monitor emergency room operations. By analyzing patient flow, waiting times, and admissions, the dashboard enables data-driven decision-making for hospital management, helping to identify bottlenecks and improve operational efficiency.

✅ What You Will Learn

• Clean and organize emergency room data
• Analyze patient visits, waiting time, and admission status
• Use Pivot Tables and Charts to summarize hospital data
• Track critical KPIs for healthcare management
• Generate insights to improve ER efficiency

Note to Students –

Live Classes will held on Google Meet.
Mentor will provide files, dataset in the Google Clasroom.
Class video will be provided on Google Classroom.

Click “Mark as Complete” button.

Good Luck.