I frequently hear the question, “Can Tableau show my missing data?”. Generally when I get this question, people want to either see a 0 or a blank where there should be missing data.
When embarking on a data communication project, you might not always have all the data you need to create a prototype in a timely manner. I often generate realistic, placeholder data sources so I can design a dashboard and get feedback, even if the actual data isn’t ready for display yet.
Have you ever found that Tableau Desktop took a long time to load a worksheet or apply a filter? You might have found yourself wondering “Is my data source too large for Tableau?” The answer is…“maybe”.
Yes, but it takes some wrangling. Unlike Alteryx, there is no “fuzzy match” tool in Tableau Prep, but there is a method you can employ which will help (though, like all fuzzy matching, it isn’t perfect).
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.
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).
If you're like most people in the world of analytics you spend 90% of time cleaning and preparing data and the last 10% recovering from the effort. Not anymore!
Join us for 30 minutes to look at how you can use Tableau Prep to clean dirty data and save hours each week.
Interested in the workshop mentioned in the video? Register for the Tableau Prep Foundations workshop here!
Need help on a personal project? Register for an office hour and we'll get you sorted!
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.