Built with datascienceportfol.io

AQUALINE CREDIT GROUP LOAN APPROVAL REPORT

Project photo

Skills

About this project

Introduction: I analyzed loan approval datato gain insight into the lending pattern and preferences of our customers. This analysis aims to optimize loan approval process and inform strategic decisions.

Data Source: The data was obtained from kaggle and was cleaned and formatted in order to remove blanks, duplicated and ensure correct days types. This was done In order to ensure data completeness, accuracy and integrity.

Key insights:

Count of Loan Approval by Family Member Size: This was represented by a clustered column chart that loan approval by the family size. Family size was categorized into 4 which is 1, 2, 3, and 4. The chart shows that althought the most occuring answer is No, the family size of 4 had the higher loan approval rating.

Rate of Personal Loan Approval: The overall approval rating is low as shown by the pie chart that depicted the yes and no responses.The overall approval rate for personal loans is loan, indicating a stringent approval process.

Count of Personal Loan Approval by Credit Card Ownership: This is visualized by a clustered bar chart and shows if the probability of a customer getting a loan is higher is they have a credit card or not. It shows that Applicants with credit cards are more likely to be approved for personal loans.

Loans Approval by income: This was represented using a matrix card and it works to show if higher incomes correspond to higher loan approval rates or vice versa.

Count of Personal Loan Approved by Education:

Insight: Applicants with higher education levels are more likely to be approved for personal loans.

Count of Personal Loan Approval by Experience: This was represented by a clustered column chart, the experience years were group into 0-10, 11-20, 21-30 and other. And it shows that the experience range with a higher loan approval rating is 0-10.

This analysis provides insights into loan approval patterns, highlighting key factors influencing approval rates.

Recommendations:

- Offer targeted loan products for families with 3-4 members

- Require credit card ownership for personal loan approval

- Offer higher loan amounts for applicants with higher incomes and education levels

- Streamline the approval process for more experienced applicants.