COVID-19 tracking sample for US state and local governments
Article
APPLIES TO:
Power BI Desktop
Power BI service
The Power BI team has created a COVID-19 tracking sample that enables US state and local governments to publish or customize an interactive report about COVID-19. The Power BI file contains the data model and interactive graphics in a Power BI template (.pbit) file format you can edit in Power BI Desktop. When you open it in Power BI Desktop, you can analyze and visualize COVID-19 data to keep your community informed at the city, county, state, and national/regional levels. A typical customization is to filter the report to a specific state, and then to create your own publish-to-web embed code to share the report publicly and inform citizens. The article offers different options for using Power BI interactive visualizations in your own public story, blog, or website.
This article covers how to:
Make customizations such as formatting a specific state.
Publish to the Power BI service.
Publish to the web.
Mash up this data with data from another source.
Prerequisites
Before you can get started using Power BI to tell your story, you need these prerequisites:
COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University is provided under a Creative Commons License that requires attribution. Before publishing this data, review the disclaimers.
Download the Power BI template (.pbit) file
To get started, select this link to download the Power BI template (.pbit) file. Power BI report template files contain this information from the report from which they were generated:
Report pages, visuals, and other visual elements.
The data model definition, including the schema, relationships, measures, and other model definition items.
All query definitions, such as queries, query parameters, and other query elements.
Template files don't include the report data, so they're often smaller than Power BI report (.pbix) files.
When you open a template (.pbit) file and save it, Power BI saves it as a report (.pbix) file. From then on, it's like any other Power BI report file. For more information about Power BI template files, see Using report templates.
Update your report
Download the latest version of the free app, Power BI Desktop, if you haven't already.
When the report opens, you're prompted to set the Start Date parameter value. Then select Load to refresh the data. The earliest data is from 3/22/2020.
To filter your report to a specific state, select the arrow to expand the Filters pane.
If you intend to publish the customized report on your website, it's best to configure your scheduled refresh to run at least as frequently as the COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University updates. Since the COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University may refresh their data at different times each day, you may want to configure several refreshes each day.
After you publish your embed code, use the iFrame on the confirmation dialog to embed in your website.
If you make changes to the report in Power BI Desktop, you can publish and replace the existing report in the Power BI service. The embed code doesn't change. It takes approximately an hour for changes to the report or refreshed data to appear on your website.
About the data source for this report
This interactive report aggregates data from the Centers for Disease Control and Prevention (CDC), and state- and local-level public health agencies. County-level data is confirmed by referencing state and local agencies directly (link).
The COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University is licensed under the Creative Commons Attribution 4.0 International (CC BY 4.0) by the Johns Hopkins University on behalf of its Center for Systems Science in Engineering. Copyright Johns Hopkins University 2020. Here are the full Terms of Use. More information is available from the Johns Hopkins University website.
Disclaimers
This report and data are provided "as is", "with all faults", and without warranty of any kind. Microsoft gives no express warranties or guarantees and expressly disclaims all implied warranties, including merchantability, fitness for a particular purpose, and non-infringement.
Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI. (DP-605T00)
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.