microsoft’s business intelligence strategy john eng lead product manager microsoft corporation...

Microsoft’s Business Intelligence Strategy

John EngLead Product ManagerMicrosoft Corporation

Microsoft SQL Server Business Intelligence Overview

Agenda

> Trends in Business Intelligence > Microsoft’s BI Strategy> Q&A

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

Analysis Paralysis

> I have too muchdata and not enough information

> Why don’t all of my reports tie together?

> Management needs answers yesterday

> Who has timefor analysis?

Today’s World – Silos of information

> Enterprise Resource Planning (ERP)

> Customer Relationship Management (CRM)

> Supply Chain Management (SCM)

> Web Clickstream data

> Internet Commerce

EnterpriseData

Warehouse

CallCallCenterCenter

MarketingMarketingCampaignCampaign

MgmtMgmt

CRM CRM and and

eCRMeCRM

InternetInternet

Financial/ Financial/ AccountingAccounting

ProcureProcurementment

HRHR

InventoryInventory

Intelligence is data with relevance and context

Business Intelligence Market Trends

Internet Impact

Adoption of Enabling Technologies

Competitive and Declining Business Conditions

Standardization of Enterprise Applications

•Global competition

•Slowing economy

•Increased productivity/ focus on profits

•Top Line Growth / Business Agility

•Web services

•XML / SOAP / HTTP

•Mobile Devices

•ASP / Hosting

•Bandwidth

•Huge data volumes (CRM, ERP, SCM)

•Real-time information / access via internet

•Partner and customer Interaction

•New sources of data

•KPI’s and schemas for CRM, ERP, SCM, clickstream applications

•Open and Std APIs

BIAdvantage

DEMAND DRIVERS ENABLING FACTORS

Operations

BI for the Masses

Analysts

Execs

> Strategic value of decisions increases towards the center

> Number of decisions increases away from the center

“I’ve got everything here at my fingertips; I find it’s made my life a lot easier...and made my customers so much happier with the customer service” - Andrea McGregor-Dawson, Relationship Manager, ASB Bank

“I’ve got everything here at my fingertips; I find it’s made my life a lot easier...and made my customers so much happier with the customer service” - Andrea McGregor-Dawson, Relationship Manager, ASB Bank

Where should we be?

> Empower employees to make great decisions> They’re 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

Pervasive Business Intelligence

How we deliver on the premise

> BI Tools> Scale – large to small> Security> Interoperability

Abilities

> Embedded analytics> Applications> Devices> Web services> Real time/closed loop

Agilities

> Comprehensive BI platform> Open API> Manageability / Self tuning> Best of Breed partners

TCO

Best of BreedBest of BreedInteroperabilityInteroperability

Fast Time to Fast Time to MarketMarket

Pervasive Business Intelligence

Microsoft Business Intelligence strategy

Comprehensive Comprehensive BI PlatformBI Platform

Data Warehousing Alliance and Data Warehousing Alliance and Framework, Open Data Access Framework, Open Data Access APIs, Data Source ConnectivityAPIs, Data Source Connectivity

Integrated RDBMS, ETL, OLAP, Integrated RDBMS, ETL, OLAP, Data Mining, Meta Data, Mgt toolsData Mining, Meta Data, Mgt tools

Easy to Build and Manage, Easy to Build and Manage, Lowest TCOLowest TCO

MICROSOFT BI MOMENTUM

> OLAP Market $3.5B> OLAP Report

> #1 in OLAP> Microsoft was the clear leader

in 2001> Fastest growing OLAP server in

history> Industry Publications

> Intelligent Enterprise – #2 - Top 12 most influential companies enabling Enterprises

> DM Review DM 100 – #6

Business Intelligence Platforms Magic Quadrant

COMPREHENSIVE BI OFFERING

> SQL Server 2000 > Complete platform with scalable RDBMS,

including: Data Transformation Services Analysis Services (OLAP and Data

Mining) Metadata Services English Query

> Office XP> Excel – built-in PivotTable Service> Web components for custom development> SharePoint> Microsoft Data Analyzer

