A Heat map is used to compare categories using color and size. In this, we can distinguish two measures.
Scenario: Show sales and profit in all regions for different product categories and sub-categories.
Follow these steps:
- Drag Region field to Columns shelf, and Category and Sub-Category fields in Rows shelf.
- Use the ShowMe tool and select the Heat Map.
- Observe the hotter and colder regions in the heat map produced:
A heat map is not only defined by color, but you can also use its size. Here we define the size by sale by dragging the Sales tab to Size under marks card, comparing profit and sales through the color and size
Analysis: Profit is represented by color and ranges from orange for loss to blue for profit. The total sales are represented by size.
Tree Maps
A Treemap is used to represent hierarchical data. The space in the view is divided into rectangles that are sized and ordered by a measure.
Scenario: Show sales and profit in all regions for different product categories and sub-categories.
- Select two dimensions Category and Sub-Category
- Select two measures Sales and Profit from the data pane.
- Use the Show-me tool and select tree-map.
