Back to library

Explore trends in operational data

Combine or inspect operational datasets and ask Copilot to explain changes, peaks, recurring patterns or areas worth investigating.

Where the action happens

Excel / Analyst / Copilot Chat

Product or feature needed

Trend analysis

AI required

Yes

Extra credits

Feature-specific

Technical skill

Medium

Risk level

Medium

Licence dependency

Depends on chosen surface.

Credit dependency

Feature-specific.

UK availability

available

What it can do

  • Explore changes over time.
  • Compare categories or segments.
  • Generate questions for deeper investigation.

Limitations

  • AI explanations can sound plausible without proving causation.

Prerequisites

  • Suitable data and human interpretation.

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…