📊 Bank Loan Analysis Project

Tools

• 🔧 Power BI: For interactive dashboards and visualizations.
• 🗃️ SQL: For data extraction and manipulation.

---

Project Objective

The goal of this project is to analyze bank loan data to gain valuable insights into lending activities, identify key performance indicators (KPIs), and track loan performance. This analysis aids in making data-driven decisions and understanding the financial health of the bank's lending portfolio. 📈💡

---

Inspiration

This project draws inspiration from the YouTube channel Data Tutorials, which provided a comprehensive guide on creating effective data dashboards. Leveraging their techniques, this project delivers a robust analysis solution. 🎓📹

---

Project Description

This project involves the following steps:

1. Data Import and Preparation

• Import Data: Load loan data into SQL. 📥
• Data Cleaning: Write SQL queries to clean and manipulate the data. 🧹
• Connect to Power BI: Integrate Power BI with the SQL database and import the cleaned data. 🔗
• Further Refinement: Transform and refine the data in Power BI. 🔄

2. Dashboard 1: Summary

• Key Metrics:
  • Total Loan Applications: Number of applications with Month-to-Date (MTD) and Month-over-Month (MoM) changes. 📅
  • Total Funded Amount: Total funds disbursed with MTD and MoM analysis. 💵
  • Total Amount Received: Total repayments with MTD and MoM analysis. 💰
  • Average Interest Rate: Average interest rate with MTD and MoM changes. 📉
  • Average Debt-to-Income Ratio (DTI): Measures borrowers' financial health with MTD and MoM tracking. 🏦
  • Good Loan vs. Bad Loan KPIs:
    • Good Loan: Percentage and number of 'Good Loans,' including funded amount and total received amount. ✅
    • Bad Loan: Percentage and number of 'Bad Loans,' including funded amount and total received amount. ❌
  • Loan Status Grid View: Overview by loan status showing key metrics. 🗂️

3. Dashboard 2: Overview

• Key Metrics:
  • Monthly Trends by Issue Date: Analyze loan issuance trends over time. 📅
  • Regional Analysis by State: Assess lending activity and performance across states. 🗺️
  • Loan Term Analysis: Breakdown of loan terms (short-term, medium-term, long-term). 📊
  • Employee Length Analysis: Examine the effect of borrower employment length on loan metrics. 👔
  • Loan Purpose Breakdown: Metrics based on loan purposes (education, home improvement). 🎯
  • Home Ownership Analysis: Impact of home ownership status on loans. 🏠

4. Dashboard 3: Details

• Objective: Provides a detailed view of key loan metrics and borrower profiles. 📋

Tools and Technologies

• Power BI: For creating interactive dashboards and visualizations. 📊
• SQL: For data import, cleaning, extraction, and manipulation. 🧹
• PowerPoint: For summarizing and presenting the project. 🎤

Repository Includes

• Power BI Project File: Interactive dashboards and visualizations. 📈
• SQL PDF Documents: SQL queries used in the project. 📄
• PowerPoint Presentation: Project summary and findings. 🗒️

---

Check Out the More Project on GitHub

Repository 🌟

Dataset

Download the dataset used in this project here. 📥

Query Document

Find the SQL queries used in this project here. 📄

📄 Report PDF Here

Find the detailed project report PDF here.

📊 Power BI Report Sample

Explore a sample of the Power BI report created for this project:

• Dashboard 1: Summary
• Dashboard 2: Overview
• Dashboard 3: Details

---

“Every data point is a stepping stone to a brighter insight. Keep analyzing, keep discovering!” 🌟🔍

---

Project Developed by:
Bhushan Gawali 👋