Data Analytics with Google Cloud BigQuery and Looker Studio
1h 5mIntermediate2023-05-31
Authors

Yoyu Li
Course details
When you think about the best storytellers of the 21st century, you might not think… data? But data analytics play an increasingly large role in how we interpret what’s happening around us and is indispensable in solving real-world problems. In this course, learn how to use Google Cloud BigQuery and Looker Studio to tell your data analytics stories. Instructor Yoyu Li provides a step-by-step demonstration of solving a real-world data analytics challenge, looking at global temperature changes over nine decades. Yoyu shares a full view of the process of telling a story with data, starting from a problem statement. She shows you how to use public datasets in BigQuery, how to run SQL queries, how to add data sources, and visualize data in Looker Studio. Yoyu starts each chapter with a problem to solve, so you can immediately see the concepts in action as go you along.
Skills covered
Google Cloud PlatformData VisualizationBusiness IntelligenceData EngineeringSoftware Development ToolsGoogleData AnalysisCloud PlatformsCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Tell a story with data using Google Cloud BigQuery and Looker Studio
- 02 - Who this course is for
1. Visualizing BigQuery Data as Line Charts in Looker Studio
- 03 - Introduction to Google Cloud BigQuery and Looker Studio
- 04 - Using a public dataset in BigQuery
- 05 - Running an SQL query in BigQuery
- 06 - Aggregation functions in BigQuery
- 07 - Aggregation across multiple tables in BigQuery
- 08 - Creating a line chart in Looker Studio
- 09 - Challenge - Visualize global temperature changes using BigQuery and Looker Studio
- 10 - Solution - Visualize global temperature changes using BigQuery and Looker Studio
2. Dimensions and Column Charts in Looker Studio
- 11 - Joining two datasets in BigQuery
- 12 - Dimensions in line charts and column charts
- 13 - String functions in BigQuery
- 14 - Updating an existing BigQuery data source in Looker Studio
- 15 - Challenge - Visualize temperature trends in selected countries in Looker Studio
- 16 - Solution - Visualize temperature trends in selected countries in Looker Studio
3. Intermediate SQL Transformation and Geo Charts in Looker Studio
- 17 - Creating a geo chart in Looker Studio
- 18 - Anatomy of a complex SQL query
- 19 - Challenge - Comparing countries temperature changes in a geo chart
- 20 - Solution - Comparing countries temperature changes in a geo chart
Conclusion
- 21 - Continue your data analytics journey