What users are saying about
Top Rated
207 Ratings

Microsoft BI

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

We are really excited and looking forward to exploring the forecasting, and "What If" scenarios. Our current business structure makes it very difficult to forecast and project at any level, and I think Anaplan will be a great solution for us.I think for any business that has multiple, or dynamic, hierarchies Anaplan is a great solution. We have reduced the time spent on these dynamic views by using subsets and properties with in the models.I am looking forward to the increased the communication/connected planning aspect that Anaplan brings to our company. In the past we had thousands of Excel workbooks, some that were too large to email or open. We have seen improved interaction and clear lines of communication for our end users by using Anaplan for our budget process.
Matthew Cantwell 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.5
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.7
Microsoft BI

Consolidation and Close

Anaplan
6.5
Microsoft BI
Financial data consolidation
Anaplan
7.7
Microsoft BI
Journal entries and reports
Anaplan
6.5
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.2
Microsoft BI
Detailed Audit Trails
Anaplan
6.0
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.3
Microsoft BI

Analytics

Anaplan
6.7
Microsoft BI
Personalized dashboards
Anaplan
5.5
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.5
Microsoft BI
Benchmarking with external data
Anaplan
7.1
Microsoft BI

Integration

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

BI Standard Reporting

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

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

Report Output and Scheduling

Anaplan
Microsoft BI
8.2
Publish to Web
Anaplan
Microsoft BI
8.3
Publish to PDF
Anaplan
Microsoft BI
8.8
Report Versioning
Anaplan
Microsoft BI
8.2
Report Delivery Scheduling
Anaplan
Microsoft BI
7.6
Delivery to Remote Servers
Anaplan
Microsoft BI
8.2

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

Anaplan
Microsoft BI
8.3
Responsive Design for Web Access
Anaplan
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

Application Program Interfaces (APIs) / Embedding

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

Pros

  • Anaplan is great at organizing data. You can have one module for importing and then other modules that feed from there. It acts as a one stop shop for data that comes from several different SQL tables. Plus the pivot function is so easy to use.
  • Anaplan is money when it comes to modeling. You can test scenarios with different subsets changing one data point which will flow through all modules and particular versions that you need it to.
  • I am able to keep a very detailed and constantly updated hierarchy in Anaplan. From there I can branch off subsets that I need to test, such as bottom stores, merged stores, closing stores....thus I can extrapolate or dismiss certain groups. I also love Selective Access. Operators can see their group only and efficiently make changes to the forecast where they see fit.
David Cintron profile photo
  • 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

  • Some functions I occasionally used in Excel are not yet available in Anaplan - SUBTOTAL and CODE primarily. Also the ability to highlight multiple adjacent cells and instantly see a sum, count or average.
  • We are on a prior pricing model with Anaplan and it makes it difficult to expand the use cases. I believe this is resolved in the new pricing model. Also, depending on the pricing, small tasks/projects may not be cost effective to move out of Excel and into Anaplan if the users are numerous and not already in Anaplan.
  • Extracting data out of Anaplan is not always straightforward. It is terrific for a user who has access to Anaplan but if a user wants to pull data out for another purpose or to share with non users it is limited. There are links to XLS and PPT but those only go so far.
Brent Orr profile photo
  • More than two dimensions. Yes, I know that 2D is the core of Excel's DNA. However, we're starting to deal with higher-dimensional arrays here in analytics land so better visualization support would be cool.
  • UI weirdness. By default, you are flipping back between regular Excel tabs and super-top-secret BI tabs. You create charts in one place, but look at them in the other. That kind of stuff. I know there are a couple of other ways to interact with Microsoft BI, but please figure out the main way.
  • Better hookups to other analytics tools including Microsoft's. Microsoft BI has a good variety of data connections, and I don't expect it to bloom into a full-fledged analytics tool, but it may be a good idea to keep hammering at connectivity with "hardcore" analytics. In my case, Python stuff.
Alexander Lubyansky profile photo

Likelihood to Renew

Anaplan8.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 BI8.0
Based on 25 answers
I will renew because the pain to change, rip out and buy new is simply too much to live through. I am under the assumption that this is still 1.0. Microsoft will better my concerns and I still see them adding features from time to time. They have released new versions of the Power Query, and the Gateway over the past couple of months. They have single evenhandedly turned Excel from the preferred tool of presentation to making Excel Middle ware. Middle Ware? Don't hang up and close the browser yet. Yup, its middle ware. Excel connects to the data, SQL database or the data model, Excel is the tool that passes the information to the real presentation layer. Excel is just a middleware tool that has become more powerful than ever and the platform that Microsoft BI resides upon. While my review may seem at times critical its the familiarity of the tools (Excel), ease of use, and price that make Microsoft BI the recommended tool for the small to medium size company looking for BI
Sean Warren 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
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman profile photo

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

Alternatives Considered

Modeling and what I call the "brains" is much better in Anaplan. You can create several different model types that can all feed into a single budget or plan.What Anaplan really lacks is the ad-hoc ability that is in Hyperion. You can't identify your dimensions and find the data sitting in that spot, the data just isn't setup that way in Anaplan. This makes answering some detail questions more difficult than it would be in Hyperion. for that reason, we are using Anaplan for the modeling, and Hyperion for the data storage. It would be nice to be able to sunset Hyperion though....
Joe Bradbury profile photo
Looking at the visualization portion of BI, there are three types of tools.
  1. Programming packages. Free and powerful, they let you make any diagram, at the cost of difficulty of use.
  2. Specialist software like Tableau and Microsoft BI. This is the best choice in most cases due to ease of use and quality of output.
  3. More generic software offered by the big IT companies, often part of a BI suite. There's really a lot of variety here. Use this when it fits the workflow and you are already using the relevant software. But, personally, I'd still use the specialist software.
Alexander Lubyansky profile photo

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
  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
No photo available

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