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

SQL Server 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

SQL Server
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
266
Ranking in other categories
Relational Databases Tools (1st)
Tableau
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
295
Ranking in other categories
BI (Business Intelligence) Tools (2nd), Reporting (2nd), Data Visualization (1st), Embedded BI (1st)
 

Mindshare comparison

SQL Server and Tableau aren’t in the same category and serve different purposes. SQL Server is designed for Relational Databases Tools and holds a mindshare of 21.1%, down 23.1% compared to last year.
Tableau, on the other hand, focuses on BI (Business Intelligence) Tools, holds 19.7% mindshare, up 18.9% since last year.
Relational Databases Tools
BI (Business Intelligence) Tools
 

Featured Reviews

Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.
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

"It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
"The solution has a reliable database."
"The solution is easy to use and provides similar features to other competitors."
"It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work."
"If we want to expand to other servers and create an extra node, it's expandable."
"What I like most is the management, as it is very easy compared with other products."
"We like business integration, database, and analysis."
"The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations."
"It's the ease of use. It is also a self-service tool so it decreases the burden on having centralized IT-type teams or developers."
"It's very user-friendly. It's not like Power BI, Tableau is very user-friendly. Anybody can use Tableau. It's very easy to adopt things. I can visualize the stats."
"It's very easy to visualize data with this product. The visualization maps of and frames that we have been able to cross-reference has been excellent."
"Tableau has greatly enhanced our organization's data-driven decision-making processes by enabling us to create visually compelling reports and dashboards."
"The stability seems to be very reliable."
"The product has the best features for analytical views and filters."
"Compared to other products, visualization features are really good."
"It has a shallow learning curve and so you can go to market very, very, very quickly."
 

Cons

"Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."
"The solution could offer more integration with other platforms."
"SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."
"Even if you have some technical agreement with Microsoft, the technical support of the solution won't help you. The support needs to be improved."
"Improvement in SQL Server should focus on lowering the high cost, especially for environments requiring extensive CPU and memory usage like data warehousing"
"I would like to have more replication scenarios."
"SQL Server doesn't have proper bitmap indexing, proper columnar databases, or proper implementation of materialized views."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
"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."
"The setup was easy but we are having some problems with the configuration that is taking a long time. We have done some initial tests and some of the delays could be from bandwidth issues. However, the whole installation process should be simplified."
"There are not enough language options. It needs to be offered in more than just English."
"The Hyper Extract functionality is not as strong as that provided by Microsoft SQL."
"People are migrating to Microsoft BI due to the speed, which is quite slow to load, and the lack of visualization options."
"Provide additional enhancements in any business process: Operations, Marketing and Sales, Finance, Human Resources, Logistics, etc."
"Lacks machine learning algorithms that you can implement using R, SPSS Modeler, and Python."
"Lacks customization in some areas."
 

Pricing and Cost Advice

"The solution is on a pay-per-use pricing model."
"The price has been going higher and higher. The market is quite price sensitive."
"I don't know the exact prices because my focus is essentially technical and not on the bills. A few years ago, they changed the billing policy for the Enterprise Edition, and it became less attractive. But I believe they are still cheaper than Oracle. SQL Server isn't cheap, but it's not expensive either."
"Their options for concurrency and locking are good, as well as their prices."
"There is a license required for this solution and we pay monthly. The price is reasonable compared to other solutions."
"There is an annual license and it is priced reasonably."
"For our purpose, we are not required to have a license for what we are using it for."
"The product’s price depends on the specific server requirements."
"It is a bit difficult for some people when they hear $70.00 per month, as some solutions are available for less than $10.00 or for free."
"Tableau can be costly (but this can be indefinable, such as user experience vs. cheaper etc.)"
"It is expensive when you compare it with Power BI. It should be cheaper."
"I believe it has a lifelong license, and once you purchase it, you don't have to renew it, but I'm not sure."
"The pricing is $70 per month. You have to pay about $800 or something in that ballpark annually for one license."
"Its licensing cost should be improved."
"The pricing for Tableau is the same as the other products in the market."
"This solution is a bit expensive. The pricing options have become more difficult over the years. I think they are bordering on pricing themselves out of the market. They need different pricing options for various-sized businesses. Where my organization is a large organization, we are happy to pay a higher price because we can leverage the products very extensively. For smaller enterprises, different pricing options would be good."
report
Use our free recommendation engine to learn which Relational Databases Tools 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
Educational Organization
51%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
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

Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
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 ...
 

Comparisons

 

Also Known As

Microsoft SQL Server, MSSQL, MS SQL
Tableau Desktop, Tableau Server, Tableau Online
 

Overview

 

Sample Customers

Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
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, Oracle, SAP and others in Relational Databases Tools. Updated: January 2025.
831,265 professionals have used our research since 2012.