Microsoft Business Intelligence Performance Management
Somphol Weswibul Solution Specialist – Application Platform Microsoft (Thailand) Limited
[email protected]
The Need For Better Insight And Visibility Exists Throughout the Organization
Organizational Challenges
Performance Management
4
Performance Management Challenges End User Challenges
Execute on Strategy and Monitor Performance
IT Challenges
Multiple Users, Multiple Tools
Consistent Metrics
Decentralized Business Logic and Disintegrated Systems
Long Budget Cycles with Manual consolidation processes
Flexible and Scalable Budgeting and Planning Architecture
Lack of Transparency in the Data
Regulatory Compliance Requirements
Need for an Integrated Approach Aligning past information, present conditions, and future outcomes
What is happening? Scorecards and Dashboards
What happened? Reporting, Consolidation
What will happen? Forecasting
Why did it happen?
Analytics Common Business Data & Logic
What do I want to happen? Planning, Budgeting
Across the Organization Performance Management Applications Financial Budgeting, Planning and Forecasting, Consolidation, Management Reporting, Scorecards & Analytics
Operational/Supply Chain/MFG Operational Dashboards, Supply Chain Analytics, Constraint Based Planning
Sales/Customer/Marketing Analytic CRM, Sales Forecasting, Campaign Management & Analytics, Sales Scorecards
Human Resources HR Analytics, Headcount Planning, Talent Scorecards, OPEX Planning & Analytics
IT System / Application Availability, Server and Disk Capacity, SLA variance to System Availability
“I need to improve our analytics capabilities so we can understand our current business performance and do a better job of planning for the future." “I need better visibility into my cost of operations so I can target specific cost reduction opportunities that won’t have a negative impact.” “I need better visibility into our pipeline performance so I can focus on deals that help me grow business with my most profitable customers.” “I need better visibility into our talent management so I can plan for growth and understand issues before they become troublesome.” “I need a solution for monitoring the health of my IT Infrastructure and to drill into operations data to analyze trends and investigate root cause.”
Monitor Performance Central KPI’s Management Create once, Reuse, Centrally manage
Create and Manage Scorecards: Roll Up and Consolidate KPI’s Enable online KPI collaboration Support methodologies (Six Sigma, Balance Scorecard)
Live Strategy Maps for Cause & Effect Contextual Dashboards for ease of discovery Advanced Filters and Time Intelligence Monitor planning models for continuous improvement
Monitor KPI’s in Visual Context Tie Visio diagrams or Virtual Earth to Live KPI’s Fault Tree Analysis
Desktop Management
Geospatial
Analyze Performance Analyze the data to find Root Cause for poor performance Web-based Dashboard Analytics Purpose built for PM Dashboards Drill-across, Drill-to-detail, Sort, Filter, Slice and Dice the data
Predictive Integrate with Data Mining to Forecast and Trend
Contextual Contextually aware through tight integration with KPI’s
Guided Navigation Pre-define navigation paths for ease of Root Cause Discovery
Better Manage The Planning Process Centralized approach to budgeting and planning Monitor through SharePoint
Contribute through Excel
Account Entity Scenario
Costs
Forms
Revenue
Time
Consol.
Dimensions Hierarchies
Models Bus. Rules Calcs
Cycle
Centralized business rules, definitions, and models
Today’s BI Reality For Most Organizations
Our Integrated End-to-End BI Offering DELIVERY
END USER TOOLS AND PERFORMANCE MANAGEMENT APPLICATIONS
BI PLATFORM (RDBMS, ETL, OLAP, Reporting)
Mainframe/ Departmental Systems
Delivering The Right BI Tool For Every Role In The Organization
Familiar Microsoft Environment Drives BI Adoption
Improve Customer Services & Opportunity targeting by location
Major Microsoft BI Customers 5.1 TB Credit Card DW, Relational Query, OLAP, RS 500+ unique reports, 1500+ users, Office BSM Catering Planning System used in 2,300 hotels 25% time savings in catering forecast generation Used by 13,000 agents in 220 offices Built portal with Visual Studio .NET, SSAS 700 restaurants, 30,000 users, 700+ concurrent OLTP/LOB reporting on inventory & sales data Reporting on 1.6 TB of data, 35K+ Tx/Min 325 concurrent connections Consumer Real Estate Division 98% reduction in report management time
www.microsoft.com/bi
© 2008 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
