ABC-XYZ Inventory Analysis with SQL and Excel

Managing product inventory effectively requires clear insights into demand patterns and stock value. ABC-XYZ analysis provides a structured data-driven methodology to segment inventory and optimize supply chain decisions. In this text-based course, you will learn how to write database queries to classify products by revenue contribution and sales predictability, verifying your calculations step-by-step in Excel. What you'll learn: Learn foundational concepts of inventory management, revenue distribution, and demand variance; Write SQL queries using CTEs and window functions to categorize items into ABC and XYZ matrix tiers; Calculate key statistical metrics including cumulative sales percentages and coefficients of variation; Validate query outputs against Excel formulas to ensure computational accuracy; Translate classification matrix results into actionable stock control and purchasing strategies. The course begins with core supply chain definitions and basic SQL setup before progressing through query construction, statistical calculations, and cross-tool data verification. This program is designed for beginners, data analysts, and inventory specialists looking to build analytical stock management skills with no prior prerequisites required. Read through the written lessons and start optimizing your inventory management workflows today.