Q1 · Part 1 of 3
Sales and profitability
Total sales, average profit per order and profit margin by category, the top and underperforming categories, and why they differ.
Category sales vs profit margin
Bars: total sales (left axis). Line: profit margin % (right axis).
Why the categories perform differently
Category performance
Orders and order details merged on Order ID. Ranked by profit margin.
Sub-category breakdown
Margin by sub-category, weakest first. Loss-making lines are tinted peach.
Recommendations
Q1 · Part 2 of 3
Target achievement
Month-over-month change in the Furniture sales target, months with significant fluctuations, and strategies to align targets with actual trends.
Furniture: monthly target vs actual sales
Aligning targets with actual trends
Q1 · Part 3 of 3
Regional performance
Top 5 states by order count with total sales and average profit, regional disparities, and the cities to prioritise.
Top 5 states: order volume vs margin
Bars: distinct orders (left axis). Line: profit margin % (right axis).
Regional disparities
Top 5 states by order count
Quadrants compare each state with the top-5 medians.
Cities to prioritise
Fix: largest profit shortfall against the overall margin (sales x overall margin - profit). Scale: above-median sales and above-average margin. Most of these cities have fewer than 20 orders, so treat them as leads to check, not conclusions.