This was a beast of a question and I kind of underestimated it at first.
Start by clarifying the executive audience and the decisions the dashboard should drive, then propose a layout that separates global summary from regional detail. Select 6-8 metrics that cover acquisition, engagement, retention, and monetization for an early-stage B2B chat app, and explain how you'd normalize regions for fair comparison. Finally, describe annotation and visualization guardrails, and show how small multiples or normalized views surface small-country trends.
Pro tip: Executives care about 'so what' — always tie each metric to a business decision or action, and use a consistent color scale across regions to avoid misleading comparisons.
Ask who the executives are and what decisions they need to make (e.g., where to invest, which regions need attention). This shapes metric selection and layout.
Propose a top-down structure: global KPIs at the top, then a regional comparison view (e.g., small multiples or a heatmap), and finally drill-down details. Ensure the most important metrics are visible without scrolling.
Choose metrics that cover the funnel: acquisition (new sign-ups), activation (first message sent), engagement (DAU/MAU, messages per user), retention (weekly retention), monetization (paid conversion, ARPU), and growth (net new active teams).
Normalize metrics by population, user base, or time zone; use per-capita or per-user rates; and consider indexing to a baseline (e.g., global average) to highlight relative performance.
Annotate only significant events (product launches, outages) and use clear, consistent labels. Avoid clutter: limit colors, use accessible palettes, and ensure axes start at zero where appropriate.
AI-generated suggestions, not part of the candidate's original notes. May be inaccurate — verify before relying on them.