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

*
*
*

Is Artificial Intelligence wasting our money?

If you are anything like me, you will have become addicted to online shopping. And like me your addiction might have led you to questioning if you are buying things unnecessarily. Asking yourself: Am I wasting my money? So, as... Read More

15 years on: How times have changed…

When I incorporated KDR 15 years ago this month I had a simple mission. I wanted to run the market leading agency in its field placing contract staff with experience of working with the emerging data warehouse tool Kalido. I... Read More

The life of a Business Administration apprentice!

I started my apprenticeship with KDR in the September of 2018, when I was searching for a job I never imagined that I would find a company quite like KDR, from the moment I first stepped through the door everyone... Read More

How can data analytics impact climate change?

Every quarter we produce an e-magazine on issues and topics within the data and analytics world. In our previous issues we have looked at the impact of blockchain , the future of the data warehouse and GDPR . In our next issue... Read More

Where should we send our newsletter?

Close