Bank analytics Power BI Dashboard

The project involves analyzing loan data provided by a financial institution for diverse customers with varied grades and sub-grade levels, considering loan disbursement reasons, funded amount, revolving balance values, payment modes, and last payment values across different states and geolocations.

Data Points Analyzed:

1. Year-wise loan amount Stats

2.Grade and sub-grade-wise revol_bal

3.Total Payment for Verified Status Vs Total Payment for Non-Verified Status

4. State-wise and month-wise loan status

5.Homeownership Vs last payment date stats

Tools used:-
Power BI Desktop
Dataset Details:- 
• Domain: Finance
• Datasets: Finance_1.xlsx & Finance_2.xlsx
• Dataset Type: Excel Data
• Dataset Size: Each Excel file has 39k+ records (Total 80k+ records)
 

28 Sep 2023

Keywords
Data visualization
PowerBI
Data Cleaning
Dashboard Report
Problem solving
Data Manipulation

Creating portfolio made simple for

Trusted by 48600+ Generalists. Try it now, free to use

Start making more money