This dataset comprises detailed records of bank loans, including nearly 40,000 rows and 24 columns, representing various attributes related to loan applications and client information. The data, which was loaded into Power BI using SQL Server Management Studio (SSMS), offers a comprehensive overview of key metrics that influence loan performance and decision-making processes. Below is a breakdown of the types of data captured in the dataset:

• Client Information:

  • ID: Unique identifier for each loan applicant.

  • Address: Geographic location or address details of the clients. This may help in region-based analysis or assessing the impact of location on loan repayment patterns.

• Loan Application Attributes:

  • Application Type: Indicates whether the loan is individual or joint. This column helps differentiate between single applicants and co-borrowers.

  • Employment Duration: Captures how long the client has been employed, which can indicate financial stability.

  • Employment Title: Job designation or title of the applicant, which might correlate with income level and loan approval rates.

  • Grade of Loan Applied: Represents the loan’s risk grade, based on the applicant’s creditworthiness. Grades typically range from A to E or beyond, where A is the most secure.

• Client’s Financial Position:

  • Home Ownership: This column indicates whether the client owns a home, rents, or has a mortgage. Homeownership is a key factor that may influence loan approvals or rates.

  • Annual Income: Captures the client’s yearly income, which is an essential factor for assessing loan eligibility and repayment capacity.

  • DTI (Debt-to-Income Ratio): This ratio measures the applicant’s total monthly debt payments in relation to their gross monthly income. Higher DTI ratios often signify a higher level of risk.

• Loan Details:

  • Loan Issue Date: The date when the loan was officially issued or funded.

  • Loan Status: This column categorizes the loan into various statuses, such as “Fully Paid,” “Current,” or “Charged Off.” It provides insight into whether the loan is active, has been repaid, or defaulted.

  • Loan Purpose: Describes the reason for the loan, such as debt consolidation, home improvement, education, or medical expenses.

  • Loan Term: Refers to the length of the loan, typically represented as 36 months or 60 months, showing the time horizon over which the loan is to be repaid.

  • Loan Amount: This captures the total loan amount requested or disbursed. It can range from small personal loans to larger amounts for business or significant personal expenses.

• Loan Repayment Information:

  • Installment: The regular monthly payment amount the client is expected to pay towards the loan.

  • Interest Rate: The rate of interest charged on the loan, expressed as a percentage. Higher interest rates are often linked to riskier clients or longer-term loans.

  • Total Payment: The cumulative amount paid by the borrower throughout the loan’s lifespan, including principal and interest. This field gives insights into the loan’s overall cost to the borrower.

• Credit History:

  • Last Credit Pull Date: Refers to the last time the borrower’s credit report was checked, typically by the lender. This helps in evaluating the client’s financial condition at various stages of the loan.

  • Last Payment Date: Captures the most recent payment date, offering insights into whether payments are up-to-date or late.