Madhav Store wants to create an interactive dashboard so that they can easily track & analyze their online sales across India.
For this project we have 2 tables:
- Which category of product the customer orders the most (Clothing, Electronics, Furniture)?
- Which months generates the maximum & minimum profits?
- Which states generates the maximum revenue?
- Which person spent the maximum amount of money on buying products?
- What kind payment mode does a customer use the most while purchasing the products?
- Which sub-category of the product customer orders the most & contributes to gaining maximum profits?
- Most of the customers spent the maximum amount of money in purchasing products such as clothing (63%), electronics (21%), furniture (17%) (Printers, Bookcases, Saree etc.)
- The store generates maximum profits from the months of January to April & November.
- Most of the customers are from Maharashtra, Madhya Pradesh & Uttar Pradesh.
- The top 3 customers are Harivansh, Madhav & Madan Mohan.
- Most of the customers are uses Cash on Delivery around 44% and UPI 21% as their payment mode.