Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise