Chapter 4. Using PowerPivot in Excel 2013

Microsoft Excel is a powerful spreadsheet and data analysis application, with hundreds of capabilities that can help you to organize and make sense of the data and numbers in your life. In this Excel release, a lot has been done to both improve the experience and empower the user when employing it as a business intelligence (BI) tool; for instance, PowerPivot, which was introduced as an add-in for Excel 2010 and now is a native feature in Excel 2013. Among the many self-service BI features, this chapter will focus on the Excel Data Model feature and the PowerPivot in Excel native add-in.

The Data Model

The Data Model is a collection of tables and their relationships that reflect the real-world relationships ...

Get Business Intelligence in Microsoft SharePoint 2013 now with the O’Reilly learning platform.

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