Bank Loan Analytics Dataset preview Free

Bank Loan Analytics Dataset

Finance Advanced CSVXLSXSQL
CategoryFinance
DifficultyAdvanced
Rows38K (38,480)
Columns9
File Size5.2 MB
FormatsCSV, XLSX, SQL
LicenseFree for commercial & personal use
Downloads12,060+
Last Updated5 Jul 2026
CreatorDataVix

About this dataset

The Bank Loan Analytics Dataset contains loan applications with applicant income, loan amount, term, interest rate, credit history, approval decision and repayment/default status. It’s ideal for financial analytics and risk practice: measure approval rates, analyse default drivers, build a lending KPI dashboard and practise credit-risk modelling in Python.

#bank#loans#finance#credit-risk#default

Dataset Contents

The tables included in this dataset and what each one holds.

TableDescriptionRows
Loans One row per loan with amount, term, rate and status. 38K
Applicants Applicant income, employment and credit history. 38K
Repayments Scheduled and actual repayments per loan. 155K

Columns Included

Key columns with their datatypes and meaning.

ColumnDatatypeDescription
loan_id VARCHAR Unique loan identifier.
applicant_income DECIMAL Applicant monthly income.
loan_amount DECIMAL Approved / requested loan amount.
term_months INT Loan term in months.
interest_rate DECIMAL Annual interest rate (%).
credit_history INT Meets credit-history guidelines (1/0).
purpose VARCHAR Loan purpose category.
approved VARCHAR Approval decision (Y/N).
status VARCHAR Current, Fully Paid or Defaulted.

Skills You Can Practice

Power BI Dashboard
SQL Queries
Excel Analysis
Python Pandas
Data Cleaning
KPIs
Risk Analysis
Default Prediction
Financial Modelling
Classification

Recommended Projects

01 Lending KPI Dashboard
02 Default Risk Analysis
03 Approval Rate Report
04 Interest Rate Analysis
05 Credit-Risk Model
06 Portfolio Health Report

Preview

Click any image to enlarge.

Related Datasets

Stock Market Prices Dataset
IntermediateFinance

Stock Market Prices Dataset

Daily OHLCV prices for major tickers over 5 years — time-series and financial analysis ready.

 Superstore Retail Dataset
BeginnerRetail

Superstore Retail Dataset

The iconic Superstore orders with region, segment, category, sales and profit — perfect for a first dashboard.

 Coffee Shop Sales Dataset
BeginnerSales

Coffee Shop Sales Dataset

Transaction-level cafe sales by product, store, hour and day — great for a first Excel/Power BI project.

Frequently Asked Questions

Is this dataset free to download?
Yes. Every dataset on DataVix is 100% free to download — no signup, no paywall, no hidden cost. Just click “Download Dataset”.
How do I download the files?
Click the green “Download Dataset” button. Your download starts instantly as a single package containing all included file formats (CSV, XLSX, SQL).
Can I use this dataset for commercial projects?
Free for commercial & personal use. You’re free to use it in your portfolio, client work, YouTube tutorials, blog posts and courses — attribution to DataVix is appreciated but not required.
Which tools does this dataset work with?
It’s ready for Power BI, SQL, Excel, Python. The CSV/XLSX files import directly into Excel, Power BI, Python (pandas) and any SQL database.
Is this real or synthetic data?
It’s realistic, analysis-ready practice data modelled on real-world business scenarios and cleaned for learning — safe to share publicly with no personal or confidential information.