Loan company data analysis Excel dashboard
As part of an Excel R project, a real-life sample was showcased on the dashboard. The project involved analyzing 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 geolocations, 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)
13 Jul 2023
Keywords
Data manipulation
Statistical analysis
Data visualization
Presentation
Dashboard Report
Problem-solving
Critical thinking
Domain knowledge
