Sales Analytics Dashboard
Daily sales rollups over 10M+ rows of raw orders.
- Role
- Full-stack developer
- Year
- 2024
- Built with
- Next.jsPostgreSQLRechartsNode.js
A dashboard that consolidates orders from several channels into daily, weekly, and monthly rollups.
Materialized views on PostgreSQL precompute the aggregates overnight, taking a screen that once took 12 seconds to load down to under one.
It supports CSV export and scheduled email reports.