10. Mashing Up Data with Power Pivot
In This Chapter
Understanding the Benefits and Drawbacks of Power Pivot and the Data Model
Joining Multiple Tables Using the Data Model in Regular Excel 2016
Using the Power Pivot Add-in from Excel 2016 Pro Plus
Understanding Differences Between Power Pivot and Regular Pivot Tables
Power Pivot debuted in Excel 2010 as a free add-in with six jaw-dropping features. It was an amazing product, created outside the Excel team. You’ve already seen the Data Model in Chapter 7, “Analyzing Disparate Data Sources with Pivot Tables.” The Data Model is really the Power Pivot engine, and it was first built into Excel 2013.
The Data Model gives you some of the Power Pivot features, but many more ...
Get Excel® 2016 Pivot Table Data Crunching 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.
