Coursera
Изучить
  • Обзор
  • Поиск
  • Для организаций
  • Войти
  • Зарегистрироваться

Exploring ​and ​Preparing ​your ​Data with BigQuery

ОбзорПрограмма курсаЧасто задаваемые вопросыАвторыСтоимостьРейтинги и отзывы

ГлавнаяИнформационные технологииУправление данными

Exploring ​and ​Preparing ​your ​Data with BigQuery

Google Cloud

Об этом курсе: 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
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.
Как пройти курсЧтобы пройти курс, выполните все оцениваемые задания.
Оценки пользователей
4.6 звезды
Средняя оценка пользователей: 4.6Посмотрите, что пишут учащиеся
Программа курса
НЕДЕЛЯ 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 видео
  1. Видео: 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 видео
  1. Видео: Highlight ​Analytics ​Challenges ​Faced ​by ​Data ​Analysts
  2. Видео: Compare ​Big ​Data ​On-Premise ​vs ​on ​the ​Cloud
  3. Видео: Learn ​from ​Real-World ​Use ​Cases ​of ​Companies ​Transformed ​through Analytics ​on ​the ​Cloud
  4. Видео: Navigate ​Google ​Cloud ​Platform ​Project ​Basics
  5. Видео: Lab 0 Overview
  6. LTI Item: Lab 0: Getting Started with Google Cloud Platform and Qwiklabs
  7. Видео: 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 видео
  1. Видео: Walkthrough ​Data ​Analyst ​Tasks, ​Challenges, ​and ​Introduce ​Google Cloud ​Platform ​Data ​Tools
  2. Видео: Demo: ​Analyze ​10 ​Billion ​Records ​with ​Google ​BigQuery
  3. Видео: Explore ​9 ​Fundamental ​Google ​BigQuery ​Features
  4. Видео: Walkthrough: Data Architecture Diagram
  5. Видео: Compare ​GCP ​Tools ​for ​Analysts, ​Data ​Scientists, ​and ​Data ​Engineers
  6. Видео: Lab 1 Overview
  7. LTI Item: Lab 1: Exploring your Public Dataset with Google BigQuery
  8. Видео: 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 видео
  1. Видео: Compare Common Data Exploration Techniques
  2. Видео: Explore Real IRS Data
  3. Видео: Query Basics
  4. Видео: Intro to Functions
  5. Видео: Demo: Explore Schemas in the BigQuery UI
  6. Видео: Filters, Aggregates, and Duplicates
  7. Видео: Data Types, Date Functions, and NULLs
  8. Видео: Wildcard Filters with LIKE
  9. Видео: Lab 2 Overview
  10. LTI Item: Lab 2: Troubleshoot Common SQL Errors with BigQuery
  11. Видео: 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 видео
  1. Видео: Walkthrough of a BigQuery Job
  2. Видео: Calculate ​BigQuery ​Pricing: ​Storage, ​Querying, ​and ​Streaming ​Costs
  3. Видео: Demo: Try out the Price Calculator
  4. Видео: Reserved Slots
  5. Видео: Query Validator, Quotas, and Common Pitfalls
  6. Видео: Optimize ​Queries ​for ​Cost
  7. Видео: Lab 3 Overview
  8. LTI Item: Lab 3: Calculating Google BigQuery Pricing
  9. Видео: 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 видео
  1. Видео: Examine ​the ​5 ​Principles ​of ​Dataset ​Integrity
  2. Видео: Characterize ​Dataset ​Shape ​and ​Skew
  3. Видео: Clean ​and ​Transform ​Data ​using ​SQL
  4. Видео: Clean ​and ​Transform ​Data ​using ​a ​new ​UI: ​Introducing ​Cloud ​Dataprep
  5. Видео: Lab 4a Overview
  6. LTI Item: Lab 4a: Ingesting Datasets and Creating Flows with Cloud Dataprep
  7. Видео: Lab 4a Solution
  8. Видео: Walkthrough of Cloud Dataprep Features
  9. Видео: Lab 4b Overview
  10. LTI Item: Lab 4b: Exploring and Transforming Data with Cloud Dataprep
  11. Видео: Lab 4b Solution
Оцениваемый: Module 5 Quiz

Часто задаваемые вопросы
Как это работает
Coursework
Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from Your Peers
Help from Your Peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates
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

Доступен

Рейтинги и отзывы
Оценка 4.6 из 5 по 178 отзывам

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.



Вас также могут заинтересовать
Google Cloud
Achieving Advanced Insights with BigQuery
1 курс
Google Cloud
Achieving Advanced Insights with BigQuery
Просмотреть курс
Google Cloud
Creating New BigQuery Datasets and Visualizing Insights
1 курс
Google Cloud
Creating New BigQuery Datasets and Visualizing Insights
Просмотреть курс
Google Cloud
Applying Machine Learning to your Data with GCP
1 курс
Google Cloud
Applying Machine Learning to your Data with GCP
Просмотреть курс
Google Cloud
Securing and Integrating Components of your Application
1 курс
Google Cloud
Securing and Integrating Components of your Application
Просмотреть курс
Google Cloud
Getting Started With Application Development
1 курс
Google Cloud
Getting Started With Application Development
Просмотреть курс
Coursera
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
Загрузить из App StoreЗагрузить в Google Play
  • Coursera
  • О проекте
  • Руководство
  • Карьера
  • Каталог
  • Сертификаты
  • Степени
  • Для бизнеса
  • Для правительственных организаций
  • Сообщество
  • Партнеры
  • Наставники
  • Переводчики
  • Разработчики
  • Бета-тестировщики
  • На связи
  • Блог
  • Facebook
  • LinkedIn
  • Twitter
  • Google+
  • Технический блог
  • Еще
  • Условия
  • Конфиденциальность
  • Помощь
  • Доступность
  • Пресса
  • Контакты
  • Справочник
  • Филиалы