Data Generator → Insights

Download the data files below and upload to Copilot Chat before running this prompt.

Prompt

I am uploading a real dataset. Generate a structured analysis AND create an Excel template that can be reused for future data.

Dataset: [DESCRIBE THE DATA]
Business use case: [WHAT THIS IS USED FOR]
Frequency of refresh: [HOW OFTEN NEW DATA IS LOADED]
Audience for the output: [WHO WILL USE THIS]

**ANALYSIS OUTPUT**
From the uploaded data, produce:
1. Summary statistics table — min, max, average, median, and percentile distribution for each numeric field
2. Top 10 and bottom 10 records by [PRIMARY METRIC]
3. Trend analysis if date field is present
4. Segment breakdown by [CATEGORICAL FIELD]
5. Key insight narrative — 3 bullets in plain English

**REUSABLE TEMPLATE DESIGN**
Design an Excel template with:
- A dedicated data input tab (paste new data here)
- An automated calculations tab using formulas only (no macros)
- A dashboard tab with linked charts that update automatically
- Instructions tab for the end user

**FORMULAS TO INCLUDE**
Provide exact formulas for:
- SUMIFS for segment breakdowns
- Dynamic ranked lists using LARGE/SMALL
- Conditional formatting rules for status indicators
- Data validation dropdowns for filter controls

Make the template usable by someone with basic Excel skills.