Essays
Essays
Background, deep-dive, takeaways — essays here follow the shape of the thinking, not a report template.
Demand Planning for Industrial, B2B and Project-Driven Businesses
Industrial and B2B demand is driven by projects, tenders, shutdowns and one-off orders — not continuous consumer buying. A …
Ecommerce Sales Analytics: A 5,000-Order Dataset Walkthrough
A quick tour of a 5,000-order ecommerce sales dataset — what’s inside, what the data says about categories, regions, …
Exploratory Data Analysis: The Math and Python for Every Step
A visual EDA guide turned into a reference: for each of the nine steps — overview, missing values, descriptive stats, univariate, …
A Practical Guide to Forecast Error Metrics
MAPE is every planner’s default accuracy number — and it quietly misleads on slow-moving and intermittent demand. A …
Demand Exception Reports: Purpose, Review Process, and Practical Challenges
A Demand Exception Report is an analytical tool used in demand planning and S&OP to identify the products that require human …
Understanding SARIMAX Outputs: A Diagnostic Guide for Junior Analysts
A step-by-step diagnostic guide for junior analysts on evaluating, interpreting, and refining statsmodels time-series reports.
Store Sales Forecasting with SARIMAX: A Full Walkthrough
A complete SARIMAX forecasting pipeline on the Store Sales dataset — from EDA and stationarity testing through model fitting, …
ABC-XYZ Analysis: A Practical Guide to Inventory Segmentation for Demand Planning
ABC tells you what matters financially. XYZ tells you what you can actually forecast. Together they form the foundation of every …
Demand Planning KPIs: Learning Notes on Forecast Accuracy Metrics
Eight forecast KPIs that come up constantly in demand planning — with the formula, the business meaning, and the trap hidden …
Why Your Safety Stock Is Lying to You
Every planner inherits the same textbook formula for safety stock. Almost nobody checks whether their demand actually looks the …
A Demand Planner's Guide to LLM Evals
Evaluating a prompt change is a forecasting problem in disguise: you need a baseline, a held-out test set, and a way to tell …
The Join That Broke Procurement
A silent one-to-many join quietly tripled our open-PO totals for two months before anyone noticed the number looked wrong.