Analysis And Design Of Revenue Forecasts Organization System For Small And Medium-Sized Local Taxation Bureau Based On DM

With the development of information technology, the tax authorities at all levels can obtain the tax collection and administration of data capacity is more and more big, huge amounts of data of tax collection and administration, behind a lot of important information.In the traditional tax forecasting work, integrate the "information island" and tax agencies cannot effectively, while the lack of tax collection and management of data hiding behind the discovery of knowledge means, thus appeared "data explosion but knowledge poor" phenomenon. Tax forecasting researchers hope to tax collection and management of data on mass for a deeper analysis, correlation between generation and revenue forecast more tax collection data, to provide help for the tax revenue forecasting and decision.Application of the Visual Basic for Applications (VBA) combined with data mining technology in the revenue forecast, in the control and Analysis on the basis of the development of data mining technology, traditional tax forecasting technology, process modeling, data preprocessing, association rules mining, mining to the tax revenue collection data for research, the main work completed is as follows:1. small and medium-sized local tax bureau tax forecasting system requirements analysis, combined with the tax collection and management of data processing and the business demand, proposed the small local tax bureau tax forecasting system design framework;2. On the basis of tax collection and management of data storage and processing status of understanding, according to the requirements and the data mining technology in tax collection and management of data in the data, the data preprocessing technology common and applicable condition;3. Component design, data mining, according to the tax collection and management characteristics of data called SQL Severe2000Microsoft decision tree and Microsoft aggregation methods for data mining; 4. Component design for prediction of tax, tax forecasters habits, using VBA mode in EXCEL2003based on time series prediction method, based on tax and economic relationship;5. Design and other related componentsThe main functions of the system had reviewed by tax forecasting personnel,which obtained a good evaluation. These results can help researchers to do further forecast revenue forecast, so as to improve the accuracy of forecast of revenue, the low level of simple query, statistics application of tax collection and management data to knowledge mining and decision support advanced applications.