Skip to content

microsoft/Analytics-Hub

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

50 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation


🧠 Analytics Hub

Open-source analytics tools for Microsoft Copilot and AI adoption


Built by Microsoft Repositories


Browse the Toolkit ↓  ·  Find Your Tool ↓  ·  Data Sources ↓  ·  Case Studies ↓  ·  About the Team ↓



Eleven production-ready Power BI templates, add-ons, PowerShell automation, and browser-based tools built by Microsoft's Copilot ROI Advisory Team to help organizations — and individual practitioners — understand and demonstrate the impact of Microsoft Copilot and AI.

What Is This?

The Analytics Hub is a curated collection of open-source analytics tools from Microsoft designed for one purpose: to help organizations understand how their people are adopting Microsoft Copilot and AI, turning that understanding into action.

Each tool in this hub is a standalone, downloadable resource. Together, they form a complete analytics ecosystem that spans the full Copilot adoption journey, from license readiness, to active usage, to deep behavioral insights, all the way to measuring real business impact.

All tools are free, open-source, and link directly to original Microsoft repositories. No data is ever sent to Microsoft. Everything runs in your own environment.


🗺 The Ecosystem

There are three data source tracks and two ways to automate data collection. Understanding this upfront will save you a lot of time.

Analytics Hub Ecosystem Diagram

PAX is not a prerequisite for the Power BI templates. Every Purview-based report ships with its own lightweight scripts for template-specific data collection, and manual export from the Purview portal always works too. PAX is the right choice when you need enterprise automation, compliance-grade exports, no row limits, or want to land data in a lake or warehouse for use beyond these templates.


🎯 Which Tool Do I Need?

If you're asking... Use this tool Data source
Who are our Copilot super users, and how did they get there? Super Usage Adoption Viva Insights
What's the measurable impact of super users on work patterns? Super User Impact Viva Insights
How are people using Copilot Chat and Agents across our org? Copilot Chat & Agent Intelligence Purview + Entra
I want a single dashboard showing all Copilot and Agent activity AI-in-One Dashboard Purview + Entra
How are developers adopting GitHub Copilot? GitHub Copilot Impact GitHub Enterprise
What did I personally build with GitHub Copilot this week — and what's the leverage? What I Did: Copilot Impact Report Local Copilot sessions
Which users should get Copilot licenses next? M365 Copilot Readiness Purview + Entra
How do employees feel about Copilot, and does that match actual usage? Adoption & Sentiment Report M365 Admin Center + Survey
How do I automate pulling audit logs without manual exports? PAX: Portable Audit eXporter Microsoft Graph API
I want to model Copilot ROI scenarios from a CSV — no Power BI, no install M365 Copilot Productivity ROI Calculator CSV export (browser-only)
I want to add custom pages or extend my Viva Insights reports CustomizeCopilot Viva Insights

🛠 The Toolkit

Data Source Type Download

Who are your Copilot super users, and how do you make more of them?

This template uses Viva Insights organizational data to understand the path from first-time Copilot user to power user: what they use Copilot for, how quickly habits form, which teams are furthest along, and where to focus enablement efforts.

What you can explore
  • Super usage profile: What does super usage look like at your org? Which Copilot surfaces are driving the deepest engagement?
  • The journey: What did super users do differently in the early days? How fast are you producing them?
  • Work patterns: What behavioral signals are associated with super users? Any early signs of productivity shifts?
  • Change management: Where are super users concentrated? Which teams need enablement investment most?
Dashboard preview

Super Usage Dashboard Preview

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Download Repository  |  Interpretation Guide  |  📧 Email Prerequisites  |  ⭐ Star  |  👀 Watch


Data Source Type Download

What is the measurable impact of Copilot on how your super users work?

Goes beyond adoption metrics to measure actual impact on work patterns. This template explores behavioral changes associated with super users, along with estimated value delivered, and where available, sentiment signals. Cross-team comparisons and cohort-level views make it easier to build a business case for Copilot.

What you can explore
  • Impact measurement: Work pattern deltas before and after super user status emerges
  • Sentiment signals: Sentiment overlay (when available) to contextualize behavioral change
  • Estimated value: Quantified value estimates tied to time savings and collaboration shifts
  • Cross-team comparison: Benchmark super user cohorts across functions and orgs
  • Usage tiers: Static threshold-based tier classification for clearer benchmarking
Dashboard preview

Super User Impact Dashboard Preview

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Download Repository  |  📧 Email Prerequisites  |  ⭐ Star  |  👀 Watch


