Chapter 1. Introduction to PowerPivot
Microsoft PowerPivot for Microsoft Excel 2013 is a technology aimed at providing self-service business intelligence (BI), which is a real revolution inside the world of data analysis because it gives the final user all the power needed to perform complex data analysis without requiring the intervention of BI technicians. PowerPivot is an Excel add-in that implements a fast, powerful, in-memory database that can be used to organize data, detect interesting relationships, and provide the fastest way to browse information.
Some of the most interesting features of PowerPivot are the following:
The ability to organize tables for the PivotTable tool in a relational way, freeing the analyst from the need to import ...
Get Microsoft Excel 2013: Building Data Models with PowerPivot now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
