Course Overview
Explore ways to derive insights from data at scale using BigQuery, Google Cloud’s serverless, highly scalable, and cost-effective cloud data warehouse. This course uses lectures, demos, and hands-on labs to teach you the fundamentals of BigQuery, including how to create a data transformation pipeline, build a BI dashboard, ingest new datasets, and design schemas at scale.
Who should attend
- Data Analysts, Business Analysts, Business Intelligence professionals
- Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud
Prerequisites
Basic proficiency with ANSI SQL (reference)
Course Objectives
- Derive insights from data using the analysis and visualization tools on Google Cloud
- Load, clean, and transform data at scale with Dataprep
- Explore and Visualize data using Google Data Studio
- Troubleshoot, optimize, and write high performance queries
- Practice with pre-built ML APIs for image and text understanding
- Train classification and forecasting ML models using SQL with BigQuery ML