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
- Видео: Highlight Analytics Challenges Faced by Data Analysts
- Видео: Compare Big Data On-Premise vs on the Cloud
- Видео: Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud
- Видео: Navigate Google Cloud Platform Project Basics
- Видео: Lab 0 Overview
- LTI Item: Lab 0: Getting Started with Google Cloud Platform and Qwiklabs
- Видео: Lab 0 Review
Оцениваемый: 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
- Видео: Compare Common Data Exploration Techniques
- Видео: Explore Real IRS Data
- Видео: Query Basics
- Видео: Intro to Functions
- Видео: Demo: Explore Schemas in the BigQuery UI
- Видео: Filters, Aggregates, and Duplicates
- Видео: Data Types, Date Functions, and NULLs
- Видео: Wildcard Filters with LIKE
- Видео: Lab 2 Overview
- LTI Item: Lab 2: Troubleshoot Common SQL Errors with BigQuery
- Видео: Lab 2 Solution
Оцениваемый: Module 3 Quiz
Module 4: Google BigQuery Pricing
Understand how pricing works in BigQuery and how you can best optimize your queries
- Видео: Walkthrough of a BigQuery Job
- Видео: Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs
- Видео: Demo: Try out the Price Calculator
- Видео: Reserved Slots
- Видео: Query Validator, Quotas, and Common Pitfalls
- Видео: Optimize Queries for Cost
- Видео: Lab 3 Overview
- LTI Item: Lab 3: Calculating Google BigQuery Pricing
- Видео: Lab 3 Solution
Оцениваемый: 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
- Видео: Examine the 5 Principles of Dataset Integrity
- Видео: Characterize Dataset Shape and Skew
- Видео: Clean and Transform Data using SQL
- Видео: Clean and Transform Data using a new UI: Introducing Cloud Dataprep
- Видео: Lab 4a Overview
- LTI Item: Lab 4a: Ingesting Datasets and Creating Flows with Cloud Dataprep
- Видео: Lab 4a Solution
- Видео: Walkthrough of Cloud Dataprep Features
- Видео: Lab 4b Overview
- LTI Item: Lab 4b: Exploring and Transforming Data with Cloud Dataprep
- Видео: Lab 4b Solution
Оцениваемый: Module 5 Quiz
FD
Issues with user credentials through labs