Hierarchies
Hierarchies are structured groups of data, much like a Russian doll. Creating hierarchies can add another dimension to your analysis, making it easier to group data and find insights and relationships.
There are some interesting hierarchical relationships in the sales_team
since it is an organization chart dataset. This could be helpful to explore.
Continue working in your current workbook. If you've lost progress, open 2_1_relationships.xlsx
from the Workbooks folder in the course materials.
This exercise is part of the course
Power Pivot in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
