Research On The Structure Of Fiscal And Tax Data Warehouse And Forecast Of Department Budget Data

With the rapid development of computer technology, financial informatization level also rises rapidly, and various business system increasingly accumulated data, how to effectively to the fiscal and taxation data integration and analysis, effectively improve the utilization rate of the data, fully implement the data value, is an urgent problem in the fiscal and taxation data analysis and processing. Department budget in the specific practice has a budget is not scientific, budget, low accuracy, with the rise of the data mining technology, how to use the data mining technology to advanced history department budget data mining, mining characteristic, found the law of the data, thus to effectively predict the future department budget data, financial data analysis is another important issue need to research.First, according to the financial department of different business system data sync issue such as difference of timeliness, data analysis, proposed a fiscal and taxation system overall architecture of data warehouse. Using the method of combining the technology of ETL and data scheduling software, the tax data analysis and processing related data in a business system according to the data for the fiscal and taxation, and special processing steps, unified extraction, transformation, loaded into the data warehouse system of revenue.Second, in order to further analyze the data and improve the utilization efficiency of data, for the purpose of using IBM Cognos tools for data analysis, the data is multidimensional, all aspects of the visual analysis. Adopted a chart the results of data analysis in combination with linkage analysis of data, chart display, break through the traditional way of data visualization report, make a smart statements can not only meet the same dimension between the different levels of traceability down, also can meet the link function between different statements, intuitive, image display data information such as the characteristics and trends.Once more, put forward a model based on time series algorithm is applied to the department budget data. According to the department budget data sequence characteristics, this paper using ARIMA model for time series modeling algorithm and algorithm steps is designed.Finally, the design experiment the department budget forecasting algorithm based on time series is applied in the department budget data, department budget forecast experiments, to predict data guide financial practice.