Analytics dashboard
Custom KPIs, real-time, with exports
statuscoming soon
stackTremor, Postgres materialized views, TanStack Table
updated2026
TremorPostgresMaterialized views
01 / / the problem
Every B2B company eventually needs internal dashboards. Tableau and Looker are expensive overkill. Build-me-a-custom-dashboard pays well and recurs.
02 / / what i built
→KPI cards with comparison vs. previous period
→Time-series charts with date range selection
→Bar and pie chart breakdowns
→Filterable, sortable, paginated data table
→CSV and PDF export
→Real-time updates for one metric
→Materialized views for query performance
03 / / how i built it
Tremor
Faster than building Recharts components from scratch
Postgres materialized views
Pre-computed aggregations for sub-100ms loads
TanStack Table
Headless table with built-in sort and filter
04 / / live demo
→ open live demo at https://analytics.drodriguez.site
Loom walkthrough — 90 seconds
Demo credentials shown on the demo's landing page.
05 / / production extensions
Things deliberately out of scope for the demo, but I'd add for production:
→User-configurable widget layouts
→Drill-down navigation
→Email scheduled reports
→Custom SQL query builder