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."
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.