Sales And Order
-
In this sales and order report for 2022, which is created using Excel. The “Order vs Sales” graph shows a decline in both orders and sales from April to June.
-
The “Men vs Women” pie chart indicates that 64% of orders are made by women and 36% by men.
-
The “Order Status” pie chart shows that 92% of orders were delivered, with a small percentage returned or refunded.
-
The bar graph titled “Sales: Top 10 States” illustrates that Maharashtra leads in sales, followed by Uttar Pradesh and Karnataka.
-
The “Orders: Age vs Gender” bar graph shows adults have the highest ordering rate at 40.72%, with teenagers at a mere 8.59%.
-
The “Order: Channels” pie chart reveals Amazon as the predominant channel for orders at 35%, followed by Flipkart and Myntra.
-
Excel tools visible include dropdown menus for month and category selection, enabling users to filter data based on specific months or product categories , enhancing data analysis efficiency.
-
This dashboard is a powerful tool for visualizing and analyzing sales and order data.
Insights from the data suggest that focusing on female customers and adults could increase profits as they make up the majority of orders. Additionally, increasing sales efforts in Maharashtra, Uttar Pradesh, and Karnataka could be beneficial as these states lead in sales. For low performers, targeted marketing and promotional offers could help boost their sales. Also, considering Amazon is the leading order channel, optimizing the company’s presence on this platform could lead to higher profitability.