1 / 30

Business Information Warehouse

Business Information Warehouse. Naeem Hashmi Founder, CTO The Information Frameworks URL: http://infoframeworks.com. September 2000. PLEASE NOTE!. This document is part of a presentation that author delivered at an SAP event on September 2000.

gen
Download Presentation

Business Information Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Information Warehouse Naeem Hashmi Founder, CTO The Information Frameworks URL: http://infoframeworks.com September 2000 Copyrights, 2000, Information Frameworks September 2000

  2. 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

  3. 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

  4. The Data Warehouse people... Bill Inmon Ken Orr Doug Hackney Claudia Imhoff John Zachman Richard Finklestein Ralph Kimball Larry English Copyrights, 2000, Information Frameworks September 2000

  5. 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 as well as newer technologies such as: • Data Mining • Data Visualization • Geographic Information Systems Business Intelligence Environment EIS Data Analysis Query & Reporting Early 80’s Mid to late 70’s Late 80’s Early to Mid 90’s Data Mining Internet MDBMS Business Information Database RDBMS Legacy Systems Legacy Systems Legacy Systems Legacy Systems Knowledge Management Copyrights, 2000, Information Frameworks September 2000

  6. 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

  7. Information Consumers INFORMATION PROVIDER SERVICE PROVIDER WAREHOUSE MANAGEMENT DATA PROVIDER Data Sources Architectural layers of a Data Warehouse Information Delivery Content Management Content Creation Information Acquisition Copyrights, 2000, Information Frameworks September 2000

  8. Regions Regions Regions Fiscal years Fiscal years Fiscal years Divisions Divisions Divisions Ralph Kimball Approach "What is my profitability by customer over time, by region ?" • The Father of Star Schema - deal for OLAP. • Key figures • Classification criteria Period Division Customer group Plant Product group Prod. quantity Sales volume Revenue Prod. costs Employees Fixed assets Copyrights, 2000, Information Frameworks September 2000

  9. Data Warehouse Data Sources Global Data Warehouse Data Warehouse Data Sources Data Marts Dependent Data Marts Data Warehouse Data Sources Data Marts Independent Data Marts Types of Data Warehouses Copyrights, 2000, Information Frameworks September 2000

  10. Ad Hoc Query OLTP Operational- enable the user to maintain control over day to day transactions in a transactional system • Overdue Orders • Orders on Hold • Released sales orders Batch Processing Fiscal/legal- fulfill external and statutory governance reporting requirements which are mandatory for the corporation Consolidated Income Statement Balance Sheet Tax Reporting Sales Out DATA WH/MART OLAP Management - assist in analysis or measurement based on key performance indicators/metrics of the business Orders and Backlog reporting Profitability Analysis (e.g. product P&Ls) Variance Analysis (performance vs.. plan) Mostly Static INTERnet INTRAnet Documents- to share knowledge among a broad spectrum of audience - public and private, multimedia Product Announcements Technical Support Material Product specifications KNOWLEDGE WH Enterprise Information Portals Characteristics of Information Objects Copyrights, 2000, Information Frameworks September 2000

  11. Typical Data Warehouse Components Copyrights, 2000, Information Frameworks September 2000

  12. Components of SAP BW Copyrights, 2000, Information Frameworks September 2000

  13. SAP BW - Open Solution - 3rd Party Integration Data Access Data Load 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, 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 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

  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, 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 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 • 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 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

  24. Strategies for implementing BI solutions using BW Copyrights, 2000, Information Frameworks September 2000

  25. Source: SAP ASAP Methodology for BW Copyrights, 2000, Information Frameworks September 2000

  26. Lowest Total Cost of Ownership Data Warehouse Cost Structure SAP BW Cost Reduction Rest 2% Hardware & Communication 13% Operation/ Administration 9% DWH-Software 13% Implementation End-User Costs & Ongoing 35% Upgrades 28% Source: Strategy Partners International, 1999 Copyrights, 2000, Information Frameworks September 2000

  27. Lowest Total Cost of Ownership Source: Strategy Partners International, 1999 Case study at live SAP BW customer Copyrights, 2000, Information Frameworks September 2000

  28. 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

  29. 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

  30. Questions ! Naeem Hashmi Founder, CTO The Information Frameworks URL: http://infoframeworks.com Copyrights, 2000, Information Frameworks September 2000

More Related