COVID-19 Daily Updates Report Development Walkthrough

PAUL TURLEY (Pragmatic Works) – COVID-19 Daily Updates Report Development Walkthrough

Paul, with the help of members of the Microsoft MVP program and his colleagues from Pragmatic Works, has developed a public Power BI report to monitor the COVID-19 pandemic. The report contains daily updates from the Center for Disease Control (CDC) using data curated by the Johns Hopkins University Center for Systems Science & Engineering. 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.

Check out the COVID-19 Daily Updates report by clicking here

Paul will demonstrate the different stages of their project:

  • Source data from Johns Hopkins University & the CDC
  • Some of the complexities & challenges encountered consuming & refreshing the dataset
  • Initial Power BI dataset & report published to the web
  • Project in GitHub to which the community are contributing
  • Template app published through the community partner program
  • How to install the app from AppSource

Read Paul’s bio and more about report development steps on his blog (and don’t forget to subscribe!): https://sqlserverbi.blog/

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.