March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
03-17-2020 06:22 AM - last edited 03-30-2020 17:24 PM
This Coronavirus dashboard has new insights & user interactions.
My progress is on YouTube, where you can follow or redo the development steps. (language: German *Sorry*)
The source is based on the Johns Hopkins Univesity dashboard and dataset on github.
Have fun with my dashboard. I look forward to your feedback.
Best regards
Nico
eyJrIjoiYjdkZGFjMGEtOGMzZC00ZjAxLTg3ZGItOTVhMzc5NTVmMGQ2IiwidCI6IjdkYzExMmRlLTZhNTItNDA2OS1hN2Q1LWRjNzYzODMzNGMxYyIsImMiOjl9
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!
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.
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).
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
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!
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