Package: vivainsights 0.5.5

Martin Chan

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

Provides a versatile range of functions, including exploratory data analysis, time-series analysis, organizational network analysis, and data validation, whilst at the same time implements a set of best practices in analyzing and visualizing data specific to 'Microsoft Viva Insights'.

Authors:Martin Chan [aut, cre], Carlos Morales [aut]

vivainsights_0.5.5.tar.gz
vivainsights_0.5.5.zip(r-4.5)vivainsights_0.5.5.zip(r-4.4)vivainsights_0.5.5.zip(r-4.3)
vivainsights_0.5.5.tgz(r-4.4-any)vivainsights_0.5.5.tgz(r-4.3-any)
vivainsights_0.5.5.tar.gz(r-4.5-noble)vivainsights_0.5.5.tar.gz(r-4.4-noble)
vivainsights_0.5.5.tgz(r-4.4-emscripten)vivainsights_0.5.5.tgz(r-4.3-emscripten)
vivainsights.pdf |vivainsights.html
vivainsights/json (API)
NEWS

# Install 'vivainsights' in R:
install.packages('vivainsights', repos = c('https://microsoft.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/microsoft/vivainsights/issues

Datasets:
  • g2g_data - Sample Group-to-Group dataset
  • mt_data - Sample Meeting Query dataset
  • p2p_data - Sample person-to-person dataset
  • pq_data - Sample Person Query dataset

On CRAN:

6.00 score 11 stars 40 scripts 380 downloads 139 exports 96 dependencies

Last updated 4 days agofrom:2ade2f6553. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 19 2024
R-4.5-winOKNov 19 2024
R-4.5-linuxOKNov 19 2024
R-4.4-winOKNov 19 2024
R-4.4-macOKNov 19 2024
R-4.3-winOKNov 19 2024
R-4.3-macOKNov 19 2024

Exports:%>%afterhours_distafterhours_fizzafterhours_lineafterhours_rankafterhours_sumafterhours_summaryafterhours_trendanalysis_scopeanonymiseanonymizeany_idatecamel_cleancheck_inputscheck_querycollab_areacollab_distcollab_fizzcollab_linecollab_rankcollab_sumcollab_summarycollaboration_areacollaboration_distcollaboration_fizzcollaboration_linecollaboration_rankcollaboration_sumcollaboration_summarycollaboration_trendcommacopy_dfcreate_barcreate_bar_asiscreate_boxplotcreate_bubblecreate_densitycreate_distcreate_dtcreate_fizzcreate_histcreate_inccreate_incidencecreate_IVcreate_linecreate_line_asiscreate_lorenzcreate_period_scattercreate_rankcreate_rank_combinecreate_sankeycreate_scattercreate_stackedcreate_trackingcreate_trendcut_houremail_distemail_fizzemail_lineemail_rankemail_sumemail_summaryemail_trendexportexternal_distexternal_fizzexternal_lineexternal_rankexternal_sumexternal_summaryextract_date_rangeextract_hrflag_ch_ratioflag_em_ratioflag_extremeflag_outlooktimegenerate_reportgenerate_report2heat_colorsheat_colourshr_trendhrvar_counthrvar_count_allhrvar_trendidentify_churnidentify_datefreqidentify_holidayweeksidentify_inactiveweeksidentify_nkwidentify_outlieridentify_privacythresholdidentify_shiftsidentify_tenureimport_queryis_date_formatIV_reportjitter_metricskeymetrics_scankeymetrics_scan_asismaxminmeeting_distmeeting_fizzmeeting_linemeeting_rankmeeting_summeeting_summarymeeting_tm_reportmeeting_trendnetwork_g2gnetwork_p2pnetwork_summaryone2one_distone2one_fizzone2one_freqone2one_lineone2one_rankone2one_sumone2one_summaryone2one_trendp2p_data_simpad2pairwise_countread_preamblergb2hextheme_wpatheme_wpa_basictm_cleantm_cooctm_freqtm_wordcloudtotals_bindtotals_coltrack_HR_changetstampus_to_spacevalidation_reportwrapwrap_textxicor

Dependencies:base64encbslibcachemclicolorspacecommonmarkcpp11crosstalkcurldata.tabledigestdplyrDTevaluatefansifarverfastmapfontawesomefsgenericsggforceggplot2ggraphggrepelggwordcloudgluegraphlayoutsgridExtragridtextgtablehighrhtmltoolshtmlwidgetshttpuvigraphisobandjaneaustenrjpegjquerylibjsonliteknitrlabelinglaterlatticelazyevallifecyclemagrittrmarkdownMASSMatrixmemoisemgcvmimemunsellnetworkD3nlmepillarpkgconfigplyrpngpolyclippromisesproxypurrrR6rappdirsRColorBrewerRcppRcppArmadilloRcppEigenreshape2rlangrmarkdownsassscalesSnowballCstringistringrsystemfontstibbletidygraphtidyrtidyselecttidytexttinytextokenizerstweenrutf8vctrsviridisviridisLitewithrwpaxfunxml2yaml

Readme and manuals

Help Manual

Help pageTopics
Distribution of After-hours Collaboration Hours as a 100% stacked barafterhours_dist
Distribution of After-hours Collaboration Hours (Fizzy Drink plot)afterhours_fizz
After-hours Collaboration Time Trend - Line Chartafterhours_line
Rank groups with high After-Hours Collaboration Hoursafterhours_rank
Summary of After-Hours Collaboration Hoursafterhours_sum afterhours_summary
After-Hours Time Trendafterhours_trend
Anonymise a categorical variable by replacing valuesanonymise anonymize
Identify whether variable is an IDate class.any_idate
Convert "CamelCase" to "Camel Case"camel_clean
Check whether a data frame contains all the required variablecheck_inputs
Check a query to ensure that it is suitable for analysischeck_query
Collaboration - Stacked Area Plotcollaboration_area collab_area
Distribution of Collaboration Hours as a 100% stacked barcollaboration_dist collab_dist
Distribution of Collaboration Hours (Fizzy Drink plot)collaboration_fizz collab_fizz
Collaboration Time Trend - Line Chartcollaboration_line collab_line
Collaboration Rankingcollaboration_rank collab_rank
Collaboration Summarycollaboration_sum collaboration_summary collab_sum collab_summary
Collaboration Time Trendcollaboration_trend
Add comma separator for thousandscomma
Copy a data frame to clipboard for pasting in Excelcopy_df
Mean Bar Plot for any metriccreate_bar
Create a bar chart without aggregation for any metriccreate_bar_asis
Box Plot for any metriccreate_boxplot
Create a bubble plot with two selected Viva Insights metrics (General Purpose), with size representing the number of employees in the group.create_bubble
Create a density plot for any metriccreate_density
Horizontal 100 percent stacked bar plot for any metriccreate_dist
Create interactive tables in HTML with 'download' buttons.create_dt
Fizzy Drink / Jittered Scatter Plot for any metriccreate_fizz
Create a histogram plot for any metriccreate_hist
Create an incidence analysis reflecting proportion of population scoring above or below a threshold for a metriccreate_inc create_incidence
Compute Information Value for Predictive Variablescreate_IV
Time Trend - Line Chart for any metriccreate_line
Create a line chart without aggregation for any metriccreate_line_asis
Calculate the Lorenz Curve and Gini Coefficient in a Person Querycreate_lorenz
Period comparison scatter plot for any two metricscreate_period_scatter
Rank all groups across HR attributes on a selected Viva Insights metriccreate_rank
Create combination pairs of HR variables and run 'create_rank()'create_rank_combine
Create a sankey chart from a two-column count tablecreate_sankey
Create a Scatter plot with two selected Viva Insights metrics (General Purpose)create_scatter
Horizontal stacked bar plot for any metriccreate_stacked
Create a line chart that tracks metrics over time with a 4-week rolling averagecreate_tracking
Heat mapped horizontal bar plot over time for any metriccreate_trend
Convert a numeric variable for hours into categoricalcut_hour
Distribution of Email Hours as a 100% stacked baremail_dist
Distribution of Email Hours (Fizzy Drink plot)email_fizz
Email Time Trend - Line Chartemail_line
Email Hours Rankingemail_rank
Email Summaryemail_sum email_summary
Email Hours Time Trendemail_trend
Export 'vivainsights' outputs to CSV, clipboard, or save as imagesexport
Distribution of External Collaboration Hours as a 100% stacked barexternal_dist
Distribution of External Collaboration Hours (Fizzy Drink plot)external_fizz
External Collaboration Hours Time Trend - Line Chartexternal_line
Rank groups with high External Collaboration Hoursexternal_rank
External Collaboration Summaryexternal_sum external_summary
Extract date periodextract_date_range
Extract HR attribute variablesextract_hr
Flag unusual high collaboration hours to after-hours collaboration hours ratioflag_ch_ratio
Flag Persons with unusually high Email Hours to Emails Sent ratioflag_em_ratio
Warn for extreme values by checking against a thresholdflag_extreme
Flag unusual outlook time settings for work day start and end timeflag_outlooktime
Sample Group-to-Group datasetg2g_data
Generate HTML report with list inputsgenerate_report
Generate HTML report based on existing RMarkdown documentsgenerate_report2
Generate a vector of 'n' contiguous colours, as a red-yellow-green palette.heat_colors heat_colours
Employee count over timehr_trend
Create a count of distinct people in a specified HR variableanalysis_scope hrvar_count
Create count of distinct fields and percentage of employees with missing values for all HR variableshrvar_count_all
Track count of distinct people over time in a specified HR variablehrvar_trend
Identify employees who have churned from the datasetidentify_churn
Identify date frequency based on a series of datesidentify_datefreq
Identify Holiday Weeks based on outliersidentify_holidayweeks
Identify Inactive Weeksidentify_inactiveweeks
Identify Non-Knowledge workers in a Person Query using Collaboration Hoursidentify_nkw
Identify metric outliers over a date intervalidentify_outlier
Identify groups under privacy thresholdidentify_privacythreshold
Identify shifts based on outlook time settings for work day start and end timeidentify_shifts
Tenure calculation based on different input dates, returns data summary table or histogramidentify_tenure
Import a query from Viva Insights Analyst Experienceimport_query
Identify whether string is a date formatis_date_format
Generate a Information Value HTML ReportIV_report
Jitter metrics in a data framejitter_metrics
Run a summary of Key Metrics from the Standard Person Query datakeymetrics_scan
Run a summary of Key Metrics without aggregationkeymetrics_scan_asis
Max-Min Scaling Functionmaxmin
Distribution of Meeting Hours as a 100% stacked barmeeting_dist
Distribution of Meeting Hours (Fizzy Drink plot)meeting_fizz
Meeting Time Trend - Line Chartmeeting_line
Meeting Hours Rankingmeeting_rank
Meeting Summarymeeting_sum meeting_summary
Generate a Meeting Text Mining report in HTMLmeeting_tm_report
Meeting Hours Time Trendmeeting_trend
Sample Meeting Query datasetmt_data
Create a network plot with the group-to-group querynetwork_g2g
Perform network analysis with the person-to-person querynetwork_p2p
Summarise node centrality statistics with an igraph objectnetwork_summary
Distribution of Manager 1:1 Time as a 100% stacked barone2one_dist
Distribution of Manager 1:1 Time (Fizzy Drink plot)one2one_fizz
Frequency of Manager 1:1 Meetings as bar or 100% stacked bar chartone2one_freq
Manager 1:1 Time Trend - Line Chartone2one_line
Manager 1:1 Time Rankingone2one_rank
Manager 1:1 Time Summaryone2one_sum one2one_summary
Manager 1:1 Time Trendone2one_trend
Sample person-to-person datasetp2p_data
Simulate a person-to-person query using a Watts-Strogatz modelp2p_data_sim
Create the two-digit zero-padded formatpad2
Perform a pairwise count of words by idpairwise_count
Sample Person Query datasetpq_data
Read preambleread_preamble
Convert rgb to HEX codergb2hex
Main theme for 'vivainsights' visualisationstheme_wpa
Basic theme for 'vivainsights' visualisationstheme_wpa_basic
Clean subject line text prior to analysistm_clean
Analyse word co-occurrence in subject lines and return a network plottm_cooc
Perform a Word or Ngram Frequency Analysis and return a Circular Bar Plottm_freq
Generate a wordcloud with meeting subject linestm_wordcloud
Row-bind an identical data frame for computing grouped totalstotals_bind
Fabricate a 'Total' HR variabletotals_col
Sankey chart of organizational movement between HR attributes and missing values (outside company move) (Data Overview)track_HR_change
Generate a time stamptstamp
Replace underscore with spaceus_to_space
Generate a Data Validation report in HTMLvalidation_report
Add a character at the start and end of a character stringwrap
Wrap text based on character thresholdwrap_text
Calculate Chatterjee's Rank Correlation Coefficientxicor