How vaish1101/ev-charging-expansion-intelligence works
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: silver_transformations.py Silver transforms · gold_transformations.py Gold transforms · bronze_ingestion.py Bronze ingestion · published_gold_views.sql Published views
Components 19
Source ingestion
- Source landing
databricks/notebooks/phase4_source_landing.py - Source validation
databricks/notebooks/phase4_source_validation.py - Bronze entry
databricks/notebooks/phase2b_bronze_ingestion.py - Bronze ingestion
src/ev_charging/bronze_ingestion.py
Analytics pipeline
- Silver entry
databricks/notebooks/phase2c_silver.py - Silver transforms
src/ev_charging/silver_transformations.py - Gold entry
databricks/notebooks/phase2d_gold.py - Gold transforms
src/ev_charging/gold_transformations.py
Serving and reporting
- Published views
databricks/sql/published_gold_views.sql - Serving readiness
databricks/notebooks/phase4_serving_readiness.py - Databricks dashboard
databricks/dashboards/ev_charging_intelligence.lvdash.json - Power BI model
powerbi/EV Charging Intelligence.SemanticModel/definition/model.tmdl - Power BI report
powerbi/EV Charging Intelligence.Report/definition/report.json
Contracts and controls
- Source contracts
src/ev_charging/source_contracts.py - Data identity
src/ev_charging/identity.py - Geography rules
src/ev_charging/silver_rules.py - Gold rules
src/ev_charging/gold_rules.py
Other components
- Planning teams
- Official datasets
Connections 22
- Official datasets → Source landing: lands revisions
README.md - Source landing → Source validation: validates landed
README.md - Source validation → Source contracts: checks formats
databricks/notebooks/phase4_source_validation.py - Source validation → Data identity: computes revisions
databricks/notebooks/phase4_source_validation.py - Bronze entry → Bronze ingestion: runs ingestion
databricks/notebooks/phase2b_bronze_ingestion.py - Bronze ingestion → Source contracts: validates sources
src/ev_charging/bronze_ingestion.py - Bronze ingestion → Data identity: uses identities
src/ev_charging/bronze_ingestion.py - Silver entry → Silver transforms: runs transforms
databricks/notebooks/phase2c_silver.py - Silver transforms → Geography rules: applies rules
src/ev_charging/silver_transformations.py - Silver transforms → Data identity: uses identities
src/ev_charging/silver_transformations.py - Gold entry → Gold transforms: runs transforms
databricks/notebooks/phase2d_gold.py - Gold transforms → Gold rules: applies checks
src/ev_charging/gold_transformations.py - Gold transforms → Data identity: uses identities
src/ev_charging/gold_transformations.py - Bronze ingestion → Silver transforms: transforms Bronze
README.md - Silver transforms → Gold transforms: aggregates Silver
README.md - Gold transforms → Published views: publishes results
README.md - Published views → Serving readiness: checks readiness
databricks/notebooks/phase4_serving_readiness.py - Published views → Databricks dashboard: serves screening
README.md - Published views → Power BI model: serves KPI layer
README.md - Power BI model → Power BI report: drives report
README.md - Planning teams → Databricks dashboard: screens regions
README.md - Planning teams → Power BI report: investigates regions
README.md