Data Source Type Download

Extend your Viva Insights reports with plug-and-play add-on pages without starting from scratch.

A growing library of modular Power BI pages that drop directly into the Super Usage Adoption and Super User Impact templates. Each add-on is pre-configured with its own measures and visuals, compatible with both templates, and maintained alongside the base reports.

Current add-ons

Champion ID Pages. Two person-level analytics pages for identifying your top Copilot champions. Shows individual usage rankings across all M365 apps, Copilot action breakdowns, network influence metrics (strong ties, diverse ties, internal network size), and temporal usage patterns. Ideal for peer training programs, recognition initiatives, and targeted coaching.

Compatible with Super User Adoption v5+ and Super User Impact v5+. Requires 25 measures, all included automatically in the latest template versions.

How to add pages to your report

Option A: Power BI Desktop (easiest):

  1. Open your base report and a second Power BI Desktop instance with the add-on file
  2. Right-click the page you want → Copy → paste into your base report
  3. Verify visuals load and save

Option B: Power BI Project files (.pbip):

  1. Copy the page folder from the add-on into your report's definition/pages/ directory
  2. Add the page GUID to pages.json
  3. Open in Power BI Desktop and verify

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Download Repository  |  ⭐ Star  |  👀 Watch


Data Source Data Source Type Download

Every Copilot and Agent interaction in one place, from licensed M365 Copilot to third-party AI.

Pulls from Purview audit logs to give you a single view of M365 Copilot usage, unlicensed Copilot Chat, and Agent activity across your organization. Covers adoption trends, license utilization, and readiness, all in one template.

New: The Agent Dashboard feature is now in public preview, providing one-click visibility into agent usage. Work with your IT admin to enable it.

What you can explore
  • Comprehensive coverage: M365 Copilot, unlicensed Copilot Chat, custom agents, and third-party AI apps (Confluence, Jira, Miro, and more)
  • User engagement tracking: Adoption trends over time across all Copilot surfaces
  • License intelligence: Licensed vs. unlicensed usage patterns to optimize allocation
  • Agent inventory: Full catalog of agents deployed in your tenant via the Agent Registry
  • Org segmentation: Slice any view by department, role, or custom attributes
  • Two setup paths: Manual portal export or fully automated PowerShell scripts
Dashboard preview

AI-in-One Dashboard Preview

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Interpretation Guide  |  📧 Email Prerequisites  |  ⭐ Star  |  👀 Watch


Data Source Data Source Type Download

Deep-dive analytics on Copilot Chat sessions and Agent adoption, with two purpose-built templates.

Where the AI-in-One Dashboard gives you the full picture, this repo goes deep on Chat and Agents specifically. The Chat Intelligence report breaks down prompt volume, session patterns, and engagement progression from light to habitual use. The Agent Intelligence report shows which agents are being used, by whom, and how adoption is trending.

Two templates, two lenses

Chat Intelligence: Prompts, sessions, surface breakdown, user engagement tiers, and licensing readiness signals across Copilot Chat.

Agent Intelligence: Agent adoption across licensed and free experiences, segmented by org, quartile, and surface. Identify adoption hotspots and quantify agent ROI.

Dashboard previews

Agent Intelligence:

Agent Intelligence Preview

Chat Intelligence:

Chat Intelligence Preview

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Agent Intelligence Guide  |  Chat Interpretation Guide  |  📧 Chat Email Prerequisites  |  📧 Agent Email Prerequisites  |  ⭐ Star  |  👀 Watch


Data Source Data Source Type Download

How are developers building habits with GitHub Copilot, and which teams are pulling ahead?

Built specifically for engineering orgs, this template connects GitHub Enterprise usage data with your Entra org structure so you can segment developer habit data by team. Track the shift to agentic coding, compare acceptance rates by language, monitor model adoption, and set team-level goals with bright-spot / hotspot views.

What you can explore
  • Adoption & engagement: Weekly active users, interaction volume, chat vs. agent mode split by team
  • Code impact: Acceptance rates, lines suggested and accepted, code generation trends over time
  • Language insights: Which languages see the highest acceptance? Which teams get the most value from specific languages?
  • Feature insights: How do code completion, agent mode, and inline edits compare in usage and acceptance?
  • Model insights: Which models are contributing to the codebase? Which are gaining new users?
  • Goal tracking: Set adoption targets per team, track progress, surface leading and lagging cohorts
Dashboard preview

GitHub Copilot Impact Preview

