Redesign an executive dashboard for C-suite
Company: Meta
Role: Data Scientist
Category: Analytics & Experimentation
Difficulty: medium
Interview Round: Onsite
You are handed a single slide for the C-suite showing a spaghetti chart of regional trends for one metric. Critique and redesign the slide into an executive dashboard that is interpretable and action-guiding. Specify: (a) the exact layout (top-line tiles, trend panels, cohort tables), (b) the 6–8 metrics you would include for this 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), (c) how you will make regions comparable (index to 100 at launch, per-company normalization, small multiples with consistent y-axes, rank tables), (d) annotation rules for highlights and thresholds, and (e) visualization guardrails (no dual axes, consistent scales, uncertainty bands for sparse countries). Explain how your design helps spot small-country trends that the spaghetti chart obscures.
Quick Answer: This question evaluates skills in dashboard design, data visualization, metric selection, and executive-level analytical communication for product and growth measurement.