Home
%3CLINGO-SUB%20id%3D%22lingo-sub-275910%22%20slang%3D%22en-US%22%3EWorkplace%20Analytics%20-%20October%202018%3A%20Meeting%20costs%2C%20Manager%20impact%2C%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275910%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Workplace%20Analytics%20team%20is%20excited%20to%20announce%20our%20feature%20updates%20for%20October%20(see%26nbsp%3Bpast%26nbsp%3B%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-365-Analytics-Blog%2Fbg-p%2FOffice365AnalyticsBlog%22%20target%3D%22_blank%22%3Eblog%20articles%20here%3C%2FA%3E%3C%2FSPAN%3E).%20In%20this%20update%2C%20you%E2%80%99ll%20discover%20the%20latest%2C%20including%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3ECost%20of%20low-quality%20meetings%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EManager%20impact%20Power%20BI%20template%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EChart%20interactivity%20improvements%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH3%20id%3D%22toc-hId-1512840967%22%20id%3D%22toc-hId-1534916192%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-1452962019%22%20id%3D%22toc-hId--1039315994%22%20id%3D%22toc-hId--1017240769%22%3ECost%20of%20low-quality%20meetings%3C%2FH3%3E%0A%3CP%3EAs%20described%20in%20the%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-365-Analytics-Blog%2FWorkplace-Analytics-August-2018-New-custom-meeting-metrics-space%2Fba-p%2F236470%22%20target%3D%22_blank%22%3EAugust%20blog%20article%3C%2FA%3E%3C%2FU%3E%2C%20we%20recently%20added%20the%20ability%20to%20specify%20a%20per-user%20hourly%20wage%20in%20the%20organizational%20data%20file%2C%20which%20is%20used%20in%20the%20%3CEM%3ECost%20of%20Low-Quality%20Meetings%3C%2FEM%3E%20calculation%20in%20the%20%3CSTRONG%3EMeetings%20overview%3C%2FSTRONG%3E%20exploration.%20But%20what%20happens%20when%20an%20employee%20doesn%E2%80%99t%20have%20an%20hourly%20rate%20specified%2C%20or%20when%20you%20don%E2%80%99t%20want%20to%20include%20that%20rate%20in%20a%20per-person%20format%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%E2%80%99d%20like%20to%20announce%20a%20new%20global%20setting%20that%20allows%20you%20to%20change%20the%20default%20hourly%20rate%20used%20across%20the%20organization.%20By%20using%20this%20setting%2C%20you%20can%20update%20the%20hourly%20rate%20to%20reflect%20your%20own%20employee%20population%20to%20get%20a%20more%20accurate%20view%20of%20the%20cost%20of%20low-quality%20meetings.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20change%20this%20default%2C%20simply%20go%20to%20the%20Settings%20page%20and%20change%20the%20%3CSTRONG%3EHourly%20Rate%3C%2FSTRONG%3E%20setting.%20In%20the%20following%20illustration%2C%20this%20value%20is%20set%20to%20%2475.00%3A%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%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57827iF12BBA1B018EA7B1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.%20System%20defaults.png%22%20title%3D%221.%20System%20defaults.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%20%3CSTRONG%3EMeetings%20overview%3C%2FSTRONG%3E%20tab%20of%20the%20Workplace%20Analytics%20Explore%20page%2C%20you%20can%20see%20the%20total%20cost%20of%20low-quality%20meetings%20over%20a%20selected%20period%20of%20time%2C%20calculated%20by%20using%20the%20hourly%20rate%20that%20you%20set%3A%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%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57828i4AFECEA77EEE188D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222.%20Meeting%20cost.PNG%22%20title%3D%222.%20Meeting%20cost.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1452962019%22%20id%3D%22toc-hId-703494341%22%20id%3D%22toc-hId-725569566%22%3EManager%20impact%20Power%20BI%20template%3C%2FH3%3E%0A%3CP%3E%3CSPAN%3EIn%20the%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-365-Analytics-Blog%2FWorkplace-Analytics-September-2018-Teamwork-solution-Admin%2Fba-p%2F259901%22%20target%3D%22_blank%22%3ESeptember%20Workplace%20Analytics%3C%2FA%3E%3C%2FU%3E%20blog%2C%20%3C%2FSPAN%3Ewe%20described%20a%20new%20Power%20BI%20template%20that%20let%20analysts%20visualize%3CSPAN%3E%20areas%20of%20collaboration%20overload%20in%20their%20organization.%20Such%20a%20template%20performs%20two%20tasks%3A%20it%20pre-populates%20a%20Workplace%20Analytics%20query%20and%20it%26nbsp%3Bselects%20the%20proper%20Power%20BI%20charts%20to%20display%20the%20results%20of%20that%20query.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20month%2C%20we%20are%20happy%20to%20announce%20the%20addition%20of%20a%20new%20Power%20BI%20template%2C%20%3CSTRONG%3EManager%20Impact%3C%2FSTRONG%3E.%20This%20template%20shows%20trends%20of%20manager%20behavior%20%E2%80%93%20how%20managers%20interact%20with%20their%20teams%20%E2%80%93%20within%20your%20organization.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EImportant%3A%3C%2FSTRONG%3E%20To%20see%20this%20info%20in%20the%20Trends%20overview%20table%20in%20Power%20BI%2C%20the%20Workplace%20Analytics%20admin%20must%20include%20the%20SupervisorIndicator%20column%20in%20the%20organizational%20data%20file%20that%20they%20upload.%20For%20the%20SupervisorIndicator%20attribute%2C%20indicate%20the%20manager%20status%20of%20each%20employee%20by%20using%20the%20values%20%3CSTRONG%3EIC%3C%2FSTRONG%3E%20(individual%20contributor)%2C%20%3CSTRONG%3EMngr%3C%2FSTRONG%3E%20(manager)%2C%20or%20%3CSTRONG%3EMngr%2B%3C%2FSTRONG%3E%20(manager%20of%20managers).%20If%20SupervisorIndicator%20is%20excluded%2C%20the%20query%20still%20runs%20and%20you%20obtain%20an%20OData%20link%20to%20its%20results%2C%20but%20after%20you%20open%20Power%20BI%2C%20the%20Trends%20overview%20table%20is%20blank.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20section%20provides%20a%20brief%20description%20of%20how%20to%20use%20the%20Manager%20impact%20Power%20BI%20template.%20For%20more%20complete%20instructions%2C%20see%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fworkplace-analytics%2Ftutorials%2Fpower-bi-templates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EPower%20BI%20templates%3C%2FA%3E%3C%2FSPAN%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOpen%20the%20Queries%20page%20in%20Workplace%20Analytics%2C%20select%20the%20%3CSTRONG%3EManager%20impact%3C%2FSTRONG%3E%20query%20card%2C%20select%20a%20rule%20from%20the%20Meeting%20exclusions%20list%2C%20and%20select%20%3CSTRONG%3ERun%3C%2FSTRONG%3E.%20Now%2C%20go%20to%20the%3CSPAN%3E%20Query%20%26gt%3B%20Results%20page.%3C%2FSPAN%3E%20After%20the%20query%20finishes%20running%2C%20i%3CSPAN%3En%20the%20row%20of%20your%20query%20results%2C%20select%20the%20download%20icon%3A%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20981px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57829i2A43EB5BDBFE5E93%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%223.%20PBI%20template%20results.png%22%20title%3D%223.%20PBI%20template%20results.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20pop-up%20option%20box%2C%20se%3CSPAN%3Elect%26nbsp%3B%3CSTRONG%3EPBI%20template%3C%2FSTRONG%3E%20and%20then%20open%20the%20downloaded%20Power%20BI%20template%20query%20results%20file.%26nbsp%3BThe%20results%20file%20opens%20in%20Power%20BI.%20You%20are%20prompted%20to%20paste%20the%20OData%20link%3B%20paste%20it%20and%20then%20select%26nbsp%3B%3CSTRONG%3ELoad%3C%2FSTRONG%3E.%26nbsp%3BAfter%20the%20data%20loads%2C%20Power%20BI%20provides%20%3C%2FSPAN%3E%3CSPAN%3Einto%20manager%20trends%20within%20your%20organization.%20%3C%2FSPAN%3EHere%20is%20an%20example%20of%20what%20the%20manager%20impact%20template%20provides%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20841px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57830iB3384D74590C29D0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%224.%20Leadership%20exposure.png%22%20title%3D%224.%20Leadership%20exposure.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1848662620%22%20id%3D%22toc-hId--1826587395%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-1452962019%22%20id%3D%22toc-hId--105852285%22%20id%3D%22toc-hId--83777060%22%3EChart%20interactivity%20improvements%3C%2FH3%3E%0A%3CP%3ECharts%20in%20Workplace%20Analytics%20now%20contain%20a%20%3CEM%3Ereference%20line%3C%2FEM%3E%20that%20displays%20the%20average%20value%20of%20a%20specific%20metric%20for%20the%20filter%20group.%20This%20is%20an%20improvement%20over%20the%20former%20way%20that%20charts%20displayed%20this%20information%2C%20namely%20as%20a%20column%20(the%20first%20column)%20in%20the%20chart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20following%20illustration%2C%20the%20dashed%20line%20is%20the%20reference%20line%3A%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%20style%3D%22width%3A%20873px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57958i05F8A25C56F10F66%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Graph-%20Avg%20line.PNG%22%20title%3D%22Graph-%20Avg%20line.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAt%20the%20beginning%20and%20end%20of%20the%20reference%20line%20you%E2%80%99ll%20find%20points%20on%20which%20you%20can%20hover%20to%20see%20the%20filter%20group%20averages%20for%20this%20metric.%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20%3CSTRONG%3EPage%20settings%3C%2FSTRONG%3E%20panel%20on%20the%20%3CSTRONG%3EExplore%3C%2FSTRONG%3E%20page%2C%20you%20can%20use%20a%20slider%20to%20change%20the%20number%20of%20displayed%20groups.%20This%20setting%20applies%20to%20all%20bar%20charts%20and%20box%20plots%20in%20the%20%3CSTRONG%3EExplore%3C%2FSTRONG%3E%20dashboards.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20illustration%20shows%20this%20setting%20at%20its%20initial%20default%20value%20of%2050%20groups%3A%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%20style%3D%22width%3A%20222px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57832iA337023BB1735DB4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%226.%20Page%20settings.png%22%20title%3D%226.%20Page%20settings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20let%20us%20know%20if%20you%20have%20any%20feedback%20on%20the%20features%20described%20in%20this%20blog.%20Stay%20tuned%20for%20feature%20announcements%20coming%20%3CA%20href%3D%22https%3A%2F%2Fna01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ftechcommunity.microsoft.com%252Ft5%252FOffice-365-Analytics-Blog%252Fbg-p%252FOffice365AnalyticsBlog%26amp%3Bdata%3D04%257C01%257Cnabarnet%2540microsoft.com%257C6855081eb508409f727f08d5ed9f55db%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636676190986550716%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwifQ%253D%253D%257C-1%26amp%3Bsdata%3DpsMOK67GZOaBVAXbyxrV7WycZ0x0JvbKaHGd2CwH1xs%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Enext%20month%3C%2FA%3E!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH5%20id%3D%22toc-hId--434641160%22%20id%3D%22toc-hId-1243931040%22%20id%3D%22toc-hId-1266006265%22%3ELearn%20more%20about%20Workplace%20Analytics%20on%20our%20%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fen-US%2Fbusiness%2Fworkplace-analytics%3Fms.officeurl%3Dworkplaceanalytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eproduct%20page%3C%2FA%3E%20and%20read%20about%20our%20work%20with%20customers%20at%20%3CA%20href%3D%22http%3A%2F%2Finsights.office.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Einsights.office.com%3C%2FA%3E.%20Get%20personal%20insights%20with%20%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fen-us%2Fbusiness%2Fmyanalytics-personal-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMyAnalytics%3C%2FA%3E.%26nbsp%3B%3C%2FH5%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-275910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ECheck%20out%20the%20latest%20product%20releases--directly%20from%20the%20Workplace%20Analytics%20product%20team!%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20320px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57833i9DC33EE7301336ED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Blog_Updates.png%22%20title%3D%22Blog_Updates.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

