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

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with O’Reilly online learning.

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