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 most valuable feature of Databricks is the notebook, data factory, and ease of use."
"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."
"A very valuable feature is the data processing, and the solution is specifically good at using the Spark ecosystem."
"Databricks integrates well with other solutions."
"What I like about Databricks is that it's one of the most popular platforms that give access to folks who are trying not just to do exploratory work on the data but also go ahead and build advanced modeling and machine learning on top of that."
"Databricks gives us the ability to build a lakehouse framework and do everything implicit to this type of database structure. We also like the ability to stream events. Databricks covers a broad spectrum, from reporting and machine learning to streaming events. It's important for us to have all these features in one platform."
"The initial setup phase of Databricks was good."
"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."
"It provides good visibility."
"It is useful for bringing visualization to data. It calculates counts, ratios, etc."
"The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything."
"The stability is great and continues to get better and better."
"The initial setup is relatively simple."
"What's most valuable in this tool is that it gives its users detailed error messages. It's a very stable data analytics tool, and it offers good scalability."
"Microsoft BI's most valuable features are the user interface, which is easy to use and light."
"We have found the product very stable and reliable."
"Databricks would benefit from enhanced metrics and tighter integration with Azure's diagnostics."
"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."
"The solution has some scalability and integration limitations when consolidating legacy systems."
"The initial setup is difficult."
"Databricks may not be as easy to use as other tools, but if you simplify a tool too much, it won't have the flexibility to go in-depth. Databricks is completely in the programmer's hands. I prefer flexibility rather than simplicity."
"I would like more integration with SQL for using data in different workspaces."
"There would also be benefits if more options were available for workers, or the clusters of the two points."
"Databricks could improve in some of its functionality."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"Microsoft BI can improve some of the visual level filters or visual functionality, that are available in other BI tools, such as Tableau or Qlik Sense."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."
"There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another."
"I believe the price should be degressive, and we should have a lower, or better unit price if we have more users."
Databricks is an industry-leading data analytics platform which is a one-stop product for all data requirements. Databricks is made by the creators of Apache Spark, Delta Lake, ML Flow, and Koalas. It builds on these technologies to deliver a true lakehouse data architecture, making it a robust platform that is reliable, scalable, and fast. Databricks speeds up innovations by synthesizing storage, engineering, business operations, security, and data science.
Databricks is integrated with Microsoft Azure, Amazon Web Services, and Google Cloud Platform. This enables users to easily manage a colossal amount of data and to continuously train and deploy machine learning models for AI applications. The platform handles all analytic deployments, ranging from ETL to models training and deployment.
Databricks deciphers the complexities of processing data to empower data scientists, engineers, and analysts with a simple collaborative environment to run interactive and scheduled data analysis workloads. The program takes advantage of AI’s cost-effectivity, flexibility, and cloud storage.
Databricks Key Features
Some of Databricks key features include:
Reviews from Real Users
Databricks stands out from its competitors for several reasons. Two striking features are its collaborative ability and its ability to streamline multiple programming languages.
PeerSpot users take note of the advantages of these features. A Chief Research Officer in consumer goods writes, “We work with multiple people on notebooks and it enables us to work collaboratively in an easy way without having to worry about the infrastructure. I think the solution is very intuitive, very easy to use. And that's what you pay for.”
A business intelligence coordinator in construction notes, “The capacity of use of the different types of coding is valuable. Databricks also has good performance because it is running in spark extra storage, meaning the performance and the capacity use different kinds of codes.”
An Associate Manager who works in consultancy mentions, “The technology that allows us to write scripts within the solution is extremely beneficial. If I was, for example, able to script in SQL, R, Scala, Apache Spark, or Python, I would be able to use my knowledge to make a script in this solution. It is very user-friendly and you can also process the records and validation point of view. The ability to migrate from one environment to another is useful.”
Microsoft BI is a business intelligence solution that connects to all your data sources and turns your data into insightful and useful business information that is relevant to all levels of the business, ensuring data accuracy, consistency, and security.
Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server - with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end users to better analyze their data, collaborate, and better present their data.
The BI platform empowers members of your organization to make data-driven decisions that drive strategic actions quickly by allowing them to work together easily on the same data, share insights, and collaborate on reports using other Microsoft Office applications.
Microsoft BI Benefits
Some of the benefits of using Microsoft BI include:
Reviews from Real Users
Microsoft BI stands out among its competitors for a number of reasons. Two major ones are its integration options and its data analytics capabilities.
Tariq R., an operations & BI analyst at American Hospital Dubai, writes, “Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis. ”
Databricks is ranked 1st in Data Science Platforms with 50 reviews while Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 83 reviews. Databricks is rated 8.2, while Microsoft BI is rated 8.0. The top reviewer of Databricks writes "Ahead of the competition in building data ecosystems, but needs to improve ease-of-use". On the other hand, the top reviewer of Microsoft BI writes "User friendly, easy to set up and great for analyzing data". Databricks is most compared with Amazon SageMaker, Microsoft Azure Machine Learning Studio, Informatica PowerCenter, Dataiku Data Science Studio and Tableau, whereas Microsoft BI is most compared with Amazon QuickSight, Tableau, KNIME, Domo and Salesforce Einstein 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.