Getting Started with Google BigQuery

Name: Getting Started with Google BigQuery
Start: 2023-05-23 00:00:00
Location: Virtual Classroom

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.

1 day course

Supporting material

Virtual, Private

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 offered as a Virtual Classroom course, which will be hosted from the UK. It is also available as a private training session and can be delivered at any location of your choice.

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

Upcoming courses

Virtual Classroom Getting Started with Google BigQuery	Tue, May 23 2023 430 € ex IVA	ADD TO BASKET
Virtual Classroom Getting Started with Google BigQuery	Tue, Jul 18 2023 430 € ex IVA	ADD TO BASKET
Virtual Classroom Getting Started with Google BigQuery	Tue, Sep 19 2023 430 € ex IVA	ADD TO BASKET

Virtual Classroom