Microsoft 365 Copilot Analyst: Features, Use Cases and Licensing
Learn how Microsoft 365 Copilot Analyst analyses Excel and CSV data, creates reports, compares with Copilot in Excel, and works across GCC and DoD.
Hammad Shahid
Power Platform, SharePoint & Copilot Studio Consultant · Microsoft Certified Trainer
Microsoft 365 Copilot Analyst is an AI-powered data analysis agent that helps users examine business data, identify trends, find outliers, and generate reports using natural-language instructions.
Instead of manually combining spreadsheets, creating formulas, or writing Python code, users can attach supported data files and ask questions such as:
Compare sales performance across these regional files and identify the products with the largest decline.
Analyst can then return written findings, calculations, tables, and charts.
In this guide, we look at what Microsoft 365 Copilot Analyst does, how it compares with Copilot in Excel and Researcher, its licensing requirements, and where it is currently available.
What is Microsoft 365 Copilot Analyst?
Microsoft 365 Copilot Analyst is a Microsoft-built agent designed for analysing structured business data.
It can help users:
- Analyse multiple Excel and CSV files.
- Compare data across regions, departments, products, or periods.
- Calculate statistics and performance indicators.
- Identify trends, anomalies, and outliers.
- Generate charts and tables.
- Summarize findings in plain business language.
- Explore relationships between different variables.
Microsoft describes Analyst as capable of working with thousands of rows and multiple data sources, including spreadsheets, CSV files, databases, and other supported sources.
It is especially useful for users who understand their business data but do not have advanced skills in Python, statistics, Power BI, or Excel modelling.
How to access Microsoft 365 Copilot Analyst
Analyst is available in the Agents section of the Microsoft 365 Copilot app.
To use it:
- Open Microsoft 365 Copilot with your work or school account.
- Select Analyst under Agents.
- Enter your analysis request.
- Select Attach content.
- Upload files from your computer or select supported files from OneDrive.
- Review the generated analysis.
A qualifying Microsoft 365 Copilot licence is required. Your Microsoft 365 administrator must also allow the Analyst agent within your organization.
How Microsoft 365 Copilot Analyst works
Analyst uses reasoning capabilities to work through data-analysis tasks in multiple steps.
Depending on the request, it can:
- Combine datasets.
- Group and aggregate records.
- Calculate growth rates or distributions.
- Identify statistical outliers.
- Create forecasts.
- Generate visualizations.
- Explain important findings.
Microsoft also documented that Analyst can generate and execute Python code for complex calculations and allow users to inspect the code used during the analysis.
At launch, Microsoft stated that Analyst was built on OpenAI’s o3-mini reasoning model. However, this should be treated as launch-era information rather than a permanent product specification, because Microsoft can update the underlying models used by its managed services.
Which agent should you use?
Microsoft 365 Copilot includes several agents that overlap at first glance. The quickest way to choose is to match your main input and your desired output:
| If your main input is… | And you want… | Use |
|---|---|---|
| A single Excel workbook | Formulas, PivotTables, edits kept in the file | Copilot in Excel |
| Several raw data files | A written analysis with trends and charts | Analyst |
| Web and workplace content | A source-cited research report | Researcher |
The rest of this guide expands on those distinctions.
Microsoft 365 Copilot Analyst vs. Copilot in Excel
Analyst and Copilot in Excel can both help users understand data, but they are designed for different outcomes.
Use Copilot in Excel when:
- You want to edit an Excel workbook.
- You need formulas inserted into cells.
- You want editable charts or PivotTables.
- You need to sort, filter, format, or reorganize data.
- Your final deliverable should remain inside Excel.
Copilot in Excel can also retrieve information from other workbooks stored in OneDrive, SharePoint, or on a user’s computer. Therefore, it is no longer accurate to say that Copilot in Excel is limited to analysing only one workbook.
Use Analyst when:
- You want to analyse several raw data files.
- You need a detailed written interpretation.
- You want trends and anomalies explained.
- You need charts and tables as part of an analytical report.
- You are more interested in conclusions than workbook editing.
A practical distinction is:
Copilot in Excel helps you build and modify a workbook. Analyst helps you investigate data and explain what it means.
Analyst vs. Researcher in Microsoft 365 Copilot
Analyst and Researcher are separate Microsoft 365 Copilot agents.
Analyst is designed for structured data, calculations, comparisons, trends, and visualizations.
Analyse the attached sales files, compare quarterly performance by region, and identify unusual changes.
Researcher is designed for deep research across web sources and accessible workplace content such as documents, emails, meetings, and chats.
Research the adoption of AI agents in financial services and create a source-cited industry report.
Analyst is generally the better option when the main input is numerical data. Researcher is more appropriate when the task requires gathering and synthesizing information from several sources.
Practical use cases for Copilot Analyst
| Scenario | What to ask Analyst |
|---|---|
| Sales analysis | Upload regional sales files and compare revenue, growth, product performance, and regional results. |
| Budget analysis | Compare planned and actual expenditure and identify departments exceeding their budgets. |
| Customer analysis | Examine purchases, product usage, support activity, or account value to find high-risk or high-potential groups. |
| Marketing performance | Compare campaign costs, leads, engagement, conversion rates, and acquisition costs. |
| Survey analysis | Review employee or customer survey data, identify recurring themes, and compare satisfaction scores. |
| Operational reporting | Analyse request volumes, processing times, delays, bottlenecks, or service-level performance. |
Example prompts for Microsoft 365 Copilot Analyst
Better prompts provide a clear objective, relevant metrics, comparison criteria, and desired output.
Sales prompt
Combine the attached regional sales files. Compare revenue and units sold by region and quarter, identify major changes, and provide an executive summary with two charts.
Finance prompt
Compare the budget and actual-expense files. Calculate the variance by department and month and highlight any variance above 15%.
Customer prompt
Identify high-value customers with low product adoption. Group them by account size and recommend which segment should be contacted first.
Operations prompt
Analyse processing time by department and request type. Calculate the percentage of requests exceeding the target and identify the main bottlenecks.
Licensing and administrative requirements
Microsoft 365 Copilot Analyst requires a qualifying Microsoft 365 Copilot licence.
However, assigning the licence does not always guarantee that the agent will immediately appear. Access may also depend on:
- Licence provisioning.
- Microsoft 365 administrator settings.
- Organizational agent policies.
- Cloud environment.
- Tenant-specific restrictions.
If Analyst is missing, users should contact their Microsoft 365 administrator to confirm that the agent is enabled.
Government-cloud availability
According to Microsoft’s service description updated in June 2026, Analyst is available in Microsoft commercial tenants, Government Community Cloud (GCC), GCC High, and Department of Defense (DoD) environments.
| Agent | Commercial | GCC | GCC High | DoD |
|---|---|---|---|---|
| Analyst | Available | Available | Available | Available |
| Researcher | Available | Available | Available | Not currently available |
This is an important update, because older guidance may still state that Analyst is unavailable in government-cloud environments.
Government organizations should still verify individual feature availability, because connectors, web access, and other Copilot capabilities may vary between cloud environments.
Query limits and supported languages
When Analyst and Researcher became generally available in June 2025, Microsoft announced up to 25 combined Analyst and Researcher queries per licensed user each month. At that time, Microsoft also stated that Analyst supported eight languages.
These were launch-era figures and should not be treated as permanent limits. Microsoft may change usage allowances and language support as the product develops. Organizations should verify current entitlements through their Microsoft 365 tenant, licensing documentation, or Microsoft account representative.
Limitations of Microsoft 365 Copilot Analyst
Analyst can speed up data exploration, but it does not replace a governed business-intelligence or data-management platform. It should not be considered a complete replacement for:
- Power BI semantic models and dashboards.
- Power Query transformation processes.
- SQL databases or data warehouses.
- Microsoft Dataverse.
- Approved financial-reporting systems.
- Data-quality controls.
- Human review of important decisions.
For recurring reporting, Power BI may be a better long-term solution. For one-time analysis, rapid investigation, and early insights, Analyst can save significant time.
How to verify Analyst’s output
Before relying on a generated analysis, check:
- Whether all relevant files were included.
- Whether the datasets cover the same period.
- Whether duplicate records were removed.
- How missing values were handled.
- Whether currencies and date formats are consistent.
- Whether averages or weighted averages were used.
- Whether cancelled or returned transactions were excluded.
- Whether generated totals match the source data.
AI-generated calculations and conclusions should always be reviewed before being used in financial, legal, operational, or strategic decisions.
Frequently asked questions
Can Microsoft 365 Copilot Analyst analyse multiple files?
Yes. Cross-file analysis is one of its main use cases.
Can Analyst create charts and tables?
Yes. Analyst can include visualizations, tables, calculations, and written findings in its response.
Can Analyst run Python?
Microsoft has documented that Analyst can generate and execute Python code for complex data-analysis tasks.
Is Analyst the same as Copilot in Excel?
No. Copilot in Excel focuses on editing and analysing an Excel workbook. Analyst focuses on examining supplied data and producing analytical findings.
Does Analyst require Microsoft 365 Copilot?
Yes. A qualifying Microsoft 365 Copilot licence is required.
Is Analyst available in GCC and DoD?
Yes. As of June 2026, Microsoft lists Analyst as available in Commercial, GCC, GCC High, and DoD environments.
Should Analyst’s results be trusted automatically?
No. Important calculations, assumptions, and conclusions should be validated against the original data.
Final thoughts
Microsoft 365 Copilot Analyst helps users move from raw data to business insights using natural-language prompts. Its strongest use case is analysing multiple datasets and explaining what changed, where performance is improving or declining, which records appear unusual, what patterns exist across different files, and which findings require attention.
Copilot in Excel remains a better choice when the final result needs to be an editable workbook. Researcher is better suited to web and workplace research. Analyst is the specialist agent for interpreting structured data.
With clean data, specific prompts, and proper human review, Microsoft 365 Copilot Analyst can significantly reduce the effort required to turn business data into useful decisions.
Planning a Microsoft 365 Copilot or Power Platform rollout? Get in touch — I help enterprises adopt Copilot agents, licensing, and governance the right way.