Method and system for data cleansing to improve product demand forecasting
AssigneeTeradata Corporation
InventorsTsz Yu Chan, Ghadamali Bagherikaram
Life of this patent
Estimating the term…
Abstract
A method for cleansing product demand data to improve product demand forecasting. The improved data cleansing methodology enhances product weekly demand forecast accuracy by adjusting stock-out week demand values, and employing separate outlier logic for regular and promotional demand periods.
Claims20
A computer-implemented method for identifying outliers within a data sample, the method comprising the steps of:
- maintaining, in a data storage device, a database of historical demand information for a product, said historical demand information comprising regular demand values corresponding to non-promotional historical product sales, and promotional demand values corresponding to promotional historical product sales;
- establishing high and low boundary values for said regular demand values, and high and low boundary values for said promotional demand values;
- identifying, by a computer in communication with said data storage device, an individual regular demand value as an outlier regular demand value when said individual regular demand value is above, or below, said high and low boundary values for said regular demand values, respectively;
- and
- identifying, by said computer, an individual promotional demand value as an outlier promotional demand value when said individual promotional demand value is above, or below, said high and low boundary values for said promotional demand values, respectively.
A computer system comprising:
- a data storage device containing a database of historical demand information for a product, said historical demand information comprising regular demand values corresponding to non-promotional historical product sales, and promotional demand values corresponding to promotional historical product sales;
- a computer in communication with said data storage device for:
- identifying an individual regular demand value as an outlier regular demand value when said individual regular demand value is above, or below, high and low boundary values established for said regular demand values, and high and low boundary values for said promotional demand values, respectively;
- and
- identifying an individual promotional demand value as an outlier promotional demand value when said individual promotional demand value is above, or below, high and low boundary values for said promotional demand values established for said promotional demand values, respectively.
A non-transitory computer-readable medium having a computer program for identifying outliers within a database of historical demand information for a product, said historical demand information comprising regular demand values corresponding to non-promotional historical product sales, and promotional demand values corresponding to promotional historical product sales data sample, the computer program including executable instructions that cause a computer to:
- identify an individual regular demand value as an outlier regular demand value when said individual regular demand value is above, or below, high and low boundary values established for said regular demand values, and high and low boundary values for said promotional demand values, respectively;
- and
- identify an individual promotional demand value as an outlier promotional demand value when said individual promotional demand value is above, or below, high and low boundary values for said promotional demand values established for said promotional demand values, respectively.
Dependencies are inferred from the claim text.