Dashboard and Metric Design prompts for Data Analyst
Ready-to-use AI prompts for dashboard and metric design — written for Data Analyst and easy to paste into ChatGPT, Claude or Gemini.
When you need dashboard and metric design done, these data analyst prompts give you a fill-in-the-blanks starting point covering dashboard, metrics, kpi. Fill in fields like audience, decisions, data available and paste the result into ChatGPT, Claude, or Gemini.
Design a dashboard around a decision
You are an analytics lead designing a dashboard for [audience]. Decisions they make: [decisions]. Data available: [data available]. Tool: [tool].
Start from the decisions, not the data. For each decision, specify the one metric that informs it, its precise definition, the comparison that makes it interpretable (target, prior period, segment), the chart type and why, and the threshold at which the viewer should act.
Then lay out the dashboard: what goes above the fold, what belongs in a drill-down, and what should not be on it at all. Name the metrics people will ask for that you are deliberately excluding and why. Include the refresh cadence and who owns each definition.
Define a metric precisely
Act as an analytics engineer resolving a metric definition dispute. Metric: [metric name]. How different teams currently define it: [current definitions]. Underlying data: [underlying data]. What the metric is used to decide: [use].
Write a single canonical definition covering: the numerator and denominator in words, the entity and time grain, inclusions and exclusions (test accounts, internal users, refunds, deleted records), how late-arriving data is handled, and the timezone.
Then show the SQL that implements it, list the edge cases where reasonable people would disagree with a recommendation for each, and quantify roughly how much the number changes between the competing definitions so people understand what is at stake.
Critique an existing dashboard
You are a data visualization reviewer. Here is a description of my dashboard:
<dashboard>
[dashboard]
</dashboard>
Audience: [audience]. What they should do with it: [intended use]. Complaint: [complaint].
Assess: does each chart support a decision or is it there because the data existed? Is the chart type right for the comparison being made? Can a viewer tell in five seconds whether things are good or bad? Are there missing baselines, misleading axes, or metrics that move together and are redundant?
Give a revised layout, the charts to cut, and the one addition most likely to fix the stated complaint. Explain each change in one line.
How to use this prompt
Fill in the blanks. Type your details into each highlighted field of this dashboard and metric design prompt — fields like audience, decisions, data available — and it rewrites itself live.
Copy the prompt. Press Copy prompt to put the finished dashboard and metric design prompt on your clipboard.
Paste into your AI model. Paste it into ChatGPT, Claude, Gemini, or any chat LLM to get your dashboard and metric design result.
Review and iterate. Read the response as a data analyst would, then adjust fields like audience, decisions, data available and re-run to sharpen it.
Fill-in fields explained
audience
e.g. the head of support
decisions
what they decide and how often
data available
tables and fields
tool
Your tool.
metric name
Your metric name.
current definitions
describe the variations
underlying data
tables, events, grain
use
Your use.
dashboard
list each chart — metric, chart type, time range, filters, position
intended use
Your intended use.
complaint
e.g. nobody opens it, they still ask me for numbers
Frequently asked
Which AI models does the Dashboard and Metric Design prompt work with?
The Dashboard and Metric Design prompts for Data Analyst are plain-text and model-agnostic — paste them into ChatGPT (GPT-4o), Claude, Gemini, Llama, or any other chat model.
How do I customize the Dashboard and Metric Design prompt for my own use?
Fill in the 11 labelled fields (audience, decisions, data available, …) before copying, or edit the [bracketed] text after you paste.
Are the Dashboard and Metric Design prompts for Data Analyst free to use?
Yes. Every Dashboard and Metric Design prompt here is free to copy and reuse, including for commercial and client work, with no sign-up.