1 of 22

Loan Lending for Economic Development

Presented By :

Divya Jadhav, Arunima Bafna, Fascel Fernandes, Ninad Jagdale

2 of 22

Agenda

PROBLEM STATEMENT

2

3 of 22

PROBLEM STATEMENT

  • Online Loan lending platform

​

  • Based on the idea of crowdfunding

​

  • Motto of the organisation

​

  • Objective: Impact of the organisation, support business decisions, help borrowers understand the certainty of his/her application

​

​

4 of 22

Agenda

ROAD MAP

5 of 22

Visualize

Solution

Insights

Exploratory Data Analysis

Architecture blueprint and Techstack

Defining valuable insights

Set up and ETL

Data

Cloud

6 of 22

Agenda

GLOSSARY

7 of 22

GLOSSARY

Borrower

Lender

Field Partner

Crowd-funding

Multidimensional Poverty Index (MPI)

Posted Time

Funded Time

Disbursed Time

8 of 22

Agenda

BUSINESS FLOW

9 of 22

BUSINESS FLOW

10 of 22

Agenda

EXPLORATORY DATA ANALYSIS

11 of 22

Loan ID

​

Loan Theme Code

Loan Theme Type

Partner ID

  • Unique Identification of loan Information
  • No duplicate rows found in source data

ROW BASED DATA ANALYSIS

12 of 22

COLUMN BASED DATA ANALYSIS

  • Analysis on the Types of Loans , Quick Funds and Fully funded loans based on the fields

Posted Time

​

Funded Time

​

Disbursed Time

​

  • Borrowers Gender Category Analysis

Only Females

​

Only Males

​

Groups

​

  • Hashtags Fields indicating Online Presence of Borrowers for Loan Approval
  • Analysis on Repayment Modes

Bullet

​

Irregular

​

Monthly

​

13 of 22

Agenda

TECHNOLOGY STACK

14 of 22

TECHNOLOGY STACK

15 of 22

Agenda

SCHEMA

16 of 22

SCHEMA

17 of 22

Agenda

CLOUD IMPLEMENTATION

18 of 22

Cloud Implementation

19 of 22

Agenda

TABLEAU DEMONSTRATION

https://public.tableau.com/profile/arunima.bafna#!/

20 of 22

21 of 22

ANY QUESTIONS ?

22 of 22

THANK YOU