A COVID-19 dashboard in Google Data Studio

In this post I will be sharing a dashboard I made focused on COVID-19 cases worldwide.

The COVID-19 dashboard

It’s made using a public data set provided Google BigQuery. Below is the COVID-19 dashboard I created in Google Data Studio.

It contains two metrics; confirmed cases and deaths. Up until yesterday the data also listed ‘recovered cases’ but an announcement added on 23 March to the data set said that “The source file for the recovered_cases table is no longer updated as of 03/23/2020”.

I got the idea to create a dashboard from Marc Soares who has created very informative and clearly visualized Data Studio reports on the Coronavirus pandemic.

I have also created a custom metric; ‘deaths / confirmed’. This is essentially the death rate. However it is not official and as such I have simply left it as the calculated field name automatically given to it in Google Data Studio.

For certain countries you can drill down from countries to provinces / regions / states to see a breakdown of the number of cases and deaths using the geomap.

A map showing the number of coronavirus cases across canadian provinces on 12 April 2020. Data on COVID-19 cases presented in google data studio.

Using the table showing the number of confirmed COVID-19 cases and deaths you can select two or more countries to compare them in the time series chart. For example below we have a comparison between the United States and United Kingdom.

A chart showing a comparison of Coronavirus cases between the United States and the United Kingdom on 11 April 2020.


Updated Charts on Page 2 of the report

I’ve added in some additional charts on page 2 of the report.

I’ve added in a time series of COVID-19 cases in a log scale chart.

a time series of COVID-19 cases in a log scale chart.

I’ve also added in a Google Map showing the number of cases and deaths. The bubble size is determined by the number of confirmed COVID-19 cases and the colour is determined by the number of deaths.

a Google Map showing the number of cases and deaths. The bubble size is determined by the number of confirmed COVID-19 cases and the colour is determined by the number of deaths.

The Dataset

This report is based on the COVID-19 Public Datasets available in Google BigQuery.

If you’d like to learn about how to connect to the public data sets available in BigQuery you can read this blog post on the topic.

My Other Blog Posts

If you found this post interesting you might enjoy my other blog posts. They are focused on digital marketing, analytics and data visualization.

Michael Howe-Ely