Help with understanding how Anaplan works
I am able to do the exercises but struggle to understand what is happening conceptually, given I am used to an excel world in finance! For example, with employees, at it's simplest:
I would have a tab with all the employee details (name, start date etc), with a unqiue Key - then I would cross reference in calculations in another tab.
In Anaplan, I need to upload an employee data csv but then set up a system module with all the employee details. I also need to put formulas to get the code or parent details from another source.
I understand the concepts of modules within models (inputs, calcs, outputs) but as to why you need a seperate systems module vs just using a data source that would have all that data (eg. HR system), I get confused at why we set it up as we do, and in the case of the Model 1 exercises (SYS08 Employee Details lesson 6 and 7), why once I upload the employees data with every detail, I still need a formula to relate to code and dept despite having already matched Code to Name in the Source to Target Input Data screen.
Can someone help me at a basic level understand?