Analyst is Copilot's specialist for data work. Attach an Excel workbook or CSV, or point it at data already indexed in your tenant, and ask for a trend, a forecast or a breakdown. Analyst writes Python to answer, runs it and returns charts and findings, with the code visible in real time so you can trace how each number was produced.
It shares a monthly cap of twenty-five queries per user with Researcher, and Microsoft ships it as-is, so you cannot customise it in Agent Builder. Analyst returns its analysis in the chat; it does not save a finished workbook back to a folder on your computer.