Workplace Analytics March 2021 feature updates

Published 03-16-2021 09:00 AM 1,057 Views
Microsoft

Last month, we used this space to announce Microsoft Viva Insights, part of the broader Microsoft Viva initiative that’s empowering and connecting employees in new ways in our evolving digital age. (You can this and other past blog articles here). In addition to Viva Insights, the Workplace Analytics team has introduced other feature updates over the past few weeks. Today’s update describes expanded support of worldwide languages in query results and the release of an R package for Workplace Analytics.

 

  • UTF-8 encoded characters allowed in metric names
  • Open-source R package for Workplace Analytics

 

UTF-8-encoded characters allowed in metric names

When you define a query, you select metrics and organizational-data attributes. After the query runs, its results are organized into columns and rows. The column headers in the results match the attribute names and metric names that you selected while defining the query.

Before this update, metric names that were in any character set other than Latin appeared garbled in column headers in query and OData output. This caused some customers to develop downstream apps or clients that anticipated and processed that output to make it consumable. 

Now, this is no longer necessary. With this update, the names of metrics that you select while building a query can now be in any UTF-8 encoded character set – in other words, in the language of your choice. 

In the following example of a query-result file that's been opened in Excel, metric names that the customer input in Japanese have remained in Japanese, while attribute names were uploaded in English and remain in English: 

 

Paul_Schafer_0-1615841641637.png

 

 

For more information, see Supported languages for column headers.

 

Open-source R package for Workplace Analytics

Paul_Schafer_1-1615841641644.png

The M365 Insights team is pleased to share the first open-source release of Workplace Analytics shareable code, the wpa R package.

Note: R is an open-source statistical programming language and one of the most popular toolkits for data analysis and data science. For users of the R language, a “package” is a unit of sharable code that’s organized into libraries.

The wpa R package is a flexible repository of more than 100 functions that provide pre-built analyses in a single curated package. With this release, customer and partner analysts can go beyond the popular insights that Power BI templates and Workplace Analytics queries make available. They can help leaders go deeper and solve more specific problems by defining, scoping, and executing custom analyses.

 

Analyst objectives

This R package can be used by analysts and data scientists who are intermediate-to-advanced users of R or Python. With the wpa package, an analyst can:

  • Run prebuilt analysis and visualizations of Workplace Analytics data with the ability to make settings to use organizational data variables and maintain privacy thresholds. They can easily export these outputs into any format required, including clipboard (copy & paste), Excel, .csv, and – for plots – .png, .svg, and .pdf.

  • Validate data prior to analysis by running a data validation report, which performs systematic checks on metrics, organizational attributes, and meeting subject lines. The data-validation functions promote good practices of checking for patterns such as public holidays, non-knowledge workers, outliers, and missing values in the data to improve the quality and reliability of analysis. 

  • Generate prebuilt interactive HTML reports, which includes reports on data validation, subject-line text mining, and key collaboration metrics.

  • Leverage advanced analytics functions, such as text mining, network analysis, and hierarchical clustering, all designed specifically for Workplace Analytics metrics.

 

r-package-2.gif

The user experience in creating Workplace Analytics visuals in R

Additional resources:

1 Comment
Frequent Contributor

Thanks for posting the updates to Workplace Analytics in the Tech Community. Great to see the query functionality now has support for the characters we use across the globe with the UTF-8-encoded characters!

