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 ...