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.
Cet exercice fait partie du cours
Power Pivot in Excel
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice