03-17-2020 08:08 AM - last edited 03-17-2020 08:08 AM
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.
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.
Short answer: I have to transform the data model each day manually.
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?
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!
the "Drilldown Player" is custom visual from
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.