Design Pivot Table for Summary Analysis
When you have a large dataset and need guidance on how to summarize it effectively with a pivot table.
Prompt
I have a dataset with columns: [COLUMN_NAMES_AND_EXAMPLES]. I want to analyze [ANALYSIS_GOAL, e.g., sales by region and product category, survey response distribution]. Recommend a pivot table layout using [SPREADSHEET_APP] including rows, columns, values, and filters. Also suggest any calculated fields or custom aggregations. Provide step-by-step instructions and explain why this layout helps achieve the goal.
Fill in these
Swap each placeholder for your own value:
[COLUMN_NAMES_AND_EXAMPLES][ANALYSIS_GOAL][SPREADSHEET_APP]
Pro tips
- Mention if you need to group dates by month or quarter.
- Ask for advanced pivot features like custom sort orders or conditional formatting.
- Specify if the pivot table will be the basis for a chart.
Related prompts
Complex Conditional Formula Generator
Act as a spreadsheet expert. I need a formula for [SPREADSHEET_APP] to calculate [DESIRED_OUTCOME] based on these conditions: [CONDITIONS]. The formula should handle [DATA_RANGE_REFERENCE] and include [SPECIFIC_FUNCTIONS, e.g., IF, VLOOKUP, INDEX-MATCH]. Use best practices for readability and error handling. Output only the formula with a brief explanation of how it works.
View promptClean Messy Text Columns with Formulas
I have a spreadsheet column containing [DATA_TYPE, e.g., full names, addresses, email addresses] that is inconsistently formatted. Common issues include [LIST_ISSUES, e.g., extra spaces, mixed case, inconsistent separators]. Please provide a set of formulas or functions in [SPREADSHEET_APP] to clean this column, transforming the data into a consistent format: [DESIRED_FORMAT]. Include explanations for each formula step. If a single formula is too complex, break it down into helper columns.
View promptConvert Natural Language to SQL Query
You are a SQL expert. I will provide a description of my database tables and a question. Write a SQL query to answer the question. Use clear aliases, comments, and optimize for readability. Tables: [TABLE_SCHEMAS]. Question: [QUESTION]. Include only the SQL code in your response, with a brief explanation after.
View promptExplain Data Trend or Anomaly
I have a dataset about [DATASET_DESCRIPTION]. I observed a [TREND_OR_ANOMALY] between [TIME_PERIOD_OR_SEGMENT]. My hypothesis is [YOUR_HYPOTHESIS, if any]. Help me interpret this finding. Consider factors such as [RELEVANT_FACTORS]. Provide possible explanations, suggest additional data to analyze, and ask me clarifying questions to narrow down causes.
View prompt