Nimbus Analytics
(SaaS Dashboard)Project goal:
Product teams at 300+ companies were drowning in CSV exports. They needed a real-time analytics dashboard that answers everyday questions in under a second, with no data team in the loop.
Tech decisions:
Next.js for SSR and streaming, tRPC for type-safe APIs end to end, and a Redis cache in front of Postgres materialized views to cut response time. Hosted on AWS with per-tenant rate limits.
Results:
- −45% load time
- 12k weekly users
- 99.95% uptime
- Next.js
- tRPC
- PostgreSQL
- Redis
- AWS
Nimbus Analytics
saas dashboard
export const metricsRouter = router({
overview: protectedProcedure
.input(z.object({ range: z.enum(["7d", "30d", "90d"]) }))
.query(async ({ ctx, input }) => {
const key = "overview:" + ctx.org.id + ":" + input.range;
const cached = await redis.get(key);
if (cached) return JSON.parse(cached);
const data = await db.metrics.aggregate(ctx.org.id, input.range);
await redis.set(key, JSON.stringify(data), "EX", 60);
return data;
}),
});