loan-analysis

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

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.

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.

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 for analyzing loan portfolio performance, delinquency, charge-offs, and credit risk.

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.

Interactive Power BI dashboard analyzing loan default risk using DAX, Power Query, KPI tracking, and financial behavior insights.

Interactive Loan Default Risk Analysis Dashboard built using Power BI, DAX, Power Query and Python.

End-to-end Loan Default Risk Analysis dashboard built with Power BI, DAX, and Power Query using 255K+ loan records to analyze borrower behavior, financial risk, and default trends.

Interactive Power BI dashboard for bank loan portfolio analysis featuring KPI reporting, DAX measures, Power Query transformations, and business intelligence insights.

Interactive Power BI solution for executive reporting, loan portfolio analysis, credit risk assessment, and customer insights using DAX, Power Query, and business-focused analytics.

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

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

Bank Loan Analysis using SQL to analyze loan applications, approval rates, customer income, credit score, loan purpose, and high-risk applicants.

An end-to-end data analytics project using Excel, PostgreSQL, SQL, and Looker Studio to analyze credit risk and loan approval patterns.

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

Loan application analysis and approval dashboard built with Python and Power BI, covering application trends, customer risk, approval performance, and loan processing operations.

A machine learning framework for credit risk modeling, comparing traditional models with Explainable AI (XAI) approaches to satisfy regulatory compliance.

End-to-end bank loan performance analysis using SQL, Power BI, Tableau, and Excel — tracking loan volume, repayment behavior, and risk across 38.6K applications.