Full setup instructions and prerequisites are available in the repository.

View Repository  |  📧 Email Prerequisites  |  ⭐ Star  |  👀 Watch


Data Source Type Download

One command. See everything you built with Copilot — and the leverage you're getting from your seat.

The personal companion to the org-level templates in this hub. Reads your local GitHub Copilot session logs and produces a six-dimension impact report — goals, artifacts produced, skills augmented, collaboration style, activity heatmap, and time-saved estimates. Ships as a Copilot CLI agent and a standalone Python script. Optional AI narrative runs under your existing gh token via GitHub Models.

What you can explore
  • 🎯 Goals & leverage: What you actually worked on, and the lift Copilot gave you
  • 📦 Artifacts produced: Files created, modified, deleted — grouped by project
  • 🧠 Skills augmented: Which capabilities Copilot lifted (debug, refactor, doc, test, design)
  • 🤝 Collaboration style: How you partnered with Copilot — directing, pairing, reviewing
  • ⏰ Activity heatmap: When you worked, when you peaked, when you context-switched
  • 📐 Estimation evidence: Time-saved estimates backed by artifact + interaction signals

Ranges: --7D / --14D / --30D, single --date, or custom --from / --to. Optional --email opens an Outlook draft on Windows.

Sample report

What I Did sample report

Local-first. No telemetry. Optional AI uses your existing gh token. Full setup in the repository.

View Repository  |  Download Repository  |  ⭐ Star  |  👀 Watch


Data Source Data Source Type Download

Which users are most likely to get value from a Copilot license?

Uses M365 activity data to produce a ranked, prioritized view of user readiness, so licenses can be allocated to the people best positioned to use them. A composite Licensing Priority (LP) score blends M365 activity across Teams, Outlook, Word, Excel, and PowerPoint, and adjustable weighting sliders let you model different licensing scenarios instantly.

7 report pages
Page What it shows
M365 Executive Summary Tenant-level KPIs: total users, active Copilot users, aggregate M365 activity by workload
M365 Usage Trends Week-over-week trend lines per app with tier distribution matrix
Copilot License Recommendations Every user ranked by composite LP score with adjustable weighting profiles
Copilot Enablement Strategy 2×2 quadrant: Champions, Enablement Targets, AI-First, Low Engagement
Copilot Enablement Strategy Tiers Priority tiers (Critical → Low) based on M365-to-Copilot engagement gap
M365 Usage Activity Engagement segments (Daily / Frequent / Moderate / Infrequent / Inactive) by department
Glossary & Metric Definitions Every metric, threshold, and scoring method defined. No separate docs needed.

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Download Repository  |  📧 Email Prerequisites  |  ⭐ Star  |  👀 Watch


Data Source Data Source Type Download

How do adoption levels and employee sentiment correlate across your organization?

Combines Microsoft 365 Copilot usage data from the Admin Center with employee survey responses to give a complete picture of adoption, satisfaction, and self-reported time savings. Four dedicated report pages surface where perception diverges from reality and help focus enablement efforts on the right teams.

What you can explore
  • Adoption Overview: Licensed users, active users, and month-over-month usage trends broken down by org and usage tier (Bottom 25% through Top 10%)
  • Sentiment Analysis: Correlate survey scores with actual Copilot activity — satisfaction, speed, quality, productivity, readiness, and agents — to surface org-level outliers
  • Comments Analysis: Free-text survey responses organized by use cases, time repurposing, barriers to adoption, and open-ended feedback — with Copilot in Power BI narrative (PPU required)
  • Saved Time Analysis: Self-reported daily time savings alongside actual usage levels, broken down by usage tier to understand where and how Copilot delivers value
Dashboard preview

Adoption Overview

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Download Repository  |  ⭐ Star  |  👀 Watch


Live Site Type Data Source Download

Drop in your Copilot usage CSV. See team-level ROI in seconds — all in your browser.

A three-tool suite that translates Copilot usage data into a defensible ROI conversation — without Power BI Desktop, without a tenant, without uploading data anywhere. Pairs naturally with Super Usage Adoption: export the heatmap as CSV, drop it in, and get per-team breakdowns, scenario modeling, and a phased adoption roadmap.

Three tools, one site
  • 📊 Full Data Analysis: Upload a CSV exported from your Copilot Power BI heatmap. Per-team performance, peak tracking, and organization-wide ROI
  • 🧮 ROI Calculator: Scenario-model projected value with industry-specific hourly rates and adjustable minutes-saved-per-action assumptions
  • 🗜 Adoption Journey: Month-by-month productivity projections with phase-based rollout roadmaps

