Transcript BI and BW and 3rd Party Tools

Business Information Warehouse
Naeem Hashmi
Founder, CTO
The Information Frameworks
URL: http://infoframeworks.com
September 2000
Copyrights, 2000, Information Frameworks
September 2000
1
PLEASE NOTE!
• This document is part of a presentation
that author delivered at an SAP event on
September 2000.
• As Technical architecture and the
functionality about all products discussed
in this document may have changed since
its composition, author takes no
responsibility for their latest functionality
missing in this presentation.
• For latest product information, contact the
respective vendor.
Copyrights, 2000, Information Frameworks
September 2000
2
Agenda
• What is Business Intelligence?
• What is SAP Information Warehouse (SAP BW)
• How SAP BW Compares with 3rd Party Data
Warehouse Tools?
Copyrights, 2000, Information Frameworks
September 2000
3
The Data Warehouse people...
Bill Inmon
Ken Orr
Richard Finklestein
Copyrights, 2000, Information Frameworks
Doug Hackney
Claudia Imhoff
John Zachman
Ralph Kimball
September 2000
Larry English
4
The Business Intelligence
Business Intelligence is an umbrella term, introduced
by Howard Dresner of the GartnerGroup in 1989 to
describe a set of concepts and methodologies to
improve decision making in business through the use
of facts and fact-based systems.
Business Intelligence Terminology
•
•
•
•
•
Executive Information Systems
Decision Support Systems
Enterprise Information Systems
Management Support Systems
OLAP (On-Line Analytical Processing)
• Balanced Score Cards
Business Intelligence Environment
EIS
Query &
Reporting
Data Analysis
Mid to late 70’s
Early 80’s
Late 80’s
Early to Mid 90’s
Data Mining
Internet
MDBMS
RDBMS
as well as newer technologies such as:
• Data Mining
• Data Visualization
• Geographic Information Systems
Business Information
Database
Legacy Systems
Legacy Systems
Legacy Systems
Legacy Systems
Knowledge Management
Copyrights, 2000, Information Frameworks
September 2000
5
The Data Warehouse definition
Bill Inmon, known as the father of
data warehousing,
defines a data warehouse as
"a subject-oriented, integrated,
non-volatile and time-variant
collection of data in support
of management decisions."
Copyrights, 2000, Information Frameworks
September 2000
6
Architectural layers of a Data Warehouse
WAREHOUSE MANAGEMENT
Information Consumers
INFORMATION PROVIDER
Information Delivery
SERVICE PROVIDER
Content Management
DATA PROVIDER
Content Creation
Information Acquisition
Data Sources
Copyrights, 2000, Information Frameworks
September 2000
7
Ralph Kimball Approach
• The Father of Star Schema - deal for OLAP.
Fiscal
years
Divisions
Fiscal
years
Divisions
 Key figures
 Classification criteria
