New Coronavirus (COVID-19) Daily Updates Report

Updated again on April 7 2020. See video tutorial below

After publishing the original daily COVID-19 cases report on March 14, Johns Hopkins University changed the file format. This required us to publish an updated dataset with a new report, which you can access >here<.

Since the original solution was posted, I have received a tremendous amount of feedback, suggestions for enhancements and corrections. I introduced the tool in the earlier post. Members of the Microsoft MVP program have been a lot of help and several of my colleagues from Pragmatic Works have jumped in to add their insights and design support. We’re working on a Power BI app template that can installed into a Power BI tenant. In the interim, you can access the publicly accessible report through this link.

Using the report, we can track the daily progression of confirmed cases, recovered cases and deaths by country. Where available, these metrics are also available state or province and US counties.

The current project and future updates can be accessed using this GitHub repo.

There are now three different ways to access the COVID-19 Daily Updates Power BI dataset & report:

9 thoughts on “New Coronavirus (COVID-19) Daily Updates Report

  1. Hi Paul,

    I just installed the Covid-19 Global Daily Updates app version 15. I connected mydata using Anonymous/Public for both prompts but I’m not getting any data. Some of the dashboard tiles appear to have data through May 13 but the reports seem to have no data.

    What could I be doing wrong?

    Thanks,
    Mike

    • Hi Paul,

      More information. Disregard the previous post. It does not occur consistently.

      After uninstalling and re-installing and selecting connect my data and selecting Anonymous/Public I continue to see the prompt of, “You’re viewing this app with sample data. Connect your data” in a pinkish banner at the top of the pages. Even after selecting Anonymous/Public during the install, the fields return to Anonymous/None every time I click “Connect your data” and change it to Anonymous/Public even though I get the confirmation pop-up indicating “Refreshing data”. The only place “Public” is retained is under Datasource / Settings / Data source credentials.

      In all cases I’m not getting any data.

      Any thoughts?

  2. Paul, looking forward to your presentation tomorrow. Not sure if you’re aware, but there’s a free, granular version of the John Hopkins data set which is automatically updated daily available on Snowflake’s Data Exchange. Thought it might save you some time prepping/refreshing the data behind your amazing dashboard: https://www.businesswire.com/news/home/20200325005087/en/Starschema-Brings-Single-Source-Truth-COVID-19-Incidence

  3. Hi Paul, Would you mind commenting on the underlying data model as curious to know the reasoning why its predominantely a snowflake schema with bidirectional relationships … as opposed to a star schema. Thanks.

Leave a Reply