Kpi Dashboard Design

What it does

This skill designs interactive KPI dashboards visualizing key metrics from SecondSky data. It focuses on clear communication of performance through well-structured layouts, appropriate chart selection, and consistent visual design principles. The goal is to enable users to track progress towards business goals with actionable insights derived from the presented data.

When to use it

• To create a dashboard summarizing key revenue metrics like MRR, ARR, and Revenue Growth.
• When needing to visualize user acquisition performance using metrics such as CAC, New Users, and Conversion Rate.
• For tracking retention metrics including Churn Rate, NPS, and DAU/MAU.
• To design a dashboard displaying efficiency KPIs like LTV:CAC and Burn Rate.
• When wanting to present quality-related data, such as Error Rate and Response Time.

Key capabilities

• KPI Selection Framework: Guides the selection of relevant, measurable, and actionable KPIs.
• Dashboard Layout Design: Creates structured dashboards with sections like Executive Summary, Trend Analysis, and Detailed Views.
• Visual Design Principles: Utilizes traffic light colors (green, amber, red) and visual hierarchy to highlight key information.
• Chart Selection Guidance: Provides recommendations for appropriate chart types based on data type (e.g., line charts for trends, bar charts for comparisons).
• Interactivity Features: Supports drill-down views, date range selection, filtering, CSV/PDF export and scheduled email reports.

Example prompts

• "Design a KPI dashboard focusing on revenue growth and user acquisition."
• "Create a retention dashboard with a funnel chart visualizing the customer journey."
• "Show me an example of a dashboard layout for tracking efficiency metrics like LTV:CAC."

Tips & gotchas

• Limit dashboards to 5-7 KPIs to avoid information overload.
• Ensure data is updated frequently (real-time or hourly) and reviewed quarterly for relevance.
• Use consistent color coding throughout the dashboard for clarity.