This project entails the development of a comprehensive Bank Loan Report using SQL for data analysis, and Power BI for visualization. The report provides in-depth analysis and insights into the loan portfolio, loan performance, and risk assessment. It is designed to help banking professionals make informed decisions and improve the management of loan portfolios.
-
Loan Portfolio Overview: A comprehensive view of the total number of loans, total loan amount disbursed, average loan size, and loan types.
-
Customer Demographics: Analysis of loan distribution based on customer demographics such as employment length, and geographic location.
-
Loan Performance Analysis: Metrics on interest rates, delinquencies, default rates, and overall loan performance.
-
Risk Assessment: Identification of high-risk loans and customers based on factors like debt-to-income ratio.
-
Interactive Dashboards: Dynamic visualizations in Power BI, enabling users to explore the data through filters, and interactive charts.
The Power BI component of this project includes several interactive dashboards:
-
Summary Dashboard: Provides a high-level summary of the bank’s loan portfolio, including key metrics like total loan amounts, total amount received, loan type and loan status.
-
Overview Dashboard: Visualizes loan data segmented by purpose, monthly trends, geographic trends and by term analysis.
-
Details Dashboard: Shows the complete data about all the loans in tabular format.
