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:
- Use this link to view the report published using Power BI “publish to web”
- Add the complete COVID-19 app to your Power BI tenant from Microsoft AppSource (see instructions below)
- Download the .PBIX file from this GitHub repository and make your own enhancements
