Exploring and Preparing your Data with BigQuery

Focused View

Google Cloud

4:24:36

39 View

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

0.mp4

01:14

01. Introduction to Data on Google Cloud Platform

00. Highlight Analytics Challenges Faced by Data Analysts.mp4

09:35

01. Compare Big Data On-Premise vs on the Cloud.mp4

12:59

02. Real-World Use Cases.mp4

02:27

03. Navigate Google Cloud Platform Project Basics.mp4

03:33

02. Big Data Tools Overview

00. Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools.mp4

05:13

01. Demo - BigQuery Tips and Tricks on Public Datasets.mp4

10:51

02. Explore 9 Fundamental Google BigQuery Features.mp4

03:50

03. Walkthrough - Data Architecture Diagram.mp4

03:30

04. Compare GCP Tools for Analysts, Data Scientists, and Data Engineers.mp4

04:03

05. Getting started with GCP and Qwiklabs.mp4

03:48

06. Explore a BigQuery Public Dataset.mp4

00:10

07. Lab Walkthrough - Exploring Ecommerce Data.mp4

34:19

08. Demo - Beyond the BigQuery Web UI.mp4

05:44

03. Exploring your Data with SQL

00. Intro to Google Analytics ecommerce dataset.mp4

01:19

01. Compare Common Data Exploration Techniques.mp4

03:51

02. Query Basics.mp4

03:51

03. Intro to Functions.mp4

09:20

04. Demo - Explore Schemas in the BigQuery UI.mp4

02:08

05. Filters, Aggregates, and Duplicates.mp4

13:14

06. Data Types, Date Functions, and NULLs.mp4

07:24

07. Wildcard Filters with LIKE.mp4

03:30

08. Troubleshooting Common SQL Errors with BigQuery v1.5.mp4

00:10

09. Lab Walkthrough - Enable Standard SQL.mp4

03:52

10. Lab Walkthrough - Query Validator, Aliases, and Commas.mp4

05:13

11. Lab Walkthrough - Logical Errors, Group Bys, Wildcard Filters.mp4

07:53

12. Lab Walkthrough - Ordering, Calculated fields, Filtering after Aggregating.mp4

09:05

13. Lab Walkthrough - Finding top selling products, Filtering NULLs.mp4

06:41

04. Google BigQuery Pricing

00. Walkthrough of a BigQuery Job.mp4

02:42

01. Calculate BigQuery Pricing - Storage, Querying, and Streaming Costs.mp4

05:22

02. Demo - Try out the Price Calculator.mp4

01:20

03. Reserved Slots.mp4

02:48

04. Query Validator, Quotas, and Common Pitfalls.mp4

04:37

05. Optimize Queries for Cost.mp4

02:19

05. Cleaning and Transforming your Data

00. Examine the 5 Principles of Dataset Integrity.mp4

09:28

01. Characterize Dataset Shape and Skew.mp4

03:10

02. Clean and Transform Data using SQL.mp4

06:22

03. Clean and Transform Data using a new UI - Introducing Cloud Dataprep.mp4

05:01

04. Demo - CloudDataprep on Ecommerce Dataset.mp4

07:29

05. Exploring and Creating an Ecommerce Analytics Pipeline with Cloud Dataprep v1.5.mp4

00:10

06. Lab Walkthrough - Connecting BigQuery data to Cloud Dataprep.mp4

05:48

07. Lab Walkthrough - Exploring Ecommerce Data Fields and Values with a UI.mp4

09:53

08. Lab Walkthrough - Building Data Transformation Recipes with a UI.mp4

10:08

09. Lab Walkthrough - Running and Scheduling Dataprep Jobs to BigQuery.mp4

07:53

10. Course Summary.mp4

01:19

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 Platform.

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 Platform. You’ll pick up some SQL along the way and become very familiar with using BigQuery and Cloud Dataprep to analyze and transform your datasets.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Big Data

Google Cloud

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.