data analysis
Budget: ₹100 – ₹400 INR
2. Use the below problem context associated with the data to answer the questions below
An E-Commerce Platform - has one of its Mother Distribution Centres (DC) set up in Mumbai which coordinates with its Three Child DCs: 1. Pune, 2. Aurangabad, 3. Nashik.
For this assignment, we are considering 10 categories; 5 products each leading up to 50 products.
There are 4 data sheets in the Excel File provided to you.
1. SKU Master: It contains information of BU, SKU, Brand, Model and Average Price
2. Sales Data: It contains information on Date, SKU, City and Volume
3. OPN STK: Stock that is available as on 01-01-2023
4. Stock Transfer: Contains information on incoming stocks to Pune, Aurangabad and Nasik from Mumbai from 01-01-2023 – 30-01-2023.
NOTE: THE SAME DATASET WILL ALSO BE USED FOR ASSIGNMENT 6.
Questions to be solved
1. Over the 30 days of observed sales, what is the total sale value of SKU B003 ?(INTEGER)
2. How much percentage of total sale quantity (Volume) did Household category achieve in the first week? (Jan 1 to Jan 7, both days included) (FLOAT - 3 decimal places)
Hint: Construct a Volume Pareto Chart
3. What is the maximum sale value by a single SKU in a day across all days? (INTEGER)
(Sale Value = Sale Qty * Price per Qty)
4. What is the least revenue generating category across all days? (STRING)
5. What is the percentage of sale value in Mumbai across all categories and days? (FLOAT - 3 decimal places)
An E-Commerce Platform - has one of its Mother Distribution Centres (DC) set up in Mumbai which coordinates with its Three Child DCs: 1. Pune, 2. Aurangabad, 3. Nashik.
For this assignment, we are considering 10 categories; 5 products each leading up to 50 products.
There are 4 data sheets in the Excel File provided to you.
1. SKU Master: It contains information of BU, SKU, Brand, Model and Average Price
2. Sales Data: It contains information on Date, SKU, City and Volume
3. OPN STK: Stock that is available as on 01-01-2023
4. Stock Transfer: Contains information on incoming stocks to Pune, Aurangabad and Nasik from Mumbai from 01-01-2023 – 30-01-2023.
NOTE: THE SAME DATASET WILL ALSO BE USED FOR ASSIGNMENT 6.
Questions to be solved
1. Over the 30 days of observed sales, what is the total sale value of SKU B003 ?(INTEGER)
2. How much percentage of total sale quantity (Volume) did Household category achieve in the first week? (Jan 1 to Jan 7, both days included) (FLOAT - 3 decimal places)
Hint: Construct a Volume Pareto Chart
3. What is the maximum sale value by a single SKU in a day across all days? (INTEGER)
(Sale Value = Sale Qty * Price per Qty)
4. What is the least revenue generating category across all days? (STRING)
5. What is the percentage of sale value in Mumbai across all categories and days? (FLOAT - 3 decimal places)