Cleaning & Analyzing Data in Tableau Prep Builder

Tableau Prep Builder
  • 10 Videos | 47m 16s
  • Includes Assessment
  • Earns a Badge
Likes 26 Likes 26
Tableau Prep Builder is all about preparing your data source and getting it ready for deeper analysis. In this 10-video course, learners will discover how to perform a variety of different operations, including clean-up steps, data aggregation, and split, group, and replacement actions. You will begin by exploring steps involved in applying cleaning operations by using Tableau Prep Builder, then learning how to use the Split tools to separate values into new fields. Discover how to perform manual group and replace operations by editing individual data values and selecting multiple similar values; how to use the group and replace fuzzy match tools; and how to create and apply custom data roles to clean data quickly. Explore how to insert Aggregate steps to aggregate, group, or summarize data; insert an Aggregate step to remove exact data set duplicates, and insert calculated fields into a flow. The course concludes by demonstrating how to create calculated fields with regular expressions, then showing steps involved in extending the functionality of Tableau Prep Builder via Python or R scripts.

WHAT YOU WILL LEARN

  • demonstrate the steps involved in applying cleaning operations using Tableau Prep Builder
    use the Split tools to separate values into new fields
    perform manual group and replace operations by editing individual data values and selecting multiple similar values
    use fuzzy match group and replace tools in Tableau Prep Builder, including group by pronunciation, spelling, and common characters
    create and apply custom data roles to clean data quickly
  • insert Aggregate steps to aggregate, group, or summarize data
    insert an Aggregate step to remove exact duplicates in dataset
    insert calculated fields into a flow
    create calculated fields using regular expressions
    demonstrate the steps involved in extending the functionality of Tableau Prep Builder via Python or R scripts

IN THIS COURSE

  • Playable
    1. 
    Using the clean-up tools
    4m 22s
    UP NEXT
  • Playable
    2. 
    Splitting fields
    4m 42s
  • Locked
    3. 
    Performing manual group & replace operations
    5m 11s
  • Locked
    4. 
    Using the Group & Replace fuzzy match tools
    4m 3s
  • Locked
    5. 
    Creating custom data roles to clean data
    5m 48s
  • Locked
    6. 
    Using data aggregation steps
    3m 35s
  • Locked
    7. 
    Removing duplicate data in Tableau Prep Builder
    3m 38s
  • Locked
    8. 
    Working with calculated fields
    4m 44s
  • Locked
    9. 
    Using regular expressions in calculated fields
    3m 35s
  • Locked
    10. 
    Working with scripts in Tableau Prep
    2m 38s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE