copyrights, 2000, information frameworks september 2000 1 business information warehouse september...
TRANSCRIPT
Copyrights, 2000, Information Frameworks September 2000 1
Business Information WarehouseBusiness Information WarehouseBusiness Information WarehouseBusiness Information Warehouse
September 2000September 2000
Naeem HashmiFounder, CTO
The Information FrameworksURL: http://infoframeworks.com
Copyrights, 2000, Information Frameworks September 2000 2
PLEASE NOTE!PLEASE NOTE!PLEASE NOTE!PLEASE NOTE!
• This document is part of a presentation This document is part of a presentation that author delivered at an SAP event on that author delivered at an SAP event on September 2000.September 2000.
• As Technical architecture and the As Technical architecture and the functionality about all products discussed functionality about all products discussed in this document may have changed since in this document may have changed since its composition, author takes no its composition, author takes no responsibility for their latest functionality responsibility for their latest functionality missing in this presentation.missing in this presentation.
• For latest product information, contact the For latest product information, contact the respective vendor.respective vendor.
• This document is part of a presentation This document is part of a presentation that author delivered at an SAP event on that author delivered at an SAP event on September 2000.September 2000.
• As Technical architecture and the As Technical architecture and the functionality about all products discussed functionality about all products discussed in this document may have changed since in this document may have changed since its composition, author takes no its composition, author takes no responsibility for their latest functionality responsibility for their latest functionality missing in this presentation.missing in this presentation.
• For latest product information, contact the For latest product information, contact the respective vendor.respective vendor.
Copyrights, 2000, Information Frameworks September 2000 3
AgendaAgendaAgendaAgenda
• What is Business Intelligence?• What is SAP Information Warehouse (SAP BW)• How SAP BW Compares with 3rd Party Data
Warehouse Tools?
• 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 4
Richard Finklestein Ralph Kimball
Ken Orr Doug Hackney John ZachmanLarry English
Bill Inmon
Claudia Imhoff
The Data Warehouse people... The Data Warehouse people... The Data Warehouse people... The Data Warehouse people...
Copyrights, 2000, Information Frameworks September 2000 5
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 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 Business Intelligence TerminologyTerminology
• • Executive Information SystemsExecutive Information Systems• • Decision Support SystemsDecision Support Systems• • Enterprise Information SystemsEnterprise Information Systems• • Management Support Systems Management Support Systems • • OLAPOLAP ( (OOn-n-LLine ine AAnalyticalnalytical P Processing)rocessing)
• • Balanced Score CardsBalanced Score Cards
as well as newer technologies such as:as well as newer technologies such as:
• • Data MiningData Mining• • Data VisualizationData Visualization• • Geographic Information SystemsGeographic Information Systems
Data Analysis
EISQuery &
Reporting
InternetData Mining
Business Information DatabaseRDBMS
Business Intelligence Environment
Legacy Systems
Mid to late 70’sEarly 80’s
Late 80’s
Early to Mid 90’s
Legacy SystemsLegacy Systems
Legacy Systems
MDBMS
Knowledge ManagementKnowledge Management
The Business Intelligence The Business Intelligence The Business Intelligence The Business Intelligence
Copyrights, 2000, Information Frameworks September 2000 6
The Data Warehouse definitionThe Data Warehouse definitionThe Data Warehouse definitionThe Data Warehouse definition
Bill Inmon, known as the father of Bill Inmon, known as the father of data warehousing, data warehousing,
defines a data warehouse as defines a data warehouse as
"a subject-oriented, integrated, "a subject-oriented, integrated, non-volatile and time-variant non-volatile and time-variant collection of data in support collection of data in support
of management decisions."of management decisions."
Bill Inmon, known as the father of Bill Inmon, known as the father of data warehousing, data warehousing,
defines a data warehouse as defines a data warehouse as
"a subject-oriented, integrated, "a subject-oriented, integrated, non-volatile and time-variant non-volatile and time-variant collection of data in support collection of data in support
of management decisions."of management decisions."
Copyrights, 2000, Information Frameworks September 2000 7
Architectural layers of a Data WarehouseArchitectural layers of a Data WarehouseArchitectural layers of a Data WarehouseArchitectural layers of a Data WarehouseW
AR
EH
OU
SE
MA
NA
GE
ME
NT
SERVICE PROVIDER
DATA PROVIDER
INFORMATION PROVIDER
Data SourcesData Sources
Information ConsumersInformation Consumers
Information Delivery
Content Management
Content CreationInformation Acquisition
Copyrights, 2000, Information Frameworks September 2000 8
Ralph Kimball ApproachRalph Kimball ApproachRalph Kimball ApproachRalph Kimball Approach
• The Father of Star Schema - deal for OLAP.• The Father of Star Schema - deal for OLAP.
Classification criteriaClassification criteria Key figuresKey figures
PeriodPeriod DivisionDivision CustomerCustomergroupgroup
PlantPlant ProductProductgroupgroup
Prod.Prod.quantityquantity
SalesSalesvolumevolume
RevenueRevenue Prod.Prod.costscosts
EmployeesEmployees FixedFixedassetsassets
Re
gio
ns
Re
gio
ns
DivisionsDivisions
Fiscal Fiscal yearsyears
Re
gio
ns
Re
gio
ns
DivisionsDivisions
FiscalFiscalyearsyears
Re
gio
ns
Re
gio
ns
DivisionsDivisions
FiscalFiscalyearsyears
"What is my profitability by customer over time, by region ?"
Copyrights, 2000, Information Frameworks September 2000 9
Types of Data WarehousesTypes of Data WarehousesTypes of Data WarehousesTypes of Data Warehouses
Da
ta
So
urc
es
Data Warehouse
Independent Data Marts
Data Marts
Data Warehouse
Da
ta
So
urc
es
Dependent Data Marts
Data Marts
Da
ta
So
urc
es
Data Warehouse
Global Data Warehouse
Copyrights, 2000, Information Frameworks September 2000 10
Characteristics of Information ObjectsCharacteristics of Information ObjectsCharacteristics of Information ObjectsCharacteristics of Information Objects
Operational - enable the user to maintain control over day to day transactions in a transactional system
Overdue OrdersOrders on HoldReleased sales orders
Overdue OrdersOrders on HoldReleased sales orders
Fiscal/legal - fulfill external and statutory governance reporting requirements which are mandatory for the corporation
Consolidated Income StatementBalance SheetTax ReportingSales Out
Consolidated Income StatementBalance SheetTax ReportingSales Out
Management - assist in analysis or measurement based on key performance indicators/metrics of the business
Orders and Backlog reportingProfitability Analysis (e.g. product P&Ls)Variance Analysis (performance vs.. plan)
Documents - to share knowledge among a broad spectrum of audience - public and private, multimedia
Product AnnouncementsTechnical Support MaterialProduct specifications
Ad Hoc Query
Batch Processing
OLAP
Mostly Static INTERnetINTRAnet
OL
TP
DA
TA
WH
/MA
RT
KN
OW
LE
DG
E W
H
Enterprise Information Portals Enterprise Information Portals
Copyrights, 2000, Information Frameworks September 2000 11
Typical Data Warehouse ComponentsTypical Data Warehouse Components
Copyrights, 2000, Information Frameworks September 2000 12
Components of SAP BWComponents of SAP BW
Copyrights, 2000, Information Frameworks September 2000 13
SAP BW - Open Solution - 3rd Party IntegrationSAP BW - Open Solution - 3rd Party IntegrationSAP BW - Open Solution - 3rd Party IntegrationSAP BW - Open Solution - 3rd Party IntegrationArcplan Information Services inSight 2.35 15.12.98 BW-ODB 1.2
Business Objects Business Objects 15.12.98 BW-ODB 1.2
Cognos, Inc. Power-Play SAP BWInterface
1.0 13.01.99 BW-ODB 1.2
Seagate Software Seagate WorksheetSeagate Crystal ReportsSeagate Holos
777
17.03.99 BW-ODB 1.2
Brio Technology, Inc. Brio Enterprise 6.0 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
Informatica Corp. PowerCenter 4.5 08.06.98 BW-STA 1.2
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 WarehouseConnector
4.0 09.06.99 BW-STA 1.2
Information Builders, Inc. SNAPpack Data Migrator 2.6 11.08.99 BW-STA 1.2
SuperNova International B.V. Supernova for BusinessWarehouse
08.12.99 BW-STA 1.2
Ardent Software DataStage load pack forSAP BW
02.02.00 BW-STA 1.2
Data Load
Data Access
ACNielsen U.S EDW* Connect 1.02 20.07.99 BW-DPI 1.2
Others
Copyrights, 2000, Information Frameworks September 2000 14
Comparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 18
Comparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 19
Comparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 21
Comparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 23
Comparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData Warehouse Construction ToolsComparing SAP BW with 3rd Party Comparing SAP BW with 3rd Party Data Warehouse Construction ToolsData 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 24
Strategies for implementing BI solutions using BWStrategies for implementing BI solutions using BW
Copyrights, 2000, Information Frameworks September 2000 25
ASAP Methodology for BWASAP Methodology for BWASAP Methodology for BWASAP Methodology for BW
Source: SAP
Copyrights, 2000, Information Frameworks September 2000 26
Rest2%
Operation/ Administration
9%
Hardware & Communication
13%
DWH-Software13%
Implementation & Ongoing Upgrades
28%
End-User Costs35%
Lowest Total Cost of OwnershipLowest Total Cost of OwnershipData Warehouse Cost Structure
SAP BW Cost Reduction
Source: Strategy Partners International, 1999
Copyrights, 2000, Information Frameworks September 2000 27
Lowest Total Cost of OwnershipLowest Total Cost of OwnershipLowest Total Cost of OwnershipLowest Total Cost of Ownership
Total Costs in 5 Years
0
2,000
4,000
6,000
8,000
10,000
12,000
14,000
16,000
18,000
Alt A SAP BW Alt B
'00
0 D
M
Rest
Operation/Administration
End-User Costs
Implementation andOngoing Upgrades
Other Software
DWH-Software
Hardware andCommunications
Source: Strategy Partners International, 1999Case study at live SAP BW customer
Copyrights, 2000, Information Frameworks September 2000 28
Reasons for selecting BWReasons 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 29
Reasons for selecting BW as Information Reasons for selecting BW as Information Supply HubSupply HubReasons for selecting BW as Information Reasons for selecting BW as Information Supply HubSupply Hub
Lowest total cost of ownershipLowest total cost of ownershipSeamless integration with the eBusiness processesSeamless integration with the eBusiness processes
Mature ProductMature ProductProven high performance and scalable infrastructureProven high performance and scalable infrastructure
Global SupportGlobal SupportVendor Stability - SAP is here to stay...Vendor Stability - SAP is here to stay...
Lowest total cost of ownershipLowest total cost of ownershipSeamless integration with the eBusiness processesSeamless integration with the eBusiness processes
Mature ProductMature ProductProven high performance and scalable infrastructureProven high performance and scalable infrastructure
Global SupportGlobal SupportVendor Stability - SAP is here to stay...Vendor Stability - SAP is here to stay...
Copyrights, 2000, Information Frameworks September 2000 30
Questions !
Naeem Hashmi
Founder, CTO
The Information Frameworks
URL: http://infoframeworks.com