# tandah-marcelle/pipeline-etl-dashboard-finance-market architecture

> Architecture diagram of the GitHub repository tandah-marcelle/pipeline-etl-dashboard-finance-market, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/tandah-marcelle/pipeline-etl-dashboard-finance-market
- Repository: https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market

## Overview

Finance Market Analytics is a notebook-based market-data ETL project paired with a Power BI dashboard. The documented workflow ingests stock-index prices and EUR/USD rates, transforms them into analytical measures and a star-schema model, then presents interactive historical trends and filters. The tree contains the notebook, raw rate snapshots, a stock-index CSV, and the Power BI file. Source excerpts were unavailable, so stage wiring follows README claims; database implementation details and specific notebook calls cannot be verified.

Main entry points: [`Pipeline_ETL_Finance_Market.ipynb`](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb) (ETL Notebook), [`BI_Pipeline_ETL_Finance_Market.pbix`](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/BI_Pipeline_ETL_Finance_Market.pbix) (Power BI Report), [`Stock_Market_Index.csv`](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Stock_Market_Index.csv) (Stock Indices), [`data/raw`](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/tree/master/data/raw) (FX Rate Snapshots)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_etl["ETL Pipeline"]
  node_notebook["ETL Notebook"]
  node_market_model[("Market Data Model")]
  node_metrics["Market Metrics"]
end

subgraph group_data["Market Data"]
  node_indices["Stock Indices"]
  node_rates["FX Rate Snapshots"]
end

subgraph group_analytics["Analytics Dashboard"]
  node_powerbi["Power BI Report"]
end

node_analyst(("Analyst"))

node_notebook -->|"reads"| node_indices
node_notebook -->|"reads"| node_rates
node_notebook -->|"transforms"| node_market_model
node_notebook -->|"calculates"| node_metrics
node_powerbi -->|"models"| node_market_model
node_analyst -->|"explores"| node_powerbi

click node_notebook "https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb"
click node_indices "https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Stock_Market_Index.csv"
click node_rates "https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/tree/master/data/raw"
click node_market_model "https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb"
click node_metrics "https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb"
click node_powerbi "https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/BI_Pipeline_ETL_Finance_Market.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_notebook,node_market_model,node_metrics toneBlue
class node_indices,node_rates toneAmber
class node_powerbi toneMint
class node_analyst toneIndigo
```

## Components

### ETL Pipeline

- [ETL Notebook](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb): `Pipeline_ETL_Finance_Market.ipynb`
- [Market Data Model](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb): `Pipeline_ETL_Finance_Market.ipynb`
- [Market Metrics](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Pipeline_ETL_Finance_Market.ipynb): `Pipeline_ETL_Finance_Market.ipynb`

### Market Data

- [Stock Indices](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/Stock_Market_Index.csv): `Stock_Market_Index.csv`
- [FX Rate Snapshots](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/tree/master/data/raw): `data/raw`

### Analytics Dashboard

- [Power BI Report](https://github.com/tandah-marcelle/pipeline-etl-dashboard-finance-market/blob/master/BI_Pipeline_ETL_Finance_Market.pbix): `BI_Pipeline_ETL_Finance_Market.pbix`

### Other components

- **Analyst**

## Connections

- ETL Notebook → Stock Indices: reads
- ETL Notebook → FX Rate Snapshots: reads
- ETL Notebook → Market Data Model: transforms
- ETL Notebook → Market Metrics: calculates
- Power BI Report → Market Data Model: models
- Analyst → Power BI Report: explores