Azure Databricks vs. Explorium

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

We need to constantly measures costs in our health business and we forecast pricing acoording to several values and conditions. Explorium works quite good analysing simple datasets, but when hierahies start to increase, meaning 6-10 olap variables, the system start to slow down quite a bit until was no longer to retrieve the info we required. This is why we test several tools, because even world-class solutions we purchase, don´t do the job we need. Explorium is a good tool, but complexity will be a minus in some scenarios.

Incentivized

• SQL
• Data management
• Data access

Incentivized

• Data ready for consumption.
• Good enough relationships between entities.
• Nice integration with other players. That's a good thing.

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

• relationships between entities could be better. Would be great to have scenarios.
• The data normalized needs improvement. Works pretty good, but it needs more refinement when using AND-OR Formulas that came from various datasets.

Incentivized

Based on my extensive use of Azure Databricks for the past 3.5 years, it has evolved into a beautiful amalgamation of all the data domains and needs. From a data analyst, to a data engineer, to a data scientist, it jas got them all! Being language agnostic and focused on easy to use UI based control, it is a dream to use for every Data related personnel across all experience levels!

Incentivized

Against all the tools I have used, Azure Databricks is by far the most superior of them all! Why, you ask? The UI is modern, the features are never ending and they keep adding new features. And to quote Apple, "It just works!" Far ahead of the competition, the delta lakehouse platform also fares better than it counterparts of Iceberg implementation or a loosely bound Delta Lake implementation of Synapse

Incentivized

The simplicity of the tool is an advantage. The integrations as well work quite well. All these solutions have worked well until some point and what we have discovered over the years is that we need to combine various solutions. There is no such thing as one tool ruling them all. Explorium works quite well until we start testing more advanced relations, and here, the tool is promising but requires a little work.

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

• Positive. The time save in analysis per hour of internal consulting was the best compared to our SAP and Cognos solutions.
• In term of objetives works as stated, but when using multi-conditions of dataset, start the issues.

Incentivized