In this video, Phil Gold shows how to build data hierarchies in PowerPivot tables. Learn how to build hierarchies in tables, and see a demonstration of how they provide even more interactivity to end users.
- [Instructor] Another nice feature…that we have available to us is the ability…to set up hierarchies within the tables…that we're using for our Power Pivot Pivot Tables.…This allows extra drill down functionality…and enables some other pretty cool stuff.…So, let's set up a hierarchy in our Regions table.…We'll start by going back into Power Pivot…and Power Pivot, and Manage,…and we'll go back to the Diagram View.…
If we go over into the Region and we float here,…you can see there's a little prompt…there for create a hierarchy.…We'll click that and this will give us…the opportunity to name this.…Let's do something really obvious like RegionHierarchy.…Now, we've created that.…Now, let's take the region and drag it,…and you gotta put it right on top,…and see it turns color, there.…
So, that's the first thing under the hierarchy.…Now we'll put State under Region.…So, State will feed up to Region.…That'll be the order of the hierarchy.…Fairly simple.…Now, go ahead and get out of there.…Go back to the Data View.…And let's create a new table.…
- Define “static snapshot.”
- Recall when to use a SharePoint BI Center.
- Cite the licensing requirements for PowerPivot.
- Describe how to add data relationships.
- Explain what happens when you export a list from SharePoint to Excel.
- Summarize what happens when you expand a filter.
- Describe how you can see data without scrolling.
- Explain how to create a BI Center.