Try our new research platform with insights from 80,000+ expert users

Microsoft SQL Server Reporting Services vs Tableau comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft SQL Server Report...
Ranking in Reporting
6th
Average Rating
7.8
Reviews Sentiment
8.0
Number of Reviews
18
Ranking in other categories
No ranking in other categories
Tableau
Ranking in Reporting
2nd
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
295
Ranking in other categories
BI (Business Intelligence) Tools (2nd), Data Visualization (1st), Embedded BI (1st)
 

Mindshare comparison

As of January 2025, in the Reporting category, the mindshare of Microsoft SQL Server Reporting Services is 3.5%, down from 4.9% compared to the previous year. The mindshare of Tableau is 23.7%, up from 22.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

Gnanavel-Chakkarapani - PeerSpot reviewer
Offers useful templates but needs to improve the connectivity offered
In Microsoft SQL Server Reporting Services, not much of the interface part is used. With Microsoft SQL Server Reporting Services, its users face issues with the interface after they use Excel or create Microsoft SSIS Packages. The tool's interface is an area of concern requiring improvement. There needs to be an improvement in the product's connectivity so that the tool can connect easily with other third-party databases. In the dashboard, drag and drop functionality needs to improve, especially when compared to other tools like IBM Cognos Analytics and Qlik Sense. Microsoft SQL Server Reporting Services is useful only for standard reports. In IBM Cognos Analytics, query studio can be used by users to drag the data and simply download the reports, so the user doesn't need to have any technical knowledge like developers. Microsoft SQL Server Reporting Services is to be improved to offer features like query Studio, which is provided in IBM Cognos Analytics.
ROMIL SHAH - PeerSpot reviewer
Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time
When it comes to visualizations, Tableau has a limitation as compared to Power BI. It has a limited set of visualizations. Power BI has the entire marketplace, so you can connect and import many visualizations and use them, whereas Tableau has only 10 or 15 visualizations. There should be more visualizations, and there should also be data integration with more cloud providers. Tableau has recently launched a paid version for the documentation. So, documentation has become a little bit challenging when it comes to Tableau development because we do not have any tool to export the data out of it. It is a license-based feature that you need to purchase to prepare documentation. So, on the documentation front, for preparing clear documentation for any dashboard, it would help if we get an embedded option, rather than buying a license for each user for the documentation. To document anything, if I have to connect to each workbook and see what has been written as a formula and then document in the Word document, it is pretty time-consuming. We have the Microsoft stack, and we are currently evaluating Power BI because Tableau has a limitation of 50 columns for a drill-down report. If we want more than 50 columns, we have found a hack, but there is no ready-made option for doing it. So, we have to use another tool in case we need a drilled report with more than 50 columns. There are many instances where users need 80 or 90 columns for their analysis, and switching between two technologies becomes a challenge. It is not a cost-effective approach for us. Their support should be improved. We are not happy with their support. Whenever we raised queries, we were pointed to a few blogs, and we didn't get a proper solution from them. Their licensing should also be improved. They want us to purchase a Tableau Creator license for business users, whereas Power BI Desktop is free for business users. They should come up with a basic license with one or two connectors that our business users can use for preparing their visualizations. Tableau also charges us per user for users who want the data only through email.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The initial setup is easy."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"We get good support from Microsoft."
"We can create quality reports in real time."
"In Microsoft SQL Server Reporting Services, the installation and configuration are easy."
"It is scalable."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"The dashboards are amazing, with different report types and stunning visuals. Most importantly, Tableau's AI with machine learning automatically predicts features and reports based on historical data. These are the three most valuable features for me."
"The geospatial maps representation and the visualizations are nice."
"The solution has a lot of customization when comparing to Microsoft BI."
"Compared to other products, visualization features are really good."
"This service is the combination of very pleasant, interactive graphical visualizations along with the application of advanced statistical models (in some cases)."
"Easy for beginners to use"
"It has made the reporting stage simple and enabled us to focus mainly on the ETL part"
"Self-service is most valuable. Users can pick up quickly and do the resolution. There are a lot of out-of-the-box features, and it satisfies most of the needs. If users are properly trained, they can deal with any situation."
 

