IBM Planning Analytics vs. Microsoft Power BI

I would be likely to recommend IBM Planning Analytics, particularly in scenarios where comprehensive financial and operational planning is essential. For instance, in our construction company, it is awesome for optimizing resource allocation across multiple projects, creating detailed project budgets, and conducting risk analysis to mitigate project uncertainties.

Incentivized

In operations we use the tool for many different topics, from factory quality systems to high level reviews. We have created kind of an internal "App Store" based on Power BI where you have a lot of different dashboards for different solutions (cost, cash, health and safety, sales, factories, distribution centers...) and you as an user just need to get in that "App Store" and enter in whatever tool can be useful for you. It is open to all the operations employees and can use on demand. Also it has raised the imagination of our colleagues, as they are not only working by themselves creating new reports, but also raising fantastic ideas that can be extended for the usage of all the community.

Incentivized

• Forecasting after taking into account seasonal trends and exceptional transactions
• Unlike spreadsheets, there is no fear of an user making changes to the mastercopy accidentally. Each user gets his or her own workspace to analyze.
• For entities operating in multiple countries, connects seamlessly with IBM Cognos Controller for taking into account variation in currencies

Incentivized

• Quickly filter and view granular data sets with easily configurable reporting figures.
• The ability to quickly switch between tabs allows for historical data comparisons and progress tracking.
• It's helpful to dive into the data and break it down from high levels to small.
• Achieve actionable insights faster by using real-time data. It's incredible to have online access to reports.

• IBM Planning Analytics was an upgrade from an older version of TM1 that is experiencing some growing pains, some functionality is harder to reach than it has been in the past
• It is easy to learn as a surface user with created reports, but it does require some technical skills to make advanced calculations and reports if there is no reliable consultant available, much like Excel

Incentivized

• The desktop app is great but needs a lot of performance improvements
• No MacOS Version for the Desktop app, this is a big limitation for business since executives prefer Macs
• Premium Cloud Version of Power BI is awfully expensive
• On-Premise Version of the Power BI Reports Server is bundled only with SQL Server Enterprise License and cannot be purchased separately and requires Software Assurance Subscription
• On-Premise Power BI Report Server doesn't support ADFS, AzureAD or any Claims-Based authentication platform, a sad disadvantage for enterprises

Incentivized

Since IBM Cognos Express is suitable only for medium data warehouse environment, we are not sure if this tool solves the long term need as the business keeps growing rapidly. So its a 50/50 ratio to renew Express license. But having said that, the components of IBM Cognos Express are also available in other Cognos BI suites like Cognos 10.x version. So we will probably upgrade our environment to IBM Cognos 10.x which comes with more new features.

I find it helpful and easy to use

Incentivized

For developers, admins and end users looking for flexibility, IBM Planning Analytics would rate very highly on usability. For example, a developer has access to a highly performant built-in ETL (Extract Translate Load) tool and scripting language called Turbo Integrator that can (among other things) bring in data via flat file or direct connection from many data sources, move data around Planning Analytics, perform batch calculations, export to files or other data stores. In the rare situation where limitations are encountered there is a well documented REST API. Admins and end users benefit from the intuitive PAW (Workspace) interface as well as the rich Excel integration through Planning Analytics for Excel (PAfE). Since flexibility inherently comes with a little more complexity, so an organization with simple and "cookie-cutter" requirements may rate Planning Analytics a little lower.

Incentivized

At this point, I think we all know who has taken the lead in the business intelligence and analytics market worldwide. With fresh new updates every other day on top of an already robustly built product with all features that one can dream of is a no brainer, I feel. Microsoft will invariably be synonymous with quality and professionalism.

Incentivized

Although I find the IBM Planning analytics documentation quite time consuming, their support with email and call is something i can term as very considerate and patient, I have had few calls about the features and how i would want to implement them within my projects, and the teams have been super helpful to resolve my issues

Incentivized

I can't really speak to the support overall, [but] I will say that in the almost three years I have used the system, I have only needed to contact their support team once. I think the team was helpful, but it did take some time for us to resolve the issues/ request that they had. I guess the good news is that the system is pretty stable, and I personally have rarely needed to contact their technical support team.

Incentivized

Anaplan does not handle sparsity; this is very problematic for large volume data sets (many 0's). There also are limitations to the number of dimensions that can be used in a module. If more dimensions are required, then separate modules need to be built and intertwined. IBM PA does not have these limitations.

Incentivized

[Microsoft] Power BI is practical and effective, like a hammer for a nail, it is easy to use and produces very quickly the results that in most cases are urgently required by clients (nice reports to share on the web). To start using [Microsoft] Power BI you need a business email address, with that you create an account in Power BI Service and in less than 1 hour you will have installed Power BI Desktop, a report will have been created and it will have been published on the web .

Incentivized

• One of the advantage is on its ability to ease budget and planning
• Secondly,the fact that it allows for forecasting means based on such insights means that organisations are able to prepare for future eventualities
• Thirdly, since it can accommodate data from multiple sources means that one is able to carry out best business practices like planning.

Incentivized

• It helps us track and achieve company goals.
• It shows us [our] performance in areas we could not previously track and allows us to see and work on how to improve their performance.
• Quick easy access for executives to use in helping teams and addressing issues.

Incentivized