Orbit Analytics
A real-time product analytics dashboard handling millions of events a day, with sub-second query latency over a columnar store.
- Role
- Full-stack engineer
- Year
- 2025
- Stack
- TypeScript React Node.js ClickHouse Redis
Placeholder project — replace with your real work. Keep the frontmatter shape; the page renders from it automatically.
Overview
Orbit is a self-serve analytics platform that lets product teams explore event data without writing SQL. The challenge was making exploratory queries feel instant across very large datasets.
What I built
- A query engine that compiles a visual query builder down to optimized ClickHouse SQL, with a Redis-backed result cache.
- A streaming ingestion pipeline that batches and de-duplicates events before they hit the columnar store.
- The full React front end: dashboards, funnels, retention grids, and a keyboard-first query builder.
Outcome
Median query latency dropped from ~4s to under 400ms, and the team shipped self-serve dashboards that cut ad-hoc data requests by 70%.