Examples of Input Data Sets

Here are two examples of input data sets:

• This input data set contains monthly sales revenue and price information for the past 12 months. In this example, the time variable is Date, the dependent variable is Revenue, and the independent variables are Avg. Price and Holiday. The variable Holiday indicates the number of holidays during the month.

  Monthly Sales for 12 Months

  Date	Revenue	Avg. Price	Holiday
  JAN2011	18817	26.3	0
  FEB2011	52573	25.3	0
  …	…	…	…
  DEC2011	44205	20.3	1

• This input data set contains monthly retail sales information for different regions and product categories over the past 12 months. You can use the Region and Product variables to create a hierarchy for the sales forecasts.

  Monthly Sales for Different Regions and Categories

  Date	Sales	Avg. Price	Holiday	Region	Product
  JAN2011	355	25.3	0	Region 1	Product 1
  FEB2011	398	25.3	0	Region 1	Product 1
  …	…	…	…	…	…
  JAN2011	555	19.8	0	Region 1	Product 2
  FEB2011	390	25.3	0	Region 1	Product 2
  …	…	…	…	…	…
  JAN2011	301	27.1	0	Region 2	Product 1
  FEB2011	350	25.3	0	Region 2	Product 1
  …	…	…	…	…	…
  JAN2011	314	27.2	0	Region 2	Product 2
  FEB2011	388	25.3	0	Region 2	Product 2
  …	…	…	…	…	…
  DEC2011	518	20.3	1	Region 2	Product 2