We performed a comparison between Databricks and Pentaho Business Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms."The setup is quite easy."
"The most valuable feature is the Spark cluster which is very fast for heavy loads, big data processing and Pi Spark."
"We are completely satisfied with the ease of connecting to different sources of data or pocket files in the search"
"Databricks is a scalable solution. It is the largest advantage of the solution."
"The built-in optimization recommendations halved the speed of queries and allowed us to reach decision points and deliver insights very quickly."
"The technical support is good."
"Databricks' Lakehouse architecture has been most useful for us. The data governance has been absolutely efficient in between other kinds of solutions."
"The ability to stream data and the windowing feature are valuable."
"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"Easy to use components to create the job."
"The most valuable feature of Pentaho is the Tableau report."
"We were able to install it without any assistance from tech support."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"The initial setup is pretty straightforward."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"This solution only supports queries in SQL and Python, which is a bit limiting."
"Databricks has added some alerts and query functionality into their SQL persona, but the whole SQL persona, which is like a role, needs a lot of development. The alerts are not very flexible, and the query interface itself is not as polished as the notebook interface that is used through the data science and machine learning persona. It is clunky at present."
"There should be better integration with other platforms."
"The interface of Databricks could be easier to use when compared to other solutions. It is not easy for non-data scientists. The user interface is important before we had to write code manually and as solutions move to "No code AI" it is critical that the interface is very good."
"Databricks requires writing code in Python or SQL, so if you're a good programmer then you can use Databricks."
"Anyone who doesn't know SQL may find the product difficult to work with."
"Databricks doesn't offer the use of Python scripts by itself and is not connected to GitHub repositories or anything similar. This is something that is missing. if they could integrate with Git tools it would be an advantage."
"I would like it if Databricks adopted an interface more like R Studio. When I create a data frame or a table, R Studio provides a preview of the data. In R Studio, I can see that it created a table with so many columns or rows. Then I can click on it and open a preview of that data."
"Logging capability is needed."
"Another concern is that Pentaho is not customizable or interactive."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"The repository should be improved."
"Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."
"Version control would be a good addition."
"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
"Pentaho Business Analytics' user interface is outdated."
Databricks is ranked 1st in Data Science Platforms with 78 reviews while Pentaho Business Analytics is ranked 19th in BI (Business Intelligence) Tools with 42 reviews. Databricks is rated 8.2, while Pentaho Business Analytics is rated 8.0. The top reviewer of Databricks writes "A nice interface with good features for turning off clusters to save on computing". On the other hand, the top reviewer of Pentaho Business Analytics writes "Flexible, easy to understand, and simple to set up". Databricks is most compared with Amazon SageMaker, Informatica PowerCenter, Dataiku, Microsoft Azure Machine Learning Studio and Dremio, whereas Pentaho Business Analytics is most compared with Microsoft Power BI, Microsoft SQL Server Reporting Services, SAP Crystal Reports, KNIME and Tableau.
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.