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)
Link for original Power BI file:-
https://drive.google.com/file/d/1nO6ZYyitJiHwAqzaAE6LkngAQ65ijKcK/view?usp=sharing
22 Jul 2023
Keywords
