dashboards with pps monitoring and analytics
DESCRIPTION
TRANSCRIPT
Dashboards withPPS Monitoring and Analytics
Raj Chaudhuri
Session Code:
Agenda
Overview of Dashboards PerformancePoint Server : Past, Present and…Overview of PPS Dashboard features
ScorecardsKPIS and Indicators
ReportsFiltering
Extending PPS Dashboards using:Web Page ReportsCustom Report TypesCell Context-based InteractionPPS Metadata
Dashboards Overview
DashboardsProvide important, related information in one glanceCan show summarized or detailed dataCan be targeted to specific audiencesAllow interaction – drill down, get detailsThese days, mainly show scorecardsWhich are composed using KPIs
“Microsoft” Dashboards
KPIs can be built usingMicrosoft SQL Server Analysis ServicesMicrosoft Office SharePoint Server (KPI Lists)Microsoft ProClarityGood old Microsoft Excel
Dashboards can be shown usingMicrosoft SQL Server Reporting ServicesMicrosoft ProClarity and ProClarity Advanced ServerMicrosoft Office SharePoint Server (Especially Excel Services)
PerformancePoint Server
Logical successor to another product called Business Scorecard ManagerPlays three roles: Planning, Monitoring and AnalysisMonitoring and Analysis involve calculating KPIs, combining them to build scorecards, and using scorecards and reports to build dashboardsCombines all the other technologies discussed
Umm, except…
Analytics
Planning PPS Service Pack 3
Monitoring
PerformancePoint Server Roadmap
H1 CY10Mid CY09
SharePoint “14” PerformancePoint
Services
Supported 10 yrs
Analytics
Monitoring
Today
Performance Management becomes a workload in SharePoint
Product Licensing Roadmap
Today(Effective April 1st, 2009) Summer 2009 Wave 14
Monitoring
PPS 2007As an entitlement of
MOSS 2007 Enterprise CAL Software Assurance
no changeSharePoint “14”
Standard + Enterprise CAL
Analytics no change
PlanningSP3 for PPS 2007
Available for all owners of PPS 2007
maintenance
(to get the latest functionality)
Still…
Monitoring and Analytics will continue in SharePoint v.nextAny development done now will continue to workMOSS customers with Software Assurance have access to PPS today.So…
Building a basic dashboarddemo
Adding some interactivitydemo
What next?
Custom report types are not very simple to build
We have to create a design surface as well as a result
If we only want to display results, there is an easy way
The Web Page Report
The Web Page Report
Is just a web pageWhich can render anythingDashboard context can be passed to the web page:
Via regular HTTP parameters
Coding Web Page reports with parametersdemo
Custom Report Types
Custom report types need a little more patienceThey require both :
server-side deployment (for rendering), andClient-side deployment (for designing)Final deployment requires the code to be signed
Creating Custom Report Typesdemo
Metadata
PerformancePoint Server Monitoring maintains metadata about every object
“What are the banding thresholds for a KPI?”“What annotations have been added to a scorecard?”
This data is maintained in a column called SerializedXml in the PPS Monitoring databaseIt could be used in custom reports through:
The PPSMonitoring Web ServiceDirectly querying the database
The MAUDF project
Monitor Analyze User Defined FunctionsProvides
T-SQL access to M&A element metadata Using
CLR Table-Valued UDFsAvailable
http://www.codeplex/maudf
धन्यवा�दઆભા�ર ধন্য�বা�দ
ਧੰ�ਨਵਾ�ਦ
ଧନ୍ୟ�ବା�ଦ
நன்றி�
ధన్య�వాదాలు� ಧನ್ಯ�ವಾ�ದಗಳು
നി�ങ്ങള്ക്ക്� നിന്ദി�
question & answer
© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS,
IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.