Skip to content

An interactive Power BI dashboard that analyzes bank loan data to provide insights into approval trends, default risks, and customer profiles. Designed to assist financial institutions in making data-driven lending decisions.

Notifications You must be signed in to change notification settings

AllanOtieno254/bank-loan-analysis-dashboard-power-bi

Repository files navigation

Bank Loan Analysis Dashboard

This repository contains a Power BI project designed to analyze bank loan data. The dashboard provides key insights into loan approval rates, default risks, customer demographics, and lending patterns. It serves as a valuable tool for banks and financial institutions aiming to make informed lending decisions based on data-driven insights.

summary

Features

  • Loan Approval Analysis: Breakdown of approved vs. rejected loans with trends over time.
  • Default Risk Insights: Identification of factors contributing to loan defaults.
  • Customer Segmentation: Analysis of customer demographics, including age, income, and credit score distributions.
  • Interactive Visualizations: User-friendly and customizable visualizations for deeper analysis.

Objectives

  1. Enhance decision-making by visualizing key loan metrics.
  2. Identify risk factors to improve loan approval processes.
  3. Provide insights into customer profiles to tailor financial products.

Dashboard Overview

overview

details

The dashboard consists of the following sections:

  • Overview: Summary metrics, including total loans, approval rates, and default rates.
  • Demographics: Customer distribution by age, gender, income, and geography.
  • Loan Analysis: Insights into loan amounts, interest rates, and repayment trends.
  • Risk Assessment: Identification of high-risk customers and default trends.

File Structure

bank-loan-analysis-dashboard/
├── README.md               # Project documentation
├── LICENSE                 # Licensing information
├── /data/                  # Sample data used for the dashboard
│   └── bank_loan_data.csv  # Placeholder for the dataset
├── /images/                # Dashboard screenshots and visualizations
│   └── dashboard.png
└── /dashboard/             # Power BI file and related exports
    └── Bank Loan Analysis Dashboard.pbix

About

An interactive Power BI dashboard that analyzes bank loan data to provide insights into approval trends, default risks, and customer profiles. Designed to assist financial institutions in making data-driven lending decisions.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published