Back to projects
Case Study
Realtime SaaS Analytics Dashboard
Replaced a hand-rolled analytics pipeline with a streaming architecture. Query latency p95 dropped 40x. Shipped end-to-end from schema design to dashboard UI.
Overview
About this project.
A streaming analytics core for a B2B SaaS platform — built to replace a slow aggregation layer and unlock realtime dashboards for end customers.
Highlights
Feature set
Streaming pipeline
- Kafka + ClickHouse ingest, 80M events/day
- Sub-300ms p95 dashboard queries
- Backfill 18mo history, zero downtime
Realtime UI
- React + TypeScript dashboard SPA
- Streaming chart updates via SSE
- Saved views + shareable URLs
Multi-tenant safety
- Row-level tenant isolation at the query layer
- Per-tenant rate limits + quota enforcement
- Audit log for every dashboard export
Handover
- Runbook + on-call playbook documented
- Team trained on operating model
Related
You might also like.
In progress
Open Source: Postgres Migration Diff Tool
Python CLI that diffs PostgreSQL schemas across environments and outputs idempotent migration SQL. MIT-licensed.
View project
Live
Cross-Platform Field Service App
Offline-first React Native app for 400+ field engineers. Job tracking, parts inventory, and a sync engine designed for spotty rural…
View project
More projects