Creating New BigQuery Datasets and Visualizing Insights

Focused View

Google Cloud

2:37:21

14 View

01 - Introduction

01 - Course Introduction.mp4

01:12

02 - Getting started with GCP and Qwiklabs.mp4

03:48

03 - Recap of Google Analytics ecommerce dataset.mp4

00:47

02 - Storing and Exporting Data

04 - Creating Permanent Tables.mp4

10:55

05 - Demo -Importing JSON Data.mp4

02:44

06 - Temporary Tables and Query Results.mp4

01:38

07 - Performance Preview -Query Cache.mp4

02:01

08 - Creating Logical Views.mp4

07:13

09 - Lab Overview.mp4

00:20

10 - Data to Insights - Creating new Permanent Tables v1.1.mp4

00:10

11 - Lab Solution.mp4

11:13

03 - Ingesting New Datasets into Google BigQuery

12 - Ingesting New Data into BigQuery.mp4

06:35

13 - Demo -Loading Data into BigQuery.mp4

13:12

14 - Lab Intro.mp4

00:19

15 - Data to Insights - Ingesting and Querying New Datasets v1.1.mp4

00:10

16 - Lab Solution.mp4

07:25

17 - Creating Date-Partitioned Tables in BigQuery v1.5.mp4

00:10

04 - Joining and Merging Datasets

18 - Introducing JOINs and UNIONs.mp4

07:03

19 - Introducing BigQuery Table Wildcards for Easy Merges.mp4

09:00

20 - SQL JOIN Syntax.mp4

03:20

21 - Walkthrough -SQL Join Types.mp4

05:30

22 - Avoiding Pitfalls when Merging Datasets.mp4

05:14

23 - Recap of Google Analytics ecommerce dataset.mp4

00:47

24 - Troubleshooting and Solving Data Join Pitfalls v1.5.mp4

00:10

25 - Lab Intro.mp4

00:24

26 - Data to Insights - Unioning and Joining Datasets v1.1.mp4

00:10

27 - Lab Solution.mp4

16:12

05 - Data Visualization

28 - Overview of Data Visualization principles.mp4

06:48

29 - Comparing Good and Bad Visualizations.mp4

03:58

30 - Dimensions, Measures, and Reports.mp4

02:54

31 - Introducing Google Data Studio.mp4

02:44

32 - Demo -Data Studio Walkthrough.mp4

06:59

33 - Lab Intro.mp4

00:16

34 - Data to Insights - Exploring a Dataset in Google Data Studio v1.1.mp4

00:10

35 - Lab Solution.mp4

14:22

06 - End of Course Recap

36 - End of Course Recap.mp4

01:28

Description

This is the second course in the Data to Insights specialization. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data Studio. We will also cover intermediate SQL concepts like multi-table JOINs and UNIONs which will allow you to analyze data across multiple data sources. Note:Even if you have a background in SQL, there are BigQuery specifics (like handling query cache and table wildcards) that may be new to you.

What You'll Learn?

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Big Data

Google Cloud

Instructor's Courses

Google Cloud can help solve your toughest problems and grow your business. With Google Cloud, their infrastructure is your infrastructure. Their tools are your tools. And their innovations are your innovations.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.