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:

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

  1. 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

    Like

  2. 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.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s