I help engineering & construction teams turn messy progress and energy/supply data into clear decisions.
Open to remote and DK/SE/NO relocation · EN/ES
P2 — Nordic Infrastructure Sustainability v0.9 (Power BI + Fabric)
End-to-end demo to track Energy, CO₂e, Cost, Delay by city/asset with Executive and What-if pages.
Fabric path: Lakehouse (Delta) → Semantic Model (Direct Lake) → thin report (live).
- Repo: https://github.com/asaygom/p2-nordic-infra-sustainability-fabric-powerbi
- One-pager (PDF) & 90s GIF: see
/media
in the repo
- P1 · Plan vs Actual (Power BI) — weekly KPIs, variance %, simple pace index.
- P2 · Nordic Infra Sustainability (Power BI + Fabric) — plan vs actual, What-if (±20%), Direct Lake lineage.
- P3 · Supply Chain (Power BI + SQL + Python) — inventory & demand analytics: OTIF, stockouts, lead-time variability, safety stock & reorder points; Python/SQL ETL → Power BI model.
- Power BI (DAX, data modeling, Power Query), Microsoft Fabric (Lakehouse, Semantic/Direct Lake)
- SQL, Python (pandas) for data prep and light automation
Extended toolset (past use / learning)
Bash · Git · Streamlit · Next.js · React/JS/TS/Angular
- Star-schema modeling and KPI design (variance/%, YTD/MTD/QTD)
- What-if analysis in Power BI (scenario sliders, adjusted KPIs)
- Fabric lineage: Lakehouse → Semantic (Direct Lake) → thin reports
- Lightweight automation (Python/pandas) and SQL-backed ETL for BI