Back to library
Work with data: Explore, analyse and consolidate dataMedium - analysis can be wrong or misleading riskAI required

Analyse data and find patterns

Give Copilot a table or dataset and ask questions about trends, outliers, changes over time or relationships between fields.

Where the action happens

Excel / Analyst / Copilot Chat

Product or feature needed

Data analysis

AI required

Yes

Extra credits

Usually no additional credits for normal licensed analysis; advanced tools may vary

Technical skill

Low to medium

Risk level

Medium - analysis can be wrong or misleading

Licence dependency

Depends on Excel/Analyst availability.

Credit dependency

Feature-specific.

UK availability

available

What it can do

  • Ask questions of structured data in natural language.
  • Identify patterns, trends and outliers.
  • Generate explanations and follow-up questions.

Limitations

  • Correlation can be mistaken for causation and data quality problems can distort results.

Prerequisites

  • A reasonably structured dataset and human review of important conclusions.

Notes

Generic data capability.

Watch-outs for Work with data

  • Check important calculations and conclusions before relying on them.
  • This section focuses on capability; organisational rules determine which datasets are appropriate to use.
  • For regulated or consequential decisions, keep human accountability.

Last checked: 2026-10-09

Disclaimer: Always follow your organisation's internal guidance and policies regarding AI usage. The suggestions in this guide have been created to the best of accuracy, but Microsoft licensing, pricing and feature availability change frequently — treat them as a planning baseline, not a procurement quote.

Community feedback

Has your organisation tried this? Confirm whether it's possible, whether it's useful, and share any tips.

0

Confirmed possible

0

Reported not possible

0

Found it useful

0

Not useful

Add your feedback

Used to verify feedback comes from a real organisation. Never displayed publicly.

Is this possible in practice?

Is it useful?

Loading feedback…