Market Basket Analysis in a Time Variant Data Warehouse - Data Warehouse Designs - page 253

tABle 14.8
Market Basket BI Table with Driver Entity

Itemset
Key

Driver
Entity Key

Driver
Quantity

Driver
Dollars

Driver
Count

Corr
Instance Key

Corr
Quantity

Corr
Dollars

Corr
Count

1 9792 2 $30.62 1 0 0 $0.00 1

2 1124 3 $40.32 1 15 2 $30.62 1

2 1124 3 $40.32 1 16 1 $12.21 1

2 6543 1 $12.21 1 15 2 $30.62 1

2 6543 1 $12.21 1 78 3 $40.32 1

2 9792 2 $30.62 1 16 1 $12.21 1

2 9792 2 $30.62 1 78 3 $40.32 1

3 1124 2 $4.90 1 43 3 $42.96 1

3 1124 2 $4.90 1 57 4 $36.36 1

3 6543 3 $42.96 1 57 4 $36.36 1

3 6543 3 $42.96 1 98 2 $4.90 1

3 9792 4 $36.36 1 43 3 $42.96 1

3 9792 4 $36.36 1 98 2 $4.90 1

4 1124 2 $4.90 1 57 2 $18.18 1

4 1124 2 $4.90 1 64 3 $37.11 1

4 6543 3 $37.11 1 57 2 $18.18 1

4 6543 3 $37.11 1 98 2 $4.90 1

4 9792 2 $18.18 1 64 3 $37.11 1

4 9792 2 $18.18 1 98 2 $4.90 1

5 6543 2 $24.74 1 87 1 $16.87 1

5 9792 1 $16.87 1 64 2 $24.74 1