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.
"Databricks makes it really easy to use a number of technologies to do data analysis. In terms of languages, we can use Scala, Python, and SQL. Databricks enables you to run very large queries, at a massive scale, within really good timeframes."
"Databricks helps crunch petabytes of data in a very short period of time."
"The integration with Python and the notebooks really helps."
"The solution's features are fantastic and include interactive clusters that perform at top speed when compared to other solutions."
"Automation with Databricks is very easy when using the API."
"Databricks has a scalable Spark cluster creation process. The creators of Databricks are also the creators of Spark, and they are the industry leaders in terms of performance."
"The initial setup is pretty easy."
"Databricks is a unified solution that we can use for streaming. It is supporting open source languages, which are cloud-agnostic. When I do database coding if any other tool has a similar language pack to Excel or SQL, I can use the same knowledge, limiting the need to learn new things. It supports a lot of Python libraries where I can use some very easily."
"We have found that the reporting and publishing are great."
"The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
"It is a powerful tool that helps our data analysis processes."
"We found the initial setup to be straightforward."
"Ability to extract data from a variety of sources and systems."
"It is in the cloud, which makes it easy for mobile access of reports and data."
"With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license."
"The solution's initial setup isn't too complicated."
"I have had some issues with some of the Spark clusters running on Databricks, where the Spark runtime and clusters go up and down, which is an area for improvement."
"I have seen better user interfaces, so that is something that can be improved."
"Databricks is an analytics platform. It should offer more data science. It should have more features for data scientists to work with."
"Databricks' performance when serving the data to an analytics tool isn't as good as Snowflake's."
"Scalability is an area with certain shortcomings. The solution's scalability needs improvement."
"It should have more compatible and more advanced visualization and machine learning libraries."
"The product could be improved by offering an expansion of their visualization capabilities, which currently assists in development in their notebook environment."
"CI/CD needs additional leverage and support."
"Power BI could have better metadata management. It's easy to use for a single person. However, it lacks an enterprise-grade metadata management system, which can be a problem if you're doing an enterprise deployment with multiple users."
"I would like to be able to use more predicting data science features without having to use R."
"I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that."
"I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in."
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"The cost of the solution can get high."
"It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
"I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product."
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, Dremio 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.