Google BigQuery Training
Our Google BigQuery Kickstarter course is designed for digital marketing teams as well as data analysts and engineers who are looking to get to grips with the plethora of functionality available in BigQuery and the wider Google Cloud Platform tools.
We start by introducing the Google Cloud Platform, including integrations and costs. You’ll then learn how to load and manage data and get hands-on experience creating views and writing queries.
Level-up your team
Call +44(0)20 3920 0387 or email us to discuss your requirements and find a date that works for you.
What to expect
Our team training courses are relaxed and informal, covering a lot of ground in a fun and stimulating way. The course is delivered remotely over two, 3-hour sessions to help you maintain focus and avoid information overload.
You don’t need to bring any of your own data, but you may benefit from being able to look at your data and navigate BigQuery on a second screen. We set aside plenty of time for questions about your instance and use cases.
First session
Introduction to Google BigQuery and the Google Cloud Platform
Topics covered:
What is the Google Cloud Platform (GCP)
Gentle intro to the BigQuery interface
How to write efficient code in BigQuery
You will learn:
An understanding of the GCP, including pricing and core tools
How to navigate the current BigQuery interface and how to access key tools
Key programming standards to manage costs and write efficient code
Suitable for:
Anyone who wants to understand how to access and use BigQuery, even if you have limited SQL experience.
Break
Creating tables and working with Google Analytics and Firebase data
Topics covered:
Ingesting data into BigQuery
Google Analytics (Universal) and Firebase (Google Analytics 4) tables
Handling arrays
You will learn:
How to import different data sources into the BigQuery warehouse
The structure of the live streamed tables and how to access the data
Extracting data and parameters from the streamed tables
Suitable for:
Anyone who wants to understand how to create and use tables from UA, GA4 and Firebase data.
Q&A
Second session
Managing your BigQuery data warehouse and saving tables
Topics covered:
Storing your data and query output
Managing your warehouse
Data recovery
You will learn:
Creating and maintaining permanent tables and views
Managing datasets and tables in the interface and generating reusable tables
Recovering your datasets and tables when things go wrong
Suitable for:
Anyone who wants to be hands on with their data and maintain a clean and tidy warehouse
Break
BigQuery automation and other core tools
Topics covered:
Automating your transformations in BigQuery
Introduction to other key tools: Google Data Studio
Introduction to other key tools: Google Dataform
You will learn:
Scheduling and automating your queries to run your code for you
How to connect your tables to Google Data Studio and common pitfalls
What is Google Dataform and how to set it up on your account
Suitable for:
Anyone who wants to automate transformations within BigQuery, or connect BigQuery data with Google Data Studio
Q&A
Meet your trainer and more
Lace Rogers
LEAD ANALYTICS SPECIALIST
Lace is passionate about BigQuery and the accompanying Google Cloud Platform tools. With a background in advanced analytics and data warehousing on GCP BigQuery, she spends her days helping clients optimise, automate and enrich their databases, as well as bringing together external data sources to enhance our client’s investment in their marketing and CRM activities.
Remote delivery
SOCIALLY DISTANT
All our courses are delivered remotely via Zoom or your preferred video conferencing platform – at a time and date that works for you.
You may prefer to join as a group from your offices or have everyone connect from home. We’re easy!
Frequently asked questions
What people say
Pricing and payment
Training courses cost £1,600 +VAT for two 3-hour sessions run over the course of a week.
There’s no official limit on the number of attendees but we’ve found any more than 10 people in a session becomes impractical.
Once dates are confirmed, we invoice for the total cost with payment due on receipt.
Call us now on +44(0)20 3920 0387 or email us to book your sessions.