Home
Own your Microsoft 365 usage data — and get far more insight than the admin center gives you.
Microsoft 365 Advanced Analytics is an open-source engine that continuously collects enhanced usage data from across Microsoft 365 — SharePoint, Teams, Outlook, OneDrive, Viva Engage (Yammer), Copilot, Power Platform and more — into a single SQL database you own. Reporting and dashboards then build on that dataset, so you can analyse adoption, engagement and ROI in ways the built-in reports can't.
| Microsoft 365 built-in reports | Microsoft 365 Advanced Analytics | |
|---|---|---|
| History | Rolling 7–180 days | Keep as long as you want — you control retention |
| Data access | Locked in the admin center, limited export | One SQL database in your tenant — query it any way |
| Scope | Siloed per workload, pre-aggregated | Unified, joinable schema across every workload |
| Granularity | High-level counts | Page hits/clicks/sessions, per-call quality, per-email + sentiment, Copilot interactions, files & resources |
| People | Names often de-identified | Identifiable users enriched with department, manager, job title, office and license/SKU |
| Reporting | Microsoft's fixed report set | Your own Power BI & dashboards (templates included) |
| Enrichment | — | Optional AI sentiment, language & keyword detection |
- Measure real adoption by department, region, role or license — not just tenant-wide totals.
- See how SharePoint is actually used — page hits, sessions, link clicks, searches, performance, geography and device, down to the page.
- Track Copilot adoption & ROI — who's using it, in which apps and agents, against which files and resources.
- Right-size licensing with per-user, per-app usage history.
- Watch Teams call quality and meeting habits at the session level.
- Trend over years, not weeks, with history you keep.
Tip: the engine covers many workloads, and you may not need them all. Decide which areas of data collection you need first — that keeps the required permissions and prerequisites to a minimum. The full list is in What data is collected.
- Prerequisites — the service principals, permissions (Graph/Microsoft 365 API + Azure RBAC), and tenant/subscription configuration you need.
- Install with the installer — the standard, installer-driven deployment. (Prefer to do it by hand? See Manual installation.)
- Verify the deployment — confirm the import jobs are running.
Optional during install: private endpoints and certificate authentication.
- What data is collected — the full data-collection map across SharePoint, Teams, Outlook, OneDrive, Viva Engage, Copilot, Power Platform and more.
- Copilot analytics — the Copilot-specific stats and data recorded: app hosts, agents (including custom agents), accessed resources, AI models, response messages and estimated Copilot Credits, plus the tables they land in.
- Architecture & costs — the Azure components used, performance tiers, and indicative running costs.
- Database schema — the SQL tables the data lands in.
Some of these require additional configuration after the engine is installed (see Additional solutions).
- Activity & Usage Analytics — Power BI reporting over the collected dataset (see also the data model).
- Copilot Analytics — Copilot usage and adoption reporting.
- SharePoint Insights — an additional solution built on the engine (see the repository).
- Updating the solution
- Monitoring, health alerts and system performance
- Troubleshooting and known issues
-
Telemetry Service — a private, MSAL-protected dashboard (source under
src/TelemetryService/) that receives anonymous, opt-in usage telemetry from deployed analytics engines so the project team can see which versions, solutions and workloads are in active use. No tenant data is ever sent. Work in progress.
Use the sidebar for the full list of pages, grouped by topic.