Latest Enterprise DNA Initiatives

Power BI Challenge 11 - Covid 19 Reporting from Timothy

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

image

image

Here’s how Timothy described it:

Data
Given that the count in the original data set is just the cumulative amounts for a given day, I created 4 additional calculated columns in the Covid Data table. I opted to go with calculated columns instead of measures as I just found it quicker this time and the data set was relatively small. The columns were:

“Previous Day Count” – this was used to get the value from the previous day which would then allow me to calculate what the daily count was. I added variables to take both the category (Confirmed, Death, Recovered) as well as location.

“Daily Count” – this would just be the amount in the original Value column (provided with the dataset) minus the previous day count above.

I then added two more columns to find out what the daily change was from the previous day as well as the percentage change. I was hoping to use this information to track the % change over time – but ended up running out of time. I’m hoping someone else did something around this.

Key Measures
There is nothing fancy here. Mainly the daily counts for each category and then 7 day moving averages. I also created Top 10 countries for both confirmed cases and deaths.

Visuals
Very standard visuals here. I did use the ArcGIS map visual but found that with this as well as the standard Microsoft map that the bubbles representing size aren’t very good at representing the actual amount. A small bubble could be 20 cases or 20,000 cases and they look to be the same size. So overall, I didn’t find this very effective. I am going to review others who used maps to see what you all did.

A new visual that I have never used before is the one for the top 10 countries for confirmed cases/deaths. I used the Infographic Designer visual (available from the custom visual location) – and then used people as the icon. I thought this would be the most relevant to display the number of cases.

Credit for the icon

Icons made by Freepik from www.flaticon.com

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

power-bi-chal-1

1 Like

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.

1 Like

@tweinzapfel,

I really like the look of this report, and both you and @datazoe did something important with your reports that has really stuck with me as I went through all the entries in detail this weekend. In working through this challenge, I found myself getting so immersed in the data modeling and analytical issues that at times I lost sight of the fact that this is not hypothetical sales data or IT help desk tickets, but that each and every data point represents the death or illness of an actual person. Your creative use of Infographic Designer and @datazoe’s “mourners multiplier” parameter drove that point home in different but equally effective ways. I think sometimes Infographic Designer can be used to create what Edward Tufte refers to as “chartjunk”, but judicious use of it can really effectively convey important context, which I think you’ve done here. Well done.

  • Brian

@BrianJ - thanks for the great feedback!

@tweinzapfel,

A couple of other comments I meant to include in my earlier message:

  1. I totally agree with your decision to emphasize confirmed and deaths. The recovered field is a wonky mess, and I don’t even know how to interpret it (i.e., is high recovered a bad outcome because it means you have a lot of cases, or a good outcome because it means you may have kept a sizable number of confirmed from becoming deaths?)

  2. for your confirmed and deaths visuals, I would recommend using the red for deaths and a different color for confirmed. The current mixing of colors for both doesn’t lend itself to the “at a glance” interpretation that your dashboard is otherwise set up so well to provide.

  • Brian