Exploring and Preparing your Data with BigQuery

This course is part of From Data to Insights with Google Cloud Specialization

Instructor: Google Cloud Training

What you'll learn

Query and draw insight from BigQuery public datasets.
Assess the quality of a dataset and develop an automated data cleansing pipeline that will output to BigQuery.
Write and troubleshoot SQL on a real Google Analytics e-commerce dataset to drive marketing insights.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the From Data to Insights with Google Cloud Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 7 modules in this course

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.

Learn the courses, content, and technologies that are part of this data analyst course series.

What's included

1 video

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

What's included

4 videos1 assignment

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

What's included

5 videos1 assignment1 app item

5 videosTotal 19 minutes

Data analyst tasks and challenges and Google Cloud data tools4 minutesPreview module
9 fundamental BigQuery features3 minutes
Walkthrough: Data architecture diagram3 minutes
Google Cloud tools for analysts data scientists and data engineers3 minutes
Coursera: Getting Started with Google Cloud Platform and Qwiklabs4 minutes

1 assignmentTotal 10 minutes

Big Data Tools Overview10 minutes

1 app itemTotal 90 minutes

Lab: Exploring an Ecommerce Dataset using SQL in Google BigQuery90 minutes

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

What's included

7 videos1 assignment1 app item

7 videosTotal 41 minutes

Introduction to the Google Analytics ecommerce dataset1 minutePreview module
Common data exploration techniques3 minutes
Query basics3 minutes
Introduction to functions9 minutes
Filters, aggregates, and duplicates12 minutes
Data types, date functions, and NULLs7 minutes
Wildcard filters with LIKE3 minutes

1 assignmentTotal 6 minutes

Exploring your Data with SQL6 minutes

1 app itemTotal 60 minutes

Lab: Troubleshooting Common SQL Errors with BigQuery60 minutes

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

What's included

3 videos1 assignment

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

What's included

7 videos1 assignment2 app items

7 videosTotal 33 minutes

5 principles of dataset integrity9 minutesPreview module
Dataset shape and skew3 minutes
Clean and transform data using SQL6 minutes
Clean and transform data using a new UI: Introducing Dataprep4 minutes
Components of Data Fusion2 minutes
Building a Pipeline6 minutes
Exploring Data using Wrangler1 minute

1 assignmentTotal 12 minutes

Module 5 Quiz12 minutes

2 app itemsTotal 150 minutes

Lab: Building Transformations and Preparing Data with Wrangler in Cloud Data Fusion60 minutes
Exploring and Creating an Ecommerce Analytics Pipeline with Cloud Dataprep90 minutes

Summary of the course key learning points

What's included

1 video

Instructor

Instructor ratings

4.6 (731 ratings)

Google Cloud Training

Google Cloud

1,708 Courses2,843,797 learners

Offered by

Google Cloud

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.7

3,637 reviews

5 stars
72.57%
4 stars
23.02%
3 stars
3.29%
2 stars
0.68%
1 star
0.41%

Showing 3 of 3637

Reviewed on Nov 20, 2017

Excelente curso, muy buenas explicaciones. Tuve problemas para entrar al laboratorio, pero las explicaciones posteriores sirvieron para entender la ejecución.

Reviewed on May 24, 2020

Broad overview on the use of BigQuery and learn for beginners to learn SQL in a ridiculously short amount of time, also to build a simple datapipeline to transform data

Reviewed on Jun 29, 2019

I think this is a rare example of good course for Google Cloud BigQuery. I would recommend this one instead of "Serverless Data Analysis with Google BigQuery and Cloud Dataflow"

View more reviews