Commerce Analytics Dashboard
An internal analytics dashboard for e-commerce teams, surfacing sales trends, inventory health, and customer cohort data.
Commerce Analytics Dashboard is an internal tool built for an e-commerce operations team. It replaces a collection of spreadsheets and ad-hoc SQL queries with a live, role-aware dashboard that non-technical stakeholders can use without engineering support.
Features
- Sales overview — daily, weekly, and monthly revenue charts with period-over-period comparisons
- Inventory health — stock level alerts, reorder suggestions, and supplier lead-time tracking
- Customer cohorts — retention curves, average order value by acquisition channel, and churn risk scores
- Configurable reports — users can define custom date ranges, filter by SKU/category, and export to CSV
- Access control — view-only vs edit roles; sensitive margin data restricted to finance team members
Stack
Built with Next.js (App Router) and Tailwind CSS. Data is fetched server-side via RSC and cached with ISR; client-side interactions use React Server Actions. The backend reads from a read replica of the production PostgreSQL database to avoid impacting live traffic. Authentication is handled via NextAuth with SSO through the company’s existing identity provider.
Charts use a lightweight custom SVG charting layer to avoid heavy chart library dependencies.