×
One data cube
for a whole clean-energy portfolio
Level 1 · The Company
Meet Cleanwatts
Clean-energy project portfolio
Decentralized renewable energy
For communities and businesses
Based in Portugal
Level 2 · The Problem
Fragmented portfolio data
One project, three tools, three different answers.
Portfolio and CRM data apartProfitability per project hard to assess
Manual financial calculationsChanging assumptions tracked by hand
Inconsistent stakeholder reportingNo aligned view for management and shareholders
Level 3 · Run the Scenarios
Run the scenarios
Click an assumption and watch the IRR recalculate.
Project IRR by assumption
Assumptions
Base
Scenario
CAPEX
Grid connection
Generation per year
Changed assumptions are tracked, the IRR recalculates
Project IRR - live
0 / 3 calculated
Every scenario recalculated, nothing copied by hand
Illustrative project and illustrative inputs, not Cleanwatts data. All figures fictional.
Run all three scenarios to unlock the results
Level 4 · The Results
Profitability, visible across the portfolio
The Outcome
+2%
pooled IRR across the portfolio
+3%
CM1 contribution margin
1 cube
portfolio + CRM unified in one cube
The stack
Snowflake
Power BI
Power BI
More case studiesAuxeumNatsanaAll case studies
© Gemma Analytics · Case Study Cleanwatts