Glint 的行为模式Behavior patterns for Glint

Glint 仪表板的行为模式使用 Power BI 模板来组合 Workplace Analytics 的行为数据和 Glint 中的行为数据。The Behavior patterns for Glint dashboard uses a Power BI template to combine behavioral data from Workplace Analytics and sentiment data from Glint. 领导可以深入了解可能为员工感觉和工作做贡献的基础因素。Leaders get insights into underlying factors that might be contributing to both how their employees feel and how they work. 该分析有助于确定影响行为和改进业务成效的机会。The analysis helps identify opportunities to influence behavior and improve business outcomes.

它使用调查分数和工作模式来确定可能需要关注的团队。It uses survey scores and working patterns to identify outlying teams who might need attention. 即使对于已了解团队问题领导,仪表板也创建了高级可见性,以便他们能够使用基于研究和数据的操作来更改或改善工作场所行为。Even for leaders who are already aware of team issues, the dashboard creates high-level visibility enabling them to use research-based and data-driven actions to change or improve workplace behaviors.

此版本的仪表板结合了以下数据。This release of the dashboard combines the following data.

主题Theme 代表 Glint 调查问题Representative Glint survey question 工作区分析指标Workplace Analytics metrics
放松休息Wellbeing 我的公司真正关注员工健康。My company takes a genuine interest in employees' wellbeing.
  • 工时后指标After hours metrics
  • 协作时间Collaboration hours
  • 工作周跨度Workweek span
优先顺序Prioritization 我了解现在应关注哪些方面。I know what I should be focusing on right now. 经理一对一小时Manager one-on-one hours
员工连接Employee connection 我的公司正在做好帮助员工彼此保持联系的工作。My company is doing a good job of helping employees feel connected to one another.
  • 内部网络大小Internal network size
  • 小组会议时间Small group meeting hours

Power BI Glint Wellbeing 报告

仪表板包括以下报告。The dashboard includes the following reports.

  • 员工健康与协作之间是否有关系?Is there a relationship between employee wellbeing and collaboration? – 比较所选 HR 属性(如组织或级别指定)的健康评分,并说明一周工作时间、工作时间和协作时间对特定组健康的影响。– Compares wellbeing scores for the selected HR attributes, such as organization or level designation, and shows how workweek span, after hours, and collaboration hours might be affecting wellbeing for specific groups. 你还将看到基于研究、可操作的策略,以帮助更改可能导致健康分数较低的行为。You'll also see research-based, actionable strategies to help change behaviors that might contribute to low wellbeing scores.
  • 工作 优先顺序与经理参与度之间是否具有关系 – 比较选定 HR 属性的优先顺序分数,以显示经理一对一小时对员工的工作重点和优先级的能力有何影响。Is there a relationship between work prioritization and manager engagement – Compares prioritization scores for the selected HR attribute to show how manager one-on-one hours might be affecting employees’ ability to focus on and prioritize their work. 使团队能够轻松实施计划,让员工有机会更定期地一对一地与经理会面,并排定工作优先级。Gives teams easy-to-implement plans that create opportunities for employees to more regularly meet with their managers one-on-one and prioritize their work.
  • 查找 感觉断开连接且受益于更好的网络的团队 – 比较所选 HR 属性的员工连接分数,以显示小组会议小时数和内部网络大小对员工的连接感觉有何影响。Look for teams feeling disconnected that will benefit from better networking – Compares employee connection scores for the selected HR attribute to show how small group meeting hours and internal network size might be affecting employees’ feeling of connection. 帮助领导识别和支持可能具有影响其连接分数和协作模式的基础条件的团队。Helps leaders identify and support teams who might have underlying conditions that are affecting both their connection scores and collaboration patterns.
  • 如何采取措施改善员工健康?How can I take action to improve employee wellbeing? - 总结通过解决相关行为改善员工福利的机会。- Summarizes opportunities to improve employee wellbeing by addressing related behaviors. 更改开始发生后,领导可以使用 Workplace Analytics 数据测量协作行为中的实时变化,并跟踪后续 Glint 调查分数的改进。After changes start to occur, leaders can use Workplace Analytics data to measure real-time change in collaboration behaviors and track improvement with subsequent Glint survey scores.
  • 如何采取措施来改进优先顺序和连接?How can I take action to improve prioritization and connection? - 总结通过解决相关行为来提高对优先任务和员工连接的重点的机会。- Summarizes opportunities to improve focus on priority tasks and employee connection by addressing related behaviors. 更改开始发生后,领导可以使用 Workplace Analytics 数据测量协作行为中的实时变化,并跟踪后续 Glint 调查分数的改进。After changes start to occur, leaders can use Workplace Analytics data to measure real-time change in collaboration behaviors and track improvement with subsequent Glint survey scores.

