Analytics Dashboard Specifications
Comprehensive specifications for all dashboard metrics, visualizations, and data sources for Nuqta's analytics platform.
Executive Overview
High-level KPIs and health metrics for leadership
Available Filters:Date rangeUser segmentRegion/Area
Recommended Visualizations
KPI cards with trend indicators
Daily/Weekly/Monthly trend line charts
GMV vs Revenue waterfall chart
Points economy balance (earned vs redeemed)
Dashboard Implementation Guide
Data Architecture
- • PostgreSQL for transactional data
- • ClickHouse for analytics queries
- • Redis for real-time counters
- • ETL pipeline: Airbyte → dbt
- • Data refresh: 15-min intervals
Technical Stack
- • Visualization: Metabase / Looker
- • Alerting: PagerDuty integration
- • Exports: CSV, PDF, API
- • Access: Role-based permissions
- • Mobile: Responsive dashboards
Reporting Cadence
- • Daily: Key KPIs email
- • Weekly: Exec summary deck
- • Monthly: Deep-dive analysis
- • Quarterly: Board presentation
- • Ad-hoc: Custom queries
Sample Executive Dashboard View
Active Users
47,832
+12.5%
Daily Transactions
8,943
+8.2%
Points Issued
2.4M
+15.1%
Churn Rate
4.2%
-0.8%
User Growth Trend
JanJunDec
Transaction Categories
F&B
35%
Grocery
25%
Retail
20%
Entertainment
12%
Other
8%