Multi-loan Calculator is a web application that provides loan amortization analysis and helps users manage multiple loans with ease. The application is built with Plotly Dash.

A complete end-to-end Bank Analytics project analyzing loan data and credit/debit transactions. Includes dashboards in Excel, Power BI, Tableau, SQL-based analysis, and a detailed presentation. Datasets are confidential and not uploaded.

贷款计算器 & 还贷模拟器。支持商贷/公积金/组合贷、等额本息/等额本金/自由还款三种方式，可多次利率变更和提前还款并按天精确计息。提供还款模拟（智能分析最优方案）、机会成本分析（提前还款 vs 投资理财）、多方案对比、数据可视化。内置 LPR 利率表，数据全部本地运算及存储，PWA 离线可用。

Financial loan portfolio analysis using Excel. This project analyzes 38,576 loan records from 2021 to evaluate funding volume, repayments, portfolio yield, loan trends and borrower risk indicators such as interest rate and DTI.

Finance Navigator Pro – Interactive Tableau dashboard analyzing 38.6K loan applications: KPIs, good/bad loan splits (86% good), trends by purpose/state/term/grade, and filtered details for lending insights.

This repository contains Power BI projects showcasing data analysis and interactive dashboards. Each project includes detailed visualizations and insights on diverse topics such as loan analysis, sales performance, and customer behavior.

Power BI dashboard analyzing home loan applications, sanctions, and recovery performance using customer, branch, product, and channel data.

This project analyzes a sample loan dataset to uncover patterns in loan approvals, assess risk levels, and suggest data-driven strategies for lending businesses.

Analyzed bank loan application and repayment data using sql and power bi to evaluate approval trends, risk factors, and loan performance.

Credit risk analysis using SQL, Python, and Power BI dashboards for loan insights.

Interactive Power BI dashboard analyzing loan amounts, year-over-year changes, and regional default trends.

Data Analysis project analyzing the characteristics of credit card borrowers. After the analysis, a classification model is built.

Power BI dashboard for evaluating home loan processes, including applications, approvals, and recovery performance, with insights drawn from customer profiles, branch operations, product categories, and distribution channels.

Analysis of the effect of rising interest rates on the probability of default on consumer loans

Privacy-safe Streamlit mortgage planning app for payoff analysis, overpayment scenarios, and personal finance decisions.

Credit risk assessment using FICO score segmentation, loan default modeling, discretization techniques, and log-likelihood evaluation for predictive analytics in financial services.

End-to-end SQL project analyzing bank loan risk, customer credit profiles and default patterns using joins, window functions and business KPIs.

Interactive Tableau dashboard and SQL-powered analysis for bank loan approvals, rejections, and key financial KPIs.

Loan Approval Dashboard using SQL, Python, and Power BI

Power BI dashboard analyzing loan repayment risk using FICO score, DTI, interest rate, loan purpose, and credit policy.