Data Warehouse Testing: A Step Towards using Business Intelligence in Banking
Sonali Mathur1, S.L. Gupta2, Payal Pahwa3
1Sonali Mathur, Research Scholar, BIT (Mesra, Ranchi), India.
2Prof. (Dr.) S. L Gupta, Dean, Waljat College of Applied Sciences, Sultanate of Oman.
3Prof. (Dr.) Payal Pahwa, Principal, BPIT, Rohini, Delhi.

Manuscript received on November 17., 2019. | Revised Manuscript received on November 24 2019. | Manuscript published on 30 November, 2019. | PP: 12365-12372 | Volume-8 Issue-4, November 2019. | Retrieval Number: D9891118419/2019©BEIESP | DOI: 10.35940/ijrte.D9891.118419

Open Access | Ethics and Policies | Cite  | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (

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.
Keywords: Data Warehouse, Data Warehouse Testing, Banking Industry, Business Intelligence.
Scope of the Article: Big Data Analytics and Business Intelligence.