Information Matters – Data Visualisation vs Traditional Reporting
March 26th, 2019
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?
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.
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:
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…..”
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?
This blog was originally published on LinkedIn. To read the original blog, click here