IT Central Station is now PeerSpot: Here's why

Databricks vs Microsoft BI comparison

Cancel
You must select at least 2 products to compare!
Databricks Logo
35,108 views|28,642 comparisons
Microsoft Logo
43,914 views|35,006 comparisons
Featured Review
Buyer's Guide
Data Science Platforms
June 2022
Find out what your peers are saying about Databricks, Alteryx, Knime and others in Data Science Platforms. Updated: June 2022.
609,272 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like how easy it is to share your notebook with others. You can give people permission to read or edit. I think that's a great feature. You can also pull in code from GitHub pretty easily. I didn't use it that often, but I think that's a cool feature.""It's easy to increase performance as required.""I like the ability to use workspaces with other colleagues because you can work together even without seeing the other team's job.""It can send out large data amounts.""The integration with Python and the notebooks really helps.""The main features of the solution are efficiency.""Databricks gives you the flexibility of using several programming languages independently or in combination to build models.""The ability to stream data and the windowing feature are valuable."

More Databricks Pros →

"We find the solution offers good stability.""There is also a chart store where we can download charts, which is extremely useful.""We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI.""There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources.""It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis.""In contrast to what we were using before I think that Power BI has given us more extensive results.""We have found the product very stable and reliable.""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."

More Microsoft BI Pros →

Cons
"I would like it if Databricks made it easier to set up a project.""The initial setup is difficult.""Instead of relying on a massive instance, the solution should offer micro partition levels. They're working on it, however, they need to implement it to help the solution run more effectively.""The solution could improve by providing better automation capabilities. For example, working together with more of a DevOps approach, such as continuous integration.""Databricks doesn't offer the use of Python scripts by itself and is not connected to GitHub repositories or anything similar. This is something that is missing. if they could integrate with Git tools it would be an advantage.""I would like to see more documentation in terms of how an end-user could use it, and users like me can easily try it and implement use cases.""There are no direct connectors — they are very limited.""It's not easy to use, and they need a better UI."

More Databricks Cons →

"One area for improvement in Microsoft Power BI is serviceability. Compared to one of its competitors: Tableau, there are a lot of things which you cannot do in this tool, that can be done in Tableau.""The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better.""I would like to see a more user-friendly interface with Microsoft BI.""Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier.""The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files.""Power BI's administration could use some work, and the user experience needs to improve because it is a client-based tool. If you want to generate a model or report, you need to use client tools, but client tools are limited for end-users who don't have enough hardware. For example, maybe a client lacks enough memory or CPU power for report generators. If you use a model that requires a massive amount of data, your client will face several problems.""Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it.""I would like to see more visualization options."

More Microsoft BI Cons →

Pricing and Cost Advice
  • "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."
  • "There are different versions."
  • "The solution uses a pay-per-use model with an annual subscription fee or package. Typically this solution is used on a cloud platform, such as Azure or AWS, but more people are choosing Azure because the price is more reasonable."
  • "The solution requires a subscription."
  • "Databricks is a very expensive solution. Pricing is an area that could definitely be improved. They could provide a lower end compute and probably reduce the price."
  • More Databricks Pricing and Cost Advice →

  • "We have a premium Power BI license in-house that's quite an expensive license. It's $10 a month for four users and then I think 35,000 at the premium rate."
  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
  • "Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • More Microsoft BI Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    609,272 professionals have used our research since 2012.
    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: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 »
    Top Answer:The most interesting feature of Microsoft Power BI is that it's very user-friendly.
    Ranking
    1st
    Views
    35,108
    Comparisons
    28,642
    Reviews
    23
    Average Words per Review
    480
    Rating
    8.0
    Views
    43,914
    Comparisons
    35,006
    Reviews
    183
    Average Words per Review
    534
    Rating
    8.1
    Comparisons
    Also Known As
    Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, 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 BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    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.

    Offer
    Learn more about Databricks
    Learn more about Microsoft BI
    Sample Customers
    Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Top Industries
    REVIEWERS
    Computer Software Company16%
    Financial Services Firm16%
    Retailer11%
    Mining And Metals Company11%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider14%
    Financial Services Firm9%
    Manufacturing Company5%
    REVIEWERS
    Financial Services Firm14%
    Manufacturing Company12%
    Computer Software Company12%
    Government10%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Comms Service Provider16%
    Financial Services Firm9%
    Government6%
    Company Size
    REVIEWERS
    Small Business26%
    Midsize Enterprise15%
    Large Enterprise59%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    REVIEWERS
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise68%
    Buyer's Guide
    Data Science Platforms
    June 2022
    Find out what your peers are saying about Databricks, Alteryx, Knime and others in Data Science Platforms. Updated: June 2022.
    609,272 professionals have used our research since 2012.

    Databricks is ranked 1st in Data Science Platforms with 28 reviews while Microsoft BI is ranked 1st in Business Intelligence (BI) Tools with 188 reviews. Databricks is rated 8.0, while Microsoft BI is rated 8.0. The top reviewer of Databricks writes "Good integration with majority of data sources through Databricks Notebooks using Python, Scala, SQL, R". On the other hand, the top reviewer of Microsoft 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 Microsoft Azure Machine Learning Studio, Amazon SageMaker, Dataiku Data Science Studio, Azure Stream Analytics and Domino Data Science Platform, whereas Microsoft BI is most compared with Tableau, Amazon QuickSight, MicroStrategy, Oracle OBIEE and Google Data Studio.

    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.