Coursera Plus Annual is 40% Off — Ends June 29.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Exploring and Preparing your Data with BigQuery

Google via Google Skills

Go to class Write review
OpenLearning Ad

Future-Proof Your Career: AI Manager Masterclass

Learn More → University of the People Ad

Earn Your CS Degree, Tuition-Free, 100% Online!

Learn More →

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
In this course, we see what the common challenges faced by data analysts are and how to solve them with the big data tools on Google Cloud. You’ll pick up some SQL along the way and become very familiar with using BigQuery and Dataprep to analyze and transform your datasets. This is the first course of the From Data to Insights with Google Cloud series. After completing this course, enroll in the Creating New BigQuery Datasets and Visualizing Insights course.

Syllabus

  • Welcome to From Data to Insights with Google Cloud - Exploring and Preparing your Data
    • Course series introduction
  • Introduction to Data on Google Cloud
    • Analytics challenges faced by data analysts
    • Big data on-premises versus in the cloud
    • Real-world use cases
    • Google Cloud project basics
    • Quiz: Introduction ​to ​Data ​on Google ​Cloud
  • Big Data Tools Overview
    • Data analyst tasks and challenges and Google Cloud data tools
    • 9 fundamental BigQuery features
    • Walkthrough: Data architecture diagram
    • Google Cloud tools for analysts data scientists and data engineers
    • Exploring an Ecommerce Dataset using SQL in Google BigQuery
    • Quiz: Big Data Tools Overview
  • Exploring your Data with SQL
    • Introduction to the Google Analytics ecommerce dataset
    • Common data exploration techniques
    • Query basics
    • Introduction to functions
    • Filters, aggregates, and duplicates
    • Data types, date functions, and NULLs
    • Wildcard filters with LIKE
    • Troubleshooting Common SQL Errors with BigQuery v1.5
    • Quiz: Exploring your Data with SQL
  • BigQuery Pricing
    • BigQuery jobs
    • Sizing and cost management
    • Optimize queries for cost
    • Quiz: BigQuery Pricing
  • Cleaning and Transforming Your Data
    • 5 principles of dataset integrity
    • Dataset shape and skew
    • Clean and transform data using SQL
    • Clean and transform data using a new UI: Introducing Dataprep
    • Exploring and Creating an Ecommerce Analytics Pipeline with Cloud Dataprep v1.5
    • Components of Data Fusion
    • Build a pipeline
    • Explore data using wrangler
    • Building Transformations and Preparing Data with Wrangler in Cloud Data Fusion
    • Quiz: Cleaning ​and ​Transforming Your ​Data
  • Course Summary
    • Course summary
  • Course Resources
    • Course Resources
  • Your Next Steps
    • Course Badge

Tags

Reviews

Start your review of Exploring and Preparing your Data with BigQuery

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.