Share on LinkedIn Feed Twitter Facebook

Exploring and Preparing your Data with BigQuery

Exploring and Preparing your Data with BigQuery

magic_button SQL BigQuery
These skills were generated by A.I. Do you agree this course teaches these skills?
24 hours Introductory universal_currency_alt 16 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.

When you complete this course, you can earn the badge displayed here! 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!

Badge for Exploring and Preparing your Data with BigQuery
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, 日本語, español (Latinoamérica), français, and português (Brasil)
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.
Preview