At home assessment:
What percentage of sales in 202103 was due to brands with higher than $500K sales?
Live excel:
Remove any duplicate rows in the following data set.
Using a formula, how much was sold (revenue) in July 2022?
Using a formula, how many litres did Vortex 899 sell in November 2021? Using a formula, find the product ID of the product that sold at 450 stores in any month.
Using formulas, find the price of product 283929 in October 2021.
Case study:
Cleaning and combining tables, sales performance questions, identifying top performers, impact on sales volume and margin based based on given discount and elasticity
Behavioral questions were the standard ones a couple that come to mind are why RML, what would you do if you realized all the work was wrong a week before the deadline, why are you leaving your current role