| With the development of information, the strategic information plays more important role for the business. The retail trade is an important industry in our national economy. In recent years, the retail trade business enterprises develop more quickly, especially the medium and small-sized chain supermarkets, which take up a great deal of market quota. At the same time, the competition between business enterprises is also gradually vigorous. The medium and small-sized business enterprises, who want to obtain advantages in the competition, must understand the circumstance of selling and conducting to themselves well, so that they can draw up the strategy, to improve their own competition level. To understand their own sale and managements more, they need to carry on the data analysis. The data warehouse and technique of OLAP are exactly developed to meet such requirements. Therefore, constructing the model of retail trade data analysis by the data warehouse and technique of OLAP contains important and practical significance.This thesis first analyses the technique and thought of data warehouse and OLAP, to select reasonable technique and design models for the retail trade .Then it takes"the nice day chain supermarket of Heibei province"as the background, to construct the requirements analysis of the data warehouse model by studying the system of OLTP and the database frames that the business enterprises conduct currently .At the same time, the customer flow data are added to the project model. Then the topic design, the ETL design and the dimensional model design are carried on. After that, data warehouse and data of many dimensions are set up, and the possibility of that model is proved by analysis the actual sale data of the business enterprises and reasonable customer flow data obtained using the OLAP model. At the same time, this thesis quests the Web models of OLAP.Finally, it summaries the result to the thesis, and puts forward to the further research work. |
PDF Full Text Request