Working with the COVID-19 US Sample Power BI Report

Microsoft has provided a free, downloadable or embeddable, Power BI Report sample using COVID-19 data for the US. This report can be used as is, or customized to leverage the COVID-19 data and report capabilities to compare to your regular business data. 

About the report

You can use the embed code below to embed this report wherever you would like:

<iframe width="1600" height="900" src="https://app.powerbi.com/view?r=eyJrIjoiMmI2ZjExMzItZTcwNy00YmUwLWFlMTAtYTUxYzVjODZmYjA5IiwidCI6ImMxMzZlZWMwLWZlOTItNDVlMC1iZWFlLTQ2OTg0OTczZTIzMiIsImMiOjF9" frameborder="0" allowFullScreen="true"></iframe>

Make note, you may need to adjust the iFrame size.

Or, you can download the PBIX file itself and make your own customizations and bring in your own data here: download the .pbix file (here).

Report Capabilities 

  • Filter by Date
    • Select your data range
  • Filter cases by State
    • Click on the State you would like to select in the left hand chart. 
    • Watch as the visuals filter to that states numbers.
Select-your-state
  • Drill Through to the County View
    • Right click on the left hand visual for the state you would like to select.
    • Drill Through to County View
      drill-through-to-county
    • View the Metrics by County
county-view

Customize the Report

  1. Choose the data you would like to bring in (in my case, we want to view account and sales numbers from Dynamics 365 Sales – I’m not going to walk through all the transformations we made here)
  2. Create your visuals
    Visuals
  3. Save your report
  4. Publish to Power BI Service
    (show in Power BI service)
    power-bi-service
  5. Configure a scheduled refresh for your data sources
  6. Share in Teams or SharePoint to distribute
    (image shared in teams)
    report-in-teams

Author: Bernie Thibeault

What I love most about Dynamics 365 is how it streamlines processes for businesses of all sizes. Every organization is unique, but they all have the same need to get more done in less time. Dynamics 365 is the solution to do that. I'm a skilled listener who knows how to get beneath the surface and hone in on exactly what clients need to get out of Dynamics 365, making him one of the most valuable additions to any team.