The PowerPivot add-in is a data analysis tool which provides an extension to PivotTable functionality.
This add-in allows you to work with more than 1,048,576 rows and can work on data from multiple sources.
Fast manipulation of large data sets, streamlined integration of data and the ability to share analysis through SharePoint.
Not Available To Everyone
This add-in is only installed (by default) for the following Office 365 subscriptions:
Office 365 Pro Plus
Office 365 Enterprise E3
Office 365 Enterprise E5
or for any of the following Perpetual (one-off) licenses:
Office Professional 2016
Office 2013 Professional Plus
Excel 2016 standalone
Excel 2013 standalone
Excel 2010 standalone (not installed by default, must be downloaded separately)
This term is a very general and very loose term.
It refers to the ability to connect to on-premise and/or cloud sources and incorporates SharePoint Online.
This encompasses both Power Pivot and Power Query.
More Powerful that Pivot Tables
This extend the capability of the PivotTable functionality with new features such as
Expanded data capacity
Import data from multiple sources
Publish workbooks as interactive web applications
Use the Data Analysis Expression (DAX) language to create advanced formulas
A powerpivot data model can be used to create a pivottable.
PowerPivot provides a "self-service" approach by allowing users to easily connect to different data sources to analyse data.
PowerPivot does not replace SQL Server Analysis Services (SSAS).
There is also a Power Pivot window and a Power Pivot Field.