Standard process, two stages, Second stage more technical with presentation, Given a sheet of data to review, analyse and the present back in final stage interview based on scenario.

First stage went fairly standard, but after came the second stage, and with it the most insane task I've witnessed in a case study. Basically, you are asked to analyse a full year sales performance with a client, using the real EPOS data provided, and present back a complete promotional plan for the next year, using the uplifts you measured as a part of your prior analysis (accounting for things like secondary space that is outlined in a previous promo plan that they provide as a literal image, and that you have to overlay on top of the EPOS data with the dates not matching, and multiple different promo price points throughout the year, meaning that the only somewhat accurate way to measure the uplift is manually go through every promotion on every SKU, and record it) and to provide a cash up of the volume & value uplift that this new promo plan of yours will bring. All of that on top of the SWOT analysis that you have to do as a first part of that assignment. And somehow presented in 15 minutes with all the methodology used clearly outlined and questioned.