In this video, Phil Gold demonstrates how the relationship between data tables enable extra functionality in PowerPivot. Learn the reasoning behind setting up data tables, and see how they provide additional user interactivity.
- [Instructor] Now you might be wondering why we went to the…trouble of establishing the relations…between our different tables.…Let's build a simple pivot table…using our workbook to demonstrate the reason.…So here's my saved workbook,…and I've got the PowerPivot tab already open,…and we'll start by clicking Manage.…We've already added all of the tables into the data model,…so it knows everything's here.…Click anywhere into any table,…and we click the Power Pivot icon.…
Now, because everything's already added to the data model,…it doesn't really matter where you start on this.…PowerPivot is going to know that it's looking at…all of the tables that have been added to the data model,…and it knows your ranges for you.…We want to open this up as a new worksheet.…So here is a new worksheet.…Let's build a Pivot Table, and we'll take Total Sales,…and we'll make that the Value, so it's going to add up…all of our Total Sales, and I want to see the Total Sales…by Salesmen, I'll add Salesmen to Row,…and Product, I want to see Product.…
- 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.