This repository showcases my capstone projects, featuring four distinct initiatives that demonstrate my analytical and problem-solving skills. Each project reflects a comprehensive approach to research and execution, addressing unique challenges across various domains. I plan to expand this collection with additional projects in the coming days.

Predicts bank customer loan acceptance using Python to optimize marketing campaigns.

This is about the Financial Loan Statement of a Bank of United Sates. In this I have analyzed total loan application with various types of borrowers on the basis of month, state, term, employment length, purpose, home ownership, good loan and bad loan. This will help us to get more meaningful information from this report and available insights.

📊 End-to-end data analytics project analyzing a bank’s loan portfolio to identify profitable segments, high-risk borrowers, and strategic insights using Python, Jupyter Notebook, and data visualization.

Finance Domain | Bank Loan Analysis. This repository contains a comprehensive bank loan report tailored for tracking lending activities, assessing loan performance, and making data-driven decisions. It includes detailed domain knowledge, key performance indicators (KPIs), dashboard summaries, and insights into loan application processes.

🏦 Analyze bank loan data to uncover profitable segments and high-risk borrowers, guiding data-driven lending decisions and reducing portfolio losses.

A SQL project visualized using Power BI dashboard that analyzes loan applications, funded amounts, payments, interest rates, and Debt-to-Income (DTI) ratios to optimize loan portfolio performance and decision-making.

Exploratory data analysis on bank loan data from 90,000 customers using Python code, SQL queries, and Tableau visualizations.

Used Exploratory Data Analysis (EDA) to analyse patterns in the bank dataset. The main was to analyse the potential defaulters list and identify the cause for payment default. Tried to understand one of the risk assessment used by the banks and have duplicated the same for this project.

Finance Domain | Bank Loan Analysis. This repository contains a comprehensive bank loan report tailored for tracking lending activities, assessing loan performance, and making data-driven decisions. It includes detailed domain knowledge, key performance indicators (KPIs), dashboard summaries, and insights into loan application processes.

Designed a Dashboard using Microsoft-Excel

Excel-based Bank Loan Analysis Dashboard providing insights into loan performance, customer behavior, risk metrics, and key lending KPIs through interactive dashboards.

Bank Loan Analysis Project using POWER BI and SQL I am thrilled to share the results of a recent project leveraging the power of data visualization with POWER BI and SQL to analyze bank loan data. Our goal was to derive insights into loan applications, funding outcomes, and key performance indicators (KPIs) for effective decision-making.