# jibinpeter14/bank-loan-dashboard_sql-powerbi architecture

> Architecture diagram of the GitHub repository jibinpeter14/bank-loan-dashboard_sql-powerbi, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-28). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jibinpeter14/bank-loan-dashboard_sql-powerbi
- Repository: https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi

## Overview

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`](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix) (Interactive Dashboard), [`Bank_Loan_data.csv`](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank_Loan_data.csv) (Loan Dataset), [`sql_queries.sql`](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/sql_queries.sql) (SQL Queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Loan Data"]
  node_loan_data["Loan Dataset<br/>[Bank_Loan_data.csv]"]
end

subgraph group_sql["SQL Analysis"]
  node_sql_queries["SQL Queries<br/>[sql_queries.sql]"]
end

subgraph group_powerbi["Power BI"]
  node_report_model["Data Model"]
  node_date_table["Date Table"]
  node_dashboard["Interactive Dashboard"]
  node_kpis["Portfolio KPIs"]
  node_risk["Loan Risk Summary"]
  node_breakdowns["Loan Breakdowns"]
  node_loan_details["Loan Details"]
end

node_analyst(("Analyst"))

node_loan_data -->|"queries read"| node_sql_queries
node_loan_data -->|"models"| node_report_model
node_date_table -->|"supports time analysis"| node_report_model
node_report_model -->|"supplies data"| node_dashboard
node_dashboard -->|"shows"| node_kpis
node_dashboard -->|"shows"| node_risk
node_dashboard -->|"shows"| node_breakdowns
node_dashboard -->|"shows"| node_loan_details
node_analyst -->|"runs analysis"| node_sql_queries
node_analyst -->|"explores"| node_dashboard

click node_loan_data "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank_Loan_data.csv"
click node_sql_queries "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/sql_queries.sql"
click node_report_model "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"
click node_date_table "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"
click node_dashboard "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"
click node_kpis "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"
click node_risk "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"
click node_breakdowns "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"
click node_loan_details "https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_loan_data toneBlue
class node_sql_queries toneAmber
class node_report_model,node_date_table,node_dashboard,node_kpis,node_risk,node_breakdowns,node_loan_details toneMint
class node_analyst toneIndigo
```

## Components

### Loan Data

- [Loan Dataset](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank_Loan_data.csv): `Bank_Loan_data.csv`

### SQL Analysis

- [SQL Queries](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/sql_queries.sql): `sql_queries.sql`

### Power BI

- [Data Model](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`
- [Date Table](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`
- [Interactive Dashboard](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`
- [Portfolio KPIs](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`
- [Loan Risk Summary](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`
- [Loan Breakdowns](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`
- [Loan Details](https://github.com/jibinpeter14/bank-loan-dashboard_sql-powerbi/blob/main/Bank%20Loan%20Dashboard_Project.pbix): `Bank Loan Dashboard_Project.pbix`

### Other components

- **Analyst**

## Connections

- 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