Anaplan vs. Microsoft BI (MSBI)

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Anaplan
Score 8.7 out of 10
Enterprise companies (1,001+ employees)
Anaplan is a scenario planning and analysis platform designed to optimize decision-making in complex business environments so that enterprises can outpace their competition and the market. By building connections and collaboration across organizational silos, the Anaplan platform surfaces key insights.N/A
Microsoft BI (MSBI)
Score 8.5 out of 10
N/A
Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$9.99
per user/per month
Pricing
AnaplanMicrosoft BI (MSBI)
Editions & Modules
No answers on this topic
Power BI Pro
$9.99
per user/per month
Power BI Premium
4,995
per month
Offerings
Pricing Offerings
AnaplanMicrosoft BI (MSBI)
Free Trial
NoNo
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
Additional Details
More Pricing Information
Features
AnaplanMicrosoft BI (MSBI)
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Anaplan
7.6
214 Ratings
3% below category average
Microsoft BI (MSBI)
8.7
48 Ratings
7% above category average
Pixel Perfect reports6.57 Ratings9.041 Ratings
Customizable dashboards8.5214 Ratings8.048 Ratings
Report Formatting Templates7.96 Ratings9.046 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Anaplan
9.1
8 Ratings
10% above category average
Microsoft BI (MSBI)
8.7
48 Ratings
8% above category average
Drill-down analysis9.18 Ratings9.043 Ratings
Formatting capabilities9.18 Ratings8.048 Ratings
Report sharing and collaboration9.18 Ratings9.048 Ratings
Integration with R or other statistical packages00 Ratings9.038 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Anaplan
8.5
221 Ratings
3% above category average
Microsoft BI (MSBI)
9.0
47 Ratings
8% above category average
Publish to Web8.67 Ratings9.043 Ratings
Publish to PDF8.4219 Ratings9.043 Ratings
Report Versioning9.2192 Ratings9.039 Ratings
Report Delivery Scheduling7.98 Ratings9.042 Ratings
Delivery to Remote Servers00 Ratings9.023 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Anaplan
8.1
8 Ratings
6% above category average
Microsoft BI (MSBI)
9.0
47 Ratings
13% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)9.07 Ratings9.046 Ratings
Location Analytics / Geographic Visualization9.07 Ratings9.043 Ratings
Predictive Analytics6.43 Ratings9.041 Ratings
Pattern Recognition and Data Mining00 Ratings9.01 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Anaplan
9.3
224 Ratings
7% above category average
Microsoft BI (MSBI)
9.0
48 Ratings
6% above category average
Multi-User Support (named login)9.18 Ratings9.045 Ratings
Role-Based Security Model9.6224 Ratings9.042 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.18 Ratings9.045 Ratings
Report-Level Access Control9.673 Ratings9.01 Ratings
Single Sign-On (SSO)9.18 Ratings9.027 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Anaplan
7.7
213 Ratings
1% below category average
Microsoft BI (MSBI)
8.5
38 Ratings
8% above category average
Responsive Design for Web Access8.4204 Ratings8.035 Ratings
Mobile Application7.7190 Ratings8.026 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.0198 Ratings10.035 Ratings
Budgeting, Planning, and Forecasting
Comparison of Budgeting, Planning, and Forecasting features of Product A and Product B
Anaplan
9.0
322 Ratings
8% above category average
Microsoft BI (MSBI)
-
Ratings
Long-term financial planning9.3297 Ratings00 Ratings
Financial budgeting9.4301 Ratings00 Ratings
Forecasting9.3310 Ratings00 Ratings
Scenario modeling9.2312 Ratings00 Ratings
Management reporting8.0311 Ratings00 Ratings
Consolidation and Close
Comparison of Consolidation and Close features of Product A and Product B
Anaplan
7.8
275 Ratings
2% below category average
Microsoft BI (MSBI)
-
Ratings
Financial data consolidation8.3255 Ratings00 Ratings
Journal entries and reports7.5211 Ratings00 Ratings
Multi-currency management7.312 Ratings00 Ratings
Intercompany Eliminations7.39 Ratings00 Ratings
Minority Ownership7.38 Ratings00 Ratings
Local and consolidated reporting8.3244 Ratings00 Ratings
Detailed Audit Trails8.5256 Ratings00 Ratings
Financial Reporting and Compliance
Comparison of Financial Reporting and Compliance features of Product A and Product B
Anaplan
8.1
293 Ratings
0% below category average
Microsoft BI (MSBI)
-
Ratings
Financial Statement Reporting8.9271 Ratings00 Ratings
Management Reporting8.2284 Ratings00 Ratings
Excel-based Reporting7.8262 Ratings00 Ratings
Automated board and financial reporting8.214 Ratings00 Ratings
XBRL support for regulatory filing7.31 Ratings00 Ratings
Analytics and Reporting
Comparison of Analytics and Reporting features of Product A and Product B
Anaplan
9.1
313 Ratings
12% above category average
Microsoft BI (MSBI)
-
Ratings
Personalized dashboards8.7307 Ratings00 Ratings
Color-coded scorecards9.3291 Ratings00 Ratings
KPIs9.120 Ratings00 Ratings
Cost and profitability analysis9.3270 Ratings00 Ratings
Key Performance Indicator setting9.4281 Ratings00 Ratings
Benchmarking with external data9.114 Ratings00 Ratings
Integration
Comparison of Integration features of Product A and Product B
Anaplan
8.5
319 Ratings
2% above category average
Microsoft BI (MSBI)
-
Ratings
Flat file integration9.3309 Ratings00 Ratings
Excel data integration8.2287 Ratings00 Ratings
Direct links to 3rd-party data sources8.0269 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Anaplan
-
Ratings
Microsoft BI (MSBI)
8.8
20 Ratings
12% above category average
REST API00 Ratings9.018 Ratings
Javascript API00 Ratings9.018 Ratings
iFrames00 Ratings9.017 Ratings
Java API00 Ratings9.016 Ratings
Themeable User Interface (UI)00 Ratings9.017 Ratings
Customizable Platform (Open Source)00 Ratings8.016 Ratings
Best Alternatives
AnaplanMicrosoft BI (MSBI)
Small Businesses
IBM Planning Analytics
IBM Planning Analytics
Score 8.2 out of 10
BrightGauge
BrightGauge
Score 8.9 out of 10
Medium-sized Companies
Centage
Centage
Score 9.5 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Prophix
Prophix
Score 9.0 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AnaplanMicrosoft BI (MSBI)
Likelihood to Recommend
9.0
(336 ratings)
9.0
(72 ratings)
Likelihood to Renew
9.9
(35 ratings)
8.0
(25 ratings)
Usability
8.9
(63 ratings)
8.9
(14 ratings)
Availability
8.7
(7 ratings)
9.5
(2 ratings)
Performance
9.0
(7 ratings)
7.0
(2 ratings)
Support Rating
5.5
(27 ratings)
8.9
(15 ratings)
In-Person Training
8.9
(6 ratings)
6.9
(3 ratings)
Online Training
8.0
(6 ratings)
8.5
(2 ratings)
Implementation Rating
9.0
(27 ratings)
9.6
(7 ratings)
Configurability
9.1
(5 ratings)
10.0
(2 ratings)
Ease of integration
9.1
(3 ratings)
-
(0 ratings)
Product Scalability
9.4
(7 ratings)
-
(0 ratings)
Professional Services
9.1
(1 ratings)
-
(0 ratings)
Vendor post-sale
8.3
(4 ratings)
-
(0 ratings)
Vendor pre-sale
7.1
(4 ratings)
-
(0 ratings)
User Testimonials
AnaplanMicrosoft BI (MSBI)
Likelihood to Recommend
Anaplan
Anaplan is a great tool for complex modeling of the future. When you are planning your actions for the future, have multiple, disparate datasets to interact with, have dozens if not hundreds of stakeholders who must contribute and need to be guided via a streamlined workflow engine, require complex logic that can grow with your org, require real-time reporting, and you need it all in less than 6 months.
Read full review
Microsoft
Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
Read full review
Pros
Anaplan
  • Anaplan can scale as your business grows, for example adding new regions into to your geographical hierarchy.
  • Anaplan is flexible and can do anything you want it to, there are no tables pre-configured that you need to fix your business process into.
  • Reading formulas in Anaplan is straight forward with a quick learning curve.
