业务连续性Business continuity

业务连续性仪表板使用由工作区分析数据填充的 Power BI 模板,以深入了解你的组织和员工在移动到远程工作的影响。The Business continuity dashboard uses a Power BI template that’s populated by Workplace Analytics data to gain insights into how your organization and your employees are being impacted by the shift to remote work.

此仪表板将重点重点放在何处执行远程工作的变化可能会产生最大影响,并提供可衡量的起点以帮助领导者了解在哪里可以使用工具和流程来支持和维持新的工作方式。This dashboard directionally highlights where the shift to remote work might have the largest impacts, offering a measurable starting point for helping leaders understand where they might use tools and processes to support and sustain new ways of working.

仪表板使您能够直观显示和浏览由领导者提出的以下首要业务问题:The dashboard enables you to visualize and explore the following top-level business questions asked by leaders:

  • 协作活动如何更改?How are collaboration activities changing?
  • 工作生命集成的影响是什么?What are the impacts of work-life integration?
  • 是否正在维护外部关系?Are external relationships being maintained?
  • 员工是否在参与和连接?Are employees engaged and connected?
  • 如何发展工作模式?How are work patterns evolving?
  • 如何提高远程工作效率?How can remote work effectiveness be improved?

若要在 Power BI 中填充仪表板,您必须设置并成功在工作区分析中运行预定义的 业务连续性每小时协作 查询。To populate the dashboard in Power BI, you must set up and successfully run the predefined Business continuity and Hourly collaboration queries in Workplace Analytics. 这些查询的结果将每周刷新一次您下载的 Power BI 仪表板。The results of these queries will refresh your downloaded Power BI dashboard on a weekly basis.

在成功运行这些必需的查询之后,您将看到 Power BI 模板作为 "业务连续性" 查询的可用下载选项。After you successfully run these required queries, you'll see the Power BI template as an available download option for the Business continuity query. 在 Power BI 中创建仪表板需要此模板。This template is required to create the dashboard in Power BI. 下载 Power BI 模板之后,可以将查询数据从 Workplace Analytics 连接到 Power BI 中的仪表板。After you download the Power BI template, you can then connect the query data from Workplace Analytics to the dashboard in Power BI.

在使用您的数据填充业务连续性仪表板时,您可以使用它来可视化、浏览和报告组织的工作环境模式和趋势。When the Business continuity dashboard is populated with your data, you can use it to visualize, explore, and report about your organization's workplace patterns and trends.

演示Demonstration

下面的演示使用仅作为此仪表板的代表的示例数据,并且可能不是特定于您组织的唯一数据的 live 仪表板中看到的内容。The following demo uses sample data that is only representative of this dashboard and might not be exactly what you see in a live dashboard specific to your organization's unique data.


先决条件Prerequisites

运行查询并在 Power BI 中填充仪表板前,必须:Before you can run the queries and populate the dashboard in Power BI, you must:

  • 在 Workplace Analytics 中分配了“分析员”角色。Be assigned the role of Analyst in Workplace Analytics.
  • 已安装最新版本的 Power BI 桌面。Have the latest version of Power BI Desktop installed. 如果已安装早期版本的 Power BI,请在安装新版本之前将其卸载。If you have an earlier version of Power BI installed, uninstall it before installing the new version. 然后转到获取 Power BI Desktop 以下载并安装最新版本。Then go to Get Power BI Desktop to download and install the latest version.

模板更新Template update

业务连续性仪表板在频繁的节奏上进行更新,以解决日益增长的远程工作业务问题。The Business continuity dashboard is being updated on a frequent cadence to address evolving remote work business questions. 若要确保您使用的是最新版本的仪表板,请从最近运行的工作区分析业务连续性查询下载 Power BI 模板,然后在设置仪表板中重复步骤 8-15To ensure you are using the latest version of the dashboard, download the Power BI template from your most recently run Workplace Analytics Business continuity query, then repeat Steps 8-15 in Set up the dashboard. 您无需再次对模板更新运行查询。You don't have to run the queries again for template updates.

