Fill in these first
- What the data is: [e.g. monthly orders export from an online store]
- Question to answer: [e.g. which regions and products drive growth]
- Group by: [column names to summarise by, e.g. Region, Product]
- Measure: [column to total or average, e.g. Revenue]
- Time column, if any: [column name]
- Data: [paste the CSV here, with the header row]
Task
Summarise the data like a pivot table, then explain what it shows in plain language.
Output format
- Data check: row count, date range, and any blank, duplicate or odd values found.
- Summary table 1: totals of the measure by the first group-by column, with share of total as a percentage, sorted highest first.
- Summary table 2: the measure by both group-by columns, or by period if a time column is given.
- Insights: five numbered findings. Each states the figure, the comparison and why it matters, in one or two sentences.
- Recommended actions: three actions tied directly to the insights.
- Chart suggestion: one chart type and which columns go on each axis.
Quality rules
- Calculate from the data provided only; show numbers rounded consistently.
- Every insight contains at least one number.
- Separate what the data shows from what it might suggest. Use "may" for anything causal.
- If the data is too small or incomplete to support a finding, say so rather than stretch it.
- Use the currency or unit that appears in the data.






