Microsoft Business Intelligence Jaap van Tilborg Business Productivity Advisor

1
Microsoft Business Intelligence Jaap van
TilborgBusiness Productivity Advisor
2
The Evolution of Employee Productivity

• Creation
• Spreadsheets
• Word processors
• Presentation graphics

3
The Evolution of Employee Productivity

• Communication
• Networks
• E-mail
• Internet/Intranet
• Business process ERP, CRM, SCM,

• Creation
• Spreadsheets
• Word processors
• Presentation graphics

4
Opportunity Double the business productivity in
the next decade
Access
Absorb
Manage
Mobility
Ease of Use
Reliability
Security
Communicate
Collaborate
Author
5
What the Next Era looks like?

• Connection
• Interconnection of
• People
• Process
• Data

• Communication
• Networks
• E-mail
• Internet/Intranet
• Business process ERP, CRM, SCM,

• Creation
• Spreadsheets
• Word processors
• Presentation graphics

6
Connecting People, Data Processes
Connected Ecosystem
Order Processing
Paper Forms
7
What Is Business Intelligence?

• Business Intelligence provides a holistic
  overview of a business
• Having access to (structured) information
• Having the ability to analyze the information
• Having the ability to share the information with
  others

8
The Challenge

• Empower employees to make great decisions
• Theyre the face of the company to the customer
• Need the power to take action any time, any
  where, from any device
• The company with the best (equipped) employees
  wins
• Provide tools to end users to access data across
  the enterprise

9
Business Intelligence Imperative

• Decision makers are at every level of your
  organization
• Local decisions are more immediate, more relevant
• Rapid analysis instead of fixed reports

Goal Apply the best intelligence of the
organization to the problem at hand
10
What Customers Want
Reduce information latency
Provide analysis on demand

• Make BI easier

Personalize delivery
Deliver comprehensive, cost effective solution
11
BI For The Entire Enterprise
Operational
Strategic
Tactical

• Analysis
• Data Access
• Collaboration

Execs
Strategic Value

• 24x7 BI
• Form Factors
• Big ETL

Analysts/ Middle Mgrs

• Timeliness
• Ease of Use
• High-Level View

Ops
Number of decisions
12
BI for the Entire Enterprise
Analysts
Operations
Execs
Middle Managers
13
BI for the entire enterprise
??
14
BI for Everyone
CPM
Query and Analytics
Reporting
15
User Profiles
Strategic
Tactic
Operational
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
User Profiles
Strategic
Tactic
Operational
20
User Portal
21
User Profiles
Strategic
Tactic
Operational
22
(No Transcript)
23
(No Transcript)
24
Web-based Rendering
25
Print Formatted Output
26
Export to Excel
27
Personalized E-Mail Delivery
28
Why do companies need Business Intelligence?
29
European BI Survey How is the BI solution used ?
Types of Data Used
30
European BI Survey Excel in the BI Solution

• Excel is key in the BI solution
• Companies are looking for Improvements (add ins)
  to the current offering

31
European BI Survey Top Customer Requirements

• Top 3 KPIs, Report Management, Printing
  Sharing, Unified Relational and Multidimensional
  functionality
• Mobile access last

32
Is there really a problem?

• Only 5 of the workforce gets the strategy
• Only 25 of managers have incentives linked to
  strategy
• 60 of organizations don't link budgets to
  strategy
• 85 of executive teams spend less than one hour
  per month discussing strategy
• 90 fail to execute strategy successfully

Robert S. Kaplan and David P. Norton The
Strategy-Focused Organization, 2000
33
Is there really a problem?

• Available business data isgrowing exponentially
• Critical decisions per week have tripled over the
  last five years
• Dedicated analytical personnel have decreased by
  50 over the lastfive years

Source Gartner Group