Compare the Average Monthly Temperatures of Cities in Google Data Studio

Compare the Average Monthly Temperatures of Cities in Google Data Studio

In this post I’ll share a Data Studio report I made that lets you Compare the Average Monthly Temperatures of Cities around the world.

The data is from a Wikipedia article listing cities by the average temperature. It shows the average temperature for the entire year. You can filter by Month of the year to see the average temperature for that month.

The Google Data Studio report

Please note that you’ll need to open the report in Google Data Studio itself to view the Google Maps feature. You’ll need to click on the ‘Google Data Studio’ logo in the bottom right corner of the report to open it.

Open report in Google Data Studio

Below is the interactive Google Data Studio report.

The Google Map should look something like this once you’ve opened up the world correctly.

It shows the average monthly temperature of each city.

You can also compare tempatures. For example here’s Cape Town and Toronto compared. We can see that Toronto has quite an extreme change while Cape Town’s change from summer to winter is not so dramatic.

Cape Town and Toronto tempatures over the year

You could also compare cities that are a bit more extreme. For example, Riyadh and Moscow.

Riyadh and Moscow tempatures over the year

You can also filter by Country. So below I’ve selected Country as Canada and it only shows Canadian cities listed.

Compare the Average Monthly Temperatures of Cities in Canada in a table in Google Data Studio

If you filter by country you can also only see that country in the Google Map in the report. For example I’ve selected Russia and the map below only shows Russia.

Compare the Average Monthly Temperatures of Cities in Russia in a table in Google Data Studio

Getting the Data from Wikipedia into Google Sheets

So this data is not live. It is pulled into Google Sheets from Wikipedia using this formula: =ImportHtml(“https://en.wikipedia.org/wiki/List_of_cities_by_average_temperature”, “table”, 1)

I then neatened up the data in another sheet before connecting it to Data Studio.

I hope you found this Data Studio report about how to compare the average monthly temperatures of cities interesting and useful.

Download Google Data Studio Templates

If you’d like to download one of my Google Data Studio reports as a template to use for your own data, you can visit Data Studio Templates and purchase one.

My Other Blog Posts

If you liked this article you might enjoy my other blog posts. There are mainly about Google Data Studio but some feature Google Analytics, Google Tag Manager, Search Console, Tableau and other digital marketing tools.