Handles both long-format (with dates, auto-aggregated to the latest record per team) and wide-format (pre-aggregated) CSVs. Sortable tables, PDF export, optional email-draft handoff.

Open the live site

👉 https://jordankingisalive.github.io/CopilotROICalculator/

No install, no login. Works in Chrome, Edge, Firefox, and Safari. After first load the service worker caches it for offline use.

🔒 Browser-only and private. CSV parsing and ROI calculations run entirely client-side via JavaScript. No data is sent to any server. Close the tab and everything is cleared from memory. Safe for sensitive enterprise data.

Full setup instructions, CSV format reference, and ROI formula are in the repository.

Open Live Site  |  View Repository  |  Download Repository  |  ⭐ Star  |  👀 Watch


Type API Download

PowerShell scripts for automating Copilot audit log exports from Microsoft Purview and Graph API.

PAX is used by several Purview-based tools in this hub. Three scripts that retrieve the audit log data the templates need, with pagination, rate limiting, retry logic, and incremental watermark state management built in. No manual portal work required, and no row limits.

Three scripts, three use cases

PAX_Purview_Audit_Log_Processor: Retrieves Copilot interaction audit records from Purview via Graph API or Exchange Online Management. Supports CopilotInteraction, AIInteraction, ConnectedAIAppInteraction, AIAppInteraction, and the full M365 Usage Bundle (Teams, Exchange, SharePoint, OneDrive). Also includes Copilot license data and AI agent type detection.

PAX_CopilotInteractions_Content_Audit_Log_Processor: Retrieves the actual content of Copilot interactions: user prompts and AI responses from the Graph API aiInteraction resource type. Features incremental exports, parallel processing for enterprise scale, and Entra ID user enrichment.

PAX_Graph_Audit_Log_Processor: Retrieves Copilot usage data and comprehensive audit records directly from Microsoft Graph API with full Entra user and org enrichment.

Why automate?
Manual Export PAX Script
50K–100K row limit per export No row limits, retrieves everything
Must sit at keyboard and wait Runs fully unattended
Re-start from scratch if interrupted Automatically resumes from where it stopped
One-time point-in-time export Schedulable for automated daily/weekly refresh
Separate steps for each data source Single script run pulls all required files

⚠️ Important: PAX exports may include highly sensitive data including user prompts and AI responses. Review the compliance and security guidance before deploying.

Full setup instructions and prerequisites are available in the repository.

View Repository  |  Download Latest Script  |  ⭐ Star  |  👀 Watch


📡 Data Sources at a Glance

Each tool in this hub requires data from one or more Microsoft admin portals. Here's a quick reference:

Data Source What It Provides Who Needs It Access Required
Microsoft Purview Copilot interaction audit logs, third-party AI logs, M365 workload activity AI-in-One, Chat & Agent, M365 Readiness, PAX Audit Reader or Compliance Admin
Viva Insights Person-level behavioral metrics, collaboration patterns, Copilot usage metrics Super Usage Adoption, Super User Impact Insights Analyst
Microsoft Entra User attributes, department, org hierarchy, Copilot license status AI-in-One, Chat & Agent, M365 Readiness, GitHub Copilot Impact User Administrator or Global Reader
M365 Admin Center Copilot licensed user list, Agent Registry export, Copilot Activity report AI-in-One, Chat & Agent, Adoption & Sentiment Global Admin or Reports Reader
GitHub Enterprise Copilot usage insights, member list, agent mode stats GitHub Copilot Impact Enterprise Owner

The PAX scripts can automate the Purview and Entra exports, removing the need for manual portal navigation after initial setup.


🚀 Get Started

New to the toolkit?

Step 1: Pick your starting question using the Which Tool Do I Need? table above.

Step 2: Check your data access. Each tool's repository has a detailed prerequisites section. Most require admin-level access to at least one Microsoft portal.

Step 3: Download the template. Every repo has a direct download link for the .pbit Power BI template file. Open it in Power BI Desktop, paste in your data file paths, and you're running.

Step 4: Use the interpretation guides. Several repos include PDF guides and storyboard PPTX templates to help you present findings to stakeholders.

Automate your data collection

For a single report: use the built-in scripts that ship with each template. AI-in-One, for example, includes its own PowerShell scripts and Azure Automation runbooks designed to pull exactly what that report needs.

