Back to all work
Analytics
Signal Analytics
A self-serve analytics product rebuilt around pre-aggregation instead of query-time computation.
- Client
- Media startup, Karachi
- Role
- Founding engineer
- Year
- 2022
- Category
- Analytics
The engagement
Customers were waiting up to forty seconds for a chart, and every new filter made it worse because each one added another scan over raw events.
I designed a cube-style pre-aggregation layer refreshed incrementally, with a query planner that falls back to raw scans only for genuinely novel slices.
The product went from a demo people had to be warned about to the feature the sales team leads with.
Tech stack
Python
ClickHouse
FastAPI
React
Celery