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

IBM Planning Analytics 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 Planning Analytics
Average Rating
8.4
Reviews Sentiment
6.8
Number of Reviews
24
Ranking in other categories
Business Performance Management (3rd)
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 Planning Analytics is designed for Business Performance Management and holds a mindshare of 8.7%, down 9.2% 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.
Business Performance Management
BI (Business Intelligence) Tools
 

Featured Reviews

Gnanavel-Chakkarapani - PeerSpot reviewer
Can easily create dashboards and helps businesses improve forecasting accuracy
The product has improved our company's forecasting accuracy since it serves as a very useful tool for our sales and controller teams as they easily get to enter the inputs using views in TM1, which gets loaded into our main database. If there are sales team members in different parts of the world, like in Hong Kong and Singapore, they may prefer to use IBM Planning Analytics, which is easy to use when compared to the Excel tool. Speaking about planning analytics and data analysis, I would say that our company used to use IBM Cognos Analytics for reporting, where we used to use Cognos Dynamic Cubes so that users can easily use its drag and drop features while getting to see the data for which the users had to wait for two to three minutes prior to its use. In our company, tons of data are loaded into the memory, and users can use Cognos Dynamic Cubes to analyze data and understand it. The AI capabilities of IBM have benefited our planning strategy as they are very useful for business. The tool allows the easy creation of dashboard reports using AI capabilities. No technical knowledge is required for business use cases. It is possible to integrate the product in scenarios where some new integrations are available. I remember that my company used Azure Data Factory to connect Azure, Oracle, and IBM WebSphere Application Server. When it comes to IBM Planning Analytics, it is complex to integrate it with LDAP and or any other authentication tool offered by Microsoft. In our company, some users like to integrate IBM Planning Analytics with the common LDAP or Microsoft AD, which we currently use for all our applications. The authentication part is difficult to configure with IBM Planning Analytics. The maintenance of the product is easy. My company has scheduled maintenance on the product every week, especially during forecast times, so that memories automatically lapse and users can freely access their servers. The use of the tool has had an impact on collaboration within our company's planning team since everyone knows how to easily access the data and publish the results. I recommend the product to those who plan to use it. I rate the tool a nine out of ten.
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

"This level of stability is crucial for a product like Cognos TM1, as using an unstable platform would result in loss of time."
"It's a very stable, robust product."
"A lot of the platform is in-memory, so Planning Analytics can run calculations quite fast. It also offers several user interfaces. And in the newest version of Planning Analytics, there is a new one called the Planning Analytics Workspace. Maybe it could be useful for the business side."
"Its stability helps controllers win time in their planning processes."
"IBM Planning Analytics is easy to use and deploy. It is quick to develop. The calculation machine is also very fast."
"Planning Analytics' best features include automatic updates and slicing."
"All the different platforms are well integrated."
"The product's stability is good."
"There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources."
"Helped identify bad data, enabling the corrections needed to the data for management."
"The initial setup is pretty straightforward."
"PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions."
"Microsoft BI is very easy to set up and use."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"You can integrate Microsoft Power BI with various other solutions like Intune."
"The visualization part and its inclusion in a cloud-based application are valuable features."
 

Cons

"Planning Analytics could be improved by adding automation features."
"It would have been better if the solution was not just a tool kit."
"It's highly competitive right now, and all the vendors are in a race to put out new versions with additional features. IBM comes out with new versions too often, and it has an impact on quality."
"The dashboard is very poor and needs a lot of improvement."
"If we talk only about the TM1 engine, it's quite rich and possibly too rich, making it complex to perform simple tasks."
"The new frontend Planning Analytics Workspace is not very good, it could be improved. I like the Planning Analytics functionality but it would be helpful if it could be more customizable. You can create a prediction and receive information but you cannot do feature engineering regarding the predictive models. If this was added it would be helpful."
"The tool should include features for prediction. It can also improve the scalability."
"The tool's transport layer could be improved when promoting development between environments."
"There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented."
"You do need to do some hard coding for certain things in Microsoft BI."
"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."
"The challenge of this product is in truncating the table data."
"The solution should increase the API functionality so that we can use Microsoft Power BI for other purposes and aggregate things."
"I would like to see a more user-friendly interface with Microsoft BI."
"I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports."
"The biggest thing with Microsoft right now is better support. There should be more timely support. We can do 90% of it ourselves by the same token. When we're into the 10%, we do not get timely support via Microsoft's support team."
 

Pricing and Cost Advice

"It is a bit expensive, but you get what you are paying for."
"Our licensing cost is approximately $50,000.00 per year."
"IBM Planning Analytics is not the cheapest solution, but it's priced per the market standard for this type of solution. I rate the price at seven out of ten."
"IBM Planning Analytics is priced well, and licensing costs are yearly."
"I would rate the tool's pricing a nine out of ten since it's expensive."
"Compared with the other tools in the market, IBM Planning Analytics is a bit expensive."
"The license of this solution is paid annually. Most of my customers choose a license that includes support."
"Paid for itself in the first month."
"Regarding cost, the initial investment wasn't too high, but ongoing licensing could add up."
"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."
"I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage."
"The pricing is very reasonable compared to any other tool."
"The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly."
"The pricing for the solution is relatively higher compared to other alternatives."
"Power BI premium is really expensive for our market. A lot of small and medium companies would like to purchase it, but they can't afford it."
report
Use our free recommendation engine to learn which Business Performance Management solutions are best for your needs.
847,959 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
Educational Organization
43%
Financial Services Firm
10%
Computer Software Company
7%
Manufacturing Company
6%
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 Planning Analytics?
The most valuable features of IBM Planning Analytics for streamlining planning processes include a unified database where all data are centralized.
What is your experience regarding pricing and costs for IBM Planning Analytics?
TM1 is quite expensive, and I'd rate the pricing as an eight out of ten. While we do get what we want in terms of functionalities and compatibility with other IBM tools, given the product's old arc...
What needs improvement with IBM Planning Analytics?
Since I'm using TM1 as an old version of Planning Analytics, it wouldn't be fair to specify what needs improvement because it's possible these issues have already been addressed in newer versions. ...
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

Cognos TM1, IBM Cognos TM1
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

Overview

 

Sample Customers

ManpowerGroup, Convergys, AIG, Orchard Brands, Citibank, InterGen, Northwestern University, EF Education First, Ironside, Bazan Group, CSOB Insurance, Macquarie Group, Charles Stanley, SATO, Government of Sint Maarten, BMW Financial Services
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 Anaplan, Oracle, IBM and others in Business Performance Management. Updated: April 2025.
847,959 professionals have used our research since 2012.