Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1019244%22%20slang%3D%22en-US%22%3EWorkplace%20Analytics%20-%20November%202019%3A%20Feature%E2%80%AFupdates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1019244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EThe%20Workplace%20Analytics%20team%20is%20excited%20to%20announce%20our%20feature%20updates%20for%20November%202019.%20(You%20can%20see%20past%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FWorkplace-Analytics-MyAnalytics%2Fbg-p%2FOffice365AnalyticsBlog%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Eblog%20articles%20here%3C%2FA%3E).%20In%20this%20update%2C%20you%E2%80%99ll%20discover%20the%20latest%20features%2C%20including%3A%E2%80%AF%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EPower%20BI%20%E2%80%93%20Workplace%20Analytics%20connector%26nbsp%3B%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ERedesigned%20Data%20sources%20page%26nbsp%3B%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ESolutions%20feature%20renamed%20%E2%80%9Cplans%E2%80%9D%26nbsp%3B%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH2%20id%3D%22toc-hId--1443897938%22%20id%3D%22toc-hId--1443897938%22%3E%3CSPAN%3EPower%20BI%20%E2%80%93%20Workplace%20Analytics%20connector%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20class%3D%22TextRun%20SCXW233172238%20BCX7%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW233172238%20BCX7%22%20data-ccp-parastyle%3D%22Normal%20(Web)%22%3EWorkplace%20Analytics%20has%20introduced%20the%20Power%20BI-Workplace%20Analytics%20connector%20for%20the%20out-of-the-box%20metrics%20you%20see%20in%20the%20Explore%20dashboards.%20Analysts%20can%20now%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fworkplace-analytics%2Fuse%2Fview-download-and-export-query-results%23connect-through-the-powerbi-workplace-analytics-connector%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ecreate%20their%20own%20visualizations%3C%2FA%3E%20on%20these%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW233172238%20BCX7%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW233172238%20BCX7%22%20data-ccp-parastyle%3D%22Normal%20(Web)%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW233172238%20BCX7%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW233172238%20BCX7%22%20data-ccp-parastyle%3D%22Normal%20(Web)%22%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2FWorkplace-Analytics%2Fuse%2Fmetric-definitions%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Emetrics%3C%2FA%3E%20by%20bringing%20them%20directly%20into%20PowerBI.%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22EOP%20CommentStart%20CommentHighlightClicked%20SCXW233172238%20BCX7%22%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ETo%20use%20the%26nbsp%3BPower%20BI-Workplace%20Analytics%20connector%2C%20first%20start%20Power%20BI%20desktop.%20Then%2C%20select%20%3CSTRONG%3EGet%20Data%3C%2FSTRONG%3E%2C%20select%20%3CSTRONG%3EOnline%20Services%3C%2FSTRONG%3E%2C%20select%20%3CSTRONG%3EWorkplace%20Analytics%3C%2FSTRONG%3E%2C%20and%20finally%20select%20%3CSTRONG%3EConnect%3C%2FSTRONG%3E.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157990i86E1702260E3F988%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EAfter%20a%20connection%20to%20Workplace%20Analytics%20is%20established%2C%20select%20your%20current%20Workplace%20Analytics%20partition%2C%20choose%20the%20query%20type%2C%20and%20select%20%3CSTRONG%3EOK%3C%2FSTRONG%3E.%20You%E2%80%99ll%20be%20asked%20to%20enter%20your%20Office%20365%20credentials%2C%20after%20which%20Power%20BI%20will%20display%20a%20list%20of%20metrics%20and%20attributes.%20You%20can%20choose%20from%20among%20these%20metrics%20and%20attributes%20to%20visualize%20data.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFor%20example%2C%20you%20can%20generate%20a%20bar%20chart%20that%20shows%20an%20organization-wide%20analysis%20of%20collaboration%20hours%20or%20examines%20the%20meeting-hours%20trend%20for%20an%20entire%20organization%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157991i07C8DAB9CF2F465C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1043614895%22%20id%3D%22toc-hId-1043614895%22%3E%3CSPAN%3ERedesigned%20Data%20sources%20page%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%20Workplace%20Analytics%20%3CSTRONG%3EData%20Sources%3C%2FSTRONG%3E%20page%20has%20been%20redesigned.%20This%20redesign%20helps%20Workplace%20Analytics%20users%20at%20two%20different%20times%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20During%20onboarding%2C%20this%20page%20will%20make%20it%20easier%20for%20the%20analyst%20and%20admin%20to%20understand%20what%20data%20is%20available%20to%20use%20in%20analysis%2C%20and%20the%20quality%20of%20that%20data.%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20As%20part%20of%20analysis%2C%20this%20page%20will%20make%20it%20easier%20for%20the%20analyst%20to%20diagnose%20data-quality-related%20issues%20that%20arise%20from%20unexpected%20query%20results.%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20new%20page%20has%20one%20tab%20with%20information%20about%20Office%20365%20data%20signals%20and%20another%20tab%20that%20shows%20the%20quality%20of%20the%20uploaded%20organizational%20data.%20Here%20is%20the%20new%20%3CSTRONG%3EOffice%20365%20data%3C%2FSTRONG%3E%20tab%3A%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157992iDDF4579E7F1C67FB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%20%3CSTRONG%3EOrganizational%20data%3C%2FSTRONG%3E%20tab%20has%20enhanced%20interactivity%20with%20which%20you%20can%20ask%20more%20nuanced%20questions%20about%20the%20quality%20of%20your%20organizational%20data%20when%20you%20analyze%20different%20groups%20in%20your%20organization.%20For%20example%2C%20you%20can%20now%20examine%20the%20data%20along%20various%20dimensions%2C%20such%20as%20measured%20employees%2Finternal%20collaborators%2C%20selected%20date%20ranges%2C%20and%20filters%20of%20organizational%20data.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157993iB459A2B9ADA7BB8C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_3.png%22%20title%3D%22clipboard_image_3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CEM%3EThe%20n%3C%2FEM%3Eew%3CEM%3E%20Organizational%20data%3C%2FEM%3E%20%3CEM%3Etab%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157994iB5FF0E01E0E423B7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3EThe%20new%20Organizational%20data%20attribute%20drill-down%20view%3C%2FEM%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--763839568%22%20id%3D%22toc-hId--763839568%22%3E%3CSPAN%3ESolutions%20feature%20renamed%20%E2%80%9Cplans%E2%80%9D%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%80%9CPlans%E2%80%9D%20is%20the%20new%20name%20for%20the%20%E2%80%9CSolutions%E2%80%9D%20feature%20of%20Workplace%20Analytics.%20The%20term%20%E2%80%9CSolutions%E2%80%9D%20did%20not%20properly%20convey%20the%20feature%E2%80%99s%20functionality%20and%20seemed%20vague%2C%20whereas%20the%20term%20%E2%80%9Cplan%E2%80%9D%20more%20clearly%20portrays%20the%20improvement%20tool%20that%20analysts%20and%20PMs%20create.%20It%20also%20better%20reflects%20the%20experience%20of%20people%20who%20participate%20in%20a%20plan%2C%20whether%20it%20was%20launched%20in%20Workplace%20Analytics%20or%20in%20MyAnalytics.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAll%20the%20functionality%20of%20this%20feature%20remains%20the%20same%20under%20the%20new%20name.%20For%20example%2C%20to%20create%20a%20change%20plan%2C%20you%20first%20open%20the%20%3CSTRONG%3EPlans%3C%2FSTRONG%3E%20page%20and%20then%20the%20%3CSTRONG%3ENew%20plan%3C%2FSTRONG%3E%20tab%3A%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157995iF789B0C22AC46AC7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_5.png%22%20title%3D%22clipboard_image_5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ENext%2C%20select%20a%20plan%20and%20follow%20the%20steps%20that%20are%20described%20in%20the%20product%20documentation%20under%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2FWorkplace-Analytics%2Ftutorials%2Fsolutionsv2-task%23define-the-plan%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CU%3EDefine%20the%20plan%3C%2FU%3E%3C%2FA%3E.%20This%20start%20with%20investigating%20(and%20then%2C%20optionally%2C%20selecting)%20a%20plan%20in%20the%20%3CSTRONG%3EAvailable%20plans%3C%2FSTRONG%3E%20panel.%20The%20three%20choices%20are%20%3CEM%3EFocus%20plan%3C%2FEM%3E%2C%20%3CEM%3ECollaboration%20plan%3C%2FEM%3E%2C%20and%20%3CEM%3EWellbeing%20plan%3C%2FEM%3E%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157996i3754E6B5D1B5750D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_6.png%22%20title%3D%22clipboard_image_6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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

 

  • Power BI – Workplace Analytics connector 
  • Redesigned Data sources page 
  • Solutions feature renamed “plans” 

