microsoft / vivainsights

R library to analyze and visualize data from Viva Insights Analyst Experience

vivainsights

Analyze and Visualize Viva Leader Insights data

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

1. Run prebuilt analysis and visualizations off advanced insights data with settings for HR variables, privacy threshold, etc.

2. Leverage advanced analytics functions which are built for Viva Insights metrics

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

Related repositories

• Viva RMarkdown Report Marketplace
• Viva Insights Sample Code
• Viva Insights Zoom Integration
• Viva Insights OData Query Download
• Viva Insights R library (legacy)
• Viva Insights Python library

---

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?

⭐ Please star this repository to keep us going!

vivainsights's Issues

Feature request: doughnut plot

It might be cool to have a base function that users can take to generate doughnut visuals, like the following:

This visual would be especially useful to be embedded in a dashboard/report output.

This idea is inspired by the following post:
https://stackoverflow.com/questions/74569982/ggplot-create-dynamic-multi-kpis-donut-in-one-chart

Feature request: ability to change node shape

Ability to change node shape,

e.g. in ggraph to denote IC v. manager:

geom_node_point(aes(shape = TieOrigin_supervisor_indicator))...

Feature request: clustering coefficient

Ability to calculate node clustering coefficient, in a similar way as centralities

e.g. as in igraph:

cluster_coef <- transitivity(g, type="local")

Trend plot - Diverging colour map issue

Noticed difficulty in visualising the data in Trend plots due to the used diverging color map. Please refer below plots.

Feature request: provide public domain HR datasets

Ability to easily use a few public domain HR datasets so that users can try out the functions— the random graphs don’t work as well because they don’t seem to be distributed like a professional org would

e.g. as in 3.13 here: https://ona-book.org/viz-graphs.html

Feature request: allow specifying `PersonId` and `MetricDate` for `import_query()`

Currently, PersonId and MetricDate may not be in the exact spelling or case when exported from a localized Analyst experience.

Therefore, adding the ability in import_query() to rename these columns could enable versatility when such a scenario arises.

validation_report: pq_data

For validation report: While using pq_data under validation_report in vivainsights error is,

Error in rename():
! Can't rename columns that don't exist.
✖ Column Instant_Message_hours doesn't exist.

Kindly assist for sample data to use validation_report in vivainsights. Thanks

Feature request: apply color palette to node colors

Ability to easily customize the node color scheme, e.g. by applying a palette,

e.g. as in ggraph

custom_palette <- c("red", "blue", "green", "yellow")... ggraph(graph) + ... scale_color_manual(values = custom_palette) + ...

Line plot - X axis alignment correction

Noticed the last subplot of extreme right's X axis positioned above the rest of the subplots X axis positions.

Distribution plot - colour mapping not aligned with specified bins

When we specify the intended bins range to the functions - afterhours_dist(), collaboration_dist() and create_hist(), colour for the last two bins range is same, default bins is working perfect.

Please refer the below examples.

Ex:1 Same intensity of red colour displayed for 25 - 35 hours and 35 + hours range

Ex:2 Same intensity of red colour displayed for 10 - 15 hours and 15 + hours range, so not able to visualise the data

Ex:3 Default bins, no issue .