What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
525 Ratings
47 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
525 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Likelihood to Recommend

IBM Planning Analytics

Cognos TM1's ability to store and provide fast access financial data both on-premise and in the cloud makes it a great asset during month-end or year-end closing. The speed at which it can be updated and reflect GL changes for reporting makes it well suited for PL and BL reporting. For example, when it comes budgeting season and your FI application is getting hammered a speedy application makes your user base happy. However, Cognos TM1 is not well suited for reporting when you have to store a lot of granular data, think retail transaction level stuff, as Cognos TM1 is an OLAP data structure rather than relational.
No photo available

Microsoft Power BI

Power BI is great for reporting of any type. The dashboards I create for my executive team are crisp and easy to understand. I often get complements on it, and suggestions on what other reports or data could benefit from Power BI. Power BI is still dependent on data sources, so if my data source connections break, then the report is no good. This isn't something that you can create and forget. It needs eyes on it to ensure the data is correct
Richard Crane profile photo

Feature Rating Comparison

BI Standard Reporting

IBM Planning Analytics
7.0
Microsoft Power BI
8.3
Pixel Perfect reports
IBM Planning Analytics
6.0
Microsoft Power BI
8.0
Customizable dashboards
IBM Planning Analytics
8.0
Microsoft Power BI
8.6
Report Formatting Templates
IBM Planning Analytics
7.0
Microsoft Power BI
8.3

Ad-hoc Reporting

IBM Planning Analytics
8.3
Microsoft Power BI
8.4
Drill-down analysis
IBM Planning Analytics
9.0
Microsoft Power BI
8.5
Formatting capabilities
IBM Planning Analytics
8.0
Microsoft Power BI
8.2
Report sharing and collaboration
IBM Planning Analytics
8.0
Microsoft Power BI
8.5
Integration with R or other statistical packages
IBM Planning Analytics
Microsoft Power BI
8.2

Report Output and Scheduling

IBM Planning Analytics
9.0
Microsoft Power BI
8.3
Publish to PDF
IBM Planning Analytics
9.0
Microsoft Power BI
8.1
Report Versioning
IBM Planning Analytics
9.0
Microsoft Power BI
8.4
Publish to Web
IBM Planning Analytics
Microsoft Power BI
8.8
Report Delivery Scheduling
IBM Planning Analytics
Microsoft Power BI
8.3
Delivery to Remote Servers
IBM Planning Analytics
Microsoft Power BI
8.0

Data Discovery and Visualization

IBM Planning Analytics
8.5
Microsoft Power BI
8.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
IBM Planning Analytics
9.0
Microsoft Power BI
8.5
Location Analytics / Geographic Visualization
IBM Planning Analytics
8.0
Microsoft Power BI
8.4
Predictive Analytics
IBM Planning Analytics
Microsoft Power BI
7.9

Access Control and Security

IBM Planning Analytics
9.0
Microsoft Power BI
8.4
Multi-User Support (named login)
IBM Planning Analytics
9.0
Microsoft Power BI
8.4
Role-Based Security Model
IBM Planning Analytics
8.0
Microsoft Power BI
8.0
Multiple Access Permission Levels (Create, Read, Delete)
IBM Planning Analytics
10.0
Microsoft Power BI
8.4
Single Sign-On (SSO)
IBM Planning Analytics
9.0
Microsoft Power BI
8.8

Budgeting, Planning, and Forecasting

IBM Planning Analytics
9.1
Microsoft Power BI
Long-term financial planning
IBM Planning Analytics
8.6
Microsoft Power BI
Financial budgeting
IBM Planning Analytics
10.0
Microsoft Power BI
Forecasting
IBM Planning Analytics
8.6
Microsoft Power BI
Scenario modeling
IBM Planning Analytics
9.3
Microsoft Power BI
Management reporting
IBM Planning Analytics
9.3
Microsoft Power BI

Consolidation and Close

