A research on constructing data warehouse in support of order procurement for steel industry

• Main Authors: Chien-Ting Lu, 陸健婷
• Other Authors: San-Yi Hwang
• Format: Others
• Language: zh-TW
• Published: 2003
• Online Access: http://ndltd.ncl.edu.tw/handle/94638298906647742081

碩士 === 國立中山大學 === 資訊管理學系研究所 === 91 === Failure to identify major target market and lack of cost management have shown to be negative for enterprise operations. To remedy these two problems information technologies have promised to support effective and efficent decision-making processing by providing accurate and real-time information, so as to assist front-line sales, to lower down costs, to create more profits and to further diversified the risks. In steel industry, the repeated purchasing frequency (associated with customer loyalty) has been identified as one of the major determinants due to the narrow target market and capital-intensive features existed in steel business. Steel businesses often involve international transactions, which have much higher uncertainties than domestic transactions. Therefore, the major risk control task is on the collection and analysis customers’ creditability. More customer information leads to fewer risks. As such, we believe that by applying the methodology of collecting and analyzing information through information technologies, the decision makers will be more confident in making correct decisions, which in turn help to generate profits. In this thesis, we develop a data warehouse system in support of order procurement. We begin by identifying the types of information that is crucial in making order procurement decision by consulting with the experienced international and domestic front-line sales managers. The different types of information are prioritized by applying Analytic Hierarchy Process (AHP) approach. We then construct a datawarehouse model that encompasses these information. A system prototype is finally developed to demonstrate the feasiblity of our approach.