Welcome to the Bank Loan Analysis Power BI project repository! This project aims to provide insightful analysis and visualization of bank loan data using Power BI.
This Power BI project analyzes various aspects of bank loans to provide valuable insights for decision-making. It comprises three main dashboards: Summary, Overview, and Details.
- Total Loan Applications: Calculate the total number of loan applications received during a specified period, including Month-to-Date (MTD) and Month-over-Month (MoM) changes.
- Total Funded Amount: Understand the total amount of funds disbursed as loans, monitor MTD Total Funded Amount, and analyze MoM changes.
- Total Amount Received: Track the total amount received from borrowers to assess cash flow and loan repayment, including MTD Total Amount Received and MoM changes.
- Average Interest Rate: Calculate the average interest rate across all loans, MTD, and monitor MoM variations.
- Average Debt-to-Income Ratio (DTI): Evaluate the average DTI for borrowers, compute the average DTI for all loans, MTD, and track MoM fluctuations.
Loan Status Grid View: Gain a comprehensive overview of lending operations and monitor loan performance categorized by 'Loan Status'. This grid view provides insights into metrics such as Total Loan Applications, Total Funded Amount, Total Amount Received, MTD Funded Amount, MTD Amount Received, Average Interest Rate, and Average DTI.
- Monthly Trends by Issue Date (Line Chart): Identify seasonality and long-term trends in lending activities.
- Regional Analysis by State (Filled Map): Identify regions with significant lending activity and assess regional disparities.
- Loan Term Analysis (Donut Chart): Understand the distribution of loans across various term lengths.
- Employee Length Analysis (Bar Chart): Assess how lending metrics are distributed among borrowers with different employment lengths.
- Loan Purpose Breakdown (Bar Chart): Provide a visual breakdown of loan metrics based on stated purposes of loans.
- Home Ownership Analysis (Tree Map): View how home ownership impacts loan applications and disbursements hierarchically.
The Details Dashboard provides a comprehensive view of key loan-related metrics and data points, facilitating efficient access to critical information about loan portfolios, borrower profiles, and loan performance.
The bank loan analysis dataset comprises essential fields such as Loan ID, Address State, Purpose, Grade, Sub Grade, Annual Income, Loan Status, Last Payment Date, Verification Status, Debt-to-Income Ratio, and Interest Rates. These fields provide insights into borrower demographics, employment stability, loan characteristics, risk assessment, and payment behavior.
The Details Dashboard streamlines access to critical loan data, facilitating informed decision-making, enhancing operational efficiency, optimizing lending strategies, mitigating risks, and maximizing overall performance.
- Clone the Repository: Clone this repository to your local machine using
git clone https://github.com/vinayak200227/Bank-Loan-Analysis-using-PowerBI.git
. - Open the Power BI Project: Open the
.pbix
file using Power BI Desktop. - Interact with Dashboards: Explore the interactive dashboards and visualizations to gain insights into bank loan data.
You can find images of the dashboards in the Output
directory of this repository.
Contributions to enhance the analysis or add new features are welcome! If you have any suggestions, ideas, or bug fixes, feel free to open an issue or submit a pull request.