Creating a treemap

A treemap is used for displaying huge amounts of data that can be structured hierarchically (tree-structured). It presents the data using differently sized and colored rectangles.

Before you begin

See Treemap for a description of the concept.

Procedure

On the authoring bar, click Visualization types to open the flyout.
Drag the Treemap visualization type to the wanted position on the analysis page.
A suggestion of a treemap is presented.
On the Hierarchy axis, select the columns to include in the hierarchy. Start with the top level.
On the Size axis, select by which column the rectangles should be sized.
Select which type of aggregated value to display for the selected column.
On the Color axis, select by which column the rectangles should be colored.
Select which type of aggregated value to display for the selected column.

Example

The data table below lists how much money different customers have spent at four different store departments. Assume you want to find the "top" male and female customer at the Toys department.
Data table for treemap.

The treemap settings below give you the answer.
Treemap finding the "top" male and female customer at the Toys department.

Customer ID SSMM55005 is the woman who spent most money, and SSMM55091 is the man, because these customers' rectangles are the largest in the female and male branches respectively.

Maybe these two customers are the "top" customers at the Clothing department as well. To find out, change the column on the Color axis to Clothing to see if these rectangles have the darkest color.
Treemap, further investigation.

It seems other customers are more interested in clothing than the two customers who spent the most on toys!