Home
%3CLINGO-SUB%20id%3D%22lingo-sub-236470%22%20slang%3D%22en-US%22%3EWorkplace%20Analytics%20-%20August%202018%3A%20New%20custom%20meeting%20metrics%2C%20space%20planning%2C%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236470%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Workplace%20Analytics%20team%20is%20excited%20to%20announce%20the%20following%20new%20features%20for%20August%20(see%20past%20blog%20articles%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-365-Analytics-Blog%2Fbg-p%2FOffice365AnalyticsBlog%22%20target%3D%22_blank%22%3Ehere%3C%2FA%3E)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3ECustom%20metrics%20for%20meeting%20queries%20in%20Workplace%20Analytics%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EWorkplace%20Analytics%20helps%20with%20meeting%20space%20planning%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EMore%20flexibility%20with%20chart%20data%20in%20Workplace%20Analytics%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EImproved%20analysis%20of%20low-quality%20meeting%20hours%20with%20Workplace%20Analytics%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1512840967%22%20id%3D%22toc-hId-1534916231%22%3EWorkplace%20Analytics%20customizable%20metrics%20for%20meeting%20queries%3C%2FH3%3E%0A%3CP%3EYou%20can%20now%20customize%20metrics%20for%20meeting%20queries%20to%20get%20even%20more%20detailed%20analysis.%20Use%20meeting%20queries%20to%20analyze%20meeting%20time%20spent%20by%20attendees%20based%20on%20their%20specific%20attributes%2C%20such%20as%20the%20attendees%E2%80%99%20department%2C%20team%2C%20or%20any%20organizational%20attributes%20made%20available%20to%20Workplace%20Analytics.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMeeting%20queries%20enable%20you%20to%20learn%20how%20many%20people%20attended%20which%20team%20meetings%2C%20how%20much%20team%20time%20the%20meetings%20consumed%2C%20and%20if%20the%20meetings%20were%20high%20quality%20(based%20on%20conflicting%20meeting%20hours%2C%20multi-tasking%20during%20meetings%2C%20or%20attended%20by%20too%20many%20team%20members).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20you%20can%20create%20a%20meeting%20metric%20to%20find%20out%20how%20many%20people%20from%20Finance%20and%20HR%20attended%20which%20meetings%2C%20or%20how%20many%20managers%20had%20conflicting%20meetings%2C%20as%20shown%20below.%26nbsp%3BKeep%20in%20mind%20that%3CSPAN%3E%20this%20data%20is%20de-identified%E2%80%94attendees%20cannot%20be%20individually%20identified.%3C%2FSPAN%3E%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%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43633i5B3726D5BC8BF53D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.%20Metrics%20Select%20what%20you%20want.png%22%20title%3D%221.%20Metrics%20Select%20what%20you%20want.png%22%20%2F%3E%3C%2FSPAN%3E%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%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43637i197CFDEEEB4C1349%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222.%20Metrics%20Select%20what%20you%20want.png%22%20title%3D%222.%20Metrics%20Select%20what%20you%20want.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20details%20and%20instructions%2C%20see%20Workplace%20Analytics%20documentation%20for%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fworkplace-analytics%2Ftutorials%2Fcustomize-a-metric%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECustomize%20a%20base%20metric%20%3C%2FA%3Eand%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fworkplace-analytics%2Ftutorials%2Fmeeting-queries%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EMeeting%20queries%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1039315994%22%20id%3D%22toc-hId--1017240730%22%3EWorkplace%20Analytics%20helps%20with%20meeting%20space%20planning%3C%2FH3%3E%0A%3CP%3EOne%20of%20the%20great%20scenarios%20for%20Workplace%20Analytics%20is%20analyzing%20meeting%20room%20resources%20to%20see%20if%20your%20employees%20have%20the%20meeting%20space%20they%20need%20to%20collaborate%20effectively.%20For%20visibility%20into%20meeting%20room%20use%2C%20we%E2%80%99ve%20added%20a%20new%20MeetingResources%20field%20to%20use%20with%20meeting%20queries.%20You%20can%20use%20it%20both%20as%20a%20new%20meeting%20filter%20and%20as%20new%20data%20in%20meeting%20query%20output.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20when%20creating%20a%20meeting%20query%2C%20you%20can%20add%20a%20query%20filter%20to%20only%20include%20meetings%20for%20a%20specific%20room%20or%20building%20with%20the%20MeetingResources%20filter%20option.%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%20965px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43639iCDF7EAE2BC91D34A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%223.%20Filter%20Select%20which%20meetings.png%22%20title%3D%223.%20Filter%20Select%20which%20meetings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20output%20data%20for%20meeting%20queries%20will%20now%20include%20the%20following%20two%20columns%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EThe%20MeetingResourceIdsCount%20column%20provides%20the%20number%20of%20meeting%20rooms%20reserved%20for%20each%20meeting.%3C%2FLI%3E%0A%3CLI%3EThe%20MeetingResources%20column%20provides%20the%20alias%20portion%20of%20the%20room%E2%80%99s%20primary%20SMTP%20address%20(as%20a%20semi-colon%20delimited%20list).%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThe%20following%20shows%20an%20example%20of%20the%20type%20of%20data%20in%20these%20columns.%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%20679px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43640i64AD755A7D3F575A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%224.%20Data%20columns.png%22%20title%3D%224.%20Data%20columns.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EImportant%3C%2FSTRONG%3E%3A%20Because%20Workplace%20Analytics%20uses%20mailbox%20data%20for%20this%20analysis%2C%20meetings%20must%20have%20at%20least%20one%20measured%20employee%20as%20an%20attendee%20for%20the%20meeting%20room%20to%20be%20included%20in%20the%20results.%20If%20a%20meeting%20has%20no%20measured%20employees%2C%20that%20meeting%20and%20its%20room%20will%20not%20be%20included%20in%20the%20data.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-703494341%22%20id%3D%22toc-hId-725569605%22%3EMore%20flexibility%20with%20chart%20data%20in%20Workplace%20Analytics%3C%2FH3%3E%0A%3CP%3EIn%20the%20Explore%20dashboards%20in%20Workplace%20Analytics%2C%20you%20can%20now%20print%20charts%2C%20download%20them%20as%20images%2C%20or%20download%20them%20as%20a%20CSV%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDownloading%20the%20image%20or%20printing%20the%20chart%20gives%20you%20two%20easy%20ways%20to%20export%20charts%20as%20they%E2%80%99re%20displayed%20in%20Workplace%20Analytics.%20Downloading%20the%20chart%20as%20a%20CSV%20file%20gives%20you%20the%20flexibility%20to%20use%20other%20tools%20to%20recreate%20and%20format%20the%20chart%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20CSV%20download%20contains%20only%20the%20summarized%20data%20displayed%20in%20the%20chart.%20It%20does%20not%20include%20the%20query%20data%20used%20to%20generate%20the%20chart%2C%20so%20privacy%20and%20minimum%20aggregation%20rules%20are%20still%20in%20effect.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20any%20chart%20in%20the%20Explore%20dashboards%2C%20select%20the%20ellipses%20icon%20at%20the%20top%20right%20for%20these%20new%20export%20options.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%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%20584px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43641iBB704C360267302C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%225.%20Chart%20downloads.png%22%20title%3D%225.%20Chart%20downloads.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1848662620%22%20id%3D%22toc-hId--1826587356%22%3EImproved%20analysis%20of%20low-quality%20meeting%20hours%20with%20Workplace%20Analytics%3C%2FH3%3E%0A%3CP%3EWorkplace%20Analytics%20can%20now%20use%20your%20organization%E2%80%99s%20HR%20data%20to%20more%20accurately%20estimate%20low-quality%20meeting%20hours.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBy%20default%2C%20Workplace%20Analytics%20currently%20uses%20a%20%2475%20hourly%20rate%20to%20calculate%20the%20estimated%20cost%20of%20all%20low-quality%20meetings.%20If%20your%20admin%20adds%20the%20new%20HourlyRate%20column%20to%20the%20HR%20data%20upload%2C%20Workplace%20Analytics%20will%20use%20this%20HR%20data%20to%20calculate%20the%20total%20estimated%20cost%20of%20low-quality%20meetings%2C%20based%20on%20the%20hourly%20rates%20of%20the%20meeting%20attendees.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20HourlyRate%20column%20is%20now%20an%20optional%2C%20reserved%20attribute%20for%20HR%20data%20uploads.%20If%20you%20choose%20to%20not%20include%20this%20new%20column%20in%20the%20HR%20upload%2C%20Workplace%20Analytics%20will%20continue%20to%20use%20the%20default%20%2475%20hourly%20rate%20for%20the%20estimated%20totals.%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%20518px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43642iBA3FF57034AC8822%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%226.%20Explore%20new%20rate%20metrics.png%22%20title%3D%226.%20Explore%20new%20rate%20metrics.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%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%22%3Enext%20month%3C%2FA%3E!%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%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%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%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%22%3EMyAnalytics%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-236470%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20out%20the%20%3CSPAN%3Elatest%20product%20releases--directly%20from%20the%20Workplace%20Analytics%20product%20team!%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20320px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37939i77D37C1943676A12%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Blog_Updates.png%22%20title%3D%22Blog_Updates.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

