/00/Case study / 2024 · Community solar co-op

Sunwarden
Energy

Kilowatt-hours, visualised as something you can tend.

// role
Product strategy
Data viz
Full-stack engineering
Realtime infra
// stack
SvelteKitConvexD3Grafana
// duration
7 months
// team
3 GreenCoders · 1 embedded data scientist
Sunwarden Home
Your solar, this week
kWh
41.2
offset
18.6kg
credit
$14.10
/01/Summary

Sunwarden members own slices of community solar installations. We built the member dashboard where kilowatt-hours feel less like accounting, more like a garden you're tending.

94%
renewal
4m 12s
avg session
2.4M
kWh tracked
41%
DAU/MAU
/02/
Challenge

The old statements PDF was generated quarterly and showed only dollar amounts. Members felt no connection to the installations they co-owned. Membership renewal was trending down.

/03/
Approach

We designed a calendar-first dashboard where each day is a leaf, coloured by production. A credit ledger shows the money trail with no finance-app anxiety. Neighbour comparison is anonymous and opt-in. Live data via Convex reactive queries.

/04/
Outcome

Renewal rate climbed from 71% to 94% in the first year. Average session time 4m 12s (previously: members rarely logged in). Two co-ops copied the pattern under an open-source license.

/05/ Across devices

Same system. Every surface.

Year Calendar
2024 · 11,412 kWh
best day
62 kWh
streak
28d
Credit Ledger
April · $128 earned
balance
$412
redeemed
$86
/06/Process

Four seasons, in order.

/01/ Seed

Interviews with 18 members. Discovered most wanted a garden metaphor, not an investment metaphor.

/02/ Sprout

Three visual metaphors tested: garden, weather, ledger. Garden won. Weather became the secondary.

/03/ Canopy

Convex reactive queries pipe live solar data at under 1s latency. D3 custom renderer for the year calendar.

/04/ Harvest

Rolled out to three co-ops. Open-sourced the design kit under a permissive license.

/07/Details

Moments that earn a pause.

Neighbourhood
You rank #14 of 212
above avg
+18%
rank
14
Sunwarden Home
Your solar, this week
kWh
41.2
offset
18.6kg
/08/Full composition

One system, three frames.

greencode://work/year-calendar
Year Calendar
2024 · 11,412 kWh
best day
62 kWh
streak
28d
Year Calendar
2024 · 11,412 kWh
best day
62 kWh
streak
28d
Year Calendar
2024 · 11,412 kWh
best day
62 kWh
streak
28d
/09/ In their words
"Members tell me they now check their dashboard before checking the weather. That sentence means more than any KPI."
Marcus Oshiro · Operations Lead, Sunwarden