We changed our name from IT Central Station: Here's why

Databricks vs Microsoft BI comparison

Cancel
You must select at least 2 products to compare!
Databricks Logo
30,779 views|25,469 comparisons
Microsoft BI Logo
45,863 views|36,567 comparisons
Featured Review
Find out what your peers are saying about Alteryx, Databricks, Knime and others in Data Science Platforms. Updated: January 2022.
564,143 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 the ability to use workspaces with other colleagues because you can work together even without seeing the other team's job.""Can cut across the entire ecosystem of open source technology to give an extra level of getting the transformatory process of the data.""Databricks helps crunch petabytes of data in a very short period of time.""Databricks is a scalable solution. It is the largest advantage of the solution.""The time travel feature is the solution's most valuable aspect.""The solution is very easy to use.""The fast data loading process and data storage capabilities are great.""The integration with Python and the notebooks really helps."

More Databricks Pros →

"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI.""The product is easy to use and simple to navigate.""The scalability is good. We have 20 people in my organization using this solution and plan to increase usage.""It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite.""It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view.""In contrast to what we were using before I think that Power BI has given us more extensive results.""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.""The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."

More Microsoft BI Pros →

Cons
"Databricks requires writing code in Python or SQL, so if you're a good programmer then you can use Databricks.""The initial setup is difficult.""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.""The integration of data could be a bit better.""The solution could improve by providing better automation capabilities. For example, working together with more of a DevOps approach, such as continuous integration.""Costs can quickly add up if you don't plan for it.""Pricing is one of the things that could be improved.""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."

More Databricks Cons →

"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.""It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community.""The solution could improve by having more attractive graphical charts.""I think that they can add more types of charts because the selection on the desktop version is limited.""Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution.""It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in 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.""When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."

More Microsoft BI Cons →

Pricing and Cost Advice
  • "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."
  • "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."
  • 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.
    564,143 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: 
    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
    2nd
    Views
    30,779
    Comparisons
    25,469
    Reviews
    22
    Average Words per Review
    531
    Rating
    7.9
    Views
    45,863
    Comparisons
    36,567
    Reviews
    124
    Average Words per Review
    552
    Rating
    8.0
    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 creates a Unified Analytics Platform that accelerates innovation by unifying data science, engineering, and business. It utilizes Apache Spark to help clients with cloud-based big data processing. It puts Spark on “autopilot” to significantly reduce operational complexity and management cost. The Databricks I/O module (DBIO) improves the read and write performance of Apache Spark in the cloud. An increase in productivity is ensured through Databricks’ collaborative workplace.

    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
    Financial Services Firm14%
    Computer Software Company14%
    Mining And Metals Company14%
    Marketing Services Firm7%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider15%
    Financial Services Firm8%
    Government5%
    REVIEWERS
    Financial Services Firm14%
    Energy/Utilities Company11%
    Manufacturing Company11%
    Computer Software Company11%
    VISITORS READING REVIEWS
    Computer Software Company23%
    Comms Service Provider17%
    Financial Services Firm8%
    Government6%
    Company Size
    REVIEWERS
    Small Business14%
    Midsize Enterprise17%
    Large Enterprise69%
    VISITORS READING REVIEWS
    Small Business25%
    Midsize Enterprise19%
    Large Enterprise56%
    REVIEWERS
    Small Business38%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise21%
    Large Enterprise62%
    Find out what your peers are saying about Alteryx, Databricks, Knime and others in Data Science Platforms. Updated: January 2022.
    564,143 professionals have used our research since 2012.

    Databricks is ranked 2nd in Data Science Platforms with 23 reviews while Microsoft BI is ranked 1st in Business Intelligence (BI) Tools with 155 reviews. Databricks is rated 7.8, while Microsoft BI is rated 8.0. The top reviewer of Databricks writes "Has a good feature set but it needs samples and templates to help invite users to see results". 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, Azure Stream Analytics, Alteryx and Domino Data Science Platform, whereas Microsoft BI is most compared with Tableau, Oracle OBIEE, MicroStrategy, SAP BusinessObjects Business Intelligence Platform and QlikView.

    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.