Prompt libraryPrompts for every stage of the analysis.
Copy one, fill in the [brackets], paste it into Claude, ChatGPT or any assistant. Each one is written the way I brief AI on real projects: context first, a clear output, and room for what it doesn't know.
Elicitation01
Stakeholder interview plan
Before a discovery interview, so you ask the questions that matter.
I'm a business analyst preparing a 45-minute discovery interview with [stakeholder role] about [process or problem].
Context: [what we already know, in 2-3 sentences]
Draft an interview guide with:
1. A one-line purpose statement I can open with
2. 12 open questions grouped into: current process, pain points, exceptions, data and systems, success measures
3. Two follow-up probes for each question
4. Three questions that surface unstated assumptions or politics
Avoid leading and yes/no questions.
Elicitation02
Interview notes to findings
Right after an interview, to turn raw notes into structured findings.
Below are my raw notes from an interview with [role].
<notes>
[paste notes]
</notes>
Organise them into: confirmed facts, pain points (with frequency or impact if mentioned), requirements stated or implied, assumptions to validate, open questions and quotes worth keeping.
Mark anything you inferred rather than read in the notes with (inferred).
Elicitation03
Workshop agenda
When you need a focused requirements workshop instead of a status meeting.
Design a [duration] requirements workshop for [number] participants from [teams]. Goal: [decision or output we need].
Give me: a timed agenda, the activity for each block (e.g. silent brainstorming, dot voting, process walk-through), the materials needed, the output each block should produce, and how to handle one dominant voice in the room.
Elicitation04
Survey for scale
When you need input from many users, not just a few interviews.
Write a short survey (max 10 questions, under 5 minutes) for [audience] to validate these findings from interviews:
[list findings]
Mix multiple choice, a 1-5 scale and at most 2 open questions. For each question note which finding it validates. Keep the wording neutral and avoid double-barrelled questions.
Elicitation05
Questions I forgot to ask
At the end of discovery, to find the gaps before they find you.
Here is what I know about [initiative] so far:
[summary of findings, scope and stakeholders]
Act as a senior business analyst reviewing my discovery. List the 15 most important questions I haven't answered yet, grouped by: scope, users, data, edge cases, non-functional needs, compliance and change impact. Rank each as high, medium or low risk if left unanswered.
Requirements06
Notes to user stories
Turning meeting notes or a brief into a first backlog draft.
Turn these notes into user stories using "As a [role], I want [goal], so that [benefit]".
<notes>
[paste notes]
</notes>
For each story add 3-5 acceptance criteria in Given/When/Then form. Keep stories small enough to finish in one sprint. List anything ambiguous as an open question rather than guessing.
Requirements07
INVEST check
Before refinement, to catch weak stories early.
Review these user stories against INVEST (Independent, Negotiable, Valuable, Estimable, Small, Testable):
[paste stories]
For each story: score each letter pass/weak/fail with a one-line reason, then rewrite the story so it passes. If a story is too big, split it and say which splitting pattern you used.
Requirements08
Functional and non-functional split
When a requirements list mixes "what" and "how well".
Sort these requirements into functional and non-functional:
[paste list]
For non-functional ones, name the category (performance, security, availability, usability, compliance, scalability) and rewrite each so it is measurable, e.g. "loads in under 2 seconds for 95% of requests".
Requirements09
Edge cases and exceptions
When the happy path is written and you need the rest.
Here is a feature description:
[describe the feature]
List the edge cases, exception flows and error states. For each give: the trigger, what the system should do, and the message the user sees. Include empty states, permissions, timeouts, duplicate submissions and partial failures.
Requirements10
Requirements quality review
Before sign-off, to find vague or untestable requirements.
Review these requirements as a strict QA lead:
[paste requirements]
Flag words that make a requirement untestable (fast, easy, user-friendly, etc.), missing actors, conflicting requirements and anything that describes a solution instead of a need. Return a table: ID, issue, why it matters, suggested rewrite.
Process11
As-is process map
To turn a verbal description into a clean current-state process.
Here is how [process] works today, as described by the team:
<description>
[paste description]
</description>
Write it as a numbered as-is process with: step, actor, system or tool, input, output and average time if mentioned. Then list the hand-offs, wait states and rework loops you can see.
Process12
To-be design
When you have the as-is and need a better future state.
Using this as-is process:
[paste as-is steps]
Propose a to-be process that removes waste. For each change say what was removed or automated, why, and what it depends on (system change, policy change, training). Keep a human in the loop for any judgement or approval step.
Process13
SIPOC
At the start of a process improvement, to agree on scope.
Build a SIPOC for [process]: Suppliers, Inputs, Process (5-7 high-level steps), Outputs, Customers.
Context: [one paragraph]
Then list 3 scope questions the SIPOC raises that the sponsor should answer.
Process14
Mermaid flowchart
When you want a diagram you can paste into Mermaid, Notion or GitHub.
Convert this process into a Mermaid flowchart (flowchart TD). Use rectangles for steps, diamonds for decisions and label every decision branch. Keep labels under 6 words.
[paste process steps]
Process15
Root cause with 5 Whys
When a recurring problem keeps coming back.
Problem: [describe the problem and its impact]
Facts we know: [list]
Run a 5 Whys analysis. Show two alternative causal chains if the evidence supports more than one. End with the most likely root cause, how to verify it with data, and one countermeasure for each chain.
Data & SQL16
Data dictionary draft
When you inherit a table or spreadsheet with no documentation.
Here are column names and 10 sample rows from [table or file]:
[paste]
Draft a data dictionary: field name, plain-English definition, data type, example value, allowed values or format, whether it can be empty, and the likely source system. Flag fields whose meaning is unclear.
Data & SQL17
SQL from a business question
When you know the question but not the query.
Database: [PostgreSQL / SQL Server / BigQuery / other]
Tables and columns:
[paste schema]
Write a SQL query that answers: "[business question]".
Explain each clause in one line, state any assumptions about the data, and add a second version that handles NULLs and duplicates safely.
Data & SQL18
Explain this query
When you need to understand or review someone else's SQL.
Explain this SQL to a business stakeholder in plain English, then to an analyst in technical terms. Point out performance risks and logic that could produce wrong numbers (joins that fan out, filters in the wrong place, NULL handling).
[paste query]
Data & SQL19
Data quality checks
Before you trust a dataset in a report or migration.
For a dataset about [subject] with these fields:
[list fields]
List the data quality checks I should run: completeness, uniqueness, validity, consistency and timeliness. For each give the rule, a SQL snippet to test it, and the threshold that should trigger an alert.
Data & SQL20
KPI definition
When stakeholders say "we need a dashboard" but haven't agreed what to measure.
We want to measure [goal] for [team or product].
Propose 5 KPIs. For each: name, exact formula, data source, refresh frequency, owner, target or benchmark, and one way it could be gamed or misread. Mark which are leading and which are lagging indicators.
Stakeholders21
Stakeholder map
At kickoff, to plan who needs what and how often.
Initiative: [name and one-line goal]
Stakeholders: [list names or roles]
Place each stakeholder on a power/interest grid and explain why. Then give an engagement plan: what they care about, what they need from us, channel, frequency and the risk if we get them wrong.
Stakeholders22
Executive summary
When leadership needs the point in under a minute.
Rewrite this for a senior executive in under 150 words. Lead with the decision or ask, then impact in numbers, then risks and the next step. No jargon.
[paste update or document]
Stakeholders23
Saying no to scope creep
When a stakeholder asks for "just one more thing".
A stakeholder ([role]) asked to add [request] to [project] after scope was agreed. Impact: [time, cost, risk].
Draft a short, friendly reply that acknowledges the value, explains the trade-off with numbers, and offers options: add later, swap for something of equal size, or extend the timeline with sponsor approval.
Stakeholders24
Status update
Weekly updates that people actually read.
Turn these notes into a status update with: overall RAG status and why, done this week, planned next week, risks and issues (owner and date), and decisions needed. Keep it scannable.
[paste notes]
Stakeholders25
Conflicting requirements
When two stakeholders want opposite things.
[Stakeholder A] wants [requirement A] because [reason]. [Stakeholder B] wants [requirement B] because [reason].
Analyse the underlying interests of both, find what they have in common, and propose 3 options that satisfy the shared goal. For each option list trade-offs and who would need to agree.
Agile26
Epic to stories
When an epic is too big to estimate.
Split this epic into user stories that each deliver value on their own:
[epic description]
Use splitting patterns such as workflow steps, business rules, data variations and happy path first. For each story give a one-line acceptance summary and mark the smallest set that would be a useful first release.
Agile27
Backlog prioritisation
When everything is "high priority".
Prioritise these backlog items using [MoSCoW / RICE / WSJF]:
[paste items with any data on reach, impact, effort]
Show your scoring, state any assumptions you made, and highlight items that look important but have weak evidence.
Agile28
Definition of Ready and Done
When the team keeps pulling half-baked stories into sprints.
Draft a Definition of Ready and a Definition of Done for a [team type] team working on [product]. Keep each to 6-8 checkable items, and add a note on who checks each item and when.
Agile29
Sprint review script
Before a sprint review, so stakeholders see outcomes, not tickets.
Sprint goal: [goal]
Completed: [list]
Not completed: [list and why]
Write a 15-minute sprint review outline that demos outcomes for users, shows progress toward the product goal, and ends with 3 specific questions for stakeholder feedback.
Agile30
Retrospective insights
After a retro, to turn sticky notes into actions.
Here are retrospective notes from the team:
[paste notes]
Group them into themes, identify the 2 themes with the biggest impact, and propose one specific, owned and time-boxed action for each. Note any theme that keeps repeating from previous retros: [previous themes].
Testing31
Test cases from acceptance criteria
When stories are ready and QA or UAT needs test cases.
Write test cases for this user story and its acceptance criteria:
[paste story and criteria]
Return a table: test ID, scenario, preconditions, steps, test data, expected result, priority. Include positive, negative and boundary cases.
Testing32
UAT plan
Before user acceptance testing starts.
Draft a UAT plan for [release or system] with [number] business testers from [teams].
Include: scope and out of scope, entry and exit criteria, schedule, roles, how defects are logged and triaged (severity definitions), sign-off process and a daily check-in agenda.
Testing33
Defect write-up
When a bug report needs to be clear enough to fix.
Turn this description into a defect report: title, environment, steps to reproduce, expected result, actual result, severity with reason, and any data or screenshots to attach.
[paste what happened]
Testing34
Regression scope
When a change ships and you need to know what else to retest.
We are changing [component or feature]: [describe change].
Related features: [list]
List what could break, ranked by likelihood and impact, and propose the minimum regression test set that covers the highest risks.
Testing35
Test data design
When you need realistic test data without real customer data.
Design test data for [feature] covering normal, boundary and invalid cases. Fields: [list fields and rules].
Return it as a CSV-ready table of 15 rows, with a column explaining what each row is testing. Do not use real personal data.
Docs36
BRD from notes
When you need a first draft of a business requirements document.
Using these notes, draft a business requirements document with: background, problem statement, objectives with measures, scope (in and out), stakeholders, business requirements (numbered), assumptions, constraints, dependencies and open questions.
<notes>
[paste notes]
</notes>
Keep requirements numbered so they can be traced later.
Docs37
Plain-English rewrite
When a document is accurate but nobody can read it.
Rewrite this for [audience] at a reading level they will understand. Keep every requirement and number intact, use short sentences and active voice, and add a 3-bullet summary at the top.
[paste text]
Docs38
Decision log entry
After a meeting where something important was decided.
Write a decision log entry: decision, date, context, options considered with pros and cons, rationale, who decided, who was consulted, and how we will know if it was the right call.
Notes: [paste notes]
Docs39
Release notes
When a release ships and users need to know what changed.
Turn these tickets into release notes for [audience]: group by new, improved and fixed, lead each item with the user benefit, and skip internal-only changes.
[paste ticket titles and descriptions]
Docs40
Glossary builder
When a project has too many acronyms.
Extract every term, acronym and piece of jargon from this document and build a glossary: term, plain-English definition, and where it is used. Flag terms that are used inconsistently.
[paste document]
Automation41
Is this worth automating?
Before you build anything, to check the business case.
Process: [describe]
Volume: [times per week or month]
Time per run: [minutes]
Error rate today: [if known]
Assess whether to automate: annual hours saved, rough build effort, risks, and what must stay human. Give a go / not yet / no answer with reasons.
Automation42
Process to automation spec
When a process is approved for automation and needs a build brief.
Turn this process into an automation spec for [n8n / Make / Zapier]:
[paste process steps]
Include: trigger, each step as a node (app, action, key fields), data mapping between steps, error handling and retries, where a human approves, logging, and how we will test it before go-live.
Automation43
n8n workflow outline
When you know what you want to automate and need the node-by-node plan.
Outline an n8n workflow that [goal], starting from [trigger, e.g. new form submission or webhook].
List each node in order with its type (e.g. Webhook, IF, Set, HTTP Request, AI Agent, Google Sheets), what it does and the key settings. Add an error workflow and say where credentials are needed. Keep it simple enough to build in an afternoon.
Automation44
AI step design
When an automation needs an AI step to classify, extract or draft.
Inside an automation, an AI step must [classify / extract / summarise / draft] [input type].
Write the system prompt for that step, the exact JSON output schema, 3 example inputs with expected outputs, and the rule for when the result should go to a human for review (e.g. low confidence or missing fields).
Automation45
Automation runbook
Before handing an automation to the team that will own it.
Write a one-page runbook for this automation: [name and what it does].
Cover: purpose, trigger and schedule, systems and credentials involved (no secrets), what normal looks like, common failures and how to fix them, who to contact, and how to pause it safely.