Google BigQuery Training

Want to learn how to run super-fast queries on large datasets? Our Google BigQuery course is designed to give you an in-depth understanding of the tool and enable you to turn big data into actionable business insights.

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. The course will cover in detail the main elements of interaction including loading and exporting data, querying and viewing data and managing data, finally looking at some common causes of error and integration with other tools.

Our BigQuery trainers are implementation and insights specialists working with BigQuery on a daily basis. The training days are informal, engaging and involve a mix of teaching, individual and group exercises and Q&A sessions.

Course Details:

The course aims to provide you with an in-depth understanding of BigQuery. At the end of the training you will be able to load data into BigQuery, query the data that you are using and export the data in order to manage and measure against your objectives.

Six Tic have built this course for anybody working with large datasets on a day to day basis or those 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.

This course includes:


  • BigQuery: Fundamentals, use cases, access control
  • Creating datasets and tables
  • Google Analytics Schema

Query Reference

  • Query syntax and clauses
  • String Functions
  • Aggregate functions
  • Arithmetic Operators
  • Regular expressions
  • Working with different types: casting functions
  • Javascript user-defined functions

Use cases

  • Google Analytics Premium advanced analysis
  • Importing/exporting data
  • BigQuery Limitations
  • Common causes for errors
  • Integrations overview and examples

Payment options: All major credit cards (Online) or invoicing

None of these dates work for you? Or would you prefer an on-site training session? Either way, Six Tic can help. Our tailored training courses are totally flexible and built around you, from location to number of attendees (we even train one-to-one) to how the course is delivered right through to the specific content. Whatever we can do to help with your session, we will do it.

© 2016. Six Tic - All Rights Reserved.