In this video, Phil Gold describes the similarities and differences between regular PivotTables and PowerPivot. Learn how PowerPivot and PowerViews expand pivot table and graphing functionality, and provides interactivity that wasn't previously available.
- [Instructor] Now, you already know…what PivotTables are, right?…A PivotTable uses the data in an existing table…and allows you to reorganize, sort,…and filter that data to extract deeper insights.…So, how does that differ from PowerPivot and PowerView?…Well, PowerPivot is an extension for Excel.…The biggest difference is that PowerPivot…lets you use data from multiple sources…when constructing your PivotTable,…not only from a single Excel workbook, but multiple…workbooks, or even external data sources.…
It also gives you the ability to define connections…between the different data sources, and in effect…create a relational database from existing information.…In this course I'll be showing you how to attach…these data sources and even include…collecting data from SharePoint lists,…and you can stage that information back in SharePoint,…which allows your users to see…and interact with it directly from your site.…Now, once you have your data, using PowerView enables you…to create some pretty impressive visualizations.…
- 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.