Google Cloud Skills Boost

Exploring and Preparing your Data with BigQuery

3 days Introductory universal_currency_alt 15 Credits

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.

Badge for Exploring and Preparing your Data with BigQuery

When you complete this course, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

info

Course Info

Objectives
  • 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.
Prerequisites
We recommend participants have some proficiency with ANSI SQL.
Audience
Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud
Available languages
English
What do I do when I finish this course?
After finishing this course, you can explore additional content in your learning path or browse the catalog.
What badges can I earn?
Upon finishing the required items in a course, you will earn a badge of completion. Badges can be viewed on your profile and shared with your social network.
Interested in taking this course with one of our authorized on-demand partners?
Explore Google Cloud content on Coursera and Pluralsight.
Prefer learning with an instructor?
View the public classroom schedule here.
Can I take this course for free?
When you enroll into most courses, you will be able to consume course materials like videos and documents for free. If a course consists of labs, you will need to purchase an individual subscription or credits to be able consume the labs. Labs can also be unlocked by any campaigns you participate in. All required activities in a course must be completed to be awarded the completion badge.