Microsoft Office Business Scorecard Manager 2005

1
Microsoft Office Business Scorecard Manager 2005

• Dan Wood
• Operations Manager
• Netdesk Corporation

2
Microsoft Business Intelligence Vision
Improving organizations by providing business
insights to all employees leading to better,
faster, more relevant decisions

• Advanced Analytics
• Self Service Reporting
• End-User Analysis through Office and SharePoint
• Business Performance Management

3
(No Transcript)
4
What Customers Want from Scorecards
5
Microsoft Business Intelligence Platform
6
Business Scorecard Manager
Deep Contextual Insight
Collaborative Group Analysis and Action
End User Empowerment
Advanced Scorecarding KPIs
Rich charting graphing
Deep drill down Analysis
Flexible notifications alerts
7
Office Scorecards Architecture
8
Comprehensive Scorecarding for All
9
Deep Contextual Insight
Charting Analysis
Scorecard
Documents Spreadsheets
Report
MapPoint integration
10
Collaborative Group Analysis and Action
11
End-user Empowerment
Intuitive application
OWC Integration
12
Extensible Platform

• Extend with more comprehensive analysis tools
• Integrate into Industry ISV solutions
  (Professional Services, Automobile Retail, )
• Extend with powerful visualization tools

13
Scorecarding and Dashboards
14
Demo

• Business Scorecard Portal

15
Business Scorecard Builder

• Windows-based application used to
• Specify data sources for KPIs.
• Create KPIs.
• Specify indicators and bands for KPIs.
• Create scorecards.
• Specify how scorecards will be displayed on a
  SharePoint site.

16
Build Or Import KPIs
17
Create New Scorecards, Data Sources and
Indicators
18
Demo

• Business Scorecard Builder

19
Business Scorecard Manager and SQL Server 2005

• SQL Server 2005 provides
• Centralized management of metrics and business
  logic
• Multi-dimensional scorecards
• KPI interoperability across end-user applications
• Data integration and security

20
Business Scorecard Manager and SQL KPI
interoperability
SQL offers centralized management
Gross Margin KPI Value (Account.Accounts.A
ccount Level 03.49, Measures.Amount) Goal
(Account.Accounts.Account Level 03.49,
Measures.Amount, Scenario.Scenario.Scena
rio.2) Status, Trend, Graphics, Display
Folder, etc.
Platform
21
Software Requirements

• Minimum Install
• Business Scorecard Manager Server
• Windows SharePoint Services 2.0
• SQL 2000 SP3
• SQL 2000 Analysis Services SP3
• Windows Server 2003
• Business Scorecard Manager Client
• Windows XP SP2
• Recommended Technologies
• SQL 2005
• Analysis Services KPIs for centralized management
• Reporting Builder for ad hoc query
• SQL 2005/2000
• Reporting Services for exporting scorecards
• Notification Services for data-driven alerting
• Office 2003
• Office 2003 Web Components for advanced analysis
  and charting
• Visio 2003 Visio Viewer for strategy map
  presentation

22
Questions?
Thank You!

• dan.wood_at_netdesk.com