Period Division Customer
group
Copyrights, 2000, Information Frameworks
Regions
Regions
Regions
"What is my profitability by customer over time, by region ?"
Plant
Product
group
Fiscal
years
Divisions
Prod.
Sales Revenue Prod. Employees Fixed
quantity volume
costs
assets
September 2000
8
Data Sources
Data Sources
Types of Data Warehouses
Data
Warehouse
Global Data Warehouse
Data
Warehouse
Data
Marts
Data Sources
Dependent Data Marts
Data
Warehouse
Data
Marts
Independent Data Marts
Copyrights, 2000, Information Frameworks
September 2000
9
KNOWLEDGE WH
DATA WH/MART
OLTP
Characteristics of Information Objects
Operational - enable the user
to maintain control over day to
day transactions in a
transactional system
Overdue Orders
Orders on Hold
Released sales orders
Fiscal/legal - fulfill external and
statutory governance reporting
requirements which are
mandatory for the corporation
Consolidated Income Statement
Balance Sheet
Batch
Tax Reporting
Sales Out
Management - assist in analysis
or measurement based on key
performance indicators/metrics of
the business
Ad Hoc Query
Processing
Orders and Backlog reporting
OLAP
Profitability Analysis (e.g. product P&Ls)
Variance Analysis (performance vs.. plan)
Documents - to share knowledge
Product Announcements Mostly Static
INTERnet
Technical Support Material
among a broad spectrum of
INTRAnet
Product specifications
audience - public and private,
multimediaEnterprise Information Portals
Copyrights, 2000, Information Frameworks
September 2000
10
Typical Data Warehouse Components
Copyrights, 2000, Information Frameworks
September 2000
11
Components of SAP BW
Copyrights, 2000, Information Frameworks
September 2000
12
SAP BW - Open Solution - 3rd Party Integration
Arcplan Information Services
inSight
15.12.98
BW-ODB 1.2
Business Objects
Business Objects
15.12.98
BW-ODB 1.2
Cognos, Inc.
Brio Technology, Inc.
Power-Play SAP BW
Interface
Seagate Worksheet
Seagate Crystal Reports
Seagate Holos
Brio Enterprise
1.0
13.01.99
BW-ODB 1.2
7
7
7
6.0
17.03.99
BW-ODB 1.2
19.08.99
BW-ODB 1.2
Viador, Inc.
E-Portal Suite
6.0
20.08.99
BW-ODB 1.2
MIS Technologies
MIS Alea
3.7
08.10.99
BW-ODB 1.2
PointOut GmbH
PointOut for BW
17.11.99
BW-ODB 1.2
Ton Beller AG
wwwEIS
15.12.99
BW-ODB 1.2
Seagate Software
2.35
Data Access
Data Load
ACNielsen U.S
EDW* Connect
Others
1.02
20.07.99
Informatica Corp.
PowerCenter
4.5
Evolutionary Technologies
ETI*EXTRACT
1.0
18.06.98
BW-STA 1.2
TSI International Software
Mercator for R/3
1.4.2
13.11.98
BW-STA 1.2
Prism Solutions Inc.
Prism Connect for BW
2.0
20.04.99
BW-STA 1.2
Acta Technology Inc.
ActaWorks
3.0
09.02.99
BW-STA 1.2
Hummingbird Communications
Génio
3.0
27.04.99
BW-STA 1.2
systemfabrik GmbH
Business Warehouse
Connector
SNAPpack Data Migrator
4.0
09.06.99
BW-STA 1.2
2.6
11.08.99
BW-STA 1.2
08.12.99
BW-STA 1.2
02.02.00
BW-STA 1.2
Information Builders, Inc.
SuperNova International B.V.
Ardent Software
Copyrights, 2000, Information Frameworks
BW-DPI 1.2
September 2000
Supernova for Business
Warehouse
DataStage load pack for
SAP BW
08.06.98
BW-STA 1.2
13
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports

ETI, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
14
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports

ETI, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
15
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports

ETI,SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
16
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports,
ETI, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
17
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports,Code Generators

ETI, SAS, D2K

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
18
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports,

ETI, Prism, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
19
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports

ETI, Prism, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
20
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports

ETI, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
21
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports

ETI, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Compaq BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
22
Comparing SAP BW with 3rd Party
Data Warehouse Construction Tools
 3rd Party DW Components:

Acta Technologies, Oracle, IBI,
Cognos, BusinessObjects,
Crystal Reports, UPI

ETI, Prism, SAS

Informatica, Oracle DataMart,
Sagent, DataStage

TIBCO, Mercator for SAP,
Digital BusinessBus

ArcPlan
 Microsoft SQL Server 2000
Copyrights, 2000, Information Frameworks
September 2000
23
Strategies for implementing BI solutions using BW
Copyrights, 2000, Information Frameworks
September 2000
24
ASAP Methodology for BW
Source: SAP
Copyrights, 2000, Information Frameworks
September 2000
25
Lowest Total Cost of Ownership
Data Warehouse Cost Structure
SAP BW Cost Reduction
Rest
2%
Hardware &
Communication
13%
Operation/
Administration
9%
DWH-Software
13%
End-User Costs
35%
Copyrights, 2000, Information Frameworks
Implementation
& Ongoing
Upgrades
28%
September 2000
Source: Strategy Partners International, 1999
26
Lowest Total Cost of Ownership
Total Costs in 5 Years
18,000
Rest
16,000
14,000
Operation/Administration
'000 DM
12,000
End-User Costs
10,000
8,000
Implementation and
Ongoing Upgrades
6,000
Other Software
4,000
DWH-Software
2,000
Hardware and
Communications
0
Alt A
SAP BW
Alt B
Source: Strategy Partners International, 1999
Case study at live SAP BW customer
Copyrights, 2000, Information Frameworks
September 2000
27
Reasons for selecting BW
• Business know-how is built in - rich Business
content
• Hub for eBusiness applications
• Powerful analytical applications
• Enterprise wide data management tools
• Single-point-of-administration
• Leverage R/3 knowledge
• Open architecture
• Web enabled
• Portal ready
Copyrights, 2000, Information Frameworks
September 2000
28
Reasons for selecting BW as Information
Supply Hub
Lowest total cost of ownership
Seamless integration with the eBusiness processes
Mature Product
Proven high performance and scalable infrastructure
Global Support
Vendor Stability - SAP is here to stay...
Copyrights, 2000, Information Frameworks
September 2000
29
Questions !
Naeem Hashmi
Founder, CTO
The Information Frameworks
URL: http://infoframeworks.com
Copyrights, 2000, Information Frameworks
September 2000
30