Chapter 2. Using the unique features of PowerPivot

In the previous chapter, you learned the basics of the data model in Microsoft Excel 2013, and you have seen that the key to exploiting some of the most interesting new features of Excel 2013 is the creation of a Microsoft PowerPivot data model. Finally, you learned that the PowerPivot engine works even if you do not enable the PowerPivot add-in because the xVelocity in-memory analytics engine is integrated into Excel 2013, and it starts working as soon as you create a PivotTable working on more than a single table or Power View chart.

You might be wondering at this point why you would want to enable the add-in at all, if the PowerPivot engine can be executed without using it. The reason is that ...

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.