Creating Interactive Dashboard of Madhav E-Commerce Store
The owner of the Madhav 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 Madhav E-Commerce Store, the owner must show maximum ads, sale offers/coupons in the months from January to April and December.