A fantastic visual for displaying hierarchies is definitely the Treemap visual. It accomplishes this by nesting the data in rectangles, which are represented by color, and this is commonly known as a "branch". If you add a category into the Details section of the visual you will note smaller rectangles within the "branches" and these are known as "leaves", hence the name Treemap. In order to really maximize this visual, we will need to do a little extra setup and bring in a new table, and create a new hierarchy. Let's go through this process now:
Let's look at, setting up the example:
- We need to bring in the DimGeography table from the AdventureWorksDW excel workbook. Since we accomplished this during Chapter 3, Building ...
