Map COVID-19 cases

In this lesson, you'll create visualizations that show COVID-19 case rates, total cases, and total deaths by country, as well as indicators for numbers of cases and deaths worldwide. You'll also style your maps to ensure that you communicate key information.

Import a workbook

First, you'll download a workbook that contains data from the ECDC and a layer of country boundaries from ArcGIS Living Atlas of the World. Then, you'll sign in to ArcGIS Insights and import the workbook.

  1. Go to the COVID-19 Analysis Workbook item in ArcGIS Online and click Download.

    A zipped file that contains the workbook is downloaded.

  2. Browse to the downloaded file and extract its contents to a location on your computer you can easily access.

    The extracted Insights workbook package has the .insightswbk extension. Next, you'll import the workbook into ArcGIS Insights.

    Note:

    The ECDC data used in the workbook was accessed on August 29, 2020. You can download more recent data from the ECDC website, but the August 29 data will be used for the purposes of this lesson.

  3. Go to ArcGIS Insights and click Sign in. Sign in using your ArcGIS organizational account licensed for ArcGIS Insights.
    Note:

    To access Insights in ArcGIS Online, your ArcGIS organization's administrator must grant you a license for it. If your organization does not have Insights licenses, you can sign up for a free trial.

    If this is your first time signing in to your Insights account, the Welcome to Insights window appears.

  4. If necessary, in the Welcome to Insights window, click Skip.

    The Insights home page appears. In Insights, you work in a workbook. Workbooks contain connections to your datasets and cards with maps, charts, or other data. You'll import the workbook you downloaded.

  5. Click the Workbooks tab.

    Workbooks tab

    The Workbooks page contains workbooks associated with your account and your organization.

  6. Click Import.

    Import button

  7. Browse to and double-click the covid-19-analysis workbook package you downloaded.

    The workbook is added to the list of workbooks.

  8. Click the name of the Global COVID-19 analysis workbook.

    The workbook opens. It contains two datasets, located in the data pane. The first is COVID-19-geographic-distributi.Table, which contains daily COVID-19 cases by country. The second is country_gen_trim, a layer from ArcGIS Living Atlas of the World that contains generalized country boundaries.

    The names of the datasets aren't self-explanatory, so you'll rename them.

  9. In the data pane, point to COVID-19-geographic-distributi.Table and click the Rename dataset button.

    Rename dataset button

    The dataset name becomes editable.

  10. Change the name to COVID-19 cases by country and press Enter.
  11. Change the name of the country_gen_trim layer to Country boundaries.

Visualize COVID-19 case distribution

