Time Series Data
- Column-based data
-
Each time series field contains the data for a single time series. This structure is the traditional structure of time series data, as used by the Time Series Modeler procedure, the Seasonal Decomposition procedure, and the Spectral Plots procedure. For example, to define a time series in the Data Editor, click the Variable View tab and enter a variable name in any blank row. Each observation in a time series corresponds to a case (a row in the Data Editor).
If you open a spreadsheet that contains time series data, each series should be arranged in a column in the spreadsheet. If you already have a spreadsheet with time series arranged in rows, you can open it anyway and use Transpose on the Data menu to flip the rows into columns.
- Multidimensional data
- For multidimensional data, each time series field contains the data for
multiple time series. Separate time series, within a particular field, are then identified by a set
of values of categorical fields referred to as dimension fields.
For example, sales data for different regions and brands might be stored in a single sales field, so that the dimensions in this case are region and brand. Each combination of region and brand identifies a particular time series for sales. For example, in the following table, the records that have 'north' for region and 'brandX' for brand define a single time series.
Table 1. Multidimensional data date region brand sales 01/01/2014 north brandX 82350 01/01/2014 north brandY 86380 01/01/2014 south brandX 91375 01/01/2014 south brandY 70320 01/02/2014 north brandX 83275 01/02/2014 north brandY 85260 01/02/2014 south brandX 94760 01/02/2014 south brandY 69870 Note: Data that is imported from OLAP cubes, such as from IBM® Cognos® TM1®, is represented as multidimensional data.