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 (17th)
Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
321
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.9%, up 16.3% compared to last year.
Microsoft Power BI, on the other hand, focuses on BI (Business Intelligence) Tools, holds 20.7% mindshare, down 21.9% 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.
Shoury Priyanshu - PeerSpot reviewer
Facilitates seamless data aggregation with some outdated visual elements hindering user appeal
Real-time data integration is an area for improvement. Although I've worked on several solutions involving real-time integration, it's not very user-friendly and often lags, especially with over a million data rows. This makes Power BI difficult to manage as loading times can reach one or two minutes, which is problematic today. There are challenges with scalability, requiring multiple pages in dashboards to manage these issues. Visualization could be improved as it appears outdated. Users, especially newcomers, find it unappealing and not user-friendly.

Quotes from Members

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

Pros

"It makes pretty good use of memory. There are algorithms take a long time to run in R, and somehow they run more efficiently in Modeler."
"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."
"In the solution, I like the virtualization of data flow since it shows what goes where, which is mostly the strength of the tool."
"We are creating models and putting them into production much faster than we would if we had just gone with a strict, code-based solution, like R or Python."
"A lot of jobs that are stuck in Excel due to the huge numbers of rows are tackled pretty quickly."
"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"
"It is pretty scalable."
"I was familiar with using IBM SPSS Modeler separately in the private sector before that. It's a good tool for extracting data from data warehouses, creating streams, and manipulating logic to extract final data."
"The ease of integration and connectivity stands out as the most critical aspect, followed closely by the flexibility to customize reports and dashboards."
"There is continual improvement year-over-year."
"The initial setup is relatively simple."
"The dashboard is very nice and it is very simple to understand every single component."
"The user experience is easy. Users get familiar with it quickly."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"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."
"The initial setup is easy."
 

Cons

"The forecasting could be a bit easier."
"It would be beneficial if the tool would include more well-known machine learning algorithms."
"The platform's cloud version needs improvements."
"I think mapping for geographic data would also be a really great thing to be able to use."
"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."
"It would be helpful if SPSS supported open-source features, for example, embedding R or Python scripts in SPSS Modeler."
"Unstructured data is not appropriate for SPSS Modeler."
"​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.​"
"The integration with other solutions could be improved for reporting aspects."
"I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier."
"We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"Microsoft is behind IBM when it comes to security features."
"The solution is somewhat costly in comparison with MSBI tools."
"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."
"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."
 

Pricing and Cost Advice

"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."
"If you are in a university and the license is free then you can use the tool without any charges, which is good."
"It is an expensive product."
"This tool, being an IBM product, is pretty expensive."
"I am using the free version of IBM SPSS Modeler, it is the educational edition version."
"Its price is okay for a company, but for personal use, it is considered somewhat expensive."
"It is a huge increase to time savings."
"$5,000 annually."
"Pricing, that's where Microsoft beats Tableau. It is priced much cheaper."
"From a cost point of view, it's competitive in the enterprise space, although it's not as competitive when you add up all of the additional costs. Things like integrations cost extra and it's probably where Microsoft makes more of the money."
"MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
"Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI."
"Licensing is on a monthly basis, but I am not sure."
"Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
"The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly."
"It would be better if the price was cheaper."
report
Use our free recommendation engine to learn which Data Mining solutions are best for your needs.
864,053 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
11%
Educational Organization
11%
Government
10%
University
8%
Financial Services Firm
12%
Computer Software Company
9%
Government
9%
Manufacturing Company
8%
 

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: July 2025.
864,053 professionals have used our research since 2012.