The Excel Insight Generator

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

Prompt

Analyze the uploaded dataset and generate a structured insights report.

Dataset description: [DESCRIBE WHAT THE DATA CONTAINS]
Business context: [WHAT DECISIONS DOES THIS DATA SUPPORT]
Key questions to answer: [LIST 3-5 QUESTIONS YOU WANT ANSWERED]
Time period: [DATE RANGE OF THE DATA]

**AUTOMATED ANALYSIS**
Perform the following:
1. Descriptive statistics for all numeric columns (mean, median, min, max, std dev)
2. Distribution analysis — are key metrics normally distributed? Flag skewness.
3. Correlation matrix — which variables move together? Highlight correlations above 0.7.
4. Outlier detection — flag rows where any metric is more than 2 standard deviations from the mean
5. Missing data audit — which columns have gaps and what % of rows are affected?

**BUSINESS INSIGHTS**
- Top 5 insights from the data in plain language
- 3 anomalies that warrant further investigation
- 2 recommendations backed directly by the data

**EXCEL FORMULAS TO IMPLEMENT**
Provide formulas for: [SPECIFIC CALCULATIONS YOU NEED, e.g., rolling averages, cohort analysis, % of total]

**VISUALIZATION GUIDE**
For each key insight, recommend the best chart type and what it should show.

Format findings as an executive data brief — lead with conclusions, support with data.