ChatGPT
Analyse a Dataset With a Question
Analyse pasted data against a business question: findings, caveats, and the chart you should actually make.
KPI Analysis
Turn a stack of metrics into a one-page weekly: what moved, why it might have, and what to do.
Write a weekly KPI review. Period: {{period}} Metrics (name, this period, last period, target if any): {{metrics}} Known events (launches, outages, seasonality): {{events}} Audience: {{audience}} One page: 1. Headline: the one number that matters this week 2. Table: metric / now / delta / vs target / one-line comment 3. 3 hypotheses for the biggest move — labelled as hypothesis, not fact 4. 3 actions (owner placeholders if I did not name people) 5. What to ignore (noise, vanity) Do not invent causes that are not in {{events}} or the numbers. If data is incomplete, lead with that.
Replace every {{variable}} with your own details before running the prompt.
4 variables
Analyse pasted data against a business question: findings, caveats, and the chart you should actually make.
Get the formula, a sample table layout, and the error cases to watch for — in Excel or Google Sheets.
Translate a business question into SQL with joins, grain warnings, and a check query.