Azure Databricks vs. Dataiku

Suppose you have multiple data sources and you want to bring the data into one place, transform it and make it into a data model. Azure Databricks is a perfectly suited solution for this. Leverage spark JDBC or any external cloud based tool (ADG, AWS Glue) to bring the data into a cloud storage. From there, Azure Databricks can handle everything. The data can be ingested by Azure Databricks into a 3 Layer architecture based on the delta lake tables. The first layer, raw layer, has the raw as is data from source. The enrich layer, acts as the cleaning and filtering layer to clean the data at an individual table level. The gold layer, is the final layer responsible for a data model. This acts as the serving layer for BI For BI needs, if you need simple dashboards, you can leverage Azure Databricks BI to create them with a simple click! For complex dashboards, just like any sql db, you can hook it with a simple JDBC string to any external BI tool.

Incentivized

Dataiku DSS is very well suited to handle large datasets and projects which requires a huge team to deliver results. This allows users to collaborate with each other while working on individual tasks. The workflow is easily streamlined and every action is backed up, allowing users to revert to specific tasks whenever required. While Dataiku DSS works seamlessly with all types of projects dealing with structured datasets, I haven't come across projects using Dataiku dealing with images/audio signals. But a workaround would be to store the images as vectors and perform the necessary tasks.

Incentivized

• Unity Catalog
• Data Federation in Lakehouse Architecture
• Integration of Mosaic AI in the SQL Layer

Incentivized

• Low-code platform.
• Open source version includes most valuable modules.
• User friendly documentation.

Incentivized

• Their pipeline workflow orchestration is pretty primitive. Lacks some common features
• Workspace UI and navigation requires steep learning curve
• Personally, I am not fond of their autosave feature. Its dangerous for production level notebooks scripts

Incentivized

• The visualization feature of flow still has a lot room to improve, when the flow is complex.
• The "non-coding" template/building block for deep learning lack of many important configurable parameters.
• Lack of the unified way to allow applying the "design pattern" on the Python codes (if we want to develop our own module or building blocks.

Incentivized

Great for what we use day to day and does what we need it to do. Cost management is not fully developed across the UX and gets expensive very quickly for developing projects. Integrated very well with our Microsoft stack and can be worked on collaboratively which works well for us.

Incentivized

The user experience is very good. Everything feels intuitive and "flows" (sorry excuse the pun) so nicely, and the customization level is also appropriate to the tool. Even as a newer data scientist, it felt easy to use and the explanations/tutorials were very good. The documentation is also at a good level

Incentivized

The amazing part of Dataiku DSS is their customer service. Based on urgency and technical level, you get a reply from the Dataiku engineer when you raise a query. So far, my queries have been pretty complex to solve, so I have received solutions even from the CTO of the company as well, which is why I would describe their customer support as very good.

Incentivized

I have found Azure Databricks to be much better than Snowflake for handling bigger, diverse data types. Snowflake is much simpler and better for smaller warehousing. The real time processing is much better in Azure Databricks and we have much more language options. Snowflake is more expensive but simpler to use. Both are great for different needs.

Incentivized

Dataiku was selected for me, but I am happy about that. I like Dataiku for the user experience, it feels less code-y and I like to demo things to non technical stakeholders because they can still follow along. When you open some other notebooks, you can see that peoples eyes start to glaze over

Incentivized

• Helped reduce time for collecting data
• Reduced cost in maintaining multiple data sources
• Access for multiple users and management of users/data in a single platform

Incentivized

• So far it has had a positive impact. Multiple departments are coming to us with their business problems.
• I can't specifically say about ROI as I'm a developer, though I have heard this solution is economical compared to other AI/ML enterprise tools.
• By using this tool, my client has let go of software that was used earlier, and we have created a simpler framework to replace that software.

Incentivized