How jibinpeter14/bank-loan-dashboard_sql-powerbi works
This is a bank-loan analytics project: analysts use SQL queries and a Power BI report to examine loan volume, funding and repayment, borrower characteristics, and portfolio risk. The CSV is the documented loan dataset; the report includes a data model with a date table and interactive dashboard views. SQL and Power BI are described as separate analysis and visualization tools; no source excerpts are available to establish further runtime wiring.
Main entry points: Bank Loan Dashboard_Project.pbix Interactive Dashboard · Bank_Loan_data.csv Loan Dataset · sql_queries.sql SQL Queries
Components 10
Loan Data
- Loan Dataset
Bank_Loan_data.csv
SQL Analysis
- SQL Queries
sql_queries.sql
Power BI
- Data Model
Bank Loan Dashboard_Project.pbix - Date Table
Bank Loan Dashboard_Project.pbix - Interactive Dashboard
Bank Loan Dashboard_Project.pbix - Portfolio KPIs
Bank Loan Dashboard_Project.pbix - Loan Risk Summary
Bank Loan Dashboard_Project.pbix - Loan Breakdowns
Bank Loan Dashboard_Project.pbix - Loan Details
Bank Loan Dashboard_Project.pbix
Other components
- Analyst
Connections 10
- Loan Dataset → SQL Queries: queries read
- Loan Dataset → Data Model: models
- Date Table → Data Model: supports time analysis
- Data Model → Interactive Dashboard: supplies data
- Interactive Dashboard → Portfolio KPIs: shows
- Interactive Dashboard → Loan Risk Summary: shows
- Interactive Dashboard → Loan Breakdowns: shows
- Interactive Dashboard → Loan Details: shows
- Analyst → SQL Queries: runs analysis
- Analyst → Interactive Dashboard: explores