Chapter 17
Mashing up data with Power Pivot
Joining multiple tables using the Data Model
Unlocking hidden features with the Data Model
Overcoming limitations of the Data Model
The Power Pivot add-in debuted in Excel 2010. The add-in allowed you to:
Load 100 million records in an Excel workbook
Join data from Sheet1 and Sheet2 in a single workbook
Create new calculated fields using a formula language called DAX
Use time intelligence functions to handle fiscal years not ending in December
Power Pivot was not developed by the Excel team. It was developed by the SQL Server Analysis Services team. In Excel 2010, the add-in was free and mostly separate from Excel. It proved so popular that the Excel team slowly began incorporating Power Pivot ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.
