Dremio vs Tableau comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,693 views|2,048 comparisons
Tableau Logo
26,921 views|23,202 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and Tableau based on real PeerSpot user reviews.

Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms.
To learn more, read our detailed Data Science Platforms Report (Updated: March 2024).
765,234 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
"Everyone uses Dremio in my company; some use it only for the analytics function.""The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory.""We primarily use Dremio to create a data framework and a data queue.""Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it.""Dremio allows querying the files I have on my block storage or object storage.""Dremio gives you the ability to create services which do not require additional resources and sterilization."

More Dremio Pros →

"It’s good for quick visualization and being able to quickly consume unstructured data to play around with.""It allows us to basically understand and evaluate our numbers in an expedient manner.""Tableau has data relationships that can be applied to a data source which helps build out a directory which is helpful. Data blending has also been valuable to us.""The solution allows for the possibility for end-users to do their own reporting.""It has made the reporting stage simple and enabled us to focus mainly on the ETL part""The most valuable feature is the aggregation function.""Tableau is easy to use compared to some other solutions, such as Excel.""The most valuable part of the solution is the general dashboard features."

More Tableau Pros →

Cons
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people.""I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported.""Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement.""It shows errors sometimes."

More Dremio Cons →

"The customization requires a lot of effort and should be simplified. The performance could be better.""The price of Tableau is too high.""Lacks machine learning algorithms that you can implement using R, SPSS Modeler, and Python.""An area needing improvement involves the complexity of the product should you need to alter a lot of parameters. If you have technical servers, much interface, different providers and more serious processes, that will be time consuming.""The interface can be improved, in part because there is no indication that something is running or that it's processing.""The product needs to allow for better ways to drill down more effectively on the information at hand.""There's no mature ETL tool in Tableau, which is quite a negative for them.""It will be good if the server, could be more stable, and I would like to have the technical service to be more reliable."

More Tableau Cons →

Pricing and Cost Advice
  • "Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
  • "Dremio is less costly competitively to Snowflake or any other tool."
  • More Dremio 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 Data Science Platforms solutions are best for your needs.
    765,234 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:Dremio allows querying the files I have on my block storage or object storage.
    Top Answer:Every tool has a value based on its visualization, and the pricing is worth its value.
    Top Answer:Dremio's interface is good, but it has a few limitations. I cannot do a lot of things with ANSI SQL or basic SQL. I cannot use the recursive common table expression (CTE) in Dremio because the support… more »
    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
    Views
    2,693
    Comparisons
    2,048
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Views
    26,921
    Comparisons
    23,202
    Reviews
    19
    Average Words per Review
    620
    Rating
    8.6
    Comparisons
    Databricks logo
    Compared 39% of the time.
    Snowflake logo
    Compared 19% of the time.
    Starburst Enterprise logo
    Compared 13% of the time.
    Amazon Redshift logo
    Compared 4% of the time.
    Microsoft  Power BI logo
    Compared 17% of the time.
    Amazon QuickSight logo
    Compared 11% of the time.
    Domo logo
    Compared 8% of the time.
    SAS Visual Analytics logo
    Compared 4% of the time.
    SAP Analytics Cloud logo
    Compared 4% of the time.
    Also Known As
    Tableau Desktop, Tableau Server, Tableau Online
    Learn More
    Dremio
    Video Not Available
    Overview

    Dremio is a data lake query engine tool that creates PDSs and VDSs on top of S3 buckets. It is used for managing simple ad-hoc queries and as a greater layer for ad-hoc queries. The most valuable features of Dremio include its ability to sit on top of any data storage, generate refresh reflections and create visuals, manage changes effectively through data lineage and data providence capabilities, use open-source, and address the problem of data transfer when working with large datasets. The use cases are broad, allowing for high-performance queries from a data lake.

    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
    UBS, TransUnion, Quantium, Daimler, OVH
    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
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer5%
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company12%
    University7%
    Healthcare Company7%
    VISITORS READING REVIEWS
    Educational Organization34%
    Financial Services Firm11%
    Computer Software Company8%
    Manufacturing Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business32%
    Midsize Enterprise18%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise39%
    Large Enterprise47%
    Buyer's Guide
    Data Science Platforms
    March 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    Dremio is ranked 8th in Data Science Platforms with 6 reviews while Tableau is ranked 2nd in BI (Business Intelligence) Tools with 290 reviews. Dremio is rated 8.6, while Tableau is rated 8.4. The top reviewer of Dremio writes "Quick database capabilities but sometimes shows minor errors". 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". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas Tableau is most compared with Microsoft Power BI, Amazon QuickSight, Domo, SAS Visual Analytics and SAP Analytics Cloud.

    We monitor all Data Science Platforms 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.