Understanding the emergency room experience.
A Power BI report exploring emergency room visits, patient wait times, satisfaction, and department referrals.
What shapes the emergency room experience?
Patient volume alone gives an incomplete view of emergency room activity. Wait times, satisfaction, referral patterns, and the mix of patient groups add context to the visit experience.
Bring visit trends and patient-experience measures into one report, with views by age, race, gender, department, and time.
Organize visits for comparison
Modeled patient visit data with a date table, age buckets, and life-stage groups. Organized reporting by month, year, weekday versus weekend, and time of day.
Define the measures in DAX
Created measures for total visit records, average wait time, average satisfaction, referral shares, and gender distribution. Calculated the share of visits without a satisfaction rating separately from the average score.
Connect trends and patient experience
Built monthly and yearly visit trends, department-referral and age-group charts, and a matrix by race and age bucket. A field parameter lets the matrix switch between wait time and satisfaction.
What the work delivers.
A Power BI report and reusable report template that bring emergency room activity, patient experience, and referral patterns into a single analytical view.
An average satisfaction score needs context: showing the share of unrated visits makes the coverage of patient feedback visible alongside the score.
Project scopeA portfolio reporting project. The overview describes the supplied Power BI report and template; it does not claim a reduction in wait times or improved clinical outcomes. The visual summarizes the report’s focus areas.