Xinjiang CCB KPI Assessment Information Syatem Design And Implementation

Along with the improvement of the domestic commercial bank level of management, management accounting principle is applied to improve and evaluate the management performance of all domestic branches, segments, and products in internal bank, seems to be increasingly important. On the business demand basis of the bank management accounting suggested by segments, we have analyzed the applied condition of the domestic and foreign management accounting information systems of banks, compared measures of the system schemes, selected data warehouse technology as the executive plan to design and implement the management accounting information systems. According to the principle and techniques of the data warehouse, we designed systematic physics structure and logic structure, business function and process.Having focused on the business demand, we proposed a kind of accidence analysis to convert clients' reports and queries into the concept model of multidimensional business analysis (information package), taking the concept model of multidimensional business analysis and the data source analysis as the foundation, according to the principle of dual driving of business demand and data demand, we designed the data warehouse dimension model. According to the steps of building multidimensional model, we chaise the best gradually with iteration, and we got the systematic multidimensional data logic model. Based on the data stored characteristics, we considered the efficiency of the respect data search, and designed out a systematic data physics model. It was guaranteed the concept model of multidimensional analysis, the data logical model, and the physics model on the language righteousness unity, predigested the systematic analysis and design the continuity and the uniformity of the operations.The multi-layer data model of the submission data warehouse application system, definition the role and the design procedure of the prelayer data model. Withdraw the mode with various data, the data of the multilayer gather the convert capability, the vivid dispatch supervision function for object, the ETL(data go on stage sector) structure design and functional designs that steer the system, the design data withdraws the regulations, data to clean the regulations, the data convert regulations, the select tapping favors the ETL(the data goes on stage the sector) tool, apply the tapping of ETL(the data goes on stage the sector) tool carry out the data to withdraw, the data clean, the data convert to support the function with data, the forming bank management computer-based accounting system data concerning area of subject data warehouse, according to the data warehouse data of the area of subject, then the convert transform summarizing, the forming faces to the analytical accounting for management information system data street data mart.Make use of the data warehouse front end pitch tool vs. the accounting for management information system of the data mart steer the pitch, include the subscribe righteousness search and reports, the batch generate the report, on-the-spot search, have another the dimension analysis, favor the WEB method of the data analysis calling wait various data pitch method. Practice according to the item tapping of the accounting for management information system, the logarithm is according to the implementation strategy, the tapping strategy of the data warehouse, test the strategy steered the study.