About this course: 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. 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.
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.
Created by: Google Cloud
| 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 |
Syllabus
WEEK 1
Welcome to From Data to Insights with Google Cloud Platform: Exploring and Preparing your Data
Learn the courses, content, and technologies that are part of this data analyst specialization
1 video
Module 1: Introduction to Data on Google Cloud Platform
Understand the core principles behind Google Cloud Platform and how to leverage them for big data analysis
4 videos
- Video: Compare Big Data On-Premise vs on the Cloud
- Video: Real-World Use Cases
- Video: Navigate Google Cloud Platform Project Basics
Graded: Module 1 Quiz
Module 2: Big Data Tools Overview
Learn what are the key big data tools on Google Cloud Platform that you will be using to analyze, prepare, and visualize data
12 videos
- 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
Graded: Lab 1: Exploring your Public Dataset with Google BigQuery
Graded: Module 2 Quiz
Module 3: Exploring your Data with SQL
Learn how to query your data with the basics of SQL (Structured Query Language) and practice writing queries in BigQuery
13 videos, 1 reading
- 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
Graded: Lab: Troubleshooting Common SQL Errors with Google BigQuery
Graded: Module 3 Quiz
Module 4: Google BigQuery Pricing
Understand how pricing works in BigQuery and how you can best optimize your queries
8 videos
- 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
Graded: Module 4 Quiz
Module 5: Cleaning and Transforming your Data
Understand the importance of creating high quality datasets and learn the tools that will help you transform your data
10 videos
- 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
Graded: Lab: Explore and Create an Ecommerce Analytics Pipeline with Cloud Dataprep
Graded: Module 5 Quiz
FAQs
How It Works
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
Google Cloud
We help millions of organizations empower their employees, serve their customers, and build what’s next for their businesses with innovative technology created in—and for—the cloud. Our products are engineered for security, reliability, and scalability, running the full stack from infrastructure to applications to devices and hardware. Our teams are dedicated to helping customers apply our technologies to create success.
Pricing
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
Ratings and Reviews
Coursera provides universal access to the world’s best education,
partnering with top universities and organizations to offer courses online.
© 2018 Coursera Inc. All rights reserved.
