Data Warehouse Testing: A Step Towards using Business Intelligence in Banking

Abstract

In the modern era, technology plays a vital role by contributing in the development of business by providing various tools and techniques to enhance the business decision-making process. Data warehouse is an important entity that contributes to the decision-making process, which can be seen in the literature available over the years. Data warehouse provides the basis for quality analysis of available data by deriving accurate information from data. Like many other industries, banking sector is also facing challenges due to various reasons like large over-dues, non-performing assets, changing customer demographics, matching customer expectation levels, increased competition from financial technological companies and banking competitors, etc. Thus data warehouse system serves to be the best solution for the banks to overcome challenges as data warehouse system integrates all the data at one place and provides a consolidated view of the past transactions which can be used for report generation and performing analytical analysis in order to help the management to maximize business performance. In addition to making strategic decisions, data warehouse also assist in helping the banks to improve customer retention, optimize discounting, market segmentation, business performance, customer deposits, etc. Thus, a data warehouse system provides a solution to all data management problem and generate patterns and reports for analytical end users for enhancing decision making processes. In this research paper, we shall be representing a bank model that focuses on the loan department of a bank data warehouse and shall be explaining how business intelligence plays a role in improving the loan analysis for the banks. Loan analysis may include summarizing the classified loans, analyzing loans within and exceeding the threshold limits of Loan-To-Value (LTV) ratio, analysis of loan rejections and other analysis pertaining to loans.