Exploring and Preparing your Data with BigQuery

Focused View

Google Cloud

2:21:59

103 View

1. Welcome to From Data to Insights with Google Cloud - Exploring and Preparing your Data

1. Course series introduction.mp4

01:08

2. Introduction to Data on Google Cloud

1. Analytics challenges faced by data analysts.mp4

05:31

2. Big data on-premises versus in the cloud.mp4

12:41

3. Real-world use cases.mp4

02:24

4. Google Cloud project basics.mp4

03:30

3. Big Data Tools Overview

1. Data analyst tasks and challenges and Google Cloud data tools.mp4

05:03

2. 9 fundamental BigQuery features.mp4

03:33

3. Walkthrough - Data architecture diagram.mp4

03:25

4. Google Cloud tools for analysts data scientists and data engineers.mp4

03:04

5. Getting Started with GCP and Qwiklabs.mp4

03:48

4. Exploring your Data with SQL

1. Introduction to the Google Analytics ecommerce dataset.mp4

01:19

2. Common data exploration techniques.mp4

03:37

3. Query basics.mp4

03:51

4. Introduction to functions.mp4

09:12

5. Filters, aggregates, and duplicates.mp4

12:51

6. Data types, date functions, and NULLs.mp4

07:24

7. Wildcard filters with LIKE.mp4

03:18

5. BigQuery Pricing

1. BigQuery jobs.mp4

02:40

2. Sizing and cost management.mp4

11:23

3. Optimize queries for cost.mp4

02:18

6. Cleaning and Transforming Your Data

1. 5 principles of dataset integrity.mp4

09:25

2. Dataset shape and skew.mp4

03:06

3. Clean and transform data using SQL.mp4

06:12

4. Clean and transform data using a new UI - Introducing Dataprep.mp4

04:42

6. Components of Data Fusion.mp4

02:03

7. Build a pipeline.mp4

06:03

8. Explore data using wrangler.mp4

01:58

7. Course Summary

1. Course summary.mp4

06:30

Description

In this course, we see what the common challenges faced by data analysts are and how to solve them with the big data tools on Google Cloud.

What You'll Learn?

In this course, we see what the common challenges faced by data analysts are and how to solve them with the big data tools on Google Cloud. You’ll pick up some SQL along the way and become very familiar with using BigQuery and Dataprep to analyze and transform your datasets. This is the first course of the From Data to Insights with Google Cloud series. After completing this course, enroll in the Creating New BigQuery Datasets and Visualizing Insights course.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Google BigQuery

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.