The Workplace Analytics team is excited to announce our feature updates for October (see past blog articles here). In this update, you’ll discover the latest, including:

 

  • Cost of low-quality meetings
  • Manager impact Power BI template
  • Chart interactivity improvements

 

Cost of low-quality meetings

As described in the August blog article, we recently added the ability to specify a per-user hourly wage in the organizational data file, which is used in the Cost of Low-Quality Meetings calculation in the Meetings overview exploration. But what happens when an employee doesn’t have an hourly rate specified, or when you don’t want to include that rate in a per-person format?

 

We’d like to announce a new global setting that allows you to change the default hourly rate used across the organization. By using this setting, you can update the hourly rate to reflect your own employee population to get a more accurate view of the cost of low-quality meetings.

 

To change this default, simply go to the Settings page and change the Hourly Rate setting. In the following illustration, this value is set to $75.00:

 

1. System defaults.png

 

On the Meetings overview tab of the Workplace Analytics Explore page, you can see the total cost of low-quality meetings over a selected period of time, calculated by using the hourly rate that you set:

 

2. Meeting cost.PNG

 

Manager impact Power BI template

In the September Workplace Analytics blog, we described a new Power BI template that let analysts visualize areas of collaboration overload in their organization. Such a template performs two tasks: it pre-populates a Workplace Analytics query and it selects the proper Power BI charts to display the results of that query.

 

