Omnichannel Retail Analytics Path · Mission 14 of 25Hard

Inventory imbalance — z-score across stores

Multi-CTE z-score pipeline — per-SKU mean+stddev across stores, then per-(SKU,store) standardization. The fundamental statistical lens for inventory imbalance.

The Brief

You'll practice

Window variancePARTITION BY SKUZ-score-style