Database Reference
In-Depth Information
Table 4.13 The transactional dataset after restructuring and aggregating data at the
customer level.
Customer_
Total
ATM
BRANCH INTERNET
PHONE
ID
transactions
transactions
transactions
transactions
transactions
amount
amount
amount
amount
amount
1001
370
110
260
0
0
1002
710
0
150
440
120
Figure 4.2 The IBM SPSS Modeler Restructure node for pivoting transactional data.
original information with a series of key indicators. For instance, by dividing the
volume of each channel by the total volume of all transactions we can produce
the relative volume ratio (proportion) attributable to each channel. The IBM
SPSS Modeler Derive node used for this operation is displayed in Figure 4.3.
The divide operation is applied to each channel volume field by using the
''@'' operator. The conditional (''If'') part of the derive node deals with the
Search WWH ::




Custom Search