Interactive Excel dashboard for analyzing financial risk, delinquency rates, and regional exposure.
This project features a comprehensive Financial Risk Dashboard created in Microsoft Excel. It provides a real-time overview of portfolio health, delinquency rates, and risk segmentation across different demographics and regions.
- [Live Dashboard Preview](<iframe width="402" height="346" frameborder="0" scrolling="no" src="https://1drv.ms/x/c/fc8a9e63e3c2ea9d/IQRbVp_4RPuqR4ZihMVwpDu-AeuZNlYHQPSyzMtmyQ4OfK0?wdAllowInteractivity=False&ActiveCell='Dashboard'!AV43&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True&wdInConfigurator=True&edaebf=rslc0"></iframe>)
- (www.linkedin.com/in/vivek-singh-044b5527b) Linkdln Profile
Answer these using the provided CSV and Dashboard to test your understanding of the data.
- Portfolio Distribution: Which region accounts for the highest total portfolio value?
- Risk Assessment: What is the correlation between 'Income Level' and 'Delinquency Status'?
- Credit Health: What percentage of customers fall under the 'Very Poor' credit rating?
- Employment Impact: Are 'Unemployed' individuals more likely to be in the 'High Risk Segment' compared to 'Salaried' individuals?
- Gender Analysis: Is there a significant difference in the 'Total Amount of Risk' between Male and Female customers?
- Delinquency Deep-Dive: What is the average credit score of customers marked as 'Delinquent'?
- Segmentation: Which combination of 'Employment Type' and 'Income Level' represents the safest customer profile?
- Geographic Risk: Does the 'South' region's high exposure stem from a large number of customers or a few high-value high-risk accounts?
- Score Thresholds: If the minimum credit score for 'Good' was raised to 750, how many customers would be downgraded?
- Business Strategy: Based on the 58% Delinquency Rate, what specific policy change would you recommend for the 'High Risk Segment'?
- Data Cleaning: Handled via Power Query (removing nulls, formatting currency).
- Advanced Excel: Pivot Tables, Slicers, and Conditional Formatting.
- Data Modeling: Created relationships between customer demographics and financial performance.
- UI/UX Design: Implemented a dark-themed professional layout with intuitive navigation.
Data Analyst I specialize in turning complex datasets into visual stories that drive business decisions. With a background in technical data tasks and professional branding, I focus on delivering high-impact analytical solutions.
- Tools: Excel (Power Query, DAX), SQL, Python, Tableau.
- Focus: Financial Analysis, Risk Mitigation, and Business Intelligence.