Application of Data Warehouse in Commercial Banks
Binbin Yang · Microcomputer applications · 2008
With the widely application of MIS in large enterprises, especially in banks, the information system has stored a large amount of data that is even increasing dramatically now. In this information era, the managers of banks try to find out the operation condition and exterior environment to make scientific decisions by analyzing the data, and to stand up in the serious competition. This paper introduces some basic knowledge of data warehouse's components and the dimensional modeling. It also gives some ideas about the elementary architecture of Banking Credit Card's Data Warehouse and the great advantages of using Data Warehouse in credit card business. Through a whole flow of a project based on banking data warehouse, the article gives the detailed ideas of the methods of data reception, data transformation and data loading. According to a real requirement by banking business customers, we made the analysis of the requirements and designed the dimensional model to solve this problem, and created two reports to support the decision making of customers' category. Finally, we made a summary and introduced some advanced applications, such as Online Analysis Process and Data Mining with Data warehouse.