Tableau Prep: The Good, the Bad, and the Ugly

prep error


Since my last blog, I have used Tableau Prep 2018.2 to clean five different datasets so I think it’s a good time to discuss the good, the bad and the ugly of Prep…


The Good

As with Tableau Desktop, Prep is pretty. Compared to Alteryx, it looks modern, clean and is just overall, aesthetically pleasing. The user interface is friendly and intuitive. Who doesn’t love a good ol’ drag and drop? I mean, we love Tableau Desktop right?

Unlike Alteryx, Prep lets you actually interact with your data as you would in Desktop. I personally love being able to do this.

Tableau Prep has some great built-in features for data cleansing. It’s easy as pie to split fields as you would in Alteryx with Text to Columns. It’s easy to remove whitespace and change the case of your fields (note: you can only change the case of the whole string, not title cases).

Another super useful function is the Pronunciation Group and Replace. Take a look at Figure 1, you can see that ‘Growlith’ should be spelt like ‘Growlithe’. You could click on ‘Growlith’ and type the ‘e’ manually or… you could use Pronunciation as seen in Figure 1. Doing this groups the two terms together under ‘Growlithe’ (denoted by the paperclip icon).

Figure 1. Demonstration of Pronunciation Group and Replace


Amazing right? Yes, but there are limitations. This segways us nicely into…

Click to keep reading!