The Workplace Analytics team is excited to announce the following new features for August (see past blog articles here):

 

  • Custom metrics for meeting queries in Workplace Analytics
  • Workplace Analytics helps with meeting space planning
  • More flexibility with chart data in Workplace Analytics
  • Improved analysis of low-quality meeting hours with Workplace Analytics

 

Workplace Analytics customizable metrics for meeting queries

You can now customize metrics for meeting queries to get even more detailed analysis. Use meeting queries to analyze meeting time spent by attendees based on their specific attributes, such as the attendees’ department, team, or any organizational attributes made available to Workplace Analytics. 

 

Meeting queries enable you to learn how many people attended which team meetings, how much team time the meetings consumed, and if the meetings were high quality (based on conflicting meeting hours, multi-tasking during meetings, or attended by too many team members).

 

For example, you can create a meeting metric to find out how many people from Finance and HR attended which meetings, or how many managers had conflicting meetings, as shown below. Keep in mind that this data is de-identified—attendees cannot be individually identified.

 1. Metrics Select what you want.png

 2. Metrics Select what you want.png

 

For more details and instructions, see Workplace Analytics documentation for Customize a base metric and Meeting queries

 

Workplace Analytics helps with meeting space planning

One of the great scenarios for Workplace Analytics is analyzing meeting room resources to see if your employees have the meeting space they need to collaborate effectively. For visibility into meeting room use, we’ve added a new MeetingResources field to use with meeting queries. You can use it both as a new meeting filter and as new data in meeting query output.

 

