Study On The Construction Of Comprehensive Analysis System Of Bank Asset Management Based On Data Warehouse

With the rapid development of Internet finance and information technology,Banks are faced with the severe test of competitive strength in product design,customer service,profitability and other aspects,and they need to conduct differentiated and refined operation and management with the help of information technology to build core competitiveness.On the basis of the large data set,each big bank has established the management information system oriented to the business operation process.However,with the increase of channels of data acquisition and the expansion of data,asset management information system construction is also more and more,but the relative independence between each subsystem is serious,the data cannot be Shared,lack of overall consideration,unable to meet the data integration of multi-source system,flexible demand for data analysis,management,monitoring.In terms of research objects,the existing researches mainly focus on the bank management information system,but there are few technical applications and analyses specific to the asset management business.Therefore,this paper tries to build a bank asset management business comprehensive analysis system to meet the needs of internal and external users.This paper analyzes the user demand of bank asset management business,and constructs a comprehensive analysis system of bank asset management business based on data warehouse theory and big data technology.First of all,this paper summarizes the research status of data warehouse and bank information system at home and abroad,discusses the basic concepts,data warehouse,dimensional modeling and other related technologies,and defines the reporting requirements,theme requirements,collection and interface requirements and functional requirements on this basis.After that,this paper designed the comprehensive analysis system in accordance with the requirements,constructed a four-layer architecture based on the "MPP+Hadoop" framework,processed data in a hierarchical way and carried out dimensional modeling,and displayed the analysis results to users in a diversified way through Web visualization tools.Finally,this paper analyzes the application object,application scene,application benefit and difficulty of the system.This paper holds that the application of data warehouse can integrate multi-source and multi-type data and conduct multi-dimensional analysis according to the theme,which can greatly enhance the business analysis and decision-making ability and improve the management efficiency.Therefore,it is necessary to establish a comprehensive analysis system of bank asset management business based on data warehouse technology.The main achievement of this paper is to build the logical model and overall framework of the bank asset management business comprehensive analysis system,give the detailed design of functions and data,and discuss the problems that the system application may face.The deficiency is the lack of practical cases of information system application,system functions to be further explored in the practical application.