BCO6676 Business Intelligence
Task:
Question 1
(a) What is the difference between SAP business suite and Netweaver Suite?
(b) List all products available in 2019 under SAP business suite and Netweaver suite.
(c) What is difference between SAP BW, SAP BW on Hana and BW4/Hana?
Question 2
(a) Explain the use of facts, dimension’s and surrogate tables in a star schema model.
(b) What is the difference between a Star Schema fact table and extended start schema?
(c) What is the difference in navigational and display attributes in BW implemenatation?
Question 3
(a) Describe OLAP and OLTP with three feature, benefit and drawback each.
(b) What are the main components of business intelligence process lifecycle?
(c)Name three vendors providing OLTP and OLAP products or services.
Question 4
In your own words, define and compare each of the following SAP terms
(i) InfoObjects (Characteristics, Key Figures)
(ii) DataSource and Source System
(iii) Data Transfer Process (DTP) and Infopackage
(iv) Master Data and transaction data
(v) InfoCube and Infosets
(vi) Data Store Objects and Advance DSO.
