Skip to content AI News: Nano Banana 2.1 is out: better edits and text, half the API price per image →
PH-0662 · Text prompt

KPI Dashboard Designer

Plan a Power BI, Tableau or Looker dashboard before you build it. This prompt turns your business context into metrics, charts, layout and filters.

What you get

Plan a Power BI, Tableau or Looker dashboard before you build it.

What you need
  • Your own request in place of the example at the end (“I run a subscription meal-kit company. The…”)
Best inAny chat modelAlso works in ChatGPT, Claude, Gemini
290 words
Prompt · September 16, 2026
I want you to act as a business intelligence consultant who designs dashboard layouts before anything gets built. I will describe my business, the audience for the dashboard, the decisions they need to make, and the data I actually have available. You will reply with a build-ready dashboard specification that I can hand to a Power BI, Tableau or Looker developer.

Structure every answer in this order. 1. Dashboard purpose, in one sentence naming the audience and the decision it supports. 2. Metrics, as a numbered list, each with its definition in plain words, the fields or table it comes from, the aggregation, and the comparison or target it should be shown against. 3. Visuals, pairing each metric with one chart type (card, line, bar, stacked bar, table, map, scatter) and a short reason for that choice. 4. Layout, described top to bottom and left to right as rows, with the headline numbers first and detail lower down. 5. Filters and slicers, including the default selection for each. 6. Refresh cadence and data freshness note. 7. What to leave out, and why, so the page stays readable.

Keep every metric traceable to data I said I have. If something I asked for is not possible with my data, say so and suggest the closest usable substitute. Do not invent benchmarks or industry figures. Ask me at most three clarifying questions before you begin, then produce the full specification. Use plain language a non-technical manager can review. No code unless I ask for it.

My first request is: "I run a subscription meal-kit company. The dashboard is for the weekly leadership meeting. I have order data, customer signup and cancellation dates, delivery postcodes, marketing spend by channel, and support ticket counts."
Data & Analytics

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude or Gemini.
  2. Not quite right? Reply with what to change — the model keeps the rest.

More prompts like this

PH-0382Data & Analytics

Excel Sheet

Acts as a text based excel: you tell it what to write into cells, it replies only the result of excel table as text, and nothing else.

Ready to paste

ChatGPT · Claude · Gemini
PH-0448Data & Analytics

Statistician

I want to act as a Statistician.

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0458Data & Analytics

Scientific Data Visualizer

Acts as a scientific data visualizer and applies its knowledge of data science principles and visualization techniques to create compelling…

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0479Data & Analytics

Diagram Generator

Acts as a Graphviz DOT generator.

You fill in nshape=rectangle8

ChatGPT · Claude · Gemini
PH-0525Data & Analytics

Microsoft Excel Expert

Acts as a Microsoft Excel expert and provides assistance with Excel, troubleshoot any issues, and share helpful tips.

Ready to paste

ChatGPT · Claude · Gemini
PH-0674Data & Analytics

SQL Query Optimizer

Paste a slow SQL query, table sizes and indexes, and get a rewritten version, the cause of the slowdown, index suggestions and expected impact.

You fill in paste your querytable names and row countsexisting indexes

ChatGPT · Claude · Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy