# vaish1101/ev-charging-expansion-intelligence architecture

> Architecture diagram of the GitHub repository vaish1101/ev-charging-expansion-intelligence, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/vaish1101/ev-charging-expansion-intelligence
- Repository: https://github.com/vaish1101/ev-charging-expansion-intelligence

## Overview

This repository implements an EV-charging regional screening product: official German vehicle, charging and geography data are landed and validated, transformed through Bronze/Silver/Gold, and published for Databricks and Power BI reporting. Geography reconciliation and blocking quality checks are central domain stages. The README documents the overall flow and dashboard capabilities; sampled source excerpts and the SOURCE INDEX establish internal module dependencies. Unsampled dashboard and serving details are represented at their supported directory or file paths.

Main entry points: [`src/ev_charging/silver_transformations.py`](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/silver_transformations.py) (Silver transforms), [`src/ev_charging/gold_transformations.py`](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/gold_transformations.py) (Gold transforms), [`src/ev_charging/bronze_ingestion.py`](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/bronze_ingestion.py) (Bronze ingestion), [`databricks/sql/published_gold_views.sql`](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/sql/published_gold_views.sql) (Published views)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Source ingestion"]
  node_landing["Source landing"]
  node_validation["Source validation"]
  node_bronze_entry["Bronze entry"]
  node_bronze["Bronze ingestion"]
end

subgraph group_transform["Analytics pipeline"]
  node_silver_entry["Silver entry<br/>[phase2c_silver.py]"]
  node_silver["Silver transforms"]
  node_gold_entry["Gold entry<br/>[phase2d_gold.py]"]
  node_gold["Gold transforms"]
end

subgraph group_serve["Serving and reporting"]
  node_views[("Published views")]
  node_ready["Serving readiness"]
  node_db_dashboard["Databricks dashboard"]
  node_powerbi_model[("Power BI model<br/>[model.tmdl]")]
  node_powerbi_report["Power BI report<br/>[report.json]"]
end

subgraph group_rules["Contracts and controls"]
  node_contracts["Source contracts"]
  node_identity["Data identity<br/>[identity.py]"]
  node_silver_rules["Geography rules<br/>[silver_rules.py]"]
  node_gold_rules["Gold rules<br/>[gold_rules.py]"]
end

node_analysts(("Planning teams"))
node_official["Official datasets"]

node_official -->|"lands revisions"| node_landing
node_landing -->|"validates landed"| node_validation
node_validation -->|"checks formats"| node_contracts
node_validation -->|"computes revisions"| node_identity
node_bronze_entry -->|"runs ingestion"| node_bronze
node_bronze -->|"validates sources"| node_contracts
node_bronze -->|"uses identities"| node_identity
node_silver_entry -->|"runs transforms"| node_silver
node_silver -->|"applies rules"| node_silver_rules
node_silver -->|"uses identities"| node_identity
node_gold_entry -->|"runs transforms"| node_gold
node_gold -->|"applies checks"| node_gold_rules
node_gold -->|"uses identities"| node_identity
node_bronze -->|"transforms Bronze"| node_silver
node_silver -->|"aggregates Silver"| node_gold
node_gold -->|"publishes results"| node_views
node_views -->|"checks readiness"| node_ready
node_views -->|"serves screening"| node_db_dashboard
node_views -->|"serves KPI layer"| node_powerbi_model
node_powerbi_model -->|"drives report"| node_powerbi_report
node_analysts -->|"screens regions"| node_db_dashboard
node_analysts -->|"investigates regions"| node_powerbi_report

