Try our new research platform with insights from 80,000+ expert users

Databricks vs Microsoft Power BI comparison

Sponsored
 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

IBM SPSS Statistics
Sponsored
Average Rating
8.0
Number of Reviews
37
Ranking in other categories
Data Mining (3rd), Data Science Platforms (10th)
Databricks
Average Rating
8.2
Reviews Sentiment
7.4
Number of Reviews
84
Ranking in other categories
Data Science Platforms (1st), Streaming Analytics (1st)
Microsoft Power BI
Average Rating
8.0
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
 

Mindshare comparison

Data Science Platforms
BI (Business Intelligence) Tools
 

Featured Reviews

AbakarAhmat - PeerSpot reviewer
Sep 21, 2023
Enhancing survey analysis that provides valued insightfulness
I use it to analyze questionnaire surveys related to a product, solution, or application, such as open data services, which I provide to consumers and end-users. These surveys contain evaluation assessments, and I use SPSS to analyze the responses The most valuable feature is its robust…
Dunstan Matekenya - PeerSpot reviewer
Jul 10, 2024
Process large-scale data sets and integrates with Apache Spark with notebook environment
I primarily use Databricks to process large-scale data sets with Apache Spark. My main use case is processing large data sets, such as 600 GB or 800 GB Databricks integrates natively with Apache Spark, which I use as a processing engine for large-scale datasets. This native integration is one of…
Amol Rane - PeerSpot reviewer
Jul 17, 2024
Supports AI initiatives in terms of predictive analytics
The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out. Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out. The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins. So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Capability analysis is one of the main and valuable functions. We also do some hypothesis testing in Minitab and summary stats. These are the functions that we find very useful."
"The learning curve to using this product is not steep. The program is appropriate for those who do not have a lot of background in programming, yet have to perform basic statistical analysis."
"Most of the product features are good but I particularly like the linear regression analysis."
"It has helped our analyst unit deliver work with more transparency and confidence, given that we can always view the dataset in totality, after each step of data transformation."
"The most valuable feature is the user interface because you don't need to write code."
"The solution is very comprehensive, especially compared to Minitabs, which is considered more for manufacturing. However, whatever data you want to analyze can be handled with SPSS."
"Custom tables and macros: They allow us to create useful reports quickly for a broad audience."
"It is perfectly adequate if all you need are the results and not the trail of evidence."
"Ability to work collaboratively without having to worry about the infrastructure."
"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."
"In the manufacturing industry, Databricks can be beneficial to use because of machine learning. It is useful for tasks, such as product analysis or predictive maintenance."
"We have the ability to scale, collaborate and do machine learning."
"One of the features provides nice interactive clusters, or compute instances that you don't really need to manage often."
"Databricks is a robust solution for big data processing, offering flexibility and powerful features."
"The solution is very easy to use."
"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."
"If you are not very technical this tool could be very useful."
"It is in the cloud, which makes it easy for mobile access of reports and data."
"Power BI pricing is generally considered more affordable than Tableau."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. 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."
"What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
"The most valuable feature of Microsoft Power BI is the drill-through feature that takes you to a details page the users want to see."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making. It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training."
 

Cons

"The technical support should be improved."
"SPSS slows down the computer or the laptop if the data is huge; then you need a faster computer."
"The solution could improve by providing a visual network for predictions and a self-organizing map for clustering."
"The product should provide more ways to import data and export results that are user-friendly for high-level executives."
"Each algorithm could be more adaptable to some industry-specific areas, or, in some cases, adapted for maintenance."
"IBM SPSS Statistics does not keep you close to your data like KNIME."
"I think the visualization and charting should be changed and made easier and more effective."
"Most of the package will give you the fixed value, or the p-value, without an explanation as to whether it it significant or not. Some beginners might need not just the results, but also some explanation for them."
"Support for Microsoft technology and the compatibility with the .NET framework is somewhat missing."
"I would like it if Databricks made it easier to set up a project."
"There should be better integration with other platforms."
"Pricing is one of the things that could be improved."
"I would like to see the integration between Databricks and MLflow improved. It is quite hard to train multiple models in parallel in the distributed fashions. You hit rate limits on the clients very fast."
"The query plan is not easy with Databrick's job level. If I want to tune any of the code, it is not easily available in the blogs as well."
"I have seen better user interfaces, so that is something that can be improved."
"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."
"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."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
"It is not the right tool to do deeper analysis or predictions. When you have some data and you want to do some deep analysis, there is no feature to help you with this."
"Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market."
"I think because I'm moving more into RPA, I'd definitely like to see integration across the RPA, Power BI, or Tableau platforms, because that integration could then make automation and mundane reporting much faster."
"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."
"Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution."
 

