Energy & MaStR
Nightly pipelines from BNetzA’s plant register into Parquet/DuckDB views municipalities and teams can use.
Energy · Analytics · Interactive systems
I’m Tarek Chehade, based in Erfurt. I ship Python, R/Shiny, and SQL products — live dashboards, not slide decks that go stale overnight.
Selected work
Public apps on this server — click through, no install. Full catalog lives on the dashboard hub.
Monthly new PV capacity in Germany — Home, C&I, Large Scale — with year-to-date comparison.
Open dashboard → ResearchQualitative recruitment study: interviews, org map, coded extracts, and an interactive viz gallery.
Open research → LiveDay-ahead bidding zones across Europe — map, chart, and table from Energy-Charts.
Open live view → LiveLive global horizontal irradiance map and hourly series from Open-Meteo / DWD models.
Open map → RegionalLarge-scale solar, storage, and wind by Kreis — built for municipal stakeholders.
Open regional view → Civic2022 parliamentary casas — density, candidates, treemap. Tableau craft, rebuilt in Shiny.
Open civic viz →Practice
Nightly pipelines from BNetzA’s plant register into Parquet/DuckDB views municipalities and teams can use.
Day-ahead prices, solar irradiance, auto-refreshing maps — real feeds, not screenshots.
One app, one URL, one process: Shiny behind nginx, systemd, Grafana, documented schemas.
Reproducible ETL and verification so every dashboard figure can be traced to a source row.
Stakeholder demos
Pitch boards and factory-floor views — shareable, browser-only.
Eagle-eye factory map for IG Metall Mitte — membership and organising potential by building.
Open demo → IG MetallWorkforce mix by age, role, and department — interactive charts for organising conversations.
Open demo → IG MetallTariff facts as a searchable digital product — DFI 2026, rebuilt for the screen.
Open demo → PitchOperations pulse for canteens, events, quality, and sustainability — stakeholder-ready demo.
Open demo → BriefingOne-screen interactive explainer of the September 2026 independent strategy — five urgent objectives, no page scroll.
Open briefing →The lab
Monitoring and documentation for the dashboard fleet — useful if you want to see how it runs.
Catalog of every public Shiny app on this VPS.
LiveServer health in kiosk mode — CPU, probes, traffic.
PublicFull monitoring stack, public view.
PublicHigh-resolution host metrics.
PublicArchitecture, deploy notes, and how the hub is wired.
PasswordPrivate nginx analytics for this host.
Contact
Prefer email — phone signal at work is unreliable. Open to collaborations and research tooling.