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.
Tableau Prep Builder: Cleaning & Analyzing Data