Hospital ER Report #RWFD 11-11-2024 02:13 AM

[hewanz00]

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]

Can you please share the DAX daily calculation for patients, I've try to match your data but with no sucssess.
Thanks,

Ed Dror

[KotKot]

Hi can you please the PBIx file thanks

[Oded-Dror]

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

[hewanz00]

Just messaged!

[MattBrownEnviva]

Hey, Hewanz00. What are the visuals used here in this combo for the KPIs? 

Is this an area chart combined with a dynamic textbox?

[hewanz00]

Hi Matt,

Yup pretty much - I used area charts, with cards for the text values 🙂 

[Oded-Dror]

There is no data?

[hewanz00]

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