如果您在四月或 2020 5 月1日使用了业务连续性仪表板,并且选择了对查询使用六个月的数据,则需要在设置仪表板中重复执行步骤 1-7 ,以运行包含最后一年的数据的新查询,这将在三月份内和在发生移动前的时间内与远程工作有关的活动。If you started using the Business continuity dashboard in April or May 2020 and you selected to use six months of data for your queries, you need to repeat Steps 1-7 in Set up the dashboard to run new queries that include data for the last one year, which will encompass activity before and during the shift to remote work in March. 若要继续使用自定义版本的业务连续性仪表板,而不是更新到最新版本的模板,请在设置仪表板中执行以下操作而不是步骤 8-15To continue to use your custom version of the Business Continuity dashboard and not update to the latest version of the template, do the following instead of Steps 8-15 in Set up the dashboard:

  1. 在这两个查询都成功运行后,在 Power BI Desktop 中打开现有的业务连续性仪表板。After both queries successfully run, open your existing Business continuity dashboard in Power BI Desktop.
  2. 在 " 转换数据" 中,选择 " 编辑参数"。In Transform data, select Edit parameters.
  3. 使用新的查询 Url 替换业务连续性和每小时协作查询 Url 的现有 Url,然后选择 "确定"Replace the existing URLs for Business continuity and Hourly collaboration query URLs with the new query URLs, and then select OK.
  4. 一种缩短未来查询处理时间的最佳做法是关闭自动刷新或删除仪表板不再使用的预先存在的查询。A best practice that reduces future query processing time is to turn off the auto-refresh or delete the preexisting queries that the dashboard is no longer using. 有关详细信息,请参阅 停止自动刷新选项See Stop the auto-refresh option for details.

仪表板安装程序视频Dashboard setup video

Important

在运行查询时,视频显示 最近6个月 的选择,请确保选择 " 最后1年 "。Where the video shows selecting Last 6 months when running the queries, be sure you select Last 1 year instead. 然后,在3月2020,查询将包含在班次轮换之前和过程中包含活动的数据。The queries will then have data that includes activity before and during the shift to remote work in March 2020.

设置仪表板Set up the dashboard

  1. Workplace Analytics 中,选择“分析 > 查询In Workplace Analytics, select Analyze > Queries.

  2. 在 "从预选筛选器和指标开始" 下,依次选择 "业务连续性"   (或每个步骤 7) 的每小时协作。若要打开预定义查询,其中包含填充仪表板所需的指标。Under Start from preselected filters and metrics, select Business continuity (or Hourly collaboration per Step 7) to open the predefined query, which contains the required metrics to populate the dashboard.

    预定义查询

  3. 选择或确认下列查询设置:Select or confirm the following query settings:

    • 名称 - 自定义或保留默认名称Name - Customize or keep the default name
    • 分组依据 - 周Group by - Week
    • 时间段 -过去1年Time period - Last 1 year
    • 自动刷新 - 启用设置Auto-refresh - Enable the setting
    • 会议排除 - 为租户选择首选规则Meeting exclusions - Select the preferred rule for your tenant

    Important

    • 该仪表板旨在向您显示 "移动到远程工作可以如何更改组织的工作模式"。The dashboard is designed to show you how a shift to remote work can change your organization's work patterns. 为获得最佳结果,请选择时间段最后1年,包括班次前后的时间。For best results, select Last 1 year for the Time period to include time before and after a shift.
    • 如果尝试删除预定义的指标,将会看到一条警告,显示删除操作可能会禁用 Power BI 仪表板的某些部分并减少查询结果。If you try to delete a predefined metric, you'll see a warning that the deletion might disable portions of the Power BI dashboard and reduce query results. 相反,这可能会限制可视化协作模式的功能。In turn, this can limit your ability to visualize collaboration patterns. 根据删除的指标,可能会禁用单个 Power BI 图表,多个图表或所有图表。Depending on the metric you delete, you might disable a single Power BI chart, several charts, or all the charts. 选择“取消”以保留指标。Select Cancel to retain the metric.

    业务连续性查询

  4. 在“选择筛选器”中,为“想要包括哪些已测量员工?”选择“仅活动In Select filters, select Active only for "Which measured employees do you want to include?" 或者,可在仪表板的范围内进一步筛选员工。Optionally, you can further filter the employees in scope for the dashboard. 有关筛选器和指标选项的更多详细信息,请参阅创建人员查询For more details about filter and metric options, see Create a Person Query.

  5. 组织数据中,保留仪表板所需的预选“组织”、“** LevelDesignation **” 和 “**TimeZone**” 属性。In Organizational data, keep the preselected Organization, LevelDesignation, and TimeZone attributes that the dashboard requires. 然后,您可以选择要包含在仪表板中的任何其他属性(列)。You can then select any other attributes (columns) to include in the dashboard.

    Important

    如果删除必需的预先组织数据属性,则可以禁用一个或多个 Power BI 图表。If you remove the required, preselected Organizational data attributes, you might disable one or more Power BI charts.

  6. 选择“运行”以运行查询,完成此进程可能需要几分钟。Select Run to run the query, which might take several minutes to complete.

  7. 每小时协作查询重复步骤 2-6 ,该查询需要与业务连续性相同的选择。Repeat Steps 2-6 for the Hourly collaboration query, which requires the same selections as for Business continuity.

  8. 查询 > 结果中,在两个查询都成功运行后,选择 "业务连续性查询结果的下载" 图标,选择 " PBI 模板",然后选择 "确定" 以下载模板。In Queries > Results, after both queries successfully run, select the Download icon for the Business continuity query results, select PBI template, and then select OK to download the template.

    Power BI 模板下载

  9. 打开下载的 业务连续性 POWER BI 模板Open the downloaded Business continuity Power BI template.

  10. 如果系统提示选择程序,请选择 Power BIIf prompted to select a program, select Power BI.

  11. Power BI 提示时,请将两个查询的 OData 链接复制粘贴到各自的字段中。When prompted by Power BI, copy and paste the OData links for both queries into their respective fields.

    • 在 Workplace Analytics“查询” > “结果”页面中,为每个查询选择链接图标,然后选择以复制生成的 OData URL 链接。In the Workplace Analytics Queries > Results page, select the Link icon for each query, and select to copy the generated OData URL link.
    • 在 Power BI 中,将每个复制的链接粘贴到各自的字段中。In Power BI, paste each copied link into its respective field.
    • 根据贵公司查看 Workplace Analytics 数据的策略,在此报表的可视化设置用于聚合数据的“最小组规模”。Set the Minimum group size for data aggregation within this report's visualizations in accordance with your company's policy for viewing Workplace Analytics data.
    • 选择“载入”,以将查询结果导入至 Power BI 中。Select Load to import the query results into Power BI. 加载这些大文件可能需要一些时间才能完成。Loading these large files may take some time to complete.

    Power BI 查询 URL

  12. 如果您已经使用 Workplace Analytics 组织帐户登录到 Power BI,将仪表板可视化对象填充到你的数据中。If you're already signed in to Power BI with your Workplace Analytics organizational account, the dashboard visualizations will populate with your data. 你可完成并跳过下列步骤。You are done and can skip the following steps. 如果没有,继续执行下一步。If not, proceed to the next step.

  13. 如果你没有登录 Power BI,或者如果在更新数据时出错,再次登录组织帐户。If you're not signed in to Power BI, or if an error occurs when updating the data, sign in to your organizational account again. 在“OData 源”对话框中,选择“组织帐户”,然后选择“登录”。In the OData feed dialog box, select Organizational account, and then select Sign in. 有关更多详细信息,请参阅 故障排除See Troubleshooting for more details.

    Power BI 登录

  14. 选择并输入用于登录 Workplace Analytics 的组织帐户凭据,然后选择“保存”。Select and enter credentials for the organizational account that you use to sign in to Workplace Analytics, and then select Save.

    Important

    必须使用用于访问 Workplace Analytics 的相同帐户登录 Power BI。You must sign in to Power BI with the same account you use to access Workplace Analytics.

  15. 选择“连接”准备和加载数据,这可能需要几分钟才能完成。Select Connect to prepare and load the data, which can take a few minutes to complete.

  16. 如果您有仪表板不再使用的预先存在的查询结果,则一种缩短处理时间的最佳做法是关闭自动刷新或删除仪表板不再使用的查询。If you have preexisting query results that the dashboard is no longer using, a best practice that reduces processing time is to turn off the auto-refresh or delete the queries that the dashboard is no longer using. 有关详细信息,请参阅 停止自动刷新选项See Stop the auto-refresh option for details.

