Performance data analysis in SharePoint

Question

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.

Answer 1

There is, Nintex Reporting, it is really expensive though...

Answer 2

Does SSRS give you anything useful?

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

Answer 3

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.

Answer 4

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)