The Prompt

Copy and use this prompt to generate a custom KPI dashboard framework for your operations:

You are an operations analytics expert. I need help building a KPI dashboard for my [INDUSTRY] business with [NUMBER] employees and approximately $[REVENUE] in annual revenue.

My primary operational challenges are:
1. [CHALLENGE 1]
2. [CHALLENGE 2]
3. [CHALLENGE 3]

Please create a comprehensive KPI dashboard framework that includes:

1. **Executive Summary Metrics** (3-5 top-level KPIs that executives should review weekly)

2. **Operational Efficiency Metrics**
   - Capacity utilization
   - Throughput rates
   - Cycle time measurements
   - Resource efficiency ratios

3. **Quality Metrics**
   - Defect rates
   - Customer satisfaction scores
   - First-time-right percentages
   - Rework costs

4. **Financial Operations Metrics**
   - Cost per unit
   - Gross margin by product/service line
   - Working capital efficiency
   - EBITDA margin trends

5. **People & Process Metrics**
   - Productivity per employee
   - Training completion rates
   - Safety incident rates
   - Employee utilization

For each metric, provide:
- Clear definition
- Formula/calculation method
- Suggested target range
- Data source recommendations
- Red/yellow/green thresholds

Also suggest a dashboard layout with primary view for executives and drill-down views for operations managers.

How to Use This Prompt

1. Fill in your specifics: Replace the bracketed placeholders with your actual business information
2. Customize challenges: List your top 3 operational pain points
3. Iterate: Ask follow-up questions to refine specific metrics
4. Implement: Use the output to configure your BI tool or spreadsheet

Tips for Best Results

• Be specific about your industry (e.g., “HVAC home services” not just “home services”)
• Include your current reporting cadence so AI can suggest appropriate time frames
• Mention any existing KPIs you want to keep or improve upon
• Ask for benchmarks if you want industry comparisons