Define KPIs and metrics for business dashboards with calculation formulas.
You are a business intelligence analyst. Define metrics for a dashboard. ## Business Context - **Industry**: [your industry] - **Department**: [sales / marketing / product / finance / etc.] - **Dashboard Purpose**: [what decisions will this inform?] ## Current Data Available [List tables/sources you have access to] ## Metrics Requirements ### For Each Metric - Name - Definition (plain English) - Formula/Calculation - Data source - Dimensions (how to slice) - Benchmark/Target - Frequency of update ## Metric Categories ### Leading Indicators Predictive metrics ### Lagging Indicators Outcome metrics ### Efficiency Metrics Ratio-based measures ## Output Format ``` DASHBOARD: [Name] Purpose: [Description] --- METRIC 1: [Name] Definition: [What it measures] Formula: [calculation] Data Source: [table/field] Dimensions: [how to filter/group] Target: [benchmark] Update: [frequency] Visualization: [recommended chart type] --- METRIC 2: [Name] ... --- METRIC RELATIONSHIPS: [How metrics relate to each other] DATA REQUIREMENTS: [Tables and fields needed] REFRESH SCHEDULE: [When data should update] ```
This data prompt is designed to help you get better results from AI assistants like ChatGPT, Claude, and Gemini. Here's how to make the most of it:
💡 Pro tip: Save this prompt to your collection to use it again later. Well-crafted prompts can save hours of back-and-forth with AI.
Adjust the prompt to match your specific industry, audience, or use case. Adding relevant context improves output quality.
Specify your desired output length (e.g., "in 200 words" or "in 3 bullet points") to get more targeted responses.
Add tone instructions like "professional," "casual," or "technical" to match your brand voice.
Include an example of the output format you want to help the AI understand your expectations.
This prompt has been tested and optimized for all major AI models. For best results with coding-related prompts, consider using an AI-powered IDE like Cursor or Windsurf.
Learn more about using prompts effectively with our comprehensive guides:
0 people found this prompt helpful
Based on 234 reviews
Be the first to share your experience with this prompt!
Models
This prompt was reviewed and verified to work with current AI models.
Tested with ChatGPT, Claude & Gemini. Reviewed by 1600+ users.
AI prompts work best when you customize them for your specific situation. Follow these steps to get the most out of Dashboard Metrics Definer.