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 live online training, plus books, videos, and digital content from nearly 200 publishers.