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
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
6 videos
- Video: Highlight Analytics Challenges Faced by Data Analysts
- Video: Compare Big Data On-Premise vs on the Cloud
- Video: Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud
- Video: Navigate Google Cloud Platform Project Basics
- Video: Lab 0 Overview
- LTI 项目: Lab 0: Getting Started with Google Cloud Platform and Qwiklabs
- Video: Lab 0 Review
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
7 videos
- Video: Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools
- Video: Demo: Analyze 10 Billion Records with Google BigQuery
- Video: Explore 9 Fundamental Google BigQuery Features
- Video: Walkthrough: Data Architecture Diagram
- Video: Compare GCP Tools for Analysts, Data Scientists, and Data Engineers
- Video: Lab 1 Overview
- LTI 项目: Lab 1: Exploring your Public Dataset with Google BigQuery
- Video: Lab 1 Solution
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
10 videos
- Video: Compare Common Data Exploration Techniques
- Video: Explore Real IRS Data
- 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 2 Overview
- LTI 项目: Lab 2: Troubleshoot Common SQL Errors with BigQuery
- Video: Lab 2 Solution
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: Walkthrough of a BigQuery Job
- 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 项目: 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
9 videos
- Video: Examine the 5 Principles of Dataset Integrity
- 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: Lab 4a Overview
- LTI 项目: Lab 4a: Ingesting Datasets and Creating Flows with Cloud Dataprep
- Video: Lab 4a Solution
- Video: Walkthrough of Cloud Dataprep Features
- Video: Lab 4b Overview
- LTI 项目: Lab 4b: Exploring and Transforming Data with Cloud Dataprep
- Video: Lab 4b Solution
Graded: Module 5 Quiz
FAQs
How It Works
课程作业
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
来自同学的帮助
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
证书
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
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
Fun introduction. Thanks Evans!
excelent
i had trouble with the dataprep section of the course due to "data prep" not actually loading. That said, the walk through was enough to for me to actually study and get knowledge from the section i missed due to the malfunction of Dataprep.
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.
FD
Issues with user credentials through labs