Sales Performance Optimization
E-commerce sales performance — revenue concentration risks, territory gaps and seller dependency.
Challenge
Revenue across ~99K Olist orders (₹13.59M) looked strong, but São Paulo alone drove ~38% of it on both the customer and seller side — one shock away from a bad quarter.
Solution
Staging→clean SQL modeling into one order-item-grain sales_fact, validated in Python and visualized in Tableau with state, seller and Top-N filters. Found supply-side dependency worse than demand-side, plus mid-tier states (RS, PR, SC, BA) with real revenue and low saturation — growth without acquisition cost. Takeaway: growth is constrained by execution concentration, not demand.
View GitHub Repo
