Microsoft SQL Server Reporting Services (SSRS)
Microsoft SQL Server Reporting Services (SSRS) is the SQL Server component for the creation of different report formats as well as the publication of content such as reports, KPIs, and Excel and Power BI files using a central web-based portal. Besides Reporting Services, Microsoft SQL Server consists of further products including a relational database management system, data integration and data quality components, and the multidimensional database Analysis Services (SSAS).
Microsoft is the world’s largest software company. Founded in 1975 and headquartered in Redmond, it has become a household name, primarily due to its Windows operating system and Office suite. Aside from these products, Microsoft has a vast range of enterprise software and cloud offerings including its own database, browser, various servers and ERP solutions. In recent years, Microsoft has focused its business on cloud-based solutions such as Azure. AI and machine learning have also become increasingly important in product development.
Compared to the huge business the company does in a range of different markets, its BI front end revenues are relatively small. Nevertheless, Microsoft is a strong presence in the BI market and its offering is strategic to complement existing solutions and to drive cloud revenues. In the past, the vendor spread its BI capabilities across the Office, SharePoint and SQL Server product lines, providing tools for formatted reporting, analysis and dashboards. However, in 2015, Microsoft released a dedicated BI and analytics product called Power BI, which is a data discovery and dashboarding solution. Our product review describes SQL Server Reporting Services.
User & Use Cases
Microsoft SQL Server Reporting Services is much liked by mid-sized companies as many use the SQL Server database to create their data warehouse. There is an emphasis on standard/enterprise reporting with SSRS, although 67 percent of users also report using it for dashboards. This partly reflects the historical use of the software for creating simple dashboards, as well as the use of technology from the Datazen acquisition to build visually appealing mobile reports.
Interestingly – and in contrast to previous years when SSRS was frequently evaluated against other Microsoft products – none of its top five rival solutions this year come from Microsoft. This highlights a general trend we have observed in The BI Survey this year: Many customers are now seeking a business power user-oriented solution to help them analyze and visualize data.
Current vs. planned use
5 products most often evaluated in competition with Microsoft SSRS
Percentage of employees using Microsoft SSRS
Number of users using Microsoft SSRS
Tasks carried out with Microsoft SSRS by business users
Company size (number of employees)
Want to see the whole picture?
BARC’s Vendor Performance Summary contains an overview of The BI Survey results based on feedback from Microsoft SQL Server Reporting Services (SSRS) users, accompanied by expert analyst commentary.Contact us to purchase the Vendor Performance Summary