Dremio vs SAS Visual Analytics comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,610 views|1,995 comparisons
100% willing to recommend
SAS Logo
3,388 views|2,758 comparisons
96% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and SAS Visual Analytics 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: April 2024).
768,740 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
"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 gives you the ability to create services which do not require additional resources and sterilization.""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.""Everyone uses Dremio in my company; some use it only for the analytics function.""We primarily use Dremio to create a data framework and a data queue.""Dremio allows querying the files I have on my block storage or object storage."

More Dremio Pros →

"Great for handling complex data models.""It provided the capability to visualize a bunch of data in an organized way.""The most solution's notable aspect, in my view, is the ability to integrate various data sources and harness advanced technologies such as machine learning and artificial intelligence. This helps with quality assurance processes.""Quick deployment to dashboards and analytics features (using SAS Visual Statistics and Enterprise Guide). Easy to create a simple forecast and discover business insights using segmentation tools.""Visual Analytics is very easy to use. I use Visual Analytics for all the typical use cases except text mining. I used it to analyze data and monitor statistics, not text mining. I also use it for data visualization as well as creating interactive dashboards and infographics.""Simplifies report designs and quickly displays tables and graphs.""The flexibility of the configuration is valuable to me.""I believe that the possibilities for exploring data and formulating visual results are quite good because it allows the business analyst to have different perspectives on the data."

More SAS Visual Analytics Pros →

Cons
"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.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""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.""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."

More Dremio Cons →

"The visualization should be better in SAS Visual Analytics. It is easy to use but when compared to other solutions it is lacking and the support is not very good.""The solution should improve its graphics.""A bit more flexibility in the temperatization will be helpful.""The deployment isn't smooth. Deploying Visual Analytics on the cloud takes a lot of work, or you can use some providers that give you SAS as a service. For example, there is a provider called SaasNow. They host SAS Visual Analytics and the license. You can buy the license and deploy it there without the hassle of installation because deploying the software isn't easy.""There are scalability issues. It depends on the data volume and number of end-users. VA requires a lot of hardware resources to move volumes of data.""Colours used on report objects""The installation process can be a bit complex.""It is not as mature as competitors such as Tableau and QlikView."

More SAS Visual Analytics 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 →

  • "Licensing is simple."
  • "$10,000 per annum for an enterprise license."
  • "The cost of the solution can be expensive. There is an additional cost for users."
  • "Visual Analytics is expensive for a small company like mine. You also need to deploy it on a server or cloud, so you pay for the license as well as the cost of the cloud or the server that you will deploy on."
  • "SAS Visual Analytics is expensive, as is the rest of the platform."
  • "It's approximately $114,000 US dollars per year."
  • "It was licensed for corporate use, and its licensing was on a yearly basis."
  • "The product is expensive."
  • More SAS Visual Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    768,740 professionals have used our research since 2012.
    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:The most solution's notable aspect, in my view, is the ability to integrate various data sources and harness advanced technologies such as machine learning and artificial intelligence. This helps with… more »
    Top Answer:The product is expensive and needs the integration of more languages.
    Ranking
    10th
    Views
    2,610
    Comparisons
    1,995
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    7th
    out of 70 in Data Visualization
    Views
    3,388
    Comparisons
    2,758
    Reviews
    8
    Average Words per Review
    393
    Rating
    8.5
    Comparisons
    Also Known As
    SAS BI
    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.

    SAS Visual Analytics is a data visualization tool that is used for reporting, data exploration, and analytics. The solution enables users - even those without advanced analytical skills - to understand and examine patterns, trends, and relationships in data. SAS Visual Analytics makes it easy to create and share reports and dashboards that monitor business performance. By using the solution, users can handle, understand, and analyze their data in both past and present fields, as well as influence vital factors for future changes. SAS Visual Analytics is most suitable for larger companies with complex needs.

    SAS Visual Analytics Features

    SAS Visual Analytics has many valuable key features. Some of the most useful ones include:

    • Data
    • Interactive data discovery
    • Augmented analytics
    • Chat-enabled analytics
    • Sharing and collaboration
    • Visual analytics apps
    • Embedded insights
    • Location analytics
    • Security and administration
    • In-memory engine

    SAS Visual Analytics Benefits

    There are many benefits to implementing SAS Visual Analytics. Some of the biggest advantages the solution offers include:

    • Machine learning and natural language: SAS Visual Analytics uses machine learning and natural language explanations to find, visualize, and narrate stories and insights that are easy to understand and explain. This enables you to find out why something happened, examine all options, and uncover opportunities hidden deep in your data.
    • Easy and efficient reporting: With SAS Visual Analytics, you can create interactive reports and dashboards so you can quickly summarize key performance metrics and share them via the web and mobile devices.
    • Easy to use: SAS Visual Analytics was designed to be easy to use. Its easy-to-use predictive analytics enables even business analysts to assess possible outcomes, which also helps organizations make smarter, data-driven decisions.
    • Self-service data: Self-service data preparation gives users the ability to import their own data, join tables, create calculated columns, apply data quality functions, and more. In turn, the solution empowers users to access, combine, clean, and prepare their own data in an agile way, which helps facilitate faster, broader adoption of analytics for your entire organization.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the SAS Visual Analytics solution.

    A Senior Manager at a consultancy says, “The solution is very stable. The scalability is good. The usability is quite good. It's quite easy to learn and to progress with SAS from an end-user perspective.

    PeerSpot user Robert H., Co-owner at Hecht und Heck GmbH, comments, “What I really love about the software is that I have never struggled in implementing it for complex business requirements. It is good for highly sophisticated and specialized statistics in the areas that some people tend to call artificial intelligence. It is used for everything that involves visual presentation and analysis of highly sophisticated statistics for forecasting and other purposes.

    Andrea D., Chief Technical Officer at Value Partners, explains, “The best feature is that SAS is not a single BI tool. Rather, it is part of an ecosystem of tools, such as tools that help a user to develop artificial intelligence, algorithms, and so on. SAS is an ecosystem. It's an ecosystem of products. We've found the product to be stable and reliable. The scalability is good.”

    Sample Customers
    UBS, TransUnion, Quantium, Daimler, OVH
    Staples, Ausgrid, Scotiabank, the Australian Institute of Health and Welfare, the Blue Cross and Blue Shield of North Carolina, Oklahoma Gas & Electric, Xcel Energy, and Triad Analytics Solutions.
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm30%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    REVIEWERS
    Government25%
    Insurance Company15%
    Financial Services Firm15%
    Retailer5%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Government13%
    Computer Software Company12%
    University7%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business31%
    Midsize Enterprise19%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    Buyer's Guide
    Data Science Platforms
    April 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: April 2024.
    768,740 professionals have used our research since 2012.

    Dremio is ranked 10th in Data Science Platforms with 6 reviews while SAS Visual Analytics is ranked 7th in Data Visualization with 35 reviews. Dremio is rated 8.6, while SAS Visual Analytics is rated 8.0. The top reviewer of Dremio writes "It enables you to manage changes more effectively than any other platform". On the other hand, the top reviewer of SAS Visual Analytics writes "Single environment for multiple phases saves us time, and has good visualizations". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas SAS Visual Analytics is most compared with Tableau, Microsoft Power BI, Databricks, Microsoft Azure Machine Learning Studio and Dataiku Data Science Studio.

    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.