The world may be on hold, but your learning needn't be.
Work from home, study from home - and be better prepared than ever before.
Virtual classrooms

Google BigQuery

Want to learn how to run super-fast queries on large datasets? Our Google BigQuery course will give you an in-depth understanding of the tool and enable you to turn big data into actionable business insights.
product
1 day course
Supporting material
Classroom, Virtual, Private
Classroom
Face to face, interactive classroom training run from our global training centres.
Virtual Classroom
A convenient and interactive learning experience, that enables you to attend one of our courses from the comfort of your own home or anywhere you can log on. We offer Virtual Classroom on selected live classroom courses where this will appear as an option under the location drop down if available. These can also be booked as Private Virtual Classrooms for exclusive business sessions.
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

BigQuery is a powerful Big Data solution that can provide you with the insights you need to create a better customer experience and drive competitive advantage.

If you are using your analytics data to answer complex business questions or are looking for a solution that will help create efficiency and save costs in the long term, our BigQuery implementation and insights specialists will show you how BigQuery can help solve these problems.

The course will take advantage of Google Analytics 360 data to cover the four main concepts that a user should understand when using BigQuery: projects, datasets, tables and jobs.

We’ll cover in detail the main elements of interaction including loading and exporting data as well as querying, viewing and managing data. Finally, we will look at some common causes of error and BigQuery's integrations with other tools.

Our Google BigQuery course is available at our training centre in The Shard, London. We also offer private training at a location of your choice or via Virtual Classroom.

Course overview
Who should attend:
This course has been built for analysts working with large datasets and web analytics tools (in particular Google Analytics 360) on a daily basis or marketers looking to learn more about Google BigQuery and the fundamental principles behind the platform.

Having some basic knowledge of SQL and how data is gathered within your business is required.
Walk away with the ability to:
  • Use the BigQuery interface with confidence to make sense of Big Data and provide insights to the business
  • Use SQL fundamentals: clauses, functions and operators
  • Answer complex questions you couldn’t answer in the Google Analytics platform - from time to interaction analysis to user journey visualisation
  • Enhance Google Analytics data with your own business data
  • Integrate BigQuery with your technology stack and other tools including Data Studio
Course agenda
Introduction
  • BigQuery: Fundamentals, use cases, access control
  • Creating datasets and tables
  • Analytics 360 schema
Query reference
  • Query syntax and clauses (e.g. WHERE, JOIN, IN/NOT IN, ORDER BY, GROUP BY)
  • String functions: use cases and examples, e.g. concatenating, splitting and extracting values
  • Aggregate and window functions: use case and examples, e.g. counting and ranking values and defining subgroups of data
  • Arithmetic operators: use cases and examples, e.g. rounding, absolute values, averages
  • Regular expressions
  • Working with different types: casting functions
Use cases
  • Advanced analysis of Analytics 360 data
  • Importing/exporting data
  • BigQuery limitations
  • Common causes for errors
  • Integrations: overview and examples with R, Tableau, Google Sheets, Data Studio
Book this course
£499 ex VAT
Loading...
Other options available
Virtual Classrooms
Whether you’re one person, or a whole team; our Virtual Classrooms deliver an immersive learning experience when and where you need it. Hosted live by our experienced practitioners.
LEARN MORE
Unlimited Virtual Class Pass for £999
Keep learning whilst at home. Attend as many of our Virtual Classroom training sessions as you want before 31st May 2020 for a low one off fee.
Learn more
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy
Related news
& insights
BROWSE ALL ARTICLES
Cloud Guides
12 Oct, 2019
Cloud computing is an everyday part of most modern businesses - even if you don’t realise it. In this guide, we’ll answer frequently asked questions to help you understand how the technology can b...
Analytics Guides
27 Jan, 2020
By adding Google Analytics to your WordPress account, you can track how your audience is finding your website, what they’re doing when they’re there, and which pages they’re dropping off at. Thi...
Cloud Guides
17 Oct, 2019
Cloud computing can help businesses of all scales. It can enable you to streamline processes, improve flexibility, increase security, and so much more....
Cloud Guides
16 Nov, 2019
Did you know that there is more than one type of cloud computing? In this guide, we’ll help you make sense of the different types and the various cloud services that are available....
Cloud Guides
01 Jan, 2020
Want to leverage cloud technology for your business, but unsure which provider to choose? Read on to discover what options are available, their features and benefits, and how they compare with each ot...