Coming October 25: PeerSpot Awards will be announced! Learn more

IBM Planning Analytics vs Microsoft BI comparison

You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Planning Analytics and Microsoft BI based on real PeerSpot user reviews.

Find out in this report how the two Business Performance Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed IBM Planning Analytics vs. Microsoft BI report (Updated: September 2022).
635,513 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
"The ease of use is valuable. The fact that it's plugged into Excel spreadsheets is also valuable. It provides additional functionality where you can slice and dice the information in a way that you can't do with spreadsheets""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.""Planning Analytics' best features include automatic updates and slicing.""Navigating through the data to make analysis is really quick.""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."

More IBM Planning Analytics Pros →

"It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite.""Many of my customers already use Microsoft products like Office 365, so I often propose Microsoft Power BI because it integrates well with all the standard Microsoft business tools. And it's the quickest tool to implement and start using daily.""When we are introducing Microsoft BI to our clients, if they're familiar with Excel, the transition phase will be much easier for them. They can easily switch from Microsoft Excel to Microsoft BI. The core foundation or the base technology is the same in both tools. There are a few limitations in Microsoft Excel, and this is where Microsoft BI comes in.""Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it.""I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs.""The initial setup is relatively simple.""What's most valuable in this tool is that it gives its users detailed error messages. It's a very stable data analytics tool, and it offers good scalability.""The most valuable feature of Microsoft BI is its visualization and its ease of use."

More Microsoft BI Pros →

"It is a bit expensive, but it does the job.""Extracting data is a little slow.""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 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."

More IBM Planning Analytics Cons →

"Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions.""I have been doing trial and error to figuring out how to do the data analyzing and modeling. There could be some improvement to simplify it.""Integrating it with the physics build model or the engineering model should be included.""I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple.""The solution could improve by simplifying the user interface and adding integration or compatibility with APA.""It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake.""My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack.""The mobile app is very poor."

More Microsoft BI Cons →

Pricing and Cost Advice
  • "The license of this solution is paid annually. Most of my customers choose a license that includes support."
  • "It is a bit expensive, but you get what you are paying for."
  • More IBM Planning Analytics Pricing and Cost Advice →

  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
  • "Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • "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."
  • More Microsoft BI Pricing and Cost Advice →

    Use our free recommendation engine to learn which Business Performance Management solutions are best for your needs.
    635,513 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The ease of use is valuable. The fact that it's plugged into Excel spreadsheets is also valuable. It provides additional functionality where you can slice and dice the information in a way that you… more »
    Top Answer:It is a bit expensive, but you get what you are paying for.
    Top Answer:It is a bit expensive, but it does the job.
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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… more »
    Average Words per Review
    Average Words per Review
    Also Known As
    Cognos TM1, IBM Cognos TM1
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Learn More

    IBM Planning Analytics is an integrated planning solution that uses AI to automate planning, budgeting, and forecasting and drive more intelligent workflows.

    Built on TM1, IBM’s powerful calculation engine, this enterprise performance management tool allows you to transcend the limits of manual planning and become the Analytics Hero your business needs. Quickly and easily drive faster, more accurate plans for FP&A, sales, supply chain and beyond.

    Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server, with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end-users to better analyze their data, collaborate and better present their data.

    Learn more about IBM Planning Analytics
    Learn more about Microsoft BI
    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
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Top Industries
    Computer Software Company17%
    Comms Service Provider12%
    Financial Services Firm10%
    Manufacturing Company6%
    Financial Services Firm14%
    Manufacturing Company14%
    Computer Software Company11%
    Computer Software Company17%
    Comms Service Provider13%
    Financial Services Firm10%
    Company Size
    Small Business56%
    Midsize Enterprise17%
    Large Enterprise28%
    Small Business19%
    Midsize Enterprise11%
    Large Enterprise70%
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise45%
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Business Performance Management
    September 2022
    Find out what your peers are saying about Anaplan, Oracle, Domo and others in Business Performance Management. Updated: September 2022.
    635,513 professionals have used our research since 2012.

    IBM Planning Analytics is ranked 4th in Business Performance Management with 6 reviews while Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 187 reviews. IBM Planning Analytics is rated 8.6, while Microsoft BI is rated 8.0. The top reviewer of IBM Planning Analytics writes "High-performing, helps clients save time in budget processes ". On the other hand, the top reviewer of Microsoft BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". IBM Planning Analytics is most compared with SAP Analytics Cloud, Jedox, Oracle Hyperion, IBM Cognos and Tableau, whereas Microsoft BI is most compared with Amazon QuickSight, Tableau, SAP BusinessObjects Business Intelligence Platform, Oracle OBIEE and IBM Cognos.

    We monitor all Business Performance Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.