Loan Analysis
This project examines trends in the loan domain to shed light on the debt challenges facing many consumers. By analyzing lending patterns across different locations and credit profiles, it aims to identify opportunities for more affordable options that can help ease financial burdens and set citizens up for long-term prosperity.
Achieved Goals :
The following goals were achieved:
- Provide an overview of residential mortgage lending in 2022 based on the data collected under the Home Mortgage Disclosure Act (HMDA). - Summarize monthly trends and activities of the mortgage market in 2022, including total applications. - Identify trends in interest rates and their impact on payment burdens.
- Build an interactive dashboard that provides an intuitive interface for monitoring business performance across different dimensions.
- Uncover insights and provide recommendations for lenders to gain insights into borrower behavior, identify risks, and improve operational efficiency.
My steps to complete this project :
The following tasks were completed:
- Download the dataset collected under the Home Mortgage Disclosure Act (HMDA) and provided by AWS. - Import the dataset to Amazon QuickSight to perform the analysis.
- Analyze data and create visuals to get more information out of the data.
- Deliver insights from the analysis and provide recommendations for lenders to make informed decisions.
Required Tools for this project :
Amazon QuickSight was used to:
- Clean the data and analyze it. - Build a dashboard to help uncover insights.
Conclusion :
This project provided a comprehensive analysis of loan trends in different states and regions. The following are the key takeaways: - By exploring patterns in total debt levels, loan purposes, and credit attributes, several opportunities could be identified to help more individuals and communities access financial tools and resources to reduce debt burdens sustainably.
- The findings from this analysis could help lenders gain insights into borrower behavior, identify risks, improve operational efficiency, reduce costs, make informed decisions, and enhance customer experience.
In case you would like to read more about this article, please do fill up the contact form available in my home page. Thanks for reading....🤗👋