Add New Skills!

Udemy
Showing posts with label SharePoint BI Performance Point. Show all posts
Showing posts with label SharePoint BI Performance Point. 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.

Tuesday, May 10, 2011

SharePoint 2010 PerformancePoint Services (PPS)

You will find a good presentation here and here

  • Performance Management solution by Microsoft
  • Bring data to end users in the form of Interactive Dashboard and Scorecards.
  • Create context driven dashboards – apply custom filtering and sorting.
  • Provides a design environment for power users and browser view for biz users.
  • Scorecard (Status Indicators) provides an overall view of the status
  • Support for multiple data sources – Analysis Services, Excel, Lists, SQL etc
  • Visual Data exploration using decomposition tree
  • PerformancePoint Services (PPS) evolved from Biz Scorecard Manager 2005 and ProClarity 6.3
  • Elements of PPS
    • Data Source
    • KPI
    • Scorecard
    • Report
    • Dashboard
    • Filter
    • Indicator
  • Integrated with SharePoint 2010

Decomposition Tree

ScreenShot002

Pie Charts

ScreenShot003

Chart Types:

image

KPI Details Report

ScreenShot004

Filters

Filters may be reused across multiple dashboards and is compatible with SharePoint filters

ScreenShot005

Thursday, March 24, 2011

Microsoft Business Intelligence: Thinking Bigger About BI

The below summary has been created from Microsoft Webcast

Why BI in SharePoint?

















SharePoint allows you to create wikis, blogs, employee, corporate and knowledge management portals,  and also provides a consistent development environment. SharePoint unites all these features together by allowing users to seamlessly search across all of this.

Business Intelligence lives within SharePoint.

SharePoint can be setup as Internal and External facing and provides a secure environment



















Data to a SharePoint can come from Web Crawl, Web Services, RSS feeds, SAP iView Webpart, Excel, Performance Point Server, Analysis/Reporting Server

Data doesn't have to live in SharePoint itself

Support for ActiveDirectory/LDAP

Deeper support with Microsoft Office

Performance Point is now part of the BI capability of SharePoint. If you have already deployed SharePoint and have enterprise license you can use Performance Point Services.

Sample Sales Dashboard - includes KPIs, Charts, Document Library, Blog






































Score Card View



















My Site




















Add Meeting Notes




















How to quickly get started with SharePoint?

Add Excel Webparts


















Add Reporting Services Reports, KPIs, Score Card (Coporate)

Create KPIs using
  1. Data in SharePoint List (example: Team Tasks)
  2. Data in Excel Workbook
  3. Analysis Services SSAS
  4. Enter Manually
SharePoint supports adhoc analysis in Excel and allows the results of the analysis to be published back to SharePoint.


















Publish to SharePoint
















With Excel Services, you can open an excel workbook and do analytics right within the SharePoint environment



















Excel Services: Power of Excel Engine on the Server





































Other benefits:
Single version of truth
People Ready: Briding gap between end users and IT
SOA
Search
Collaboration
Unite Unstructured data with Structured data


Resources:
Microsoft BI
SharePoint
Performance Point Scorecards
Excel Services