Read a survey without fooling yourself
Here are survey results: {{paste questions, response counts, and open-text answers}}. It was distributed via {{channel}} to {{who}}, with {{n}} responses out of {{invited}}. 1. St…
PROMPT CATEGORY
Data & Analysis prompts
Practical data & analysis prompts tested with useful AI apps.
Unit economics that survive scrutiny
Work out the unit economics for {{business}}. Inputs: {{price, COGS components, CAC by channel, churn, expansion, gross margin, payback expectations}}. 1. Define each metric expli…
Write the query and the caveat for a stakeholder question
A stakeholder asked: "{{their question, verbatim}}". Available data: {{schema summary}}. 1. Restate what they're actually trying to decide — the question behind the question. If t…
Cohort retention analysis in plain language
Here's my signup and activity data: {{describe columns or paste sample}}. 1. Build monthly signup cohorts and show retention by month-since-signup as a triangle table. State clear…
Size a market from the bottom up
Size the market for {{product}} sold to {{customer type}} in {{geography}}. Build it bottom-up, not from an analyst's TAM number: 1. Define the unit of demand precisely (a company…
Clean a messy spreadsheet reproducibly
Here's a messy export: {{paste 20-30 sample rows with headers}}. 1. Diagnose every problem you can see: inconsistent date formats, numbers stored as text, mixed units, trailing wh…
Explain a metric move without inventing a story
{{Metric}} moved from {{before}} to {{after}} between {{dates}}. Context: {{what you know — launches, campaigns, seasonality, outages}}. Data available: {{list dimensions you can s…
Design an experiment that can actually conclude
I want to test {{change}} on {{surface}}. Baseline: {{metric and current value}}, traffic {{volume per week}}. Design the test: 1. State the hypothesis as a mechanism, not a hope:…
Forecast with the uncertainty attached
Forecast {{metric}} for the next {{horizon}}. History: {{paste time series}}. Known future events: {{launches, seasonality, pricing changes}}. 1. Describe the series honestly firs…
Interrogate a dataset before you trust it
Here's a dataset: {{paste sample rows plus column list, row count, and how it was collected}}. Before any analysis, audit it: 1. For each column: type, unit, expected range, % mis…
Turn analysis into an executive memo
Here's my analysis: {{paste findings, charts described, numbers}}. Audience: {{who}}, who cares about {{their objective}} and has 4 minutes. Write a one-page memo: 1. BOTTOM LINE …
Build the dashboard someone will actually use
Design a dashboard for {{role}} who needs to decide {{decision}} on a {{cadence}} basis. Available data: {{list}}. Start from decisions, not charts: 1. List the decisions this per…