How do I use the "Create Executive Dashboard Layout" prompt?

Copy the prompt template, fill in the variables (COMPANY_TYPE, TARGET_AUDIENCE, INDUSTRY, COMPANY_SIZE, BUSINESS_GOALS, STAKEHOLDERS), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this data prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Focus on 5-7 key metrics maximum - executives need quick insights, not data overload Use consistent color coding across all visualizations (red for concerning metrics, green for positive) Include benchmark comparisons or industry standards where possible to provide context Design for mobile viewing since executives often check dashboards on phones/tablets Set up automated alerts for critical threshold breaches to enable proactive decision-making

data intermediate

Create Executive Dashboard Layout

Design professional executive dashboards with strategic KPIs and visual layouts. Perfect for business intelligence and C-suite reporting needs.

Works with: chatgptclaudegemini

Prompt Template

You are an expert business intelligence designer specializing in executive-level dashboards. Create a comprehensive dashboard layout specification for [COMPANY_TYPE] targeting [TARGET_AUDIENCE] executives. Company Context: - Industry: [INDUSTRY] - Company size: [COMPANY_SIZE] - Primary business goals: [BUSINESS_GOALS] - Key stakeholders: [STAKEHOLDERS] Dashboard Requirements: 1. Design a clean, executive-friendly layout with 6-8 key sections 2. Prioritize the most critical KPIs for this industry and role level 3. Include appropriate chart types and visualization recommendations 4. Specify data refresh frequencies and time periods 5. Consider mobile responsiveness for executive access 6. Include drill-down capabilities where relevant For each dashboard section, provide: - Section title and purpose - 2-3 specific KPIs or metrics to display - Recommended visualization type (chart, gauge, table, etc.) - Data sources needed - Update frequency - Why this metric matters to executives Also include: - Overall dashboard color scheme and branding considerations - Navigation structure - Alert/notification recommendations for critical thresholds - Export and sharing capabilities needed - Performance benchmarking suggestions Format the output as a structured specification that could be handed to a development team or dashboard tool for implementation.

Variables to Customize

[COMPANY_TYPE]

The type of organization needing the dashboard

Example: SaaS technology company

[TARGET_AUDIENCE]

The specific executive level or department

Example: C-suite executives and VPs

[INDUSTRY]

The specific industry or sector

Example: B2B software and cloud services

[COMPANY_SIZE]

Organization size and scale

Example: Mid-market company, 200-500 employees, $50M ARR

[BUSINESS_GOALS]

Primary strategic objectives

Example: Growth expansion, customer retention, operational efficiency

[STAKEHOLDERS]

Key decision makers who will use the dashboard

Example: CEO, CFO, COO, VP Sales, VP Marketing

Example Output

# Executive Dashboard Specification: SaaS Technology Company ## Dashboard Overview **Target Users:** C-suite executives and VPs **Update Frequency:** Real-time with daily snapshots **Access:** Web and mobile responsive ## Layout Sections: ### 1. Financial Performance (Top Priority) - **Metrics:** Monthly Recurring Revenue (MRR), Annual Run Rate, Gross Margin - **Visualization:** Revenue trend line, MRR growth gauge, margin percentage display - **Why Critical:** Direct impact on company valuation and growth trajectory - **Alerts:** MRR growth <5% monthly, margin drop >2% ### 2. Customer Health - **Metrics:** Net Revenue Retention, Churn Rate, Customer Acquisition Cost - **Visualization:** Cohort retention heatmap, churn trend line, CAC vs LTV ratio - **Data Source:** CRM, billing system - **Update:** Daily ### 3. Sales Pipeline - **Metrics:** Pipeline value, conversion rates, sales velocity - **Visualization:** Funnel chart, win rate trends, deal progression - **Drill-down:** By rep, region, deal size ### 4. Operational Efficiency - **Metrics:** Employee productivity, system uptime, support ticket resolution - **Visualization:** Operational scorecard, SLA performance gauges **Design:** Clean white background, company brand colors, minimal clutter **Navigation:** Tab-based sections with favorites pinning **Export:** PDF reports, scheduled email summaries

Pro Tips for Best Results

Focus on 5-7 key metrics maximum - executives need quick insights, not data overload
Use consistent color coding across all visualizations (red for concerning metrics, green for positive)
Include benchmark comparisons or industry standards where possible to provide context
Design for mobile viewing since executives often check dashboards on phones/tablets
Set up automated alerts for critical threshold breaches to enable proactive decision-making