使用 Power BI 连接到 tyGraphConnect to tyGraph with Power BI

通过 Power BI 内容包可视化和浏览 Power BI 中的 tyGraph 数据。Visualize and explore your tyGraph data in Power BI with the Power BI content pack. 首先,连接到你的 tyGraph 帐户并加载仪表板、报表和数据集。Start by connecting to your tyGraph account and loading the dashboard, reports and dataset. 现成内容包括见解,比如积极参与度(MAE 评分)和排名靠前的参与者。The out of box content includes insights such as the Measure of Active Engagement (MAE score) and Top Contributors. 进一步自定义它,以突出显示你最关注的信息。Customize it further to highlight the information you care most about. 将根据你设置的计划自动刷新数据。The data will be refreshed automatically according to a schedule that you set.

连接到 Power BI 的 tyGraphConnect to tyGraph for Power BI.

如何连接How to connect

  1. 选择左侧导航窗格底部的获取数据Select Get Data at the bottom of the left navigation pane.

  2. 服务框中,选择获取In the Services box, select Get.

  3. 选择 tyGraph > 获取Select tyGraph > Get.

  4. 指定你想要连接到的组和时间范围,否则指定“全部”以导入所有数据。Specify the groups and time range you'd like to connect to, otherwise specify "All" to bring in all the data. 请注意应该使用的日期格式 (YYYY/MM/DD)。Note the date format that's expected (YYYY/MM/DD). 有关详细信息,请参阅下面的查找这些参数See details on finding the parameters below.

  5. 提供 tyGraph 密钥进行连接。Provide your tyGraph key to connect. 请参阅以下有关查找此值的详细信息。See details on finding this value below.

    如果你是经过 Yammer 验证的管理员If you are a Yammer Verified Admin
    成功创建 tyGraph 帐户后,API 密钥将通过电子邮件发送给你。Your API key is sent to you in an email when your tyGraph account is successfully created. 如果你再也找不到密钥,则可以通过向 support@unlimitedviz.com 发送一封电子邮件来请求新的密钥。如果你还没有 tyGraph 帐户,你可以在 http://www.tygraph.com/ 开始试用。If you can no longer find your key, you can request a new one by sending an email to support@unlimitedviz.com. If you do not yet have a tyGraph account, you can start a trial at http://www.tygraph.com/.

    如果你不是经过 Yammer 验证的管理员If you are not a Yammer Verified Admin

    TyGraph 内容包需要由经过 Yammer 验证的管理员创建的 tyGraph 帐户。The tyGraph content pack requires a tyGraph account created by a Yammer verified administrator. 创建账户后,可以向同一组织内的用户颁发补充密钥。Once created, supplemental keys can be issued to users within the same organization. 如果你的经过验证的管理员尚未创建 tyGraph 帐户,请联系他们并让他们创建账户。If your verified admin has not yet created a tyGraph account, contact them to have them do so. 如果他们有帐户,你可以通过向 support@unlimitedviz.com 发送电子邮件来请求密钥。If they have, you can request a key by sending an email to support@unlimitedviz.com.

  6. 身份验证成功后,导入过程将自动开始。After successful authentication, the import process will begin automatically. 导入完成后,在导航窗格中将会出现新的仪表板、报表和模型。When complete, a new dashboard, report and model will appear in the Navigation Pane. 选择仪表板查看已导入的数据。Select the dashboard to view your imported data.

下一步?What now?

查找参数Finding parameters

你可以导入你具有访问权限的所有组的数据,或者你可以选择指定子集。You can bring in data on all the groups you have access to, or you can choose to specify a subset. 你还可以按日期创建数据的子集。You can also create a subset of data by date. 你可以创建多个 tyGraph 仪表板来监视特定成对的组和/或日期。You can create multiple tyGraph dashboards to monitor specific sets of groups and/or dates. 这些参数的详细信息如下。Details on these parameters are below.

Groups

tyGraph API 可以按特定组 ID 筛选数据。The tyGraph API can filter data by specific group ID. 这些都通过以逗号分隔的列表提供给内容包。These are provided to the content pack in a comma separated list.

Example: 2427647,946595,1154464

在 Yammer 中,你可以通过导航到该组的数据源并检查 URL 来确定特定组的组 ID。You can Identify the group ID for a particular group in Yammer by navigating to the feed for the group, and examining the URL.

在上面的示例中,Yammer 组 ID 是 4054844In the above example, the Yammer Group ID is 4054844

开始日期From Date

开始日期允许限制返回数据的最早值。The From Date allows you to restrict the earliest value for the data returned. 仅在该日期当天或之后创建的数据才会被加载进内容包。Only data created on or after this date will be loaded into the content pack. 开始日期的格式是 YYYY/MM/DD。The format of the From Date is YYYY/MM/DD.

Example: 2013/10/29

在上面的示例中,在 2013 年 10 月 29 日及以后创建的所有数据都将被加载进内容包。In the above example, all data from on or after October 29, 2013 will be loaded into the content pack.

结束日期结束日期允许你限制返回数据的最晚值。To Date The To Date allows you to restrict the latest value for the data returned. 它可以与开始日期结合使用来加载一个日期范围内的数据。It can be used in conjunction with the From Date to load data from a range of dates. 仅在该日期当天或之前创建的数据才会被加载进内容包。Only data created on or before this date will be loaded into the content pack. 结束日期的格式是 YYYY/MM/DD。The format of the To Date is YYYY/MM/DD.

Example: 2014/10/20

在上面的示例中,在 2014 年 10 月 20 日及以前创建的所有数据都将被加载进内容包。In the above example, all data from on or prior to October 20, 2014 will be loaded into the content pack.

后续步骤Next steps

Power BI 入门Get started in Power BI

在 Power BI 中获取数据Get data in Power BI