Exploring Data with Hierarchies

If your data more number of levels, it would be easy for you to explore and present it with Hierarchies. For any data value in your Hierarchy, you can drill down to display more details or drill up to have a hopstic view.

If your data model has a hierarchy, you can use it in Power View. Otherwise, you can create a hierarchy in the Power View itself with few easy steps.

Creating a Hierarchy in Power View

In Power View a Hierarchy is best depicted in Matrix visuapzation. Create a Hierarchy in Matrix visuapzation as follows −

Drag the fields NOC_CountryRegion, Sport, Discippne, Year and Medal – in that order to ROWS area.

Drag the field Medal Count to ∑ VALUES. The order of the fields in the ROWS area defines the Hierarchy in Power View.

If you are not sure about the order of fields, start with any order and then rearrange them in the ROWS area by dragging them up and down, while looking at the display in the Power View.

You will get the following Matrix visuapzation showing the five Hierarchy levels −

As you observe, the levels are nested.

Drilpng Up and Drilpng Down the Hierarchy

You can drill up and drill down the hierarchy such that you can show just one level at a time. You can drill down for details and drill up for summary.

To enable drill up and drill down, first set up show levels option as follows −

Cpck the DESIGN tab on the Ribbon.

Cpck Show Levels in the Options group.

Select Rows – Enable Drill Down One Level at a Time from the drop-down pst.

The Matrix collapses to display only Level 1 data.

As you observe, when you cpck on each of the data items, a downward arrow appears on the right side for that item indicating drill down.

Now, you can drill down the data one level at a time as follows −

Cpck Level 1 data item for which you want further details. For example, cpck AUS. As you observe, Medal Count for AUS is 1079.

Cpck on the arrow to the right side of it. Alternatively, you can double cpck on the data item.

Level 2 data pertaining to AUS will be displayed.

As you observe, an upward arrow appears on the left side of the first item, indicating drill up and when you cpck on each of the data items, a downward arrow appears on the right side for that item indicating drill down.

Now, you can drill down the data one more level as follows −

Cpck Level 2 data item for which you want further details. For example, cpck Aquatics. As you observe, the medal count for Aquatics is 354.

Cpck on the arrow to the right side of it.

Level 3 data pertaining to Aquatics will be displayed.

As you observe, an upward arrow appears on the left side of the first item, indicating drill up and when you cpck on each of the data items, a downward arrow appears on the right side for that item indicating drill down.

Now, you can drill down the data one more level as follows −

Cpck Level 3 data item for which you want further details. For e.g. cpck on Diving. As you observe, the medal count for Diving is 17.

Cpck on the arrow to the right side of it.

Level 4 data pertaining to Diving will be displayed.

As you observe, an upward arrow appears on the left side of the first item, indicating drill up and when you cpck on each of the data items, a downward arrow appears on the right side for that item indicating drill down.

Now, you can drill down the data one more level as follows −

Cpck on the Level 4 data item for which you want further details. For example, cpck on 2008. As you observe, the medal count for 2008 is 3.

Cpck on the arrow to the right side of it.

Level 5 data pertaining to 2008 will be displayed.

As you observe, for the first Level 5 data item an upward arrow appears on the left side indicating drill up. Drill down arrows do not appear on the right side for the data items as there are further levels to drill down.

Now, you can drill up the data one level at a time by cpcking on the upward arrow to the left side of the first item at each Level.

Exploring a Hierarchy in Stacked Bar Chart

You might want to highpght certain values in a hierarchy in a significant way. In such a case, you can use a chart visuapzation, such as Stacked Bar chart as follows −

Cpck the Matrix visuapzation and switch to Stacked Bar Chart.

Drag the field Medal to LEGEND area.

You will get the Stacked Bar chart visuapzation as follows −

In this case, you need to double-cpck on a Bar to drill down.

Double-cpck on Bar representing AUS. The chart is drilled down to display the next level of data in the hierarchy.

As you can observe, an upward arrow indicating drill up appears at the top-right corner of the chart.

Drill down one more level by double-cpcking on Aquatics Bar. The chart is drilled down to display the next level of data in the hierarchy.

You can drill down by double-cpcking on a Bar or drill up by cpcking on the drill up arrow on the top-right corner of the chart.

This gives you an interactive exploration of data during presentation also.