MS-50465 - PerformancePoint 2010 Designing and Implementing Scorecards and Dashboards
Course
MS-50465
Price:
$1,795.00
Software Assurance Value:
3
Duration:
3 Days
MS-50465, PerformancePoint 2010 Designing and Implementing Scorecards and Dashboards
Introduction
This instructor-led course provides students with the necessary knowledge to develop
Scorecards and Dashboards using PerformancePoint 2010 in their own work environment.
The course covers design theory, different types of dashboards, planning, deployment
and security. Each of the first class objects such as Indicators, KPIs, Filters,
Data Sources, and interconnecting them into scorecards and combining scorecards
into dashboards is covered in depth. In addition peripheral knowledge that greatly
enhances the design experience is provided including an overview of the Microsoft
Business Intelligence stack, basic understanding of the hosting services for PerformancePoint
2010 which is SharePoint 2010, MDX queries and SQL Server Analysis Services.
Return to Top
Audience
This course is intended for Power Users, Developers and IT Professionals that will
be involved with the design, development and maintenance of actionable performance
measurements as displayed in a scorecard and dashboard.
At Completion
After completing this course, students will be able to:
- Discover, design and implement KPIs
- Understand the scoring methodologies used with indicators to change visual displays
- Decide on how to modify a scoring methodology
- Understand the role of SQL Server Analysis Services in measurement
- Be able to develop proper filters for easy end-user click to detail on dashboards
- Group Scorecards into Dashboards and link them together
- Modify the web page hosting the Dashboards for branding
- Implement Master Pages in Dashboards for consistency with company standards.
- Develop multiple-valued KPIs. For example This year Actual and Target and last Year
Actual and Target at the same relative point in time
- Implement Time Intelligence features to query such as Year-To-Date, Last 6 Months
etc.
- Use Excel Services and Excel Workbooks in Scorecards or as a data source
- Utilize the document management capabilities of SharePoint 2010 for PerformancePoint
objects for versioning, document retention and reverting.
- Understand team development methodologies with developing PerformancePoint to reuse
existing objects or to segment projects.
- Use workflows to approve scorecards and dashboards
- Develop Filters for Scorecards
- Use Dashboard Designer
- Work with views of SSAS Cubes to model data for proof of concept for KPIs
- Connect into Data Sources via data Connections
- Gain a generalized understanding of MDX to write basic queries
- Generate Visual Reports and tie them into Dashboards
- Utilize decomposition trees
- Understand what the advantages of having SharePoint as the platform are.
- Use dynamic hierarchies in Scorecards
- Secure all Performance Point objects
- Implement User Menus in Scorecards
Prerequisites
Before attending this course, students should have an understanding of the benefits
of business intelligence.
Microsoft Certified Professional Exams
Student Materials
The student kit includes a comprehensive workbook and other necessary materials
for this class.
Outline
