Question

A regional sales director uploads three quarters of raw sales data as CSV files to Microsoft 365 Copilot and asks for revenue trends, correlations between discount levels and deal size, and a chart summarizing the findings. The director needs the analysis performed directly on the uploaded numeric data with reproducible calculations. Which capability should the director use?

Accepted Answer

The Analyst agent, which runs Python code to process the uploaded data and produce calculated insights and visualizations

Answer

The Researcher agent, which performs multi-step reasoning across web and tenant sources to compile a report

Answer

Microsoft 365 Copilot Chat on the web, which answers grounded questions without executing analytical code

Answer

Microsoft Copilot Studio, to build a custom topic-based agent for parsing CSV files