Databricks vs Microsoft Power BI comparison

Cancel
You must select at least 2 products to compare!
Databricks Logo
28,492 views|18,008 comparisons
96% willing to recommend
Microsoft Logo
33,848 views|28,652 comparisons
92% willing to recommend
Comparison Buyer's Guide
Executive Summary
Updated on Aug 28, 2022

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.

  • Ease of Deployment: Users of both solutions agree that their initial setup is straightforward.

  • Features: Users of both products are satisfied with their scalability and stability.

    Databricks users say it is powerful, fast, integrates well, and has good AI, but that it should accommodate more open-source products.

    Microsoft BI reviewers say that it is flexible, intuitive, integrates well with other Microsoft tools, and has good reporting features. Some users mention that it is sometimes slow when rendering data.

  • Pricing: Each of these products received mixed reviews in the pricing category. Some users of each solution feel that the price is too high.

  • ROI: Users of both solutions report seeing an ROI.

  • Service and Support: Reviewers of both solutions report being satisfied with the level of support they receive.

Comparison Results: Databricks is the winner in this comparison. It is robust, high performing, and received good feedback for its speed.

To learn more, read our detailed Data Science Platforms Report (Updated: May 2024).
771,212 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""The most valuable feature of Databricks is the integration with Microsoft Azure.""The main features of the solution are efficiency.""We like that this solution can handle a wide variety and velocity of data engineering, either in batch mode or real-time.""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.""The solution is very easy to use.""It is a cost-effective solution."

More Databricks Pros →

"It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on.""I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use.""It is easy to work with and very chic.""The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R.""I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story.""The solution is stable.""The visualization and reporting are the most valuable features of this solution.""The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization."

More Microsoft Power BI Pros →

Cons
"Costs can quickly add up if you don't plan for it.""The integration of data could be a bit better.""The integration and query capabilities can be improved.""Databricks requires writing code in Python or SQL, so if you're a good programmer then you can use Databricks.""Can be improved by including drag-and-drop features.""I believe that this product could be improved by becoming more user-friendly.""If I want to create a Databricks account, I need to have a prior cloud account such as an AWS account or an Azure account. Only then can I create a Databricks account on the cloud. However, if they can make it so that I can still try Databricks even if I don't have a cloud account on AWS and Azure, it would be great. That is, it would be nice if it were possible to create a pseudo account and be provided with a free trial. It is very essential to creating a workforce on Databricks. For example, students or corporate staff can then explore and learn Databricks.""In the next release, I would like to see more optimization features."

More Databricks Cons →

"Microsoft BI could improve by having better collaboration between developers working on the same dashboard. The developer platform is all done on a single laptop and it's difficult to have the same project files work. Two developers have to go back and forth. You have to have the project file on one developer's laptop making it difficult to co-develop.""My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset.""Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution.""Integrating it with the physics build model or the engineering model should be included.""Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them.""The interface could be improved.""Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse.""From any improvement perspective, I want the product to be made available to users free of cost...The stability and scalability of the product can be better."

More Microsoft Power BI Cons →

Pricing and Cost Advice
  • "Whenever we want to find the actual costing, we have to send an email to Databricks, so having the information available on the internet would be helpful."
  • "I do not exactly know the costs, but one of our clients pays between $100 USD and $200 USD monthly."
  • "Licensing on site I would counsel against, as on-site hardware issues tend to really delay and slow down delivery."
  • "We find Databricks to be very expensive, although this improved when we found out how to shut it down at night."
  • "The pricing depends on the usage itself."
  • "I am based in South Africa, where it is expensive adapting to the cloud, and then there is the price for the tool itself."
  • "The price is okay. It's competitive."
  • "Databricks uses a price-per-use model, where you can use as much compute as you need."
  • More Databricks Pricing and Cost Advice →

  • "There is room for at least 45% discount as compared to the initial price."
  • "MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
  • "All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
  • "I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
  • "Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
  • "Make it low in cost. It is a no-brainer!"
  • "Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
  • "Paid for itself in the first month."
  • More Microsoft Power BI Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    771,212 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:Databricks gives you the option of working with several different languages, such as SQL, R, Scala, Apache Spark, or Python. It offers many different cluster choices and excellent integration with… more »
    Top Answer:We researched AWS SageMaker, but in the end, we chose Databricks Databricks is a Unified Analytics Platform designed to accelerate innovation projects. It is based on Spark so it is very fast. It… more »
    Top Answer:Databricks is an easy-to-set-up and versatile tool for data management, analysis, and business analytics. For analytics teams that have to interpret data to further the business goals of their… more »
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Ranking
    1st
    Views
    28,492
    Comparisons
    18,008
    Reviews
    47
    Average Words per Review
    441
    Rating
    8.3
    Views
    33,848
    Comparisons
    28,652
    Reviews
    27
    Average Words per Review
    619
    Rating
    7.9
    Comparisons
    Also Known As
    Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash
    SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Learn More
    Overview

    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:

    • Cloud-native: Works well on any prominent cloud provider.
    • Data storage: Stores a broad range of data, including structured, unstructured, and streaming.
    • Self-governance: Built-in governance and security controls.
    • Flexibility: Flexible for small-scale jobs as well as running large-scale jobs like Big Data processing because it’s built from Spark and is specifically optimized for Cloud environments.
    • Data science tools: Production-ready data tooling, from engineering to BI, AI, and ML.
    • Familiar languages: While Databricks is Spark-based, it allows commonly used programming languages like R, SQL, Scala, and Python to be used.
    • Team sharing workspaces: Creates an environment that provides interactive workspaces for collaboration, which allow multiple members to collaborate for data model creation, machine learning, and data extraction.
    • Data source: Performs limitless Big Data analytics by connecting to Cloud providers AWS, Azure, and Google, as well as on-premises SQL servers, JSON and CSV.

    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 Power BI is a powerful tool for data analysis and visualization. This tool stands out for its ability to merge and analyze data from various sources. Widely adopted across different industries and departments, Power BI is instrumental in creating visually appealing dashboards and generating insightful business intelligence reports. Its intuitive interface, robust visualization capabilities, and seamless integration with other Microsoft applications empower users to easily create interactive reports and gain valuable insights.

    Sample Customers
    Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware
    Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
    Top Industries
    REVIEWERS
    Computer Software Company25%
    Financial Services Firm16%
    Retailer9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Financial Services Firm15%
    Computer Software Company12%
    Manufacturing Company9%
    Healthcare Company6%
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise14%
    Large Enterprise59%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise71%
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise42%
    Large Enterprise44%
    Buyer's Guide
    Data Science Platforms
    May 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: May 2024.
    771,212 professionals have used our research since 2012.

    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.