Insights and Verify Before You Act
Start broad: three important insights with supporting numbers and why each matters — saved to a new sheet for documentation.
Lesson 5
Headlines first, then pressure-test.
Then follow threads: correlate against your target column, chart top indicators over time, test lags and seasonality — one prompt at a time, read each result before the next.
If a decision rides on the number, verify it before it leaves the room.
Core principles
- Headlines from the three-insights prompt are for orientation — trace each number to the sheet.
- High correlation proves nothing alone — ask for alternative explanations and row counts.
- Dig deeper prompts (run one at a time): correlate [target] with every numeric column; chart top 3 vs target; test 1–3 month lag vs same-month.
- Verify: List every specific claim as a table with source in the sheet — mark single-sourced and assumptions.
- Simple rule: descriptive summaries you can spot-check; causal or budget claims need rigor or data science.
Check yourself
Why flag correlations under 0.4 as weak in the Copilot Brief rules?
A modest correlation can look compelling in prose. The brief rule forces Copilot to say how little it explains and stops "insights" built on noise or shared trends.
Do this in Copilot
Run the three-insights prompt. Trace one number back to Clean Data before you would repeat it aloud.
Paste this into Copilot Chat and work through it before moving on.
Three business insights
Using the Copilot Brief sheet, identify the 3 most important insights in this data. For each one, give the supporting numbers and one sentence on why it matters to the business. Save the summary to a new sheet.
- Chain of thought
- Claim spot-check
- Dig deeper (replace [target column] with your metric, e.g. Revenue_EUR): Calculate the correlation between [target column] and every numeric column. Rank by absolute strength and label each as strong, moderate, or weak. Save the table to a new sheet.
- Verify: List every specific factual claim from your analysis as a table with the cell or calculation source. Mark single-sourced items.
Did you run this in Copilot? Mark complete when you have tried it.
RecordedEdition complete
Copilot in Excel — Data Analysis
Navigate: press j for next lesson, k for previous.