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

Microsoft Power BI

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

Likelihood to Recommend

Anaplan

Sales performance management, various finance scenarios - Anaplan is good for automating calculations. It is less appropriate for very complex business cases.
Szilvia Havasreti profile photo

Microsoft Power BI

Power BI is great for power Excel users and what I call “data archeologists” or people who dig up old data and clean it up for modern usage. It strings many files together and lets you customize the connections and format of the data. It does not work well with large data set or pull data from large databases, you will find it timing out unless you limit the data set first with a SQL View or Tabular Model before going after it. Also, large data sets take forever to refresh and update, so if you have a lot if iterations, you will spend a lot of time going out for coffee while the data reloads. Other BI tools allow you to localize the data with the first load (Qlik QVD’s) so you can refresh quicker. Comparatively, a refresh of SQL data on Power BI took 45 minutes, the exact same data set would refresh in 30 seconds using Qlik Sense.
No photo available

Feature Rating Comparison

BI Standard Reporting

Anaplan
7.2
Microsoft Power BI
8.2
Customizable dashboards
Anaplan
7.2
Microsoft Power BI
8.5
Pixel Perfect reports
Anaplan
Microsoft Power BI
7.9
Report Formatting Templates
Anaplan
Microsoft Power BI
8.1

Report Output and Scheduling

Anaplan
8.0
Microsoft Power BI
8.1
Publish to PDF
Anaplan
8.3
Microsoft Power BI
7.9
Report Versioning
Anaplan
8.3
Microsoft Power BI
8.2
Report Delivery Scheduling
Anaplan
7.3
Microsoft Power BI
8.1
Publish to Web
Anaplan
Microsoft Power BI
8.6
Delivery to Remote Servers
Anaplan
Microsoft Power BI
7.7

Mobile Capabilities

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

Budgeting, Planning, and Forecasting

Anaplan
8.5
Microsoft Power BI
Long-term financial planning
Anaplan
7.8
Microsoft Power BI
Financial budgeting
Anaplan
8.8
Microsoft Power BI
Forecasting
Anaplan
9.0
Microsoft Power BI
Scenario modeling
Anaplan
8.4
Microsoft Power BI
Management reporting
Anaplan
8.4
Microsoft Power BI

Consolidation and Close

Anaplan
7.2
Microsoft Power BI
Financial data consolidation
Anaplan
8.7
Microsoft Power BI
Journal entries and reports
Anaplan
7.5
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.9
Microsoft Power BI

FInancial Reporting and Compliance

Anaplan
8.0
Microsoft Power BI
Financial Statement Reporting
Anaplan
9.3
Microsoft Power BI
Management Reporting
Anaplan
8.8
Microsoft Power BI
Excel-based Reporting
Anaplan
5.2
Microsoft Power BI
Automated board and financial reporting
Anaplan
8.7
Microsoft Power BI

Analytics

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

Integration

Anaplan
8.3
Microsoft Power BI
Flat file integration
Anaplan
8.9
Microsoft Power BI
Excel data integration
Anaplan
7.4
Microsoft Power BI
Direct links to 3rd-party data sources
Anaplan
8.7
Microsoft Power BI

Ad-hoc Reporting

Anaplan
Microsoft Power BI
8.3
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.4
Report sharing and collaboration
Anaplan
Microsoft Power BI
8.3

Data Discovery and Visualization

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

Access Control and Security

Anaplan
Microsoft Power BI
8.2
Multi-User Support (named login)
Anaplan
Microsoft Power BI
8.3
Role-Based Security Model
Anaplan
Microsoft Power BI
7.6
Multiple Access Permission Levels (Create, Read, Delete)
Anaplan
Microsoft Power BI
8.1
Single Sign-On (SSO)
Anaplan
Microsoft Power BI
8.6

Application Program Interfaces (APIs) / Embedding

Anaplan
Microsoft Power BI
7.6
REST API
Anaplan
Microsoft Power BI
7.8
Javascript API
Anaplan
Microsoft Power BI
7.8
iFrames
Anaplan
Microsoft Power BI
7.4
Java API
Anaplan
Microsoft Power BI
7.1
Themeable User Interface (UI)
Anaplan
Microsoft Power BI
7.7
Customizable Platform (Open Source)
Anaplan
Microsoft Power BI
7.6

Pros

Anaplan

  • We really like the Data Hub concept. We are working on multiple projects with regards to aggregating data from multiple sources, and Data Hub has worked well for us thus far.
  • Agility is key for our businesses and we feel that Anaplan gives us the ability to remain flexible and reactive to the changes throughout our businesses.
  • As a administrator I really like the resources provided by Anaplan such as Anapedia. It makes it really simple to ask questions and find answers if we are having difficulty with certain items.
Matthew Cantwell profile photo

Microsoft Power BI

  • Deep Integration with Microsoft Office Suit, Excel, Access, Power Point.
  • API compatible
  • Robust query design from basic to advance consults
Litzi Saraí Gordils Ortuño profile photo

Cons

Anaplan

  • Errors handling. If you make a mistake in formula, the model might freeze for all users for several minutes.
  • Multistage calculations may cause the app to work slowly.
  • Too few functions are yet available. Tons of simple actions are really hard to implement in some cases including PRODUCT, VLOOKUP and CASE SELECT.
  • Bugs that were reported months ago are not fixed.
  • Really poor technical support. There are only 5 or so tech support guys globally and you have to wait for their answer sometimes for too long. Mostly they only give you temporary workarounds because of the bugs that won't be fixed in the nearest future.
  • No Android app.
  • End users have no interface settings at all. Only administrators may save export views and all the useful tune-ups.
  • No friendly interface to edit user rights. When their quantity exceeds 30 or more changing the rights becomes a disaster.
Максим Шилиманов profile photo

Microsoft Power BI

  • UX sometimes can be overwhelming, can be more intuitive
  • Free features always can receive more attention to gain client fidelity
  • Solutions like Power BI can always do better with their Mobile version
Litzi Saraí Gordils Ortuño 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
Implementation using Anaplan's internal customer success team left much to be desired. We've found much better success with outside consultants
Christopher Pope profile photo

Microsoft Power BI

No score
No answers yet
No answers on this topic

Alternatives Considered

Anaplan

Anaplan has a much more powerful modelling engine compared to Adaptive Insights. Adaptive might have prettier dashboards, but their product is inferior at it's core. We were impressed by everything Anaplan could do and are glad that we chose it over the competition. We also are very impressed by Anaplan's customer success team and their knowledge
Jake Cosenza profile photo

Microsoft Power BI

Power BI takes it to another level with the report and dashboard designing for a wide variety of purposes, and always gives you the option to be collaborative within their native sync features, that is also an advantage to set things up, for example, to promote reports into intranets or weekly reports.
Litzi Saraí Gordils Ortuño 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

  • Workforce Planning efficiency - so much easier than excel to maintain sensitive information planning
  • Long range plan lead time - the old excel model took weeks to update. The Anaplan model takes hours
Joe Bradbury profile photo

Microsoft Power BI

  • It's a good start for setting up customized dashboards.
  • Available for all users based on Office 365 platform we have in place.
  • Doesn't really allow depth of report - specifically customization of visual displays.
Mark Metz profile photo

Pricing Details

Anaplan

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
Additional Pricing Details
Request a personal demo: https://www.anaplan.com/request-demo/ Free trial for existing customers for any app in the App Hub: https://apphub.anaplan.com/

Microsoft Power BI

General

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

Add comparison