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
Data Manipulation
Statistical analysis
Data visualization
Presentation
Dashboard Report
Problem solving
Critical thinking
Domain knowledge
Power BI

Creating portfolio made simple for

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

Start making more money