Interactive Diagram – Template
Title: Problem Tree — Root causes of poor ESG data quality
Subtitle: What drives errors and how to tackle them quickly
Trunk (problem): Inconsistent, late, or non‑traceable ESG data.
Effects (branches at the top):
- Delayed disclosures; rework and overtime.
- Conflicting KPIs across units/sites.
- Audit findings; stakeholder mistrust.
Root causes (bottom hotspots):
- Undefined ownership (no RACI)
- Signal: Tasks stall; no approver.
- Quick fix: Publish RACI per metric.
- Owner: Sustainability lead.
- Evidence: RACI posted; sign‑off recorded.
- Inconsistent definitions (no dictionary)
- Signal: Units/periods differ by site.
- Quick fix: Create a minimal dictionary (name, definition, unit, owner, source, frequency).
- Owner: Data steward.
- Evidence: Versioned dictionary online.
- Optional link (web): Eurostat – SDG Data Browser (example of clearly defined sustainability indicators):https://ec.europa.eu/eurostat/web/sdi
Root causes (bottom hotspots – continued):
- Manual entry & copy‑paste
- Signal: Typos; broken formulas.
- Quick fix: Validated forms and CSV imports.
- Owner: Process owner.
- Evidence: Form with dropdowns/range checks.
- No validation & checks
- Signal: Out‑of‑range values pass.
- Quick fix: Add range checks and monthly reconciliations (e.g., meters vs invoices).
- Owner: Metric owner.
- Evidence: Reconciliation log stored.
Root causes (bottom hotspots – continued):
- Siloed storage & naming
- Signal: “Latest” file unclear.
- Quick fix: Standard folders and naming (YYYY‑MM_metric_vX).
- Owner: Records admin.
- Evidence: Folder template live; versions.
- Ad‑hoc cadence
- Signal: Late/missed submissions.
- Quick fix: Publish a collection calendar with SLAs and escalation.
- Owner: PM or team lead.
- Evidence: Calendar shared; reminders sent.