Dremio vs SAS Visual Analytics comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,752 views|2,082 comparisons
100% willing to recommend
SAS Logo
2,822 views|2,240 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: May 2024).
772,679 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 gives you the ability to create services which do not require additional resources and sterilization.""Everyone uses Dremio in my company; some use it only for the analytics function.""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.""We primarily use Dremio to create a data framework and a data queue.""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."

More Dremio Pros →

"I like SAS Visual Analytics for its ability to provide an initial understanding of data through exploration, even before deep analytics.""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.""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.""I use Visual Analytics for enterprise reporting.""It integrates well with SAS, making it simple and quick for developers.""It provided the capability to visualize a bunch of data in an organized way.""The product is stable, reliable, and scalable.""It's quite easy to learn and to progress with SAS from an end-user perspective."

More SAS Visual Analytics Pros →

Cons
"I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported.""It shows errors sometimes.""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.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""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.""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."

More Dremio Cons →

"In Brazil, there are few documents, courses, and other resources for studying and implementing the tool.""SAS Visual Analytics could improve by making it more accessible for users outside the organization.""The licensing ends up being more expensive than other options.""I haven't come across any missing features.""It is not as mature as competitors such as Tableau and QlikView.""The reason we haven't rolled it out across the board is due to the fact that the licensing is so expensive.""There is room for improvement in anti-money laundering prevention and operation monitoring, as well as operation monitoring surveillance.""The product is expensive and needs the integration of more languages."

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.
    772,679 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,752
    Comparisons
    2,082
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    8th
    out of 74 in Data Visualization
    Views
    2,822
    Comparisons
    2,240
    Reviews
    9
    Average Words per Review
    402
    Rating
    8.7
    Comparisons
    Also Known As
    SAS BI
    Learn More
    Dremio
    Video Not Available
    Overview

    Dremio is a data analytics platform designed to simplify and expedite the data analysis process by enabling direct querying across multiple data sources without the need for data replication. This solution stands out due to its approach to data lake transformation, offering tools that allow users to access and query data stored in various formats and locations as if it were all in a single relational database.

    At its core, Dremio facilitates a more streamlined data management experience. It integrates easily with existing data lakes, allowing organizations to continue using their storage of choice, such as AWS S3, Microsoft ADLS, or Hadoop, without data migration. Dremio supports SQL queries, which means it seamlessly integrates with familiar BI tools and data science frameworks, enhancing user accessibility and reducing the learning curve typically associated with adopting new data technologies.

    What Are Dremio's Key Features?

    • Data Reflections: Reduces query times by creating optimized representations of source data, which can accelerate performance without the complexity of traditional data warehousing solutions.
    • Semantic Layer: Allows users to define business metrics and dimensions centrally, ensuring consistency and governance across all analytics tools.
    • Built-in Security Features: Provides robust security measures, including column- and row-level security, ensuring compliance with data governance and privacy standards.
    • Support for Multiple Data Formats and Sources: Enables querying directly against a variety of data formats (Parquet, JSON, etc.) and sources without the need for conversion or replication.

    What Benefits Should Users Expect?

    When evaluating Dremio, potential users should look for feedback on its query performance, especially in environments with large and complex data sets. Reviews might highlight the efficiency gains from using Dremio’s data reflections and its ability to integrate with existing BI tools without significant changes to underlying data structures. Also, check how other users evaluate its ease of deployment and scalability, particularly in hybrid and cloud environments.

    How is Dremio Implemented Across Different Industries?

    Dremio is widely applicable across various industries, including finance, healthcare, and retail, where organizations benefit from rapid, on-demand access to large volumes of data spread across disparate systems. For instance, in healthcare, Dremio can be used to analyze patient outcomes across different data repositories, improving treatment strategies and operational efficiencies.

    What About Dremio’s Pricing, Licensing, and Support?

    Dremio offers a flexible pricing model that caters to different sizes and types of businesses, including a free community version for smaller teams and proof-of-concept projects. Their enterprise version is subscription-based, with pricing varying based on the deployment scale and support needs. Customer support is comprehensive, featuring dedicated assistance, online resources, and community support.

    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 Firm31%
    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 Enterprise73%
    REVIEWERS
    Small Business31%
    Midsize Enterprise19%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    Buyer's Guide
    Data Science Platforms
    May 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: May 2024.
    772,679 professionals have used our research since 2012.

    Dremio is ranked 10th in Data Science Platforms with 6 reviews while SAS Visual Analytics is ranked 8th in Data Visualization with 36 reviews. Dremio is rated 8.6, while SAS Visual Analytics is rated 8.2. 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.

    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.