I have an interview with a company for the Anaplan model builder position. There might be a case interview related to model building. Any suggestions on how to prepare for the interview and what kind of questions can be expected. Please help.
Congratulations on securing the interview. Your question is very broad yet I feel it's an important one. The answer will vary depending on the level you are interviewing for (Junior Model Builder, Senior Model Builder, Solution Architect,.....etc). Also, when you say Case Study, does this mean you will be asked to "develop" a model, or it is a question/answer interview.
The following is my point of view and by no means a comprehensive answer. Let's focus on what would I expect if I'm interviewing a Junior/Senior Model Builder (someone who obtained the Model Builder Certificate L1, L2, TAW):
What are the 3 main components of an Anaplan model and what's the function of each?
What is a dimension and how do you model/represent that in an Anaplan model?
What types of Lists exist in Anaplan? and how do we use each?
Why do we need to use a Numbered List?
What does the ITEM() function do and what are examples when we use it?
What are the differences between ITEM() and FINDITEM() ?
Explain the LOOKUP() function, Give a clear example.
Contrast the LOOKUP() and SUM() functions and give example.
What are System Modules and what are some of the uses of System Modules?
Walk me through how would you create a Time System Module, what are some of the useful functions to utilize and how would you use it to filter by time?
What is a Data Hub? how do you utilize it?
There are different ways to implement security and permission access in a model. List the main 3 ways and when/how you use each.
What type of Permission Access you should use in the case of having multiple managers, each works in a different department. They have access to the whole company info but need to have access to edit/add,... for their department only
How do you import a CSV file into Anaplan, walk me through the process highlighting any special considerations
What are summary methods and when should we set it to NONE?
I'll continue adding to the above list as I recall more questions and I invite others to add to the list as well.
If you don't know the answer to any of these questions and you can't find it in any of Anaplan's resources such as Anapedia, community, Academy,... let me know and I'll explain the topic better or point you to where you an find the answers.
Best of Luck
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
This definitely helps. And regarding the case interview as far as the recruiter mentioned it might be related to building a model based on a use case. Even I am not sure about this. But to be prepared for the worst-case scenario could you please suggest some tips for preparing for the interview where I can expect building a model.