Planning for business intelligence adoption - Business Intelligence in Microsoft SharePoint 2013 - page 47

Store data for use in Reporting Services as a data source for standard RDL reports and Power
View in SharePoint reports

■

Store data for use in SharePoint:
• KPI
• Visio web diagram
• PerformancePoint Services KPI or filter
• Component in a SharePoint or PerformancePoint Services dashboard

■

excel Services
Excel Services is a SharePoint service application with which users can share Excel workbooks in a
secure, centralized location. The interface is simple for casual users to find and access information.

You can use this tool to do the following:

Provide users with a way to share large workbooks outside of email, even to users who don't
have Excel installed

■

Display data in a dashboard-like layout using a familiar interface

■

Provide casual users with collaborative workbook editing and limited analysis capabilities in a
browser environment

■

Protect intellectual property in Excel workbooks

■

Embed complex calculation capabilities in custom applications

■

Display Power View in Excel visualizations

■

PowerPivot for SharePoint uses Excel Services and an Analysis Services instance in SharePoint
mode to display PowerPivot in Excel workbooks. The PowerPivot for SharePoint Add-in provides
management oversight of activity related to these workbooks. Because PowerPivot for SharePoint
relies on Excel Services, the familiar, simplified interface helps casual users interact easily with the
workbooks and to use the workbooks as a data source by using self-service BI tools such as Report
Builder or Excel.

You can use this tool to do the following:

Make it possible for users to work collaboratively on analytical data compiled in a PowerPivot
in Excel workbook

■

Automate the process of refreshing the data sources in a workbook

■

Provide users with a data source for self-service BI tools

■

Discover data sources used in workbooks and monitor workbook usage

■