$6\mathrm{.}8$ Tableau: Clustering $($loans$)$

Background

As a data scientist working for Lending Club, you have been tasked with identifying and describing the types, or clusters, of customers you have.

Tasks

Complete each step as outlined in the questions below.

Data Source

Use the lc$\_$large.csv file available to download below.

Drag the table: lc$\_$Loans into the entity view in Tableau. Select the "Extract" option for the connection in Tableau.

Data Dictionary:

Features about the loan

loan$\_$status: current status of the loan

loan$\_$status$\_$numeric: a rank$-$ordered numeric version of loan$\_$status

loan$\_$amount: the listed amount of the loan applied for by the borrower

issue$\_$d: the date the loan was funded$/$issued

term: the number of payments on the loan

int$\_$rate: the interest rate on the loan

installment: the monthly payment owed by the borrower

total$\_$pymnt: payments received to date for total amount funded

total$\_$rec$\_$prncp: payments received to date for total amount funded

total$\_$rec$\_$int: interest received to date

total$\_$rec$\_$late$\_$fee: late fees received to date

recoveries: post charge off gross recovery $($i$.$e$.,$ if the loan was charged off, how much money was recovered afterward, if any$)$

title: the loan title provided by the borrower

purpose: a category provided by the borrower for the loan request

Features obtained from the borrower before the loan was issued

emp$\_$title: the job title supplied by the borrower

emp$\_$length: employment length in years

home$\_$ownership: the homeownership status provided by the borrower

annual$\_$income: the self$-$reported annual income provided by the borrower

verification$\_$status: was income verified by LC$,$ the source, or not verified

Features obtained from the credit bureau about the borrower before issued

acc$\_$now$\_$delinq: the number of accounts on which the borrower is now delinquent

delinq$\_2$yrs: the number of $30+$ days past$-$due incidences of delinquency in the borrower's credit file for the past $2$ years

earliest$\_$cr$\_$line: the month the borrower's earliest reported credit line was opened

inq$\_$last$\_6$mths: the number of unsecured inquiries in the past $6$ months

mths$\_$since$\_$last$\_$delinq: the number of months since the borrower's last delinquency

mths$\_$since$\_$last$\_$record: the number of months since the last public record

open$\_$acc: the number of open credit lines in the borrower's credit file

pub$\_$rec: number of derogatory public records

revol$\_$bal: total credit revolving balance

revol$\_$util: the amount of credit the borrower is using relative to all available revolving credit

tot$\_$coll$\_$amt: total collection amounts ever owed

tot$\_$cur$\_$bal: total current balance of all accounts

total$\_$acc: the total number of credit lines currently in the borrower's credit file

total$\_$rev$\_$hi$\_$lim: total credit limit on revolving accounts

Features engineered by LC based on the credit bureau data

dti: a ratio calculated using the borrower's total monthly payments on the total debt obligations, excluding mortgages and the requested LC loan, divided by the borrower's combined self$-$reported monthly income

grade: the likelihood that the loan will be paid back

sub$\_$grade: a more granular version of grade

Deliverables

In addition to answering the questions below, you will upload a $.$twbx file from Tableau that includes all of the work you did to complete this assessment.