menu
arrow_back

Working with Cloud Dataprep on Google Cloud

search share 가입 로그인

Working with Cloud Dataprep on Google Cloud

1시간 크레딧 5개

This lab was developed with our partner, Trifacta. Your personal information may be shared with Trifacta, the lab sponsor, if you have opted-in to receive product updates, announcements, and offers in your Account Profile.

GSP050

Google Cloud Self-Paced Labs

Overview

Cloud Dataprep is Google's self-service data preparation tool built in collaboration with Trifacta. In this lab you will learn how to clean and enrich multiple datasets using Cloud Dataprep. The lab exercises are based on a mock use case scenario.

Use Case Scenario:

You work for a technical services company that sells three monthly subscription products:

  • Silver (price: $9.99/month)
  • Gold (price: $14.99/month)
  • Platinum (price: $29.99/month)

The company occasionally offers promotional discounts, so some product prices may be slightly lower than those listed above. Your overall goal is to provide an analysis of sales activity by zip code over the course of three years.

To do this you'll need to join your customer contact datasource (where the zip code information resides) with sales data from your purchases datasource. Once you've joined the data, you'll aggregate the results.

Objectives

In this lab, you will learn how to perform the following tasks:

  • Cleaning and profiling data with Cloud Dataprep

  • Combining multiple datasets using Cloud Dataprep

  • Computing the results of formulas in Cloud Dataprep

이 실습의 나머지 부분과 기타 사항에 대해 알아보려면 Qwiklabs에 가입하세요.

  • Google Cloud Console에 대한 임시 액세스 권한을 얻습니다.
  • 초급부터 고급 수준까지 200여 개의 실습이 준비되어 있습니다.
  • 자신의 학습 속도에 맞춰 학습할 수 있도록 적은 분량으로 나누어져 있습니다.
이 실습을 시작하려면 가입하세요