KPI Dashboard Designer

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."

More Useful ChatGPT Prompts