Schedules:

There are currently no scheduled classes for this course.

 
  Microsoft Office Business Scorecard Manager 2005
 

2-Day (BI-BSCRCRD-301-EN)

Description
Course Summary
Prerequisites
Course Outline

Description

Written and delivered by industry experts, this two-day course provides students with the technical skills required to design, develop and manage scorecards using Microsoft Office Business Scorecard Manager 2005 (BSM). The course consists of lessons, demonstrations and comprehensive "real world" student lab exercises.

Course Summary

  • Installing, configuring and securing BSM
  • Deploying and managing scorecard content
  • Creating a library of effective and reusable BSM elements
  • Implementing scorecard dashboards in SharePoint
  • Introducing advanced BSM functionality

Prerequisites

Before attending this course, it is recommended that students have the following skills:

  • Experience using Microsoft Windows operating systems
  • A general understanding of relational and multidimensional (OLAP) databases
  • Familiarity with SharePoint and Reporting Services

Course outline

01 - Course Introduction

In this module, students are introduced to the concepts of Business Performance Management (BPM) scorecarding methodologies including Kaplan Norton's Balanced Scorecard. Students are shown the final solution that they will build throughout the course.

02 - Introduction to Business Scorecard Manager

BSM is an integral part of the Microsoft Business Intelligence ecosystem. This module introduces the role BSM plays in Microsoft's strategy of "delivering BI to the masses". Students learn about BSM's flexible architecture, integration with SharePoint and the ability to create a library of rich, reusable objects that present data from a variety of sources.

03 - Development and management with BSM Builder

In this module, students begin by exploring the functionality of BSM Builder; how it is used to build scorecarding solutions and manage the Scorecard Server. Practical experience is gained by creating and publishing the four major elements of a BSM solution: Indicators, Data Sources, KPIs and Scorecards. Students also learn to create and configure Scorecard Views and Report Views in order to expose data to end users in the most effective way.

04 - Deploying and developing dashboards

Once created, the scorecard solution can be deployed and the dashboard design can begin. Using the theory presented in this module, students deploy their work to both SharePoint sites and Reporting Services reports. Students are instructed on "best practice" design, and gain practical experience with the many options available to create effective, useful scorecard dashboards.

05 - Securing scorecards

Data security can be controlled from a number of different areas in an IT environment. BSM provides role-based security capabilities on the objects managed in the Scorecard Server. In this module, students learn about BSM security. In addition, they learn how security is implemented in SharePoint and how the sources of scorecard data contribute to the overall security of a BSM solution.

06 - Advanced concepts

There are many ways in which BSM can be extended to provide advanced functionality for users. In this module, students perform practical labs to gain a greater understanding of the process of KPI scoring, importing KPI definitions from an Analysis Services cube, configuring dynamic scorecard row members using MDX and configuring custom Reporting Services reports to interact with scorecards.

07 - Introduction to Performance Point Server

The next version of BSM will be embedded into a comprehensive new product called PerformancePoint Server 2007, due for the release mid 2007. This product will provide a compelling scorecarding and analysis tool. In this module, students are given a preview of the new features and functionality, and discussions will center around how existing BSM skills can be leveraged.