Redesign an executive dashboard for C-suite
Overview
This question evaluates skills in dashboard design, data visualization, metric selection, and executive-level analytical communication for product and growth measurement.
Meta
Oct 13, 2025, 9:49 PM
Data Scientist
Onsite
Analytics & Experimentation
0
0
Redesign a Spaghetti Chart into an Executive Dashboard
Context
You are handed a single slide for the C‑suite that shows a spaghetti chart of regional trends for one metric in an early‑stage B2B chat app. Your task is to critique it and redesign the slide into an interpretable, action‑guiding executive dashboard.
Task
Specify and justify:
- Exact layout: what appears where (e.g., top‑line tiles, trend panels, cohort tables).
- The 6–8 metrics you include for an early‑stage B2B chat app (e.g., Monthly Subscribed Companies with MoM%, Monthly Subscription Revenue with MoM%, Gross and Net Revenue Retention, First‑Response‑Time P50/P90, Full‑Resolution Rate and Median Time‑to‑Resolve, CSAT/NPS).
- How to make regions comparable (e.g., index to 100 at regional launch, per‑company normalization, small multiples with consistent y‑axes, rank tables).
- Annotation rules for highlights and thresholds.
- Visualization guardrails (e.g., no dual axes, consistent scales, uncertainty bands for sparse countries).
Explain how your design helps spot small‑country trends that the spaghetti chart obscures.
Solution
Login required
Show