Google Cloud Skills Boost

Transform and Clean your Data with Dataprep by Alteryx on Google Cloud

8 hours Intermediate universal_currency_alt 22 Credits
Dataprep is Google's self-service data preparation tool built in collaboration with Alteryx. Learn the basics of cleaning and preparing data for analysis and visualization, all in the Google ecosystem. In this quest, you will learn how to connect Dataprep to your data in Cloud Storage and BigQuery, clean data using the interactive UI, profile the data, and publish your results back into the Google ecosystem. You will learn the basics of data transformation, including filtering values, reshaping the data, combining multiple datasets, deriving new values, and aggregating your dataset.
Badge for Transform and Clean your Data with Dataprep by Alteryx on Google Cloud

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

  • Lab

    Working with Cloud Dataprep on Google Cloud

    Cloud Dataprep is Google's self-service data preparation tool. In this lab, you will learn how to use Cloud Dataprep to clean and enrich multiple datasets using a mock use case scenario of customer info and purchase history.

    1 hour
    Introductory
    1 Credit
    language
    • English
    • español (Latinoamérica)
    • français
    • 日本語
    • português (Brasil)
  • Lab

    Preparing and Aggregating Data for Visualizations using Cloud Dataprep

    Dataprep by Alteryx is Google's self-service data preparation tool built in collaboration with Alteryx. In this lab you will learn some more advanced techniques with Dataprep.

    1 hour 20 minutes
    Introductory
    1 Credit
  • Lab

    warning Creating Advanced Data Transformations using Cloud Dataprep

    In this lab, you will build upon a previous flow and learn some advanced tactics for preparing data.

    1 hour 30 minutes
    Intermediate
    5 Credits
  • Lab

    Automating your BigQuery Data Pipeline with Cloud Dataprep

    In this lab, you will examine how Dataprep can be used on complicated data structures in BigQuery.

    1 hour 30 minutes
    Intermediate
    5 Credits
  • Lab

    Self Service ML Pipelines Using Dataprep and AutoML Tables

    In this lab you will learn how to use Dataprep in conjunction with AutoML Tables to build and operate your machine learning pipelines.

    1 hour 30 minutes
    Intermediate
    5 Credits
  • Lab

    Creating a Data Transformation Pipeline with Cloud Dataprep

    Cloud Dataprep by Alteryx is an intelligent data service for visually exploring, cleaning, and preparing structured and unstructured data for analysis. In this lab you will explore the Cloud Dataprep UI to build a data transformation pipeline.

    1 hour
    Intermediate
    5 Credits
    language
    • English
    • español (Latinoamérica)
    • français
    • 日本語
    • português (Brasil)
    • info
    Quest Info
    Objectives
    • Understand what is Data Preparation for modern analytics
    • How Dataprep is positioned in the Google Cloud Smart Analytics Suite
    • Assess data quality with Dataprep Profiling
    • Transform, filter, reshape, combine, calculate, aggregate data visually
    • Schedule Dataprep jobs to transform data for BigQuery
    Available languages
    English
    What do I do when I finish this quest?
    After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.
    What badges can I earn?
    Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.