scribus01/bank-loan-analysis-powerbi-sql-2-richardekpadi- — explained in plain English
Analysis updated 2026-05-18
Explore a sample Power BI dashboard analyzing bank loan applications, funding, and repayment.
Study the included SQL queries to see how loan KPIs like good versus bad loan percentage are calculated.
Use the dashboard structure as a template for building a similar loan or lending analytics report.
Filter loan data by state, region, or loan purpose using the dashboard's interactive slicers.
| scribus01/bank-loan-analysis-powerbi-sql-2-richardekpadi- | 00kaku/gallery-slider-block | 04amanrajj/netwatch | |
|---|---|---|---|
| Stars | 0 | — | 0 |
| Language | — | JavaScript | Rust |
| Last pushed | — | 2021-05-19 | — |
| Maintenance | — | Dormant | — |
| Setup difficulty | easy | easy | moderate |
| Complexity | 2/5 | 2/5 | 3/5 |
| Audience | data | general | ops devops |
Figures from each repo's GitHub metadata at analysis time.
Requires Power BI Desktop installed to open the .pbix file.
This project is a data analysis dashboard built around bank loan information rather than a piece of software someone installs and runs. It looks at 15,000 loan records to understand patterns in loan applications, how much money was funded and repaid, who the borrowers are, and how risky the overall loan portfolio is. The goal is to turn raw loan data into a set of visual reports that help someone make decisions about lending. The data itself lives in PostgreSQL, a type of database used to store and query information with SQL. From there, the numbers are pulled into Power BI, a tool from Microsoft for building interactive dashboards and charts, with DAX used for the underlying calculations and Excel used to prepare the data beforehand. The dashboard is split into three pages: an executive overview with headline numbers like total applications and funded amounts, a customer analysis page looking at things like employment length, income, and credit score, and a risk and repayment page comparing good loans against bad ones and looking at interest rates and repayment across different states. Alongside the dashboard, a set of SQL queries in the repository calculate the same kinds of figures directly from the database, covering totals, regional performance, loan purposes, and loan grades. To use the project, someone would clone the repository, open the included Power BI file, and explore the three report pages, using filters called slicers to narrow down what they are looking at. The SQL folder holds the underlying queries for anyone who wants to see how the numbers were calculated. The README does not mention a license, so the terms under which this project can be reused are not stated. It was built by a self-described aspiring data analyst as a portfolio piece to demonstrate skills in SQL, Power BI, and Excel.
A Power BI and SQL dashboard project that analyzes 15,000 bank loan records to show trends in funding, repayment, and portfolio risk.
No license is stated in the README, so reuse terms are unclear.
Setup difficulty is rated easy, with roughly 30min to a first successful run.
Mainly data.
This repo across BitVibe Labs
double-check against the repo, no cap.