Об этом курсе: 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.
Для кого этот курс: 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.
Автор: Google Cloud
| Основные сведения | Course 1 of 4 in the From Data to Insights with Google Cloud Platform Specialization |
| Уровень | Beginner |
| Выполнение | 1 week of study, 5-7 hours/week |
| Язык | English |
| Требования к аппаратным средствам | You'll need a desktop web browser to run this course's interactive labs via Qwiklabs. |
| Как пройти курс | Чтобы пройти курс, выполните все оцениваемые задания. |
| Оценки пользователей |
Программа курса
НЕДЕЛЯ 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 видео
- Видео: Highlight Analytics Challenges Faced by Data Analysts
- Видео: Compare Big Data On-Premise vs on the Cloud
- Видео: Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud
- Видео: Navigate Google Cloud Platform Project Basics
- Видео: Lab 0 Overview
- LTI Item: Lab 0: Getting Started with Google Cloud Platform and Qwiklabs
- Видео: Lab 0 Review
Оцениваемый: 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 видео
- Видео: Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools
- Видео: Demo: Analyze 10 Billion Records with Google BigQuery
- Видео: Explore 9 Fundamental Google BigQuery Features
- Видео: Walkthrough: Data Architecture Diagram
- Видео: Compare GCP Tools for Analysts, Data Scientists, and Data Engineers
- Видео: Lab 1 Overview
- LTI Item: Lab 1: Exploring your Public Dataset with Google BigQuery
- Видео: Lab 1 Solution
Оцениваемый: 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 видео
- Видео: Compare Common Data Exploration Techniques
- Видео: Explore Real IRS Data
- Видео: Query Basics
- Видео: Intro to Functions
- Видео: Demo: Explore Schemas in the BigQuery UI
- Видео: Filters, Aggregates, and Duplicates
- Видео: Data Types, Date Functions, and NULLs
- Видео: Wildcard Filters with LIKE
- Видео: Lab 2 Overview
- LTI Item: Lab 2: Troubleshoot Common SQL Errors with BigQuery
- Видео: Lab 2 Solution
Оцениваемый: Module 3 Quiz
Module 4: Google BigQuery Pricing
Understand how pricing works in BigQuery and how you can best optimize your queries
8 видео
- Видео: Walkthrough of a BigQuery Job
- Видео: Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs
- Видео: Demo: Try out the Price Calculator
- Видео: Reserved Slots
- Видео: Query Validator, Quotas, and Common Pitfalls
- Видео: Optimize Queries for Cost
- Видео: Lab 3 Overview
- LTI Item: Lab 3: Calculating Google BigQuery Pricing
- Видео: Lab 3 Solution
Оцениваемый: 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 видео
- Видео: Examine the 5 Principles of Dataset Integrity
- Видео: Characterize Dataset Shape and Skew
- Видео: Clean and Transform Data using SQL
- Видео: Clean and Transform Data using a new UI: Introducing Cloud Dataprep
- Видео: Lab 4a Overview
- LTI Item: Lab 4a: Ingesting Datasets and Creating Flows with Cloud Dataprep
- Видео: Lab 4a Solution
- Видео: Walkthrough of Cloud Dataprep Features
- Видео: Lab 4b Overview
- LTI Item: Lab 4b: Exploring and Transforming Data with Cloud Dataprep
- Видео: Lab 4b Solution
Оцениваемый: Module 5 Quiz
Часто задаваемые вопросы
Как это работает
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.
Авторы
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.
Стоимость
| Приобрести курс | |
|---|---|
| Получить доступ к материалам курса | Доступен |
| Получить доступ к оцениваемым материалам курса | Доступен |
| Получить итоговую оценку | Доступен |
| Earn a shareable Course Certificate | Доступен |
Рейтинги и отзывы
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 делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
FD
Issues with user credentials through labs