Anaplan vs. Amazon Redshift

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.

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)

Incentivized

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

• [Amazon] Redshift has Distribution Keys. If you correctly define them on your tables, it improves Query performance. For instance, we can define Mapping/Meta-data tables with Distribution-All Key, so that it gets replicated across all the nodes, for fast joins and fast query results.
• [Amazon] Redshift has Sort Keys. If you correctly define them on your tables along with above Distribution Keys, it further improves your Query performance. It also has Composite Sort Keys and Interleaved Sort Keys, to support various use cases
• [Amazon] Redshift is forked out of PostgreSQL DB, and then AWS added "MPP" (Massively Parallel Processing) and "Column Oriented" concepts to it, to make it a powerful data store.
• [Amazon] Redshift has "Analyze" operation that could be performed on tables, which will update the stats of the table in leader node. This is sort of a ledger about which data is stored in which node and which partition with in a node. Up to date stats improves Query performance.

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.

• We've experienced some problems with hanging queries on Redshift Spectrum/external tables. We've had to roll back to and old version of Redshift while we wait for AWS to provide a patch.
• Redshift's dialect is most similar to that of PostgreSQL 8. It lacks many modern features and data types.
• Constraints are not enforced. We must rely on other means to verify the integrity of transformed tables.

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

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

Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.

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

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

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.

The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support

Incentivized

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.

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

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.

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

Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).
Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.
Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.

Incentivized

Redshift is relatively cheaper tool but since the pricing is dynamic, there is always a risk of exceeding the cost. Since most of our team is using it as self serve and there is no continuous tracking by a dedicated team, it really needs time & effort on analyst's side to know how much it is going to cost.

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

• Our company is moving to the AWS infrastructure, and in this context moving the warehouse environments to Redshift sounds logical regardless of the cost.
• Development organizations have to operate in the Dev/Ops mode where they build and support their apps at the same time.
• Hard to estimate the overall ROI of moving to Redshift from my position. However, running Redshift seems to be inexpensive compared to all the licensing and hardware costs we had on our RDBMS platform before Redshift.

Incentivized