For enterprise scale: use PAX when you need compliance-grade exports, no row limits, scheduled pipelines, or want to land data in a lake, warehouse, or any tool beyond Power BI. PAX is a standalone tool that works independently of the templates.

Automate PowerPoint output

pbi-to-exec-deck is a separate tool that converts Power BI report outputs into PowerPoint presentations. It can save time if you regularly need to share findings outside of Power BI.


🔗 Quick Links

Repository Description Download Star Watch
DecodingSuperUsage Super Usage Adoption ↓ ZIP 👀
superuserimpact Super User Impact Report ↓ ZIP 👀
customizecopilot Power BI Add-on Library ↓ ZIP 👀
AI-in-One-Dashboard All-up Copilot & Agent Dashboard ↓ ZIP 👀
CopilotChatAnalytics Chat & Agent Intelligence ↓ ZIP 👀
GitHubCopilotImpact GitHub Copilot Developer Analytics ↓ ZIP 👀
What-I-Did-Copilot Personal Copilot Impact Report (CLI) ↓ ZIP 👀
M365UsageAnalytics Copilot Readiness & License Strategy ↓ ZIP 👀
copilot-adoption-sentiment-report Adoption & Sentiment Report ↓ ZIP 👀
CopilotROICalculator Browser ROI Calculator (live site) ↓ ZIP 👀
PAX Audit Log Automation Scripts ↓ Latest Release 👀

Star bookmarks the repo and helps others discover it  ·  👀 Watch sends you a notification when new versions are released


📋 Client Stories

Our team works directly with organizations to help them measure and understand their AI investments. Below are published case studies from some of those engagements.

Organization Summary Link
EPAM Deployed Copilot across 2,000+ employees and achieved a 20% reduction in external collaboration hours within six months, combining custom analytics with proactive license optimization. Read
Wipro Microsoft research featuring Wipro's outcome-driven approach to AI agents, showing that teams who align on desired outcomes are 1.9x more likely to become high-frequency agentic AI users. Read
NHS A Microsoft 365 Copilot pilot across 90 NHS organizations found AI-powered administrative support could save staff approximately 43 minutes per day, with significant system-wide potential if scaled. Read
Allegis Group 18,000+ employees saved 150,000 hours and achieved $1.5M in translation cost savings after deploying Microsoft 365 Copilot and Azure AI Services across the organization. Read
Allegis Group A leadership blueprint for how Allegis Group structured their AI rollout, including reducing PTO processing time from 31 hours to 13 hours and building repeatable frameworks for AI-driven innovation. Read
Lloyds Banking Group Rolled out 30,000 Microsoft 365 Copilot licenses with 93% daily usage rates, measurable productivity gains across routine tasks, and a 50% improvement in software development cycle times. Read

If you are interested in working with our team on your own Copilot analytics and AI measurement journey, reach out to us at copilot-roi-advisory-team-gh@microsoft.com.


👥 About the Team

This hub and all linked repositories are maintained by the Microsoft Copilot ROI Advisory Team, a group of analysts, engineers, and advisors dedicated to helping organizations measure and accelerate the impact of Microsoft AI.

Name Role
Shailendra Hegde Principal Product Manager
Fernando Berdugo Manzano Copilot Incubation & ROI Advisor
Stephanie Downey, Ph.D. Principal Copilot Analytics Consultant
Jordan King Solutions Architect, Incubation and Growth
Luz Lorenz Copilot ROI & Org Advisory
Keith McGrane Copilot & Value Advisory
Brian Middendorf AI Business Value Advisor
Olivier Pecheux AI Transformation Advisory
Stephanie Smith Copilot ROI & Org Advisory
Jennifer Stoll Principal Business Value Advisor

📧 Feedback, questions, or ideas: copilot-roi-advisory-team-gh@microsoft.com


🤓 Nerd Corner

Clone all repos, set up your editor, and analyze with AI

Step 1: Clone all repos in one shot

PowerShell (Windows, recommended for this toolkit):

$repos = @(
    "DecodingSuperUsage",
    "superuserimpact",
    "customizecopilot",
    "AI-in-One-Dashboard",
    "CopilotChatAnalytics",
    "GitHubCopilotImpact",
    "What-I-Did-Copilot",
    "M365UsageAnalytics",
    "PAX"
)
foreach ($repo in $repos) {
    git clone "https://github.com/microsoft/$repo"
}
git clone "https://github.com/olivierpecheux/copilot-adoption-sentiment-report"
git clone "https://github.com/jordankingisalive/CopilotROICalculator"

