Transcript Slide 1 - Center

Microsofts strategier og
visioner for Business
Intelligence
Chefkonsulent Anders W. Madsen
Microsoft Danmark
Today’s World –
Multiple Data Points



Enterprise Resource
Planning (ERP)
Customer Relationship
Management (CRM)
Supply Chain
Management (SCM)

Web Clickstream data

Internet Commerce
CRM
and
eCRM
Call
Center
Marketing
Campaign
Mgmt
Financial/
Accounting
Internet
Enterprise
Data
Warehouse
Inventory
Procure
ment
HR
Intelligence is data with relevance and context
Analysis Paralysis:
You are not alone



Available business data is growing
exponentially
Critical decisions per week have tripled
over the last five years
Dedicated analytical personnel have
decreased by 50% over the last
five years
Source: Gartner, Inc.
Recognizing the Need for BI
1.
2.
3.
4.
5.
Operational reports don’t match
Lack of corporate-wide picture of
customer and product profitability
IT overloaded with reporting requests
Business units hired separate IT people
Lack of customer segmentation and
targeted marketing.
The Business Problem



Companies are under-leveraging their
information and people assets
Employees do not have access to a free
flow of information
Decision-makers cannot react in real
time to changing needs
What Do Companies Want?
Ability to analyze data to identify and
respond quickly to “pain points”
CFO
Cash flow problems
Poor investment performance
Declining profits
Not meeting profit growth objectives
Not making budget targets
VP Sales
Not meeting growth goals
Increasing sales expenses
Declining customer satisfaction
Ineffective sellers
Store Manager
Poor promotion execution
Declining sales
Ineffective customer segmentation
Microsoft BI Strategy
Objective:
Enable companies to better leverage their
information assets to thrive in a competitive
marketplace
How:
Making Business Intelligence Easy
Microsoft Business Intelligence Strategy
Comprehensive
BI Platform
Best of Breed
Interoperability
Fast Time to
Market
Integrated RDBMS, ETL, OLAP,
Data Mining, Meta Data, Mgt tools
Data Warehousing Alliance and
Framework, Open Data Access
APIs, Data Source Connectivity
Easy to Build and Manage,
Lowest TCO
Pervasive Business Intelligence
Microsoft forretningsmodel
 Core
business (SW development)
 High volume – low cost
 Indirect sales model > low cost & choice
of right solutions for your business
 Focus on technology platform -Solutions
through partners (DWA)
 Protects investment in databases & front
end tools (DWA)
 Synergy with Enterprise Agreement
Very
attractive pricing (“free” Danfoss, “10
times less than Oracle” quote Posten)
Types of users
Statisticians (2%)
Knowledge Workers
(15%)
Information
Consumers
Executives
Hvad siger analytikerne?
“Among the more
notable changes in
the BI platform
Magic Quadrant are
Microsoft's
increasing ability to
execute, with
growing adoption of
Analysis Server and
related tools.”
- Howard Dresner,
Gartner Group, 7/01
Hvad siger analytikerne?




MS Fastest Growing Mkt Share (86% CAGR, IDC 2001)
Huge emerging market ($12b by 2005, 27% 5 yr CAGR)
MS DW/BI revs = $500 M per to IDC
DW/BI represents 40% of SQL Server revenues
Microsoft BI momentum
MS #1 in OLAP market share
 Microsoft #1 product chosen (80%) if
evaluated and compared to others
 Microsoft #1 OLAP server purchased
and installed
 Microsoft largest seat deployment. 40%
above next closest competitor
 Microsoft among top in customer
loyalty

Source: 2001 – The OLAP Survey http://www.survey.com/reports/olap/
3
T

World’s largest cube - 1.2 TB
source data DW in MOLAP Cube





- Enterprise Scale
7.7 billion fact row RDW into MOLAP
(440GB)
50 concurrent users
Median query time = between 0.02 0.08 sec
Reflects a real company’s schema,
business process and data
Only SQL Server can support this
scale; manageability
Addressing The…“Abilities”
Reliability


99.999 equates to less than
five minutes downtime
per year
Starbucks, FreeMarkets, and
MortgageRamp, an affiliate of
GMAC Commercial Mortgage,
are using Windows® 2000
Server–based systems
designed to deliver 99.999
percent server uptime
Windows 2000 operates reliably in large-scale enterprise information
environments - with uptime approaching four-nines
(i.e., 99.99%) in the real world
Source: Aberdeen Group
BI case (DK)
Operational
data
Data
Warehouse
Data Marts
Data access &
analysis
DTS
Mainframe
 10 million
SQL DW
transactions  + 1 TB
per day
 Load window
Intranet
Microsoft Analysis
Services (OLAP)
 Price elesticity
 Campaign mgt.
TARGIT analysis
IE, Excel

350 Purchasers
Solution Software TCO
Microsoft/HP savings
in year 3 = Euro + 1
IBM RegattaEuro 5,5
mio
mio.
 MSFT Total cost year
IBM AIX Euro 5 mio.
3 est. Euro 0,5 mio.
Microsoft Euro 2,5 mio.
 IBM total cost year 3
(incl migration)
est. Euro 1,5 - 2 mio.
SQL server ent. ed. incl
(IBM bid with Analysis
3 year SA. = SA alone
Services!)
on DB2!
3
year TCO estimated:

•Windows Adv. server (non clustered), SQL server 2000 ee. (RDBMS,OLAP,DTS)
•+ 1,5 TB (single instance) + OLAP cubes
•Targit Analysis (OLAP analyse (seperat)
Microsoft BI – “Built for the Masses”
Microsoft Office XP


OLE DB for OLAP
in Excel
PivotTables
Office Web
Components for
browser-based
analysis
Executive Dashboard
An aggregated personalized view of BI
Microsoft Business Intelligence

Microsoft = Platform


Partner = Løsning


Data Warehousing framework –Alliance
Skalerbar og enterprise ready teknologi



Komplet platform for BI (Microsoft SQL Server
2000: ETL, DB, OLAP, Data Mining, Meta Data)
Dansk Supermarked, Danske Bank, Sonofon,
SydBank, Lauritzen, Rambøll, Nordea,
Bekræftet af Analytikere (IDC)
TCO, Pris, omkostning…!
Why Microsoft?
The Power to turn information into business insight
Microsoft
SQL Server 2000 is
the fastest way to
deliver enterprise
database solutions
SQL Server
 Complete scalable
RDBMS, including:




Microsoft Office
The world's
leading suite of
productivity
software
Data Transformation
Services
Analysis Services (OLAP
and Data mining)
Metadata Services
English Query facility
Office
 Excel - Built-in PivotTable®
Service
 Web components for
custom development
 Digital Dashboard
Microsoft Business Intelligence
referencer i Danmark (udvalgte)














Amtsrådsforeningen
Arbejdsmarkeds
styrelsen
Arovit Petfoods
Bonniers
B-Young (i hele
Norden)
B&O
Carlsberg
COMM/2
DaimlerChrysler
Dandy
Dansk Supermarked
Gruppen
Danske Bank
DAAB Danmark
DM Data















Egmont
Electrolux
Ferring
Gigtforeningen
Global One
HT
Inco Fælleskøb
olding Kommune
Københavns
Kommune
KV Tjellesen
Lauritzen
Matas
Nordea Securities
NCC
Rambøl












Pfizer
Politiken
Premiair
Royal Canin
Europe
Shell
Superfos
Sydbank
Synoptik
Tele Danmark
IT & Telestyrelsen
Thiele
WM-data Nordic