仪表板设置Dashboard settings

在设置了业务连续性仪表板并填写了工作区分析数据之后,作为查看仪表板中的数据的第一步,在 " 设置 " 页上查看和设置以下参数。After the Business continuity dashboard is set up and populated with Workplace Analytics data, as a first step to viewing data in the dashboard, view and set the following parameters on the Settings page.

  • 较早的时间范围 -这是分析的基准,所有更改将与此时间范围进行比较。Earlier time frame - This is the baseline for your analysis and all changes will be compared with this time frame.

    Note

    之前的时间段必须在当前时间范围之前,且不能重叠。The Earlier time frame must precede and not overlap with the Current time frame. 如果两个时间段重叠,您将收到有关时间线重叠的警告。If the two timeframes overlap, you'll get a warning about the timelines overlapping.

  • 当前时间范围 -这是要与之前的时间范围进行比较的时间范围。Current time frame - This is the timeframe you want to compare with the earlier timeframe.

  • 按所有后续报告中显示的主 "分组依据" 属性查看报告的组织属性Organizational attribute to view the report by - The primary “group-by” attribute shown in all subsequent reports. 您可以随时更改此属性,所有后续报告页将按新属性显示组值。You can change this attribute at any time and all subsequent report pages will show group values by the new attribute.

  • 要筛选的组织属性 –若要筛选已测量的员工填充,可以按任何选定的组织属性进行筛选,然后按这些属性的任何值进行筛选。Organizational attribute to filter by – To filter the measured employee population, you can filter by any selected Organizational attribute, and then filter by any of the values for these attributes. 如果进行筛选,则度量的员工计数将反映一个减少的数量。If you filter, the measured employees count will reflect a reduced number. 若要清除现有筛选器,请选择 Ctrl ,同时单击 " 清除筛选器" 箭头 (或使用触摸屏,选择 " 清除筛选器" 箭头) 。To clear an existing filter, select Ctrl while clicking the Clear filter arrow (or with a touchscreen, select the Clear filter arrow). 度量的员工反映在指定时间段内处于活动状态的筛选填充中的雇员数。Measured employees reflect the number of employees in the filtered population who were active in the specified time period. "活动员工" 是指在当前时间段包含的工作周中至少发送一封电子邮件或即时消息的人员。Active employees are those who sent at least one email or instant message in the work week included in the current timeframe.

    业务连续性仪表板设置

