Codebasics Resume Project Challenge

Domain:  FMCG       Function: Sales / Promotions

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well and which did not so that they can make informed decisions for their next promotional period.  

Sales director Bruce Haryali wanted this immediately but the analytics manager Tony is engaged on another critical project. Tony decided to give this work to Peter Pandey who is the curious data analyst of AtliQ Mart. Since these insights will be directly reported to the sales director, Tony also provided some notes to Peter to support his work.

Task: 

Imagine yourself as Peter Pandey and perform the following task to keep up the trust with your manager Tony Sharma. 

1. Go through the metadata and analyze the datasets thoroughly. This is the most fundamental step. 
2. Check “Recommended Insights.pdf” – this document contains a few recommendations from your manager Tony.  
3. Design a dashboard with your metrics and analysis. The dashboard should be self-explanatory and easy to understand.
4. Check “ad-hoc-requests.pdf” - this document includes important business questions posed by senior executives, requiring SQL-based report generation.
5. You need to present this to the sales director - hence you need to create a convincing presentation with actionable insights.  
6. You can add more research questions and answer them in your presentation that suits your recommendations.  
7. Be creative with your presentation, audio/video presentation will have more weightage.   

Other resources Provided:

• Dataset required to answer preliminary research questions.
• Metadata
• Supporting documents

Note:

• We recommend you create a video presentation of ideally 15 minutes or less for the business stakeholders. Additionally, make a LinkedIn post that includes relevant links, your video presentation, and a reflection on your experience while working on this challenge.
• You can check out this example presentation to gain some inspiration: Sample Presentation Link
• After completing your linkedIn post, please submit the link in the input box provided below.

Download Problem Files