Learn R Programming

vivainsights

Overview

This is an R package for analyzing and visualizing data from Microsoft Viva Advanced Insights (previously Microsoft Workplace Analytics).

With the vivainsights package, you can...

Run prebuilt analysis and visualizations off advanced insights data with settings for HR variables, privacy threshold, etc.
Leverage advanced analytics functions which are built for Viva Insights metrics
Integrate analysis of Viva Insights data with your R workflow seamlessly

This library is compatible with the latest implementation of the Viva Insights Analyst Workbench. For the R library compatible with the legacy implementation, please visit the wpa package website or GitHub repository .

Installation

# Install from CRAN:
install.packages("vivainsights")

# Install development version from GitHub:
pak::pak("microsoft/vivainsights")

Usage

To get started with the package, please see the following links:

Cheatsheet

Also check out our package cheat sheet for a quick glimpse of what vivainsights offers:

Related repositories

Code of Conduct

We would ask you to please read the Microsoft Open Source Code of Conduct prior to engaging with this package.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

Finding this project useful?

:star: Please star this repository to keep us going!

Copy Link

Version

Install

install.packages('vivainsights')

Monthly Downloads

457

Version

0.6.1

License

MIT + file LICENSE

Maintainer

Martin Chan

Last Published

May 12th, 2025

Functions in vivainsights (0.6.1)

collaboration_trend

Collaboration Time Trend

Check a query to ensure that it is suitable for analysis

collaboration_area

Collaboration - Stacked Area Plot

collaboration_line

Collaboration Time Trend - Line Chart

Add comma separator for thousands

collaboration_fizz

Distribution of Collaboration Hours (Fizzy Drink plot)

Check whether a data frame contains all the required variable

collaboration_sum

Collaboration Summary

collaboration_rank

Collaboration Ranking

collaboration_dist

Distribution of Collaboration Hours as a 100% stacked bar

Create a density plot for any metric

Horizontal 100 percent stacked bar plot for any metric

create_bar_asis

Create a bar chart without aggregation for any metric

create_line_asis

Create a line chart without aggregation for any metric

Mean Bar Plot for any metric

Copy a data frame to clipboard for pasting in Excel

Fizzy Drink / Jittered Scatter Plot for any metric

Create interactive tables in HTML with 'download' buttons.

Calculate the Lorenz Curve and Gini Coefficient in a Person Query

create_rank_combine

Create combination pairs of HR variables and run 'create_rank()'

Create a sankey chart from a two-column count table

Distribution of Email Hours (Fizzy Drink plot)

Email Time Trend - Line Chart

Create a bubble plot with two selected Viva Insights metrics (General Purpose), with size representing the number of employees in the group.

Box Plot for any metric

Create an incidence analysis reflecting proportion of population scoring above or below a threshold for a metric

Create a histogram plot for any metric

Estimate an effect of intervention on every Viva Insights metric in input file by applying single-group Interrupted Time-Series Analysis (ITSA)

Time Trend - Line Chart for any metric

Compute Information Value for Predictive Variables

Email Hours Time Trend

create_tracking

Create a line chart that tracks metrics over time with a 4-week rolling average

Heat mapped horizontal bar plot over time for any metric

Export 'vivainsights' outputs to CSV, clipboard, or save as images

Generate a vector of n contiguous colours, as a red-yellow-green palette.

External Collaboration Summary

extract_date_range

Extract date period

External Collaboration Hours Time Trend - Line Chart

Email Hours Ranking

Create a count of distinct people in a specified HR variable

Rank groups with high External Collaboration Hours

hrvar_count_all

Create count of distinct fields and percentage of employees with missing values for all HR variables

Employee count over time

Track count of distinct people over time in a specified HR variable

Identify employees who have churned from the dataset

Jitter metrics in a data frame

keymetrics_scan

Run a summary of Key Metrics from the Standard Person Query data

Warn for extreme values by checking against a threshold

Flag Persons with unusually high Email Hours to Emails Sent ratio

Distribution of Email Hours as a 100% stacked bar

Convert a numeric variable for hours into categorical

Meeting Time Trend - Line Chart

