Exploring ​and ​Preparing ​your ​Data with Big Query


Duration: 2 Months

This first course in this specialization is Exploring and Preparing your Data with BigQuery. Here we will see what the common challenges faced by data analysts are and how to solve them with the big data tools on Google Cloud Platform. You’ll pick up some SQL along the way and become very familiar with using BigQuery and Cloud Dataprep to analyze and transform your datasets.

Course Topics

Module 1: Introduction ​to ​Data ​on Google ​Cloud ​Platform

Understand the core principles behind Google Cloud Platform and how to leverage them for big data analysis

Module 2: ​Big ​Data ​Tools ​Overview

Learn what are the key big data tools on Google Cloud Platform that you will be using to analyze, prepare, and visualize data

Module 3: ​Exploring ​your ​Data ​with SQL

Learn how to query your data with the basics of SQL (Structured Query Language) and practice writing queries in BigQuery

Module 4: ​Google ​BigQuery ​Pricing

Understand how pricing works in BigQuery and how you can best optimize your queries

Module 5: ​Cleaning ​and ​Transforming your ​Data

Understand the importance of creating high quality datasets and learn the tools that will help you transform your data