Tesco has their operating outlets in different regions across the globe, they wish to investigate 3 main regions: UK, Scotland, and Europe.
Assignment Details and Instructions:
You applied for a Graduate Technical Analyst role with Tesco, one of the world’s largest retailers. They liked your educational background and were impressed by the scores from situational judgement, logical and numeric tests. Thus, you have been invited to showcase your data analytical abilities through a short-recorded video exercise.
Tesco has their operating outlets in different regions across the globe, they wish to investigate 3 main regions: UK, Scotland, and Europe. The analysis should help them understand their sales across these regions along with potential factor affecting their Sales, so they could focus more on these specific aspects.
You have been asked to provide your analysis and insight into the following areas:
- Your first job as a Business Analyst is to summarise the results (as you see fit).
- Tesco provided you with a data that contains specific stores with their sizes and Total Sales (including some stores from Europe and Scotland). They want you to investigate, if there is any link between their Store Size and Total Sales. Comment on your findings.
- Tesco would like to predict their future sales; hence they pulled some data along with some economic variables e.g., GDP, Household expenditure, unemployment, and interest rates & Interest Rate. Perform Regression Analysis (Multiple Regression) to identify the potential driver. Comment on your assumptions or findings.
- Tesco wish to predict their Sales for their leading stores in Scotland and Europe. They are unsure of which method would be most beneficial. They asked you to keep the last 6 months of 2018 as a “hold-out” period and use different techniques to analyse the most effective way for Forecasting.
- Finally, Tesco asked you to predict the forecast of 6 months (from October 2018 – APRIL 2019) for the UK store. Comment on your findings.
Answer preview for Tesco has their operating outlets in different regions across the globe, they wish to investigate 3 main regions: UK, Scotland, and Europe.
432 Words
300 Words