Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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