Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Google BigQuery for Data Analysts (CPB 200)

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

GK# 8327

Course Overview

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.

Delivery Format Options

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $1995 CAD

    3 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • 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

Prerequisites

Who Needs To Attend

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