From the course: Data Analytics with Google Cloud BigQuery and Looker Studio
Join today to access over 25,300 courses taught by industry experts.
Challenge: Comparing countries’ temperature changes in a geo chart - Google Cloud Platform Tutorial
From the course: Data Analytics with Google Cloud BigQuery and Looker Studio
Challenge: Comparing countries’ temperature changes in a geo chart
(bright upbeat music) - [Instructor] As the final challenge of this course, you are going to plot a geo chart that shows the average temperature of given years in different countries compared to the average temperature of the past 50 years. This will answer questions like how the average temperature has changed in the past century and which countries had the biggest changes in temperature over the years. The final chart should look like this. We have a geo chart that shows each country's average temperature compared to the average of this country in the past 50 years. The bigger the difference, the darker the shade of oranges. And I can use a slider to change which years average I want to compare with. For example, at the moment the average temperature is between 2001 and 2021 and is compared to the average temperature of the past 50 years. I can change this to the last year, so this way it'll compare the average…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.