Copilot analytics
Interactive Dashboards
Compare three synthetic AI usage dashboards and open a step-by-step guide with screenshots, query requirements and rendering commands.
Copilot Analytics / Interactive Dashboards
Explore three reports built with synthetic data. The demos open in a browser without installation. Each report also has a standalone guide with screenshots, expected outputs, required query exports and step-by-step commands.
Select Start using for the practical setup, a starter prompt and capability limits, or open a report’s Full guide for its complete walkthrough.
Synthetic data · R template
Business Leaders AI Usage
Who is using AI, how much, and how does usage vary over time and across groups?
Full guide for Business Leaders AI Usage Start using Business Leaders AI Usage
Synthetic data · R template
Copilot Consumption and Ways of Working
How is Copilot consumed, and how does consumption relate to collaboration?
Full guide for Copilot Consumption and Ways of Working Start using Copilot Consumption and Ways of Working
Synthetic data · R template
Developer Experience and Copilot
What do developer working conditions and joint Copilot use look like?
Full guide for Developer Experience and Copilot Start using Developer Experience and CopilotBusiness Leaders AI Usage
Synthetic data · R template
Explore four, eight or thirteen weeks by organisation, function and team. Reach counts distinct people across sources; recorded usage is per person per week across the full roster, including non-users.
View demo · Get source · Rendering and input requirements
Start using
- Open the synthetic demo in your browser. No installation is required.
- To render it locally, clone the whole repository so that the source, helpers and synthetic fixtures stay together. You will need Git, R and Pandoc (also supplied with RStudio).
git clone https://github.com/microsoft/viva-insights-sample-code.git
cd viva-insights-sample-code
R packages: dplyr, tidyr, jsonlite, knitr, rmarkdown. Install missing packages from your approved package source. For CRAN:
Rscript -e "install.packages(c('dplyr', 'tidyr', 'jsonlite', 'knitr', 'rmarkdown'), repos='https://cloud.r-project.org')"
Rscript -e "stopifnot(rmarkdown::pandoc_available())"
Run this from the repository root in a terminal:
New-Item -ItemType Directory -Force ..\copilot-dashboard-work\business-leaders
Rscript examples\utility-r\render-business-leaders-ai.R ..\copilot-dashboard-work\business-leaders\dashboard.html
Expected output: ..\copilot-dashboard-work\business-leaders\dashboard.html, outside the checkout so the tracked demo is not overwritten. It is a self-contained HTML file with four-, eight- and thirteen-week views, group comparisons and separate product credit rates.
Demo inputs: Person, M365 Copilot, Cowork, Agent, Consumption and GitHub Copilot fixtures.
Using real exports: Synthetic reference only. A real-data adaptation needs a separately implemented and verified mapping, coverage assessment and disclosure review.
Work with a coding agent
This report is not supported by the optional dashboard Skill runner. Ask your agent to use the dedicated renderer with this prompt:
Reproduce the synthetic Business Leaders AI Usage report from my local viva-insights-sample-code checkout at [path]. Read its rendering guide and use render-business-leaders-ai.R, not the dashboard Skill runner. Check dependencies first and ask before installing them. Save to a fresh output HTML path and report the command, validation and coverage limits.
Capability and interpretation: This is a synthetic reference, not a verified real-export adapter. Coverage is limited to observed usage within the Person Query roster. M365 Copilot credits and GitHub AI credits remain separate; descriptive comparisons do not establish causation.
Before sharing: review coverage and your organisation's privacy requirements, including data embedded in the HTML. Keep customer exports outside this repository.
Full dashboard details and caveats · Query and setup requirements · Query setup and joins
Copilot Consumption and Ways of Working
Synthetic data · R template
Separate credit volume from cost per session, explore concentration and heavy-user patterns, and compare services, organisations and functions in a seven-page report.
View demo · Get source · Rendering and input requirements
Start using
- Open the synthetic demo in your browser. No installation is required.
- To render it locally, clone the whole repository so that the source, helpers and synthetic fixtures stay together. You will need Git, R and Pandoc (also supplied with RStudio).
git clone https://github.com/microsoft/viva-insights-sample-code.git
cd viva-insights-sample-code
R packages: jsonlite, rmarkdown, flexdashboard, dplyr, tidyr, ggplot2, scales, knitr, stringr, vivainsights, ggrepel. Install missing packages from your approved package source. For CRAN:
Rscript -e "install.packages(c('jsonlite', 'rmarkdown', 'flexdashboard', 'dplyr', 'tidyr', 'ggplot2', 'scales', 'knitr', 'stringr', 'vivainsights', 'ggrepel'), repos='https://cloud.r-project.org')"
Rscript -e "stopifnot(rmarkdown::pandoc_available())"
Run this from the repository root in a terminal:
Rscript frontier-analytics\starter-kits\copilot-query-dashboard\dashboard.R reproduce frontier-analytics\starter-kits\copilot-query-dashboard\configs\demo-consumption.json
The demo configuration selects an output folder outside the checkout. Choose a fresh folder if it already exists. The runner refuses to overwrite a previous run.
Expected output: A seven-page synthetic HTML report, provenance.json and an isolated working copy under the configured output_dir\reproduce folder outside the repository.
Demo inputs: Five fixture files across Person, Consumption and GitHub queries; GitHub breakdown files are not used.
Using real exports: M365 credits by period and service, with optional grouping when the metadata supports it. Inspect the activity and matching people metadata first, approve exact mappings and confirm spending-policy additivity when required.
Work with a coding agent
Install the dashboard and analysis Skills from the same checkout. Keep the checkout because the Skill runs its R code.
From the parent folder containing your checkout:
gh skill install ./viva-insights-sample-code viva-insights-analysis --from-local --agent github-copilot --scope user
gh skill install ./viva-insights-sample-code viva-insights-copilot-dashboards --from-local --agent github-copilot --scope user
Reload the Skills in your agent, then replace [path] in this starter prompt:
Use the Copilot query dashboards Skill to reproduce the synthetic Consumption demo. My checkout is at [path]. Check dependencies before rendering and ask before installing them. Use a fresh private output directory, preserve the reference files, and return the HTML location, configuration, provenance and validation summary. Explain which demo panels are excluded from the real M365 credits-only adapter.
Capability and interpretation: The real-v1 runner supports only M365 credits from Consumption activity and matching people metadata, with explicit mapping approval. Sessions, Person Query associations and GitHub panels are not implemented by that adapter. Credit intensity does not measure value or quality.
Before sharing: review coverage and your organisation's privacy requirements, including data embedded in the HTML. Keep customer exports outside this repository.
Full dashboard details and caveats · Query and setup requirements · Query setup and joins
Developer Experience and Copilot
Synthetic data · R template
Compare collaboration, focus, after-hours activity and network breadth across three GitHub-intensity groups. Explore joint M365 and GitHub use while keeping observation and eligibility gaps visible.
View demo · Get source · Rendering and input requirements
Start using
- Open the synthetic demo in your browser. No installation is required.
- To render it locally, clone the whole repository so that the source, helpers and synthetic fixtures stay together. You will need Git, R and Pandoc (also supplied with RStudio).
git clone https://github.com/microsoft/viva-insights-sample-code.git
cd viva-insights-sample-code
R packages: jsonlite, rmarkdown, flexdashboard, dplyr, tidyr, ggplot2, scales, knitr, stringr, vivainsights. Install missing packages from your approved package source. For CRAN:
Rscript -e "install.packages(c('jsonlite', 'rmarkdown', 'flexdashboard', 'dplyr', 'tidyr', 'ggplot2', 'scales', 'knitr', 'stringr', 'vivainsights'), repos='https://cloud.r-project.org')"
Rscript -e "stopifnot(rmarkdown::pandoc_available())"
Run this from the repository root in a terminal:
Rscript frontier-analytics\starter-kits\copilot-query-dashboard\dashboard.R reproduce frontier-analytics\starter-kits\copilot-query-dashboard\configs\demo-github.json
The demo configuration selects an output folder outside the checkout. Choose a fresh folder if it already exists. The runner refuses to overwrite a previous run.
Expected output: A self-contained synthetic HTML report with Overview, Collaboration, Focus, After-hours, Network and additional breakdowns, plus provenance.json and isolated work files under output_dir\reproduce.
Demo inputs: Person, GitHub and Consumption fixtures, including GitHub feature, model and language breakdowns.
Using real exports: Readiness inspection only. The runner does not build this dashboard from real GitHub exports. Missing observation must not be relabelled as zero use or as lack of provisioning.
Work with a coding agent
Install the dashboard and analysis Skills from the same checkout. Keep the checkout because the Skill runs its R code.
From the parent folder containing your checkout:
gh skill install ./viva-insights-sample-code viva-insights-analysis --from-local --agent github-copilot --scope user
gh skill install ./viva-insights-sample-code viva-insights-copilot-dashboards --from-local --agent github-copilot --scope user
Reload the Skills in your agent, then replace [path] in this starter prompt:
Use the Copilot query dashboards Skill to reproduce the synthetic Developer Experience demo. My checkout is at [path]. Check dependencies and ask before installing them. Use a fresh private output directory and return the HTML location, configuration, provenance and validation summary. Keep the GitHub observation limits and privacy gates visible. If I later supply real exports, inspect readiness only because no verified real GitHub build adapter is supplied.
Capability and interpretation: No verified real GitHub dashboard adapter is supplied. Synthetic breakdown allocations are not verified real-export semantics. Acceptance rate is not code quality, after-hours activity is not burnout, and calendar space does not establish coding time.
Before sharing: review coverage and your organisation's privacy requirements, including data embedded in the HTML. Keep customer exports outside this repository.
Full dashboard details and caveats · Query and setup requirements · Query setup and joins
Build with your own data
The templates use R, not Python. Start by reproducing the synthetic example in the relevant guide, then choose a supported real-data path.
| Report | Real-data support |
|---|---|
| Business Leaders AI Usage | Synthetic reference only. No verified real-export adapter. |
| Consumption and Ways of Working | M365 credits-only build from Consumption activity and people metadata, with explicit mapping approval. |
| Developer Experience and Copilot | Input-readiness inspection only. No verified real GitHub dashboard adapter. |
For the two runner-supported demos, the Copilot query dashboards Skill guides reproduction, inspection and customisation. Joining Viva Insights queries explains query setup and integration. It does not expand the runner’s supported inputs.
Before sharing: apply your organisation’s privacy rules, review embedded data as well as visible charts, and retain coverage limitations. Credit consumption is not monetary cost or business value. Descriptive comparisons do not establish causal impact. Keep customer exports outside this repository.