Product Analysis System For Iron And Steel Enterprise Based On Data Warehouse

Data Warehouse, a new data management technology which appeared several decades ago, is developing rapidly. It enables people to use tremendous data stored in the data warehouse to make appropriate decision, and helps people to achieve success in the severe competition of the worldwide market. The report form is an important dependence on which enterprise can know its business situation, make or modify the strategy of management and make a long term decision, so the veracity and betimes of the report forms is very important. The detailed discussion of this thesis includes the design of steel enterprise statistical system and its realization. Its main task is to analyze these products, such as Zhonggui, Xinggang, Fanggang and Yuangang, which are produced in Guiliang factory of Panggang, and show the data in report forms. Firstly, the brief introductions of data warehouse and Pangang steel ERP system is given; Data warehouse is the basis in developing this system. Pangang steel ERP system is data source. Secondly, this thesis gives full introductions of the processing and realization of ETL (Extract, Transform and Load) of Pangang enterprise statistical system, and analyzes the process of making data from data source to Zhuti, Taizhang, and report forms which users get. This thesis also gives full discussion of the design of the system's website module, and several key pages of the module, such as "report query", "resource management", and "report runtime log". Finally, this thesis discusses system test and its realization, including the software and hardware equipment and the network disposition.Pangang enterprise statistical system, which is based on data warehouse, can make reports more efficient and more accurate than before, and have excellent extensibility. It's also a good basis for the further development of enterprise information construction.