identify_privacythreshold

Identify groups under privacy threshold

Meeting Hours Ranking

Distribution of External Collaboration Hours as a 100% stacked bar

Manager 1:1 Time Trend - Line Chart

Manager 1:1 Time Ranking

create_period_scatter

Period comparison scatter plot for any two metrics

Flag unusual high collaboration hours to after-hours collaboration hours ratio

Extract HR attribute variables

generate_report

Generate HTML report with list inputs

generate_report2

Generate HTML report based on existing RMarkdown documents

Rank all groups across HR attributes on a selected Viva Insights metric

Horizontal stacked bar plot for any metric

Create a Scatter plot with two selected Viva Insights metrics (General Purpose)

identify_shifts

Identify shifts based on outlook time settings for work day start and end time

Distribution of Meeting Hours as a 100% stacked bar

Distribution of External Collaboration Hours (Fizzy Drink plot)

flag_outlooktime

Flag unusual outlook time settings for work day start and end time

meeting_summary

Meeting Summary

meeting_tm_report

Generate a Meeting Text Mining report in HTML

Distribution of Meeting Hours (Fizzy Drink plot)

identify_outlier

Identify metric outliers over a date interval

Sample Group-to-Group dataset

Identify Non-Knowledge workers in a Person Query using Collaboration Hours

Plot Usage Segments over time

Row-bind an identical data frame for computing grouped totals

Import a query from Viva Insights Analyst Experience

identify_datefreq

Identify date frequency based on a series of dates

Identify whether a habitual behaviour exists over a given interval of time

keymetrics_scan_asis

Run a summary of Key Metrics without aggregation

identify_holidayweeks

Identify Holiday Weeks based on outliers

identify_inactiveweeks

Identify Inactive Weeks

Max-Min Scaling Function

Simulate a person-to-person query using a Watts-Strogatz model

Sample person-to-person dataset

network_summary

Summarise node centrality statistics with an igraph object

Distribution of Manager 1:1 Time as a 100% stacked bar

Fabricate a 'Total' HR variable

Identify whether string is a date format

Clean subject line text prior to analysis

Analyse word co-occurrence in subject lines and return a network plot

identify_tenure

Tenure calculation based on different input dates, returns data summary table or histogram

Meeting Hours Time Trend

Sample Meeting Query dataset

Create the two-digit zero-padded format

Perform a pairwise count of words by id

Replace underscore with space

Prepare variable names and types in query data frame for analysis

Sample Person Query dataset

Perform a Word or Ngram Frequency Analysis and return a Circular Bar Plot

Manager 1:1 Time Trend

Manager 1:1 Time Summary

track_HR_change

Sankey chart of organizational movement between HR attributes and missing values (outside company move) (Data Overview)

Generate a time stamp

Generate a wordcloud with meeting subject lines

identify_usage_segments

Identify Usage Segments based on a metric

Distribution of Manager 1:1 Time (Fizzy Drink plot)

Frequency of Manager 1:1 Meetings as bar or 100% stacked bar chart

Perform network analysis with the person-to-person query

Create a network plot with the group-to-group query

validation_report

Generate a Data Validation report in HTML

Main theme for 'vivainsights' visualisations

theme_wpa_basic

Basic theme for 'vivainsights' visualisations

Wrap text based on character threshold

Calculate Chatterjee's Rank Correlation Coefficient

Convert rgb to HEX code

vivainsights-package

vivainsights: Analyze and Visualize Data from 'Microsoft Viva Insights'

Add a character at the start and end of a character string

Generate a Information Value HTML Report

afterhours_dist

Distribution of After-hours Collaboration Hours as a 100% stacked bar

Identify whether variable is an IDate class.

afterhours_rank

Rank groups with high After-Hours Collaboration Hours

afterhours_fizz

Distribution of After-hours Collaboration Hours (Fizzy Drink plot)

afterhours_line

After-hours Collaboration Time Trend - Line Chart

Convert "CamelCase" to "Camel Case"

afterhours_trend

After-Hours Time Trend

Anonymise a categorical variable by replacing values

afterhours_summary

Summary of After-Hours Collaboration Hours