Google BigQuery for Data Analysts

Learn how to store, transform, analyze, and visualize data using Google BigQuery.

In this course, you will be introduced to Google BigQuery. Through a combination of instructor-led presentations, demonstrations, and hands-on labs, you will learn how to store, transform, analyze, and visualize data using Google BigQuery.

More details

More info

This course is aimed at:

  • Data analysts and data scientists responsible for: 

  • Analyzing and visualizing big data

  • Implementing cloud-based big data solutions

  • Deploying or migrating big data applications to the public cloud

  • Implementing and maintaining large-scale data storage environments, and transforming/processing big data

You will need:

  • Have attended Google Cloud Platform Fundamentals (CP100A) or Google Cloud Platform Big Data And Machine Learning Fundamentals (CPB100) (or equivalent experience)

  • Experience using a SQL-like query language to analyze data

You will learn to:

  • Purpose of and use cases for Google BigQuery

  • Ways in which customers have used Google BigQuery to improve their businesses

  • Architecture of BigQuery and how queries are processed

  • Interact with BigQuery using the web UI and command-line interface

  • Purpose and structure of BigQuery schemas and data types

  • Purpose of and advantages of BigQuery destinations tables and caching

  • Use BigQuery jobs

  • Transform and load data into BigQuery

  • Export data from BigQuery

  • Store query results in a destination table

  • Create a federated query 

  • Export log data to BigQuery and query it

  • Understand the BigQuery pricing structure and evaluate mechanisms for controlling query and storage costs

  • Best practices for optimizing query performance

  • Troubleshoot common errors in BigQuery

  • Use various BigQuery functions

  • Use external tools such as spreadsheets to interact with BigQuery

  • Visualize BigQuery data

  • Use access controls to restrict access to BigQuery data

  • Query Google Analytics Premium data exported to BigQuery

£ 1,645.00 ex.vat

Data sheet

Course Duration 3 Days
Location London