Dashboard Design Brief
Write a complete brief for a data dashboard — what to show, how to organize it, and what decisions it should drive.
Design a structured analysis plan — what to measure, how to measure it, and how to avoid common analytical mistakes.
Help me design a structured plan for analyzing a dataset. **The question I'm trying to answer:** [What business question, hypothesis, or decision is this analysis for?] **The dataset I have:** - What it contains: [Describe the data — tables, fields, rows, time range] - How it was collected: [e.g. user events, survey responses, sales transactions, sensor data] - Known data quality issues: [Nulls, duplicates, inconsistencies you're aware of] - Size: [approximate rows and columns] **Tools I'm using:** [e.g. Python/pandas, R, SQL, Excel, Tableau, Looker, BigQuery] **Who the output goes to:** [e.g. myself, an executive, a client, a data science team, published externally] **Timeline:** [How much time do you have for this analysis?] Design a complete analysis plan: 1. **Reframe the question** — restate it as a precise, answerable analytical question 2. **Key metrics** — the specific numbers you need to calculate to answer the question 3. **Analysis steps** — ordered sequence of what to do: data cleaning → exploration → analysis → validation 4. **For each step:** what you're doing, why, and what tool/technique to use 5. **Potential confounders and biases** — what could make the results misleading 6. **Sanity checks** — how to verify your results make sense before presenting them 7. **Output format** — what the deliverable should look like given the audience
Planning a structured data analysis before starting — defining the right metrics, steps, pitfalls, and output format.
A complete analysis plan with a reframed question, key metrics, ordered analysis steps with techniques, confounders to watch for, sanity checks, and output format guidance.
Sign in to leave a comment.
No comments yet.
Be the first to share your thoughts.
Works best with
Claude Sonnet 4
Write a complete brief for a data dashboard — what to show, how to organize it, and what decisions it should drive.
Define the right metrics and KPIs for a goal — including how to measure them, what good looks like, and what to avoid tracking.
Write complex SQL queries from a plain English description of what you need — with explanations.