The Hospital Emergency Room Dashboard is an end-to-end data analysis and visualization project built in Microsoft Excel using Power Query, Power Pivot, and DAX. The dashboard provides actionable insights into hospital emergency room operations by tracking key performance indicators (KPIs) such as patient volume, average wait times, and satisfaction scores.
This project simulates a real-world hospital analytics scenario, helping healthcare administrators make informed decisions to improve efficiency and patient care.
The goal was to create a data-driven solution for hospital management that:
- Improves efficiency by monitoring critical ER metrics.
- Provides clear, visual insights for stakeholders.
- Identifies patterns and bottlenecks in patient flow.
The dataset contains anonymized records representing hospital ER visits, including:
- Patient demographics (age, gender)
- Admission status (Admitted / Not Admitted)
- Wait times (in minutes)
- Patient satisfaction scores
- Type of service received
- Number of Patients: Tracks total patient visits and identifies busy periods.
- Average Wait Time: Monitors service efficiency and highlights delays.
- Patient Satisfaction Score: Measures service quality over time.
- Admission Status: Analyzes admitted vs. non-admitted patients.
- Demographics: Breaks down patients by age group and gender.
- Specialty Services: Displays service demand by department.
- Microsoft Excel (Dashboard Development)
- Power Query (Data Cleaning & Transformation)
- Power Pivot (Data Modeling)
- DAX (KPI Calculations)
- Charts & Visualizations (Bar, Pie, and Trend Charts)
- Business Requirement Gathering – Defined KPIs and objectives.
- Understanding the Data – Reviewed dataset structure and quality.
- Data Connection – Imported data using Power Query.
- Data Cleaning & Quality Checks – Removed duplicates, handled missing values.
- Calendar Table Creation – Built using Power Query for time-based analysis.
- Data Modeling – Established relationships in Power Pivot.
- DAX Calculations – Created measures for KPIs.
- Dashboard Layout – Designed and formatted visuals for clarity.
- Insights Generation – Derived meaningful trends and recommendations.
- Leveraging Power Query for efficient data transformation.
- Building relational data models in Power Pivot.
- Writing DAX measures to calculate meaningful business metrics.
- Designing user-friendly dashboards to tell a clear data story.
- Download the Excel file from this repository.
- Open it in Excel 2016 or later (Power Query & Power Pivot enabled).
- Use the slicers and filters to explore the data interactively.
This dashboard enables hospital administrators to:
- Reduce average wait times by identifying delay causes.
- Monitor and improve patient satisfaction levels.
- Optimize staffing and resource allocation based on patient trends.
If you want, I can also make this README more visually appealing by adding emojis, badges, and a Table of Contents so it looks highly professional on GitHub and attracts recruiters. That would make your repository stand out.
Do you want me to make that upgraded version?