IBM Planning Analytics
9.0
Microsoft Power BI
Financial data consolidation
IBM Planning Analytics
10.0
Microsoft Power BI
Journal entries and reports
IBM Planning Analytics
8.0
Microsoft Power BI
Multi-currency management
IBM Planning Analytics
10.0
Microsoft Power BI
Intercompany Eliminations
IBM Planning Analytics
10.0
Microsoft Power BI
Minority Ownership
IBM Planning Analytics
8.0
Microsoft Power BI
Local and consolidated reporting
IBM Planning Analytics
10.0
Microsoft Power BI
Detailed Audit Trails
IBM Planning Analytics
7.0
Microsoft Power BI

FInancial Reporting and Compliance

IBM Planning Analytics
9.0
Microsoft Power BI
Financial Statement Reporting
IBM Planning Analytics
10.0
Microsoft Power BI
Management Reporting
IBM Planning Analytics
9.3
Microsoft Power BI
Excel-based Reporting
IBM Planning Analytics
10.0
Microsoft Power BI
Automated board and financial reporting
IBM Planning Analytics
8.6
Microsoft Power BI
XBRL support for regulatory filing
IBM Planning Analytics
7.3
Microsoft Power BI

Analytics

IBM Planning Analytics
8.1
Microsoft Power BI
Personalized dashboards
IBM Planning Analytics
8.6
Microsoft Power BI
Color-coded scorecards
IBM Planning Analytics
7.1
Microsoft Power BI
KPIs
IBM Planning Analytics
6.4
Microsoft Power BI
Cost and profitability analysis
IBM Planning Analytics
9.3
Microsoft Power BI
Key Performance Indicator setting
IBM Planning Analytics
9.3
Microsoft Power BI
Benchmarking with external data
IBM Planning Analytics
7.8
Microsoft Power BI

Integration

IBM Planning Analytics
9.5
Microsoft Power BI
Flat file integration
IBM Planning Analytics
9.3
Microsoft Power BI
Excel data integration
IBM Planning Analytics
10.0
Microsoft Power BI
Direct links to 3rd-party data sources
IBM Planning Analytics
9.3
Microsoft Power BI

Mobile Capabilities

IBM Planning Analytics
Microsoft Power BI
8.2
Responsive Design for Web Access
IBM Planning Analytics
Microsoft Power BI
8.2
Dedicated iOS Application
IBM Planning Analytics
Microsoft Power BI
8.3
Dedicated Android Application
IBM Planning Analytics
Microsoft Power BI
8.3
Dashboard / Report / Visualization Interactivity on Mobile
IBM Planning Analytics
Microsoft Power BI
8.2

Application Program Interfaces (APIs) / Embedding

IBM Planning Analytics
Microsoft Power BI
7.9
REST API
IBM Planning Analytics
Microsoft Power BI
8.1
Javascript API
IBM Planning Analytics
Microsoft Power BI
8.2
iFrames
IBM Planning Analytics
Microsoft Power BI
7.8
Java API
IBM Planning Analytics
Microsoft Power BI
7.5
Themeable User Interface (UI)
IBM Planning Analytics
Microsoft Power BI
8.1
Customizable Platform (Open Source)
IBM Planning Analytics
Microsoft Power BI
7.9

Pros

IBM Planning Analytics

  • TM1 is tremendously more flexible than the competitor products due to its ability to calculate real-time.
  • Hierarchy changes are instantly available to take advantage of the real-time calculation. No pre-consolidations needed!
  • Native write-back capability allows for simple, integrated budgeting, forecasting and what-if analysis.
  • IBM is constantly improving the product and integrating with new products like Cognos BI, SPSS and is now beginning to integrate it with Watson Analytics.
  • New cloud versions of TM1 are now providing some really great web-based tools to simplify and streamline the presentation development and strengthen the self-service reporting, analytics and what-if analysis capacity.
Christopher Redmond profile photo

