Here’s Mehdi’s entry for Power BI Challenge 14. @MehdiH, would you like to share how you built this dashboard and what your inspiration is in building it?
Using PowerPoint to design the aspect (background, titles, visuals placeholders) of each page of the report
Using Power BI to implement the report from getting to visualizing the data).
Adjust report aspect and content if needed
For this project
I started by opening a new OneNote page where I first just past contents from the post that introduced the challenge (The brief, the process, the food for thought and the conclusion).
I added comments and notes to better understand the steps of the process, the definitions, and the needs.
I opened the data source in Excel and started to understand and analyze the data. Then, I switched to Power BI. I shaped the data, added the relationship, and created some basics visuals to check if everything works fine.
After that, I added ideas about the direction that I want the report takes like the pages it is interesting to add, the measures and insight it could be useful to explore.
I then started to design the report elements like the logo, the backgrounds and icons using PowerPoint.
And finally, I build the report.
Where I get my inspiration?
If I must answer this question in one sentence, I will say “from over the world Power BI’s community”.
As examples, and for this report, I was inspired by Leonardo Kapra to design the aspect of the report especially saving the images in “.svg” format rather than “.png”. But also, from the best practices that I learned from the “Mastering Report Development Start to Finish” eDNA course.
To get the Top 3 Stations and Top 3 Hospitals, I was inspired by Sam’s article “A Deeper Understanding of Advanced RANKX” in eDNA forum.
To highlight the min and max in the tables, I used a technique I learned from Alberto Ferrari “Highlighting the minimum and maximum values in a Power BI matrix”.
To create the “time table”, I used and adapted a script provided on Github by Prett Powell.
And I discovered the “Force-Directed Chart” in the “Document Model” external tool from “Data-Marc”
This is it, hoping it will help and inspire
Best Regards
Mehdi
Brilliant report that you’ve created here. The first thing that comes to mind is how comprehensive it is and it really covers off every insight that I think is important from the data that we were presented in this challenge.
I also like some of the incredibly innovative visualisation‘s and storytelling visuals you’ve created and used. Whilst some look a tad busy I think that the variety that you’re showing in ways that you can showcase these important insights is great .
Maybe for next time you may want to think about consolidating some of these pages. Attempting to tell more with less. Sometimes you can use different filtering mechanisms and navigation experiences with bookmarks to tell the same story and a more condensed and optimised way. Something to try out next time.
Congrats on getting involved and well done on your submission.