Welcome to From Data to Insights with Google Cloud Platform: Exploring and Preparing your Data
Learn the courses, content, and technologies that are part of this data analyst specialization
Module 1: Introduction to Data on Google Cloud Platform
Understand the core principles behind Google Cloud Platform and how to leverage them for big data analysis
- Video: Highlight Analytics Challenges Faced by Data Analysts
- Video: Compare Big Data On-Premise vs on the Cloud
- Video: Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud
- Video: Navigate Google Cloud Platform Project Basics
- Video: Lab 0 Overview
- LTI 项目: Lab 0: Getting Started with Google Cloud Platform and Qwiklabs
- Video: Lab 0 Review
Graded: Module 1 Quiz
Module 2: Big Data Tools Overview
Learn what are the key big data tools on Google Cloud Platform that you will be using to analyze, prepare, and visualize data
Module 3: Exploring your Data with SQL
Learn how to query your data with the basics of SQL (Structured Query Language) and practice writing queries in BigQuery
- Video: Compare Common Data Exploration Techniques
- Video: Explore Real IRS Data
- Video: Query Basics
- Video: Intro to Functions
- Video: Demo: Explore Schemas in the BigQuery UI
- Video: Filters, Aggregates, and Duplicates
- Video: Data Types, Date Functions, and NULLs
- Video: Wildcard Filters with LIKE
- Video: Lab 2 Overview
- LTI 项目: Lab 2: Troubleshoot Common SQL Errors with BigQuery
- Video: Lab 2 Solution
Graded: Module 3 Quiz
Module 4: Google BigQuery Pricing
Understand how pricing works in BigQuery and how you can best optimize your queries
- Video: Walkthrough of a BigQuery Job
- Video: Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs
- Video: Demo: Try out the Price Calculator
- Video: Reserved Slots
- Video: Query Validator, Quotas, and Common Pitfalls
- Video: Optimize Queries for Cost
- Video: Lab 3 Overview
- LTI 项目: Lab 3: Calculating Google BigQuery Pricing
- Video: Lab 3 Solution
Graded: Module 4 Quiz
Module 5: Cleaning and Transforming your Data
Understand the importance of creating high quality datasets and learn the tools that will help you transform your data
- Video: Examine the 5 Principles of Dataset Integrity
- Video: Characterize Dataset Shape and Skew
- Video: Clean and Transform Data using SQL
- Video: Clean and Transform Data using a new UI: Introducing Cloud Dataprep
- Video: Lab 4a Overview
- LTI 项目: Lab 4a: Ingesting Datasets and Creating Flows with Cloud Dataprep
- Video: Lab 4a Solution
- Video: Walkthrough of Cloud Dataprep Features
- Video: Lab 4b Overview
- LTI 项目: Lab 4b: Exploring and Transforming Data with Cloud Dataprep
- Video: Lab 4b Solution
Graded: Module 5 Quiz
FD
Issues with user credentials through labs