Microsoft SQL Server Reporting Services vs Tableau comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
4,785 views|3,416 comparisons
86% willing to recommend
Tableau Logo
17,135 views|14,826 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft SQL Server Reporting Services and Tableau based on real PeerSpot user reviews.

Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Microsoft SQL Server Reporting Services vs. Tableau Report (Updated: March 2024).
772,649 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"We can create quality reports in real time.""The tool's valuable features are its drill-down feature, graphs, and charts.""We get good support from Microsoft.""The initial setup is easy.""I am impressed with the product's seamless integration. It can work with different databases like Oracle.""The solution's features are all just wrapped up in one nice easy package. I don't need a lot of toolsets to get everything I need done.""I mainly use the solution for the ease of reporting and for executive dashboards.""The stability of SSRS has been reliable, with minimal issues encountered during our usage."

More Microsoft SQL Server Reporting Services Pros →

"It is definitely easy to use. It is intuitive, and more or less, everything can be done from the front end. As such, there is no concept of metadata. You can just take data from a database and start building your own stuff, such as OLAP data warehouse. You don't need extensive metadata modeling like Oracle BI.""Show Me is a feature to help with knowing which chart is an appropriate one for the selected variables, and it makes helps in creating appropriate visuals.""Very user friendly.""The most valuable part of the solution is the general dashboard features.""The product’s performance is better than other tools.""A valuable feature of Tableau is that it is a useful tool for small setups. I shuffle between Tableau and MicroStrategy, so I use Tableau for personal purposes more than enterprise. I like the light version of Tableau for personal usage and doing some use cases on my own. When it comes to something small, I use Tableau for setups, rather than any other tool.""I really like the interactivity of the dashboards.""Data Interpreter: Which can identify issues or potential errors with your imported data."

More Tableau Pros →

Cons
"Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality.""We encounter some barriers while trying to build a report.""Sometimes, we need to make sure that the configuration stays consistent across the reporting instances. They all connect to the same database. So, it shares that same backend, but the reporting services itself can also be configured. On the application level, for reporting level. And it is, based on my own experience, it is a manual effort to make sure that the reporting servers are configured the same across the environment.""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 solution's interface is old.""The setup is difficult because you have to install different servers.""Microsoft SQL Server Reporting Services needs to improve performance.""The product could be improved by reducing the time it takes to build and deploy reports."

More Microsoft SQL Server Reporting Services Cons →

"When you create new fields in Tableau and you enter the formulas, there is a new small window that is there in the interface. You can enter the calculated fields, it could be more user-friendly. At this time it is limited and hard to understand at the beginning. The fields should be easier to use, such as in Microsoft Excel. You can have a difficult time understanding what to do in the fields, you end up doing trial and error to figure it out.""There should be stronger data modules for the platform.""Implementation requires a technical background.""To be the best in the market, Tableau has to improve its user interface and also look into developing implementing the best machine learning algorithms.""Navigating through activities like cleansing, reshaping, and wrangling extensive or complicated datasets could prove challenging within the Tableau environment.""The product's features for cloud integration need improvement.""I would like to be able to set the parameters in a more specific manner.""Requires a lot of user training."

More Tableau Cons →