This month, we are happy to announce the addition of a new Power BI template, Manager Impact. This template shows trends of manager behavior – how managers interact with their teams – within your organization.

 

Important: To see this info in the Trends overview table in Power BI, the Workplace Analytics admin must include the SupervisorIndicator column in the organizational data file that they upload. For the SupervisorIndicator attribute, indicate the manager status of each employee by using the values IC (individual contributor), Mngr (manager), or Mngr+ (manager of managers). If SupervisorIndicator is excluded, the query still runs and you obtain an OData link to its results, but after you open Power BI, the Trends overview table is blank.

 

The following section provides a brief description of how to use the Manager impact Power BI template. For more complete instructions, see Power BI templates.

 

Open the Queries page in Workplace Analytics, select the Manager impact query card, select a rule from the Meeting exclusions list, and select Run. Now, go to the Query > Results page. After the query finishes running, in the row of your query results, select the download icon: 

3. PBI template results.png

 

In the pop-up option box, select PBI template and then open the downloaded Power BI template query results file. The results file opens in Power BI. You are prompted to paste the OData link; paste it and then select Load. After the data loads, Power BI provides into manager trends within your organization. Here is an example of what the manager impact template provides:

 4. Leadership exposure.png

 

Chart interactivity improvements

Charts in Workplace Analytics now contain a reference line that displays the average value of a specific metric for the filter group. This is an improvement over the former way that charts displayed this information, namely as a column (the first column) in the chart.

 

In the following illustration, the dashed line is the reference line:

 

Graph- Avg line.PNG

 

At the beginning and end of the reference line you’ll find points on which you can hover to see the filter group averages for this metric.  

 

In the Page settings panel on the Explore page, you can use a slider to change the number of displayed groups. This setting applies to all bar charts and box plots in the Explore dashboards.

 

The following illustration shows this setting at its initial default value of 50 groups:

 

6. Page settings.png

 

Please let us know if you have any feedback on the features described in this blog. Stay tuned for feature announcements coming next month!

 

Learn more about Workplace Analytics on our product page and read about our work with customers at insights.office.com. Get personal insights with MyAnalytics