Dremio vs Dundas BI comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,683 views|2,043 comparisons
100% willing to recommend
Dundas Logo
465 views|208 comparisons
96% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and Dundas BI 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).
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
"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.""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 allows querying the files I have on my block storage or object storage.""Everyone uses Dremio in my company; some use it only for the analytics function."

More Dremio Pros →

"With Dundas BI, you have a lot of visualization choices, and you can also do customizations by using HTML coding and JavaScript. The ease of development was one of the main factors for going for Dundas BI. The client had different reporting tools, but they wanted something that could accommodate all requirements.""We have now the ability to create interactive and complex reports without the need for software developers and code.""The Layers feature organizes my work and makes it easier, instead of having to use scripting to show and hide when drilling down.""It was quite easy to use. The UI was basically drag-and-drop based. So, even if you were a beginner at coding software or something else, it would be easy to catch up on Dundas BI.""The solution has a good drag-and-drop feature for creating dashboards.""We use Dundas to report on machine sensor data and create dashboards."

More Dundas BI Pros →

Cons
"It shows errors sometimes.""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.""I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported.""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.""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."

More Dremio Cons →

"For every object, references are generated, but sometimes, there was a problem with the references overlapping each other. Everything would go off. It would stop working, and then from the admin side, people had to do something to bring it up again.""It would be helpful if Dundas made the UI more user-friendly like the leading tools and decreased the learning curve. It should be simpler for a beginner to build dashboards.""I cannot select a visualization and see what filters are connected to it.""Lacks sufficient online support.""I would love to see more functions built in inside the application, instead of being scripted. They already did some of that in the new release, version 5, like forecasting, trend lines, etc., and I would love to see more of these kinds of calculations, which we used to do it by scripts before.""Working with the color palette is difficult in Dundas BI. They can work on different color palettes and make them organized and user-friendly. It would help a long way. Most of the time, the users face challenges in assigning colors to the fields that they have created or to the dimensions and measures in a chart."

More Dundas BI 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 →

  • "I'm not aware of its cost. Its licensing was probably role-wise. Most of us had reader access, editor access, or developer access. For admin, there were certain restrictions. So, I'm assuming it had role-wise licensing."
  • "I am not majorly involved in its licensing. We are not the end license purchaser of the Dundas BI. It costs somewhere around $4,000 a year for the enterprise solution, but I am not sure."
  • More Dundas BI 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: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:I am not majorly involved in its licensing. We are not the end license purchaser of the Dundas BI. It costs somewhere around $4,000 a year for the enterprise solution, but I am not sure.
    Top Answer:It would be helpful if Dundas made the UI more user-friendly like the leading tools and decreased the learning curve. It should be simpler for a beginner to build dashboards.
    Top Answer:We use Dundas to report on machine sensor data and create dashboards.
    Ranking
    9th
    Views
    2,683
    Comparisons
    2,043
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    21st
    out of 71 in Data Visualization
    Views
    465
    Comparisons
    208
    Reviews
    4
    Average Words per Review
    761
    Rating
    6.3
    Comparisons
    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.
    Microsoft Power BI logo
    Compared 35% of the time.
    Tableau logo
    Compared 31% of the time.
    Logi Analytics logo
    Compared 15% of the time.
    Angles Professional logo
    Compared 10% of the time.
    Salient logo
    Compared 9% of the time.
    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.

    Dundas BI is a powerful, flexible, end-to-end business intelligence platform that simplifies the entire analytics process and empowers its users to analyze and visualize data. The solution enables organizations to create and view interactive dashboards, reports, scorecards, and more. Dundas BI can be integrated into an existing website as part of a custom BI solution or it can be deployed as the central data portal for your organization. The solution is suitable for mid-to-large sized companies.

    Dundas BI Features

    Dundas BI has many valuable key features. Some of the most useful ones include:

    • Mobile responsive dashboards
    • Smart data display
    • Calendar support for retail and manufacturing
    • Data connectivity
    • Show/hide interaction
    • Batching data builds
    • Enhanced development workflow
    • Navigation support
    • Data regulation support
    • Optimized application performance
    • Instant application portability with docker
    • Easy SaaS support with Kubernetes
    • Natural language user input
    • Enhanced application security
    • Scheduled reports with multiple export options
    • Fully open APIs

    Dundas BI Benefits

    There are many benefits to implementing Dundas BI. Some of the biggest advantages the solution offers include:

    • Limitless customization: You can fully customize the Dundas BI platform, including its dashboards, data visualizations, interactions, scorecards, labels, etc. to meet your organization’s unique design requirements.
    • Effectively visualize and analyze data: The solution provides interactive data views that help you create pixel-perfect dashboards and reports that have interactive data visualizations so you can elevate your users’ abilities to effectively communicate data insights and drive faster decision-making.
    • Greater efficiency: Dundas BI can consolidate and store data from any source, providing seamless data delivery and a consistent user experience, which leads to greater efficiency. By having all your business intelligence, reporting, and data analytics needs in one single platform, you also save your organization a lot of time and effort.
    • Tailored data discovery process: Dundas BI adapts to all user types, allowing everyone to personalize it to suit their own needs and requirements, which helps users, data analysts, and developers to analyze their data quickly. The solution’s data discovery process also allows you to run ad-hoc queries, perform visual data analytics, and quickly create relevant and actionable content.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Dundas BI solution.

    A Business Intelligence Consultant at Siemens Industry says, “The flexibility of the dashboard designer is great. You can control every single pixel and no matter what the user asks for we can deliver. It has a lot of out-of-the-box options that you can use to customize your dashboard. There is also the option to use their JavaScript API, however, in 99% of the cases, the built-in options are more than enough. I also love the control you have on what queries Dundas BI is generating against our databases. This allows us to create really fast dashboards even when running against millions of records.”

    James D., System Architect at Yulista, LLC mentions that the most valuable aspect of the solution is its “ability to warehouse query results. This is good because you do not have to have a data warehouse, you let Dundas warehouse the results of a query that runs long during off hours.”

    Another reviewer shares, “The built-in ETL functionality has allowed us to combine data sources without the need for a full SSIS package. This saves time and allows for a quicker time to market.”

    Sample Customers
    UBS, TransUnion, Quantium, Daimler, OVH
    Coca Cola, Siemens, Verizon, Microsoft, Pitney Bowes, Scotiabank, Pepperidge Farm, Shutterstock, Norwegian Government, Boeing, Guess Inc., BP, Bayer
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    REVIEWERS
    Manufacturing Company25%
    Energy/Utilities Company13%
    Healthcare Company13%
    Aerospace/Defense Firm13%
    VISITORS READING REVIEWS
    Government14%
    Financial Services Firm13%
    Computer Software Company13%
    Manufacturing Company8%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    REVIEWERS
    Small Business44%
    Midsize Enterprise17%
    Large Enterprise39%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise14%
    Large Enterprise59%
    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.
    771,157 professionals have used our research since 2012.

    Dremio is ranked 9th in Data Science Platforms with 6 reviews while Dundas BI is ranked 21st in Data Visualization with 21 reviews. Dremio is rated 8.6, while Dundas BI is rated 8.6. 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 Dundas BI writes "Has a lot of integration and visualization options, but can't be easily used by business users, and working with the color palette is difficult". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas Dundas BI is most compared with Microsoft Power BI, Tableau, Logi Analytics, Angles Professional and Salient.

    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.