Google BigQuery Training

In this one-day training workshop we’ll first introduce 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.

The course is designed for digital marketers, data analysts and engineers who are looking to answer complex business questions using large datasets.

Topics covered
Upcoming dates

£475 +VAT per person

All major credit cards accepted or request an invoice.

BOOK NOW

What to expect

Our training days are relaxed and informal, covering a lot of ground in a fun and stimulating way. Bring along a wifi-enabled laptop and come prepared to ask questions and get stuck in with hands-on exercises.

We will be working with data from a demo account on the day. It will help if you have experience with Google Analytics and Data Studio and some familiarity with SQL.

Topics covered

10:00 – 11:00

Introduction

Google Cloud Platform

Getting to know Google Cloud Platform (GCP)

Management and access control

BigQuery

BigQuery setup and administration

Creating datasets and tables

Things to watch

Writing efficient code

11:00 – 11:15

Coffee Break

11:15 – 12:30

Use cases – writing and fixing code in BigQuery

Creating simple queries using BigQuery

SQL and query syntax / references

Understanding and fixing errors

Writing Functions

12:30 – 13:30

Lunch

14:00 – 15:00

Coding and Beyond

An Introduction to Nested Queries

A logical approach to queries

BigQuery connectors

15:00 – 15:15

Coffee Break

15:15 – 16:00

Questions & Answers

Book online

Meet your trainer and more

Your trainer

KATY BECKETT – DATA SPECIALIST

Katy is an accomplished data engineer and analyst with a wealth of experience blending and analysing big data. She regularly uses a number of open source and commercial tools and languages including SQL, R and Python to automate data processes, build predictive models and derive insight.

Our training venues

ALL OVER LONDON

We use several Central London locations – all ideal for workshop based training. In all venues, there’s a kitchen for breakfast and lunches – as well as facilities for tea, infusions, freshly brewed Fair-trade coffee, juices, soft drinks, retro-sweets, cookies, fruit and nuts-all day long.

Frequently asked questions

Who is the course aimed at?

If you are looking to use Google BigQuery in your steps towards creating a truly scalable data warehouse, this course is for you.

What are the course timings?

Our courses last for a day. We normally crack on at around 10:00am but we ask delegates to be there a bit earlier to ensure that everyone is ready by that time (breakfast is available beforehand, from 8am!). We normally finish at around 4:00-4:30pm but this depends on the group’s pace of learning, number of attendees – never more than 10 – and so on. We want to ensure that no-one walks away thinking that it wasn’t worth their time and money! 🙂

Do I need a Google BigQuery account?

You don’t need a BigQuery / GCP account to attend the course as we will provide you with examples and take you through the features and reports covered in the course content. However, if you have access to an account already, you’d be able to look your own data and get a better understanding on where the gaps might be.

What do I do if I’m running late?

If you are just running late due to traffic, train delays, etc. Don’t panic! Just give us a ring and we will let the trainer know.

What happens if I need to cancel?

If you want to cancel or postpone the course, please check our cancellation policy below. Or you can also drop us a line at training@measurelab.co.uk ** Cancellation policy: ** Refunds and transfers can be requested up to 7 days before the event.

What people say

Excellent training. Hands on and practical. Sitting in a room actually going through the reports and doing real examples in the GA account made it so much easier to understand. One of the best and most useful training courses I have been on.

This was incredibly useful, thank you. I found the sections on API particularly useful, and I think it was good to have this in the afternoon, building on the work of the morning. Pitched at the right level, and all questions were answered really well. Thank you!

It is pretty rare to find a trainer so knowledgeable AND articulate… Thank you for a great session, it will take time to process everything we’ve learn but this was amazing. Thanks!

Very interesting teardown of some fundamental issues around GA setup that can heavily skew interpretation, and how to best tackle those.

The training was excellent and very beneficial to the team.

Dan (our teacher) knew pretty much everything. He could’ve been smug, but he was thoughtful, comprehensive and spoke with great clarity. Good work!

Pricing and payment

One-day training course is just £475 +VAT per person.

Book now

We accept all major credit cards online. Alternatively, to pay via bank transfer you may select “pay by invoice” at checkout.

For bigger groups we run onsite training workshops at your offices or at an agreed location, with prices starting from £1,200 +VAT per day.

Custom training and workshops

We can also provide custom training and workshops at your offices or at an agreed location, with prices starting from £1,200 +VAT per day.

Find out more

Flexible Location

At your office, at our office, or somewhere else entirely – the training can be conducted wherever’s easiest for you.

Flexible Content

Our custom training courses will be adapted to your specific needs.

Flexible Group Size

Normal group size limits need not apply! We can train as many or as few people as you need us to.

Flexible Time & Date

For those with difficult schedules, or who just can’t make it for one of our regular sessions – we can find a time that suits you.