ABC Classification (Pareto Analysis) — SQL-Based Inventory Prioritization Analyzed 293,569 orders and 2,350 SKUs to identify which products actually drive revenue — and which don't. Approach: Built a CTE-based ABC classification in SQL Server, ranking products by cumulative revenue contribution using window functions (SUM() OVER, CUME_DIST(), PERCENT_RANK()), then segmented into three tiers based on Pareto thresholds. Result: Category A (20% of products) → 70%+ of total revenue Category B (30% of products) → 20-25% of revenue Category C (50% of products) → 5-10% of revenue Business impact: This reprioritizes where operational effort should go — tighter stock monitoring and faster reordering for Category A, reduced tracking overhead for Category C. The same logic fed into a related late-delivery root cause analysis on the same dataset. Stack: SQL Server · Tableau