Data Connections Defined
The first thing to design and plan out when building dashboards in PerformancePoint is which data connections to use. The data connections are links to any externally generated and maintained set of data on which the dashboard components will be based. Data can come from any of the following types of sources:
• SQL Server Analysis Services
• Excel components from either Excel Services or Excel Workbooks
• SharePoint Lists
• SQL Server tables
Recall that Business Intelligence in SharePoint is not about creating data or determining how to organize it. SharePoint’s focal point is about surfacing the data, making it available, presentable, and consumable for those who need to make key business decisions. Therefore, a key ...
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.
Read now
Unlock full access