Tableau Prep is a new desktop application (released spring, 2018) provided by Tableau to assist with complex data preparation.
One of the frustrating data formats that can make data unusable in Tableau is report-formatted spreadsheet that have headers with following blanks.
Working with milliseconds in Tableau is tricky. While Tableau does technically handle milliseconds, they aren’t as flexible as other date units like days and hours.
Sets and Groups are two distinct ways of creating predefined subsets of data in Tableau. While they seem similar at a high level, they have some significant differences.
Storytelling is about creating a shared experience. It means listening to where people are and what they are seeking. When we use this approach for our dashboard delivery, it creates a shared solution.
As Steve Jobs shared, “… [Design] is not just what it looks like and feels like. Design is how it works.”
Imagine you are working in Tableau and want to create a worksheet that compares performance this quarter to date to performance last quarter to date. Depending on the visuals you’d like to create, you’ll likely need to create a calculated field for this to work properly.
We all have to make decisions in life. Some of those decisions are small and have minimal impact (e.g. What should I wear to work?), but some of those decisions have significant, long-term impact.
Have you gotten the error “All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources” in Tableau?
Data scaffolding allows you to generate missing data for visualization purposes.
I’ve seen several examples of people turning their resumes into Tableau dashboards recently and I wanted to try my hand at it and write a blog post about the process.
Imagine you are working with a data set in Tableau that displays minutes and seconds in decimals. For instance, 1.5 would be reflective of 1 minute and 30 seconds…
Imagine you work for a company that sells products but not in every market. Because you don’t sell certain products in given markets, you have null values in your data.
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.
Working with data that isn’t clean can be a pain. One of the most frequent data issues I come across is dealing with duplicated rows of data.