Coursera
Catalog
  • Browse
  • Search
  • For Enterprise
  • Log In
  • Sign Up

Exploring ​and ​Preparing ​your ​Data with BigQuery

OverviewSyllabusFAQsCreatorsPricingRatings and Reviews

HomeInformation TechnologyData Management

Exploring ​and ​Preparing ​your ​Data with BigQuery

Google Cloud

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
Google Cloud
Basic Info
Course 1 of 4 in the From Data to Insights with Google Cloud Platform Specialization
LevelBeginner
Commitment1 week of study, 5-7 hours/week
Language
English
Hardware ReqYou'll need a desktop web browser to run this course's interactive labs via Qwiklabs.
How To PassPass all graded assignments to complete the course.
User Ratings
4.6 stars
Average User Rating 4.6See what learners said
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
  1. Video: Introduction: From Data to Insights with Google Cloud Platform 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
  1. Video: Highlight ​Analytics ​Challenges ​Faced ​by ​Data ​Analysts
  2. Video: Compare ​Big ​Data ​On-Premise ​vs ​on ​the ​Cloud
  3. Video: Learn ​from ​Real-World ​Use ​Cases ​of ​Companies ​Transformed ​through Analytics ​on ​the ​Cloud
  4. Video: Navigate ​Google ​Cloud ​Platform ​Project ​Basics
  5. Video: Lab 0 Overview
  6. LTI 项目: Lab 0: Getting Started with Google Cloud Platform and Qwiklabs
  7. 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
  1. Video: Walkthrough ​Data ​Analyst ​Tasks, ​Challenges, ​and ​Introduce ​Google Cloud ​Platform ​Data ​Tools
  2. Video: Demo: ​Analyze ​10 ​Billion ​Records ​with ​Google ​BigQuery
  3. Video: Explore ​9 ​Fundamental ​Google ​BigQuery ​Features
  4. Video: Walkthrough: Data Architecture Diagram
  5. Video: Compare ​GCP ​Tools ​for ​Analysts, ​Data ​Scientists, ​and ​Data ​Engineers
  6. Video: Lab 1 Overview
  7. LTI 项目: Lab 1: Exploring your Public Dataset with Google BigQuery
  8. 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
  1. Video: Compare Common Data Exploration Techniques
  2. Video: Explore Real IRS Data
  3. Video: Query Basics
  4. Video: Intro to Functions
  5. Video: Demo: Explore Schemas in the BigQuery UI
  6. Video: Filters, Aggregates, and Duplicates
  7. Video: Data Types, Date Functions, and NULLs
  8. Video: Wildcard Filters with LIKE
  9. Video: Lab 2 Overview
  10. LTI 项目: Lab 2: Troubleshoot Common SQL Errors with BigQuery
  11. 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
  1. Video: Walkthrough of a BigQuery Job
  2. Video: Calculate ​BigQuery ​Pricing: ​Storage, ​Querying, ​and ​Streaming ​Costs
  3. Video: Demo: Try out the Price Calculator
  4. Video: Reserved Slots
  5. Video: Query Validator, Quotas, and Common Pitfalls
  6. Video: Optimize ​Queries ​for ​Cost
  7. Video: Lab 3 Overview
  8. LTI 项目: Lab 3: Calculating Google BigQuery Pricing
  9. 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
  1. Video: Examine ​the ​5 ​Principles ​of ​Dataset ​Integrity
  2. Video: Characterize ​Dataset ​Shape ​and ​Skew
  3. Video: Clean ​and ​Transform ​Data ​using ​SQL
  4. Video: Clean ​and ​Transform ​Data ​using ​a ​new ​UI: ​Introducing ​Cloud ​Dataprep
  5. Video: Lab 4a Overview
  6. LTI 项目: Lab 4a: Ingesting Datasets and Creating Flows with Cloud Dataprep
  7. Video: Lab 4a Solution
  8. Video: Walkthrough of Cloud Dataprep Features
  9. Video: Lab 4b Overview
  10. LTI 项目: Lab 4b: Exploring and Transforming Data with Cloud Dataprep
  11. 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
Rated 4.6 out of 5 of 175 ratings

FD

Issues with user credentials through labs

BM

Fun introduction. Thanks Evans!

Héctor Noel Chacón Salazar

excelent

JR

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.



You May Also Like
Google Cloud
Achieving Advanced Insights with BigQuery
1 course
Google Cloud
Achieving Advanced Insights with BigQuery
View course
Google Cloud
Creating New BigQuery Datasets and Visualizing Insights
1 course
Google Cloud
Creating New BigQuery Datasets and Visualizing Insights
View course
Google Cloud
Applying Machine Learning to your Data with GCP
1 course
Google Cloud
Applying Machine Learning to your Data with GCP
View course
Google Cloud
Securing and Integrating Components of your Application
1 course
Google Cloud
Securing and Integrating Components of your Application
View course
Google Cloud
Getting Started With Application Development
1 course
Google Cloud
Getting Started With Application Development
View course
Coursera
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.
Download on the App StoreGet it on Google Play
  • Coursera
  • About
  • Leadership
  • Careers
  • Catalog
  • Certificates
  • Degrees
  • For Business
  • For Government
  • Community
  • Partners
  • Mentors
  • Translators
  • Developers
  • Beta Testers
  • Connect
  • Blog
  • Facebook
  • LinkedIn
  • Twitter
  • Google+
  • Tech Blog
  • More
  • Terms
  • Privacy
  • Help
  • Accessibility
  • Press
  • Contact
  • Directory
  • Affiliates