GCP BigQuery and Analytics — Dataplexa
Google Cloud › GCP BigQuery and Analytics
Phase 3 — Data & AI — Course 8 of 14

BigQuery and Analytics

BigQuery SQL, Dataflow, Dataproc, Looker Studio, and real-time analytics — how ShopStream analyzes millions of orders with Google Cloud.

Start Lesson 1 → ← Back to Google Cloud
EC
Emily Carter — DevOps Engineer · ShopStream
Your Guide
EC
Emily Carter
DevOps Engineer
ShopStream
Migrating ShopStream's e-commerce platform to GCP — real problems, real Google Cloud.
Course Lessons
Follow each lesson in order — each one builds on the last.
Phase 3 — Data & AI
GCP BigQuery and Analytics
12Lessons
~5hDuration
1Project
Free TierAccess
Your Guide
EC
Emily Carter
DevOps Engineer
ShopStream
What you'll learn
  • Write real SQL in BigQuery
  • Partitioning and clustering
  • Dataflow and Dataproc pipelines
  • Looker Studio visualizations
  • BigQuery ML and cost optimization
Lesson 01
What is BigQuery?
Theory
Lesson 02
BigQuery Architecture and Slots
Theory
Lesson 03
Writing SQL in BigQuery
Console
Lesson 04
BigQuery Tables, Datasets, and Projects
Console
Lesson 05
BigQuery Partitioning and Clustering
Console
Lesson 06
BigQuery Cost Optimization
Theory
Lesson 07
Dataflow Explained
Theory
Lesson 08
Dataproc Explained
Theory
Lesson 09
Pub/Sub with BigQuery
Console
Lesson 10
Looker Studio with BigQuery
Console
Lesson 11
BigQuery ML Explained
Theory
Lesson 12
Hands-On: ShopStream Sales Analytics
Hands-on
Up Next — Course 9 of 14
GCP AI and Machine Learning on GCP
Vertex AI, AutoML, pre-trained APIs, Model Garden, and ML pipeline deployment.
Start Next Course →