# niravtrivedi23/mutual-fund-analysis-dashboard-python-powerbi architecture

> Architecture diagram of the GitHub repository niravtrivedi23/mutual-fund-analysis-dashboard-python-powerbi, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/niravtrivedi23/mutual-fund-analysis-dashboard-python-powerbi
- Repository: https://github.com/niravtrivedi23/mutual-fund-analysis-dashboard-python-powerbi

## Overview

This repository documents a mutual-fund analysis workflow: a large scheme dataset is cleaned, normalized, scored and ranked to identify 30 funds, then supported by Excel and presented in an interactive Power BI dashboard. The README also describes dashboard filters, KPI and comparison visuals, and insight cards. The listed files contain no sampled implementation or dashboard/data artifacts, so paths are null; relationships are limited to those documented in the README.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_analysis["Fund analysis"]
  node_cleaning["Data cleaning"]
  node_description["Data description"]
  node_normalization["Normalization"]
  node_scoring["Fund scoring"]
  node_ranking["Top 30 ranking"]
end

subgraph group_support["Data support"]
  node_excel["Excel support"]
end

subgraph group_dashboard["Dashboard insights"]
  node_dashboard["Power BI dashboard"]
  node_filters["Dynamic filters"]
  node_fund_kpis["Fund KPIs"]
  node_cost_returns["Cost and returns"]
  node_manager_amc["AMC and managers"]
  node_insights["Insight cards"]
end

node_dataset[("Scheme dataset")]
node_investor(("Dashboard user"))

node_dataset -->|"is cleaned"| node_cleaning
node_cleaning -->|"is summarized"| node_description
node_description -->|"is normalized"| node_normalization
node_normalization -->|"supports scoring"| node_scoring
node_scoring -->|"selects top 30"| node_ranking
node_ranking -->|"is supported in"| node_excel
node_excel -->|"supports dashboard"| node_dashboard
node_investor -->|"views"| node_dashboard
node_dashboard -->|"provides"| node_filters
node_dashboard -->|"presents"| node_fund_kpis
node_dashboard -->|"compares"| node_cost_returns
node_dashboard -->|"summarizes"| node_manager_amc
node_dashboard -->|"generates"| node_insights

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_cleaning,node_description,node_normalization,node_scoring,node_ranking,node_investor toneBlue
class node_excel,node_dataset toneAmber
class node_dashboard,node_filters,node_fund_kpis,node_cost_returns,node_manager_amc,node_insights toneMint
```

## Components

### Fund analysis

- **Data cleaning**
- **Data description**
- **Normalization**
- **Fund scoring**
- **Top 30 ranking**

### Data support

- **Excel support**

### Dashboard insights

- **Power BI dashboard**
- **Dynamic filters**
- **Fund KPIs**
- **Cost and returns**
- **AMC and managers**
- **Insight cards**

### Other components

- **Scheme dataset**
- **Dashboard user**

## Connections

- Scheme dataset → Data cleaning: is cleaned (evidence: `README.md`)
- Data cleaning → Data description: is summarized (evidence: `README.md`)
- Data description → Normalization: is normalized (evidence: `README.md`)
- Normalization → Fund scoring: supports scoring (evidence: `README.md`)
- Fund scoring → Top 30 ranking: selects top 30 (evidence: `README.md`)
- Top 30 ranking → Excel support: is supported in (evidence: `README.md`)
- Excel support → Power BI dashboard: supports dashboard (evidence: `README.md`)
- Dashboard user → Power BI dashboard: views (evidence: `README.md`)
- Power BI dashboard → Dynamic filters: provides (evidence: `README.md`)
- Power BI dashboard → Fund KPIs: presents (evidence: `README.md`)
- Power BI dashboard → Cost and returns: compares (evidence: `README.md`)
- Power BI dashboard → AMC and managers: summarizes (evidence: `README.md`)
- Power BI dashboard → Insight cards: generates (evidence: `README.md`)