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,300 courses taught by industry experts.
Challenge: Visualize temperature trends in selected countries in Looker Studio - Google Cloud Platform Tutorial
From the course: Data Analytics with Google Cloud BigQuery and Looker Studio
Challenge: Visualize temperature trends in selected countries in Looker Studio
(bubbly upbeat music) - [Instructor] In the previous video of this chapter, we joined the reference data set in BigQuery to attach the country information to our weather observation data. And we introduced the concept of dimensions and we used the string functions to extract the dimensional elements, the decade from years. And we learned how to update an existing data source. In this challenge, I want you to go straight to update the chart to display the changes in average temperature over decades in the 20th century in those three countries we chose. The completed chart should look something similar to this. Now over to you.
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.
Contents
-
-
-
-
Joining two datasets in BigQuery4m 53s
-
(Locked)
Dimensions in line charts and column charts5m 8s
-
(Locked)
String functions in BigQuery3m 35s
-
(Locked)
Updating an existing BigQuery data source in Looker Studio1m 47s
-
(Locked)
Challenge: Visualize temperature trends in selected countries in Looker Studio50s
-
(Locked)
Solution: Visualize temperature trends in selected countries in Looker Studio50s
-
-
-