演示Demonstration

这将使用仅代表仪表板的示例数据,并且可能不完全是你在特定于组织唯一数据实时仪表板中看到的数据。This uses sample data that is only representative of the dashboard and might not be exactly what you see in a live dashboard specific to your organization's unique data.

设置视频Setup video

以下视频介绍如何设置仪表板,这可能与使用组织独有的数据时的体验不完全一样。The following video describes how to set up the dashboard, which might not be exactly what you experience with data that's unique to your organization.

简要步骤High-level steps

在 Power BI 中填充仪表板所需的高级步骤:The high-level steps required to populate the dashboard in Power BI:

  1. 获取 Glint 数据 - 在 Glint 中,选择要在 Power BI 中分析的相应调查问题和总体,包括要分析的 HR 属性,如团队和位置。Get Glint data - In Glint, select the corresponding survey questions and the population to analyze in Power BI, including the HR attributes you want to analyze, such as team and position. 然后导出包含此数据的热度映射报告文件。Then export a Heat Map report file with this data.
  2. 获取 Workplace Analytics 数据 - 在 Workplace Analytics 中设置并运行 Glint 查询的预定义行为模式。Get Workplace Analytics data - Set up and run the predefined Behavior patterns for Glint query in Workplace Analytics. 成功运行查询后,在"结果"页上下载 Glint 查询的 Power BI 模板。After the query successfully runs, download the Power BI template for the Glint query on the Results page. 在 Power BI 中创建仪表板需要此模板。This template is required to create the dashboard in Power BI.
  3. 同时加载到 Power BI - 连接到工作区分析中的查询数据以及从 Glint 到 Power BI 的热度映射,并加载这些数据。Load both into Power BI - Connect to and load both the query data from Workplace Analytics and the Heat map from Glint into Power BI.

先决条件Prerequisites

在 Workplace Analytics 中运行查询并在 Power BI 中填充仪表板之前,需要执行以下操作。The following is required before you can run the query in Workplace Analytics and populate the dashboard in Power BI.

  • 你的公司使用与 Workplace Analytics 具有的数据相同的测量总体的 Glint:Your company uses Glint with the same measured population as Workplace Analytics has data for:

    • Glint 热图报告中反映的填充与 Glint 查询的行为模式中经过筛选的填充相同。The population reflected in the Glint Heat Map report is the same as the filtered population in the Behavior patterns for Glint query.
    • 你拥有过去六个月的 Glint 调查内容,其中包括有关员工福利、优先顺序和连接的问题。You have Glint survey content for the last six months that includes questions on employee wellbeing, prioritization, and connectivity.
  • 在 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.

  • 至少已在 Workplace Analytics 中上载和处理以下组织属性之一。Have at least one of the following organizational attributes already uploaded and processed in Workplace Analytics.

    • 级别指定 - 组织中每个员工的级别。Level designation - Each employee's level in the organization.
    • 组织或团队 - 每个员工的团队分配,反映了他们参与的组织或业务部门。Organization or team - Each employee’s team assignment, which reflects the organization or business division they're in.

获取 Glint 数据Get the Glint data

  1. 在 Glint 中,选择 " 报告热图",然后选择对健康、优先顺序和连接有疑问 > 的报告。In Glint, select Reports > Heat Map, and then select the reports that have questions on wellbeing, prioritization, and connectivity. 如果问题分布在不同的脉冲日期,请选择 "多脉冲" 选项。If the questions spread across different pulse dates, select the Multiple Pulses option.

    Glint 热图报告

  2. "筛选者"中,选择要在 Power BI 中分析总体的适用部门,然后选择"完成 "。In Filter By, select the applicable departments for the population you want to analyze in Power BI, and then select Done.

    按部门筛选的 Glint 筛选器

  3. 选择在报表的 Workplace Analytics 中也使用的分组属性。Select the grouping attributes that are also used in Workplace Analytics for the report.

    Glint 报告选项

  4. "添加 (,) 其他分组属性进行分析,这也必须存在于 Workplace Analytics 中。In Add section, select (up to five) other grouping attributes to analyze by, which must also be present in Workplace Analytics.

  5. 选择 "导出到电子表格 "以下载报告。Select Export to spreadsheet to download the report.

    Glint 报告导出

  6. 将电子表格保存在可访问的位置。Save the spreadsheet in an accessible location.

