Design Analytics Dashboard — Salesforce — Intervues

Home Coursework Blog

← Back to companies
[ OK ] Loaded  — 
[ INFO ] 
$ cd 
$ ls -lt 
01
02
03
04
05
$ ls -lt 
01
02
03
04
05
user@intervues:~/$ 

← Salesforce
Design Analytics Dashboard[ OK ] 283 — full content available
[ INFO ] category: System Design  difficulty: hard  freq: high  first seen: 2026-01-13
[HARD][SYSTEM DESIGN][HIGH]data_engineeringwebMetricsmachine_learningSystem DesignReal-timebackendTime-series
$ cat problem.md
Design an analytics dashboard system (like ChatGPT's usage dashboard) that displays various metrics.
Requirements:
Display DAU (Daily Active Users), MAU
Track Latency metrics (P50, P95, P99)
Real-time updates for certain metrics
Historical data visualization
Support different time ranges (hourly, daily, weekly)
Key Components:
Data Collection Pipeline (events, logs)
Time-series Database (InfluxDB, TimescaleDB)
Aggregation Service (batch + streaming)
Dashboard API
Real-time streaming (WebSocket)
Caching Layer
Discussion Points:
Which metrics to prioritize and why
Real-time vs batch aggregation trade-offs
Data retention and rollup policies
Dashboard caching strategies
Pre-aggregation vs on-demand computation
user@intervues:~/salesforce$ 