About this course: >>> By enrolling in this specialization you agree to the Qwiklabs Terms of Service as set out in the FAQ and located at: https://qwiklabs.com/terms_of_service <<< Welcome to the Coursera specialization, From Data to Insights with Google Cloud Platform brought to you by the Google Cloud team. I’m Evan Jones (a data enthusiast) and I’m going to be your guide. 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. This course should take about one week to complete, 5-7 total hours of work. By the end of this course, you’ll be able to query and draw insight from millions of records in our BigQuery public datasets. You’ll learn how to assess the quality of your datasets and develop an automated data cleansing pipeline that will output to BigQuery. Lastly, you’ll get to practice writing and troubleshooting SQL on a real Google Analytics e-commerce dataset to drive marketing insights.
Who is this class for: This is course is primarily aimed at new Data Analysts, Business Analysts, and Business Intelligence professionals. It is also intended for Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform. Note that this first course has a module on SQL basics that will be serve as a review for those already familiar with the language.
| Basic Info | Course 1 of 4 in the From Data to Insights with Google Cloud Platform Specialization |
| Level | Beginner |
| Commitment | 1 week of study, 5-7 hours/week |
| Language | English |
| Hardware Req | You'll need a desktop web browser to run this course's interactive labs via Qwiklabs. |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
- Video: Compare Big Data On-Premise vs on the Cloud
- Video: Real-World Use Cases
- Video: Navigate Google Cloud Platform Project Basics
- Video: Demo: BigQuery Tips and Tricks on Public Datasets
- Video: Explore 9 Fundamental Google BigQuery Features
- Video: Walkthrough: Data Architecture Diagram
- Video: Compare GCP Tools for Analysts, Data Scientists, and Data Engineers
- Video: Meet Qwiklabs, your on-demand labs platform
- Video: Lab Walkthrough - Explore Ecommerce Data and Identifying Duplicates
- Video: Lab Walkthrough - Practice Basic SQL on Ecommerce Data
- Video: Challenge 1 Solution - Calculating Conversion_Rate
- Video: Challenge 2 Solution - Track Visitor Checkout Progress
- Video: Challenge 3 Solution - Track Abandoned Carts
- Video: Demo: Beyond the BigQuery Web UI
- Discussion Prompt: Brainstorm Ecommerce Questions
- Video: Compare Common Data Exploration Techniques
- Reading: IRS Public Dataset Overview
- Video: Query Basics
- Video: Intro to Functions
- Video: Demo: Explore Schemas in the BigQuery UI
- Video: Filters, Aggregates, and Duplicates
- Video: Data Types, Date Functions, and NULLs
- Video: Wildcard Filters with LIKE
- Video: Lab Walkthrough - Enable Standard SQL
- Video: Lab Walkthrough - Query Validator, Aliases, and Commas
- Video: Lab Walkthrough - Logical Errors, Group Bys, Wildcard Filters
- Video: Lab Walkthrough - Ordering, Calculated fields, Filtering after Aggregating
- Video: Lab Walkthrough - Finding top selling products, Filtering NULLs
- Video: Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs
- Video: Demo: Try out the Price Calculator
- Video: Reserved Slots
- Video: Query Validator, Quotas, and Common Pitfalls
- Video: Optimize Queries for Cost
- Video: Lab 3 Overview
- LTI Item: Lab 3: Calculating Google BigQuery Pricing
- Video: Lab 3 Solution
- Video: Characterize Dataset Shape and Skew
- Video: Clean and Transform Data using SQL
- Video: Clean and Transform Data using a new UI: Introducing Cloud Dataprep
- Video: Demo: CloudDataprep on Ecommerce Dataset
- Video: Lab Walkthrough - Connecting BigQuery data to Cloud Dataprep
- Video: Lab Walkthrough - Exploring Ecommerce Data Fields and Values with a UI
- Video: Lab Walkthrough - Building Data Transformation Recipes with a UI
- Video: Lab Walkthrough - Running and Scheduling Dataprep Jobs to BigQuery
- Video: Course Summary
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
I found the course extremely useful and very well structured. The trainer was excellent in terms of knowledge, communication and importantly making the topics very practical and bringing alive concepts with real life examples. The Lab format is extremely helpful for learning by doing making the learning process highly involved and almost simulating real life experiences on the job. Congratulations to the trainer and the backend team for bringing together this excellent course and I am looking forward to completing the remaining courses as soon as possible.
Great course !
Very, very interesting. Dataprep is a wonder tool, thanks.
a
More hands-on use case scenario could be given. The lab is very complete and helpful in coaching beginner on using GCP