Design And Implementation Of Tobacco Trade Analysis System

With the rapid development of the tobacco industry, a wide variety of tobacco business and a lot of tobacco shopkeepers bring rich services experience for users. As the large volume of the data generated in this process, it becomes a challenge for the tobacco companies on business data analysis and making sales strategy. At present, the provincial tobacco company average weekly generates60million records, and how to manage and analysis this large volume data to forecast tobacco market demand trends and timely find the problems existing in the tobacco business operations, etc., is a big problem for sailing the tobaccos. To solve the above problems, we have to reform the tobacco business sailing manage system by using the modern network management ways. At the same time, we have to adopt the method of on-line analytical processing (OLAP) to enable the multidimensional analysis technology. So the sales man can operate tobacco business data analysis effectively. In this paper, based on the analysis of the demands on tobacco business data analysis, for solving the current problems in tobacco company Marketing Department and sales department in sales operations, we design tobacco online ordering system, information management system of sales process of tobacco companies, at the same time, using the data warehouse and multidimensional analysis technology, design and development of tobacco sales analysis system.In this thesis, our contributions mainly include:1. Research the current status of the tobacco sales environment from the tobacco market, and we complete the demand analysis and the function deign of the system;2. Design the system architecture of the tobacco access, sale and order system, and we select the development environment;3. Propose the multidimensional analysis technology for the system, and we design the method and define the implementation process;4. Design the key module of the system including the data analysis, data visualization part design, and we give the implementation in details.System has been developed and implemented for nearly one year, and has achieved good performance.