| The rapid development of chain supermarket has become the most dynamic area in this form of business. Delivery center is an important department realizing centralized purchasing and unified distribution. To a great extent the running results of chain supermarkets are due to working quality of delivery center. Research and design an advanced delivery system is meaningful to improve the management level of chain supermarkets.This paper is majored in analyzing how to make use of the business intelligence technique, such as the data warehouse,online analytic process(OLAP) and data mining(DM), to design the system for chain supermarket that has the character and active characteristics. The research is mainly focused on th following aspects:1.We analyzed workflow of the delivery center. we also analyzed the shortage that tradition delivery project, and advantage that active delivering project and the project with the character. Base on the technicque of data warehouse, OLAP and DM, we researched design project that has the character and active characteristics;2.According to the effective demand of the system, we built regard sale fact as the central data warehouse model, and established this data warehouse by the data warehouse tool of MS SQL Server 2000;3.We proceed to synthesize the analysis to the detailed sale data by technique of OLAP and DM, including the analysis of ABC, merchandise connection analysis, main customer and their consuming the behavior analysis. And then we established the delivery model for the store of the chain supermarket;4.According to the business process and relevant request,we designed the delivery dystem with Delphi 2005. In the system,we used the method of MDX and PivotTable to get the data from the data warehouse. And using the FP_growth calculate way,we came to association analysis to realize sale merchandise.In the end, we used the supermarket data to explain the system with the operation method. |
PDF Full Text Request