Coronavirus dashboard - Global pandemic 03-17-2020 08:08 AM - last edited 03-17-2020 08:08 AM

[BILLUMINATE]

This Coronavirus dashboard has new insights & user interactions.

• New measure "Exsiting" = Confirmed - Deaths - Recovered
• Cumulated & daily view
• Percentage of deaths / exisiting / recovered
• Deviation absolute / percent to previous day
• Select date, continent, country & state
• 2 Views: By KPI tiles & country hierarchy with heatmap

My progress is on YouTube, where you can follow or redo the development steps. (language: German *Sorry*)

1. Redone
2. Redesigned
3. Remastered
4. Swiss Lockdown
5. USA new Hotspot

The source is based on the Johns Hopkins Univesity dashboard and dataset on github.

• Johns Hopkins University dashboard 
• GitHub dataset

Have fun with my dashboard. I look forward to your feedback.

Best regards

Nico

eyJrIjoiYjdkZGFjMGEtOGMzZC00ZjAxLTg3ZGItOTVhMzc5NTVmMGQ2IiwidCI6IjdkYzExMmRlLTZhNTItNDA2OS1hN2Q1LWRjNzYzODMzNGMxYyIsImMiOjl9

[czaldumbide]

Great Work!

I was just wondering how were you handling the scheduled refresh? I've noticed that your data only goes up until a few days before the current date. 

Thanks!

[BILLUMINATE]

Hi czaldumbide,

Thanks!

Short answer: I have to transform the data model each day manually.

Long: 

The source is a Web URL API and should refresh automatically. But the datasets are not perfect. I have 2 options.

1. Daily .csv-> new table each day
2. Full time series .csv -> new column each day

I used the full time series because of less tables and joins. For a suitable data model I transformed each table (Confirmed, Deaths, Recovered). With a new columen every day I have to change the transformation steps daily (see attachments).

1. Increase the number of columns
2. Chance the data type to Int64

Maybe I overlook a better solution. Do you have an idea?

Best regards

Nico

*Update 18.04.2020*

Hint from user africat: Remove parameter "Columen=xx" in Data Transformation > Table > Source

[cabc_xlorla]

Hey mate, great work on building this dashboard. I think the colors are suited for the current situation of confirmed case, recovered and very sadly the deaths...

I have a quick question: is the "Drilldown player" a custom visual built from your self?

Again. I liked the distribution and alignment of the visual. Congrats!

[BILLUMINATE]

Hi cabc_xlorla,

the "Drilldown Player" is custom visual from

https://blog.pragmaticworks.com/power-bi-custom-visuals-drilldown-player

Great for the outbreak simulation. But I want dashboard without any third party components (only standard). Maybe I will remove it.

Thanks for your Feedback. I will improve the dashboard in the near future.

Nico