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.6
Reviews Sentiment
6.8
Number of Reviews
23
Ranking in other categories
Business Performance Management (4th)
Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
318
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 9.5%, up 8.7% compared to last year.
Microsoft Power BI, on the other hand, focuses on BI (Business Intelligence) Tools, holds 22.6% mindshare, up 22.5% 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.
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

"The most valuable features of IBM Planning Analytics for streamlining planning processes include a unified database where all data are centralized."
"Planning Analytics' best features include automatic updates and slicing."
"Navigating through the data to make analysis is really quick."
"The product's stability is good."
"The tool is flexible."
"It's a very stable, robust product."
"The flexibility of IBM Planning Analytics is a great feature of this solution. The design flexibility with data rules and defining calculations The ability to combine online and offline calculations are a benefit. Additionally, the forecasting features and predictive analytics is very good."
"All the different platforms are well integrated."
"The most valuable feature of Power BI is its ability to provide customized visualizations and insights tailored to specific business needs."
"Because this solution is very easy, and very visual, you can have results in minutes."
"The product is stable."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"Microsoft Power BI is an easy tool for data analysis."
"Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
"Power BI's integration with other tools is very good."
"It is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow."
 

Cons

"The tool's transport layer could be improved when promoting development between environments."
"It would have been better if the solution was not just a tool kit."
"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."
"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."
"Adding predefined templates could be beneficial."
"It is a bit expensive, but it does the job."
"The local authentication part is difficult to manage in the product, making it an area where improvements are required."
"Extracting data is a little slow."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"Integrating it with the physics build model or the engineering model should be included."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"It should have more report outputs. They should expand the report outputs. Its documentation should also be better."
"The solution should increase the API functionality so that we can use Microsoft Power BI for other purposes and aggregate things."
"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."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"I have found that some issues exist, indicating room for improvement in scalability."
 

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."
"The license of this solution is paid annually. Most of my customers choose a license that includes support."
"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."
"If you purchase a license for a server, for users, or the professional version, you might not have to. The free version I think it can satisfy many customers' needs."
"It is a cheap solution for our needs."
"The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly."
"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."
"Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
"This solution came free, it was offered by Microsoft with our E3 license."
"In general, Microsoft BI's price is lower compared to Alteryx."
"Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
report
Use our free recommendation engine to learn which Business Performance Management solutions are best for your needs.
831,158 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
49%
Financial Services Firm
9%
Computer Software Company
6%
Manufacturing Company
6%
Educational Organization
43%
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 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?
The cost of IBM Planning Analytics is not cheap, considering the amount of money involved. However, it offers good ROI for customers.
What needs improvement with IBM Planning Analytics?
The workspace API should be improved and documented so we know better which objects and tier-one objects are used.
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
 

Learn More

 

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: December 2024.
831,158 professionals have used our research since 2012.