# mohitsapkal/financial_performance_dashboard architecture

> Architecture diagram of the GitHub repository mohitsapkal/financial_performance_dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-13). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mohitsapkal/financial_performance_dashboard
- Repository: https://github.com/mohitsapkal/financial_performance_dashboard

## Overview

This repository appears to support a financial performance dashboard: a Python loader imports the supplied CSV into MySQL, alongside a SQL analysis file and a Power BI dashboard artifact. The loader’s read and insert operations are explicit. The README is empty, and the SQL and dashboard contents were not sampled, so their relationships to the database or each other cannot be verified.

Main entry points: [`load_data.py`](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/load_data.py) (CSV loader), [`dataset/Financial_Sample_dataset.csv`](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/dataset/Financial_Sample_dataset.csv) (Financial CSV), [`Financial_Performance_Dashboard.pbix`](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/Financial_Performance_Dashboard.pbix) (Power BI dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Financial Data"]
  node_csv["Financial CSV"]
  node_mysql[("MySQL database")]
end

subgraph group_ingestion["Data Ingestion"]
  node_loader["CSV loader<br/>[load_data.py]"]
end

subgraph group_analytics["Analytics"]
  node_sql["SQL analysis"]
  node_dashboard["Power BI dashboard"]
end

node_user(("Dashboard user"))

node_loader -->|"reads"| node_csv
node_loader -->|"inserts rows"| node_mysql
node_user -.->|"views"| node_dashboard

click node_csv "https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/dataset/Financial_Sample_dataset.csv"
click node_loader "https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/load_data.py"
click node_sql "https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/financial_data_analysis.sql"
click node_dashboard "https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/Financial_Performance_Dashboard.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_csv,node_mysql,node_user toneBlue
class node_loader toneAmber
class node_sql,node_dashboard toneMint
```

## Components

### Financial Data

- [Financial CSV](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/dataset/Financial_Sample_dataset.csv): `dataset/Financial_Sample_dataset.csv`
- **MySQL database**

### Data Ingestion

- [CSV loader](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/load_data.py): `load_data.py`

### Analytics

- [SQL analysis](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/financial_data_analysis.sql): `financial_data_analysis.sql`
- [Power BI dashboard](https://github.com/mohitsapkal/financial_performance_dashboard/blob/main/Financial_Performance_Dashboard.pbix): `Financial_Performance_Dashboard.pbix`

### Other components

- **Dashboard user**

## Connections

- CSV loader → Financial CSV: reads (evidence: `load_data.py`)
- CSV loader → MySQL database: inserts rows (evidence: `load_data.py`)
- Dashboard user → Power BI dashboard: views