Question

A finance manager wants a Copilot agent that can take raw sales data from an Excel file, run advanced statistical calculations, generate visualizations, and produce a forecast. The finance manager asks which built-in Copilot agent is designed for this kind of high-fidelity, code-driven data analysis. Which agent should you recommend?

Accepted Answer

The Analyst agent, because it can run Python-based analysis to process data and build forecasts and visualizations

Answer

The Researcher agent, because it performs multi-step research across web and work data

Answer

A declarative custom agent built in Copilot Studio agent builder with a knowledge source of web pages

Answer

The default Microsoft 365 Copilot chat experience, because it handles all data tasks natively