17. Mashing Up Data with PowerPivot
A revolutionary add-in called PowerPivot, which debuted in Excel 2010, enabled you to build pivot tables from multiple tables. For Excel 2016, that core functionality of PowerPivot is built directly into Excel. This chapter starts by showing you how anyone with Excel 2016 can build pivot tables from multiple tables.
Certain versions of Excel 2016 also ship with the full PowerPivot add-in. If you have one of these versions, you can activate the add-in and access additional tools, such as a powerful Data Analysis Expressions (DAX) formula language. The latter part of the chapter describes the additional benefits of PowerPivot.
Joining Multiple Tables Using the Data Model
When you see the term Data Model in Excel ...
Get Excel 2016 In Depth 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.
