Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
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 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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal