The Microsoft 365 Copilot Analyst agent is an AI-powered assistant for data analysis. The Analyst agent is like having a skilled data analyst on hand to help you make sense of data quickly without requiring advanced expertise.
Benefits of Analyst
-
Save time: You don’t have to look through thousands of rows of data or multiple files like Excel spreadsheets, CSV files, databases, or others and then try to consolidate that data for analysis. Analyst does it for you!
-
You don’t have to be a data analyst: Just ask a simple question about your data and Analyst will do things like calculate statistics, identify trends, and show outliers.
-
Get easy-to-read reports: You’ll get a report based on your question in easy-to-read language and formatting that surfaces insights and can include visuals like charts and tables.
Where to find Analyst
Sign into https://microsoft365.com/copilot with your work or school account. You should see your name and picture at the bottom left corner of the screen.
You can find Analyst under Agents.
How to use Analyst
-
Open Microsoft 365 Copilot.
-
Under Agents in the left navigation pane, select Analyst.
-
Enter a question about the data you want to analyze.
-
Select the + icon and then select Attach content to supply the file(s) that have the data you want to analyze.
-
You will see a list of suggestions, but you can also search for a file. Additionally, you can upload one or more files from your device or attach content from the cloud by selecting the Upload or OneDrive icon next to the Search bar.
Looking for ways to start?
Here are a couple of examples to inspire you.
Compare sales performance: Let's say you want to compare sales performance across regions and quarters. Choose the files you want to analyze and ask:
|
Find top-performing products: You’re building a report to show which products have the best sales. Choose the files you want to analyze and ask:
|
Note: If the Analyst agent is not available, it may be because your administrator has not enabled it. Administrators can learn more about managing agents in Manage agents for Microsoft 365 Copilot in the Microsoft 365 admin center.