Pricing and Cost Advice
  • "The price is pretty good."
  • "The solution is expensive."
  • "The solution is cheaper than its alternatives."
  • "The solution is free to use for developers."
  • "The tool's licensing costs are expensive."
  • "Value-wise, the solution's pricing is good for the price that we pay."
  • "The product pricing is reasonable in terms of suitable features for business."
  • More Microsoft SQL Server Reporting Services Pricing and Cost Advice →

  • "For big business, Tableau could be expensive as having a lot of Tableau server users (entering with a browser to reports) could be a bit expensive."
  • "Best advice on pricing is to anticipate the desire for more licenses once the results of this product are acknowledged in other parts of your company."
  • "Paying for users you never setup or buying expensive desktop licenses for users who can solve their users with web editing on the server are the two biggest expenses."
  • "Buy 50 at a time. Project your use base every three months, and project your requirements forward."
  • "Tableau can be costly (but this can be indefinable, such as user experience vs. cheaper etc.)"
  • "I wish there was more of a subscription model with the pricing when it comes to Tableau, so you can get all the latest version upgrades/features if you pay monthly/annually."
  • "The cost is high."
  • "Deployment of dashboards to viewers and unit supervisors can be prohibitively expensive."
  • More Tableau Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Reporting solutions are best for your needs.
    772,649 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    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 use to create and share insights. It is also the tool of choice for rapid prototyping of dashboards. Tableau is very flexible with its data import. Tableau's data blending capability is very intuitive. This capability is useful when you have data spread across several different sources that has not gone through ETL processes. This is a problem analysts deal with routinely. They are unable to wait for the data warehouse team to develop ETL processes to provide the physical models they need to build an analysis. The Tableau interface is Excel-like and has a low barrier to entry for analysts that are used to working in Excel. Building a dashboard by mashing up visualizations in a Tableau worksheet is extremely simple. Users are able to build good presentation-quality dashboards in a very short amount time. Tableau's annotations capabilities and its time and geographical intelligence are key differentiators. Tableau has overcome limitations in data sharing with the introduction of a Data Server in Tableau 7.0. The Data server allows Data sources and extracts to be shared securely and opens up interesting new possibilities. If your application can take advantage of the above… Read more →
    Questions from the Community
    Top Answer:I mainly use the solution for the ease of reporting and for executive dashboards.
    Top Answer:According to me, the solution's pricing is very expensive, but I don't know how much Oracle or other competitors would cost. Since I am unfamiliar with other pricing schemes, the solution's pricing… more »
    Top Answer:I'm starting to use Power BI this year, and it would be really nice to have better integration between the solution and Power BI.
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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… more »
    Ranking
    8th
    out of 50 in Reporting
    Views
    4,785
    Comparisons
    3,416
    Reviews
    10
    Average Words per Review
    348
    Rating
    7.6
    2nd
    out of 50 in Reporting
    Views
    17,135
    Comparisons
    14,826
    Reviews
    13
    Average Words per Review
    537
    Rating
    8.7
    Comparisons
    Also Known As
    SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
    Tableau Desktop, Tableau Server, Tableau Online
    Learn More
    Overview

    At Microsoft, our mission is to empower every person and every organization on the planet to achieve more. Our mission is grounded in both the world in which we live and the future we strive to create. Today, we live in a mobile-first, cloud-first world, and the transformation we are driving across our businesses is designed to enable Microsoft and our customers to thrive in this world.

    We do business in 170 countries and are made up of 114,000 passionate employees dedicated to fulfilling our mission of helping you and your organization achieve more.

    Tableau is a tool for data visualization and business intelligence that allows businesses to report insights through easy-to-use, customizable visualizations and dashboards. Tableau makes it exceedingly simple for its customers to organize, manage, visualize, and comprehend data. It enables users to dig deep into the data so that they can see patterns and gain meaningful insights. 

    Make data-driven decisions with confidence thanks to Tableau’s assistance in providing faster answers to queries, solving harder problems more easily, and offering new insights more frequently. Tableau integrates directly to hundreds of data sources, both in the cloud and on premises, making it simpler to begin research. People of various skill levels can quickly find actionable information using Tableau’s natural language queries, interactive dashboards, and drag-and-drop capabilities. By quickly creating strong calculations, adding trend lines to examine statistical summaries, or clustering data to identify relationships, users can ask more in-depth inquiries.

    Tableau has many valuable key features:

    • Tableau dashboards provide a complete view of your data through visualizations, visual objects, text, and more.
    • Tableau provides convenient, real-time options to collaborate with other users and instantly share data in the form of visualizations, sheets, and dashboards. 
    • Tableau ensures connectivity to both live data sources and data extraction from external data sources as in-memory data. This gives users the flexibility to use data from more than one source without any restrictions. 
    • Tableau gives many data source option, ranging from spreadsheets, big data, on-premise files, relational databases, non-relational databases, data warehouses, and big data, to on-cloud data. 
    • Tableau has a lot of pre-installed information on maps, such as cities, postal codes, and administrative boundaries. 
    • Tableau has a foolproof security system based on authentication and permission systems for data connections and user access. Tableau also gives you the freedom to integrate with other security protocols.

    Tableau stands out among its competitors for a number of reasons. Some of these include its fast data access, easy creation of visualizations, and its stability. PeerSpot users take note of the advantages of these features in their reviews:

    Romil S., Deputy General Manager of IT at Nayara Energy, notes, "Its visualizations are good, and its features make the development process a little less time-consuming. It has an in-memory extract feature that allows us to extract data and keep it on the server, and then our users can use it quickly.

    Ariful M., Consulting Practice Partner of Data, Analytics & AI at FH, writes, “Tableau is very flexible and easy to learn. It has drag-and-drop function analytics, and its design is very good.

    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.
    Top Industries
    REVIEWERS
    Computer Software Company25%
    Financial Services Firm17%
    Retailer8%
    Healthcare Company8%
    VISITORS READING REVIEWS
    Financial Services Firm15%
    Government10%
    Computer Software Company10%
    Healthcare Company7%
    REVIEWERS
    Financial Services Firm13%
    Computer Software Company12%
    University7%
    Healthcare Company7%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm12%
    Computer Software Company8%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business26%
    Midsize Enterprise11%
    Large Enterprise63%
    VISITORS READING REVIEWS
    Small Business23%
    Midsize Enterprise14%
    Large Enterprise63%
    REVIEWERS
    Small Business32%
    Midsize Enterprise18%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise40%
    Large Enterprise46%
    Buyer's Guide
    Microsoft SQL Servering Services vs. Tableau
    March 2024
    Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. Tableau and other solutions. Updated: March 2024.
    772,649 professionals have used our research since 2012.

    Microsoft SQL Server Reporting Services is ranked 8th in Reporting with 16 reviews while Tableau is ranked 2nd in Reporting with 293 reviews. Microsoft SQL Server Reporting Services is rated 7.8, while Tableau is rated 8.4. The top reviewer of Microsoft SQL Server Reporting Services writes "Offers useful templates but needs to improve the connectivity offered". On the other hand, the top reviewer of Tableau writes "Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time". Microsoft SQL Server Reporting Services is most compared with Microsoft Power BI, TIBCO Jaspersoft, SAP Crystal Reports, Oracle OBIEE and IBM Cognos, whereas Tableau is most compared with Microsoft Power BI, Domo, Amazon QuickSight, SAS Visual Analytics and Databricks. See our Microsoft SQL Server Reporting Services vs. Tableau report.

    See our list of best Reporting vendors.

    We monitor all Reporting reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.