Data Analytics with Google Cloud BigQuery and Looker Studio

Data Analytics with Google Cloud BigQuery and Looker Studio

1h 5mIntermediate2023-05-31

Authors

Yoyu Li

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 EngineeringGoogleSoftware Development ToolsData AnalysisCloud PlatformsCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsSoftware DevelopmentOne-Off

Concepts

Introduction

  • Tell a story with data using Google Cloud BigQuery and Looker Studio
  • Who this course is for

Visualizing BigQuery Data as Line Charts in Looker Studio

  • Introduction to Google Cloud BigQuery and Looker Studio
  • Using a public dataset in BigQuery
  • Running an SQL query in BigQuery
  • Aggregation functions in BigQuery
  • Aggregation across multiple tables in BigQuery
  • Creating a line chart in Looker Studio
  • Challenge - Visualize global temperature changes using BigQuery and Looker Studio
  • Solution - Visualize global temperature changes using BigQuery and Looker Studio

Dimensions and Column Charts in Looker Studio

  • Joining two datasets in BigQuery
  • Dimensions in line charts and column charts
  • String functions in BigQuery
  • Updating an existing BigQuery data source in Looker Studio
  • Challenge - Visualize temperature trends in selected countries in Looker Studio
  • Solution - Visualize temperature trends in selected countries in Looker Studio

Intermediate SQL Transformation and Geo Charts in Looker Studio

  • Creating a geo chart in Looker Studio
  • Anatomy of a complex SQL query
  • Challenge - Comparing countries temperature changes in a geo chart
  • Solution - Comparing countries temperature changes in a geo chart

Conclusion

  • Continue your data analytics journey
40,000 Toman