Built a Shopify operations tracker and solved a return-rate discrepancy
A DTC apparel brand's Shopify returns had been climbing for two months before anyone found the real cause.
I ran a full extract–clean–analyze–report workflow: cleaned messy Shopify exports, reconciled 1,516 order lines, and built formula-driven analysis (SUMIFS, COUNTIFS, INDEX/MATCH) to trace a storewide return spike from 5.9% to 8.5% back to a single SKU/size/warehouse combination — responsible for 38.1% of returns and 45% of refund dollars.
Delivered a formula-driven dashboard, a recurring weekly tracker, an SOP, and both internal and customer-facing reports, so the fix outlasted the project.