From the course: SharePoint Advanced: Working with PowerPivot
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
PivotTables vs. PowerPivot and PowerView
From the course: SharePoint Advanced: Working with PowerPivot
PivotTables vs. PowerPivot and PowerView
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.