COMPREHENSIVE OFFERING

SOURCE SYSTEMS(LEGACY)

EXTRACTIONTRANSFORM

LOADMANAGE

DATA WAREHOUSEAND / OR DATA MARTS

Data Warehouse or Data Mart

(dimensional, subject oriented)

and

Operational Data Store

PRESENTATION / OLAP

OLAP including HOLAP, ROLAP,

MOLAP query services; may store atomic data;

may be frequently

refreshed

Data Mining Models forecasting;

clustering; scoring

OLE DB

XML/A

OLE DB

XML/A

END USER ACCESS AND ANALYSIS

Ad-hoc Query Tools

Reporting

Custom Apps

Analytical Apps

Web Services and

Mobile Apps

COMPREHENSIVE OFFERING

SOURCE SYSTEMS(LEGACY)

EXTRACTIONTRANSFORM

LOADMANAGE

DATA WAREHOUSEAND / OR DATA MARTS

Data Warehouse or Data Mart

(dimensional, subject oriented)

and

Operational Data Store

END USER ACCESS AND ANALYSIS

Ad-hoc Query Tools

Reporting

Custom Apps

Analytical Apps

Web Services and

Mobile Apps

DTS

OLEDB

DTS

SQL Server

Oracle

IBM

PRESENTATION / OLAP

OLAP including HOLAP, ROLAP,

MOLAP query services; may store atomic data;

may be frequently

refreshed

Data Mining Models forecasting;

clustering; scoring

OLE DB

XML/A

OLE DB

XML/A

Excel /MSDA /

Sharepoint / IE

Third Party (DWA Q&R)

Visual Studio

Data Warehousing

Alliance

Visual Studio

OLAP including HOLAP, ROLAP,

MOLAP query services; may store

atomic data; may be frequently

refreshed

Data Mining Models forecasting;

clustering; scoring

SQL Server Analysis Services

(OLAP)

SQL Server Analysis Services

(Data Mining)

SQL Server

DTS

DTS / HIS

DTS

Data Warehousing Alliance Members

Appsco Software Limited

Arcplan Inc

Ardent Software Inc

Artech

Baan Company

Best Software

Broadbase Software Inc

Business Objects

ChangePoint

Citicorp ITI Limited

Cizer Software Corporation

Cognos

Comshare

Data Mirror

Data Watch

Decisionism

Decision Support Panel

EMS Plc

Epicor

FRx Software Corp

HarmonyInfinium SoftwareInformaticaInformation BuildersKnosysLawsonManugisticsMaximal Innovative IntelligenceMetaEdgeMIS Technologies GmbhNetAcumenOLAP @ Work IncPolyvista Software Portola DimensionalRevelwood IncSagent TechnologySeagate SoftwareSilvon SoftwareSRC Software IncTargit A/STop TierVisual Insights

Market Momentum Customer Examples

> ASB Bank – Largest Bank in New Zealand> Oracle switcher; delivers customer

behavior/profitability info to 130 branch offices> http://www.microsoft.com/sql/productinfo/ASBBank.htm

> AT&T – Growth Markets> 1 TB Sales DB – cross-sells; 300% ROI in 6

months> http://www.microsoft.com/servers/net/ATTSQL.htm

> Disco S.A. – leading chain of Argentine supermarkets> 900 GB DB/DW for frequent shoppers club. Data

Mining for targeting promotions – deployed < 1 month

> http://www.microsoft.com/servers/net/disco.htm> Inmar – coupon promotion analysis

> Analyzes 5 Billion coupon transactions – legacy AS/400 data source

> http://www.microsoft.com/servers/net/InmarEnterprises.htm

> $8 billion operator of world’s largest digital wireless network> Business Problem – need to improve their understanding of key market

dynamics, plan more effective market penetration strategies and increase their business growth rate

> Increase customer focus and enable growth> Reduce Costs without Impacting Quality> Support People for Success

> Strategy - Focus on Key Metrics > Customer Churn, Product Affinity / Customer Demographics> Uptime of network & services> Response time to requests & problems

