Ordering Forecasting based on historic order quantity and marketing Calender


Scenario is as below

Got order table which has got historic data about order quantity on each day for last 2 years.

3 columns, Date, Period Type (e.g. Normal, Christmas, Stocktaking sale, Mother's Day, etc.) and Order Quantity for each day

Got Period type for next 1 year assigned to different dates.

Want to forecast order quantity for next 1 year taking in consideration the date & period type both.

Best Answer