Objectives: This is an in-depth, hands-on, instructor-led course providing Business
Intelligence with PerformancePoint Server training. You will learn to
develop commercial Business Intelligence solutions using the powerful
Dashboard, Analyis, and Publishing capabilities of SharePoint Server 2010
and PerformancePoint Services.
Target Audience: Database programmers, business
analysts and project managers who want to deploy Business Intelligence
solutions to SharePoint 2010, PerformancePoint Services, Excel 2010 Services
Duration: 2 Days
Module 1 – The Business Intelligence
Stack
- SQL 2008R2 Business Intelligence Platform
- SQL Analysis Services
- SQL Reporting Services
- Performance Management Tools
- SharePoint 2010
- Multidimensional Space
- Data Mining
- Understanding the Terminology
Module 2 – PerformancePoint 2010
- Integration with SharePoint Server 2010
- Common Service Application Framework
- New PerformancePoint Features
- Storage Security
- Time Intelligence & Dynamic Filters
- Linking of Web Parts
- KPI Details Report
Module 3 – Dashboards and Scorecards
- What is Dashboard?
- What is Scorecard?
- Scorecards in PPS
- KPI Collections
- Dashboard Design Guidelines
- Dashboards designed to Monitor
- Dashboards designed to Analyze
- Dashboards designed as Management Views
Module 4 – Dashboard Designer
- Dashboard Designer Internals
- Dashboard Designer Interface
- First Class Objects
- Main Window
- Properties
- Dashboard Designer Features
Module 5 – Data Connections
- Data Sources
- Multidimensional
- Tubular
- Specific Sources
- SSAS
- Excel
- SharePoint List
- Time Intelligence
Module 6 – Visual Indicators
& Key Performance Indicators
- Visual Indicators
- Categorizing Indicators
- Performance Measures
- KPI Characteristics
- KPI Details
- KPI Templates
- Formatting Numbers
- Data Mappings & Calculation Metrics
- Scoring Patterns
- KPI Details Report
Module 7 – Visual Reports & Filters
- Types of Reports
- Analytic Chart
- Analytic Grid
- Excel Services
- ProClarity Analytics
- SQL Server Reporting Services
- Filters and Filtering
- Post Formula
Module 8– Scorecards
- Three Categories
- SSAS Template & Standard Template
- Tabular Scorecards
- Data Sources
- Implementing Interactivity
- Display Values
- Using Filters
- Deploying
Module 9 - Dashboard Details
- Dashboard Hierarchy
- Dashboard Variance
- Dynamic Dashboards
- Dashboard Interactivity
Module 10 - Security
- Understand SharePoint Security
- Understand Authentication in PPS
- Secure PPS Objects