click node_landing "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase4_source_landing.py"
click node_validation "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase4_source_validation.py"
click node_bronze_entry "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase2b_bronze_ingestion.py"
click node_bronze "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/bronze_ingestion.py"
click node_contracts "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/source_contracts.py"
click node_identity "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/identity.py"
click node_silver_entry "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase2c_silver.py"
click node_silver "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/silver_transformations.py"
click node_silver_rules "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/silver_rules.py"
click node_gold_entry "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase2d_gold.py"
click node_gold "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/gold_transformations.py"
click node_gold_rules "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/gold_rules.py"
click node_views "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/sql/published_gold_views.sql"
click node_ready "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase4_serving_readiness.py"
click node_db_dashboard "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/dashboards/ev_charging_intelligence.lvdash.json"
click node_powerbi_model "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/powerbi/EV%20Charging%20Intelligence.SemanticModel/definition/model.tmdl"
click node_powerbi_report "https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/powerbi/EV%20Charging%20Intelligence.Report/definition/report.json"

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_landing,node_validation,node_bronze_entry,node_bronze toneBlue
class node_silver_entry,node_silver,node_gold_entry,node_gold toneAmber
class node_views,node_ready,node_db_dashboard,node_powerbi_model,node_powerbi_report toneMint
class node_contracts,node_identity,node_silver_rules,node_gold_rules toneRose
class node_analysts,node_official toneIndigo
```

## Components

### Source ingestion

- [Source landing](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase4_source_landing.py): `databricks/notebooks/phase4_source_landing.py`
- [Source validation](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase4_source_validation.py): `databricks/notebooks/phase4_source_validation.py`
- [Bronze entry](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase2b_bronze_ingestion.py): `databricks/notebooks/phase2b_bronze_ingestion.py`
- [Bronze ingestion](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/bronze_ingestion.py): `src/ev_charging/bronze_ingestion.py`

### Analytics pipeline

- [Silver entry](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase2c_silver.py): `databricks/notebooks/phase2c_silver.py`
- [Silver transforms](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/silver_transformations.py): `src/ev_charging/silver_transformations.py`
- [Gold entry](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase2d_gold.py): `databricks/notebooks/phase2d_gold.py`
- [Gold transforms](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/gold_transformations.py): `src/ev_charging/gold_transformations.py`

### Serving and reporting

- [Published views](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/sql/published_gold_views.sql): `databricks/sql/published_gold_views.sql`
- [Serving readiness](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/notebooks/phase4_serving_readiness.py): `databricks/notebooks/phase4_serving_readiness.py`
- [Databricks dashboard](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/databricks/dashboards/ev_charging_intelligence.lvdash.json): `databricks/dashboards/ev_charging_intelligence.lvdash.json`
- [Power BI model](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/powerbi/EV%20Charging%20Intelligence.SemanticModel/definition/model.tmdl): `powerbi/EV Charging Intelligence.SemanticModel/definition/model.tmdl`
- [Power BI report](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/powerbi/EV%20Charging%20Intelligence.Report/definition/report.json): `powerbi/EV Charging Intelligence.Report/definition/report.json`

### Contracts and controls

- [Source contracts](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/source_contracts.py): `src/ev_charging/source_contracts.py`
- [Data identity](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/identity.py): `src/ev_charging/identity.py`
- [Geography rules](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/silver_rules.py): `src/ev_charging/silver_rules.py`
- [Gold rules](https://github.com/vaish1101/ev-charging-expansion-intelligence/blob/main/src/ev_charging/gold_rules.py): `src/ev_charging/gold_rules.py`

### Other components

- **Planning teams**
- **Official datasets**

## Connections

- Official datasets → Source landing: lands revisions (evidence: `README.md`)
- Source landing → Source validation: validates landed (evidence: `README.md`)
- Source validation → Source contracts: checks formats (evidence: `databricks/notebooks/phase4_source_validation.py`)
- Source validation → Data identity: computes revisions (evidence: `databricks/notebooks/phase4_source_validation.py`)
- Bronze entry → Bronze ingestion: runs ingestion (evidence: `databricks/notebooks/phase2b_bronze_ingestion.py`)
- Bronze ingestion → Source contracts: validates sources (evidence: `src/ev_charging/bronze_ingestion.py`)
- Bronze ingestion → Data identity: uses identities (evidence: `src/ev_charging/bronze_ingestion.py`)
- Silver entry → Silver transforms: runs transforms (evidence: `databricks/notebooks/phase2c_silver.py`)
- Silver transforms → Geography rules: applies rules (evidence: `src/ev_charging/silver_transformations.py`)
- Silver transforms → Data identity: uses identities (evidence: `src/ev_charging/silver_transformations.py`)
- Gold entry → Gold transforms: runs transforms (evidence: `databricks/notebooks/phase2d_gold.py`)
- Gold transforms → Gold rules: applies checks (evidence: `src/ev_charging/gold_transformations.py`)
- Gold transforms → Data identity: uses identities (evidence: `src/ev_charging/gold_transformations.py`)
- Bronze ingestion → Silver transforms: transforms Bronze (evidence: `README.md`)
- Silver transforms → Gold transforms: aggregates Silver (evidence: `README.md`)
- Gold transforms → Published views: publishes results (evidence: `README.md`)
- Published views → Serving readiness: checks readiness (evidence: `databricks/notebooks/phase4_serving_readiness.py`)
- Published views → Databricks dashboard: serves screening (evidence: `README.md`)
- Published views → Power BI model: serves KPI layer (evidence: `README.md`)
- Power BI model → Power BI report: drives report (evidence: `README.md`)
- Planning teams → Databricks dashboard: screens regions (evidence: `README.md`)
- Planning teams → Power BI report: investigates regions (evidence: `README.md`)
