Excel Pivot Table Analysis Planner
Choose pivot rows, columns, values, and filters to answer a specific business question. This practical spreadsheet workflow asks for relevant evidence, spells out how to use it, and produces a reviewable output instead of generic suggestions or invented details.
GPT / Claude / Gemini6 variables
Prompt
You are a specialist assisting with excel pivot table analysis planner. Produce a practical, evidence-led result from the inputs below.
BUSINESS QUESTIONS: {BUSINESS_QUESTIONS}
COLUMN HEADERS: {COLUMN_HEADERS}
SAMPLE DATA: {SAMPLE_DATA}
DATE FIELDS: {DATE_FIELDS}
METRIC DEFINITIONS: {METRIC_DEFINITIONS}
EXCEL VERSION: {EXCEL_VERSION}
Task workflow:
1. Map questions to appropriate aggregations.
2. Identify dimensions and measure types.
3. Warn about sums of rates, unique counts, missing data, and time grouping.
4. Outline pivot configuration and sanity checks..
Accuracy and safety rules:
- Only use facts present in my inputs or explicitly identified as checked references; distinguish facts from assumptions.
- If a required item is missing, mark it unknown and explain the minimum verification needed. Do not fabricate examples as if they were real.
- Sample data cannot prove full-dataset totals; complex calculated measures may need data model features.
- Explain important tradeoffs and any limitation caused by my stated format, platform, or audience.
- Avoid padding, repetitive claims, fake metrics, and promises of guaranteed ranking, performance, admission, or success.
- Clearly label ready-to-use material versus suggestions that still need verification.
Deliverables:
1. An analysis-to-pivot mapping table
2. Setup instructions
3. And validation checks.
5. Brief final checklist showing how I can verify the result against the provided inputs.
Before finalizing, check the work for contradictions, unsupported facts, and any missing edge cases. Prefer specific, useful instructions over generic advice.Quick brief
Purpose
Choose pivot rows, columns, values, and filters to answer a specific business question.
Expected output
The response should contain an analysis-to-pivot mapping table, setup instructions, and validation checks. The output should be formatted so it can be copied, checked, and used without guessing what was assumed.
Customize before copying
Replace these placeholders with your own context before you run the prompt.
{BUSINESS_QUESTIONS}{COLUMN_HEADERS}{SAMPLE_DATA}{DATE_FIELDS}{METRIC_DEFINITIONS}{EXCEL_VERSION}
Works well with
GPT
Claude
Gemini
Variations
Make the response shorter while keeping all required evidence and verification steps for Excel Pivot Table Analysis.
Produce a beginner-friendly version that defines specialized terms and includes a concrete example for Excel Pivot Table Analysis.
Use a professional, implementation-ready format with explicit edge cases, constraints, and acceptance criteria for Excel Pivot Table Analysis.
What this prompt helps you do
Choose pivot rows, columns, values, and filters to answer a specific business question. This practical spreadsheet workflow asks for relevant evidence, spells out how to use it, and produces a reviewable output instead of generic suggestions or invented details.
When to use it
Use this template when your immediate task is choose pivot rows, columns, values, and filters to answer a specific business question. It is most useful when you can provide the requested input fields and review the result against real examples.
How it works
The workflow anchors its reasoning in the supplied material, organizes the user's goal, and executes this task-specific process: Map questions to appropriate aggregations; identify dimensions and measure types; warn about sums of rates, unique counts, missing data, and time grouping; outline pivot configuration and sanity checks.
Best practices
Provide field types and define each metric's calculation rules. Replace every input placeholder with genuine context, including examples of the expected result. Review the first draft against your own constraints before reusing it.
Common mistakes
Skipping key inputs, accepting unsupported claims, and publishing or executing generated output without review are frequent failure modes. In this task especially: Sample data cannot prove full-dataset totals; complex calculated measures may need data model features.
What you should expect back
The response should contain an analysis-to-pivot mapping table, setup instructions, and validation checks. The output should be formatted so it can be copied, checked, and used without guessing what was assumed.
Limitations
Sample data cannot prove full-dataset totals; complex calculated measures may need data model features. This is an assisted drafting and analysis template: it cannot independently validate inaccessible files, live platform data, or unprovided sources.
Model notes
Works with GPT, Claude, and Gemini. Provide the stated inputs as text, with redacted private information where appropriate.
Real-world applications
Suitable for people using AI to choose pivot rows, columns, values, and filters to answer a specific business question in routine spreadsheets workflows, with manual verification before reuse.
How to tell if it worked
Each pivot directly answers a stated question with interpretable aggregates. A second reviewer should be able to trace assertions to supplied inputs, and the final artifact should pass the verification checklist.
Where to go next
Explore related prompts in the spreadsheets category when you need adjacent tasks, reviews, or follow-up work.
Related prompts
Excel XLOOKUP and VLOOKUP Formula Builder
Write a dependable lookup formula for a real Excel table and its exact keys.
CSV Dataset Analysis Prompt for Descriptive Insights
Analyze a tabular dataset with explicit data checks before drawing conclusions.
Excel Monthly Budget Tracker With Formulas
Design a monthly budget worksheet with clear categories, balances, and variance formulas.
Excel Formula Generator With Examples and Error Checks
Build an Excel formula from a plain-language task and a real worksheet layout.
Google Sheets KPI Dashboard Planner
Design a maintainable Sheets dashboard using real data columns and clearly defined metrics.