The owner of the E-Commerce Store wants us to create an interactive dashboard to track and analyze their online sales across India.
- Compare the sum of the amounts with different states.
- Which person spent the maximum amount of money to buy products?
- Which category of product customer orders the most (Clothing, Electronics and Furniture)?
- What kind of payment mode customer uses the most while purchasing products?
- Which months of the year Madhav Store generate the maximum profit and minimum profit?
- Which sub-category of the product customer orders the most and contibutes gaining maximum profits to Madhav Store?
- Created an interactive dashboard to track and analyze online sales data.
- Used complex parameters to drill down in worksheets and customization using filters and slicers.
- Created connections, join new tables, and calculations to manipulate data and enable user-driven parameters for visualizations.
- Used different types of customized visualization (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicers, etc).
- Most of the customers spent the maximum amounts of money on purchasing products like clothing (63%), Electronics (21%) and furniture (17%) (Printers, Bookcases, Saree, etc).
- The store generates the maximum profits from the months January to April and December.
- The states of Maharashtra, Madhya Pradesh and Uttar Pradesh are the top 3 product buyers.
- The customers Harivansh, Madhav and Madan Mohan are the top 3 product buyers.
- Generally, the customers use the Cash on Delivery (44%) and UPI (21%) mode of Payment.
The customers living in Maharashtra, Madhya Pradesh and Uttar Pradesh purchase the most of the products such as Clothing, Electronics and Furnitures. To improve sales of the E-Commerce Store, the owner must show maximum ads, sale offers/coupons in the months from January to April and December.