Alteryx vs Dremio comparison

Cancel
You must select at least 2 products to compare!
Alteryx Logo
12,334 views|7,198 comparisons
88% willing to recommend
Dremio Logo
2,683 views|2,043 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out in this report how the two Data Science Platforms solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Alteryx vs. Dremio Report (Updated: March 2024).
771,157 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
"Alteryx's connectivity is essential. We like the ability to connect the solution to multiple sources. It's easier than other data modeling and extraction solutions. It's built on a self-service concept, so it's easy for anyone to open the tool and directly import or export data from it.""The filtering is fast, and it provides a search tool that is great.""The tools are built-in. You just plug and play, drag and drop, once you understand how to use the tools, it is easy.""Predictive models, which are easy to use, and help a lot with fast design and deployment​.""It is one of the most complete and great customer service that I experienced with a software company/ecosystem.""The Alteryx designer has been the most useful feature in the solution.""It is a stable and scalable solution.""Alteryx is so advanced. It's just drag and drop."

More Alteryx 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.""Dremio gives you the ability to create services which do not require additional resources and sterilization.""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."

More Dremio Pros →

Cons
"The solution just lacks in terms of data visualization. That is why we use Tableau and Qlik in our organization. They help to pick up the slack. If data visualization was added, Alteryx would be a very good tool, and much more complete.""Sometimes workflows tend to queue up, and they tend to get canceled for some reason that we don't know sometimes.""The screen when you are looking into your workflows and your ETL processes needs to be improved. You cannot manage it very well.""Alteryx can improve in data science. They have to have more features and components in the data science aspect because they claim to be a data science tool. However, in order to be more competitive, they have to improve on their data science propositions. Thre are other solutions on the market, such as other players in the market, Data2Go or DataIQ, and Alteryx needs to catch up.""The formula we currently use in Alteryx can be automated.""I'd like it to be easier to work with PDF.""They should work on its pricing.""The interface could be improved."

More Alteryx Cons →

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

More Dremio Cons →

