How akankshapillaii/emergency-room-dashboard works
This repository contains a Power BI emergency-room analytics product. Hospital administrators and operational teams use interactive report pages to inspect patient volume, waiting times, admissions, referrals, demographics, satisfaction, and peak periods. The documented analytical flow is raw CSV data through Power Query cleaning, data modeling, and DAX measures into report views and decision-oriented insights. No source excerpts were available, so relationships reflect only the README’s documented workflow and capabilities.
Components 14
Data Preparation
- ER Visit Data
Hospital ER_Data.csv - Power Query
Hospital Emergency Room Dashboard.pbix - Prepared Data
Hospital Emergency Room Dashboard.pbix
Analytics Model
- Data Model
Hospital Emergency Room Dashboard.pbix - DAX Measures
Hospital Emergency Room Dashboard.pbix - Operational KPIs
Hospital Emergency Room Dashboard.pbix
Report Experience
- Monthly View
Hospital Emergency Room Dashboard.pbix - Consolidated View
Hospital Emergency Room Dashboard.pbix - Patient Details
Hospital Emergency Room Dashboard.pbix - Key Takeaways
Hospital Emergency Room Dashboard.pbix - Interactive Filters
Hospital Emergency Room Dashboard.pbix - Decision Insights
Hospital Emergency Room Dashboard.pbix
Other components
- Hospital Management
- Department Teams
Connections 18
- Hospital Management → Monthly View: reviews performance
- Department Teams → Consolidated View: explores operations
- ER Visit Data → Power Query: loads data
- Power Query → Prepared Data: cleans data
- Prepared Data → Data Model: builds model
- Data Model → DAX Measures: supports measures
- DAX Measures → Operational KPIs: calculates KPIs
- Operational KPIs → Monthly View: drives metrics
- Operational KPIs → Consolidated View: drives metrics
- Data Model → Patient Details: supplies details
- Data Model → Interactive Filters: enables filtering
- Interactive Filters → Monthly View: filters view
- Interactive Filters → Consolidated View: filters view
- Interactive Filters → Patient Details: filters details
- Monthly View → Decision Insights: reveals trends
- Consolidated View → Decision Insights: reveals patterns
- Patient Details → Decision Insights: supports analysis
- Decision Insights → Key Takeaways: summarizes findings