Analyst

Analyst is a first-party reasoning agent in Microsoft 365 Copilot built for multi-step quantitative work. Given data such as a spreadsheet, it applies chain-of-thought reasoning and writes executable Python to clean, transform, and summarize the data, showing its code in real time so users can inspect the logic. The key exam distinction is that Analyst targets structured data-analysis tasks while Researcher targets broad information synthesis across web and organizational sources. Both are reasoning agents in Copilot Chat requiring a Microsoft 365 Copilot license, so picking the wrong one for a data scenario is a common distractor.