SprintLens Dashboard
Built collaborative dashboards with optimistic UI, server actions, and real-time presence powered by WebSockets.
Overview
SprintLens equips SaaS founders with a telemetry cockpit that surfaces the truth about acquisition, activation, and retention. I partnered with the founding team to translate analyst pain into a living product.
Problem
- Growth, product, and finance teams relied on stale spreadsheets and duelling metrics.
- Dashboard performance tanked once datasets crossed a few million events.
- Enterprise prospects needed rock-solid access control and auditability from day one.
Solution
- Designed story-centric dashboards with saved views, annotations, and collaborative filters.
- Implemented Postgres segmentation tables with incremental refresh to keep queries sub-second.
- Wrapped the app in policy-driven tRPC procedures enforcing RLS and capturing every change.
Results
190% faster insights
Median dashboard query dropped from 4.2s to 1.4s after segment clustering.
SOC2-ready foundation
Role policies, audit logs, and encryption satisfied security reviewers pre-beta.
3 launch customers
Secured paid pilots within two weeks thanks to demo storytelling + reliability.
Key Decisions
- Next.js App Router, React Server Components, tRPC, and TanStack Query.
- PostgreSQL with Prisma, row-level security, and scheduled materialisation.
- Tailwind CSS + Radix UI for accessible interface primitives.
Timeline
Research
Facilitated metric-mapping workshops across marketing, product, and finance.
MVP Build
Delivered dashboards, segmentation engine, and collaboration suite in six weeks.
Scale
Instrumented feature usage, alerts, and board-ready reporting.