Sunday, October 20, 2013

Excel Services and PerformancePoint Services in SharePoint

Excel Services and PerformancePoint Services are used primarily for business intelligence scenarios.

Excel Services:

Just Upload a Excel file into Document Library

Create a webpart page. Insert Excel Web Access Webpart and configure the webpart to display the Excel data

Using REST API, you can display the data as Chart or Graph

You need to setup an Unattended Account in Secure Store Service app to display the data without asking for any credentials.  Start the Claims to Windows Token Service if it is not running.

Performance Point Services:

Create a Secure Store target Application using CA

Create Performance Point Service Application using CA and set the Unattended Account

Associate the PPS to the Web Application

Activate the PPS site collection featrues

Create a Site Collection using Business Intelligence Center template

Click on Start using Performance Point services

Click on Run Dashboard Designer

Now you can create a Dashboard for your data.



No comments:

Post a Comment