We performed a comparison between Databricks and Microsoft BI based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Databricks is the winner in this comparison. It is robust, high performing, and received good feedback for its speed.
"We are completely satisfied with the ease of connecting to different sources of data or pocket files in the search"
"The setup is quite easy."
"The ability to stream data and the windowing feature are valuable."
"Automation with Databricks is very easy when using the API."
"Databricks' most valuable feature is the data transformation through PySpark."
"The solution is built from Spark and has integration with MLflow, which is important for our use case."
"I like that Databricks is a unified platform that lets you do streaming and batch processing in the same place. You can do analytics, too. They have added something called Databricks SQL Analytics, allowing users to connect to the data lake to perform analytics. Databricks also will enable you to share your data securely. It integrates with your reporting system as well."
"It's very simple to use Databricks Apache Spark."
"The most valuable features of Microsoft BI are its intuitiveness and ease to use."
"In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected."
"Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
"The solution integrates with other Microsoft solutions very well."
"Ability to extract data from a variety of sources and systems."
"We are able to collaborate on things and get insightful data visualizations."
"It is a powerful tool that helps our data analysis processes."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"Databricks has a lack of debuggers, and it would be good to see more components."
"There is room for improvement in visualization."
"Doesn't provide a lot of credits or trial options."
"The Databricks cluster can be improved."
"It should have more compatible and more advanced visualization and machine learning libraries."
"The solution could be improved by integrating it with data packets. Right now, the load tables provide a function, like team collaboration. Still, it's unclear as to if there's a function to create different branches and/or more branches. Our team had used data packets before, however, I feel it's difficult to integrate the current with the previous data packets."
"The integration features could be more interesting, more involved."
"Databricks would have more collaborative features than it has. It should have some more customization for the jobs."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"Sluggish performance when handling large amounts of data."
"Creating dashboards could be easier."
"I feel the modeling page should be simplified."
"If you have to pull multiple data sources performance is somewhat lacking."
"The formatting template could be improved."
"One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
"There are some connector-related issues in their MSBA solution."
Databricks is ranked 1st in Data Science Platforms with 78 reviews while Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews. Databricks is rated 8.2, while Microsoft Power BI 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 Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". Databricks is most compared with Amazon SageMaker, Informatica PowerCenter, Dataiku Data Science Studio, Microsoft Azure Machine Learning Studio and Alteryx, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and SAS Visual Analytics.
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.