Data Analytics with Google Cloud BigQuery and Looker Studio

Focused View

Yoyu Li

1:05:01

285 View

01 - Introduction

01 - Tell a story with data using Google Cloud BigQuery and Looker Studio.mp4

00:50

02 - Who this course is for.mp4

00:55

02 - 1. Visualizing BigQuery Data as Line Charts in Looker Studio

01 - Introduction to Google Cloud BigQuery and Looker Studio.mp4

03:01

02 - Using a public dataset in BigQuery.mp4

06:50

03 - Running an SQL query in BigQuery.mp4

04:36

04 - Aggregation functions in BigQuery.mp4

02:30

05 - Aggregation across multiple tables in BigQuery.mp4

03:59

06 - Creating a line chart in Looker Studio.mp4

04:08

07 - Challenge Visualize global temperature changes using BigQuery and Looker Studio.mp4

01:03

08 - Solution Visualize global temperature changes using BigQuery and Looker Studio.mp4

02:59

03 - 2. Dimensions and Column Charts in Looker Studio

01 - Joining two datasets in BigQuery.mp4

04:53

02 - Dimensions in line charts and column charts.mp4

05:08

03 - String functions in BigQuery.mp4

03:35

04 - Updating an existing BigQuery data source in Looker Studio.mp4

01:47

05 - Challenge Visualize temperature trends in selected countries in Looker Studio.mp4

00:50

06 - Solution Visualize temperature trends in selected countries in Looker Studio.mp4

00:50

04 - 3. Intermediate SQL Transformation and Geo Charts in Looker Studio

01 - Creating a geo chart in Looker Studio.mp4

03:05

02 - Anatomy of a complex SQL query.mp4

05:56

03 - Challenge Comparing countries temperature changes in a geo chart.mp4

02:07

04 - Solution Comparing countries temperature changes in a geo chart.mp4

04:33

05 - Conclusion

01 - Continue your data analytics journey.mp4

01:26

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Google Looker

Google BigQuery

Yoyu Li

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.