> Solution - Implemented ProClarity, SQL Server, Digital Dashboard and Map Info plug-in> Users

• 500 AT&T business analysts, sales professionals and product managers

• 11,000 field sales representatives via a Web-browser solution

> Results

• 300% ROI in 6 months

Customized ProClarity(500 Analysts/Mgr.s)

Web Site (11,000 Sales Professionals)

Digital Dashboard(350 Managers)

AT&T Growth Markets

Data Transformation Services

> A generalized facility for copying and transforming data between data sources

OLE DB OLE DB ODBCODBCFixed FieldFixed FieldASCII DelimitedASCII Delimited

SourceSource

OLE DB OLE DB ODBCODBCFixed FieldFixed FieldASCII DelimitedASCII DelimitedRepl. PublicationRepl. Publication

DestinationDestination

DTS Data PumpDTS Data Pump

InIn OutOut

ActiveX ScriptActiveX ScriptCopyCopyTrim StringTrim String……CustomCustom

X FormsX Forms

Connectivity> Minimum interface/dbpropset support

>7.0 – OLE DB 2.1>2000 – OLE DB 2.6

> Existing OLE DB Providers>Microsoft(MDAC)

• SQL Server 6.5/7.0/8.0, Oracle 7/8, ODBC, WebDAV, Active Directory

>Microsoft(SQL Server)• Text Files, DTS Packages, Replication DTS,

JET(Access, Excel, dBase, Paradox, …)>Microsoft(Other)

• DB2, VSAM, Exchange 2000, Project>Merant

• Oracle(7, 8i-2), Informix, Sybase, VSAM, XML>SAS

• Over 30 different mainframe environments

OLAP Capabilities>Analysis Services for SQL Server

> Powerful, easy-to-use analysis>Integration with

> Windows NT®, SQL Server, Office, third-party products> Any OLE DB data source

>Scalable from desktop to enterprise>Flexible architecture – MOLAP, HOLAP, ROLAP

Data Mining Services

> Reconcile> Model-driven analysis (OLAP) with> Data-driven analysis (Data Mining)

> Two core algorithms> Clustering (EM) > Classification (decision trees)

> OLE DB for data mining> Tight integration with SQL Server> Developed in partnership with Microsoft

Research

> Matching individuals to populations> Drive a marketing campaign> Understand different customer profiles to fine-tune

a product or service

Separate strategiesSeparate strategiesper clusterper cluster

Data Mining Services

> Understand and predict an attribute of an individual using a decision tree> Predict credit risk> Predict buying habits

MarriedGood (2)Poor (0)

Not marriedGood (0)Poor (1)

HighGood (2)Poor (1)

LowGood (0)Poor (2)

IncomeGood (2)Poor (3)

High income,High income,marriedmarried

Data Mining Services

Microsoft Office XP

> OLE DB for OLAP in Excel PivotTables

> Office Web Components for browser-based analysis

> Access 2000 compatibility with SQL Server

Microsoft Data Analyzer

> Graphical Analysis and Data Visualization

> Provides intuitive views of data to identify opportunities, trends and issues

> Easily Publish and Share Data> Extends the power of SQL

Server Analysis Services

RELATIONAL DATABASE SHARESUnix + WindowsUnix + Windows

OracleOracle53%53%

IBMIBM16%16%

InformixInformix4%4%

SybaseSybase4%4%

OtherOther6%6%

MicrosoftMicrosoft17%17% $5.4B Total$5.4B Total

24% Growth24% Growth

WindowsWindows

OracleOracle37%37%

IBMIBM19%19%

InformixInformix 1%1%

SybaseSybase 2%2%OtherOther3%3%

MicrosoftMicrosoft38%38% $2.4B Total$2.4B Total

40% Growth40% Growth

Data Source: Gartner DataquestData Source: Gartner Dataquest

2000 Revenues

For More Information

> Resources> http://www.microsoft.com/business/bi

> http://www.microsoft.com/sql/techinfo/BI/default.asp > http://www.microsoft.com/sql/evaluation/compare/default.asp