About this Course

65,659 recent views

Learner Career Outcomes

28%

started a new career after completing these courses

24%

got a tangible career benefit from this course

14%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 13 hours to complete
English

Skills you will gain

BigqueryGoogle Cloud PlatformCloud ComputingSQL

Learner Career Outcomes

28%

started a new career after completing these courses

24%

got a tangible career benefit from this course

14%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 13 hours to complete
English

Instructor

Offered by

Placeholder

Google Cloud

Syllabus - What you will learn from this course

Content RatingThumbs Up92%(1,827 ratings)Info
Week
1

Week 1

1 minute to complete

Welcome to From ​Data ​to ​Insights ​with ​Google ​Cloud Platform: ​Exploring ​and ​Preparing ​your ​Data

1 minute to complete
1 video (Total 1 min)
1 hour to complete

Module 1: Introduction ​to ​Data ​on Google ​Cloud ​Platform

1 hour to complete
4 videos (Total 28 min)
4 videos
Compare ​Big ​Data ​On-Premise ​vs ​on ​the ​Cloud12m
Real-World ​Use ​Cases2m
Navigate ​Google ​Cloud ​Platform ​Project ​Basics3m
1 practice exercise
Module 1 Quiz30m
3 hours to complete

Module 2: ​Big ​Data ​Tools ​Overview

3 hours to complete
8 videos (Total 72 min)
8 videos
Demo: BigQuery Tips and Tricks on Public Datasets10m
Explore ​9 ​Fundamental ​Google ​BigQuery ​Features3m
Walkthrough: Data Architecture Diagram3m
Compare ​GCP ​Tools ​for ​Analysts, ​Data ​Scientists, ​and ​Data ​Engineers4m
Meet Qwiklabs, your on-demand labs platform5m
Lab Walkthrough - Exploring Ecommerce Data34m
Demo: Beyond the BigQuery Web UI5m
1 practice exercise
Module 2 Quiz30m
4 hours to complete

Module 3: ​Exploring ​your ​Data ​with SQL

4 hours to complete
13 videos (Total 77 min), 1 reading, 2 quizzes
13 videos
Compare Common Data Exploration Techniques3m
Query Basics3m
Intro to Functions9m
Demo: Explore Schemas in the BigQuery UI2m
Filters, Aggregates, and Duplicates13m
Data Types, Date Functions, and NULLs7m
Wildcard Filters with LIKE3m
Lab Walkthrough - Enable Standard SQL3m
Lab Walkthrough - Query Validator, Aliases, and Commas5m
Lab Walkthrough - Logical Errors, Group Bys, Wildcard Filters7m
Lab Walkthrough - Ordering, Calculated fields, Filtering after Aggregating9m
Lab Walkthrough - Finding top selling products, Filtering NULLs6m
1 reading
IRS Public Dataset Overview5m
1 practice exercise
Module 3 Quiz30m
1 hour to complete

Module 4: ​Google ​BigQuery ​Pricing

1 hour to complete
6 videos (Total 19 min)
6 videos
Calculate ​BigQuery ​Pricing: ​Storage, ​Querying, ​and ​Streaming ​Costs5m
Demo: Try out the Price Calculator1m
Reserved Slots2m
Query Validator, Quotas, and Common Pitfalls4m
Optimize ​Queries ​for ​Cost2m
1 practice exercise
Module 4 Quiz30m
4 hours to complete

Module 5: ​Cleaning ​and ​Transforming your ​Data

4 hours to complete
13 videos (Total 77 min), 1 reading, 3 quizzes
13 videos
Characterize ​Dataset ​Shape ​and ​Skew3m
Clean ​and ​Transform ​Data ​using ​SQL6m
Clean ​and ​Transform ​Data ​using ​a ​new ​UI: ​Introducing ​Cloud ​Dataprep5m
Demo: CloudDataprep on Ecommerce Dataset7m
Lab Walkthrough - Connecting BigQuery data to Cloud Dataprep5m
Lab Walkthrough - Exploring Ecommerce Data Fields and Values with a UI9m
Lab Walkthrough - Building Data Transformation Recipes with a UI10m
Lab Walkthrough - Running and Scheduling Dataprep Jobs to BigQuery7m
Components of Data Fusion2m
Building a Pipeline6m
Exploring Data using Wrangler1m
Course Summary1m
1 reading
New Lab! Cloud Data Fusion10m
1 practice exercise
Module 5 Quiz30m

Reviews

TOP REVIEWS FROM EXPLORING ​AND ​PREPARING ​YOUR ​DATA WITH BIGQUERY

View all reviews

About the From Data to Insights with Google Cloud Platform Specialization

From Data to Insights with Google Cloud Platform

Frequently Asked Questions

More questions? Visit the Learner Help Center.