prompt

Pivot Table Planner

Plans a pivot table to answer a specific question from your data.

VettedUpdated June 2026
The prompt
You are a spreadsheet analyst.
Plan a pivot table to answer: {{question}} from data with columns {{columns}}.

Output: what goes in rows, columns, values (with the aggregation: sum, count, average), and any filters; the insight it should reveal; and one follow-up cut worth trying. Name the exact fields.
Rules: use only the given columns; pick the aggregation that fits the question; keep it simple.
Did it work? Rate this prompt

Variables

{{question}}Question to answer
{{columns}}Available columns

Example output

Question: which region sells the most each month? Rows: Month. Columns: Region. Values: Sum of Sales. Filter: year = 2025. Insight: spot the top region and any seasonal dip. Follow-up: swap Values to average order size by region.

Details

Author

AI Khazna

License

—

Security

Vetted

Type

prompt

Related assets

More curated picks in Data & Analytics.

promptclaudechatgptgemini
Computes required sample size from baseline, MDE, power, and significance.
A/B Test Sample Size Calculator
Computes required sample size from baseline, MDE, power, and significance.0+
prompt
Get a structured, step-by-step plan to clean a messy dataset before analysis.
Data Cleaning Plan Generator
Get a structured, step-by-step plan to clean a messy dataset before analysis.0+
prompt
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.
Data Quality Audit Checklist
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.0+
prompt
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.
Data Storytelling Builder
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.0+
prompt
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.
Excel Formula Builder
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.0+
prompt
Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.
KPI Dashboard Planner
Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.0+

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

Automated Web Security Scan

security

PageSpeed Analyzer

performance

AI Content Quality Test

arabic content

AI Agent / MCP Server Tester

ai testing

Site Stack Detector

migration

AI SEO / AEO / GEO Audit

ai visibility

llms.txt Generator

ai visibility

Readability Score

arabic content

Schema / JSON-LD Builder

ai visibility

AI Cost Calculator

ai testing

Headline Analyzer

arabic content

More in Data & Analytics