Skip to main content

Videos on BigQuery

This page collects other video courses and presentations previously broadcasted on webinars, conferences and course lectures, about BigQuery and/or digital analytics data.

Check out the following videos for a concise introduction into loading data into BigQuery. These were presented on various different occasions and might have a certain amount of overlap with each other. They're all available for free for GA4BigQuery subscribers.

In case you are looking for the Simmer SQL course with Johan on GA4 data in BigQuery:

SQL course: unlock advanced insights with Google BigQuery and the GA4 data export
This course, called Query GA4 Data In Google BigQuery, is designed for marketing professionals who want to dive into the world of SQL queries, and for data professionals who need to skill up on GA4-specific knowledge.
GA4BigQueryJohan van de Werken

The power of Data Transfers in BigQuery

This video describes the most commonly used mechanisms to load data from digital platforms into Google BigQuery; originally aired on MeasureSummit 2024. This includes both some native export mechanisms and the Data Transfer service. Includes a demo on how to set it up a Data Transfer job, and information on the data from the most important platforms to help you get started.

Presentation about the most commonly used data transfers and native exports.

Note that we also have some articles on GA4BigQuery regarding some of these data ingestion mechanisms:

Beyond the Interface: Unleash Google Ads Data Potential with BigQuery and Looker Studio

This was presented as a guest lecture in the 2024 cohort of Looker Studio Masterclass. The presentation focuses on the Google Ads Data Transfer and goes into more detail about how you can find your way around the 109 tables (and another 109 views) and how this data can be queried to produce some useful output.

Creating a Data Warehouse in BigQuery

This is my newest talk, to be presented on MeasureSummit between 8-10th October. Sign up for a free access to the event (or the All-Access Pass if you want to retain the ability to watch the presentations later).

Data Science and Machine Learning Approaches for E-Commerce

This video is not about BigQuery per se—but it might be interesting if you would like to get a short summary of data science / machine learning / AI approaches relevant to retail and e-commerce companies.