O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

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

Deploying the reports in a PowerPivot site

PowerPivot for SharePoint supports the Microsoft Excel 2010 workbook, which contains the PowerPivot data model. The users can import this Excel workbook into a PowerPivot gallery in order to publish their reports. As a result, PowerPivot for SharePoint is necessary for the end users as they can view and interact with the reports; also, it's not necessary to install it into every end user's system where the PowerPivot add-in is installed. For these things, the Analysis service farm process in the SharePoint Server takes the workbook, and the memory is used by the analysis service; also, it helps in data aggregation, data processing, and some other features. If a user refers to the previous screenshot, ...

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