

Alteryx and Dremio are key players in the data analytics platform market, each offering unique strengths. Alteryx's automation and ease of use give it an edge in speeding up data preparation and transformation. However, Dremio stands out for efficiently querying large datasets from diverse sources, underlining its technical capabilities.
Features: Alteryx's standout features include robust automation, drag-and-drop functionality, and excellent connectivity options, making it ideal for non-coders. Dremio excels with features like data reflective caching, federated queries, and broad data source support, enabling complex queries without extensive programming knowledge.
Room for Improvement: Alteryx could improve its in-database connectivity and simplify its pricing structure. Enhancements in data visualization and platform integration would broaden its appeal. Dremio can enhance its utility by improving connector support, optimizing query performance, and refining its scaling policies.
Ease of Deployment and Customer Service: Alteryx offers versatile deployment options, particularly strong in on-premises solutions, with responsive technical support, though premium support comes with pricing concerns. Dremio is flexible with hybrid and cloud environments, offering robust documentation and satisfactory service backed by strong community support.
Pricing and ROI: Alteryx is priced higher, making it more suitable for larger organizations with high ROI from automation and task efficiency. Dremio is viewed as more cost-effective, especially with its community version, although enterprise pricing still raises concerns. Its cost-effectiveness is notable compared to competitors like Snowflake.
Tasks that earlier took hours in Excel or SQL are now completed in minutes.
From a time-saving perspective, we saved 60 to 75 percent of the human workforce needed and eliminated other disparate ETL tools, ultimately saving us over 600,000 dollars.
Alteryx helps familiarize managers with artificial intelligence-driven possibilities.
Dremio surely saves time, reduces costs, and all those things because we don't have to worry so much about the infrastructure to make the different tools communicate.
Customer support from Alteryx has been amazing.
they do have a website for resolving doubts and accessing helpful resources, including various tools and filters.
I contacted customer support once or twice, and they were quick to respond.
We have had to reach out for customer support many times, and they respond, so they are pretty supportive about some long-term issues.
Customer support is great.
Alteryx is scalable for most enterprise analytics and data preparation workloads.
Suggestions for improvements in Alteryx include areas for increasing efficiency, particularly in processing telemetry data, which involves dealing with large volumes of unstructured data.
Alteryx is scalable, and I would give it eight out of ten.
Dremio's scalability can handle growing data and user demands easily.
Internally, if it's on Docker or Kubernetes, scalability will be built into the system.
I didn't need to reach out to Alteryx for support because available documents usually provide enough information to resolve issues.
I have not encountered any lagging, crashing, or instability in the system during these three months of usage.
Alteryx is a reliable tool, but it is also very heavy, requiring good laptop configurations, a minimum of 8GB RAM, and a recent processor such as i10.
I rate Dremio a nine in terms of stability.
The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections.
The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system.
The additional features that Alteryx needs to work on to make it more competitive include better collaboration and easier integration through API.
Starburst comes with around 50 connectors now.
It should be easier to get Arctic or an open-source version of Arctic onto the software version so that development teams can experiment with it.
I see that many times the new versions of Dremio have not fixed old bugs, and in some new versions, old problems that were previously fixed come back again, so I think the upgrade part could use improvement.
The price is very high, with licensing typically starting around five thousand dollars plus user per year.
We found excellent use cases for automation through Alteryx, which provided the means to reduce operational costs and streamline the build of ETL pipelines without extensive coding.
Alteryx is more cost-effective compared to Informatica licenses, offering savings.
I chose eight out of ten because Dremio is expensive for the Enterprise version, particularly regarding licensing.
Alteryx not only represents data but also supports decision-making by suggesting the next steps.
Analysts who do not have any coding experience can still work on the transformation and preparation of data, which is quite useful.
Alteryx includes built-in tools such as drive time analysis and linear regression, which are much harder to achieve in standard BI tools such as Power BI or Tableau.
Having everything under one system and an easier-to-work-with interface, along with having API integrations, adds significant value to working with Dremio.
Dremio has positively impacted my organization as nowadays we are connected to multiple databases from multiple environments, multiple APIs, and applications, and Dremio organizes everything in an amazing way for me.
Multiple data sources can be queried in one query, and it is not just a query engine.
| Product | Mindshare (%) |
|---|---|
| Alteryx | 3.8% |
| Dremio | 2.0% |
| Other | 94.2% |


| Company Size | Count |
|---|---|
| Small Business | 46 |
| Midsize Enterprise | 20 |
| Large Enterprise | 73 |
| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 6 |
| Large Enterprise | 5 |
Alteryx enhances efficiency by automating data preparation and transformation through a user-friendly drag-and-drop interface, catering to non-technical users and business professionals. It supports data blending, predictive analytics, and diverse data integration capabilities.
Alteryx streamlines data manipulation and complex transformations, benefiting industries such as finance and marketing with its ability to connect to multiple data sources and automate workflows. The platform supports analytics and machine learning model building, reducing manual efforts in ETL processes. Despite its capabilities, improvements are needed in database connectivity, pricing flexibility, and cloud service integration. Users desire enhancements in reporting features, visualization, and technical support to optimize its full potential. Machine learning and predictive analytics features require advancements to improve user experience and broaden accessibility through better connectors and reduced licensing costs.
What are Alteryx's key features?
What benefits and ROI should be looked for in reviews?
In finance and marketing, organizations leverage Alteryx to automate data tasks, connect diverse sources, and generate analytics models and dashboards efficiently. Its no-code approach aids in rapid data preparation, cleansing, and analysis, empowering business users to engage in predictive and prescriptive analytics effectively.
Dremio offers a comprehensive platform for data warehousing and data engineering, integrating seamlessly with data storage systems like Amazon S3 and Azure. Its main features include scalability, query federation, and data reflection.
Dremio's core strength lies in its ability to function as a robust data lake query engine and data warehousing solution. It facilitates the creation of complex queries with ease, thanks to its support for Apache Airflow and query federation across endpoints. Despite challenges with Delta connector support, complex query execution, and expensive licensing, users find it valuable for managing ad-hoc queries and financial data analytics. The platform aids in SQL table management and BI traffic visualization while reducing storage costs and resolving storage conflicts typical in traditional data warehouses.
What are Dremio's most valuable features?Dremio is primarily implemented in industries requiring extensive data engineering and analytics, including finance and technology. Companies use it for constructing data frameworks, efficiently processing financial analytics, and visualizing BI traffic. It acts as a viable alternative to AWS Glue and Apache Hive, integrating seamlessly with multiple databases, including Oracle and MySQL, offering robust solutions for data-driven strategies. Despite some challenges, its ability to reduce data storage costs and manage complex queries makes it a favorable choice among enterprise users.
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.