Cons

"The setup is difficult because you have to install different servers."
"There is room for improvement in the pricing model."
"It is not easy to integrate the product with other tools in the market."
"It doesn't have quite the flexibility of a Tableau or something like that. Many users are more comfortable with Tableau and I'm not quite sure why that is right now, but it seems to be the case."
"The product could be improved by reducing the time it takes to build and deploy reports."
"I would like the solution to add the scheduling feature for reports."
"Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality."
"In this solution, the cost should be reduced for the enterprise edition."
"There should be more GIS features, such as location analysis, which is quite limited. There are very few location-based functionalities."
"In the cloud sometimes the performance is a little bit slow."
"Other tools are more competitively priced."
"Provide additional enhancements in any business process: Operations, Marketing and Sales, Finance, Human Resources, Logistics, etc."
"Tableau could be improved by introducing a data manipulation layer within the tool itself. Currently, data manipulations require using additional tools like Alteryx. If Tableau included these capabilities, it would reduce the need for external dependencies. The tool gets slower when we feed huge amounts of data."
"When we put more information on a single screen, it gets compressed and superimposed in many places while scrolling."
"The solution needs to improve its integration capabilities."
"Tableau is a company that does not respect partners."
 

Pricing and Cost Advice

"The pricing is high."
"The price is pretty good."
"The product pricing is reasonable in terms of suitable features for business."
"Value-wise, the solution's pricing is good for the price that we pay."
"The solution is free to use for developers."
"The solution is cheaper than its alternatives."
"The tool's licensing costs are expensive."
"The solution is expensive."
"For data extraction and analysis, Tableau is better than any other tool I have used with the same pricing model."
"Tableau is free."
"Its licensing cost should be improved."
"We are on an annual license which costs us $1,400 which is very expensive. Microsft BI is less expensive."
"The pricing is $70 per month. You have to pay about $800 or something in that ballpark annually for one license."
"I'm using Tableau Public, which is free."
"The solution's licensing is based on user-basis. It depends on the business ROI it offers. It's not on the higher side or too cheap; it falls in the medium-cost range. The price is determined by user usage, so the cost will also increase as the number of users increases."
"The pricing for Tableau is the same as the other products in the market."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
831,265 professionals have used our research since 2012.
 

Comparison Review

it_user6330 - PeerSpot reviewer
May 2, 2013
MicroStrategy vs. Tableau
After a recent presentation, several attendees asked me about the applications of Visual Insights and Tableau. Many companies are investing in both tools and are trying to figure out the right tool for specific applications Tableau has found its sweet-spot as an agile discovery tool that analysts…
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Government
12%
Computer Software Company
9%
Manufacturing Company
6%
Educational Organization
43%
Financial Services Firm
10%
Computer Software Company
7%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Microsoft SQL Server Reporting Services?
I mainly use the solution for the ease of reporting and for executive dashboards.
What is your experience regarding pricing and costs for Microsoft SQL Server Reporting Services?
Microsoft SQL Server Reporting Services should be okay if you're within the budget. We're just using open-source solutions if you're not within the budget. Sometimes, we use MySQL or something simi...
What needs improvement with Microsoft SQL Server Reporting Services?
QL Server can support the customer language in the long term, so we can use another language to build some components.
Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos Enter...
Tableau vs. Business Objects - Which is a better solution for visualization and analysis?
Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it consta...
Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies ...
 

Also Known As

SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
Tableau Desktop, Tableau Server, Tableau Online
 

Overview

 

Sample Customers

CMS Wire, The New York Times
Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. Tableau and other solutions. Updated: January 2025.
831,265 professionals have used our research since 2012.