The BI strategy is centered on two key suites of products—'SQL Server' and 'Office'. SQL Server is used as the data and reporting platform and Office provides popular easy-to-use front-end tools for end users to view and manage the data and analysis. This includes products such as Excel, Word, and SharePoint.
The key point is that SharePoint provides a central way to collaborate online. This is where reports serve the purpose of sharing the data for trends about business processes. SharePoint is a central collaboration tool enabling users to view and manage reports within SharePoint. That is the key motivation behind Reporting Services integration with SharePoint. SQL Server Reporting Services (SSRS) is one of the components in the Business Intelligence platform, which provides the unified, server-based, extensible, and scalable platform to deliver and present data. SSRS is capable of generating reports in various formats (HTML, XLS, PDF, CSV, and...