PerformancePoint And Excel Services In SharePoint 2013 Quick Primer
By utilizing PerformancePoint Dashboard Designer, you can include Excel Services reports in your PerformancePoint dashboards. Excel Services reports are Excel workbooks that have actually been published to SharePoint Server. You can show a single product in the workbook, or the entire workbook in your PerformancePoint dashboard. When you use Dashboard Designer to consist of Excel Services reports in your dashboard, you do not in fact create the reports. Instead, you create PerformancePoint Web Parts that are designed to display Excel Services reports and receive dashboard filters.
Use Excel Services reports to display take kinds that you can not develop using Dashboard Designer. You can also conserve time by displaying existing reports, instead of creating brand-new Excel workbooks, include interactive reports in your dashboards that users can either take in a web browser or open in Excel, and create reports that use data source types not readily available in Dashboard Designer. An Excel Services report screens all or part of an Excel workbook that was released to SharePoint Server 2013 by utilizing Excel Services. You can include Excel Services reports in your dashboard, either as a single item on the page or as a product alongside other dashboard items. In addition, you can connect dashboard filters to Excel Services reports, together with other kinds of PerformancePoint reports and scorecards. You would typically include several Excel Services reports in your dashboard to make it possible for dashboard users to quickly view and discover data. Relying on how you establish your reports, dashboard individuals browse through pages in Excel workbooks without opening Excel, apply internal filters for charts and tables that were produced in Excel, type rows or columns in charts or tables, and use the Refresh button in the web browser window to restore the Excel Services report to its default view.