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.
Tableau is usually the last 20% of any data communication effort. What is the first 80%? This document is meant to provide an example of what the finished output of data preparation for Tableau should look like.
After scouring the internet, I couldn’t find a good reference for beginners on how to prepare your data for Tableau so I figured, it looks like I’m going to have to do this myself! This is meant to be an introductory guide only, if you have more detailed questions feel free to send me an email.