From the course: Data Analytics with Google Cloud BigQuery and Looker Studio

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Solution: Comparing countries’ temperature changes in a geo chart

Solution: Comparing countries’ temperature changes in a geo chart - Google Cloud Platform Tutorial

From the course: Data Analytics with Google Cloud BigQuery and Looker Studio

Start my 1-month free trial Buy for my team

Solution: Comparing countries’ temperature changes in a geo chart

“

(upbeat music) - [Instructor] To plot a geochart that shows the average temperature of given years in different countries compared to the average temperature of the past 50 years, we'll use the queries that we wrote in the second video of this chapter. We have saved the query result as a table, so we need to connect this table as a data source in Looker Studio. Then we change the chart type to field map. For date range dimensions, it needs to be a column with data type, date time. So the only column that qualifies is the year, date time column. And for the locations, we are going to use country code. Here we need to change the type of this column into geotype. Since its country code, we'll choose the geotype country. Here we can see the locations have already been recognized by Looker Studio. And for the color metrics, because we care about the difference between given years and the baseline, we'll use the temp…

Contents