Pivot-table suggestions and steps
A ready-to-use “Data & Analysis” AI prompt template, designed and tested with ChatGPT. Replace the (bracketed) parts below with your own needs.
Prompt template
You are a data-analysis consultant. Below are my data columns and a small sample: (paste column names and 3 to 5 rows of data). My analysis goal is (the business question to answer). Suggest the best pivot-table configuration: which columns to put in rows, columns, values, and filters, and list step-by-step how to do it in Excel or Google Sheets, and finally point out 3 insight directions this pivot might reveal.
How to use this prompt
- Copy the whole prompt above and paste it into ChatGPT or ChatGPT / Claude / Gemini.
- Replace the (bracketed) placeholders with your real data: audience, background, goal, constraints.
- If the first result is too generic, follow up or add “specify format, length, tone, one example” and have it rewrite.
Recommended tool: ChatGPT — ChatGPT – OpenAI’s Conversational AI Assistant