O'Reilly logo

Business Intelligence in Microsoft SharePoint 2013 by Mariano Teixeira Neto Norman P. Warren Stacia Misner, Ivan Sanders, and Scott A. Helmers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required