Google BigQuery for Data Analysis

Enroll In Course

Google Data Analysis Course Description

This 3-day course provides hands-on skills in ingesting, analyzing, transforming and visualizing data using BigQuery and getting the best performance when using it at scale. This course builds on the broad topics covered in Cloud Platform CPB 101 by delving much deeper into the choices and tradeoffs that define one’s BigQuery experience.

Google Data Analysis Course Benefits

This class has the potential to be an amazing resource for any individual currently using BigQuery, or planning a switch to BigQuery data tool.
This course will delve into the optimization of BigQuery for myriad tasks, as well as why BigQuery can be a penultimate step toward Big Data solutions and transforming one’s data infrastructure.

The deeper knowledge of BigQuery will allow one to better vizualize and understand BigQuery data, Import/export data from BigQuery, learn to use external tools, such as Spreadsheets, to interact with BigQuery, and much more!

View Full Schedule

Course Outline

At the end of this course, participants should be able to:

Understand the purpose of and use cases for Google BigQuery
Describe ways in which customers have used Google BigQuery to improve their businesses
Understand the architecture of BigQuery and how queries are processed
Interact with BigQuery using the web UI and command-line interface
Identify the purpose and structure of BigQuery schemas and data types
Understand the 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
Identify 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

Google BigQuery for Data Analysis

Google Data Analysis Course Description

Google Data Analysis Course Benefits

Explore Courses

Interested in working with us?

Get In Touch

Course Info

Ledet Newsletter