Tableau Best-practices: How to prepare your Tableau workbook to be efficient creating your dashboard

You wonder why professionals are so productive building their dashboards?

 

Efficient people in dashboarding take time to carefully prepare their data source and have a great clean workbook before starting building Data Visualizations.

Here-after, a must-do list to apply if you want to be efficient creating your dashboard:

 

1. Import only the data you need

When you are sourcing your workbook with data, just import the tables/sheets you need. It is counter-productive to think that the more can do the less. When you will need these additional tables, you will simply come back to the data source and import the data you need, when you need it.

 

2. Hide/Remove all the attributes you will not use in your dashboard

Please... How come can you be productive if your workbook contains 300 attributes from which you don't even know the meaning of 90% of them? Hide/Remove those fields!

Not only it will be easier for you to look for the meaningful attributes you need for but the performance of your dashboard will be significantly better!

Just to give a rough idea: Imagine you have 15 KPIs to analyze across 30 analytical axes? This is already a lot (even too much) no? Well, it's true. For such a case, you would need a maximum of 45 attributes in your workbook.

Just think of it and remove/hide:

  • The attributes which are not meaningful for your dashboard
  • The attributes for which you do not know how to leverage them
  • The attributes where the data quality is not good enough for analysis

 

3. Give a business name to all remaining attributes

In Tableau, the name of your attributes will be displayed as-is in your data visualizations. Do you really want to display technical names in your dashboard? Do you really want your users to love your dashboard when they have to remember then "VBRK.KUNNR" actually stands for "Client"? Don't you think that capitalizing all the attributes the same way would make a nicer dashboard? What about removing the "_" in the attribute names?

 

4. Organize your attributes in folders & hierarchies

It is always easier to find attributes is they are carefully arranged in folders/hierarchies. A folder for 'Customer' attributes, another for 'Product' attributes... Same approach for Measures, Parameters...

In addition to this, leveraging folders/hierarchies will facilitate the understanding of your data source for self-service users, the structure of the data will be easier to capture.

 

5. Correctly define which attribute is a Dimension, which attribute is a Measure

Even being a numeric, 'Year' is definitively a dimension. Same thing for 'Order #' or equivalent.

Take all your attributes one by one: is it an axis of analysis, or is it a metric I am happy to aggregate?

 

Efficient people are often lazy... 

 

1 minute spent preparing on the data source = 5 minutes saved creating the DataViz

 

 


You might also be interested by

LinPack for Tableau - DEMO

10 minutes demo of (happiness with) LinPack for Tableau :-)

Read more 
By Nicolas OuryOn November 25, 2019

Create your KPI Calculations in Tableau, automatically, for free!

Create your Tableau calculations for free with LinPack: do not spend time writing formulas, create amazing DataViz!

Read more 
By Nicolas OuryOn October 19, 2018

Aggregation rules in LinPack

When you create a Tableau dashboard in LinPack using 'Custom Configuration', you define your own KPIs using aggregation rules.

LinPack-for-Tableau enriches Tableau by providing you with built-in aggregation rules to easily compute your Headcount, the number of NEW customers you acquired or the Lifetime of your products.

Read more 
By Nicolas OuryOn June 12, 2018

Creating a KPI with LinPack

Creating a KPI with LinPack

Read more 
By Nicolas OuryOn November 22, 2017

Create dashboards with LinPack: Custom Configuration vs Business Template

LinPack offers you two efficient methods to create Tableau dashboards: 'Custom Configuration' vs 'Business Template'. This news is about explaining the difference between the two creation modes and in which cases you should use one or the other.

Read more 
By Nicolas OuryOn November 15, 2017