Skip to Main Content
PowerPivot for Business Intelligence Using Excel and SharePoint
book

PowerPivot for Business Intelligence Using Excel and SharePoint

by Barry Ralston
March 2011
Beginner to intermediate content levelBeginner to intermediate
302 pages
6h 57m
English
Apress
Content preview from PowerPivot for Business Intelligence Using Excel and SharePoint

PowerPivot Management Dashboard As a Data Source

PowerPivot for SharePoint includes a robust Management Dashboard built in PowerPivot. You first saw that dashboard in Chapter 7. Another example of PowerPivot as a data source is using the metrics from that dashboard within a PowerPivot solution. However, establishing a connection to the PowerPivot workbook behind the Management Dashboard requires a slightly different process from what you just saw in the previous section. I provide an example next. As part of the example, we will use an Office Data Connection (.odc) file to specify the data connection configuration.

Creating the Office Data Connection (.odc) File

Begin with access to the PowerPivot Management Dashboard, located within SharePoint ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

Tony Smith

Publisher Resources

ISBN: 9781430233800Purchase book