All work
03 / HEALTHCARE ANALYTICS

Understanding the emergency room experience.

A Power BI report exploring emergency room visits, patient wait times, satisfaction, and department referrals.

01 / THE QUESTION

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.

02 / THE APPROACH
01

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.

02

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.

03

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.

03 / THE OUTCOME

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.

THE TAKEAWAY

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.

KEEP EXPLORING

AWS Data Engineering Pipeline