%3CLINGO-SUB%20id%3D%22lingo-sub-2211886%22%20slang%3D%22en-US%22%3EWorkplace%20Analytics%20March%202021%20feature%E2%80%AFupdates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2211886%22%20slang%3D%22en-US%22%3E%3CP%3ELast%20month%2C%20we%20used%20this%20space%20to%20announce%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fworkplace-analytics-myanalytics%2Fintroducing-microsoft-viva-insights-create-a-culture-where%2Fba-p%2F2110255%22%20target%3D%22_blank%22%3EMicrosoft%20Viva%20Insights%3C%2FA%3E%2C%20part%20of%20the%20broader%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fblog%2F2021%2F02%2F04%2Fmicrosoft-viva-empowering-every-employee-for-the-new-digital-age%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%20Viva%3C%2FA%3E%20initiative%20that%E2%80%99s%20empowering%20and%20connecting%20employees%20in%20new%20ways%20in%20our%20evolving%20digital%20age.%20(You%20can%20this%20and%20other%20past%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FWorkplace-Analytics-MyAnalytics%2Fbg-p%2FOffice365AnalyticsBlog%22%20target%3D%22_blank%22%3Eblog%20articles%20here%3C%2FA%3E).%20In%20addition%20to%20Viva%20Insights%2C%20the%20Workplace%20Analytics%20team%20has%20introduced%20other%20feature%20updates%20over%20the%20past%20few%20weeks.%20Today%E2%80%99s%20update%20describes%20expanded%20support%20of%20worldwide%20languages%20in%20query%20results%20and%20the%20release%20of%20an%20R%20package%20for%20Workplace%20Analytics.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EUTF-8%20encoded%20characters%20allowed%20in%20metric%20names%3C%2FLI%3E%0A%3CLI%3EOpen-source%20R%20package%20for%20Workplace%20Analytics%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--499285900%22%20id%3D%22toc-hId--499285900%22%20id%3D%22toc-hId--499372298%22%3EUTF-8-encoded%20characters%20allowed%20in%20metric%20names%3C%2FH2%3E%0A%3CP%3EWhen%20you%20define%20a%20query%2C%20you%20select%20metrics%20and%20organizational-data%20attributes.%20After%20the%20query%20runs%2C%20its%20results%20are%20organized%20into%20columns%20and%20rows.%20The%20column%20headers%20in%20the%20results%20match%20the%20attribute%20names%20and%20metric%20names%20that%20you%20selected%20while%20defining%20the%20query.%3C%2FP%3E%0A%3CP%3EBefore%20this%20update%2C%20metric%20names%20that%20were%20in%20any%20character%20set%20other%20than%20Latin%20appeared%20garbled%20in%20column%20headers%20in%20query%20and%20OData%20output.%20This%20caused%20some%20customers%20to%20develop%20downstream%20apps%20or%20clients%20that%20anticipated%20and%20processed%20that%20output%20to%20make%20it%20consumable.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%2C%20this%20is%20no%20longer%20necessary.%20With%20this%20update%2C%20the%20names%20of%20metrics%20that%20you%20select%20while%20building%20a%20query%20can%20now%20be%20in%20any%20UTF-8%20encoded%20character%20set%20%E2%80%93%20in%20other%20words%2C%20in%20the%20language%20of%20your%20choice.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20following%20example%20of%20a%20query-result%20file%20that's%20been%20opened%20in%20Excel%2C%20metric%20names%20that%20the%20customer%20input%20in%20Japanese%20have%20remained%20in%20Japanese%2C%20while%20attribute%20names%20were%20uploaded%20in%20English%20and%20remain%20in%20English%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Paul_Schafer_0-1615841641637.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263856i31328074AB7125B7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Paul_Schafer_0-1615841641637.png%22%20alt%3D%22Paul_Schafer_0-1615841641637.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20information%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fworkplace-analytics%2Fuse%2Fview-download-and-export-query-results%23supported-languages-for-column-headers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESupported%20languages%20for%20column%20headers%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1988226933%22%20id%3D%22toc-hId-1988226933%22%20id%3D%22toc-hId-1988140535%22%3EOpen-source%20R%20package%20for%20Workplace%20Analytics%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Paul_Schafer_1-1615841641644.png%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263855iA630B2EC5729F0B9%2Fimage-size%2Fsmall%3Fv%3Dv2%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22Paul_Schafer_1-1615841641644.png%22%20alt%3D%22Paul_Schafer_1-1615841641644.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20M365%20Insights%20team%20is%20pleased%20to%20share%20the%20first%20open-source%20release%20of%20Workplace%20Analytics%20shareable%20code%2C%20the%20%3CSTRONG%3Ewpa%20R%20package%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%20R%20is%20an%20open-source%20statistical%20programming%20language%20and%20one%20of%20the%20most%20popular%20toolkits%20for%20data%20analysis%20and%20data%20science.%20For%20users%20of%20the%20R%20language%2C%20a%20%E2%80%9Cpackage%E2%80%9D%20is%20a%20unit%20of%20sharable%20code%20that%E2%80%99s%20organized%20into%20libraries.%3C%2FP%3E%0A%3CP%3EThe%20wpa%20R%20package%20is%20a%20flexible%20repository%20of%20more%20than%20100%20functions%20that%20provide%20pre-built%20analyses%20in%20a%20single%20curated%20package.%20With%20this%20release%2C%20customer%20and%20partner%20analysts%20can%20go%20beyond%20the%20popular%20insights%20that%20Power%20BI%20templates%20and%20Workplace%20Analytics%20queries%20make%20available.%20They%20can%20help%20leaders%20go%20deeper%20and%20solve%20more%20specific%20problems%20by%20defining%2C%20scoping%2C%20and%20executing%20custom%20analyses.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1616178889%22%20id%3D%22toc-hId--1616178889%22%20id%3D%22toc-hId--1616265287%22%3EAnalyst%20objectives%3C%2FH3%3E%0A%3CP%3EThis%20R%20package%20can%20be%20used%20by%20analysts%20and%20data%20scientists%20who%20are%20intermediate-to-advanced%20users%20of%20R%20or%20Python.%20With%20the%26nbsp%3B%3CSTRONG%3Ewpa%3C%2FSTRONG%3E%26nbsp%3Bpackage%2C%20an%20analyst%20can%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3ERun%20prebuilt%20analysis%20and%20visualizations%3C%2FSTRONG%3E%26nbsp%3Bof%20Workplace%20Analytics%20data%20with%20the%20ability%20to%20make%20settings%20to%20use%20organizational%20data%20variables%20and%20maintain%20privacy%20thresholds.%20They%20can%20easily%20export%20these%20outputs%20into%20any%20format%20required%2C%20including%20clipboard%20(copy%20%26amp%3B%20paste)%2C%20Excel%2C%20.csv%2C%20and%20%E2%80%93%20for%20plots%20%E2%80%93%20.png%2C%20.svg%2C%20and%20.pdf.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EValidate%20data%20prior%20to%20analysis%3C%2FSTRONG%3E%20by%20running%20a%20data%20validation%20report%2C%20which%20performs%20systematic%20checks%20on%20metrics%2C%20organizational%20attributes%2C%20and%20meeting%20subject%20lines.%20The%20data-validation%20functions%20promote%20good%20practices%20of%20checking%20for%20patterns%20such%20as%20public%20holidays%2C%20non-knowledge%20workers%2C%20outliers%2C%20and%20missing%20values%20in%20the%20data%20to%20improve%20the%20quality%20and%20reliability%20of%20analysis.%26nbsp%3B%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EGenerate%20prebuilt%20interactive%20HTML%20reports%3C%2FSTRONG%3E%2C%20which%20includes%20reports%20on%20data%20validation%2C%20subject-line%20text%20mining%2C%20and%20key%20collaboration%20metrics.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3ELeverage%26nbsp%3B%3CSTRONG%3Eadvanced%20analytics%20functions%3C%2FSTRONG%3E%2C%20such%20as%20text%20mining%2C%20network%20analysis%2C%20and%20hierarchical%20clustering%2C%20all%20designed%20specifically%20for%20Workplace%20Analytics%20metrics.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Paul_Schafer_2-1615841641717.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263857i573EEA37DACF10FE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Paul_Schafer_2-1615841641717.png%22%20alt%3D%22Paul_Schafer_2-1615841641717.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EThe%20user%20experience%20in%20creating%20Workplace%20Analytics%20visuals%20in%20R%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3EAdditional%20resources%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EGet%20the%20package%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.github.com%252Fmicrosoft%252Fwpa%252F%26amp%3Bdata%3D04%257C01%257Cv-pausch%2540microsoft.com%257C958f9036af774e201c2108d8ddcc1096%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637503215842161307%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DXDz8x3BOpL8vF8ROHodnP2ks0%252FXwNT5lTh7Ooq7VVfA%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esource%20code%20on%20GitHub%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3ESee%20the%20%3CA%20href%3D%22https%3A%2F%2Fmicrosoft.github.io%2Fwpa%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ER%20package%20documentation%20on%20GitHub%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3ESee%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fworkplace-analytics%2Ftutorials%2Fwpa-r-package%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWorkplace%20Analytics%20documentation%20for%20the%20R%20package%3C%2FA%3E.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2211886%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20the%20latest%20feature%20releases%20from%20the%20Workplace%20Analytics%20product%20team.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22r-package.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263854i6DF3678FBFD5219B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22r-package.gif%22%20alt%3D%22r-package.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2224714%22%20slang%3D%22en-US%22%3ERe%3A%20Workplace%20Analytics%20March%202021%20feature%E2%80%AFupdates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224714%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20posting%20the%20updates%20to%20Workplace%20Analytics%20in%20the%20Tech%20Community.%20Great%20to%20see%20the%20query%20functionality%20now%20has%20support%20for%20the%20characters%20we%20use%20across%20the%20globe%20with%20the%20UTF-8-encoded%20characters!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Mar 18 2021 08:28 AM
Updated by: