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.

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

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.

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 Loan Default Risk Analysis Dashboard built using Power BI, DAX, Power Query and Python.

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.

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

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

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.

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.

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