确认设置后,检查衡量的员工数以确认这是您要分析的填充。After confirming the settings, check the number of measured employees to confirm this is the population you want to analyze.

Important

随着每周处理新数据,请在 Power BI Home 功能区中选择 " 刷新 " 以查看最新的数据。As new data is processed on a weekly basis, select Refresh in the Power BI Home ribbon to view the most recent data.

关于报告About the reports

仪表板报告重点突出显示了执行远程工作的班次对影响最大的位置。The dashboard reports directionally highlight where a shift to remote work is having the largest impact. 它们还为您提供了一个可衡量的起点,用于确定在哪里可以使用工具和流程来以一种新的工作方式支持员工。They also give you a measurable starting point for identifying where leaders can use tools and processes to support employees in a new way of working. 所有指标都在 词汇表中进行了定义。All metrics are defined in the Glossary. 每个报告的文本框中也包含 "为什么重要" 解释。A “why it matters” interpretation is also included in a text box for each report.

下面介绍每个报表,每个报告有各自的具体差别。The following describes each report with specific nuances to consider for each.

  • 协作活动如何更改?How are collaboration activities changing? –显示员工协作模式在工作模式中的变化响应中的变化,以及哪些协作工具将替换为人员内交互。– Shows how employee collaboration patterns are changing in response to a shift in work patterns, and which collaboration tools people are substituting for in-person interactions.

  • 工作生命集成的影响是什么?[1] -帮助您评估某些员工是否不按比例受到影响。What are the impacts of work-life integration? [1] - Helps you assess if some employees are disproportionately affected. 您可以从多个值中进行选择,以查看其协作时间增加或减少超过指定小时数的雇员的百分比。You can select from multiple values to view the percentage of employees whose collaboration hours increased or decreased by more than the specified number of hours.

  • 工作生命集成的影响是什么?[2] -显示 "在时间后的协作活动中的更改"。What are the impacts of work-life integration? [2] - Shows changes in after-hours collaboration activity. 您可以从多个值中进行选择,以查看其后工作时间增加或减少超过指定小时数的雇员的百分比。You can select from multiple values to view the percentage of employees whose after-hours work increased or decreased by more than the specified number of hours. 您还可以查看会议、电子邮件和即时消息每天的活动。You can also examine the activity by time of day for meetings, emails and instant messages.

  • 是否正在维护外部关系?Are external relationships being maintained? -量化与组织外部的客户、合作伙伴和其他人的交流的变化。- Quantifies changes in communication with customers, partners, and other people outside the organization.

  • 员工是否在参与和连接?Are employees engaged and connected? -与显示比较基准和当前时间段之间的变化的其他报告不同, 此报告仅显示当前时间段的最后两周的指标- Unlike the other reports that show changes between the baseline and the current timeframes, this report only shows metrics for the last two weeks of the current time frame. 你可以利用此视图评估经理一对一会议和组织协作(培养员工参与度和社区参与度的关键因素)是否仍在虚拟进行。This view enables you to assess if manager 1:1 meetings and organizational collaboration, which are keys to fostering employee engagement and community, are still occurring virtually.

    Note

    报告的指标仅基于 当前时间范围 的后两周,而不是基于与 较早时间范围的比较。The report’s metrics are based solely on the last two weeks of the Current time frame and not on a comparison with the Earlier time frame. 此外,这些图表基于少于8位人员的小型团队会议,并且仅分析会议、通话和即时消息活动,不包括电子邮件活动。Also, these charts are based on small group meetings of less than eight people and only analyze meeting, call, and instant-message activity, excluding email activity. 有关指标的更多详细信息,请参阅仪表板中的词汇表。For more details on metrics, see the Glossary in the dashboard.

Power BI 提示、故障排除和常见问题解答Power BI tips, troubleshooting, and FAQs

若要详细了解如何共享仪表板和其他 Power BI 提示、解决任何问题或查看最常见的问题,请参阅 POWER BI templates In Workplace AnalyticsFor details about how to share the dashboard and other Power BI tips, troubleshoot any issues, or review the most frequently asked questions, see Power BI templates in Workplace Analytics.

查看、下载和导出查询结果View, download, and export query results