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>
677 Ratings
213 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 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 BI

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
Jason Leidig profile photo

Feature Rating Comparison

BI Standard Reporting

Anaplan
7.2
Microsoft BI
8.0
Customizable dashboards
Anaplan
7.2
Microsoft BI
7.9
Pixel Perfect reports
Anaplan
Microsoft BI
7.8
Report Formatting Templates
Anaplan
Microsoft BI
8.2

Report Output and Scheduling

Anaplan
8.0
Microsoft BI
8.2
Publish to PDF
Anaplan
8.3
Microsoft BI
8.8
Report Versioning
Anaplan
8.3
Microsoft BI
8.1
Report Delivery Scheduling
Anaplan
7.3
Microsoft BI
7.5
Publish to Web
Anaplan
Microsoft BI
8.3
Delivery to Remote Servers
Anaplan
Microsoft BI
8.2

Mobile Capabilities

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

Budgeting, Planning, and Forecasting

Anaplan
8.4
Microsoft BI
Long-term financial planning
Anaplan
7.8
Microsoft BI
Financial budgeting
Anaplan
8.7
Microsoft BI
Forecasting
Anaplan
8.8
Microsoft BI
Scenario modeling
Anaplan
8.3
Microsoft BI
Management reporting
Anaplan
8.3
Microsoft BI

Consolidation and Close

Anaplan
7.1
Microsoft BI
Financial data consolidation
Anaplan
8.6
Microsoft BI
Journal entries and reports
Anaplan
7.3
Microsoft BI
Multi-currency management
Anaplan
6.2
Microsoft BI
Intercompany Eliminations
Anaplan
6.0
Microsoft BI
Minority Ownership
Anaplan
6.0
Microsoft BI
Local and consolidated reporting
Anaplan
8.1
Microsoft BI
Detailed Audit Trails
Anaplan
7.6
Microsoft BI

FInancial Reporting and Compliance

Anaplan
8.0
Microsoft BI
Financial Statement Reporting
Anaplan
9.2
Microsoft BI
Management Reporting
Anaplan
8.8
Microsoft BI
Excel-based Reporting
Anaplan
5.3
Microsoft BI
Automated board and financial reporting
Anaplan
8.6
Microsoft BI

Analytics

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

Integration

Anaplan
8.3
Microsoft BI
Flat file integration
Anaplan
8.8
Microsoft BI
Excel data integration
Anaplan
7.5
Microsoft BI
Direct links to 3rd-party data sources
Anaplan
8.7
Microsoft BI

Ad-hoc Reporting

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

Data Discovery and Visualization

Anaplan
Microsoft BI
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Anaplan
Microsoft BI
8.4
Location Analytics / Geographic Visualization
Anaplan
Microsoft BI
7.9
Predictive Analytics
Anaplan
Microsoft BI
8.1

Access Control and Security

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

Application Program Interfaces (APIs) / Embedding

Anaplan
Microsoft BI
7.8
REST API
Anaplan
Microsoft BI
7.9
Javascript API
Anaplan
Microsoft BI
8.3
iFrames
Anaplan
Microsoft BI
7.7
Java API
Anaplan
Microsoft BI
7.6
Themeable User Interface (UI)
Anaplan
Microsoft BI
7.8
Customizable Platform (Open Source)
Anaplan
Microsoft BI
7.5

Pros

Anaplan

  • Real - time - the cloud based technology allows all changes & its impact is visible in real time.
Szilvia Havasreti profile photo

Microsoft BI

  • The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI.
  • I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training.
  • I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to.
  • Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so.
  • Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI.
  • Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free.
  • Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.
Jason Leidig profile photo

Cons

Anaplan

  • I believe user set up within Anaplan is one of the areas that could be improved greatly.
  • Workflow is another area that I believe could be improved. Currently, I do not believe, there is a way to create an action against workflow. This would be a great benefit rather than moving the item to complete or in progress if you could write an action for it.
Matthew Cantwell profile photo

Microsoft BI

  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

Anaplan

Anaplan 8.2
Based on 3 answers
We rely on it heavily. The only way we wouldn't renew is if the price got significantly higher.
Maggie Palumbo profile photo

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
Assuming that I will continue to have a need to monitor and report on the operational aspects of the organization using transactional data, Microsoft BI is a solid choice. Its kind of like how you still have legacy applications that serve a strong need that is critical to the day to day operations. The fact that the tools are similar to stuff the users have already been using makes the adoption and buy in that much easier.
Mashhood Syed 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 BI

Microsoft BI 7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky 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 BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

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 BI

Microsoft BI 7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

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 BI

Microsoft BI 7.1
Based on 6 answers
Microsoft support in general is good, did not have any issues.
Boris Skylar profile photo

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 BI

Microsoft BI 6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

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 BI

Microsoft BI 8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

Anaplan

Anaplan 6.7
Based on 12 answers
I won't rate this low due to the 3rd party consultant, because overall the implementation with Anaplan went great. We had working models in our first month of having Anaplan, and have been able to branch out into multiple facets of the business in the 3 years since our first implementation.
Joe Bradbury profile photo

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Alternatives Considered

Anaplan

In my opinion, Anaplan is on a completely different level than any other CPM system. In looking at other systems, the ability to model doesn't even come close to what Anaplan can do. Reporting and BI is made better through synchronization. There is just really no comparison. If you want to have your planning really connected to your actual business, then Anaplan is the only way to go.
Chris Friederich profile photo

Microsoft BI

Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady 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 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 BI

  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo

Pricing Details

Anaplan

General

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

Anaplan Editions & Modules

Anaplan
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 BI

General

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

Microsoft BI Editions & Modules

Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details

Add comparison