Pricing and Cost Advice
  • "A designer and scheduler for $13K/year in total is pretty much earning you the money back in time and in other resources."
  • "​Very transparent.​"
  • "The seat is too expensive."
  • "It can be a bit pricey, especially after the first year."
  • "The pricing is $5000 per year per production license."
  • "We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees."
  • "There are some implementation services and internal effort costs at the beginning but there is nothing else."
  • "The price for Alteryx Designer is reasonable but the price for Alteryx Server for universal collaborations is too expensive."
  • More Alteryx 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 →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    771,157 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:One of the differences is that with Alteryx you can use it as an ETL and analytics tool. Please connect with me directly if you want to know more.
    Top Answer:Alteryx is an extremely easy and flexible data tool, flexible in terms of drag and drop toolset and also has python, R integrations if your team requires this It can handle over 2 billion rows of… more »
    Top Answer:I am not familiar with IBM SPSS Modeler, therefore, I cannot compare these two products Regarding Alteryx I can say the following: - An excellent desktop tool for Data Prep and analytics. -… more »
    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 »
    Ranking
    3rd
    Views
    12,334
    Comparisons
    7,198
    Reviews
    29
    Average Words per Review
    513
    Rating
    8.2
    9th
    Views
    2,683
    Comparisons
    2,043
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Comparisons
    KNIME logo
    Compared 14% of the time.
    Databricks logo
    Compared 9% of the time.
    Dataiku logo
    Compared 8% of the time.
    RapidMiner logo
    Compared 7% of the time.
    Microsoft Power BI logo
    Compared 5% of the time.
    Databricks logo
    Compared 43% of the time.
    Snowflake logo
    Compared 17% of the time.
    Starburst Enterprise logo
    Compared 12% of the time.
    Amazon Redshift logo
    Compared 4% of the time.
    Oracle Database Appliance logo
    Compared 1% of the time.
    Learn More
    Dremio
    Video Not Available
    Overview

    Alteryx can be used to speed up or automate your business processes and enables geospatial and predictive solutions. Its platform helps organizations answer business questions quickly and efficiently, and can be used as a major building block in a digital transformation or automation initiative. With Alteryx, you can build processes in a more efficient, repeatable, and less error-prone way. Unlike other tools, Alteryx is easy to use without an IT background. The platform is very robust and can be used in virtually any industry or functional area.

    With Alteryx You Can:

    • Prep, blend, and analyze data
    • Deliver faster, better business outcomes
    • Automate analytics and data science
    • Embed intelligent decisioning
    • Deploy and share analytics in hours

    Alteryx Features Include:

    Some of the most valuable Alteryx features include:

    Scalability, stability, flexibility, fast performance, no-code analytics, data processing, business logic wrapping, scheduling, ease of use, data blending from different platforms, geo-referencing, good customization capabilities, drag and drop functionality, intuitive user interface, connectors, machine learning, macros, simple GUI, integration with Python, good data transformation, good documentation, multiple database merging, and easy deployment.

    Alteryx Can Be Used For:

    • Combining and manipulating data within spreadsheets: Alteryx can be used in situations where complex data manipulation occurs. It can handle large data quickly, and the process is much simpler to see and understand.

    • Database access and supplementing SQL development: Alteryx has several sets of database connectors and functions, including many functions that your average database does not. Alteryx can work with data from multiple databases or areas within a database. It allows users to filter, sort, calculate, etc. as they would commonly do in SQL or an ETL tool.
    • API, cloud, and hybrid access: Alteryx can read and write data in databases, files, REST APIs, and a myriad of other locations (with the correct permissions). When a workflow is published, you can also call a workflow through a REST API to start it.

    • Data science: Alteryx provides pre-built models that are extremely useful for data scientists who may have limited programming skills and also gives you the ability to add R or Python code directly within a workflow.

    • Geospatial analysis: Alteryx gives users drag-and-drop tools to geocode, plot, and map locations, customers, competitors, or anything that has a location (employee, truck, pipeline, etc.).

    • Reports and dashboards: Alteryx provides built-in tools that enable the building of reports and dashboards.

    Alteryx Benefits

    Some of the benefits of using Alteryx include
    :

    • Saves time: Alteryx helps shorten the time required to start analyzing data and looking for insights, minimizing the tasks that do not add value to the business and maximizing the analysis phase.

    • Clear tool configurations: Alteryx provides simple and concise tool configurations that are quick and easy to set.

    • Excellent workflow compatibility.

    • Reduced development time: Alteryx has an extensive gallery of user-developed analytic applications that helps to reduce development time.

    • Fast data loading: Alteryx has tools that make it very effective when working with big data sets.

    • No-code, low-code analytic building blocks: You can prep, blend, and analyze data to enable highly configurable and repeatable workflows.

    • Machine learning: Alteryx allows you to quickly create properly trained algorithms that are ready to deploy.

    Reviews from Real Users

    "Automation is the most valuable aspect for us. The ability to wrap business logic around the data is very helpful." - Theresa M., Senior Capacity Planner at a financial services firm

    "Alteryx has made us more agile and increased the speed and effectiveness of decision making." - Richard F., Director, Digital Experience & Media at Qdoba Restaurant Corporation

    "The scheduling feature for the automation is excellent." - Data Analytics Engineer at a tech services company

    "The product is very stable and super fast, five-star. It's significantly more stable than its nearest competitor." - Director at a non-tech company

    “A complete solution with very good user experience and a nice user interface.” - Solutions Consultant at a tech services company

    "There are a lot of good customization capabilities." - Advance Analytics PO at a pharma/biotech company





    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.

    Sample Customers
    AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
    UBS, TransUnion, Quantium, Daimler, OVH
    Top Industries
    REVIEWERS
    Computer Software Company15%
    Manufacturing Company11%
    Financial Services Firm11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Manufacturing Company10%
    Computer Software Company9%
    Retailer6%
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise15%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    Buyer's Guide
    Alteryx vs. Dremio
    March 2024
    Find out what your peers are saying about Alteryx vs. Dremio and other solutions. Updated: March 2024.
    771,157 professionals have used our research since 2012.

    Alteryx is ranked 3rd in Data Science Platforms with 74 reviews while Dremio is ranked 9th in Data Science Platforms with 6 reviews. Alteryx is rated 8.4, while Dremio is rated 8.6. The top reviewer of Alteryx writes "Feature-rich ETL that condenses a number of functions into one tool". On the other hand, the top reviewer of Dremio writes "It enables you to manage changes more effectively than any other platform". Alteryx is most compared with KNIME, Databricks, Dataiku, RapidMiner and Microsoft Power BI, whereas Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Oracle Database Appliance. See our Alteryx vs. Dremio report.

    See our list of best Data Science Platforms vendors.

    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.