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.


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


I did a webinar on this topic : http://bit.ly/AvFhgj "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 :)



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

  • 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 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.