×
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
Solar, wind & energy communities
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 · Build the Portfolio
Build the portfolio
Click a project and watch it feed the data cube.
The Cleanwatts portfolio
Data Cube
Portfolio
CRM
Financials
Solar community
Wind park
Rooftop PV
One project, one record, all three views in sync
Pooled IRR - live preview
6.0%
Figures illustrative
0 / 3 built
Portfolio and CRM data unified in one cube
Behind the cube: portfolio and CRM data feeding financials and reporting. All figures fictional.
Build the portfolio 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