Loan Amount Dashboard

?How do loan amounts vary across customers and time

In this project, I analyzed a loan dataset to explore patterns in loan amounts based on customer demographics, time periods, and financial attributes. I focused on cleaning and preparing the data, creating calculated fields, and grouping values into meaningful buckets to make the analysis more insightful.

The dashboard highlights key metrics such as total loan amount, average loan value, and distribution of loans across different customer segments. It also analyzes loan trends over time and compares loan amounts by factors such as age, gender, city, and loan duration.

An interactive dashboard was designed using Excel, featuring dynamic filters, slicers, and clear visualizations to help stakeholders quickly understand trends, identify high-value segments, and support data-driven lending decisions.