获取工作区分析数据Get the Workplace Analytics data

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

  2. "从预先选择的筛选器和 指标开始"下,选择 Glint 的行为模式以打开预定义的查询。Under Start from preselected filters and metrics, select Behavior patterns for Glint to open the predefined query.

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

    • 名称 - 自定义或保留默认名称Name - Customize or keep the default name
    • 分组依据 - 周Group by - Week
    • 时间段 - 选择与 Glint 调查问题询问的时间段对应的时间段Time period - Select the time period that corresponds to the time period that the Glint survey questions ask about
    • 自动刷新 - 保持此设置处于禁用状态Auto-refresh - Keep this setting disabled
    • 会议与与会者排除 - 为租户选择首选规则Meeting and attendee exclusions - Select the preferred rules for your tenant

    Important

    如果尝试删除预定义的指标,将会看到一条警告,显示删除操作可能会禁用 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?," and 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 属性,以及最多三个与 Glint 数据中包含的属性相匹配的属性。In Organizational data, keep the preselected Organization and LevelDesignation attributes that the dashboard requires and up to three more that match up with the attributes included in Glint data.

    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 can take a few minutes up to a few hours to complete.

  7. "查询 结果"中,成功运行查询后,选择 Glint 查询结果的行为模式的"下载"图标,选择 PBI 模板,然后选择"确定" > 以下载模板。 In Queries > Results, after the query successfully runs, select the Download icon for the Behavior patterns for Glint query results, select PBI template, and then select OK to download the template.

在 Power BI 中加载数据Load the data in Power BI

  1. 打开 Glint 模板的下载行为 模式。Open the downloaded Behavior patterns for Glint template.

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

  3. 当 Power BI 提示时,输入以下内容,然后选择"加载"将查询结果导入 Power BI。When prompted by Power BI, enter the following, and then select Load to import the query results into Power BI.

    • 在"工作区分析 查询结果"页中,选择链接图标,然后选择复制 > 生成的 OData URL链接。In the Workplace Analytics Queries > Results page, select the Link icon, and then select to copy the generated OData URL link.
    • 在 Power BI 中,粘贴工作区分析查询 Glint URL 的 复制 OData 链接。In Power BI, paste the copied OData link for Workplace Analytics query for Glint URL.
    • Glint 热图报告中,复制并粘贴热度映射文件路径。In the Glint Heat Map report, copy and paste the Heat Map file path.
    • "最小 组大小"中,在此报告的可视化效果中输入一个数据聚合数字,该数字符合公司查看 Workplace Analytics 数据的策略。In Minimum group size, enter a number for data aggregation within this report's visualizations that complies with your company's policy for viewing Workplace Analytics data.
  4. 如果您已经使用 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.

  5. 如果你没有登录 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 登录

  6. 选择并输入用于登录 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.

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

仪表板设置Dashboard settings

在 Power BI 中设置"行为"模式仪表板并填充 Glint 和 Workplace Analytics 数据后,在仪表板中查看数据之前,在"设置"页上设置 以下参数。After the Behavior patterns dashboard is set up and populated with both the Glint and Workplace Analytics data in Power BI and before viewing data in the dashboard, set the following parameters on the Settings pages.

  • 设置 (1) 主题映射到 Glint 调查热图 – 映射工作区分析数据中使用的工作模式,以与 Glint 调查中的适用问题进行比较。Settings (1) Map themes to Glint survey Heat Map – Map the work pattern used in Workplace Analytics data to compare with the applicable question in the Glint survey.
  • 设置 (1) 选择每个报告主题的时间段 – 选择要在报告中查看的每个工作模式的时间段。Settings (1) Select time period for each report theme – Select the time periods for each of the work patterns that you want to view in the reports.
  • 设置 (2) 将感兴趣的 Glint 属性映射到相应的工作区字段 - 表示 Glint 和 Workplace Analytics 中的团队的主要"分组"属性必须相互映射,因为它们在所有后续报告中使用和显示。Settings (2) Map the Glint attribute of interest to the corresponding Workplace field - The primary “group-by” attribute that represents the teams in both Glint and Workplace Analytics must be mapped to each other because they're used and shown in all subsequent reports. 你可随时更改这些映射,并且所有后续报告页将根据您的更改显示组值。You can change these mappings at any time and all subsequent report pages will show group values based on your changes. 若要清除现有映射,请选择"重置 "箭头To clear an existing mapping, select the Reset arrow.

行为模式 设置页 1

行为模式 设置页 2

Power BI 提示、疑难解答和常见问题解答Power BI tips, troubleshooting, and FAQs

有关如何共享仪表板和其他 Power BI 提示、解决任何问题或查看最常见的问题的详细信息,请参阅 Workplace Analytics中的 Power BI 模板。For 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