SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

What is the best option you would use to show dashboard data within an Excel file on SharePoint?

A.  SharePoint and MS Office Integration.   

B.  SQL Reports integrated with SharePoint. 

C.  SharePoint Excel Services.  

D.  PerformancePoint Server integrated on SharePoint.   
share|improve this question

What do you mean "Dashboard data" - graphics? Status indicators, scorecards??

All these options mentioned by you are valid, depending on your business scenario.

Example: If your data comes from SQL and via PerformancePoint designer you built you dashboard based on KPIs - you are stuck with SharePoint.

You did forgot one very powerfull - POWERPIVOT (free for Excel) and even more could be installed and configured on SharePoint 2010 which would enable Analysis Services to process your data directly either from SQL, SharePoint, Excel Services and COMBINED!!!

Hope it helps, C:\Marius

share|improve this answer

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.