Exploring and Preparing your Data with BigQuery
Google Cloud and Google via Coursera
Overview
Class Central Tips
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.
>>> 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
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.
>>> 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
Syllabus
- 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
- 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
- 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
- Module 4: Google BigQuery Pricing
- Understand how pricing works in BigQuery and how you can best optimize your queries
- 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
Taught by
Google Cloud Training
Related Courses
-
Achieving Advanced Insights with BigQuery
-
Google Cloud Big Data and Machine Learning Fundamentals
3.0 -
Exploring and Preparing your Data with BigQuery 日本語版
-
Data Engineering, Big Data, and Machine Learning on GCP
-
Creating New BigQuery Datasets and Visualizing Insights
-
From Data to Insights with Google Cloud Platform
Reviews
4.0 rating, based on 1 reviews
-
I really like Google courses for their labs and real hands-on experience. If you're interested in basics of BigQuery, it's hard to imagine a better introduction. Nothing more here, but perfect as an entry-level course, explaining what's BQ and how it works. As Google tools evolve quickly, prepare for some minor differences, which may be a bit challenging here and there, if you don't know the tools.
Never Stop Learning!