For example, when creating a meeting query, you can add a query filter to only include meetings for a specific room or building with the MeetingResources filter option. 

3. Filter Select which meetings.png

 

The output data for meeting queries will now include the following two columns: 

 

  • The MeetingResourceIdsCount column provides the number of meeting rooms reserved for each meeting.
  • The MeetingResources column provides the alias portion of the room’s primary SMTP address (as a semi-colon delimited list).

The following shows an example of the type of data in these columns.

 

4. Data columns.png

 

Important: Because Workplace Analytics uses mailbox data for this analysis, meetings must have at least one measured employee as an attendee for the meeting room to be included in the results. If a meeting has no measured employees, that meeting and its room will not be included in the data. 

 

More flexibility with chart data in Workplace Analytics

In the Explore dashboards in Workplace Analytics, you can now print charts, download them as images, or download them as a CSV file.

 

Downloading the image or printing the chart gives you two easy ways to export charts as they’re displayed in Workplace Analytics. Downloading the chart as a CSV file gives you the flexibility to use other tools to recreate and format the chart data.

 

The CSV download contains only the summarized data displayed in the chart. It does not include the query data used to generate the chart, so privacy and minimum aggregation rules are still in effect.

 

On any chart in the Explore dashboards, select the ellipses icon at the top right for these new export options.

  

5. Chart downloads.png 

Improved analysis of low-quality meeting hours with Workplace Analytics

Workplace Analytics can now use your organization’s HR data to more accurately estimate low-quality meeting hours.

 

By default, Workplace Analytics currently uses a $75 hourly rate to calculate the estimated cost of all low-quality meetings. If your admin adds the new HourlyRate column to the HR data upload, Workplace Analytics will use this HR data to calculate the total estimated cost of low-quality meetings, based on the hourly rates of the meeting attendees.

 

The HourlyRate column is now an optional, reserved attribute for HR data uploads. If you choose to not include this new column in the HR upload, Workplace Analytics will continue to use the default $75 hourly rate for the estimated totals.

 

6. Explore new rate metrics.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