Data Analysis using Big Query

Unleash the power of serverless Data Warehouse i.e. Big Query for analyzing your data in an optimized way!!

Duration

2 Days

Level

Intermediate Level

Design and Tailor this course

As per your team needs

Edit Content

The program initially provides a high level overview of BigQuery, after that, it delves down deeper into it and provides exposure around loading data, exporting data and exploring data using BigQuery.

Edit Content

Data Engineers
Data Analyst
Data Scientists

Edit Content

Why BigQuery?

What is BigQuery?
Background
BigQuery vs Hive
Use cases for Google BigQuery
Google BigQuery Fundamentals
Hands-on: Experience BigQuery

Importing Data Into BigQuery

Schema Design
Creating datasets and tables
How to define ACLs for datasets?
Data Preparation and Transformation Aspect
Dealing with streaming data and bulk loading
Hands-on: Loading Data Into BigQuery

Exploring Data using BigQuery

Control requirements for exporting data
Quota policies
Access control requirements for exporting data
Access quotas
Compression and DataFormats
Exporting data to Google Cloud Storage
Hands-on: Exporting Data from BigQuery related exercises

Exporting Data from BigQuery

Edit Content

Participants should preferably have knowledge of SQL query language.

FIND YOUR COURSE

Topics

Brands

Data Analysis using Big Query

Duration

Level

Design and Tailor this course

Quick Links

our Offerings

Get in touch

Sign up for DataCouch Communications

Connect

we'd love to have your feedback on your experience so far