What users are saying about
214 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
540 Ratings
214 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 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
540 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

Anaplan

Well Suited
  • Any process that you expect to change frequently.
  • A process within a dynamic environment, such as high tech / the startup world, where you expect significant business process changes.
  • Any process that requires a significant number of collaborators.
  • Any process where you intend for users to update logic with Excel-like formulas.
  • Any process where using Google Docs has failed to accommodate your needs for data integrity.
Less Appropriate
  • Data visualization - Anaplan has capabilities here, but other tools are more focused on this.
  • Data storage - Anaplan is not a data warehouse and has limits on what you can store.
Matthew Kuo profile photo

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

Anaplan
6.8
Microsoft Power BI
8.3
Customizable dashboards
Anaplan
6.8
Microsoft Power BI
8.6
Pixel Perfect reports
Anaplan
Microsoft Power BI
8.0
Report Formatting Templates
Anaplan
Microsoft Power BI
8.3

Report Output and Scheduling

Anaplan
7.0
Microsoft Power BI
8.3
Publish to PDF
Anaplan
7.9
Microsoft Power BI
8.2
Report Versioning
Anaplan
7.3
Microsoft Power BI
8.3
Report Delivery Scheduling
Anaplan
5.8
Microsoft Power BI
8.3
Publish to Web
Anaplan
Microsoft Power BI
8.8
Delivery to Remote Servers
Anaplan
Microsoft Power BI
8.0

Mobile Capabilities

Anaplan
6.3
Microsoft Power BI
8.1
Responsive Design for Web Access
Anaplan
6.3
Microsoft Power BI
8.2
Dedicated iOS Application
Anaplan
Microsoft Power BI
8.0
Dedicated Android Application
Anaplan
Microsoft Power BI
8.0
Dashboard / Report / Visualization Interactivity on Mobile
Anaplan
Microsoft Power BI
8.1

Budgeting, Planning, and Forecasting

Anaplan
8.1
Microsoft Power BI
Long-term financial planning
Anaplan
6.9
Microsoft Power BI
Financial budgeting
Anaplan
8.3
Microsoft Power BI
Forecasting
Anaplan
8.8
Microsoft Power BI
Scenario modeling
Anaplan
8.2
Microsoft Power BI
Management reporting
Anaplan
8.3
Microsoft Power BI

Consolidation and Close

Anaplan
7.1
Microsoft Power BI
Financial data consolidation
Anaplan
8.3
Microsoft Power BI
Journal entries and reports
Anaplan
6.9
Microsoft Power BI
Multi-currency management
Anaplan
6.2
Microsoft Power BI
Intercompany Eliminations
Anaplan
6.0
Microsoft Power BI
Minority Ownership
Anaplan
6.0
Microsoft Power BI
Local and consolidated reporting
Anaplan
8.2
Microsoft Power BI
Detailed Audit Trails
Anaplan
7.8
Microsoft Power BI

FInancial Reporting and Compliance

Anaplan
7.0
Microsoft Power BI
Financial Statement Reporting
Anaplan
8.9
Microsoft Power BI
Management Reporting
Anaplan
8.9
Microsoft Power BI
Excel-based Reporting
Anaplan
1.6
Microsoft Power BI
Automated board and financial reporting
Anaplan
8.7
Microsoft Power BI

Analytics

Anaplan
6.3
Microsoft Power BI
Personalized dashboards
Anaplan
6.0
Microsoft Power BI
Color-coded scorecards
Anaplan
6.0
Microsoft Power BI
KPIs
Anaplan
7.0
Microsoft Power BI
Cost and profitability analysis
Anaplan
6.0
Microsoft Power BI
Key Performance Indicator setting
Anaplan
5.6
Microsoft Power BI
Benchmarking with external data
Anaplan
7.1
Microsoft Power BI

Integration

Anaplan
7.8
Microsoft Power BI
Flat file integration
Anaplan
8.4
Microsoft Power BI
Excel data integration
Anaplan
6.4
Microsoft Power BI
Direct links to 3rd-party data sources
Anaplan
8.6
Microsoft Power BI

Ad-hoc Reporting

Anaplan
Microsoft Power BI
8.4
Drill-down analysis
Anaplan
Microsoft Power BI
8.5
Formatting capabilities
Anaplan
Microsoft Power BI
8.2
Integration with R or other statistical packages
Anaplan
Microsoft Power BI
8.2
Report sharing and collaboration
Anaplan
Microsoft Power BI
8.5

Data Discovery and Visualization

Anaplan
Microsoft Power BI
8.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Anaplan
Microsoft Power BI
8.5
Location Analytics / Geographic Visualization
Anaplan
Microsoft Power BI
8.3
Predictive Analytics
Anaplan
Microsoft Power BI
7.8

Access Control and Security

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

Application Program Interfaces (APIs) / Embedding

Anaplan
Microsoft Power BI
8.0
REST API
Anaplan
Microsoft Power BI
8.1
Javascript API
Anaplan
Microsoft Power BI
8.2
iFrames
Anaplan
Microsoft Power BI
7.8
Java API
Anaplan
Microsoft Power BI
7.6
Themeable User Interface (UI)
Anaplan
Microsoft Power BI
8.1
Customizable Platform (Open Source)
Anaplan
Microsoft Power BI
8.0

Pros

