Business Intelligence in SharePoint 2010 – SSRS,SSRS with Denali,Performance Point,Excel Services,Project Crescent
Here is a quick view of when do you use SSRS Vs Performance Point Vs Excel Services while planning Business Intelligence in SharePoint 2010. Also, I have added a few lines about SSRS with SQl server 2012 or Denali and building reports using Project “Crescent”.
- Use SSRS when Report requirements are defined.
- Underline data Source is unknown or should remain Unknown.
- Features likes caching,Subscriptions etc.
SSRS with SQl server 2012 or Denali - In the new SQl server 2012 SSRS is integrated in SharePoint 2010 as a Service application. This has few benefits over the old SSRS
- Easy deployment of SSRS reports in SharePoint 2010 server.
- Since SSRS is an Service application and now has its own database (like any other service application database) administrators can perform all the day-to-day activities like backup\restore, checking uls logs using Powershell etc.
- Denali is using Visual Studio 2010 so new reports can be build in Visual studio 2010 and published to SharePoint.
Performance Point (PP) -
- When you want to use Context-driven Dashboards across system.
- You need Transparency & accountability.
- You can Create KPI from different sources.
- You use Performance Point Services when you need Multi-dimensional analysis for root cause.
Excel Services -
- When you have to increase the reach for example – Sending excel sheet to multiple users.
- Scenario based analysis like a sheet specific for Real estate.
- You need to share and collaborate.
Project Crescent -
Project “Crescent” is a new immersive ad-hoc visualization tool that is part of SQL Server 2012 Code Name “Denali” Reporting Services. Project “Crescent” is designed with end users in mind to quickly, easily, and visually explore their data and answer ad-hoc questions in just a few clicks.
Project “Crescent” is a tool where users can drag and drop components on web page and create a nice looking reports. Once your done with your reports you can publish it to SharePoint as well.