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

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

Data Engineers
Data Analyst
Data Scientists

Edit
  • What is BigQuery?
  • Background¬†
  • BigQuery vs Hive
  • Use cases for Google BigQuery
  • Google BigQuery Fundamentals
  • Hands-on: Experience 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
  • 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
  • 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
Edit

Participants should preferably have knowledge of SQL query language.

Connect

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