Microsoft Excel 2013 Inside Out

Chapter 24. An introduction to PowerPivot

• Using a PivotTable on an Excel table

• Using PowerPivot in Office 2013

• Understanding the data model

• The PowerPivot add-in

• Creating a Power View report

• Loading data from external sources

• Using the DAX language

• Refreshing the PowerPivot data model

MICROSOFT POWERPIVOT for Microsoft Excel 2013 is an add-in aimed at providing self-service business intelligence (BI). This is a real revolution in the world of data analysis, because it gives you all the power needed to perform complex data analysis without requiring the intervention of BI technicians. PowerPivot implements a fast, powerful, in-memory database that can organize data, detect interesting relationships, and provide the fastest way to browse information.

Some ...