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.
"The setup was straightforward."
"Databricks' most valuable features are the workspace and notebooks. Its integration, interface, and documentation are also good."
"Databricks is a scalable solution. It is the largest advantage of the solution."
"I haven't heard about any major stability issues. At this time I feel like it's stable."
"The solution's features are fantastic and include interactive clusters that perform at top speed when compared to other solutions."
"Specifically for data science and data analytics purposes, it can handle large amounts of data in less time. I can compare it with Teradata. If a job takes five hours with Teradata databases, Databricks can complete it in around three to three and a half hours."
"It is fast, it's scalable, and it does the job it needs to do."
"The most valuable feature of Databricks is the integration of the data warehouse and data lake, and the development of the lake house. Additionally, it integrates well with Spark for processing data in production."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"Helped identify bad data, enabling the corrections needed to the data for management."
"This solution has improved our ability in making decisions and explaining data."
"The standard BI visualization capabilities are great."
"Implementation is very quick and the solution is very user-friendly."
"The user interface is easy to work with."
"The solution is easy to use and charts can be built quickly with the tools."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"The integration of data could be a bit better."
"The product needs samples and templates to help invite users to see results and understand what the product can do."
"The Databricks cluster can be improved."
"Databricks' performance when serving the data to an analytics tool isn't as good as Snowflake's."
"It would be better if it were faster. It can be slow, and it can be super fast for big data. But for small data, sometimes there is a sub-second response, which can be considered slow. In the next release, I would like to have automatic creation of APIs because they don't have it at the moment, and I spend a lot of time building them."
"Implementation of Databricks is still very code heavy."
"I have seen better user interfaces, so that is something that can be improved."
"Overall it's a good product, however, it doesn't do well against any individual best-of-breed products."
"Its price could be better. Its licensing cost is very high."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"The initial installation is difficult."
"I think that the solution is harder to use for people who are not experts in data."
"Technical support could be a bit better."
"If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization."
"It is not the right tool to do deeper analysis or predictions. When you have some data and you want to do some deep analysis, there is no feature to help you with this."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this 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, Microsoft Azure Machine Learning Studio and Alteryx, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and MicroStrategy.
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.