Bank analytics Project Excel dashboard
As part of an Excel R project, a real-life sample was showcased on the dashboard. The project involved analysing loans provided by a financial institution to customers of diverse grades and sub-grade levels. The analysis encompassed factors such as loan disbursement reasons, funded amounts, revolving balance values, customer locations in various states and geographic locations, as well as customer payment modes, and the latest payment values.
Tools used:-
Microsoft Excel
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)
24 Sep 2023
Keywords
Data manipulation
Statistical analysis
Data visualization
Dashboard Report
Problem-solving
Advanced Excel
Bank data analysis
