Which Tool Is Easy To Handle Complex Data?

Any advice for the below query will be highly appreciated.

Would it be easy for someone to learn Anaplan if they have a Salesforce marketing cloud certification with the given skills set? If not, in how much time he can learn the basics of Anaplan? Recently, one of my friends was assigned a task to work on complex data, and suggested he use any data tool.

Thanks

Accepted answers

All comments

TristanS

@raavikant So my opinion, someone who has used excel formulas a lot would likely find it easier to learn and apply Anaplan as it uses the LOOKUP and SUM function a lot which is equivalent to Excel's VLOOKUP and SUM formulas. For someone who is more accustomed to structured programming languages such as Javascript, VB Net, etc .. it would really depend on the individual and their ability to adapt their mindset. I've seen very good structured language programmers struggle with Anaplan but have also seen average structured language programmers do very well picking up Anaplan.

TristanS

@raavikant Just realised I didn't really answer the fundamental question you had which is whether Anaplan is a good tool for handling complex data. As an analytical tool for pivoting data, it is awesome. It can handle millions/billions of data permutations and generate an output within seconds which would take hours if not days if you performed them on Excel. As an ETL tool, I would highly NOT recommend using Anaplan for performing data transformations, specially complex ones. For example, if you require transformations that can only be performed using loop logic (while, for next) it would be a convoluted exercise to do it in Anaplan. Though note there are some transformations that may require loop logic in structured languages like Java, VB NET, C that Anaplan can execute via a simple formula, in particular logic that involves Time dimensions. Anaplan is good at simplifying rule implementations that involves looping through time. So the approach I would recommend is to perform data transformations outside of Anaplan and then use Anaplan to ingest the transformed data for data analytics purposes.

unknown

This content has been removed.

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…