If you have a data set that updates irregularly, figuring out how to filter to show only the latest data is difficult. Relative Date Filters are great but only work well if you have a set time you are filtering to like “today” or “yesterday”. If your latest data could be today, yesterday, or two days ago depending on the refresh schedule, things get trickier.
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.
Yes, you can! Check out the image below for an example.
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.
Complex data questions are hard to answer with simple visuals. When questions have multiple components, a single graph may not be enough. For instance, imagine you have a table of data displaying average daily high temperatures by month that looks like this:
If you've ever tried to compare part of your data to the whole in Tableau (and give your users flexibility to change the view), you might think it's not possible. Check out the video blog above to learn about an innovative solution a client and I developed to solve this problem.
Let’s say you want to compare a value from today to the same day last year to evaluate performance…
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).
Joins can be a sticky business, especially if…
● You haven’t used them much before.
● You are working with data that is new to you.
● You don’t trust your data cleanliness.