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.3%, up 16.4% compared to last year.
Microsoft Power BI, on the other hand, focuses on BI (Business Intelligence) Tools, holds 21.6% mindshare, down 22.4% 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

"It helped me in that I didn't need to write them by hand, and I could get a result in one or two minutes. That helped me a lot."
"You take two quarters and compare them and this tool is ideal because it gives you a lot of visibility on the before and after."
"It will scale up to anything we need."
"I think the code modeling features are the most valuable and without the need to write a code back with many different possibilities to choose from. And the second one is linked to the activity of the data preparation."
"​It works fine. I have not had any stability issues; it is always up.​"
"It’s definitely scalable, it’s all on the same platform, it’s well integrated. I think the integration is important in terms of scalablility because essentially, having the entire suite helps a lot to scale it"
"IBM was chosen because of usability. It's point and click, whereas the other out-of-the box-solution, or open-source solutions, require full-on programming and a much higher skill level."
"So far, the stability has been rock solid."
"Power BI allows me to show detailed improvements in quality and safety and patient experience."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"We have found the product to be scalable."
"The solution is quite scalable."
"I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated."
"It's easy to create reports and it's easy to download the data from the corresponding report."
"My favorite feature is the power query editor, where it can do the data transformations."
 

Cons

"I can say the solution is outdated."
"The biggest issue with the visual modeling capability is that we can't extract the SQL code under the hood."
"We would like to see better visualizations and easier integration with Cognos Analytics for reporting."
"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."
"Time Series or forecasting needs to be easier. It is a very important feature, and it should be made easier and more automated to use. For instance, for logistic regression, binary or multinomial is used automatically based on the type of the target variable. I wish they can make Time Series easier to use in a similar way."
"The product does not have a search function for tags."
"It would be good if IBM added help resources to the interface."
"C&DS will not meet our scalability needs."
"Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
"Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."
"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 solution could improve by simplifying the user interface and adding integration or compatibility with APA."
"Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."
"An area for improvement is data refresh functionality"
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
 

Pricing and Cost Advice

"It is an expensive product."
"Its price is okay for a company, but for personal use, it is considered somewhat expensive."
"It got us a good amount of money with quick and efficient modeling."
"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."
"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."
"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 is a huge increase to time savings."
"The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly."
"Licensing fees are paid on a yearly basis."
"All of the licenses are on an annual basis, but Microsoft will amortize it to an extent. If it's five years, they'll include the possible interest they might have the following year. Ideally, their licensing scheme is an annual license, but they make it easier for some of our clients to take a five-year license but package everything inside for them to buy the license for five years."
"I rate the product pricing a ten."
"Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
"All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
"It would be better if the price was cheaper."
"While Power BI is generally a paid product, particularly for enterprise features and scalability, you can start with the free version and still achieve significant functionality."
report
Use our free recommendation engine to learn which Data Mining solutions are best for your needs.
847,862 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
13%
Educational Organization
12%
University
10%
Government
8%
Educational Organization
41%
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: April 2025.
847,862 professionals have used our research since 2012.