Anaplan

  • Anaplan is great for headcount reporting. We have reports by dept, office location, and subsidiary that is great for planning and also for full company reporting.
  • Although they can be complicated to set up, Anaplan is also great for setting up complex P&L views. For example, setting up a P&L with a combination of subs/depts., that still needs to consolidate to the total P&L.
  • Systems-wise, I like that it's impossible to #REF the model! Anaplan shows you where everything is referenced, so it's very difficult to break anything.
  • I also like that formulas copy across, so there is no chance of pointing to the wrong cell, like in Excel
Dan Shuwarger 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

Anaplan

  • Performance - in the case of complex business cases, the size of Anaplan is increasing drastically, and even a simple click would take more than it should.
  • UI - The User interface needs to be improved: group/expand hierarchy, "Ctrl " + select option to allow multi selection, Content page clean up, easier "Drag & drop" when customizing or building exports.
  • Review & enhance the type of security user roles.
Szilvia Havasreti profile photo

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

Anaplan

Anaplan 8.2
Based on 3 answers
I don't think we could function without the collaboration capabilities built into Anaplan that replaced disparate Excel files in the workforce planning model
Joe Bradbury 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

Anaplan

Anaplan 8.2
Based on 2 answers
There is a dependency in this rating - in that I find Anaplan extremely easy to use, but I've spent the necessary time developing a strong understanding of the platform. Once you understand how to use it, the platform is flexible, easy to use, and fun to use.
Chris Friederich profile photo

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

Reliability and Availability

Anaplan

Anaplan 10.0
Based on 1 answer
In nearly 3 years, I have only had 1 issue of being unable to access my model for an unplanned maintenance. Even planned maintenance windows are handled during low traffic hours on the weekend.
Joe Bradbury profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Performance

Anaplan

Anaplan 9.0
Based on 1 answer
Everything is calculated in memory in the cloud. It's nearly instantaneous updates when you make changes. The only time things get a little slow is when you have a massive model with very intricate calculations...but "slow" for Anaplan is not what I would call "slow" for something like Hyperion. We used to have Hyperion calcs that ran for 60 mins before you could use data. The equivalent would be 60 seconds in Anaplan.
Joe Bradbury profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Support

Anaplan

Anaplan 8.1
Based on 2 answers
I feel like the support team is a little lacking in product knowledge. Several times I have contacted them to get help, and ended up finding a solution to my own problem before the team could get back to me with anything useful. I have also submitted a few bugs, and never got updates to when they were fixed in later releases.
Joe Bradbury profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

In-Person Training

Anaplan

Anaplan 3.0
Based on 1 answer
The in-person training is simply not worth the cost. After a few weeks of playing in Anaplan, I went to the basic training and knew more than the person teaching it. a year down the road, I was the first person to complete the advance training, and again could have been teaching the class better than the person running the session. Spend some time on your own trying out different things and you will get all the understanding you need to be successful.
Joe Bradbury profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Online Training

Anaplan

Anaplan 5.0
Based on 1 answer
I'm giving this a 5 simply for the anapedia outline of calculations. The online videos and trainings leave a lot to be desired, but having anapedia around to help you understand calculations has been helpful. The drawback to anapedia is the depth they go into for calculations, it is lackluster at times. Because of that, I have been working through a much more in-depth look at each calculation on my website for users to reference: http://www.anaplanguru.com/formulas/
Joe Bradbury profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Implementation

Anaplan

Anaplan 6.7
Based on 12 answers
Agile methodology and breaking the work down into sprints was very helpful. Implementation required a deeper dive into our data than expected for the consultants to be able to construct the data model. But once it was in place, the focus on knowledge transfer enabled us to be able to use the product effectively after the team rolled off.
Steve Ridgley profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Alternatives Considered

Anaplan

Anaplan was an easy choice because two other divisions in our company used it in limited ways - either only sales ops or financial reporting. In addition, it was the hands down best choice given the complexity and size of our organization. We operate in a highly matrixed organization across the globe therefore, we needed a powerful and flexible platform; not all options allowed for this flexibility nor were they suited for large multi-national companies.
Tara Kirby 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

Scalability

Anaplan

Anaplan 7.0
Based on 1 answer
It's going to handle most of what you can throw at it. The problem lies in the sparsity of some datasets. When you have over 5ish dimensions of sparse data, the size of the model gets bloated for not much value. In several cases, I have had to adapt my model to account for sparsity in a way that minimized use of space, but also made interacting with the data more cumbersome.
Joe Bradbury profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Return on Investment

Anaplan

  • I'm sure the impact is positive. We have streamlined many processes and created capacity for our finance team.
  • It's great to have "one source of truth" and know that everyone is looking at the same metrics.
Kelley Haghighi profile photo

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

Anaplan

General

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

Microsoft Power BI

General

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

Rating Summary

Likelihood to Recommend

Anaplan
7.6
Microsoft Power BI
8.5

Likelihood to Renew

Anaplan
8.2
Microsoft Power BI
10.0

Usability

Anaplan
8.2
Microsoft Power BI
9.0

Reliability and Availability

Anaplan
10.0
Microsoft Power BI

Performance

Anaplan
9.0
Microsoft Power BI

Support

Anaplan
8.1
Microsoft Power BI

In-Person Training

Anaplan
3.0
Microsoft Power BI

Online Training

Anaplan
5.0
Microsoft Power BI

Implementation

Anaplan
6.7
Microsoft Power BI

Scalability

Anaplan
7.0
Microsoft Power BI

Add comparison