1 / 22

Microsoft Office Business Scorecard Manager 2005

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

hammer
Download Presentation

Microsoft Office Business Scorecard Manager 2005

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. 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

  4. Microsoft Business Intelligence Platform

  5. 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

  6. Dashboard and Scorecard Reporting, Analysis and Collaboration Business Definition Authoring Web Components Office Scorecard Webpart Office Report Viewer Webpart Business Analysts Business Decision Maker Maestro Builder Desktop Application Application Metadata 2005/2000 2005/2000 2005/2000 Analysis Services Reporting Services Scorecard Application Centralized Management Source Systems IT Administrator Scorecard Cubes Business Intelligence Platform Office Scorecards Architecture

  7. Deep contextual Insight End user Empowerment Collaborative Group Analysis Extensible Comprehensive Scorecarding for All

  8. Deep Contextual Insight Charting & Analysis Scorecard Documents & Spreadsheets Report MapPoint integration

  9. Collaborative Group Analysis and Action

  10. End-user Empowerment Intuitive application OWC Integration

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

  12. Scorecarding and Dashboards

  13. Demo Business Scorecard Portal

  14. 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.

  15. Build Or Import KPI’s

  16. Create New Scorecards, Data Sources and Indicators

  17. Demo Business Scorecard Builder

  18. 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

  19. Application 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], [Scenario].[Scenario].[Scenario].&[2]) Status, Trend, Graphics, Display Folder, etc. Platform

  20. 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

  21. Questions? dan.wood@netdesk.com Thank You!

More Related