SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have not worked with either one. So before I get deep into either one I want to make sure I am picking the right engine for business intelligence.

There are needs for reports, pie charts or charts, etc. You get the point. Also, my manager is interested in Dashboard (not sure if this is only achieved thru PerformanceP or PPivot)?

Please suggest the best way to do this. We do not have hardware constrains.

share|improve this question
up vote 7 down vote accepted

Getting started with business intelligence in SharePoint Server 2010 has a good comparison.

Also there is document "choosing the right Microsoft BI Tool.doc" (search on internet) which can help you. Below is captured from the document.

enter image description here enter image description here

share|improve this answer
nice.... thanks ashish – Angie Marie Jan 28 '12 at 23:26

I did a webinar on this topic : "Choosing an MS Visualisation technology"

Angie: You can use combine PPS scorecards with RS reports on a Sharepoint page to get this interactivity. I also did a webinar on this :)

share|improve this answer

Use SQL Server Reporting Services if you need reporting (and it has extensive charting functionality, too).

share|improve this answer
Can it do where you click on a the pie or chart and correspondent data would show up. – Angie Marie Jan 28 '12 at 19:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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