The Application Of Data Warehouse In Manufacture And Distrubution Industry

Delta company is the core company of the MASCO Group—The largest group in resident and decoration industry in United States, and one of the fortune 500 companys, She has over 50 years experience in producing commercial faucets, The main products are faucets and related accessories. Delta has many patents and innovations in faucets. Delta is the most well-known brand in US. The total distribution amount is over 1 billion dollars per year. The main competitors are Moen, Kohler, America Standard. How to survive from the fierce marketing competitions, so much as to keep ahead in the marketing, This urges the enterprise to command the marketing rules, and to establish some strategies that comply with the marketing rules. How to command the marketing rules well? As general speaking: the history is the mirror. This means: the history indicates the future, the rules found in the history can direct the future way.Currently many companies have some information systems, these systems produce a lot of business data, and the data increase very rapidly. Delta is in the same situation. Delta company's information system takes the JD Edwards ERP system as the central part, the assistant system are the warehouse management system PKMS, the factory planning system i2. These system include modules: manufacture, Accounting Receivable, Accounting Payable, General Accounting, Sales, Purchase, Inventory modules and etc. The system modules produce a lot of data, how to mine some marketing rules from these data to accelerate the development of the enterprise? Delta company use the data warehouse and data mining to do this.There are some applications for data warehouse and data mining in domestic, but these applications are focus on some specific industries. Such as: Bank, Paper, Insurance, Telecom, there are few applications in manufacture and distribution industries, whereas these industries are important to the country economy. As the advanced application of the IS, More and more enterprises will implement the data warehouse system and data mining system. Delta company is a company in manufacture, and use many modules of the information system.This is a good sample for the domestic company that will establish the data warehouse system.The author has joined the Delta IS team to implement the PeopleSoft EnterpriseOne ERP and to establish the data warehouse. The main responsibilities of the author is that: to analyst the business requirements of the manufacture and distribution company, to Extract, Transform and load the data form the application system to the data warehouse; and to design some analytical report to analyst the business situations, such as the Purchasing Cost analyst, Purchasing Items analyst, Inventory analyst etc. The IS of delta consists of many application systems, This thesis first presents the application system network architecture that related to the data warehouse, and then put forward the architecture of the data warehouse and related technology, such as ERP, Web Method interface between different application system, data mining(Hyperion), report layer technology(Crystal Enterprise) etc. Because data extract, transformation, load(ETL) procedure is very important to the data warehouse, So this thesis details this procedure and give a sample for this procedure. After creating the data warehouse, this thesis continue to present the application of data warehouse in Delta business, for example: Cost analyst in finance, Purchasing analyst, Inventory analyst, Sales analyst etc. These applications approve that the data warehouse is very useful and important to the enterprise. At last, this thesis present the advanced application in Delta: Bl (Business Intelligent), this is the direction of data warehouse developing, and it is the advanced application of data warehouse.The data warehouse is beneficial to the finance analyst, purchasing cost analyst, inventory veracity, decreasing unnecessary inventory etc for Delta company. Current version of this data warehouse is in the original status, and it is in the improving, however, t...