SSRS
By Haroon Choudry
23rd August 2018

Experience with the Microsoft BI full stack (SSIS, SSAS, SSRS) is in incredibly high demand with many organisations working with a heavy Microsoft tech stack, however nothing causes more controversy than one particular service in that stack; questioning the future of SSRS.

It is a well-known fact that Data Visualisation is growing massively, many organisations are getting on board with the likes of Tableau, Qlikview and most recently Power BI (a tool we ourselves use at KDR Recruitment). 

Is the rise of Power BI killing SSRS?

What is the purpose of SSRS?

SSRS (SQL Server Reporting Services) is part of the Microsoft SQL Server Suite alongside SSIS and SSAS. It is Microsoft’s tool for traditional paginated document-style reports, simply put- the more data you have, the more rows in a table therefore the more pages. SSRS is essentially used for analysing data and generating reports from a server. SSRS first came to market in 2004 and even though it is built on older technology it is used a lot within the BI function of organisations.

How has Power BI affected this?

Power BI is a data visualisation tool used for analysing data and generating interactive visual reports from either a server or the cloud. 

Power BI gives users a more interactive way of understanding data with its slick visualisations. Power BI now also has the capability to render analytical reports. It has now come to a point where Power BI can do almost everything SSRS can and then some! 

On paper choosing Power BI over SSRS seems like a no brainer, Educba did a great comparison table of the two which can be found below:

SSRS vs BI

Controversy!

A discussion on LinkedIn surrounding the future of SSRS reflected how uncomfortable people are with the prospect of no SSRS. Here are some comments on one of my posts:

“SSRS was the first tool that I used in BI. It's too special to me. I can't see it die”

“Printing in Power BI is challenging. When a customer needs a printable report, we have to switch to SSRS.”

“It would have died if MS SQL 2016 would not have combined Power BI with SSRS together. They want it to survive for few more years may be.....”

It’s just a matter of time…

Microsoft SQL Server 17 didn’t include SSIS as part of the already included suite of tools. Candidates are telling me that Power BI will take over completely. This isn’t just the decline of SSRS, it’s the decline of your bog-standard printed reporting. 

Do you think SSRS is dying? Do you see Power BI taking over? Let me know the thoughts in the comments below!

KDR Recruitment is the home of the best Information Management and Data Analytics jobs. For more tech news and views check out the KDR blog or follow KDR on LinkedIn.

This blog was originally published on LinkedIn. To read the original blog, click here

View the latest data and analytics jobs

Comments

Very interesting tabled details.
Posted on Wednesday, August 29, 2018 07:57 by Sampath R.

Post Comment

*
*
*

How far does data and analytics go and what can it do for you or your business?

Having worked in recruitment for a number of years I have recently joined KDR Recruitment focusing within the Data Analytics sector. I have always been a fan of analysing the finer details to my work but what I have learned... Read More

Is technology impacting the way we apply for jobs?

Technology is having an impact on every aspect of our lives, and no less in our job search. Tech is not just changing the way I, as a recruiter, find the best candidates for a role but also how the... Read More

Is SSRS dying?

Experience with the Microsoft BI full stack (SSIS, SSAS, SSRS) is in incredibly high demand with many organisations working with a heavy Microsoft tech stack, however nothing causes more controversy than one particular service in that stack; questioning the future... Read More

Data and Formula E

Upon a brief search of the web, you will find tons and tons of blogs relating to how data is used in Formula 1 , but what about its younger brother, Formula E? I was genuinely surprised at the lack of... Read More

Where should we send our newsletter?

Close