Bash / macOS / Linux:

for repo in DecodingSuperUsage superuserimpact customizecopilot \
  AI-in-One-Dashboard CopilotChatAnalytics GitHubCopilotImpact \
  What-I-Did-Copilot M365UsageAnalytics PAX; do
  git clone "https://github.com/microsoft/$repo"
done
git clone "https://github.com/olivierpecheux/copilot-adoption-sentiment-report"
git clone "https://github.com/jordankingisalive/CopilotROICalculator"

Step 2: Open in your editor

# VS Code
code .

# Cursor
cursor .

# Claude Code
claude

All repos will be visible in the file explorer. Each has its own README, PDF guides, PowerShell scripts, PPTX storyboards, and .pbit templates ready to explore.


Step 3: Drop this prompt into your AI tool

Once cloned and open, paste this into Claude Code, Cursor, Copilot, or your AI tool of choice to get an immediate deep-dive across all repos:

I've cloned the following Microsoft Analytics Hub repositories locally:

- DecodingSuperUsage: Copilot super user adoption analysis (Viva Insights + Power BI)
- superuserimpact: Super user work pattern impact measurement (Viva Insights + Power BI)
- customizecopilot: Plug-and-play Power BI add-on pages for the above templates
- AI-in-One-Dashboard: All-up Copilot + Agent dashboard (Purview audit logs + Power BI)
- CopilotChatAnalytics: Chat and Agent intelligence reports (Purview + Power BI)
- GitHubCopilotImpact: GitHub Copilot developer analytics (GitHub API + Power BI)
- What-I-Did-Copilot: Personal Copilot impact report (CLI + Python; reads local Copilot session logs)
- M365UsageAnalytics: Copilot license readiness and M365 usage scoring (Purview + Power BI)
- copilot-adoption-sentiment-report: M365 Copilot adoption combined with employee survey sentiment (M365 Admin Center + survey CSV + Power BI)
- PAX: PowerShell scripts for automating Purview and Graph API audit log exports
- CopilotROICalculator: Browser-only ROI calculator and scenario modeler (CSV in; runs at https://jordankingisalive.github.io/CopilotROICalculator/)

Please read all README files, PDF interpretation guides, PowerShell scripts, and
any other documentation across these repositories. Then:

1. Summarize what each tool does and how they connect to each other
2. Identify which tools I should set up first based on data I have available
3. Flag all prerequisites, permissions, and dependencies I need to arrange
4. Suggest a setup sequence to get maximum value with minimum effort
5. Identify any gaps (questions these tools don't yet answer)
6. Highlight anything in the documentation that could be clearer or improved

Step 4: Supercharge your editor with MCP servers

MCP (Model Context Protocol) servers extend AI tools like Claude Code and Cursor to natively read, write, and reason over specific file types. These are the most valuable ones for working across this repo collection:

MCP Server Why it's useful here
Filesystem Read any local file across all cloned repos without copying paths manually
GitHub Browse issues, PRs, releases, and commit history without leaving your editor
PDF Read interpretation guides and methodology PDFs directly in your AI tool
DOCX Parse Word setup docs and troubleshooting guides
PPTX Extract content from storyboard and exec deck templates
XLSX Inspect Excel exports and data model files
Doc Co-authoring Draft new setup guides, exec summaries, or onboarding docs grounded in repo content
Power BI Interact with published reports, datasets, and workspaces via the Power BI REST API

For Claude Code users: install MCP servers via:

# Official filesystem and GitHub servers
claude mcp add filesystem -- npx -y @modelcontextprotocol/server-filesystem /path/to/your/repos
claude mcp add github -- npx -y @modelcontextprotocol/server-github

# Document servers (PDF, DOCX, PPTX, XLSX)
# See: https://github.com/microsoft/markitdown for universal document parsing

For VS Code / Cursor users: add MCP servers in your editor's settings or via the MCP extension marketplace. See the MCP server registry for the full list of available servers and install instructions.


🔔 Stay Updated

The toolkit grows as new tools are released. The best way to stay current:

  • Star this hub to bookmark it and help others discover it
  • 👀 Watch this hub to get notified when new repos are added
  • Use the Star and Watch links on each repo card above to follow the tools that matter most to you


Built with care by the Microsoft Copilot ROI Advisory Team  ·  All tools are open-source under the MIT License


About

A central hub for analytics resources, linking to repositories, guides, and templates leveraging MAC, Purview, and Viva Insights.

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages