Latest Enterprise DNA Initiatives

Power BI Challenge 14 - Emergency Services Analytics from Sam C

Here’s Sam’s entry for Power BI Challenge 14. @sacrow, would you like to share how you built this dashboard and what your inspiration is in building it?

Here’s how Sam described it:

Approach I have taken for this submission is to try and make the submission as flexible as possible for the end user/s for each hospital. So I added a slicer to break each page by hospital, so you can see only key figures for that hospital, but adding in text average comparisons and tooltips where you can get an idea of how other hospitals are doing in selected scenarios.

Page 1 - I focused on Call centre stats, such as volume, hours, age range, avg durations and days of the week.

Page 2 - is focused on the ambulance service. Patients Journey from departure of the ambulance, again a breakdown in hours of the day, to identify peaks and gender and age.

Challenges I found, were coming up with relevant visuals for the measure’s created, so reverted to tables more for this challenge. Ended up using protocol numbers instead of names, but tooltips will identify the name for each P 1, P 2 etc… Time, I only saw this challenge a couple days ago, I’m sure if I had more time, I would probably take a very different approach and maybe something a bit more insightful? I think even though I don’t feel I’m reporting on much, my report feels a bit clunky, might be the fonts I decided to use, If I could redo again, I would try and make everything look a bit smoother maybe?

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.



This post is part of the Enterprise DNA platform improvements. Through these posts, members and non-members can showcase the resources and inspirations on how they come up with their challenge submissions. We hope all members can utilize it efficiently.

Thanks for the review on how you went about this particular submission to the challenge. I can see you’ve put a solid amount of thought into how you were going to represent the information.

And I think you’ve done really well here. I think it’s relatively simple and effective. Insured for any consumer to quickly find the information that is relevant to whatever decision they need to make.

I think maybe for next time you you should look to challenge yourself on the visualisation side. Maybe thinking A little bit more outside the box and testing yourself to tell a story through unique visuals and navigation experiences.

Totally copy other ideas that you’re seeing through resources that we make available and I think you’ll find lots of great ideas to incorporate in the future reports and submissions .


1 Like