Dataiku Data Science Studio vs Dremio comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dataiku Data Science Studio and Dremio 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: March 2024).
765,234 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
"I like the interface, which is probably my favorite part of the solution. It is really user-friendly for an IT person.""Cloud-based process run helps in not keeping the systems on while processes are running.""The most valuable feature is the set of visual data preparation tools.""Data Science Studio's data science model is very useful.""The solution is quite stable.""Extremely easy to use with its GUI-based functionality and large compatibility with various data sources. Also, maintenance processes are much more automated than ever, with fewer errors.""The most valuable feature of this solution is that it is one tool that can do everything, and you have the ability to very easily push your design to prediction."

More Dataiku Data Science Studio Pros →

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

More Dremio Pros →

Cons
"The interface for the web app can be a bit difficult. It needs to have better capabilities, at least for developers who like to code. This is due to the fact that everything is enabled in a single window with different tabs. For them to actually develop and do the concurrent testing that needs to be done, it takes a bit of time. That is one improvement that I would like to see - from a web app developer perspective.""There were stability issues: 1) SQL operations, such as partitioning, had bugs and showed wrong results. 2) Due to server downtime, scheduled processes used to fail. 3) Access to project folders was compromised (privacy issue) with wrong people getting access to confidential project folders.""Although known for Big Data, the processing time to process 1.8 billion records was terribly slow (five days).""Server up-time needs to be improved. Also, query engines like Spark and Hive need to be more stable.""In the next release of this solution, I would like to see deep learning better integrated into the tool and not simply an extension or plugin.""I find that it is a little slow during use. It takes more time than I would expect for operations to complete.""I think it would help if Data Science Studio added some more features and improved the data model.""The ability to have charts right from the explorer would be an improvement."

More Dataiku Data Science Studio 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.""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."

More Dremio Cons →

Pricing and Cost Advice
  • "The annual licensing fees are approximately €20 ($22 USD) per key for the basic version and €40 ($44 USD) per key for the version with everything."
  • More Dataiku Data Science Studio 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.
    765,234 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Data Science Studio's data science model is very useful.
    Top Answer:I think it would help if Data Science Studio added some more features and improved the data model.
    Top Answer:The use case is data science, and we've deployed Data Science Studio in multiple regions for four environments: dev, preset, pre-production, and production.
    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
    6th
    Views
    9,728
    Comparisons
    7,542
    Reviews
    1
    Average Words per Review
    190
    Rating
    10.0
    8th
    Views
    2,693
    Comparisons
    2,048
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Comparisons
    Also Known As
    Dataiku DSS
    Learn More
    Dremio
    Video Not Available
    Overview

    Dataiku Data Science Studio is the collaborative data science software platform for teams of data scientists, data analysts, and engineers to explore, prototype, build, and deliver their own data products more efficiently.

    Dataiku Data Science Studio is also known as Dataiku DSS. This solution enables you to discover, share, and reuse code and applications so that you can deliver high-quality projects easily and streamline your path to production. As an enterprise leader, you can leverage the power of AI to confidently make business decisions.

    With Dataiku, an intuitive interface is guaranteed and allows users the ability to access and work with data using a point-and-click method. Dataiku analyzes the data to suggest key transformations. Beyond offering 109 data transformation capabilities, Dataiku also includes pipelines that can be generated in SQL which can thereafter be scheduled for automated recomputation.

    What's more, Dataiku allows you to create more than 20 different kinds of charts and also gives you the ability to deploy them into dashboards or create custom web applications for the use of interactive and sophisticated visualization tools.

    In addition, with Dataiku you have the option of using an in-depth statistical analysis, including but not limited to: curves fitting, univariate and bivariate analysis, principal component analysis, correlation analysis, and statistical tests.

    Dataiku Data Science Studio Consists Of:

    • Data preparation
    • Visualization
    • Machine Learning
    • Data Ops
    • ML Ops
    • Analytic Apps

    With Dataiku Data Science Studio You Can:

    • Integrate any data 10x faster
    • Build and automate sophisticated data pipelines
    • Build and share insights in minutes
    • Perform in-depth statistical analysis
    • Create thousands of models to find the best ones
    • Explore and explain models

    Dataiku Data Science Studio Benefits and Features:

    • Use your favorite languages and tools: You can create code working with tools you are already familiar with in the language you prefer (Python, R, SQL, etc.)
    • Easily reuse and share code: This feature helps you reduce inefficiencies and inconsistent data. Dataiku includes project libraries, allowing teams to centralize and share code. Although it comes pre-loaded with starter code for tasks, it also provides you with the ability to add your own code snippets.
    • Simplify complexities related to connecting to data and configuring computer resources: With this feature, data scientists can execute code in both a containerized and distributed way, while also selecting the runtime environment they want. Dataiku works to maintain those containers as well as shut them down when the job is completed.

    Features Users Find Most Valuable:

    • API
    • Reporting/Analytics
    • Third-Party Integrations
    • Data Import/Export
    • Natural Language Processing
    • Search/Filter
    • Monitoring
    • Workflow Management

    Reviews from Real Users

    PeerSpot users note that Dataiku Data Science Studio has a fantastic interface and is also flexible, intuitive, and stable. One user said "I like the interface, which is probably my favorite part of the solution. It is really user-friendly for an IT person." Another user mentioned “The best feature is the user interface. It allows us to see the visual flows.”

    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.

    Sample Customers
    BGL BNP Paribas, Dentsu Aegis, Link Mobility Group, AramisAuto
    UBS, TransUnion, Quantium, Daimler, OVH
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Educational Organization13%
    Manufacturing Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer5%
    Company Size
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise19%
    Large Enterprise68%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    Data Science Platforms
    March 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    Dataiku Data Science Studio is ranked 6th in Data Science Platforms with 6 reviews while Dremio is ranked 8th in Data Science Platforms with 6 reviews. Dataiku Data Science Studio is rated 8.2, while Dremio is rated 8.6. The top reviewer of Dataiku Data Science Studio writes "The model is very useful". On the other hand, the top reviewer of Dremio writes "Quick database capabilities but sometimes shows minor errors". Dataiku Data Science Studio is most compared with Databricks, Alteryx, KNIME, Microsoft Azure Machine Learning Studio and Starburst Galaxy, whereas Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Power BI.

    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.