PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application Microsoft Excel.
It’s the user-friendly way to perform data analysis using familiar Excel features you already know, such as the Office Fluent user interface,
PivotTable and, PivotChart views, and slicers.
Take advantage of familiar Excel tools and features
Process massive amounts of data in seconds
Load even the largest data sets from virtually any source
Make the most of multi-core processors and gigabytes of memory
PowerPivot Window Launch To Pull Data from a variety of Data Sources such as MSSQL Oracle Access Teradata Sybase Informix
Sourced Data now Loaded into a seperate Worksheet as a Semantic Data Repository
Clicking on Pivot Table Button allows you Pivot Loaded Data below