Home / Courses / AI, Data & Analytics / BigQuery for Data Analysts

BigQuery for Data Analysts

Name: BigQuery for Data Analysts
Availability: InStock
Rating: 4.6 (5878 reviews)

This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in...

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Enquire Now

Download Overview

Duration:

16.00 hours

13.0 CPD hours

Overview:

Description:

Course Outline:

Module 0 - Course Introduction

Topics:

- This module introduces the course agenda.

Objectives:

- Introduce the topics covered in the course.
Module 1 - BigQuery for data analysts

Topics:

- Overview
- Data analytics on Google Cloud
- From data to insights with BigQuery
- Real-world use cases of companies transformed through analytics on Google Cloud

Objectives:

- Identify analytics challenges faced by data analysts, and compare big data on-premises versus in the cloud.
- Learn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.
Module 2 - Exploring and preparing your data with BigQuery

Topics:

- Overview
- Common data exploration techniques
- Analysis of large datasets with BigQuery
- Query basics
- Working with functions
- Enriching your queries with UNIONs and JOINs

Objectives:

- List common data exploration techniques.
- Review SQL query basics.
- Enrich queries with functions, unions, and joins.

Activities:

- Lab: Exploring an Ecommerce Dataset using SQL in Google BigQuery
- Lab: Troubleshooting Common SQL Errors with BigQuery
- Lab: Troubleshooting and Solving Data Join Pitfalls
Module 3 - Cleaning and transforming your data

Topics:

- Overview
- Five principles of dataset integrity
- Clean and transform data using SQL
- Clean and transform data: Other options

Objectives:

- Identify what makes a good dataset.
- Clean and transform data using SQL.
- Clean and transform data with other options.
Module 4 - Ingesting and storing new BigQuery datasets

Topics:

- Overview
- Permanent versus temporary data tables
- Ingesting new datasets
- External data sources

Objectives:

- Review differences between permanent and temporary data tables.
- Ingest and store new BigQuery datasets.
- Discuss options for external data sources.

Activities:

- Lab: Creating New Permanent Tables
- Lab: Ingesting and Querying New Datasets
Module 5 - Visualizing your insights from BigQuery

Topics:

- Overview
- Data visualization principles
- Connected Sheets
- Common data visualization pitfalls
- Looker Studio
- Analysis in a notebook

Objectives:

- Review data visualization principles and common visualization pitfalls.
- Use Connected Sheets and Looker Studio to visualize data insights from BigQuery.
- Discuss running analyses in a Jupyter Notebook.

Activities:

- Lab: Connected Sheets Qwik Start
- Lab: Explore and Create Reports with Looker Studio
Module 6 - Developing scalable data transformation pipelines in BigQuery with Dataform

Topics:

- Overview
- What is Dataform?
- Getting started with Dataform

Objectives:

- Use Dataform to develop scalable data transformation pipelines in BigQuery.
- Learn how to get started with Dataform by creating a repository and development workspace.
- Create and execute a SQL workflow in Dataform.

Activities:

- Demo
- Lab: Create and Execute a SQL Workflow in Dataform
Module 7 - BigQuery Studio

Topics:

- BigQuery Studio: What and why?
- Unified analytics
- Asset management
- Embedded assistance

Objectives:

- Introduce BigQuery Studio.
- Use Duet AI in BigQuery to explain and generate SQL queries.
- Learn about new usability features and integrations with Dataform and Dataplex in the new BigQuery Studio interface.

Activities:

- Demo
- Lab: Analyze Data with Duet AI Assistance
- Lab: Generate Personalized Email Content with BigQuery Continuous Queries and Gemini
Module 8 - Summary

Topics:

- Summary

Objectives:

- Summarize the key topics covered in the course.

Available Delivery Options for BigQuery for Data Analysts

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does BigQuery for Data Analysts provide?

The 2 day BigQuery for Data Analysts course gives you up to 13.0 CPD hours/structured learning hours.

Who is the correct audience for BigQuery for Data Analysts?

- Data analysts who want to learn how to use BigQuery for their data analysis needs.

Do you provide training for BigQuery for Data Analysts?

Yes, we provide corporate training, dedicated training and closed classes for BigQuery for Data Analysts. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of BigQuery for Data Analysts?

The BigQuery for Data Analysts training takes place over 2 day(s), with each day lasting approximately 16.00 hours including breaks.

What other terms do people search for?

Popular related searches include: BigQuery for Data Analysts, Data Analysis, BQDA

Why are Nexus Human the best provider for BigQuery for Data Analysts?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for BigQuery for Data Analysts?

Yes, the discount code PENPAL5 is currently available for BigQuery for Data Analysts training. Only one discount code can be used per booking.

DURATION 16.00 Hours

No scheduled classes available at this time.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.