The workbook contains datasets, but no maps or charts to visualize the data. You'll create two maps, one that shows the case rate per 100,000 people for each country and one that shows the total confirmed cases and deaths for each country. These maps will provide information as to where cases are concentrated around the world.

  1. In the data pane, click the arrow next to the COVID-19 cases by country dataset.

    Arrow to expand the COVID-19 cases by country dataset

    The dataset is expanded, revealing its attribute fields. The fields include the date the cases were reported (dateRep), the number of cases, the number of deaths, and the name of the country or territory, among other relevant information. In this dataset, the cases field contains the number of new confirmed cases for each date, not the total number of confirmed cases.

    The symbols next to each field name indicate the field type. The fields in this dataset have field types of date/time, string (text), or numbers. To map the data, you need to add a field with a location field type. Using the countryterritoryCode field, you'll join this dataset to the Country boundaries dataset to add a location field based on the location of the country boundaries.

  2. For the COVID-19 cases by country dataset, click the Dataset options button and choose Enable Location.

    Enable Location option in the Dataset options pane

    The Enable location pane appears. The default method to add a location field is to use coordinates, but your dataset doesn't have coordinate data. You'll instead add a location field based on geography. This method joins your dataset to a location field in a different dataset.

    To create a join between two datasets, at least one field that is common to both datasets must exist. In this case, both datasets include fields that contain a three-digit country code.

  3. For Location Type, choose Geography.
  4. For Location Fields, click Choose a field and choose countryterritoryCode. For Matching Geography Level, choose Country boundaries.

    Parameters for the Enable location pane

    Estimated Match Accuracy shows whether there is a match between the two datasets. In this case, the bar is close to Best, indicating that there is a good match.

  5. Click Run.

    A location field, Country boundaries, is added to the COVID-19 cases by country dataset. You can use this field to add the dataset to a map.

    Before you map the data, you'll set the display field. The display field appears in pop-ups on the map, so you want it to include useful information for your users. You'll set it to show the country name.

  6. In the data pane, point to the Country boundaries field and click the Display field button. In the Choose Display Field pane, choose Name.

    Choose Display Field pane

    Now, the country name displays in the pop-ups for any map you create.

    You'll first create a map that shows the COVID-19 case rate per 100,000 people in each country. This map normalizes the total number of cases by population and is useful for showing where COVID-19 is having a greater effect on the population as a whole.

    Your dataset doesn't include a field that shows the number of cases per 100,000 people, but it does include fields for the number of cases and the total population of each country. Using these fields, you'll calculate the field you want.

  7. For the COVID-19 cases by country dataset, click the Dataset options button and choose View data table.

    View data table option

    The COVID-19 cases by country table appears. It contains all of the data in the dataset, organized by fields. You'll add a field to the table and calculate it to show the case rate per 100,000 people.

  8. In the table window, click + Field.

    Add Field button

    A field is added to the end of the table. The field has a default name and no data.

  9. Click the new field name to make it editable. Change the name to Case rate per 100k and press Enter.

    Next, you'll calculate the field by dividing total cases by total population and multiplying the result by 100,000.

  10. In the Enter calculate function text box, type (cases/popData2019)*100000.

    Enter calculate function text box

  11. Click Run.

    The field is calculated.

  12. Close the table.

    By default, the new field type is a number. You'll change the field type to indicate that the value is a rate.

  13. In the data pane, next to the Case rate per 100k field, click the field type button and choose Rate/Ratio.

    Rate/Ratio field type

    The field type changes. Next, you'll create a map that shows the field.

  14. Drag the Case rate per 100k field onto the page and onto the Map drop zone.

    Map drop zone

    A map card appears. It displays the countries of the world styled based on the number of COVID-19 cases per 100,000 people. By default, darker colors have a higher normalized case rate. The default size of the map card is too small to show all countries, so you'll resize the card.

  15. Drag the handle on the right side of the map card until the entire world map is visible.

    Map card resized

    You'll make a second map showing the total number of COVID-19 cases and deaths per country. Your dataset contains fields for this information, so you don't need to create a new field.

  16. In the data pane, drag the cases field onto the page to the right of the map card and onto the Map drop zone.

    Another map card appears. It displays the number of cases by country. Its default style is different from the first map card, using point symbols that increase in size to represent more cases. When showing counts instead of rates, this style is more appropriate.

  17. Resize the second map card to be the same size as the first.

    You also want to add deaths to the second map card. If you try to add the deaths field to the map the same way you added the cases field, you'll only update the map's style instead of adding a second layer. To add a second layer to the map, you'll select both a location field and the deaths field.

  18. Press Ctrl and click the Country boundaries field and the deaths field to select both fields. Drag the fields onto the second map card and onto the Add new layer drop zone.

    Add new layer drop zone

    A second layer, Sum of deaths, is added to the map card.

    Map showing COVID-19 cases and deaths by country

    Every country on the map now has two point symbols, a gray symbol representing deaths and an orange symbol representing cases. (In some countries, the symbols may be sized similarly, so you can't see both at the same time.)

    Your two maps show different aspects of the same data and help give a more complete understanding of the COVID-19 pandemic. The total values and the case rates are important to understand on their own, but using them together provides even more insight. For example, some countries with a large population may have a high case count, but a relatively small case rate, whereas smaller countries may have a small case count and a high case rate.

    It would be helpful to synchronize the maps so they use the same extent when you zoom and pan.

  19. On the toolbar of the second map card, click the Sync extents button.

    Sync extents button

    The extents are synced. Now, when you navigate one map, the other map navigates to the same location.

  20. On the ribbon, click the Save button.

    Save button

    The workbook is saved.

Style the case rate map

The style of your maps and data is essential to communicating information effectively. For instance, in your second map, it's not possible to see the cases and deaths for every country because the symbols overlap. You'll update the styles of both maps using cartographic principles.

First, you'll change the basemap to one with less detail and minimal colors. This basemap will make your data stand out on the map. Then, you'll change the style for the case rate map.

  1. Click an empty space on the page to deactivate all cards.
    Note:

    When a card is inactive, the name of the card remains visible (for instance, Card 1).

  2. On the ribbon, click the Basemaps button and choose Light Gray Canvas.

    Light Gray Canvas basemap option

    The basemaps update for both maps.

    Next, you'll change the style of your first map, which shows the number of cases per 100,000 people. The current style divides countries into five groups and gives them a darker symbol if their case rates are higher. You'll change how the groups are classified and choose a different color scheme.

  3. On Card 1, click the arrow next to the Sum of Case rate per 100k layer.

    Arrow next to layer name

    The Layer options pane appears. The default tab shows the legend.

  4. Click the Options tab. Click Classification to expand the classification options.

    Classification options

    By default, the data is classified using the Natural Breaks method with five classes. The Natural Breaks classification method identifies clusters of similar values in the data and inserts class breaks between the clusters.

    In the Layer options pane, the histogram chart shows how your data is distributed and where the breaks are located. The dashed line indicates the global average. Most of the case rates around the world are relatively low, but there are some extreme outliers compared to the average. To better show these outliers, you'll change the classification type to Standard Deviation, which classifies each country's case rate based on how far away it is from the average.

  5. For Classification type, choose Standard Deviation.

    The map and the histogram chart update. Now, the class breaks are set at intervals of one standard deviation. In statistical analysis, a distance of two standard deviations from the average is generally considered significant.

  6. In the Layer options pane, click the Style tab. For Color palette, choose the white to blue palette.

    White to blue palette

    You'll also adjust some of the other style parameters to ensure that the data is displayed clearly.

  7. Change Outline thickness to 0.5 px.
  8. Change Outline color to the gray color in the second column, third row (#5C5C5C).

    Gray color in the second column, third row

  9. Change Layer transparency to 10 percent.

    Parameters on the Style tab

    The changes are automatically applied to the map.

    First map with style changes applied

    The gray outline makes it easier to see the boundaries between countries. With the Standard Deviation classification style, there is more distinction between outliers in the dataset, with only the most significant outliers being styled with the darkest colors.

    You'll add a legend to the page so users can see which values correspond to which symbols.

  10. In the Layer options pane, click the Legend tab. Click the Pop out legend button.

    Pop out legend button

    The legend is added to the map.

  11. Close the Layer options pane. Drag the legend under the map.

    You'll change the legend's size and appearance later in the lesson.

  12. Save the workbook.

Style the cases and deaths map

The map of case rates is complete. Next, you'll change the style for the map of cases and deaths.

Currently, the map is styled so that the symbols for cases and deaths vary in size. You'll keep this symbol style but change parameters such as the classification type and size of the symbols. First, you'll change the symbols for cases. You'll turn off the layer for deaths so you can focus on the layer for cases.

  1. Click the Sum of deaths button to turn it off.

    Sum of deaths button

    The Sum of deaths layer is turned off and only the Sum of cases layer is shown on the map.

  2. Click the Sum of cases arrow.

    The Layer options pane appears.

  3. Click the Options tab. Expand Classification.

    Like the map of case rates, the default classification type is Natural Breaks with five classes. The histogram chart indicates that the data is skewed toward lower values, but with a small number of significant outliers.

    You'll change the classification type to unclassed. This type scales symbol size on a continuous scale, instead of dividing the data into a certain number of discrete classes. A continuous scale will emphasize the highest values on the map. It'll also make it more efficient to update the map with more recent COVID-19 data, because you won't need to adjust the classification as the data changes.

  4. For Classification type, choose Unclassed.

    Unclassed classification type

    The symbols on the map change. Countries with a large number of total cases, such as the United States, Brazil, and India, stand out compared to the large number of countries with relatively few cases. However, it can be difficult to interpret the symbols in some areas where many smaller countries are located close together. You'll update the symbol size, fill color, and transparency so that users can differentiate the symbols.

  5. Click the Style tab. For Size (min - max), change the maximum size to 44 px.

    Maximum size changed to 44 px

    This size is the largest symbol size that legends in ArcGIS Insights can show to scale.

  6. For Fill color, replace the hex code with #00A9E6 and change Transparency to 93 percent.

    Fill color set to #00A9E6

    When you have many symbols close together, increasing transparency is a good way to make sure all of the symbols appear. You'll increase the outline thickness and change its color to match the fill color.

  7. Change Outline thickness to 1.3 px. For Outline color, replace the hex code with #00A9E6.

    Outline thickness and color parameters

    The map updates. Because you didn't increase the outline transparency, the outline color is darker than the fill color.

    Second map with style changes applied

    As with the first map, you'll pop out the legend.

  8. Click the Legend tab and click Pop out legend. Close the Layer options pane and move the legend to the right of the map.

    Next, you'll update the style for the layer of deaths.

  9. On the map card, click the Sum of deaths button to turn the layer on and click the arrow to open the Layer options pane.
  10. On the Options tab, expand Classification. Change Classification type to Unclassed.

    Classification type for deaths

    You'll also change the size and color of the deaths so that they appear distinctly compared to cases. Because there are fewer deaths than cases, you'll make the symbols for deaths smaller.

  11. On the Style tab, change the following parameters:
    • For Size (min - max), change the minimum size to 1 px and the maximum size to 10 px.
    • For Fill color, change the color to #FF5500 and Transparency to 80 percent.
    • For Outline thickness, change the value to 1.5 px.
    • For Outline color, change the color to #FF5500.

    Style parameters for deaths

    Next, you'll pop out the legend for deaths.

  12. Click the Legend tab and click the Pop out legend button. Move the legend below the Sum of cases legend and close the Layer options pane.

    You now have three legends on your page, one for the first map and two for the second. You can rearrange the legends.

  13. Move and resize the three legends to reduce empty space.
    Tip:

    To resize a card, click the card to select it and drag its handles.

    The example image shows a possible page layout with maps and legends. Your layout may look a little different.

    Example page layout with map cards and legends

    Finally, you'll check the pop-ups. You already configured the display field, so the pop-ups will show the name of each country.

  14. On the map of cases and deaths, point to some of the symbols.

    Pop-up showing sum of deaths

    The pop-ups show the number of deaths for each country, as well as statistics such as the minimum, maximum, and average number of deaths globally. It would be more useful to show the number of cases in the pop-up, instead of the number of deaths. You'll reorder the layers so that cases are displayed first.

  15. In the list of layers, drag the Sum of cases layer above the Sum of deaths layer.

    Sum of cases dragged above Sum of deaths

    The layers are reordered.

  16. Point to the symbols on the map.

    Now, the pop-ups display the sum of cases for each country.

  17. Save the workbook.

Create tables and charts

Now that the maps are complete, you'll add tables and charts to supplement the spatial information. First, you'll create a table summarizing the data from each country and region.

  1. In the data pane, press Ctrl and click the countriesAndTerritories, cases, Case rate per 100k, and deaths fields in the order listed.

    When selecting multiple fields to create a table, the order in which you select the fields determines the order in which the fields are displayed in the table.

  2. Drag the selected fields to a blank area of the page under the maps and onto the Table drop zone.

    Table drop zone

    A table is created. Its default size is too small to display all four fields.

  3. On the table, drag the handles to expand the card until you can see all four fields.

    The table displays the values for each field for each country and territory. By default, the table is sorted alphabetically by the name of the country or territory. You'll sort the table by number of cases so that countries and territories with the most cases appear at the top of the table.

  4. Click the cases field arrows to sort the field from lowest to highest (ascending). Click the arrows again to sort the field from highest to lowest (descending).

    Sort cases from highest to lowest

    It would also be useful to show an aggregated number of cases and deaths to which users can refer quickly without looking through the large amount of data in the table. You can show total values of any field using a Key Performance Indicator (KPI) chart.

  5. In the data pane, click cases to select it. Drag the cases field onto the page next to the cases and deaths map, point to the Chart drop zone, and drag the field onto KPI.

    KPI drop zone

    A KPI card is created. It shows the total number of confirmed COVID-19 cases worldwide. The card has a lot of empty space, so you'll resize it.

  6. Drag the handles to resize the card so that there is minimal empty space.
  7. In the data pane, select the deaths field. Use it to create a second KPI card and resize the card to the same size as the first.

    You've added all the spatial and nonspatial visualizations for your page. (Your layout may look slightly different than the example image.)

    Page with all elements

  8. Save the workbook.

Design the page

The COVID-19 pandemic has resulted in unprecedented data sharing from public health authorities, governments, and researchers. It's important that your page have an appropriate design for your audience. In this case, your audience is the general public, so you'll design the page so that the most important information is clearly visible. You'll also rename cards and fields so your audience can understand what each visualization shows.

Your page includes legends for each map layer, so you don't need the layer lists on the maps. You'll hide them.

  1. Click Card 1 (the map of case rates) to activate it. On the toolbar, click the Legend button.

    Legend button

    The button is deselected and the list of layers is removed from the map.

  2. Remove the list of layers from Card 2 (the map of cases and deaths).

    Next, you'll adjust the table. Currently, the field names in the table include statistics menus that show the type of statistic being shown for each field. For all of these fields, the menu is set to Sum. This information isn't too helpful for users, so you'll hide the menus.

  3. On Card 3 (the table), click the deaths field arrow.

    Arrow to collapse menus

    The menus are hidden. Next, you'll change the page's background color to match the color used in the Light Gray Canvas basemap.

  4. On the ribbon, click the Settings button.

    Settings button

  5. In the Page Style pane, for Background Color, type the hex value #F4F4F4.

    Background Color set to #F4F4F4

  6. Close the Page Style pane.

    The page background changes (the change is slight, so it may be difficult to tell). You'll also change the background for each of the cards, starting with the maps. You'll change the map backgrounds to match the color of the water features on the basemap.

  7. Click Card 1 to activate it. Click the More button and click the Card Settings button.

    Card Settings button

  8. In the Card Style pane, for Background Color, change the color to #CFD3D4. Close the Card Style pane.
  9. For Card 2, follow the same process to change the background color to #CFD3D4.

    Next, you'll remove backgrounds and borders from the remaining cards.

  10. For the remaining cards (including the legends, table, and KPI cards), change the background color to no fill.

    No fill option

  11. For the legends, table, and KPI cards, in the Card Style pane, click the Border Options tab. For Border Style, choose None.

    Border Style parameter set to None

    Now, none of the legends, tables, or KPI cards have a background or border. Next, you'll change the style of the KPI cards so that the text color used for the total number of cases and deaths matches the colors used for cases and deaths on the map. By using the same color for the same data, you'll help your users connect the data on the map with the values on the KPI cards.

  12. Activate Card 4 (the cases KPI card) and click the Legend button.

    Legend button on the KPI card

  13. In the Layer options pane, click the Style tab. For KPI color, set the color to #00A9E6.

    KPI color parameter set to #00A9E6

  14. For Card 5 (the deaths KPI card), follow the same process to change the KPI color to #FF5500.

    Many of your cards don't require titles. The KPI cards include text for sum of cases and sum of deaths, so you don't need titles for the legends and maps that show these values. You also don't need a title for the case rates map, because its legend includes its title. The table also doesn't need a title because the field names provide the necessary information. Next, you'll hide the unneeded titles.

  15. Point to each of the cards (except the Sum of Case rate per 100k legend card) and click the Hide button.

    Hide button

    Now, none of the cards except the case rates legend have titles. You'll update the field names and the title of the case rates legend to be more clear.

  16. In the data pane, point to the countriesAndTerritories field and click the Rename Field button. Change the field name to Country and press Enter.

    The field name changes in the data pane and on the table.

  17. Change the name of the cases field to Cases and the deaths field to Deaths.
  18. For the Sum of Case rate per 100k legend card, click the title to make it editable. Change the title to Case rate per 100,000 and press Enter.

    Finally, you'll update the text in the KPI cards and rearrange the KPI and legend cards.

  19. Click the Sum of cases KPI card to activate it. Click the More button and click the Edit Labels button.

    Edit Labels button

  20. Click the Sum of cases label to make the text editable. Change the label to Total cases and press Enter.
  21. Follow the same process to change the label for the Sum of deaths KPI card to Total deaths.
  22. Rearrange the KPI cards and the legends for cases and deaths so that the KPI card for total cases is above the legend for cases and the KPI card for total deaths is above the legend for deaths.

    KPI cards and legend cards rearranged

  23. At the bottom of the page, click the Page 1 tab to make the text editable. Change the name to COVID-19 overview and press Enter.
  24. Save the workbook.

    Final page

You've created an overview of the global COVID-19 pandemic as of August 29, 2020. Your page maps cases, deaths, and case rates. It also provides key information in nonspatial formats and is designed for a broad audience.


Chart temporal COVID-19 trends

Previously, you created a workbook page with an overview of the global COVID-19 pandemic as of August 29, 2020. The ECDC data you used also provides the daily number of new cases and deaths for each country, meaning it's possible to also visualize trends in the data. Next, you'll create a page with charts that will be useful for examining the temporal trends of new cases across countries.

Create a time series chart

First, you'll add your ECDC dataset to a new page. Then, you'll create a time series chart that shows how cases have changed over time for several countries.

  1. If necessary, open your Global COVID-19 analysis workbook in ArcGIS Insights.
  2. In the data pane, drag the COVID-19 cases by country dataset to the New page button.

    New page button

    A new page, Page 2, is created. It contains your dataset in the data pane.

  3. Click Page 2 to make the page name editable. Change the name to COVID-19 trends and press Enter.
  4. In the data pane, expand the COVID-19 cases by country dataset.

    The dataset includes the dateRep (date reported) field. The field is a date/time field, meaning it contains temporal data. You'll use this field to create a time series chart showing the number of daily reported COVID-19 cases per country.

  5. Press Ctrl and click the dateRep, Cases, and Country fields (in that order).

    The three fields are selected in the data pane.

  6. Drag the fields onto the page and onto the Time Series drop zone.

    Time Series drop zone

    A time series chart is created.

    Note:

    Because there is a lot of data, it may take a few seconds for the chart to load.

    The chart shows the number of cases by country for each reported date. The y-axis shows the average number of cases, the x-axis shows the date, and the different lines represent various countries.

    You'll change the y-axis to show the total number of cases instead of the average number.

  7. On the y-axis of the time series chart, click Avg Cases. In the Cases drop-down list, change AVG to SUM.

    Sum of cases option

    The chart is updated automatically. (Again, it may take a few seconds to load.)

    The chart can be difficult to read because there are so many overlapping lines in a condensed area. First, you'll increase the size of the chart. Then, you'll create filters to show only a few countries at a time.

  8. Drag the handles on the right and bottom of the chart to expand it so that it is about twice as wide as before and a little taller.

    Time series chart expanded horizontally and vertically

  9. Click any empty area on the page to deactivate the card. Click the title, Card 1, and change the title to New cases over time.
  10. Save your workbook.

Filter the chart

It's still difficult to distinguish the data for many of the countries. Next, you'll create a predefined filter and filter the chart to show only the five countries with the highest number of cases. Users will have the option to change the filters to show countries of interest to them.

  1. On the ribbon, click the Widgets button and choose Predefined Filter.

    Predefined Filter option

    A new card, Predefined Filter 1, is added to the page.

  2. If necessary, move the Predefined Filter 1 card next to the time series chart.

    Next, you'll configure the filter to show the five countries with the highest total number of cases: the United States, Brazil, India, Russia, and Peru.

  3. If necessary, activate the Predefined Filter 1 card. Click Add.

    The New Filter pane appears.

  4. For Filter By, choose Country.
  5. Uncheck Select All. Search for and check United_States_of_America, Brazil, India, Russia, and Peru.
    Note:

    If you are using a more recent version of the COVID-19 data, the countries with the most cases may be different. To see which countries have the most cases, review the summary table on the COVID-19 overview page.

    Next, you'll add the five countries you checked to a single filter that can be turned on and off.

  6. Click By group.

    The filter is added to the Predefined Filter 1 pane with the name Country. (By default, predefined filters use the field name as the filter name.) You'll rename the filter to be more descriptive.

  7. Point to the Country filter and click the Rename filter button.

    Rename filter button

  8. Rename the filter Highest total cases and press Enter.

    Next, you'll add filters for each continent. Users can turn these filters on or off to see countries of interest to them, while keeping the total number of countries displayed in the time series chart relatively low.

  9. Click Add.
  10. In the New Filter pane, for Filter By, choose continentExp.

    For the previous filter, you chose a specific group of countries to use in the filter. For this filter, you'll create separate filters for each of the values for this field.

  11. Click By value.

    Filters for each continent are added to the list of filters. By default, every filter is turned on, so all countries are displayed in the time series chart. You'll turn off all of the filters except the Highest total cases filter.

  12. On the Predefined Filter 1 card, uncheck Select All. Check Highest total cases.

    Time series chart filtered to show countries with the most cases

    The time series chart shows only the five countries with the highest number of cases.

    Your filter doesn't need a title, so you'll hide it.

  13. For the Predefined Filter 1 card, click the Hide button.

Create bar charts

Next, you'll create bar charts showing the number of cases and the number of deaths for each country.

  1. In the data pane, press Ctrl and click Country and Cases (in that order). Drag the fields onto the page next to the predefined filter card and onto the Chart drop zone.

    A bar chart is created. It shows the total number of cases in the five countries with the highest number of cases. (If you change the filter, different countries are shown.)

    Default bar chart

    The bars on the chart are displayed using default colors. You'll update the style so the colors on the bars match the colors on the time series.

  2. Click the bar chart to activate it. Click the Legend button.

    Legend button

    The Layer options pane appears.

  3. Click the Options tab. For Symbol type, choose Unique symbols.

    Symbol type set to Unique symbols

  4. Close the Layer options pane.

    You'll also sort the chart so the countries are displayed in descending order by number of cases.

  5. Click the Sort button and choose Sort descending.

    Sort descending option

    By default, the chart displays the average number of cases across the countries displayed. You don't need the average, so you'll remove it from the chart.

  6. Click the Chart statistics button and uncheck Mean.

    Mean unchecked

  7. Close the Chart Statistics pane. For the bar chart, click the Hide button to hide the card header.

    You'll create a second bar chart to show the number of deaths.

  8. In the data pane, select the Country and Deaths fields (in that order). Drag the fields onto the page under the first bar chart and onto the Chart drop zone.
  9. For the second bar chart, click the Legend button. In the Layer options pane, on the Options tab, change Symbol type to Unique symbols.
  10. Close the Layer options pane. Click the Sort button and choose Sort descending.
  11. Click the Chart Statistics button and uncheck Mean.
  12. Click the Hide button to hide the card header.

Create a box plot chart

The last card you'll create is a box plot, which shows the distribution of data, such as minimum and maximum values, median values, and outliers.

  1. If necessary, move and resize the cards on the page so the filter is next to the time series chart and the bar charts are stacked on top of one another next to the filter.

    Page with cards rearranged

  2. In the data pane, select the Country and Cases fields (in that order). Drag the fields onto the page under the time series chart, point to Charts, and drop the fields on Box Plot.

    Box Plot drop zone

    A box plot card is created. It displays a separate box plot for each country. The box plots indicate the maximum, minimum, and median values for the daily number of confirmed cases for each country. Outliers are depicted with lines that extend above the boxes.

    Next, you'll resize the box plot chart.

  3. Drag the right handle of the box plot chart to fill the empty space between the box plot chart and the Sum of Deaths bar chart.
  4. Click an empty area of the page to deselect the card. Click Card 3 (the title of the box plot chart), change the title to Distribution of new cases, and press Enter.

    Final page

    Your workbook now has two pages. The first gives a global overview of the COVID-19 pandemic, including the spatial distribution of cases, and the second shows temporal changes in cases.

Share a workbook

Creating a report is an important part of communicating your analysis to stakeholders. You can share your work in Insights as individual pages or a complete workbook. You'll share your workbook so both pages are readily accessible.

A shared workbook is a read-only version of your original workbook. Viewers can interact with the maps and charts in the same way as an editable Insights workbook, but they cannot make any changes. Members of your organization can also duplicate your shared workbooks to create their own editable copy.

  1. Click the COVID-19 overview page to return to the first page.
  2. Save the workbook.
  3. On the ribbon, click the Insights button.

    Insights button

    You return to the Insights home page. The home page lists your recent workbooks, so your workbook is listed first.

  4. On the home page, point to your Global COVID-19 analysis workbook and click the Share button.

    Share button

    The Share with window appears.

  5. Check Everyone (public) and click Share.

Your workbook is now available to the public in a read-only format. You can open the workbook and share the URL with anyone, including people who don't have an Insights account. The URL will redirect to a view-only URL when opened by anyone other than you.

In this lesson, you learned about mapping techniques that give an accurate and responsible overview of the global COVID-19 pandemic and looked at the trends in new cases over time. You conveyed key information clearly so ordinary users could gain insight into the pandemic. You also shared your workbook to make it available to the public.

You can find more lessons in the Learn ArcGIS Lesson Gallery.