Question

A financial operations team wants a Microsoft 365 Copilot capability that can perform advanced, multi-step data analysis on raw sales spreadsheets—including running Python code to generate visualizations and statistical models directly from the data they provide. As the administrator, which built-in Copilot agent should you direct them to use for this scenario?

Accepted Answer

The Analyst agent, because it can run Python to perform advanced data analysis and generate insights from provided data

Answer

The Researcher agent, because it performs deep multi-source research and reasoning

Answer

A pay-as-you-go SharePoint agent, because it grounds responses in document libraries

Answer

A custom declarative agent built in Copilot Studio, because only custom agents can process spreadsheet data