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

Question

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.   

Answer 1

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