Google BigQuery (GBQ) training
Learn how to use Google BigQuery with our team of analytics experts.
Our trainers each have over 10 years of experience working for organisations of all shapes and sizes, including eCommerce firms. They are familiar with the premium features of Google Analytics and associated products. You will leave our training sessions with actionable learnings which will equip you to get the most out of Google Big Query for your business.
Our training includes:
- Up to six hours of essential GBQ training via Zoom
- High-quality, tailored sessions for between 3-10 participants at a time
- Bespoke training materials
- A recording of the training, available for two years
- Two weeks of follow-up support via email
Google Big Query course
Course details
Course details
4x 1.5-hour remote sessions. or 3x 2-hour remote sessions
Introduction to Google BigQuery and the Google Cloud Platform for marketers
- What is the Google Cloud Platform (GCP)
- Intro to the BigQuery interface
- How much do GCP and BigQuery cost?
- How to get started with SQL
Working with Google Analytics 4 data set
- How to set up your project
- How to connect GA4 to BigQuery
- The GA4 schema
- Writing your first basic query on GA4 data
Advanced GA4 analysis
- Unnesting parameters for custom dimensions and metrics
- How to track user journeys
- How to track Attribution
- Regex and filtering
- Best practice when writing SQL
Building your processes and being business-driven
- Automate your queries
- How to schedule a daily GA4 query
- Connecting to Looker Studio
- Connecting data to other sources
- Data Transfers and other data sources
- How to develop your skills further
Pricing
1-5 delegates £2,750
6-10 delegates £4,600
Loading
Talk to us about our GBQ training
Tell us your needs and we'll be in touch