Hospital ER Report #RWFD

Question

This Power BI dashboard provides an overview of daily and weekly metrics using the Hospital ER dataset from the Real World Fake Data series. The Daily Metrics section displays individual patient flow and ER activity data, helping to identify trends and high-traffic days. The Weekly Metrics panel features a rolling 7-day view, allowing users to analyze week-over-week changes in admissions, patient information, and patient satisfaction. This report is designed to support emergency department management by highlighting trends in ER visits and demand patterns over time.

The data can be found here!

eyJrIjoiZmI0MzE4MjQtMTE0Mi00MjZkLTkzYWMtNjQ5MGM4Y2U5YTk0IiwidCI6ImNlZjk5OTUzLWM0OTYtNGE4MS1iMDYxLTNlYmU1ODRjY2ZjYyIsImMiOjh9&pageName=b8668014888b20c194e7

oded-dror · Answer

There is no data?

hewanz00 · Answer

Thanks for letting me know - the link's been editied

mattbrownenviva · Answer

Hey, Hewanz00. What are the visuals used here in this combo for the KPIs?&nbsp;Is this an area chart combined with a dynamic textbox?

oded-dror · Answer

Which period you referring to?&nbsp;Can you share your calc for one of your daily and weekly please I've try to mimic that but I coulden't&nbsp;

hewanz00 · Answer

Hi Matt,Yup pretty much - I used area charts, with cards for the text values 🙂&nbsp;