Excel PowerPivot

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.

Specific features:

• 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