Cleaning & Analyzing Data in Tableau Prep Builder

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.