microsoft office business scorecard manager 2005 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Office Business Scorecard Manager 2005 PowerPoint Presentation
Download Presentation
Microsoft Office Business Scorecard Manager 2005

Loading in 2 Seconds...

play fullscreen
1 / 22

Microsoft Office Business Scorecard Manager 2005 - PowerPoint PPT Presentation

  • Uploaded on

Microsoft Office Business Scorecard Manager 2005. Dan Wood Operations Manager Netdesk Corporation. Microsoft Business Intelligence Vision. Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions. Advanced Analytics

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Microsoft Office Business Scorecard Manager 2005' - hammer

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
microsoft office business scorecard manager 2005

Microsoft Office Business Scorecard Manager 2005

Dan Wood

Operations Manager

Netdesk Corporation

microsoft business intelligence vision
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
what customers want from scorecards

Business Decision Makers

Access to multiple data sources for exception reporting

Deep analysis in context

Integrated collaboration environment

Alerting on changes in data

Business Analysts

A system of record for business definitions

Empowering KPI and scorecard designer

Auditing, versioning, and reversion capabilities

IT Administrators

Centrally managed, scalable BI platform

Better partnership with business users in scorecard and KPI authoring

What Customers Want from Scorecards

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

office scorecards architecture

Dashboard and Scorecard Reporting, Analysis and Collaboration

Business Definition Authoring

Web Components

Office Scorecard Webpart Office Report Viewer Webpart

Business Analysts

Business Decision


Maestro Builder Desktop Application

Application Metadata




Analysis Services

Reporting Services

Scorecard Application

Centralized Management



IT Administrator



Business Intelligence Platform

Office Scorecards Architecture
comprehensive scorecarding for all




End user






Comprehensive Scorecarding for All
deep contextual insight
Deep Contextual Insight

Charting & Analysis


Documents & Spreadsheets


MapPoint integration

end user empowerment
End-user Empowerment

Intuitive application

OWC Integration

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


Business Scorecard Portal

business scorecard builder
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.


Business Scorecard Builder

business scorecard manager and sql server 2005
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
business scorecard manager and sql kpi interoperability


Gross Margin for Canadian Consumer Goods KPIOwner: Jennifer Adams

Stretch Goal: 4.5%

Report Views: Pie Chart, Datasheet, Transaction Report

Readers: Executives and Canadian Middle Managers

Editors: Canadian Corporate KPI Editors

BSM offers tailored definitions

Business Scorecard Manager and SQL KPI interoperability

SQL offers centralized management

Gross Margin KPI

Value: ([Account].[Accounts].[Account Level 03].&[49], [Measures].[Amount])

Goal: ([Account].[Accounts].[Account Level 03].&[49], [Measures].[Amount],


Status, Trend, Graphics, Display Folder, etc.


software requirements
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
      • SharePoint Portal Server 2003 for search and personalization

Thank You!