Define KPIs and metrics for business dashboards with calculation formulas.
Ask questions or share concrete improvements.
No comments yet.
Sign in to join the discussion.
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.
Compatibility tags come from the prompt author. Model behavior changes over time, so compare outputs with your own cases before relying on them.
Learn more about using prompts effectively with our comprehensive guides:
Models