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.
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.
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.
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.
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.
Great article! We’ve done a similar one where explained how to create a destination tracker dashboard in Google Data Studio https://blog.coupler.io/coronavirus-dashboard-data-studio/ I hope, your audience will find it useful!
thanks for sharing!