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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
