Databases Reference
In-Depth Information
The SQL of the Market Basket BI View, shown in Figure 5.7, has three
main sections. The three sections are marked by the horizontal lines in
Figure 5.7.
The first section of the Market Basket BI View presents the Market
Basket Analysis keys and metrics. The keys should always be present in
6(/(&7
'5,9(5'5,9(5B2%-(&7B.(<
&255&255B2%-(&7B.(<
'5,9(5'5,9(5B48$17,7<B680
'5,9(5'5,9(5B'2//$56B680
'5,9(5'5,9(5B&2817B680
&255&255B48$17,7<B680
&255&255B'2//$56B680
&255&255B&2817B680
&255&255B48$17,7<B680'5,9(5'5,9(5B48$17,7<B680$648$17,7<B5$7,2
&255&255B'2//$56B680'5,9(5'5,9(5B'2//$56B680$6'2//$56B5$7,2
&255&255B&2817B680'5,9(5'5,9(5B&2817B680$6&2817B5$7,2
)520
6(/(&7
'5,9(5B2%-(&7B.(<
680'5,9(5B48$17,7<$6'5,9(5B48$17,7<B680
680'5,9(5B'2//$56$6'5,9(5B'2//$56B680
680'5,9(5B&2817$6'5,9(5B&2817B680
)5206(/(&7
,7(06(7B.(<
'5,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
)5200$5.(7B%$6.(7B%,B7$%/(
*5283%<
,7(06(7B.(<
'5,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
*5283%<
'5,9(5B2%-(&7B.(<'5,9(5
,11(5-2,1
6(/(&7
'5,9(5B2%-(&7B.(<
&255B2%-(&7B.(<
680&255B48$17,7<$6&255B48$17,7<B680
680&255B'2//$56$6&255B'2//$56B680
680&255B&2817$6&255B&2817B680
)5200$5.(7B%$6.(7B%,B7$%/(
*5283%<
'5,9(5B2%-(&7B.(<
&255B2%-(&7B.(<&255
21'5,9(5'5,9(5B2%-(&7B.(< &255'5,9(5B2%-(&7B.(<
25'(5%<
'5,9(5'5,9(5B2%-(&7B.(<
&255&255B2%-(&7B.(<
fIGure 5.7
Market Basket Analysis BI View.
