In SP2010 there are silver light dashboards used to be there in our project. Now we planned to convert them into BI reports in SP2013. All these report data is coming from list and libraries. Some reports should also have drill down capabilities. I am planned with performance point services or excel services. But is it proper one. Reports should have filter capability. If I install SSRS for SharePoint is it possible to achieve the same? Everywhere showing examples of external database like Adventure Works with sharepoint. But I have to build a report using list and libraries. Which will be best option?
Regarding If I install SSRS for SharePoint is it possible to achieve the same? Everywhere showing examples of external database like Adventure Works with SharePoint. But I have to build a report using list and libraries
Yes , you can use SSRS to show data from SharePoint Lists using Report Builder , to do that check the detail steps at Create SSRS Report from SharePoint 2013 List using Report Builder 3.0
Regarding What's the best option ?
you have mentioned most of the available BI and reporting tools in SharePoint, I suggest When you try to select appropriate tools you should be aware of the following 5 factors
- The SharePoint Edition.
- SharePoint Topology.
- The Capability of the tools.
- The Client Requirement.
- your knowledge with this tool.
Based on the above factors you can select your appropriate tools. (Note : Based on your mentioned scenario , I suggest SSRS)
**Below is simple comparison between SSRS , PerformancePoint and Excel Services **
The SharePoint Edition
- PerformancePoint. (Require SharePoint Enterprise)
- SSRS. (Require SharePoint Enterprise/Standard/Foundation)
- Excel Services. (Require SharePoint Enterprise)
SQL Services Reporting Services - SSRS
- Flexibility in defining specific formatting and layout, specific item -placement, multiple or composite report items, groups, headers, footers, subtotals
- Report caching and snapshot for better performance especially if the source data query is complex and takes longer to execute
- Creating report subscription for automatic report delivery via email or file share mode
- Can combine multiple data sources (relational and OLAP data) into a single report
- Additional charting options - map, area, range, scatter, polar, 3D, sparklines, data bars, etc
- As similar as PPS dashboard, SSRS reports can also be deployed on a SharePoint site for collaboration
- Harder to create dashboards and therefore often done by IT people
- No automatic drill-through and drill-across features
PerformancePoint Services - PPS
- Unique decomposition tree features for better and multi-level data analysis; you can refer to this tip for more on decomposition tree feature.
- Automatic drill-through and drill-across features using the decomposition tree on SSAS cube
- Stunning/great appearance of dashboard, score cards, etc.
- Scorecards allow users to enter comments against KPI values
- Usually, less development time required in comparison with SSRS reports or dashboard
- Comes with SharePoint 2013 Enterprise Edition
- Limited flexibility in defining formatting and layout; cannot be customized or modified as much as SSRS
is a remarkably good choice for a Self Service BI scenarios. The ease of development and the flexibility of the UI options are great. The greatest drawback is inability to interact with charts and graphs on the Excel Services rendered web page. Also, if you are trying to delight the end-user with you data visualization, it can be a challenge as the final product at the end still looks very much like Excel
Form more details check