Course
Skills
Exploring and Preparing your Data with BigQuery
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.
Table of contents
Welcome to From Data to Insights with Google Cloud Platform - Exploring and Preparing your Data
1min
Introduction to Data on Google Cloud Platform
29mins
Big Data Tools Overview
72mins
- Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools 5m
- Demo:BigQuery Tips and Tricks on Public Datasets 11m
- Explore 9 Fundamental Google BigQuery Features 4m
- Walkthrough:Data Architecture Diagram 4m
- Compare GCP Tools for Analysts, Data Scientists, and Data Engineers 4m
- Getting started with GCP and Qwiklabs 4m
- Explore a BigQuery Public Dataset 0m
- Lab Walkthrough - Exploring Ecommerce Data 34m
- Demo:Beyond the BigQuery Web UI 6m
Exploring your Data with SQL
76mins
- Intro to Google Analytics ecommerce dataset 1m
- Compare Common Data Exploration Techniques 4m
- Query Basics 4m
- Intro to Functions 9m
- Demo:Explore Schemas in the BigQuery UI 2m
- Filters, Aggregates, and Duplicates 13m
- Data Types, Date Functions, and NULLs 7m
- Wildcard Filters with LIKE 3m
- Troubleshooting Common SQL Errors with BigQuery v1.5 0m
- Lab Walkthrough - Enable Standard SQL 4m
- Lab Walkthrough - Query Validator, Aliases, and Commas 5m
- Lab Walkthrough - Logical Errors, Group Bys, Wildcard Filters 8m
- Lab Walkthrough - Ordering, Calculated fields, Filtering after Aggregating 9m
- Lab Walkthrough - Finding top selling products, Filtering NULLs 7m
Google BigQuery Pricing
19mins
Cleaning and Transforming your Data
65mins
- Examine the 5 Principles of Dataset Integrity 9m
- Characterize Dataset Shape and Skew 3m
- Clean and Transform Data using SQL 6m
- Clean and Transform Data using a new UI: Introducing Cloud Dataprep 5m
- Demo:CloudDataprep on Ecommerce Dataset 7m
- Exploring and Creating an Ecommerce Analytics Pipeline with Cloud Dataprep v1.5 0m
- Lab Walkthrough - Connecting BigQuery data to Cloud Dataprep 6m
- Lab Walkthrough - Exploring Ecommerce Data Fields and Values with a UI 10m
- Lab Walkthrough - Building Data Transformation Recipes with a UI 10m
- Lab Walkthrough - Running and Scheduling Dataprep Jobs to BigQuery 8m
- Course Summary 1m
