In June, 2018 I wrote a blog post about three things Tableau Prep couldn’t do. One of those was the ability to transpose (unpivot) data. That is no longer the case. Tableau Prep Builder now gives you the capability to transpose rows of data into columns. Let’s look at an example.
In June, 2018 I wrote a blog post about three things Tableau Prep couldn’t do. One of those was the ability to transpose (unpivot) data. That is no longer the case.
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).