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

IBM SPSS Modeler vs Microsoft Power BI comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

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)
IBM SPSS Modeler
Average Rating
8.0
Number of Reviews
39
Ranking in other categories
Data Mining (4th), Data Science Platforms (13th)
Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
 

Mindshare comparison

Data Mining
BI (Business Intelligence) Tools
 

Featured Reviews

AbakarAhmat - PeerSpot reviewer
Enhancing survey analysis that provides valued insightfulness
I used traditional tools where I would prepare data, click through menus, and use SQL Server for data visualization. We switched to IBM SPSS because it offers strong certification and aligns well with the standards we prioritize in our surveys. In terms of popularity, it stands out as the top choice in the market, especially in the research and university domains. Many different organizations and institutions use SPSS for statistical analytics. While there are other tools like MCLab and similar options available, SPSS is the most renowned and widely used among them.
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.
Amol Rane - PeerSpot reviewer
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

"Some of the most valuable features that we are using with some business models are machine learning algorithms, statistical models given to us by the business, and getting data from the database or text files."
"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."
"It has the ability to easily change any variable in our research."
"The software offers consistency across multiple research projects helping us with predictive analytics capabilities."
"Most of the product features are good but I particularly like the linear regression analysis."
"Custom tables and macros: They allow us to create useful reports quickly for a broad audience."
"You can quickly build models because it does the work for you."
"The best part is that they have an algorithm handbook, so you can open it up and understand how it works, and if it is useful, this is very important."
"It is pretty scalable."
"Compared to other tools, the product works much easier to analyze data without coding."
"Extremely easy to use, it offers a generous selection of proprietary machine learning algorithms."
"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."
"Stability is good."
"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 will scale up to anything we need."
"We have full control of the data handling process."
"Real-time refresh is quite interesting and user-friendly, provided you have access to a gateway. It works well."
"The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information."
"I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs."
"The visualization part and its inclusion in a cloud-based application are valuable features."
"One of the most valuable features of Power BI is the ease of use. It is comfortable and there is not a steep learning curve for this solution. If you have some idea of the data and basic visualization ideas, you can use this solution comfortably."
"This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
"The solution is very easy to use."
"You can integrate Microsoft Power BI with various other solutions like Intune."
 

Cons

"Perhaps in terms of visualization. It's not really easy to do some data visualization, just simple, descriptive analysis in SPSS. I think that could be an area for improvement."
"The solution needs more planning tools and capabilities."
"It could allow adding color to data models to make them easier to interpret."
"Needs more statistical modelling functions."
"If there is any self-generation data collection plan (DCP), it would be helpful in gathering data. It would also be useful if there is a function to scale it up to, let's say, UiPath and have it consolidate and integrate into a UiPath solution."
"I feel that when it comes to conducting multiple analyses, there could be more detailed information provided. Currently, the software gives a summary and an overview, but it would be beneficial to have specific details for each product or variable."
"In developing countries, it would be beneficial to provide certain features to users at no cost initially, while also customizing pricing options."
"SPSS is a tool that's been around since the late 60s, and it's the universal worldwide standard for quantitative social science data analysis. That said, it does seem a bit strange to me that the graphical output functions are so clunky after all these years. The output of charts and graphs that SPSS produces is hideous."
"The standard package (personal) is not supported for database connection."
"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."
"We have run into a few problems doing some entity matching/analytics."
"We would like to see better visualizations and easier integration with Cognos Analytics for reporting."
"It's not as user friendly as it could be."
"Formula writing is not straightforward for an Excel user. Totally new set of functions, which takes time to learn and teach."
"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."
"Dimension reduction should be classified separately."
"From an improvement perspective, I think if the Power BI developers of that platform would really focus on being more detailed and specific on the error messages, it would help a lot of developers troubleshoot and maintain the report ECT or the dashboard ECT."
"I cannot comment on the stability as we haven't yet used it for a big project."
"The setup took a lot of tinkering with InfoSec to allow us to do stuff."
"We found out that you can't share a report with others unless you have an additional package. That caught us off guard. It came as a program that somebody could go in, build a report, and show it, but you can't share it without having additional licenses."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"For someone who is new, I think that Power BI can be a little complicated."
"Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse."
"The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section."
 

Pricing and Cost Advice

"While the pricing of the product may be higher, the accompanying service and features justify the investment."
"The pricing of the modeler is high and can reduce the utility of the product for those who can not afford to adopt it."
"The price of IBM SPSS Statistics could improve."
"The price of this solution is a little bit high, which was a problem for my company."
"SPSS is an expensive piece of software because it's incredibly complex and has been refined over decades, but I would say it's fairly priced."
"It's quite expensive, but they do a special deal for universities."
"More affordable training for new staff members."
"We think that IBM SPSS is expensive for this function."
"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."
"Having in mind all four tools from Garner’s top quadrant, the pricing of this tool is competitive and it reflects the quality that it offers."
"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."
"I am using the free version of IBM SPSS Modeler, it is the educational edition version."
"This tool, being an IBM product, is pretty expensive."
"It got us a good amount of money with quick and efficient modeling."
"It is a huge increase to time savings."
"$5,000 annually."
"It is somewhere in the middle in terms of price. Licensing is quite clear."
"The solution's pricing is medium."
"We have enterprise licenses and some of the other tools or features come as a package and others you have to purchase separately."
"It is part of our Office 365 license."
"We pay for users who are publishing on the cloud. The desktop version is free. Its licensing is on a yearly basis."
"Make it low in cost. It is a no-brainer!"
"In the beginning, the solution cost approximately $1,000 per month, we have a Microsoft startup subscription. There is a subscription pack for startups company which we are able to have for one year."
"Licensing fees are paid on a yearly basis."
report
Use our free recommendation engine to learn which Data Mining solutions are best for your needs.
816,636 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%
Computer Software Company
9%
University
9%
Manufacturing Company
8%
Educational Organization
14%
Financial Services Firm
13%
Computer Software Company
9%
University
9%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
6%
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?
The cost of IBM SPSS Statistics is managed by organizations, not individual researchers. It is a very expensive produ...
What needs improvement with IBM SPSS Statistics?
IBM SPSS Statistics does not keep you close to your data like KNIME. In KNIME, at every stage, you can see the result...
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 bud...
What needs improvement with IBM SPSS Modeler?
There are performance issues. Extracting data from many combined tables can take hours and occasionally crash the ser...
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
SPSS Modeler
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

Learn More

Video not available
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
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: November 2024.
816,636 professionals have used our research since 2012.