Sap Bw Data Warehouse Technology In Business Analysis

Data warehouse can process and integrate huge amounts of Heterogeneous datafrom the interior and the exterior of an enterprise according to need of assistingdecision-making procedure. It can also provide senior administrative managers withdifferential and efficient data analysis. As such, data warehouse is the focus of currentresearch in information processing technology.To maintain and expend our client crowd in competition, to increase customvalue, usually, we have to find out our customs' behavior pattern, as well as how theyexpend their business, collect profit, market and provide supports in their dailyoperation. This will aid us instituting reasonable and efficient operation strategy totake the leading position in competition.This article uses a large manufacture enterprise as an example to illustrate thedesign and application of data warehouse system for medium/large corporation. By far,enterprise has systematically implemented core operation systems, such as ERP, PLM,CRM and SCM, and collected history data after years of application. However, thecurrent system run at event-response mode and store data in an isolated fashion,which limits us from identifying valuable information and potential knowledge. Datawarehouse and business intelligence technology created an application environment,which facilitates us to efficiently uncover information and knowledge at deep leveland transforms indirect and obscure information into a straightforward way. Themanagers will benefit from it in decision making process.Based on the analysis of the requirement, Enterprise set to establish datawarehouse and on-line analysis progress (OLAP) system. Through analyzing yearscollected operation data/record, valuable conclusions can be draw from it. On thebasis of mastering previous and current operational information, an integrate,reasonable and precise analysis/forecast of corporation future can be made. Thisarticle briefly summarized data warehouse and business intelligence technology, aswell as the protocol and procedure to implement it. An corporation oriented datawarehouse technology have been designed and embodied, a corporation analysismodel has been proposed and the application of information analysis in enterpriseoperation has been exemplified.