Table selection

To forecast sales for individual stores, the warehouse administrator selects different tables and assigns meaningful names.

The following table shows the table names, the logical names the warehouse administrator assigned to them, and the data and the columns that are included in the tables:

Table 1. Table selection
Table Name	Logical Name	Data	Column Names	Descriptive Column Names
PRCHS_PRFL_ANLYSIS	Sales transactions	Point-of-sales	TIME_ID STR_IP_ID PD_ID SALES_AMOUNT CST_OF_GDS_SLD_CGS	TIME_ID STR_IP_ID PD_ID SALES_AMOUNT Cost
STORE	Store	Store properties	STR_IP_ID STR_REG_NM STR_TP_NM	STR_IP_ID Store region Store type
PRODUCT	Product	Product properties	PD_ID NM PD_DEPT_NM	PD_ID Name Department name
TIME	Time	Time properties	TIME_ID CDR_YR CDR_QTR CDR_MO DAY_CDR_MO	TIME_ID Year Quarter Month Day

Although the information that is shown in the table above is sufficient to prepare the input data to forecast sales for individual stores, the warehouse administrator might want to define a richer input model. For example, if the data source additionally includes customer data, other projects can work with the same data. This applies not only to the table selection, but also to the other steps of the input model definition.

Feedback