Anaplan vs. Microsoft BI (MSBI)

I've implemented a number of projects for Anaplan for Sales Performance Management use cases. It is obviously built for financial planning, but it allows for a lot of flexibility for territory and quota, ICM, sales forecasting, and other important use cases. Territory and Quota is very powerful in the tool as it organize complex assignment structures into hierarchies for easier analysis and reporting.

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.

• Anaplan removes the time consuming process of integrating the results of individual spreadsheets.
• Anaplan facilitates the standardization of assumptions across all sub-processes
• Anaplan provides full transparency of the calculations and source inputs
• Anaplan allows us to automate certain planning processes that would have been impossible when relying on the computational capabilities of an individual computer.

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

Incentivized

• Some end users don't spend the required amount of time to familiar themselves with Anaplan.
• Auditability, while good in theory, can be lacking and clunky when needed.
• Model building can become convoluted over time, leading to confusion over the specific use of line items.

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

Incentivized

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

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.

As a user it is a very simple tool, but at the same time with a very mature and powerful calculation engine. It is very easy to switch from excel or traditional tools with added capabilities of multi dimensionality and real time calculation engine to see quick insights needed to create plans and scenarios

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.

Incentivized

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

The product has been reliable.

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.

Incentivized

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.

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.

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.

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.

This training was more directed toward what the product was capable of rather than actual programming.

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

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.

One key insight from implementing Anaplan is that success comes from focusing on designing the process, not just building the model. Anaplan is extremely flexible—there are very few planning scenarios it cannot support—but that flexibility means the project needs strong governance, clear ownership of requirements, and a well-defined data model. When those foundations are in place, implementations are fast, iterations are easy, and users can quickly see value.
In our projects, both Financial Planning and Integrated Business Planning models were adopted smoothly because we involved business users early, kept the model design intuitive, and leveraged Anaplan’s Excel-like syntax and user-friendly dashboards. The result was more efficient day-to-day work, reduced manual tasks, and increased collaboration across teams. In short: when you combine Anaplan’s flexibility with a structured implementation approach, adoption and value realization happen quickly.

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.

Anaplan is more powerful than Pigment considering that it is an Enterprise class system and is able to manage bigger data sets. Anaplan allows for advanced scenario modeling and formula capabilities along with custom reporting functionalities. Anaplan has proven its capabilities and stability across various use cases and across bigger enterprises when compared to Pigment which is still in earlier phases of its development

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.

Incentivized

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

• Anaplan's implementation led to a significant reduction in planning cycle errors and bugs, streamlining processes and improving overall accuracy in data inputs
• Standardizing the planning process and enabling cross-functional collaboration through Anaplan enhanced our ability to adapt swiftly to changing business needs, resulting in improved agility in decision-making
• The platform's capabilities, especially in Demand Planning and Supply Chain, positively impacted our ROI by optimizing resource allocation and solving complex business problems efficiently across multiple functions

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

Incentivized