1 of 26

HOME CREDIT DEFAULT RISK

GROUP NAME: DOM DOM

INSTRUCTOR: Ph.D DINH THUY TIEN

2 of 26

DO HOANG ANH

VUONG HOANG GIANG

A44498

A44526

CORE TEAM MEMBER

3 of 26

OVERVIEW

4 of 26

TARGET

3

2

1

MISSION

  • Identify key features
  • Build predictive models

STAKEHOLDERS

  • Executive Team
  • Relevant departments

GOALS

  • AUC > 0.7
  • Precision > 0.7

5 of 26

Focus on customers aged 28 - 65, as this is the most common age range for loan borrowers.

AGE

CASH LOANS

Select only customers using cash loans, as this is the most common loan type.

EXISTING CUSTOMERS

Select only customers who have had a previous loan with Home Credit.

SCOPE

6 of 26

1, EXPLANATION

  • What is Home Credit ?
  • What is the main product ?
  • How does Home Credit work?
  • What is the mission?
  • Business problem

2, DATA PREPARATION

  • Overview Dataset
  • Pre-processing data
  • Create new features
  • Feature selection

3, SOLUTION

  • Model selection
  • Prediction variables
  • Choose the best cut-off threshold
  • Result & Evaluation
  • Advantages for business

​

​

​

4, APPLICATION

  • Criteria
  • Mini – App
  • Review
  • Expansion

AGENDA

7 of 26

EXPLANATION

8 of 26

WHAT IS HOME CREDIT ?

Home Credit is a financial institution specializing in offering loans to individuals with limited or restricted access to traditional banking services.

WHAT IS THE MAIN PRODUCT ?

​

POS CASH

INSTALLMENT

CREDIT CARD

9 of 26

HOW DOES HOME CREDIT WORK?

WHAT IS THE MISSION ?

Receive application

Review

&

Evaluation

Disburse

➤

➤

➤

Mitigating risk while maintaining business growth

Monitors

Reduce the rate of financial loss from customers who are facing difficulties

Build a model to predict if customers will struggle with loan repayment

10 of 26

Insufficient credit history for many customers makes accurate risk assessment challenging.

HIGH RISK

INCONSISTENT DATA

Information scattered across multiple platforms leads to difficulties in ensuring data uniformity and reliability.

TIME-CONSUMING

Fragmented and disorganized customer records across different sources slow down processes.

BUSINESS PROBLEM

11 of 26

DATA PREPARATION

12 of 26

OVERVIEW DATASET

MERGE DATA

​

APPLICATION_TRAIN

PREVIOUS_APPLICATION

  • Rows: 38
  • Columns: 264668
  • Customer loans history at Home Credit
  • Rows: 37
  • Columns: 1670214
  • Customer demographic and loan application data
  • Rows: 122
  • Columns: 307221

13 of 26

-

DATA TYPE

DUPLICATES

Removing duplicates improves dataset quality and model reliability.

MISSING VALUES

Imputation handles gaps in data to maintain accuracy and integrity.

PRE-PROCESSING

Ensuring correct data types (numerical/categorical) avoids errors in model training.

14 of 26

CREATE NEW FEARTURES

DAYS_BIRTH

PREVIOUS_APPLICATION

  • Negative value ( - )
  • Calculated by days

AGE

  • Positive value ( + )
  • Calculated by years

SUM

MEAN

  • AMT_ANNUITY
  • AMT_APPLICATION
  • AMT_DOWN_PAYMENT
  • AMT_GOODS_PRICE
  • CNT_PAYMENT
  • RATE_DOWN_PAYMENT

15 of 26

SOLUTION

16 of 26

MODEL SELECTION

High

Interpretability

Random Forest

K-Neareast Neighbors

(KNN)

Decision Tree

High

Poor

Poor

Logistic Regression

Implementability

17 of 26

PREDICTION MODEL

YES

NO

SELECTED FEARTURES

INPUT VARIABLES

LOGISTIC MODEL

OUTPUT

Having trouble paying debt?

18 of 26

MOST IMPORTANT FEATURES

SELECTED FEARTURES

19 of 26

Age of the customers

AGE

Customer's previous loan applications were rejected

PREV_STATUS_

REFUSED

Customer gender as a vector

CODE_GENDER_VEC

Evaluate the area where customers live

REGION_RATING_

CLIENT

Previous loans had revolving contracts

PREV_TYPE_

REVOLVING

New customer in previous loan application

PREV_CLIENT_TYPE_NEW

Price of product customer want to buy

AMT_GOODS_PRICE

Total days of customer experience

DAYS_EMPLOYED

Total customer prepayment ratio on previous loans

PREV_RATE_DOWN_

PAYMENT_SUM

Average customer prepayment ratio on previous loans

PREV_RATE_DOWN_

PAYMENT_MEAN

FEATURES SELECTION

Credit score from others

EXT_SOURCE_2

Total number of customer prepayments on previous loans

PREV_PAYMENT_

COUNT_SUM

Average number of customer prepayments on previous loans

PREV_PAYMENT_

COUNT_MEAN

Average customer installment amount on previous loans

PREV_ANNUITY_

MEAN

Customer work group as a vector

job_group_vec

Cash loans type in previous loans

PREV_TYPE_CASH

Previous loans with approved status

PREV_STATUS_

APPROVED

Total prepayments on previous loans

PREV_DOWN_

PAYMENT_SUM

Average prepayments on previous loans

PREV_DOWN_

PAYMENT_MEAN

Type of customer in previous loan

PREV_TYPE_

CONSUMER

20 of 26

CHOOSE THE BEST THRESHOLD

Threshold: 0.162

Precision: 0.88

AUC: 0.703

21 of 26

BUSINESS VALUE

4776

62748

2310

864

=> Increase the ability to predict customers who are facing difficulty by 33%

ADVANTAGE

DISADVANTAGE

High Precision:The model is accurate when predicting difficulties

Low Recall: Indicating the model misses many actual cases of customers in difficulty

22 of 26

APPLICATION

23 of 26

EASY TO UNDERSTAND

HIGH APPLICABILITY

HIGH

PRECISION

EASY TO UPDATE

MINI APP

CRITERIA

24 of 26

Implement functionality to convert relevant model outputs or inputs into string format for enhanced compatibility and data handling

CONVERT TO STRING

COMPLETE APP

Including all variables allows the model and using additional models to improving its accuracy and predictive power

BETTER INTERRFACE

Develop a more user-friendly interface to streamline interactions with the model, improving usability and accessibility

EXPANSION

25 of 26

REFERENCE SOURCE

26 of 26

THANK YOU