Pricing and Cost Advice

"The pricing of the modeler is high and can reduce the utility of the product for those who can not afford to adopt it."
"If it requires lot of data processing, maybe switching to IBM SPSS Clementine would be better for the buyer."
"The price of this solution is a little bit high, which was a problem for my company."
"While the pricing of the product may be higher, the accompanying service and features justify the investment."
"More affordable training for new staff members."
"It's quite expensive, but they do a special deal for universities."
"We think that IBM SPSS is expensive for this function."
"Our licence is on a yearly renewal basis. While pricing is not the primary concern in our evaluation, as products are assessed by whether they can meet our user needs and expertise, the cost can be a limiting factor in the number of licences we procure."
"The billing of Databricks can be difficult and should improve."
"Price-wise, I would rate Databricks a three out of five."
"We're charged on what the data throughput is and also what the compute time is."
"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."
"The licensing costs of Databricks is a tiered licensing regime, so it is flexible."
"The solution is affordable."
"The solution is a good value for batch processing and huge workloads."
"My smallest project is around a hundred euros, and my most expensive is just under a thousand euros a week. That is based on terabytes of data processed each month."
"It would be better if the price was cheaper."
"You don't need a license for development, but if you want to publish to external users, you need a license. The licensing is very costly, but I think that since the advantages and benefits of Power BI are so high, people are willing to pay. I can't blame them."
"We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500."
"Power BI is cost-effective compared to other reporting tools."
"The cost of the solution is more flexible for us because the desktop is free and we pay as we use it in the cloud."
"I have never worked on licensing, but I have heard that it is reasonable."
"Regarding cost, the initial investment wasn't too high, but ongoing licensing could add up."
"Power BI comes with enterprise Microsoft licensing. So for the user, you don't have to pay, but you do have to pay a one-time cost."
report
Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
815,854 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
University
9%
Computer Software Company
9%
Manufacturing Company
8%
Financial Services Firm
16%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
6%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM SPSS Statistics?
The software offers consistency across multiple research projects helping us with predictive analytics capabilities.
What is your experience regarding pricing and costs for IBM SPSS Statistics?
While the pricing of the product may be higher, the accompanying service and features justify the investment. However...
What needs improvement with IBM SPSS Statistics?
In some cases, the product takes time to load a large dataset. They could improve this particular area.
Which do you prefer - Databricks or Azure Machine Learning Studio?
Databricks gives you the option of working with several different languages, such as SQL, R, Scala, Apache Spark, or ...
How would you compare Databricks vs Amazon SageMaker?
We researched AWS SageMaker, but in the end, we chose Databricks. Databricks is a Unified Analytics Platform designe...
Which would you choose - Databricks or Azure Stream Analytics?
Databricks is an easy-to-set-up and versatile tool for data management, analysis, and business analytics. For analyti...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I wou...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize info...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are ...
 

Also Known As

SPSS Statistics
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

Video not available
 

Overview

 

Sample Customers

LDB Group, RightShip, Tennessee Highway Patrol, Capgemini Consulting, TEAC Corporation, Ironside, nViso SA, Razorsight, Si.mobil, University Hospitals of Leicester, CROOZ Inc., GFS Fundraising Solutions, Nedbank Ltd., IDS-TILDA
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
Find out what your peers are saying about Databricks, Knime, Microsoft and others in Data Science Platforms. Updated: November 2024.
815,854 professionals have used our research since 2012.