Sales figures alone can be misleading — a category can look like a top performer by revenue while barely turning a profit. I grouped the dataset by product category and compared sales against profit directly, rather than reporting them as two separate charts.
Python · Pandas · Plotly
E-commerce sales & margin analysis
An exploratory analysis of 9,994 Superstore transactions, looking past revenue to find where the business was actually making money.
Overview
Key finding
Furniture generated $742K in sales — close to Technology's $836K — but converted only 2.5% of that to profit, against Technology's 17.4% margin.
Recommendation
A revenue-only view rates Furniture as a strong category. The margin view says otherwise: it's likely being discounted aggressively to move volume, and a pricing or discount-policy review would do more for the bottom line than promoting it further.
What I'd add next
Breaking this down to the sub-category level would show whether the margin problem is a couple of specific products or the whole Furniture line.