Retail Planning Systems: the Data Model Underneath
You take the three hierarchies every planning system is built on, learn what a grain is, and see why a plan held at the wrong one can never be tied back to actuals. Then you follow one womenswear coats migration off spreadsheets. A class moved to a new parent, a store with no open date, and a size curve held one level too high cost 9.2% of a season's gross profit.
Published by Merchandising Academy · First lesson free to read
Course value
What will you be able to do?
Work outcome
You can build and defend an open-to-buy, phase intake against a forecast you can justify, and decide when to take a markdown instead of holding stock that is quietly costing you money.
Who it is for
Brand and buying-office teams.
What you will produce
You build a data-model pack for one category. You write out the product, location, and time hierarchies level by level. You declare a grain for every measure, including the profiles nobody thinks are data. You keep a register of mapping changes. You plan to reconcile at the lowest level. You run four migration tests drawn from real faults. And you name an owner for every hierarchy.
Learning format
3 lessons · 0 templates · workplace calculations and decisions.