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 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.
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.