Business Intelligence Options in Sharepoint 2007

Question

I am new to Sharepoint and the technology used here is Sharepoint 2007 enterprise version. I am trying to do some research on the business intelligence capability of sharepoint 2007..

• KPI lists
•  excel services
• dashboards

..i found some articles regarding performance point server and also a dashboard designer..more information is given for sharepoint 2010 and not for SP 2007.. My organization is more interested to know about dashboard applications.

1)is there a way to use performance point services with SP 2007? If yes, how should i enable it?

2) can i extract data from web services? how should i set it up?

Your help is appreciated!

Thanks

Answer 1

Hi info,

Here is a link about PerformancePoint Services in SharePoint 2007:
http://www.bonair.com.pl/en/Microsoft-Office-SharePoint-Server-2007---PerformancePoint-Services

About your Second question, there are some built-in WebService in SharePoint, and you can extract data from them:
http://msdn.microsoft.com/en-us/library/dd878586(v=office.12)
http://www.etechplanet.com/blog/sharepoint-web-services-7c-list-of-all-web-services-available-with-wss-30moss-2007.aspx

Thanks,
Lhan Han

Answer 2

If you have SQL 2008 R2 in the environment, you can develop the dashboard functionality using Reporting services reports. They are much powerful for creating any type of dashboards and out of box controls are good enough to build the functionality. You can create a new database for dashboard purpose (also called datawarehouse). you can utilize SQL SSIS functionality to load data to it from any data source. Reporting services reports can run on top of the database (datewarehouse). Reporting services report is a web based report, so it can be easily shown in sharepoint using Page viewer web part. for end users, they come to SharePoint site, view the dashboard as it is showing up inside a webpart etc. It is a very good seemless presentation to the end users.

---

Moonis Tahir MVP SharePoint,MCTS SharePoint 2010/2007, MCPD.net, MCSD.net, MCTS BizTalk 2006,SQL 2005

Answer 3

Do you have a link that I can follow? Any tutotial or  steps as to how to go about?