Databases Reference
In-Depth Information
tABle 7.4 (coNtINueD)
Market Basket BI Table
Driver
Object
Key
Corr
Object
Key
Itemset
Key
Driver
Quantity
Driver
Dollars
Driver
Count
Corr
Quantity
Corr
Dollars
Corr
Count
4
43
3
$42.96
1
98
1
$2.45
1
4
57
1
$9.09
1
43
3
$42.96
1
4
57
1
$9.09
1
78
1
$13.44
1
4
57
1
$9.09
1
87
1
$16.87
1
4
57
1
$9.09
1
98
1
$2.45
1
4
78
1
$13.44
1
43
3
$42.96
1
4
78
1
$13.44
1
57
1
$9.09
1
4
78
1
$13.44
1
87
1
$16.87
1
4
78
1
$13.44
1
98
1
$2.45
1
4
87
1
$16.87
1
43
3
$42.96
1
4
87
1
$16.87
1
57
1
$9.09
1
4
87
1
$16.87
1
78
1
$13.44
1
4
87
1
$16.87
1
98
1
$2.45
1
4
98
1
$2.45
1
43
3
$42.96
1
4
98
1
$2.45
1
57
1
$9.09
1
4
98
1
$2.45
1
78
1
$13.44
1
4
98
1
$2.45
1
87
1
$16.87
1
The Market Basket BI Table is the first table that may be customer-facing
toward an analyst. As the Market Basket BI Table juxtaposes the Driver
Object and Correlation Object with all the metric measurements included,
it can be the terminus for an iteration of analysis.
step 3: Arithmetic Juxtaposition of Driver
objects and correlation objects
The Market Basket BI View, shown in Figure 7.3, arithmetically removes
the Itemset from the juxtaposition of the Driver Object and Correlation
Object. The additive metrics in the Market Basket Table (i.e., Quantity and
Dollars) are both present in the Market Basket BI View as summations of
the Quantity and Dollar fields. The Market Basket Analysis BI View also
calculates ratios based on the summed additive metrics. The ratios pro-
vide a relative frame of reference that enhances the inferences that can be
gleaned from the Market Basket Analysis.
