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.
You might never have heard of a self join but you might need one. Occasionally, tables in a database are structured so that it makes sense to join a copy of a table to itself…
Sometimes you need to use data in Tableau that isn’t in a clean, denormalized format. It might have been exported from an application or prepared by a coworker in a way that Tableau doesn’t like.
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.
You might have heard a lot of noise about the new Tableau Prep product that just released.
Newsflash: You automatically get it with your Tableau Desktop license
Wondering what all the hoopla is about? Watch the webinar below to learn the 3 key things you need to know about the product and how it can save you weeks in your data communication efforts.
Imagine you are living your best life and run a company that owns an ice cream parlor and a chocolate store. You have data for both companies that looks like this:
If you’re ever refreshed an updated Excel file in Tableau and noticed that your data didn’t change, this write-up is for you. The main issue is that when you save your Tableau Workbook as a .twbx packaged workbook file, it will often package the Excel file in a temporary file structure so that it can be easily shipped along with the workbook when shared.