Microsoft Power BI

  • Engaging dashboard displays with drag and drop modules to convey data in a meaningful ways.
  • Familiar Microsoft "Ribbon" type interface that creates an integral feel with the rest of the Microsoft suite of products.
  • Built-in mobile optimization window and associated Mobile applications that allow viewing from any location connected to the server.
Rick Botha profile photo

Cons

IBM Planning Analytics

  • User interface could be more modern and intuitive
  • Better capability to brand the tool to fit your company's aesthetic
  • Built in / out of the box stock-based-compensation modeling
  • More colors and fonts for visualizations
No photo available

Microsoft Power BI

  • It is such a powerful system that it can come across as intimidating for some without some Excel knowledge
  • I'm not a database analyst or administrator, so calling the data in can be difficult (not necessary the fault of the software, but something that could be difficult for teams without someone with database knowledge)
  • It can come across as confusing, when there is both a local Power BI and online Power BI components. They don't necessarily do the same functions. You'll definitely want to know how to use the online version as this is how you'll publish and share the results of your findings, but the local one has a lot of capabilities that don't appear to be directly available in the online version (and if so, it's not immediately apparent).
Steffany Winkelmann profile photo

Likelihood to Renew

IBM Planning Analytics

IBM Planning Analytics 10.0
Based on 1 answer
This is a planning developer's dream. You feel like you're given a blank canvas with all the right tools to make it an artwork. It is the future of business application development.
David Chen profile photo

Microsoft Power BI

Microsoft Power BI 10.0
Based on 1 answer
I find it helpful and easy to use
jim paroly profile photo

Usability

IBM Planning Analytics

IBM Planning Analytics 9.0
Based on 1 answer
The application is easy to install and to develop with. Your super users have the ability to manage the data and the user logins without IT help.
No photo available

Microsoft Power BI

Microsoft Power BI 9.0
Based on 3 answers
PBI is very easy to use because of its similarity with power pivot and excel. DAX is the basic foundation language to be mastered to quickly build reports. Custom measures have been introduce to write instant DAX functions (But doesnt work all the time and need a understanding of DAX to debug). Easy to chart multiple charts and also third party charts
Rohit Acharya profile photo

Support

IBM Planning Analytics

IBM Planning Analytics 8.0
Based on 1 answer
There are good support people in Ottawa, but having access to the development team and a TAM make the support. Without that access I don't think IBM Support would be as highly rated.
No photo available

Microsoft Power BI

No score
No answers yet
No answers on this topic

Alternatives Considered

IBM Planning Analytics

  • TM1 is an in-memory solution which provides on-demand calculations and consolidations with the flexibility to instantly apply hierarchy changes and allows storage and reporting of text.
  • TM1 has an extremely fast ETL tool which can consume most data sources.
  • Cube rules virtually stand alone among the competition.
  • Most competitor products strive to match TM1 performance, flexibility and functionality.
  • As an IBM product, TM1 continues to be integrated into many other "sister" products and has a vast R&D team with deep pocket resources available and committed to continued product development.
Christopher Redmond profile photo

Microsoft Power BI

Microsoft Power BI as I said earlier is unfortunate in relation to the panels but compared to Tableau.Although Microsoft Power BI has a general interface easier to understand in my company because we already have a signature with the package Office 365 that the integration of the same is excellent.
Gabriel Oliveira profile photo

Return on Investment

IBM Planning Analytics

  • Increased employee efficiency. Employees have more time to analyze the results because little time is spent gathering or compiling data
  • More accurate forecasts and predictions based on the data due to it's efficiency
  • Better planning for future years based on accurate historical data
No photo available

Microsoft Power BI

  • I'm using the free version, so the only investment was the time spent to learn how to use the product (which as an Excel user, was very short).
  • I use Excel to store every single bit of information about all the projects I do, and being able to see them visualized helped me see some redundant steps I was taking.
  • No negative impact at all for me.
jim paroly profile photo

Pricing Details

IBM Planning Analytics

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Microsoft Power BI

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison