SharePoint 中的性能数据分析

发布于 2024-07-25 13:27:27 字数 80 浏览 10 评论 0原文

市场上是否有任何工具可以有效分析 SharePoint 列表中的数据? 我有一位客户希望分析和报告 SharePoint 中存储的员工绩效数据。

Are there any tools on the market that effectively analyze data in SharePoint lists? I have a client looking to analyze and report on employee performance data stored in SharePoint.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

猫七 2024-08-01 13:27:27

SSRS 给你提供任何有用的东西吗?

您只需要报告数据,还是需要复杂的聚合?

Does SSRS give you anything useful?

Do you just need to report the data, or do you require complicated aggregation?

歌入人心 2024-08-01 13:27:27

Nintex 报告了 SharePoint 本身(而且实际上相当便宜)。 报告提出问题的方式可能是关于共享点列表中的员工数据,因此 SSRS 确实更有意义。

您还可以查看 MOSS Enterprise 附带的一些 BI 功能,例如 KPI Web 部件、记分卡、报告、Excel 服务和仪表板。

Nintex reports on SharePoint itself (and is acually quite cheap). The way the question is stated the report might be about employee data in a sharepoint list so SSRS does make more sense.

You can also look at some the BI features that come with MOSS Enterprise such as the KPI web part, scorecards, reports, Excel services and dashboards.

笑,眼淚并存 2024-08-01 13:27:27

除了 SSRS 之外,您还应该考虑使用 Excel 或 Access 来运行报告:-

在 Excel 中分析 SharePoint 数据
(查找标题为“SharePoint 到 Excel 和数据同步”的部分)

如何将 SharePoint Server 2007 列表与 Microsoft Access 2007 链接

页面当前已中断,缓存版本 http://209.85.229.132/search?q=cache:YnuTwWha77UJ:sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx%3FID%3D68+connecting+access+to+sharepoint+lists&cd =5&hl=en&ct=clnk

请记住,您还可以以 XML 形式访问列表数据,以便任何可以调用 SharePoints Web 服务 也可以使用并操作生成的 XML - 这里肯定有数百个竞争者。

使用的最佳工具取决于许多因素,例如您可能熟悉的内容、所需分析的复杂性、是否需要静态或动态报告(向下钻取等)。 商务智能 报告工具是一个巨大的领域!

最后,如果您需要相当简单的数据透视表/交叉表类型功能,那么这个 CrossTab Web 部件可能适合(免责声明 - 由我公司出售

In addition to SSRS you should also consider using either Excel or Access to run reports :-

Analysing SharePoint Data in Excel
(Look for the section titled SharePoint-to-Excel and Data Synchronization)

How to Link SharePoint Server 2007 Lists with Microsoft Access 2007

Page currently borked, cached version http://209.85.229.132/search?q=cache:YnuTwWha77UJ:sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx%3FID%3D68+connecting+access+to+sharepoint+lists&cd=5&hl=en&ct=clnk

Remember that you can also access the list data as XML so any 3rd party BI/reporting tool that can call one of SharePoints web services and manipulate the resulting XML could also be used - there are must be hundreds of contenders here.

The best tool to use depends upon many factors such as what you may be familiar with, the complexity of analysis you need, if you need static or dynamic reports (drill down etc). BI & Reporting tools are a huge area!

Finally if you need fairly simple PivotTable/crosstab type functionality then this CrossTab web part may be suitable (disclaimer - its sold by my company)

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文