Loan Data Analysis Using Data Warehouse Techniques

Abstract

Most of the financial institutions are running their operations smoothly and profitable way without any interruptions with the help of data analytical techniques. This study will be able to enhance the business's ability to expand its market by providing meaningful and key analysis of consumer behavior. Financial institutions should have proper parameters to identify the right customer base with the capacity of their repayments. To identify those parameters, BI technologies and the data warehouse techniques such as inspecting, cleansing, transforming, and modeling were used to convert data to meaningful information. The star schema is used for this data warehouse design which includes one fact table surrounded by several dimensions. This study was mainly focused to identify the borrower’s response to the calls taken by call center agents on a time basis per day. As a result, identified that several parameters such as age groups and gender-wise response times are different. Those factors will be evaluated by using a decision tree in future works. This will increase the loan collection efficiency.