Home

Welcome to the Microsoft 365 Advanced Analytics project home.

This is an analytics engine that extracts much more analytics from Microsoft 365 than is available out of the box. At its core is an ingestion engine that collects enhanced Microsoft 365 usage data and stores it in a single SQL Server database. Reporting and dashboards then build on that dataset to offer enhanced functionality and insights.

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.

Start here

1. Prerequisites — the service principals, permissions (Graph/Microsoft 365 API + Azure RBAC), and tenant/subscription configuration you need.
2. Install with the installer — the standard, installer-driven deployment. (Prefer to do it by hand? See Manual installation.)
3. Verify the deployment — confirm the import jobs are running.

Optional during install: private endpoints and certificate authentication.

Understand the solution

• What data is collected — the full data-collection map across SharePoint, Teams, Outlook, OneDrive, Yammer, Copilot, Power Platform and more.
• Architecture & costs — the Azure components used, performance tiers, and indicative running costs.
• Database schema — the SQL tables the data lands in.

Solutions built on the engine

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).

Operate & maintain

• Updating the solution
• Monitoring, health alerts and system performance
• Troubleshooting and known issues

Related projects in this repository

• 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.