Not only is Tableau a great data analysis tool, it’s also really useful for data discovery. One of the helpful ways you can use Tableau is to uncover inconsistencies and holes in your data structure. I do this by finding out what data unexpectedly has null values.
Whenever I see a null indicator like in the below image, I start digging into the data:
Investigating the Nulls
1. Start by creating a new worksheet and pulling a measure onto Rows.
2. After placing the measure, use the dropdown to change it to be both a Dimension and Discrete.
If there is null data, “Null” will automatically sort to the top of the headers after doing this.
3. Add the Number of Records measure to Text on the Marks card.
4. Right-click on the records listed after Null and investigate.
Need more help? Please contact us at firstname.lastname@example.org.