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

IBM SPSS Modeler vs Microsoft Power BI comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

IBM SPSS Modeler
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
39
Ranking in other categories
Data Mining (4th), Data Science Platforms (13th)
Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
319
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
 

Mindshare comparison

While both are Business Intelligence solutions, they serve different purposes. IBM SPSS Modeler is designed for Data Mining and holds a mindshare of 17.0%, up 16.4% compared to last year.
Microsoft Power BI, on the other hand, focuses on BI (Business Intelligence) Tools, holds 21.4% mindshare, down 22.6% since last year.
Data Mining
BI (Business Intelligence) Tools
 

Featured Reviews

PeterHuo - PeerSpot reviewer
Good tool for extracting data from data warehouses, creating streams, and manipulating logic to extract final data
There are performance issues. Extracting data from many combined tables can take hours and occasionally crash the server due to memory leaks. This performance problem bothers people. The performance issue seems to be related to the server. We design streams on the client and submit them to the server, which generates a large SQL statement. There are two potential bottlenecks: one in the server and another in data extraction. I'm unsure about the exact mechanics of data splitting when fetching from the database. When streams become larger, performance bottlenecks may occur in the IBM SPSS Modeler server or the database. Sometimes the server crashes and needs to be restarted to release memory on both sides. I'm not sure exactly where the problem is caused, as I focus on stream design rather than server issues. The problem could be on the IBM SPSS Modeler server and database.
James Balbach - PeerSpot reviewer
Robust system consistently elevates data visualization and seamlessly updates with user-driven advancements
Power BI is a general-use visualization system. I can express the performance of our network through high-level key performance indicators. It allows me to show detailed improvements in quality and safety and patient experience. I create improvement dashboards for task forces and work teams. I have built analytic dashboards that guide analytics, enabling research and dataset manipulation.

Quotes from Members

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

Pros

"The quality is very good."
"It scales. I have not run into any challenges where it will not perform.​"
"Automated modelling, classification, or clustering are very useful."
"We have integration where you can write third-party apps. This sort of feature opens it up to being able to do anything you want."
"The ease of use in the user interface is the best part of it. The ability to customize some of my streams with R and Python has been very useful to me, I've automated a few things with that."
"The most valuable features of the IBM SPSS Modeler are visual programming, you don't have to write any code, and it is easy to use. 90 to 95 percent of the use cases, you don't have to fine-tune anything. If you want to do something deeper, for example, create a better neural network, then you have to go into the features and try to fine-tune them. However, the default selection which is made by the tool, it's very practical and works well."
"It handles large data better than the previous system that we were using, which was basically Excel and Access. We serve upwards of 300,000 parts over a 150 regions and we need to crunch a lot of numbers."
"New algorithms are added into every version of Modeler, e.g., SMOTE, random forest, etc. The Derive node is used for the syntax code to derive the data."
"Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
"Data integration is very useful in Power BI. It lets me collect data from many sources. For example, I can get data from Oracle databases and SQL Server databases at the same time."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"The stability is good."
"There is a lot of help and documentation on the Internet, so no special training is needed to use the source code."
"Microsoft B's beneficial features are that it is a Microsoft product and it is well known by the staff here in the company. It suited the available skills."
"Power BI stands out because it provides considerable flexibility in creating reports, dashboards, and various types of analytics to meet those dynamic requirements. It is lightweight and easy to use with good support."
 

Cons

"When you are not using the product, such as during the pandemic where we had worldwide lockdowns, you still have to pay for the licensing."
"​I would like better integration into the Weather Company solution. I have raised a couple of concerns about this integration and having more time series capabilities.​"
"When I used it in the office, back in the day, we did have some stability issues. Sometimes it just randomly crashed and we couldn't get good feedback. But when I use it for my own stuff now I don't have any problems."
"I would like see more programming languages added, like MATLAB. That would be better."
"If IBM could add some of the popular models into the SPSS for further analysis, like popular regression models, I think that would be a helpful improvement."
"I can say the solution is outdated."
"I understand that it takes some time to incorporate some of the new algorithms that have come out in the last few months, in the literature. For example, there is an algorithm based on how ants search for food. And there are some algorithms that have now been developed to complement rules. So that's one of the things that we need to have incorporated into it."
"The platform that you can deploy it on needs improvement because I think it is Windows only. I do not think it can run off a Red Hat, like the server products. I am pretty sure it is Windows and AIX only."
"It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well."
"There is room for improvement in terms of customization and configuration options, particularly for more advanced users."
"The upgrade process could be improved."
"These licenses are in US dollars. With a long-term license, the client is unaffected when the exchange rate goes up. However, if the exchange rate goes down, you don't get refunded from the excess money you've paid. I guess that is a risk you take in business."
"The integration with third-party products could be more stable."
"It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."
"The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire."
"We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."
 

Pricing and Cost Advice

"It is a huge increase to time savings."
"When you are close to end of quarter, IBM and its partners can get you 60% to 70% discounts, so literally wait for the last day of the quarter for the best prices. You may feel like you are getting robbed if you can't receive a good discount."
"This tool, being an IBM product, is pretty expensive."
"The government has funds and a budget, it's hard to say if it's expensive or cheap. In Canada, they have a yearly budget. They used to encourage people to use the modeler for development. If ten users use the server with ten licenses, it runs faster. But if forty users use the same appliance, everything slows down. People then think it's not easy to do things and prefer using remote tools like Python to extract data from the database. It's not about being expensive or cheap, but about people's knowledge and experience in how to do the work."
"It got us a good amount of money with quick and efficient modeling."
"$5,000 annually."
"I am using the free version of IBM SPSS Modeler, it is the educational edition version."
"The scalability was kind of limited by our ability to get other people licenses, and that was usually more of a financial constraint. It's expensive, but it's a good tool."
"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."
"The solution is less expensive than other PowerBI tools, which is why most people go with it, although it does cost more than MSBI tools."
"There are a few options available for purchasing a license. Typically the number of users you have will determine the price of the license. The more users you have the more you will pay."
"I have not had a customer suggest the solution is too expensive. There are licenses to use the solution."
"The price of the license can be better."
"The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users."
"The costs are small and the benefits are high."
"Paid for itself in the first month."
report
Use our free recommendation engine to learn which Data Mining solutions are best for your needs.
837,501 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
12%
Educational Organization
12%
Computer Software Company
9%
University
9%
Educational Organization
43%
Financial Services Firm
8%
Computer Software Company
6%
Government
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM SPSS Modeler?
Compared to other tools, the product works much easier to analyze data without coding.
What is your experience regarding pricing and costs for IBM SPSS Modeler?
The government has funds and a budget, it's hard to say if it's expensive or cheap. In Canada, they have a yearly budget. They used to encourage people to use the modeler for development. If ten us...
What needs improvement with IBM SPSS Modeler?
There are performance issues. Extracting data from many combined tables can take hours and occasionally crash the server due to memory leaks. This performance problem bothers people. The performanc...
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 would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
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 information, control users accessing information, the configuration of governance po...
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 fully customizable and very user-friendly. This solution is very stable. Oracle ...
 

Also Known As

SPSS Modeler
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

Overview

 

Sample Customers

Reisebªro Idealtours GmbH, MedeAnalytics, Afni, Israel Electric Corporation, Nedbank Ltd., DigitalGlobe, Vodafone Hungary, Aegon Hungary, Bureau Veritas, Brammer Group, Florida Department of Juvenile Justice, InSites Consulting, Fortis Turkey
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 Knime, Weka, IBM and others in Data Mining. Updated: February 2025.
837,501 professionals have used our research since 2012.