Chapter 45. PowerPivot

Questions answered in this chapter:

  • How can I load data into PowerPivot?

  • How can I use PowerPivot to create a PivotTable?

  • How can I use slicers with PowerPivot?

  • What are DAX functions?

Microsoft PowerPivot was first introduced as a downloadable add-in for Excel 2010. If you have Excel 2013 Pro Plus or Office 365, PowerPivot for Excel is available to you. PowerPivot for Microsoft Excel 2013 is an add-in that enables you to:

  • Store and query large volumes of data (think hundreds of millions of rows) efficiently that you can combine from multiple data sources and multiple data formats. For example, some of your data might come from a Microsoft Access database, some from a text file, some from several Excel files, and some from live ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.