Chapter 17Mashing Up Data with Power Pivot
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 into ...
Get Microsoft Excel 2019 Inside Out 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.
