- React dashboard —
10_dashboard_react/· Vite + React 18 + Tailwind + Plotly + Framer Motion. Premium single page with the Aqualia logo, animated hero orb with floating T1/T2/T3 dots, interactive Monte Carlo matrix, ESRS gap heatmap, Aqueduct water-stress view, and the roadmap grid. Run withnpm install && npm run dev.
Track: Double Materiality & ESG Strategy – Aqualia · IE Sustainability Datathon · March 2026.
External ESG advisory engagement simulated for the IE Sustainability Datathon. Deliverable: a CSRD/ESRS‑aligned double materiality assessment and strategic sustainability roadmap for Aqualia at a level of rigor suitable for executive-committee or sustainability- board review.
Thesis. Three assets carry the submission: a methodology that combines Monte Carlo, bilingual TF-IDF, and Mitchell–Agle–Wood salience in a way rarely seen at this scale; a finding (Colombia 33% customer satisfaction, ESRS S3 absorbed into S4) traceable to Aqualia's own published data; and a deck built to land in five minutes without losing technical rigor.
Workshop 1 — The Analytical Current: A Consultant's Playbook — made the grading criteria explicit. Every deliverable below is mapped to one of these four items:
- Justify your selection. Clearly articulate why our three chosen topics are strategically relevant to Aqualia's value chain.
- Show your math. Document thresholds, criteria, weighting logic for every severity calculation.
- Trace the logic. Matrix is a direct visual output of the scoring methodology — reviewer can reconstruct any bubble from the scoring sheet.
- Make it actionable. 2027–2030 recommendations must be realistic, defensible, focused on long-term value creation.
Workshop 1 also locked the 4-phase blueprint we follow: Phase 1 Context Analysis → Phase 2 Impact Materiality → Phase 3 Financial Materiality → Phase 4 Strategic Synthesis. Matrix axes confirmed: Y = Impact Severity (Scale × Scope × Remediability × Probability), X = Financial Severity (Magnitude × Probability), Target Zone = top-right quadrant (both ≥ 2.5).
Aqualia (water management and sanitation, part of FCC Group) is refining its double materiality framework to comply with CSRD and the European Sustainability Reporting Standards (ESRS). Our task, as external ESG consultants:
- Identify three material topics strategically relevant to Aqualia.
- Assess each along two dimensions:
- Impact materiality — scale, scope, likelihood, irreversibility of Aqualia's effects on society and the environment.
- Financial materiality — how the topic drives revenues, costs, assets, liabilities, or enterprise value.
- Build a transparent double materiality matrix traceable to a documented scoring methodology.
- Translate findings into a strategic sustainability roadmap for the 2027–2030 horizon.
| # | Deliverable | Location |
|---|---|---|
| 1 | Analytical report, 10–15 pp. (appendices allowed) | 05_report/ |
| 2 | Executive‑ready double materiality matrix | 04_matrix/ |
| 3 | 5‑minute presentation | 06_presentation/ |
- Technical rigor (50%) — methodology clarity, regulatory alignment, source quality, scoring robustness, matrix consistency.
- Strategic communication (50%) — roadmap coherence, feasibility, business relevance, pitch clarity.
Assumptions, thresholds, and regulatory alignment must be documented. Failure to do so = disqualification.
- Extract Aqualia's existing 2025 material topics from
AQ_2025_Material Topics_ENG.pdfandv2_VF_Aqualia Informe final Revision Doble Materialidad 2025_ENG.pdf. - Overlay ESRS topical standards: E1 Climate change, E2 Pollution, E3 Water & marine resources, E4 Biodiversity, E5 Circular economy, S1 Own workforce, S2 Workers in value chain, S3 Affected communities, S4 Consumers & end‑users, G1 Business conduct.
- Cross‑reference peer material topics (see §7) and sector hotspots (SASB Water Utilities & Services, WBCSD WASH).
- Score long‑list for relevance × urgency and narrow to three.
Impact materiality score = f(Severity, Scope, Irreversibility, Likelihood), per ESRS 1 §43–48.
Financial materiality score = f(Magnitude €, Probability, Time
horizon), per ESRS 1 §49–51 and Aqualia's internal methodology in
Methodology Double Materiality Assessment Review.pdf.
Each sub‑criterion graded on a 1–5 scale with explicit, cited
thresholds (03_analysis/scoring_rubric.md). Weights derived from
stakeholder salience, not authorial preference.
Use the Mitchell–Agle–Wood stakeholder salience model
(Power × Legitimacy × Urgency) applied to Aqualia's ecosystem in
AQ_2025_GGII_ENG.pdf. Converts the stakeholder section from
narrative to analytical. Output: weights used in §4.2.
For each material topic, estimate € ranges (low / base / high) across:
- Revenue at risk / upside (contract loss, tariff regulation, new service lines)
- OPEX impact (energy, chemicals, labor, compliance)
- CAPEX needs (desalination, treatment upgrades, leak reduction, water reuse)
- Contingent liabilities (fines, litigation, asset stranding)
Anchored to Aqualia's 2022–2024 reported financials and peer disclosures. Real Options Analysis on one major CAPEX decision (e.g., desalination vs water‑reuse) to show capital discipline.
Plot Impact (y) × Financial (x); each topic rendered as a 90% confidence ellipse (from Monte Carlo on the scoring inputs), not a point. Bubble size = stakeholder salience. Threshold lines marked. Matrix is fully reproducible from the scoring spreadsheet.
For each material topic: targets, KPIs, initiatives, CAPEX/OPEX, governance owner, ESRS disclosure reference. Aligned to Aqualia's existing Strategic Sustainability Plan pillars. OKRs, not just KPIs.
- Quantitative 1–5 rubric with cited thresholds for every sub‑criterion.
- ESRS datapoint mapping per topic (exact DRs + datapoint IDs from ESRS E1–E5, S1–S4, G1).
- € financial ranges (low / base / high) with visible assumption log.
- Peer benchmarking — Veolia, Suez, Acciona Agua, Saur, Severn Trent — declared topics side‑by‑side.
- Assumption log — every numeric threshold cited.
- Executive summary that stands alone — one page, answer‑first (Pyramid Principle), three topics + the €-denominated headline.
- Monte Carlo on the matrix. Plot each topic as a 90% confidence ellipse, not a point. Forces engagement with uncertainty.
- WRI Aqueduct 4.0 water‑stress overlay on Aqualia's service geography. Map‑based evidence for water topics.
- Stakeholder salience model (Mitchell, Agle & Wood 1997) — Power × Legitimacy × Urgency, quantified.
- NGFS climate scenarios applied to Aqualia's revenue base — Orderly / Disorderly / Hot House by 2030.
- ESRS gap heatmap — LLM + embeddings to classify Aqualia's 2024 sustainability disclosures against the ~1,100 ESRS datapoints. This is the hero slide.
- "Blind‑spot" finding — a material topic peers disclose but Aqualia under‑weights (or vice versa). Gives the pitch a memorable headline.
- Sensitivity / tornado chart — which inputs most move each topic's position.
- Real Options Analysis on one CAPEX decision (e.g., desalination vs water‑reuse).
- Interactive React dashboard — QR code on deck; jury can adjust
weights live (see
10_dashboard_react/). - Text‑similarity benchmark — sentence‑embedding cosine similarity between Aqualia's topics and each peer's. Quantifies "how differentiated is Aqualia's framing."
- Network / Sankey graph of IROs → topics → ESRS datapoints.
- Expert quote — one water‑sector sustainability lead via LinkedIn outreach. Elevates from "student" to "consulting."
- Climate VaR on Aqualia's asset base.
Rigor gets a high pass. This is what wins.
- Answer‑first structure. Page 1 of the report and Slide 1 of the deck: three topics, the headline €-number, the one‑line recommendation. Everything else is evidence.
- One headline number. "Three material topics — [X], [Y], [Z] — represent €XXX M of financial materiality Aqualia's current framework under‑weights." Judges remember the number, not the method.
- Memorable topic names. Not "Water Resource Management." A sharp 3‑word label + a one‑sentence articulation each. McKinsey names things.
- One‑page board card per topic. Same layout for all three: IRO description, score, financial range, ESRS datapoints, roadmap ask. Six at‑a‑glance visuals beat ten paragraphs.
- Custom visual system. Aqualia palette (navy / aqua / teal / sand), one typeface across report + deck, one chart style. Consistency = credibility.
- Limitations section. PhD signal. Name what the methodology can't do. Intellectual honesty pre‑empts criticism.
- The close. Specific €-denominated ask: "€X of dedicated investment by 2028 → €Y risk mitigated / value created by 2030." Not a recap. An action.
All provided Aqualia materials archived. Use this map before opening anything:
| File | What it gives us |
|---|---|
Aqualia Sustainability Reports.pdf |
Consolidated ESG performance, climate strategy, water management, circular economy, governance (2022–2024) |
Corporate context and sustainability framework_2025_ENG.pdf |
Sector trends, regulatory environment, value chain, strategic challenges |
Corporate narrative about DM process_Aqualia.pdf |
Strategic narrative behind the double materiality review; IRO integration |
Methodology Double Materiality Assessment Review.pdf |
Aqualia's internal scoring methodology — severity, probability, financial magnitude criteria |
v2_VF_Aqualia Informe final Revision Doble Materialidad 2025_ENG.pdf |
2025 DM review summary — benchmarking, validation, final material topics |
AQ_2025_Material Topics_ENG.pdf |
Officially identified ESG material topics mapped to ESRS |
AQ_2025_GGII_ENG.pdf |
Stakeholder ecosystem, engagement mechanisms, communication channels |
Challenge brief: 00_brief/FV_Aqualia_Datathon_Double_Materiality_Challenge.pdf.
Sustainability Datathon/
├── 00_brief/ Challenge PDF
├── 01_research/ CSRD/ESRS notes, peer benchmarks, Aqueduct outputs, scenario notes
├── 02_sources/ Aqualia materials (7 PDFs — see §9)
├── 03_analysis/ Scoring rubric, topic assessments, Monte Carlo, financial estimates
├── 04_matrix/ Double materiality matrix (data + visual)
├── 05_report/ Analytical report (10–15 pp. + appendix)
├── 06_presentation/ 5‑minute deck
└── README.md
| Phase | Output | Review gate |
|---|---|---|
| Baseline extraction from 7 PDFs | 01_research/aqualia_2025_baseline.md |
Internal |
| Peer benchmark + ESRS overlay | 01_research/peer_benchmark.md |
Internal |
| Scoring rubric + stakeholder salience | 03_analysis/scoring_rubric.md |
Mentor session 1 |
| LLM ESRS gap heatmap | 03_analysis/esrs_gap_heatmap.* |
Internal |
| Aqueduct + NGFS overlays | 01_research/water_stress.md, climate_scenarios.md |
Internal |
| Monte Carlo matrix + sensitivity | 04_matrix/matrix_mc.* |
Mentor session 2 |
| Financial magnitude + Real Options | 03_analysis/financials.* |
Internal |
| Matrix + roadmap | 04_matrix/, roadmap draft |
Internal |
| Report & deck | 05_report/, 06_presentation/ |
Final rehearsal |
- CSRD — Directive (EU) 2022/2464
- ESRS — Commission Delegated Regulation (EU) 2023/2772 (ESRS 1, ESRS 2, topical standards E1–E5, S1–S4, G1)
- EFRAG Implementation Guidance — IG 1 Materiality Assessment, IG 2 Value Chain, IG 3 Datapoints
- SASB Water Utilities & Services (cross‑reference)
- TCFD / TNFD (cross‑reference for environmental topics)
- SFDR PAI (principal adverse impacts — investor materiality lens)
- Spanish Ley 7/2021 (climate law), EU Water Framework Directive, Urban Waste Water Treatment Directive (recast)
- Project library initialised; source materials archived
- Workshop 1 PPT ingested; Consultant's Checklist mapped to deliverables
- Aqualia 2025 baseline —
01_research/aqualia_2025_baseline.md - Peer benchmark (Veolia / Suez / Saur / Facsa / Global Omnium) —
01_research/peer_benchmark.md - Scoring rubric — 1–5 thresholds, cited, Monte Carlo design —
03_analysis/scoring_rubric.md - Stakeholder salience model — Mitchell, Agle & Wood 1997 —
03_analysis/stakeholder_salience.md - ESRS gap heatmap prototype plan — hero-slide pipeline —
03_analysis/esrs_gap_heatmap_plan.md - Three-topic short-list LOCKED —
03_analysis/short_list_lock.md - ESRS gap heatmap prototype RUN — 75 DPs × 48 chunks —
04_matrix/esrs_gap_heatmap.png+.html - Financial magnitude sheet — € triangular ranges, Real Options, €500M green bond close —
03_analysis/financials.md - WRI Aqueduct water-stress overlay plan + script —
01_research/water_stress.md - Monte Carlo matrix with 90% CI ellipses —
04_matrix/matrix_mc.{png,html}+03_analysis/matrix_mc_notes.md - Sensitivity tornado —
04_matrix/matrix_tornado.png+03_analysis/mc_tornado.csv - Robustness check (4 weighting schemes) —
03_analysis/mc_robustness.csv— no ranking flips - React interactive dashboard —
10_dashboard_react/(for QR-code deck link) - 5-minute deck script — slide-by-slide, timings, Q&A prep —
06_presentation/deck_script.md - Executive summary — one-page stand-alone —
05_report/executive_summary.md - 13-page report skeleton — section briefs + exhibits + citations —
05_report/report_skeleton.md - References / bibliography —
05_report/references.md - ESRS heatmap — full corpus run (11 PDFs, 873 chunks, bilingual TF-IDF, adaptive thresholds) — findings unchanged
- Final Readiness punch list — what's left, prioritised —
FINAL_READINESS.md - NGFS scenario analysis applied to revenue base
- Download full 2022/2023/2024 Sustainability Reports; rerun heatmap
- Execute Aqueduct map (download WRI shapefile, run script)
- Strategic roadmap 2027–2030 with ESRS datapoint mapping
- Limitations + assumption log
- Analytical report (10–15 pp. + appendix)
- 5-minute presentation + rehearsal
Every item here is pitch-ready. Read before each rehearsal.
- T1 — Water Resilience & Equitable Access (Impact 3.98, Financial 3.07 — Target Zone) · 26 IROs absorbed
- T2 — Digital & Cyber Infrastructure (Impact 3.08, Financial 2.75 — Target Zone) · 11 IROs · the blind-spot repositioning
- T3 — Green Finance & Integrity (Impact 3.24, Financial 2.42 — borderline / conditionally material) · 24 IROs · upside-dominated case
10,000 MC draws per topic, 90% χ² confidence ellipses rendered in 04_matrix/matrix_mc.png. Topic ranking stable across 4 stakeholder-weighting schemes (mc_robustness.csv).
-
The Colombia outlier. Aqualia's customer satisfaction is 92–98% across European + institutional + industrial segments, but 33% in Colombia. Aqualia folded ESRS S3 (affected communities) into S4 — a methodological shortcut that buries this equity-access issue. Restoring S3 converts a disclosure gap into a concession-renewal risk signal.
-
The Digitalisation blind spot. Aqualia logged 2 IROs for Digitalisation — the lowest of any topic in the 2025 review. Yet peers (Veolia AquaCIS, Suez Aquadvanced, Global Omnium GoAigua) treat it as core, EU Water Resilience Strategy names it Action Area 3 of 5, WEF ranks cyber insecurity top-10, and Aqualia's own operational risks O8/O9 on digital + cyber are HIGH-severity. Our Monte Carlo repositions this topic from lower-middle of the matrix into the Target Zone.
-
The Green-Finance differentiator. Aqualia promotes Financial Management & Green Finance to stand-alone material status — ahead of peers. We amplify with a €500 M EU-Taxonomy-aligned green / sustainability-linked bond programme 2027–2030, structured around the T1 water-resilience CAPEX pipeline. At 25 bp coupon saving, this delivers ~€31 M PV interest savings over the bond life.
"Three material topics — Water Resilience & Equitable Access, Digital & Cyber Infrastructure, Green Finance & Integrity — represent €18 M/yr of net financial materiality Aqualia's current framework under-weights. A €440 M targeted 2027–2030 investment, funded by our proposed €500 M EU-Taxonomy-aligned green bond programme, converts this drag into upside — via cost-of-capital savings, tender differentiation, and reuse-market revenue."
| Claim | File, §, assumption ID |
|---|---|
| 31 of 83 IROs cluster in our T1 | aqualia_2025_baseline.md §3 |
| Peers treat digital as core | peer_benchmark.md §3 Finding 1 |
| Colombia 33% | Corporate context... p.15 → aqualia_2025_baseline.md §1.3 |
| ESRS gap share per topic (70% avg) | esrs_gap_heatmap_notes.md §3 |
| €1.4 B revenue anchor | financials.md A01 |
| €500 M bond → €31 M PV savings | financials.md §3.3 |
| Water-stress exposure 45% today → 79% under BAU-2030 | water_stress.md §2; 01_research/aqueduct_overlay.py |
| Stakeholder weights (salience model) | stakeholder_salience.md §3 |
- Justify selection →
short_list_lock.md§1.2, §2.2, §3.2 and rebuttal §4. - Show your math →
scoring_rubric.md(all thresholds cited) +stakeholder_salience.md+coverage_matrix.csv+financials.mdassumption logs. - Trace the logic →
short_list_lock.md§5 traceability matrix +esrs_gap_heatmap.png+coverage_matrix.csv. - Actionable →
financials.md§3.3 €500M bond ask + §5 Real Options +water_stress.md§6.
Los Gatos de Datos — IE Master in Business Analytics & Data Science.
- @ma731 — Marco Ortiz Togashi