Your question is Prioritize Market Segments and Headcount. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are given several years of sales data and salesperson headcount for a number of market segments. Assess the performance of each segment and recommend which segments should be prioritised and whether headcount in each should be increased or decreased. Prepare and present your analysis.
This was asked in the take-home data case and presentation stage. The data set was provided in advance, and the candidate prepared a presentation instead of completing a live Excel test.
Several years of segment-level sales and salesperson headcount data.