Introduction to Treemap in Tableau
Treemap in Tableau is used to display Rectangle boxes. Data has a weird story, it plays a very crucial role yet organizations (aka users) find themselves at a position where possibilities to explore and interpret these data in a better way was felt. The bottom line remains the same for every user. Charts are one of the crucial tools to interpret the data in a meaningful manner (using any number of tools).
The existence of a different variety of charts around us gives a litter exposure regarding how complex data can be. As a user, we need to filter our need in terms of data suitable to a particular type of charts. Today’s title for discussion is “Treemap” charts in Tableau. Let us begin and see what possibilities the Treemap chart unlocks for its users while manipulating a dataset.
Treemap charts are very simple in structure, you can say a pile of blocks or rectangle clubbed on top of others.
Benefits of Treemap in Tableau
- This chart works really well for big amount of data. When the data increases it also increases the problem of understanding it. There is no such problem with Treemap charts as the related labels are associated with the data it represents.
- Treemap charts are really effective practice when you want to communicate and consume a good number of marks on a single view. With this crucial behavior, a user can easily spot patterns and relationships between them otherwise not possible.
- The hierarchical data representation technique nested on a tree-like structure.
Use Case of Treemap in Tableau
A tool/practice/technique holds its importance in a similar sense when to use it is equally important to know. Since very chart has a working range, let us see where a Treemap chart holds their importance and how –
- Only when you have to work on any two quantitative values.
- Only when you have a very huge hierarchical data with space to decide.
- If you are looking to obtain a quick and high-level summary for the anomalies and similarities within one and multiple categories of working data.
Process in Treemap in Tableau
We will construct a treemap chart that will depict no profit and no sales that happen in certain years With related profit Rations.
For this, we need the following data
- Year of Order
- No of sales
- Profit ratios
This is how a blank tableau dashboard looks like, as a user we have to connect the tableau application to a dataset. Refer to the below-mentioned screens.
You can see in the main section (black area) that has a ‘Superstore’ dataset which comes preinstalled with the application. We will work on this dataset to construct a Treemap chart.
Click on the Sample Superstore dataset, and you will get a screen like shown below –
Sample Superstore is loaded completely, at the bottom of the screen we can see multiple tabs are listed which are the content of the data set. These are a kind of reference charts for working data. Now, we will make our own Treemap chart, once we make a fresh worksheet on the dashboard you will get a screen like below –
Note – A Treemap chart considers and works only on two-dimensional data. We can see in the above screen on the left-hand side there is ‘Dimension’, ‘Measures’ and ‘Parameters’ sections. All these hold different forms of data or data measuring techniques. If you see the below screen, you will get to know for a Treemap chart we need at least 1 dimension and at least 2 measures.
Our next task is to drag and drop data from the Dimension and Measure section. From here the actual chart creation begins.
We want our chart to have YEAR and REGIONAL details at base. So, we drag and drop the Region and Year of Order date to ‘Text’. Once we do this we will get the below screen.
In the above image of Treemap in Tableau, we can clearly see the Regional details (like Central/East/South/West) and Year of order details (like 2014, 2015….2017).
Now we will add the Sales details to the chart by drag and drop ‘Sales’ to the ‘Size’ section (present under the Marks). Refer to the below mentioned screen.
With this we will now add the ‘Profit’ into the chart, the chart will then show the profits earned forgiven no of sales in a particular region over a certain period of time.
This is the foundation of a Treemap chart, but we want to sort the profit as per the colors. For this, we have to drag and drop the ‘Profit’ to the ‘Color’ marks section. Have a look at the below-mentioned screen.
The data in the Marks section says the kind of details they will reflect. Have a look –
This is how we make a Treemap chart in tableau, there can be some customization as per the need but the overall process is the same, drag and drops the working data.
Limitations of Treemap in Tableau
- The Treemap chart fails to display data with varying ranges.
- We have seen the two quantitative variables which we used in our case (i.e. country and GDP) here the limitation for the Treemap chart is cannot tolerate a negative value or parameters.
- No sorting options regarding the chart are provided to users.
- Not suitable for prints as it contains a large set of data points.
- Very fewer customization options for users.
So, the Treemap chart is preferred when you have to show the cumulative totals for the working data. You can also include labels like date, time, name, and budget while creating the chart.
This has been a guide to Treemap in Tableau. Here we discussed its Concept and Process, Use cases, Benefits and Limitations of Treemap in Tableau. You may also look at the following articles to learn more –