If you’ve been using Tableau Desktop for a while you probably know that you can join, union and pivot data in the product. When you hear that Tableau Prep helps you “prepare your data” you might wonder what it can do that Desktop can’t.
All in Tableau Prep
If you’ve been using Tableau Desktop for a while you probably know that you can join, union and pivot data in the product. When you hear that Tableau Prep helps you “prepare your data” you might wonder what it can do that Desktop can’t.
You don’t.
Tableau Desktop will allow you to union multiple tables from the same database or even multiple .csv files, but you can’t union a table from SQL Server A with a tableau from SQL Server B.
Creating calculated fields in Tableau Prep is pretty straightforward. Editing them isn’t. The first time I wanted to edit a calculated field in the product I had a moment of hesitation.
Tableau Prep is a powerful tool but it can’t help solve every data preparation scenario. We focus a lot of our time and effort on what it can do, but we thought it would be worthwhile to cover what it can’t do (yet).
Tableau Prep is a great tool for dealing with messy or unorganized data. After understanding the basics, one of the first things I found myself wondering was “does Tableau Prep have the ability to unpivot data?”. It has a pivot feature but does not have an unpivot or transpose feature at this point. However, there is a workaround.