Pivot Table from Data
Creates pivot table configurations from your data structure
Help me create a pivot table.
Platform: {platform} (Excel / Google Sheets / Python pandas)
Source data: {data}
Columns: {columns}
What needs to be analyzed: {analysis}
Provide:
1. **Pivot table setup**:
- Rows (what to group by)
- Columns (what to compare)
- Values (aggregations: sum, average, count)
- Filters
2. **Step-by-step instructions** for {platform}
3. **Formulas** / Code (if pandas):
- pivot_table or groupby
- Calculated fields (share, growth, deviation)
4. **Visualization**: which chart to build from the pivot table
5. **Insights**: what questions this pivot table can answer
6. **Additional slices**: what other groupings would be useful
0 copies
Variables
Replace these variables with your own values before using:
{платформа}{данные}{столбцы}{анализ}
Prompt info
📊
Category
Data
AI model
Any model
Application
Создание сводных таблиц для анализа бизнес-данных
сводная таблицаpivotExcelаналитикагруппировка
Similar prompts
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
📊 DataAny model
0 copies