Power BI – Workplace Analytics connector

Workplace Analytics has introduced the Power BI-Workplace Analytics connector for the out-of-the-box metrics you see in the Explore dashboards. Analysts can now create their own visualizations on these metrics by bringing them directly into PowerBI.  

 

To use the Power BI-Workplace Analytics connector, first start Power BI desktop. Then, select Get Data, select Online Services, select Workplace Analytics, and finally select Connect.  

 

clipboard_image_0.png

After a connection to Workplace Analytics is established, select your current Workplace Analytics partition, choose the query type, and select OK. You’ll be asked to enter your Office 365 credentials, after which Power BI will display a list of metrics and attributes. You can choose from among these metrics and attributes to visualize data.  

 

For example, you can generate a bar chart that shows an organization-wide analysis of collaboration hours or examines the meeting-hours trend for an entire organization:

clipboard_image_1.png

Redesigned Data sources page

The Workplace Analytics Data Sources page has been redesigned. This redesign helps Workplace Analytics users at two different times:

 

  • During onboarding, this page will make it easier for the analyst and admin to understand what data is available to use in analysis, and the quality of that data.
  • As part of analysis, this page will make it easier for the analyst to diagnose data-quality-related issues that arise from unexpected query results.

 

This new page has one tab with information about Office 365 data signals and another tab that shows the quality of the uploaded organizational data. Here is the new Office 365 data tab:   

clipboard_image_2.png

The Organizational data tab has enhanced interactivity with which you can ask more nuanced questions about the quality of your organizational data when you analyze different groups in your organization. For example, you can now examine the data along various dimensions, such as measured employees/internal collaborators, selected date ranges, and filters of organizational data.  

clipboard_image_3.png

 The new Organizational data tab

 

clipboard_image_4.png

The new Organizational data attribute drill-down view

Solutions feature renamed “plans”

“Plans” is the new name for the “Solutions” feature of Workplace Analytics. The term “Solutions” did not properly convey the feature’s functionality and seemed vague, whereas the term “plan” more clearly portrays the improvement tool that analysts and PMs create. It also better reflects the experience of people who participate in a plan, whether it was launched in Workplace Analytics or in MyAnalytics.  

 

All the functionality of this feature remains the same under the new name. For example, to create a change plan, you first open the Plans page and then the New plan tab:   

clipboard_image_5.png

 

Next, select a plan and follow the steps that are described in the product documentation under Define the plan. This start with investigating (and then, optionally, selecting) a plan in the Available plans panel. The three choices are Focus plan, Collaboration plan, and Wellbeing plan:

clipboard_image_6.png