Question

A financial planning team asks you which built-in Copilot agent to use for a recurring task: they need to take a large raw sales dataset stored in Excel, run advanced statistical calculations and code-based data manipulation on it, and produce a chart with insights. They are not asking for a broad multi-source investigation. Which agent should you recommend?

Accepted Answer

The Analyst agent, because it can run code (Python) to perform advanced data analysis on the provided data

Answer

The Researcher agent, because it performs multi-step reasoning across many sources

Answer

A custom declarative agent built in Copilot Studio, because built-in agents cannot process spreadsheets

Answer

The Researcher agent, because it is the only agent that can generate charts