Cloud Hero Intro to BigQuery: Analytics & Machine Learning
Overview
This Cloud Hero game equips you with BigQuery, Google powerful data warehouse, for analyzing massive datasets using familiar SQL. Go a step further and explore BigQuery Machine Learning (ML) to build models directly in BigQuery. Through hands-on labs, you will learn to unearth public datasets, seamlessly import them, and craft efficient data structures for analysis. Furthermore, you will delve into BigQuery ML to predict customer behavior and even forecast taxi fares using real-world data.
What You'll Learn
- Analyze massive datasets using BigQuery and SQL
- Build machine learning models directly in BigQuery using BigQuery ML
- Unearth and work with public datasets
- Import datasets into BigQuery
- Craft efficient data structures for analysis
- Predict customer behavior using BigQuery ML
- Forecast taxi fares using real-world data with BigQuery ML
Who Should Attend
Someone looking to learn BigQuery ML. This course pairs well with the BigQuery Skills Cloud Hero and is a great follow up or can be done stand-alone.
Prerequisites
Basic understanding of BigQuery
Products Covered
Course Modules
BigQuery: Qwik Start - Command Line
Topics
- BigQuery command-line interface
- bq command-line tool
- Running queries from the command line
- BigQuery CLI basics
Learning Outcomes
- Use the BigQuery command-line tool (bq)
- Execute queries from the command line
- Manage BigQuery resources via CLI
Activities
Ingesting New Datasets into BigQuery
Topics
- Data ingestion methods
- Importing public datasets
- Loading data into BigQuery
- Creating efficient data structures
- Data schema design
Learning Outcomes
- Import datasets into BigQuery
- Work with public datasets
- Create efficient data structures for analysis
- Design appropriate data schemas
Activities
Getting Started with BigQuery ML
Topics
- BigQuery ML fundamentals
- Building ML models in BigQuery
- Model training with SQL
- ML model evaluation
Learning Outcomes
- Build machine learning models directly in BigQuery
- Train ML models using SQL
- Evaluate model performance
Activities
Predict Taxi Fare with a BigQuery ML Forecasting Model
Topics
- Forecasting with BigQuery ML
- Real-world ML applications
- Predicting taxi fares
- Customer behavior prediction
Learning Outcomes
- Create forecasting models using BigQuery ML
- Predict taxi fares using real-world data
- Apply ML to solve practical business problems
Activities
Get This Training
No public classes currently scheduled. Express interest below or request private training.
Course Details
- Course Code
- CH-INTROTOBIG
- Duration
- 1 day
- Format
- On-Demand
- Level
- Introductory
- Modules
- 4
- Activities
- 4
- Price
- Loading...
Questions About This Course?
Contact us for custom scheduling, group discounts, or curriculum customization.
Contact Us