• Bernard

Tableau charts: Tree map

In the series Tableau charts, our goal one. To help Tableau users learn how to build different charts and graphs, hence equipping them with different techniques of telling each data story. Tableau like many other tools offers one of the simplest interface to query data (drag and drop interface), with a large resource of graphs and charts which users can leverage to present data, and a very active community which helps users learn. So, why should one learn different techniques of presenting data? We are living in the digital disruption age, and one the asset being generated by most of businesses is data. With now these huge sources of data, institutions focus is not much on how to collect and store data, but rather how to make sense of these data assets. And therefore, with this demand, the following two reason should be compelling enough for you to consider learning different techniques of presenting data.

  • Data comes in different shapes and variety, and different data sets require different techniques of data preparation and transformation. Having a rich resource of techniques lets you have a smooth time when dealing with data.

  • Most data consumers are not data savvy, their preferences vary across the spectrum and their demands change every day. To satisfy such varying consumer needs, developers need to learn different techniques of presenting data.

Therefore, in the spirit of the Tableau chart series, we’ll explore on how to build a simple Tree map in Tableau using the Superstores data set.

Related: How to build Tableau charts.

Note: Our goal is to visualize the amount of Sales and Profit generated by different product Sub-Category’s within the Superstores portfolio.

Step 1: Prepare our structure.

This can be done in the following process;

  • Drag measure field Sales to the Size tab.

  • Drag the measure field Profit to the color tab.

  • Select Square under marks cards.

Note; this gives us a single square below.

Step 2: Extend our Square to all other product Sub-Category to create a tree map.

This can be done by dragging dimension Sub-Category to the details tab.

Note, we can label our tree map by dragging the fields Sub-Category, Sales and Profit to the label tab.

Step 3: Add another layer of analysis.

(This could be in the case where users would like to view the analysis across other category's).

This can easily be done by dragging any dimension you would like to analyze to the rows shelf. And therefore, in this case, i would like to add dimension Region in my analysis.

To effect this;

  • Drag dimension Region to the rows shelf.

The resulting visualization (Tree map), can provide the following insights.

  • The West and East regions are the leading regions in Sales generated. (Interpret by the size of tree maps for each region).

  • The Sub-Category Chairs and Phones generated most of Sales for West, East and Central regions. (interpreted by the Size of square for each Sub-Category in the tree map).

  • Only two Sub-Category’s in the West region were unprofitable, with Central region recording seven unprofitable Sub-Category’s. (interpreted using color).

Note, this are some of insights which can be drawn from this visualization. More approaches like use of filters and parameters can be applied to deliver same information to users in different ways.

This is one way of building a tree map, another technique could be as follows.

  • Drag dimension Sub-Category to the Rows shelf.

  • Drag measure field Sales and Profit to the columns shelf.

  • Under the 'Show Me' tab select 'Tree maps'.

I hope this visualization adds to your list of best techniques of presenting data. Thanks for reading.