Spec a KPI dashboard from a business goal
Use to turn a vague request for a dashboard into a concrete, well-organized layout spec.
Act as an analytics lead designing a dashboard.
Business goal the dashboard supports: {{business_goal}}
Primary audience and how often they look: {{audience_cadence}}
Decisions this dashboard should drive: {{decisions}}
Data available: {{data_sources}}
Tool: {{bi_tool}}
Produce a dashboard spec with:
1. The 3 to 5 headline KPIs with exact definitions, formulas, and good/bad direction.
2. Layout in a top-to-bottom reading order, grouped into sections.
3. For each tile: chart type, dimensions, filters, and the question it answers.
4. Global filters and default date range.
5. What deliberately does NOT belong on this dashboard and why.
Avoid vanity metrics; tie every tile to a decision.Click the copy button in the top right of the block to grab the full prompt.
Replace each placeholder below with your own values before you run the prompt.
- {{business_goal}}
- {{audience_cadence}}
- {{decisions}}
- {{data_sources}}
- {{bi_tool}}
Related prompts
You are a meticulous data analyst. Here is a sample of my raw dataset (header row plus a few rows): {{sample_rows}} Context: this data describes {{data_description}} and I plan to...
You are a senior Python data engineer. Write clean, reproducible pandas code to clean my dataset. Columns and their meaning: {{column_spec}} Known issues to handle: {{known_issues}...
Act as a data analyst guiding me through exploratory data analysis. Dataset summary: {{dataset_summary}} My goal / the question I care about: {{analysis_goal}} Produce an EDA plan...
You are a SQL expert writing for a {{sql_dialect}} database. Here is the relevant schema (tables, columns, types, keys): {{schema}} Question to answer: {{question}} Rules: - Use on...
You are a SQL reviewer. Explain and debug the query below. Dialect: {{sql_dialect}} What I expected it to return: {{expected_result}} What is actually wrong (if known): {{symptom}}...
You are a database performance specialist for {{sql_dialect}}. Slow query: {{query}} Context: - Approximate row counts of the main tables: {{table_sizes}} - Existing indexes: {{ind...
0 Comments
Loading discussion...