Design Executive Dashboards for Actionable Insights

Executive Dashboard Designer is a skill for designing and building dashboards aimed at C-level executives and senior leadership - translating complex business data into clear, strategic visualizations that drive decisions rather than operational drill-downs. It codifies a strategic-focus principle set: lead with business outcomes instead of raw data points, align KPIs directly to company objectives, prioritize forward-looking metrics over historical reporting, allow drill-down without overwhelming the main view, and design for mobile and presentation contexts. Information hierarchy follows the "5-second rule" (key insights visible immediately), progressive disclosure from summary to trends to details, a traffic-light status system, and consistent terminology across metrics.

Use it when building or restructuring a dashboard meant for board decks, C-level review meetings, or strategic planning - where the audience needs an at-a-glance read (revenue, growth, churn, margin) with the option to drill into specifics. It defines concrete KPI sets for two domains: Financial Performance (Monthly Recurring Revenue, Revenue Growth Rate YoY, Revenue per Employee, Pipeline Value & Conversion Rate, Gross Margin %, Operating Expense Ratio, Cash Flow & Burn Rate, ROI by Initiative) and Operational Excellence (Customer Acquisition Cost, Net Revenue Retention, Net Promoter Score, Customer Lifetime Value, Defect Rate & SLA Performance, Time to Market & Cycle Time, Utilization Rates). It is not the right fit for operational or engineering dashboards meant for hands-on daily monitoring - those need more granular, real-time detail than an executive summary view is designed to show.

Input is the underlying business metrics and data marts; output is a layout following a fixed template: hero metrics in the top 20% of the screen (e.g. primary revenue KPI with trend arrow, green/yellow/red status indicators), trend charts in the middle 60% (line chart for revenue trend, gauge for NPS against target, funnel for sales pipeline, heatmap for regional performance), and action items in the bottom 20% (critical alerts like rising churn, positive insights like improved marketing ROI). Chart type is chosen by data type and purpose (trend/time-series to line chart, comparison/categories to bar chart, part-to-whole to donut, performance-vs-target to gauge, correlation to scatter plot, geographic to choropleth map, process/conversion to funnel, distribution to box plot), and status color coding is standardized:

EXEC_COLORS = {
    'success': '#00A86B',    # Green - targets met/exceeded
    'warning': '#FFB000',    # Amber - attention needed
    'critical': '#D2222D',   # Red - immediate action required
    'neutral': '#708090',    # Gray - informational
    'primary': '#1f4e79'     # Navy - brand/emphasis
}

Dashboards refresh critical metrics on a 5-minute interval, support drill-down paths (e.g. revenue by total/product/region/customer, churn by rate/segment/reason/cohort), and can auto-generate insight text - flagging a revenue-growth opportunity above 15% or a forecast-variance alert above 10%.

The skill includes an export path for board presentations, generating slide templates for executive summary, financial performance, and operational highlights decks, each with a defined chart set and commentary style. It also specifies a data-layer pattern: a materialized view aggregating daily revenue, active customers, and average satisfaction score, refreshed on a cron schedule every 4 hours for a near-real-time executive view. Predictive widgets can be layered in - a seasonal-ARIMA revenue forecast with a 90-day horizon and 80% confidence interval, and a customer-health-score-based churn prediction with a 0.7 alert threshold.

Product, data, and BI teams building or refreshing dashboards for boards, C-suite, and senior leadership review, where the deliverable must pass a 5-second-test for clarity, load in under 3 seconds, work on mobile, and meet accessibility requirements like color-blind-friendly palettes and screen-reader support.