Hospital Emergency Room Dashboard | Microsoft Excel -
Date
Service
Data Analysis
Client
Personal Project
Project Overview
The Hospital Emergency Room Dashboard is an interactive Microsoft Excel dashboard developed to analyze patient flow, waiting time, patient satisfaction, admission status, and departmental referrals. The project combines Power Query for data preparation, Power Pivot for data modeling, and Excel dashboards to transform raw hospital data into meaningful operational insights.
The dashboard enables hospital administrators to monitor emergency room performance, identify patient trends, and support operational decision-making through interactive reporting.
Business Problem
Hospital Emergency Rooms handle thousands of patients throughout the year, making it difficult to manually track patient volume, waiting times, admissions, referrals, and service quality.
The objective of this project was to build an interactive reporting solution that provides hospital management with a centralized view of emergency room operations, helping them monitor performance and identify opportunities to improve patient care.
Dataset
Industry : Healthcare
Domain : Hospital Emergency Room
File Format: CSV
Analysis Period: 2023 – 2024
Tools Used
Microsoft Excel
Power Query and Power Pivot
Pivot Tables
Pivot Charts and Slicers
Data Modeling
KPI Development
Project Methodology
Imported and prepared the Hospital Emergency Room dataset in Microsoft Excel.
Cleaned and transformed the data using Power Query.
Built a relational data model with Power Pivot.
Developed KPIs using Pivot Tables and calculated metrics.
Designed an interactive dashboard with Pivot Charts, slicers, and KPI cards.
Analyzed patient flow, waiting time, admissions, referrals, and satisfaction to generate business insights.
Dashboard Overview
Designed an end-to-end Hospital Emergency Room Dashboard in Microsoft Excel by combining Power Query, Power Pivot, and interactive visualizations. The dashboard transforms raw healthcare data into actionable insights, enabling stakeholders to track patient trends, operational efficiency, and key performance metrics.
Key Highlights
Insights
The dashboard helps stakeholders understand:
Monthly patient volume trends.
Average waiting time across reporting periods.
Patient satisfaction performance.
Admission versus non-admission distribution.
Patient attendance status.
Gender distribution of patients.
Age group distribution.
Departments receiving the highest referrals.
Recommendations
Based on the analysis:
Monitor waiting time regularly to improve patient experience.
Allocate additional resources during high patient volume periods.
Review departments with the highest referral rates to improve operational efficiency.
Continue monitoring patient satisfaction to identify service improvement opportunities.
Use monthly performance trends for workforce and resource planning.
