Add New Skills!

Udemy
Showing posts with label PerformancePoint Services. Show all posts
Showing posts with label PerformancePoint Services. Show all posts

Friday, June 10, 2011

Self Service BI in SharePoint 2010: Part 2: Performance Point Services

This is part 2 of the 3 part blog series based on session by Peter Myers in TechEd 2011 . You can find the slides here. I have taken the key learning from the presentation for my future reference. For Part 1, go here

Performance Point Services (PPS)
Performance Point Services (PPS) is a performance management application where you define rich KPI and Score Card definitions to support monitoring. It includes comprehensive report types to support analysis and delivers interactive browser based dashboard all within the SharePoint. The picture below shows the key elements of PPS and how they are related.
clip_image002
Start by going to the Performance Point Content Library in SharePoint:
clip_image004
PPS comes with a Dashboard Designer tool:
clip_image006
See Data Connections:
clip_image008
Create new Scorecard:
clip_image010
Choose a template:
clip_image012
You are presented with a Wizard to create a KPI. You can import the KPIs from an excel workbook which is part of the Excel Reports Library in SharePoint.
image
Scorecard is created:
image
A KPI consists of 3 main things: Value, Goal & Status, Trend.
image
The Value of the KPI is got by using the formula: KPIValue(“Sales Performance”).
The threshold for the goals can be set as follows:
image
Likewise trends can be defined as below.
image
Once you save the dashboard, the KPI and the Scorecard will be visible in SharePoint
image
Back in the PPS Designer, note that the dimensions of the cube is visible which can be added to the Scorecard:
imageimage
The Scorecard is updated with the new dimension
image
Analytic capabilities of PPS is handled by Reports:
image
Choose the report template:
image
Create the Report:
image
Next define a filter:
image
Choose the type of filter:
image
Select the Members for the Filter:
image
Select the dimension:
image
You can choose to display the filter as a List, Tree or Multi-Select and save the filter:
image
You can create an Excel Services Report:
image
Enter the Report Settings:
image
Note the Year Parameter that was defined on the Fiscal Date Hierarchy will show:
image
Now it is time to bring all of the above in a Dashboard; so start by creating a new Dashboard:
image
Drag and Drop the filter, Scorecard and Report on the dashboard. Filters can pass values to Scorecards and Reports and Scorecards can pass values to Reports. Reports can only consume from either scorecards or filters.
image
Drag and Drop the filter on the Scorecard and the report to make a connection between the items of the dashboard:
image
Connect the Scorecard to the Report by pass the Sales Person Name (just drag the Member Unique Name onto the Report to make the connection between items of the dashboard):
image
Finally Deploy to SharePoint:
image
Dashboard View in the SharePoint:
image
Note Selection of North America from the hierarchy in the Scorecard changes the Salespeople Report:
image
Note the ability to drill across dimensions:
image
You can choose other measures available in the cube:
image
See details behind aggregated numbers:
image
Note the details ability to export to Excel:
image
Create graphs and analyze the data in decomposition tree:
image
Note the decomposition tree. The Decomposition tree is rendered through Silverlight:
image
Excel can now be viewed directly within the browser with the help of Excel Services. The below Excel Sheet connects to Analysis Services:
image
Coming up next is Vision Services. I will write that in my next blog post.

Thursday, June 9, 2011

Self Service BI with SharePoint 2010

Another great session from the TechEd 2011 by Peter Myers. You can find the slides here. I have taken the key learning from the presentation for my future reference.

SharePoint has become pervasive within an organization. How can we leverage the SharePoint BI application support and offload the task of publishing workbooks, diagrams and analytics to end users? SharePoint 2010 Business Intelligence Center makes it possible because it is no longer just a document repository but has rightfully designed to be the BI Portal for the organization. The best part I like about the Self Service BI with SharePoint 2010 is that end users can use their creativity and do web development without writing a single line of code or relying on IT!

Business Intelligence Center:

image

Create Web Parts easily:

image

Note all the categories of web parts that can be added to SharePoint 2010:

image

Connect the web part to a data source:

image

Add Filters to the Web Parts:

image

Provide the filter values that the end users could choose from:

image

Connect the filter to the Chart:

image

Since one web part feed to another, you must connect them and the end points will be made available as shown:

image

Filter is prompted to the end user as shown:

image

Chart Web Part:

image

SharePoint 2010 introduced Status List Web Parts for reporting Key Performance Indicators (KPIs). The data for the KPIs can be retrieved from SharePoint Lists, Excel Services, Analysis Services or just Fixed Values.

Excel Services supports the server-side calculations and browser based rendering of workbooks. This is extremely useful when users want to share the contents of the workbook with others in the organization in a more presentable, interactive format compared to plain attachments of files in a SharePoint or via Email. You can configure security within the workbook such that parts of the workbook are NOT visible to a group of users. Excel Services Promotes development of analytical solutions.Excel Web Access web part supports embedding workbook reports into Web Part Pages.

Data Connection Library: Data Connections need to be created or approved by the SharePoint 2010 Administrator.

image

Refer to the data connection library within Excel: end users don’t need to know where the cube resides or where the data comes from.

image

In Excel 2010 you can insert slicers within a workbook:

image

Slicers:

image

Formatting to see the Distribution of Values:

image

Filters in Excel can be embedded into a Web Part Page as a Filter Web Part:

image

Publish to SharePoint:

imageimage

Set the Parameters before you Publish:

image

Publish it to the Excel Report Library:

image

The Excel Reports Library is rendered in Silverlight, also known as Silverlight Gallery:

image

Excel is opened within the browser and is fully interactive:

image

We can create Excel Web Access Web Part:

image

Select the workbook:

image

Select Excel Reports:

image

This will embed the report in a web part page:

image

You can add a date filter to the above web part:

image

Reference the ODC file to connect to Analysis Services:

image

Connect the Web Part Filter to the Parameter of the Excel Web Part:

image

Connecting the filter to the Time Dimension of an Analysis Services Cube cubes shows the hierarchy when you select the filter:

image

Result:

image

I will write about Performance Point Services in Part 2 of this blog post.