# silwiueduard/bolt-trips-analysis-2026-bucharest-romania architecture

> Architecture diagram of the GitHub repository silwiueduard/bolt-trips-analysis-2026-bucharest-romania, 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/silwiueduard/bolt-trips-analysis-2026-bucharest-romania
- Repository: https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania

## Overview

This repository is a Bolt fleet ETL and business-intelligence project: it extracts operational records, stores raw data, transforms and exports analytical datasets, and presents performance findings in Power BI. The README documents the broader scheduled cloud pipeline, while the sampled Python excerpt shows API extraction and Bronze uploads. SQL, workflow, and report internals were not sampled, so their connections below rely on README statements; the Power BI data connection is left unverified.

Main entry points: [`.github/workflows/weekly_extraction_bolt_v3.yml`](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/.github/workflows/weekly_extraction_bolt_v3.yml) (Weekly Workflow), [`python/bolt_fleet_extractor.py`](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/python/bolt_fleet_extractor.py) (Fleet Extractor), [`data/data_silver`](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data/data_silver) (Silver Dataset), [`sql/archive`](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/sql/archive) (Analysis Queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Extraction"]
  node_schedule["Weekly Workflow"]
  node_extractor["Fleet Extractor"]
  node_bolt{{"Bolt Fleet API"}}
end

subgraph group_warehouse["Data Platform"]
  node_bronze[("Bronze Storage")]
  node_rawfiles[("Local Raw Data")]
  node_transform["SQL Transformations"]
  node_silverexport["Silver Export"]
  node_silver[("Silver Dataset")]
end

subgraph group_analytics["Analysis"]
  node_queries["Analysis Queries"]
  node_gold[("Gold Results")]
end

subgraph group_presentation["Reporting"]
  node_powerbi["Power BI Dashboard"]
  node_reports["Analysis Reports"]
end

node_operator(("Fleet Analyst"))

node_operator -.->|"initiates"| node_schedule
node_schedule -->|"runs"| node_extractor
node_schedule -->|"runs"| node_transform
node_schedule -->|"runs"| node_silverexport
node_extractor -->|"requests data"| node_bolt
node_extractor -->|"writes files"| node_rawfiles
node_extractor -->|"uploads raw data"| node_bronze
node_bronze -->|"supplies raw data"| node_transform
node_transform -.->|"transforms"| node_silverexport
node_silverexport -->|"exports datasets"| node_silver
node_silver -.->|"analyzed by"| node_queries
node_queries -.->|"produces results"| node_gold
node_silver -.->|"feeds dashboard"| node_powerbi
node_gold -.->|"visualized in"| node_powerbi
node_queries -.->|"documented in"| node_reports
node_operator -->|"reviews insights"| node_powerbi

click node_schedule "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/.github/workflows/weekly_extraction_bolt_v3.yml"
click node_extractor "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/python/bolt_fleet_extractor.py"
click node_rawfiles "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data"
click node_transform "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/sql/create_silver_orders.sql"
click node_silverexport "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/sql/export_silver_orders.sql"
click node_silver "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data/data_silver"
click node_queries "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/sql/archive"
click node_gold "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data/data_gold"
click node_powerbi "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/powerbi/Bolt_Analysis_Silviu.pbix"
click node_reports "https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/docs"

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_schedule,node_extractor,node_bolt toneBlue
class node_bronze,node_rawfiles,node_transform,node_silverexport,node_silver toneAmber
class node_queries,node_gold toneMint
class node_powerbi,node_reports toneRose
class node_operator toneIndigo
```

## Components

### Extraction

- [Weekly Workflow](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/.github/workflows/weekly_extraction_bolt_v3.yml): `.github/workflows/weekly_extraction_bolt_v3.yml`
- [Fleet Extractor](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/python/bolt_fleet_extractor.py): `python/bolt_fleet_extractor.py`
- **Bolt Fleet API**

### Data Platform

- **Bronze Storage**
- [Local Raw Data](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data): `data`
- [SQL Transformations](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/sql/create_silver_orders.sql): `sql/create_silver_orders.sql`
- [Silver Export](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/sql/export_silver_orders.sql): `sql/export_silver_orders.sql`
- [Silver Dataset](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data/data_silver): `data/data_silver`

### Analysis

- [Analysis Queries](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/sql/archive): `sql/archive`
- [Gold Results](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/data/data_gold): `data/data_gold`

### Reporting

- [Power BI Dashboard](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/blob/main/powerbi/Bolt_Analysis_Silviu.pbix): `powerbi/Bolt_Analysis_Silviu.pbix`
- [Analysis Reports](https://github.com/silwiueduard/bolt-trips-analysis-2026-bucharest-romania/tree/main/docs): `docs`

### Other components

- **Fleet Analyst**

## Connections

- Fleet Analyst → Weekly Workflow: initiates (evidence: `README.md`)
- Weekly Workflow → Fleet Extractor: runs (evidence: `README.md`)
- Weekly Workflow → SQL Transformations: runs (evidence: `README.md`)
- Weekly Workflow → Silver Export: runs (evidence: `README.md`)
- Fleet Extractor → Bolt Fleet API: requests data (evidence: `python/bolt_fleet_extractor.py`)
- Fleet Extractor → Local Raw Data: writes files (evidence: `python/bolt_fleet_extractor.py`)
- Fleet Extractor → Bronze Storage: uploads raw data (evidence: `python/bolt_fleet_extractor.py`)
- Bronze Storage → SQL Transformations: supplies raw data (evidence: `README.md`)
- SQL Transformations → Silver Export: transforms (evidence: `README.md`)
- Silver Export → Silver Dataset: exports datasets (evidence: `README.md`)
- Silver Dataset → Analysis Queries: analyzed by
- Analysis Queries → Gold Results: produces results
- Silver Dataset → Power BI Dashboard: feeds dashboard
- Gold Results → Power BI Dashboard: visualized in
- Analysis Queries → Analysis Reports: documented in (evidence: `README.md`)
- Fleet Analyst → Power BI Dashboard: reviews insights (evidence: `README.md`)
