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.
In this module we are going to take a look at the Business Intelligence Stack.
SQL 2008R2 Business Intelligence Platform
SQL Analysis Services
SQL Reporting Services
Performance Management Tools
Understanding the Terminology
The Business Intelligence Stack
Explore Business Intelligence Development Studio
Connect into a SQL Server Analysis Services Cube
Use SQL Server Management Studio
Explore SharePoint 2010
Understand the overview of the stack.
Explain the role of each of the services in SQL for BI.
Overview of SharePoint.
Gain a familiarity with terminology used in products.
Understand Multidimensional Space.
Review Components of SharePoint .
In this module we are going to take a look at the PerformancePoint Services 2010.
Integration with SharePoint Server 2010
Common Service Application Framework
New PerformancePoint Features
Time Intelligence and Dynamic Filters
Linking of Web Parts
KPI Details Report
PerformancePoint Services 2010
Use SharePoint to create a site collection
Configure Central Administration for PerformancePoint Services
Create and Explore a PerformancePoint Business Intelligence Center
Review Integration with SharePoint.
Advantages of SharePoint Security.
See New Features in PerformancePoint Services.
Understand Object Hierarchy in PPS.
In this module we are going to take a look at the Dashboards and Scorecards.
What is a Dashboard ?
What is a Scorecard ?
Scorecards in PPS
Dashboard Design Guidelines
Dashboards designed to Monitor
Dashboards designed to Analyze
Dashboards designed as Management views such as Six Sigma
Dashboards and Scorecards Overview
Design each of the three categories of dashboards
Design your company dashboard
Discover the two definitions of a Dashboard.
Learn the three types of Dashboards.
In this module we are going to take a look at the MDX.
What is MDX ?
MDX Query Editor
Understand the Cell
Write a Tuple
Write a SELECT statement
Write a Function
Understand what the MDX is.
In this module we are going to take a look at the Dashboard Designer.
Dashboard Designer Internals
Dashboard Designer Interface
First Class Objects
Dashboard Designer Features
Create a Data Connection
Create a Basic Dashboard
Deploy the Dashboard
Explore the Dashboard in PPS
Review Module Goals.
Examine the Dashboard Designer Internal structure.
Work with the Dashboard Designer Interface.
Understand First Class Objects.
Explore the windows.
Review the features of Dashboard Designer.
In this module we are going to take a look at the Data Connections.
Create a new Business Intelligence site for lab as a sub site
Create a SQL Server Analysis Services Connection and use it as source
Create a Data Connection using Excel Services
Create a Data Source using Import Workbook
Connect into a tabular SharePoint list as a Data Source
Understand types of Data Connections.
Explore each type of Data Connections.
In this module we are going to take a look at the Visual Indicators and Key Performance Indicators.
KPI Details Report
Visual Indicators and Key Performance Indicators
Create a custom Indicator
Create several KPIs
Create a basic Scorecard to host your KPIs
Utilize a cube as a data source
Create an objective KPI
Create a multi-valued KPI
Explain the advantages of Visual Indicators.
Discover Performance Measures.
Review the 7 characteristics of KPIs.
In this module we are going to take a look at the Visual Reports and Filters.
Types of Reports
SQL Server Reporting Services
Provider and Consumer
STPS to MDX
Visual Reports and Filters
Create an Analytic Grid
Create a Member Selection Filter
Create an Analytic Chart
Create a Strategy Map
Create a Time Intelligence Filter
Use Time Intelligence in a Report
Explore Visual Reports.
Understand the link to SQL Server Reporting Services.
Work with filters.
In this module we are going to take a look at the Scorecards.
Create a KPI for use in lab
Add a dimension filter
Wire up filters
Compare the effects of filtering
Change Scorecard Settings
Explore Scorecard Templates.
Utilize Scorecard Wizard.
Apply Filter to Scorecard.
In this module we are going to take a look at the Dashboard Details.
Develop multiple Dashboards
Change Deployed Dashboards
Provide interactive Help for your Dashboards
Monitor Dashboard Utilization
Control Dashboard Updates
Understand the details of Dashboards.
Make connections between web parts.