Microsoft SQL Server Reporting Services (SSRS)
Microsoft is the world’s largest software company. Founded in 1975 and based in Redmond, USA, it has become a household name, primarily due to its Windows operating system and Office suite. Aside from these products, Microsoft offers a vast range of software including its own database, browser, various servers and ERP solutions.
In recent years, Microsoft has also begun to manufacture hardware, including tablets and gaming consoles.
Compared to the huge business the company does in other areas, its BI revenues are relatively small. Nevertheless, Microsoft is a strong presence in the BI market. In the past few years the vendor has spread its BI capabilities across the Office, SharePoint and SQL Server product lines, providing tools for formatted reporting, ad hoc reporting, analysis and dashboards. In 2015 Microsoft released a dedicated BI and analytics product portfolio called Cortana Intelligence Suite. Power BI – a dashboarding and analysis solution – is one of the components of this suite.
Microsoft SQL Server Reporting Services (SSRS) is the SQL Server component for formatted reporting and creating simple dashboards. Besides Reporting Services, Microsoft SQL Server consists of further products including a relational database management system, data integration and data quality components, and Analysis Services (SSAS) as a multidimensional database.
User & Use Cases
Survey data shows that Microsoft SQL Server Reporting Services is provided as part of the SQL Server bundle and focuses on the creation of formatted standard reports. 50 percent of users also say they use the product for advanced analysis. This is now more viable with the 2016 version, in which Microsoft integrated Revolution R into the SQL Server product to support data mining and advanced analytics scenarios.
The product is used in large scenarios, but mostly by mid-sized companies. We often see Microsoft SQL Server implemented as a data warehouse solution at this type of organization.
Current vs. planned use
N = 88
5 products most often evaluated in competition with Microsoft SSRS
N = 557
Percentage of employees using Microsoft SSRS
N = 86
N = 68
Number of users using Microsoft SSRS
N = 69
Tasks carried out with Microsoft SSRS by business users
N = 84
Company size (number of employees)
N = 86