Exploring and Preparing your Data with BigQuery - Locales

"This course, Exploring and Preparing Your Data with BigQuery - Locales, is intended for non-English learners. If you want to take this course in English, please enroll in 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. You’ll pick up some SQL along the way and become very familiar with using BigQuery and Dataprep to analyze and transform your datasets. This is the first course of the From Data to Insights with Google Cloud series. After completing this course, enroll in the Creating New BigQuery Datasets and Visualizing Insights course."

• Welcome to From Data to Insights with Google Cloud - Exploring and Preparing Your Data
• Course series introduction
• Introduction ​to ​Data ​on Google ​Cloud
• Analytics challenges ​faced ​by ​data ​analysts
• Big ​data ​on-premises ​versus ​in ​the ​cloud
• Real-world ​use cases
• ​Google ​Cloud ​project ​basics
• Quiz: Introduction ​to ​Data ​on Google ​Cloud
• ​Big ​Data ​Tools ​Overview
• Data analyst tasks and challenges and Google Cloud data tools
• 9 fundamental ​​BigQuery ​features
• Walkthrough: Data architecture diagram
• 'Google Cloud ​tools ​for ​analysts ​data ​scientists ​and data ​engineers'
• Exploring an Ecommerce Dataset using SQL in Google BigQuery
• Quiz: Big Data Tools Overview
• ​Exploring ​your ​Data ​with SQL
• Introduction to the Google Analytics ecommerce dataset
• Common data exploration techniques
• Query basics
• Introduction to functions
• Filters, aggregates, and duplicates
• Data types, date functions, and NULLs
• Wildcard filters with LIKE
• Troubleshooting Common SQL Errors with BigQuery v1.5
• Quiz: Exploring your Data with SQL
• ​​BigQuery ​Pricing
• BigQuery jobs
• Sizing and cost management
• Optimize ​queries ​for ​cost
• Quiz: BigQuery Pricing
• ​Cleaning ​and ​Transforming Your ​Data
• ​5 ​principles ​of ​dataset ​integrity
• Dataset ​shape ​and ​skew
• Clean ​and ​transform ​data ​using ​SQL
• 'Clean ​and ​transform ​data ​using ​a ​new ​UI: ​Introducing ​Dataprep'
• Exploring and Creating an Ecommerce Analytics Pipeline with Cloud Dataprep v1.5
• Components of Data Fusion
• Build a pipeline
• Explore data using wrangler
• Building Transformations and Preparing Data with Wrangler in Cloud Data Fusion
• Quiz: Cleaning ​and ​Transforming Your ​Data
• Course Summary
• Course summary
• Course Resources
• Course Resources