microsoft/AI-Business-Value

microsoft/AI-Business-Value

Description: Business Value of Copilot and Agents

Language: PowerShell

License: MIT

Stars: 3

Forks: 0

Open issues: 4

Created: 2026-05-10T22:57:12Z

Pushed: 2026-05-26T15:23:02Z

Default branch: main

Fork: no

Archived: no

README: > 🚨 April 2026 — Microsoft Graph Audit Log Query API permission change > Microsoft began enforcing a new permission for the /security/auditLog/queries endpoint. The broader AuditLog.Read.All scope is no longer sufficient on its own — AuditLogsQuery.Read.All is now required. > Symptom: scripts run successfully but CopilotInteraction queries silently return 0 records even when activity exists. > Fix: have your tenant admin grant AuditLogsQuery.Read.All to the app registration / consented account before running the scripts. See [scripts/readme.md](scripts/readme.md#permissions-april-2026-graph-api-change) for details.

> ⚠️ Support Notice > This repository is not supported through Microsoft support channels. Please report issues by opening an issue in this repo.

💼 AI Business Value Dashboard

This repository contains the AI Business Value Dashboard Power BI template. It quantifies the business value of Microsoft Copilot and agent activity — translating raw audit signals into hours saved, assisted value, and a defensible ROI narrative aligned to Microsoft's Frontier Firm framework.

---

📸 Dashboard Preview


*Animated walkthrough of all dashboard pages. Static page images are in [Images/pages/](Images/pages) and the source PDF is at [Images/source/AI Business Value Dashboard - Sample.pdf](Images/source/AI%20Business%20Value%20Dashboard%20-%20Sample.pdf).*

---

⚠️ Important usage & compliance disclaimer

Please note:

While this tool helps customers better understand the business value of their AI usage data, Microsoft has no visibility into the data that customers input into this template/tool, nor does Microsoft have any control over how customers will use this template/tool in their environment.

Customers are solely responsible for ensuring that their use of the template tool complies with all applicable laws and regulations, including those related to data privacy and security.

Microsoft disclaims any and all liability arising from or related to customers' use of the template tool.

Experimental Template Notice: This is an experimental template with audit logs as the primary source. The audit logs from Microsoft Purview are intended to support security and compliance use cases. While they provide visibility into Copilot and agent interactions, they are not intended to serve as the sole source of truth for licensing or full-fidelity reporting on Copilot activity.

---

📁 Choose your deployment path

Pick the path that matches your environment. Each folder is self-contained — README, PBIT/PBIP, and the scripts you need are all in one place.

| Path | Folder | Best when… | Volume ceiling | |---|---|---|---| | Manual | [1. Manual/](1.%20Manual/) | One-off, ad-hoc, or single-user. Customer manually exports audit CSV from Purview UI, drops into the local PBIT | 30 days of accumulated history but no Fabric. Folder iteration auto-unions all daily CSVs | Up to 180 days (Graph cap), heavier PBI memory footprint | | Fabric / Lakehouse | [3. Fabric/](3.%20Fabric/) | Have Fabric capacity. JSON parsing happens upstream in a notebook → best performance, multi-year history, sub-second dashboard | Millions of events, multi-year |

Inside each path:

• The PBIT/PBIP for that pattern (and a README explaining what parameters to fill in)
• scripts/interactive/ — manual one-shot PowerShell (admin signs in via browser)
• scripts/appreg/ — unattended app-registration scripts (service principal for scheduled jobs)
• scripts/azure/ *(SharePoint / Single File only)* — Bicep + runbooks for Azure Automation

Not sure which path? Most customers should start with SharePoint / Single File — it covers 80% of real deployments and avoids the data-combination errors that the Folder pattern is prone to. If you have Fabric capacity, Fabric / Lakehouse is the long-term home for any serious volume.

---

📊 What This Dashboard Provides

• Quantified business value of Copilot and agent activity — hours saved and dollar-equivalent assisted value, grounded in research-sourced time baselines
• Frontier Firm maturity view — where your organisation sits on the Pattern 1 (human + Copilot) → Pattern 2 (human + agent) → Pattern 3 (agents run workflows) journey
• Functional value breakdown — value per function (Sales, HR, IT, Legal, Finance, Marketing, Customer Service) with defensible task-level attribution
• Work archetype analysis — Copilot activity mapped to Creating, Finding, Consuming, Producing, Automating
• User maturity tracker — Beginner → Developing → Proficient progression using behavioural breadth, agent adoption, and active days
• Business case output — projected annualised value, ROI multiple, and licence investment net

---

🚀 How This Helps Leaders

• Build a defensible business case for continued Copilot investment — tie value directly to the KPIs your CFO, CHRO, and CIO already care about
• Identify Frontier Firm maturity by function — see which functions are stuck in Pattern 1 and where Pattern 3 autonomy is emerging
• Prioritise enablement investment — see which work archetypes and functions have the highest value potential
• Track progression over time — compare functional value and maturity quarter-on-quarter as adoption matures

---

✅ What You'll Do

Quick Overview: Export 3–4 data sources → Connect them to Power BI → Analyse your AI value

Choose Your Template

Two PBIT variants ship with this repo — pick one based on where your CSVs live:

| Template | Use when… | Data source format | |---|---|---| | `AI-Business-Value-Dashboard-29-04-csv-path.pbit` | CSVs sit on a local drive or network share, or you only need a one-off load | Direct file path per CSV | | `AI-Business-Value-Dashboard-29-04-sharepoint-refresh.pbit` | You want scheduled refresh in Power BI Service from SharePoint / OneDrive | SharePoint folder URL per data source |

> ⚠️ The SharePoint Refresh template needs four separate folders — one each for Interactions, Licensed Users, Org Data, and Agent 365. The Interactions query…