What are the basic needs to develop a business intelligence dashboard in SharePoint 2010 or in MOSS 2007 (I have both)? Do I need to install any services?

I want to monitor different tender proposals in the portal. I am sure I need a database. I don't want to use the BDC/BCS.

Can I use web parts in dashboards? I want to show the graphs in Excel sheets.

What should I do?


SP 2010

You need to have Enterprise version for SP 2010 to use performance point service.

follow this steps to create BI Site.

  1. Activate the SharePoint Server Publishing Infrastructure feature. PerformancePoint Services uses this feature to perform dashboard publishing.

  2. Activate PerformancePoint Services Site Collection Features feature. This feature adds PerformancePoint content types and a Business Intelligence Center site template.

  3. Activate the SharePoint Server Enterprise Site Collection Features feature. This feature enables Excel Services, Visio Services, and Access Services, included in the SharePoint Server Enterprise License.

  4. Create a new Business Intelligence Center site by clicking Site Actions ➪ New Site, and then choose Business Intelligence template.

  5. Create an Unattended Service Account.

In PerformancePoint Services, you create the unattended account directly in the PerformancePoint Services application settings. In this case, the password is stored in Secure Store Service and the actual username is stored in the PerformancePoint Services database.

An unattended account can be created using the following steps:

  1. Browse to the Central Administration Site.
  2. From the Application Management category, choose Manage service applications.
  3. From the list of existing service applications, click PerformancePoint Service Application.
  4. Click the PerformancePoint Service Application Settings link.
  5. Specify the unattended service account for PerformancePoint and click OK.


SP 2007

Just go through this article to install PPS 2007 on your MOSS environment.

  • Please don't add your name or "Thanks" as a signature to posts. It adds unnecessary information and "noise" to the page that decreases its value. Thank you!
    – Alex Angas
    Jul 15 '11 at 1:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.