ch1.datawhse.dss

ch1.datawhse.dss - SAP Business Warehouse High Level...

Info iconThis preview shows pages 1–15. Sign up to view the full content.

View Full Document Right Arrow Icon
1 SAP Business Warehouse High Level Overview Gary Krudys 4/24/02
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Agenda Data Warehouse Concepts 101 Definitions SAP BW Architecture Components Future Business Information Competency Center Acronym Bingo
Background image of page 2
3 DW Concepts 101 Data Warehouse “a subject oriented, integrated, non-volatile and time-variant collection of data in support of management decisions” …. W.H. Inmon “the coordinated, architected, and periodic copying of data from various sources, both inside and outside the enterprise, into a an environment optimized for analytical and informational processing” …. A. Simon “the means for creating and managing a data architecture for user access and analysis…. . this involves the design and creation of logical and physical database structures intended specifically for this purpose, and the extraction, transformation, consolidation and quality improvement of data to form information resource rather than raw data” …. Gartner
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 DW Concepts 101 Data Warehouse Context/Architecture Data Information Access Business Questions Business Intelligence
Background image of page 4
5 Data Information Access Data Warehouse Context/Architecture GK Business Questions Internal/External Operational Data DW Repository Tools - Query - Reporting - Analytics - Trending - Graphing
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 DW Concepts 101 – DW Components Transaction Data Reformatted/Multidimensional Data Metadata Data Information Access
Background image of page 6
7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
8
Background image of page 8
9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
10 DW Concepts 101 Multidimensional Data Model
Background image of page 10
11 DW Concepts 101 – DW Components Transaction Data Reformatted/Multidimensional Data OLAP – online analytical processing OLTP – online transaction processing ETL Data Information Access
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
12 Data Information Access Data Warehouse Context/Architecture GK Business Questions Internal/External Operational Data DW Repository Tools – Query,Reporting, Analytics, Trending,Graphing
Background image of page 12
13 Data Information Access Data Warehouse Context/Architecture GK Internal/External Operational Data DW Repository Tools – Query,Reporting, Analytics, Trending,Graphing Business Questions For a hospital with a bed size of ‘X’, what is the total dollar volume of Welch Allyn business by product category For all or a specific hospital with a bed size of ‘X’, what is the total dollar volume of Welch Allyn business GPO contracts, identify associated member hospitals and their respective dollar volume of Welch Allyn business in total and by product category Compare contract hospitals with non-contract hospitals of similar size by total dollar volume and by product category
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Information Access Data Warehouse Context/Architecture GK Internal/External Operational Data DW Repository Tools – Query,Reporting, Analytics, Trending,Graphing Business Questions For all or specific geographic areas, what is the total dollar volume by hospital within these areas What geographic areas are weak or strong Identify market potential by geographic area What is WA market share vs. competitors
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/05/2011 for the course IST 352 taught by Professor Staff during the Fall '10 term at Syracuse.

Page1 / 33

ch1.datawhse.dss - SAP Business Warehouse High Level...

This preview shows document pages 1 - 15. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online