Redesign an executive dashboard for C-suite

Quick Overview

This question evaluates skills in dashboard design, data visualization, metric selection, and executive-level analytical communication for product and growth measurement.

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.

|Home/Analytics & Experimentation/Meta
Meta logo
Meta
Oct 13, 2025, 9:49 PM
mediumData ScientistOnsiteAnalytics & Experimentation
2
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:

  1. Exact layout: what appears where (e.g., top‑line tiles, trend panels, cohort tables).
  2. 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).
  3. How to make regions comparable (e.g., index to 100 at regional launch, per‑company normalization, small multiples with consistent y‑axes, rank tables).
  4. Annotation rules for highlights and thresholds.
  5. 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.

Loading comments...