Getting Started with Google BigQuery

4.8 / 5 Feefo reviews

Do you need to analyze large datasets? Our BigQuery course will give you an in-depth understanding of Google’s powerful data warehouse and enable you to turn your data into actionable business insights.

Book this course
1 day course
Supporting material
Private
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 scalable big data platform that can give you the insights you need to create a better customer experience and drive competitive advantage.

On this one-day course, our BigQuery experts will help you learn how to unlock more value from your business data. You’ll get to see the underlying architecture that makes the platform so powerful, and learn how to use the Structured Query Language (SQL) to explore, enrich, and generate insights from your data.

Using SQL, you'll examine an example GA4 dataset to help you understand your web analytics data and the main concepts of BigQuery. You’ll also get an overview of how to load and manage data in the platform. Toward the end of the session, we’ll cover best practices to help you get the most out of it.

Our Getting Started with Google BigQuery course is available as a private training session that can be delivered via Virtual Classroom or at a location of your choice in Australia.

Course overview

Who should attend:

This course is designed for analysts working with large datasets like web analytics information (especially GA4) on a daily basis. This is also relevant for marketers looking to get more value out of their data by taking control of the analysis process.

What you'll learn:

By the end of this course, you will be able to:

  • Confidently use the BigQuery web user interface to make sense of big data and provide insights
  • Use SQL to answer complex questions you couldn’t answer in the Google Analytics platform – from time-to-interaction analysis to user journey visualization
  • Combine Google Analytics data with your own business data for even greater value
  • Import your business data into BigQuery
  • Efficiently use BigQuery, respective of both cost and performance, by following best-practice guidelines

Course agenda

Introduction to BigQuery
  • BigQuery as a data warehouse
  • BigQuery storage
  • BigQuery processing
Using the BigQuery Web Interface
  • Exploring datasets
  • Using the SQL Workspace
  • Managing jobs
Structured Query Language (SQL)
  • Retrieving data
  • Enriching data
  • Advanced operations
Exploring Google Analytics 4 Data with BigQuery
  • GA4 data structure
  • Nested and repeated fields
  • Custom dimensions
Loading & Managing Data
  • SQL Data Manipulation Language (DML)
  • BigQuery advanced storage configuration
  • Import tools and services
BigQuery Best Practices
  • Controlling costs
  • Performance tips
  • Visualizing data
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
Feefo logo
4.8 / 5 Feefo reviews
Independent Service Rating based on 4 verified reviews

Google BigQuery

Josh is an excellent instructor and he taught me exactly what I was expecting to learn.

Nancy McDonald 13 October, 2023