Read full review
Microsoft
  • Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
  • Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
  • Transfer of data from one application to another via Excel and comparison of data attributes between applications
  • Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.
Read full review
Cons
Anaplan
  • Ability to decide if to apply the formula or a manual input on front end for each line item
  • Real Time Data Transfer across models. Currently Data is transferred using Processes across different models. Having a functionality to access data from any model in real time would be great
Read full review
Microsoft
  • The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
  • Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
  • Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.
Read full review
Likelihood to Renew
Anaplan
Anaplan is a very strong multi-dimensional modeling tool that provides a calculation engine to empower a complex planning process. It is fairly easy to learn for those with experience in similar tools, or excel. It forces structure and auditability that spread sheets do not have, along with extensive security capabilities
Read full review
Microsoft
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.
Read full review
Usability
Anaplan
Anaplan's usability is very good. Users can customize reports and make adjustments with very little training. They can quickly plan and collaborate very easily. Making large adjustments or creating complex functionality may require more experience or training but a lot of tasks can be completed by users with very little experience
Read full review
Microsoft
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
Read full review
Reliability and Availability
Anaplan
There are very few outages. Maintenance is scheduled on two or three Saturdays per month, so as not to affect businesses. When there is an outage, users are kept informed of progress to restore the platform and typically this takes no more than an hour. Anaplan customer support is very responsive if we ever have questions about platform issues
Read full review
Microsoft
The product has been reliable.
Read full review
Performance
Anaplan
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.
Read full review
Microsoft
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.
Read full review
Support Rating
Anaplan
Support quality has dropped since Thoma Bravo has taken over. I think some serious re-focus needs to happen here -- part of the beauty of being in the Anaplan community was how involved you felt in it before. Before I didn't dread sending a support ticket, now I am starting to.
Read full review
Microsoft
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Read full review
In-Person Training
Anaplan
In my opinion, in-person training is always the best if you have the option to do so. This allows real-time interactions with the instructions, whereas the online training I took required me to write-down questions, email them, and wait for responses. This slows down the process, as you can imagine. That said, in-person training is an extra cost and it likely isn't needed for everyone. I would suggest selecting a small number of people to take in-person training and then having them act as mentors to the rest of your team. That way, as the rest of the team takes the online training, they have a resource to help them in real time.
Read full review
Microsoft
This training was more directed toward what the product was capable of rather than actual programming.
Read full review
Online Training
Anaplan
Anaplan training materials are clear, simple, easy to understand and to follow. Visuals are excellent. The vendor is good at updating training materials in a timely manner and encouraging users and administrators to keep coming back to Academy site for refresher courses or new feature courses. I really like their interactive diagrams
Read full review
Microsoft
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.
Read full review
Implementation Rating
Anaplan
The platform allows a flexible implementation mechanic to be put in place, since the possibilities and functionalities are vast and there are very few things the tool cannot do well. The solutions for the financial planning and the integrated business planning we put in place were easily adopted by the end users and their day-to-day work was made easier.
Read full review
Microsoft
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
Read full review
Alternatives Considered
Anaplan
Compared to OneStream and Venna Anaplan offers a more modern look and feel of the platform. It is better situated and maintained in regards of platform updates as it's a full SaaS software there are never any issues with the system version as it's always automatically up to date with no backward compatibility issues. Due to the flexible nature of the modelling engine, it is also better suited to perform larger multi-department use cases, like IBP (Integrated Business Planning)
Read full review
Microsoft
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
Read full review
Scalability
Anaplan
We have managed to leverage Anaplan for financial planning and forecasting across the business. It is now used by almost every department, with more than 50 users (but I know of companies that have hundreds of users) and still the platform is quick and reliable. It is easy to make changes to divisions and departments or add users and apply different user settings - the core part of the model is not affected and end users can continue their work without any disruption
Read full review
Microsoft
No answers on this topic
Return on Investment
Anaplan
  • We've typically seen an average of 40% removal of time from processes using Anaplan an enabler
  • Though difficult to quantify, we consistently find our processes less error prone than in the past. Essentially, we've removed a previously "hidden cost" of risk due to poor data quality that was buried in our processes.
Read full review
Microsoft
  • As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
  • However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
Read full review
ScreenShots

Anaplan Screenshots

Screenshot of Platform: The Anaplan platform is a unified cloud-based solution that connects people, data and plans to enable complex scenario modeling.Screenshot of OpEx Planning. This is where users review revenue-target-setting goals by brand, season, and capacity all on a visual dashboard.Screenshot of Supply Planning. This visualization breaks down costs across assembly production to project profitability and align an organization's supply chain to market opportunities.Screenshot of Territory and Quota Planning. This dashboard is used to track of sales goals and quotas across territories and industries to optimize sales performance.Screenshot of Headcount Planning. Here, users can align workforce plans with strategic plans, and see where the best qualified talent resides to fit an organization’s staffing needs.Screenshot of Marketing. This interface drives efficiency across planning, and is used to budget against planned activity.