Demand Planning · Forecasting · Supply Chain Analytics
Norman Li
I work across demand forecasting, inventory planning and supply-chain analytics, combining practical planning experience with Python, SQL, Power BI and statistical forecasting.
Stream
Everything →
Jul 11
Reading about theory of constraints again. Keep circling back to it whenever a planning process feels stuck — the bottleneck is rarely where the complaints are loudest.
Jul 8
TIL: pandas.DataFrame.explode() solves the bill-of-materials flattening problem cleanly — one list-column per parent, exploded into one row per component, no manual loop.
Jun 25
Every team measures forecast accuracy differently, and almost nobody states which one they mean. MAPE punishes low-volume SKUs unfairly; WMAPE fixes that but hides SKU-level misses. Worth writing up properly at some point.
Timeline
2026
Building forecasting and supply-chain analytics projects
2023
Demand planning & procurement analytics
2021
Demand planning in retails
2020
Expanded into Python & SQL analytics