One of the features of Tableau prep is that you can see your data transformation in action immediately before running the workflow. Each step in the workflow will immediately show you the results – so that you can validate your process on the fly.
Another great feature is the visual representation of your data in the Profile pane. This makes it easy for you to distinctly look at data at the record level. Clicking on a data point will highlight other associated fields in the other columns to give you an idea about the data connection made.
The transformation steps are extensive and very quick to give results. You can easily change data types, trim spaces, change cases of string fields, group values, pivot data and also perform calculations. These calculations follow the language we use for calculated fields in Tableau Desktop – so it’s pretty easy and familiar.
One of the new WOW features that Tableau Prep provides is their fuzzy matching of similar fields. Tableau Prep uses a phonetic algorithm to index words using their pronunciation. This is extremely helpful in combining several common names in a column that are listed separately due to a spelling issue or non-standarized naming.