What users are saying about

Anaplan

Top Rated
205 Ratings

Microsoft BI

602 Ratings

Anaplan

Top Rated
205 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 BI

602 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Anaplan

It's great for complex models that require frequent updates and instant feedback. That describes most planning situations I know of. It's great for organizations that want to change plans and models independent of IT support or programming. It's not a great reporting or analytics tool. Ad-hoc analysis is a non-starter in the platform--you have to be a model builder and the process of generating a report is very cumbersome compared with something like Tableau.
Christopher Pope 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

Budgeting, Planning, and Forecasting

Anaplan
7.4
Microsoft BI
Long-term financial planning
Anaplan
7.4
Microsoft BI
Financial budgeting
Anaplan
8.1
Microsoft BI
Forecasting
Anaplan
7.7
Microsoft BI
Scenario modeling
Anaplan
6.5
Microsoft BI
Management reporting
Anaplan
7.6
Microsoft BI

Consolidation and Close

Anaplan
6.5
Microsoft BI
Financial data consolidation
Anaplan
7.7
Microsoft BI
Journal entries and reports
Anaplan
6.6
Microsoft BI
Multi-currency management
Anaplan
6.2
Microsoft BI
Intercompany Eliminations
Anaplan
5.9
Microsoft BI
Minority Ownership
Anaplan
6.0
Microsoft BI
Local and consolidated reporting
Anaplan
7.1
Microsoft BI
Detailed Audit Trails
Anaplan
6.1
Microsoft BI

FInancial Reporting and Compliance

Anaplan
7.6
Microsoft BI
Financial Statement Reporting
Anaplan
7.0
Microsoft BI
Management Reporting
Anaplan
8.3
Microsoft BI
Excel-based Reporting
Anaplan
6.9
Microsoft BI
Automated board and financial reporting
Anaplan
8.0
Microsoft BI

Analytics

Anaplan
6.7
Microsoft BI
Personalized dashboards
Anaplan
5.3
Microsoft BI
Color-coded scorecards
Anaplan
6.0
Microsoft BI
KPIs
Anaplan
7.0
Microsoft BI
Cost and profitability analysis
Anaplan
7.0
Microsoft BI
Key Performance Indicator setting
Anaplan
7.4
Microsoft BI
Benchmarking with external data
Anaplan
7.2
Microsoft BI

Integration

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

BI Standard Reporting

Anaplan
Microsoft BI
7.8
Pixel Perfect reports
Anaplan
Microsoft BI
7.6
Customizable dashboards
Anaplan
Microsoft BI
7.9
Report Formatting Templates
Anaplan
Microsoft BI
7.8

Ad-hoc Reporting

Anaplan
Microsoft BI
8.5
Drill-down analysis
Anaplan
Microsoft BI
8.4
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.8

Report Output and Scheduling

Anaplan
Microsoft BI
8.4
Publish to Web
Anaplan
Microsoft BI
8.5
Publish to PDF
Anaplan
Microsoft BI
8.6
Report Versioning
Anaplan
Microsoft BI
8.7
Report Delivery Scheduling
Anaplan
Microsoft BI
7.9
Delivery to Remote Servers
Anaplan
Microsoft BI
8.1

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

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

Pros

  • Simultaneous data editing by several departments.
  • Large data calculation.
  • Agile access anywhere if you have Internet access.
Максим Шилиманов profile photo
  • Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
  • Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
  • Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
  • Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.
Haibo Yang profile photo

Cons

  • Difficulty training up users
  • Hierarchy of units that are used cross functionally that aren't easily translated between orgs
  • Ability to call back parts of models previously built up
  • Elegance in design can be make or break between cost accretion and dilution
  • Inconsistency of quality of consultants
Sharon Kam profile photo
  • Visualization and presentation is an area that may need some improvement. I have used a competitive tool Tableau which has better visualization capabilities against Pivot Charts/Power BI.
  • For ultra large organizations, certain BI solutions require more volume of data to be processed. Although Microsoft Windows Azure, HDInsight and various other big data mechanism can cater to this need, other MS BI tools like Power Pivot, SharePoint etc... need to be more performance oriented.
  • Licensing is one aspect which is relatively more complex as compared to its competitors. Microsoft is now following subscription-model approach in a lot of areas but still there is a scope of improvement in providing more clarity and simplicity when purchasing MS BI tools.
Ved Mishra profile photo

Likelihood to Renew

Anaplan8.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 BI8.0
Based on 25 answers
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
Lee Cullom profile photo

Usability

Anaplan8.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 BI7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available

Reliability and Availability

Anaplan10.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 BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

Anaplan9.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 BI7.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

Anaplan8.0
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 BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

Anaplan3.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 BI6.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

Anaplan5.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 BI8.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

Anaplan6.8
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 BI9.6
Based on 7 answers
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo

Breadth of Deployment

No answers on this topic
It was the main reporting tool used by all the different departments. It was used by the Executive level, operations, marketing, sales. Number of users were probably around 50. Types of users: VP's, Directors, Managers, Analysts.
Mashhood Syed profile photo

Alternatives Considered

Anaplan allowed us to manage alternate/substitute parts supply allocation better than any other tool. It was able to [perform] fast calculations in the cloud and did not make things difficult by slowing the process down.
Sid Powar profile photo
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

Lines of Business and Business Impact

Particular impact on my end would be the use of vendor based forecasting. Supporting marketing, my world is consumed by innumerable vendors with many moving parts, often changing commitments, and vendor spend ranging from multi million dollars down to small double digit expenses that all require reconciliation. Having used the vendor expense module for just corporate software as a beta tester has improved the management of these vendors. However, to fully manage such a dynamically fluid department, I would need to further refine this model to be successful
Ramandeep Garcha profile photo
No answers on this topic

Selection Process

Adaptive and Host Analytics
More flexible and able to handle more data.
Tommy Bettles profile photo
No answers on this topic

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Microsoft BI8.1
Based on 29 answers
I wish it was simpler to share a dashboard or embed them outside of BI. Other than that sharing is easy enough with our 365 organization
Micah Jones profile photo

Data Integration

No score
No answers yet
No answers on this topic
Microsoft BI8.6
Based on 28 answers
The software was nice, the problem was price per seat and the slight learning curve. In the end we deemed it best to stick with the more boring simple simple operating look and appeal of Excel and similar more basic Microsoft Applications and Programs, rather than venture into the Microsoft BI system. That is to say it was nice, and very aesthetically pleasing, but ultimately it wasn't for us
No photo available

Scalability

Anaplan7.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
No score
No answers yet
No answers on this topic

Return on Investment

  • 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
  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady 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