Design And Implementation Of Chain Sales Distribution Decision Support System Based On Data Warehouse

At present, the rise of small chain enterprise makes how to distribute goods by the head office to the store a pressing issue. Before, distribution requirements set by artificial. It mainly based on personal experience and has a variety of disadvantages. If enterprises can make correct forecast of the demand for distribution by using the valuable information from their business data, their distribution costs can be reduced. So based on the specific business of jewelry enterprise, this thesis provide the decision support systems of distribution a data warehouse solutions. The main works are as follows:1. Analyze the theoretical basis of a decision support system and particularly discuss data warehouse and data mining’s role for the decision support system. Deeply analyze the characteristics for small and medium-sized chain sales data and the artificial prediction method, point out the limits of artificial decision.2. According to the actual business, on the analysis of the business process and information process, to construct a data warehouse system facing chain sales and distribution decision. Based on data warehouse, using microsoft’s OLAP to set up corresponding multidimensional data view, namely the multi-dimension data, which can transfer the data in the data warehouse into the information needed by decision analysis to meet the needs of senior management’s multidimensional analysis.3. Using c#.net to develop a front-end tool, make the decision data and view to show up by obvious way. User interface is friendly and easy-using. All of the store’s sales and inventory information are provided to senior managers for the next distribution decision support.The decision support system realized by this thesis is a subsystem of B/S structure of information management system. The system has been put into practical use in Baoruiyuan Company of Anhui Province successfully.