Want to learn the steps it takes to answer analytical questions build a dashboard like this? Check out the webinar recording above!
Preparing survey data for analysis in a data visualization tool is notoriously difficult. It's not as simple as being able to perform a single pivot or filter.
If you need to pivot data from a SQL table for use in Tableau, Tableau Desktop’s default pivot feature can’t help you.
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.
It’s more complicated than you think. Let me explain.
In my first sample data set I have just the two columns of data below and 365 rows, one for each day of 2018.
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.