How silwiueduard/bolt-trips-analysis-2026-bucharest-romania works
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: weekly_extraction_bolt_v3.yml Weekly Workflow · bolt_fleet_extractor.py Fleet Extractor · data_silver Silver Dataset · archive Analysis Queries
Components 13
Extraction
- Weekly Workflow
.github/workflows/weekly_extraction_bolt_v3.yml - Fleet Extractor
python/bolt_fleet_extractor.py - Bolt Fleet API
Data Platform
- Bronze Storage
- Local Raw Data
data - SQL Transformations
sql/create_silver_orders.sql - Silver Export
sql/export_silver_orders.sql - Silver Dataset
data/data_silver
Analysis
- Analysis Queries
sql/archive - Gold Results
data/data_gold
Reporting
- Power BI Dashboard
powerbi/Bolt_Analysis_Silviu.pbix - Analysis Reports
docs
Other components
- Fleet Analyst
Connections 16
- Fleet Analyst → Weekly Workflow: initiates
README.md - Weekly Workflow → Fleet Extractor: runs
README.md - Weekly Workflow → SQL Transformations: runs
README.md - Weekly Workflow → Silver Export: runs
README.md - Fleet Extractor → Bolt Fleet API: requests data
python/bolt_fleet_extractor.py - Fleet Extractor → Local Raw Data: writes files
python/bolt_fleet_extractor.py - Fleet Extractor → Bronze Storage: uploads raw data
python/bolt_fleet_extractor.py - Bronze Storage → SQL Transformations: supplies raw data
README.md - SQL Transformations → Silver Export: transforms
README.md - Silver Export → Silver Dataset: exports datasets
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
README.md - Fleet Analyst → Power BI Dashboard: reviews insights
README.md