Banking Business Intelligence System Design And Implementation

Along with the computer technology development, the bank has experienced three stages in computer techniques application: application in service , data from branch centralism, application in bank management .At present the majority banks have completed the second stage. Faced with the intense market competition, computer application in the bank management becomes extremely urgent. The Data Warehouse and the Business Intelligence (BI) techniques provided the support platform for such using .The bank have accumulated lot of data in the over the years management, may withdraw the latent effectively commercial knowledge with the aid of the Business Intelligence techniques from these data, for managers the policy-maker and the bank control section refers. Therefore Business Intelligence application in bank hold very important role. Since on century 90's, the more and more overseas banks have constructed the Business Intelligence system, and manifested its superiority. After use the Business Intelligence technology, these bank have promoted the market competition ability and the management efficiency greatly. After several years, Our country bank Business Intelligence application also gradually start.The bank Business Intelligence system architecture divides into three levels: the data source, the data storage and the data analysis. The Business Intelligence system application scope is different append on different domain. This article unifies the Bank services and the service flow, depand on the various departments application demand, divides the bank Business Intelligence system application scope into the five kinds: comprehensive management analysis, the customer relations management, the credit risk management, the achievements analysis ,the statistical report system and so on. The paper aLso elaborated the bank Bussiness Intelligence system and the application goal. Because in the Business Intelligence system construction, the data warehouse modelling based on the bank service flow is playing the extremely important role, therefore this paper discusses the data warehouse establishment process. Also analysis the subject of data warehouse, the conceptual model, the logical model, the physical model modelling, and the data sources. Also design the ETL process, and by"customer relations management"as an example, explained with OLAP as well as the data mining technology in the bank Bussiness Intelligence application. This article carried on the preliminary exploration to the Bussiness Intelligence application in bank.