BigQuery + GA4 Intro Course

50+
courses held
4.8
score rating
100+
participants
CTRL ACADEMY

Working with Google Analytics 4 Data in Google BigQuery.

This full-day course is perfect for digital analysts and marketers who want to dive into using Google BigQuery for marketing data. You’ll learn the basics of data warehousing, how to connect Google Analytics 4 to BigQuery, and the fundamentals of SQL for querying data. We’ll also explore how to work with public datasets, handle nested fields in GA4, and analyze events, sessions, and users. A dedicated code lab session gives you hands-on practice, and you’ll discover how ChatGPT can assist with everything from learning new techniques to debugging queries.


By the end of the day, you’ll have a strong foundation and the confidence to continue building your BigQuery and SQL skills—laying the groundwork for deeper, more advanced marketing data analysis as you progress.

"I went from zero knowledge of BigQuery to actually being able to write and understand SQL queries."

Course Program

Getting Started

  • What is Google BigQuery?
  • Linking Google Analytics 4 to BigQuery
  • Accessing public datasets

SQL Fundamentals

  • What is SQL?
  • Basic SQL concepts
  • Running your first query
  • Code lab session #1

Google Analytics Dataset

  • Table schema
  • Events, sessions & users
  • Nested fields
  • Cost management
  • Code lab session #2

Data Visualization

  • Integrating with Google Data Studio
  • Best practices for calculations

Tips & Tricks

  • Using ChatGPT for learning & debugging
  • Online resources for continuous learning

Course Leaders

Anton Gezelius

Anton Gezelius has over 15 years of experience in digital analytics and digital marketing, with a primary focus on technical implementation, data architecture, and privacy. He has extensive experience in professional training, having lectured and led courses on SQL, JavaScript, Google Analytics, and Google Tag Manager. Anton is also a recognized speaker, having shared his expertise at multiple industry conferences.

Anton Gezelius
Corporate Course
32,000 SEK ex. VAT
12 attendees (+1995 SEK pp)
Location: Remote or @Office
Full Day
Individual Registration
4,000 SEK ex. VAT
Location: Remote
Full Day
Bundled Offer
9,800 SEK ex. VAT
Location: Remote
Individual Registration
Certification