Cursusomgeving Data-Docent
Home
Effectieve Business Intelligence
Data Gedreven Werken
Databases
SQL
Self Service Reporting
Lijst van datasets
Overzicht verkoopdashboard
Overzicht verkoop en draaitabel
Overzicht datamart bestelling
Overzicht datamart bezorging
Selecteer een kolom via onderstaande lijst en voeg toe aan select, filter of sorteren
productverkoop_id
productcategorie
neerslag
temperatuur
windsnelheid
verkoopdatum
verkoopaantal
verkoopbedrag
weekdag
maand
datumid
Filter en sorteren
Voeg de geselecteerde kolom toe aan de lijst van kolommen in de resultaatset
Kies de filter operator
=
<>
>=
<=
>
<
Geef de filter waarde
Combineer filter stappen
AND
OR
Voeg de geselecteerde kolom aan de sortering voor de rijen in de resultaatset
Voer de opgebouwde opdracht uit en toon de resultaatset
Overzicht verkoopdashboard
productverkoop_id
productcategorie
neerslag
temperatuur
windsnelheid
verkoopdatum
verkoopaantal
verkoopbedrag
weekdag
maand
datumid
1
IJs
10
88
2022-02-10
6
23,70
Thursday
February
20220210
2
IJs
5
6
2022-02-08
1
2,77
Tuesday
February
20220208
3
IJs
1
1
71
2022-02-17
1
2,77
Thursday
February
20220217
4
IJs
1
7
62
2022-02-08
5
22,12
Tuesday
February
20220208
5
IJs
5
29
44
2022-01-24
8
51,19
Monday
January
20220124
6
IJs
0
9
74
2022-01-29
1
8,85
Saturday
January
20220129
7
IJs
4
-9
30
2022-02-11
3
13,27
Friday
February
20220211
8
IJs
1
-4
80
2022-02-15
2
8,30
Tuesday
February
20220215
9
IJs
1
4
17
2022-02-03
4
16,59
Thursday
February
20220203
10
IJs
4
-4
1
2022-01-23
4
19,91
Sunday
January
20220123
11
IJs
4
1
75
2022-02-01
3
15,49
Tuesday
February
20220201
12
IJs
4
28
52
2022-02-01
8
47,40
Tuesday
February
20220201
13
IJs
1
8
26
2022-02-12
6
24,89
Saturday
February
20220212
14
IJs
4
-10
36
2022-01-25
3
13,27
Tuesday
January
20220125
15
IJs
0
12
5
2022-02-13
14
56,88
Sunday
February
20220213
16
IJs
3
12
1
2022-01-24
6
23,70
Monday
January
20220124
17
IJs
2
29
43
2022-02-14
4
23,70
Monday
February
20220214
18
IJs
1
24
47
2022-01-22
18
106,65
Saturday
January
20220122
19
IJs
2
22
15
2022-02-16
2
11,85
Wednesday
February
20220216
20
IJs
4
6
19
2022-02-04
5
22,12
Friday
February
20220204
21
IJs
4
11
49
2022-02-16
8
31,60
Wednesday
February
20220216
22
IJs
5
29
4
2022-02-09
9
56,88
Wednesday
February
20220209
23
IJs
3
9
39
2022-02-08
4
19,36
Tuesday
February
20220208
24
IJs
0
16
90
2022-01-26
1
6,32
Wednesday
January
20220126
25
IJs
3
4
90
2022-01-26
4
19,36
Wednesday
January
20220126
26
IJs
2
17
69
2022-01-27
7
27,65
Thursday
January
20220127
27
IJs
0
7
87
2022-01-25
4
22,13
Tuesday
January
20220125
28
IJs
2
-8
34
2022-02-13
7
27,65
Sunday
February
20220213
29
IJs
5
6
23
2022-01-27
1
1,33
Thursday
January
20220127
30
IJs
1
28
11
2022-01-29
2
11,85
Saturday
January
20220129
31
IJs
4
-5
77
2022-02-09
2
11,06
Wednesday
February
20220209
32
IJs
2
7
31
2022-01-20
4
16,59
Thursday
January
20220120
33
IJs
3
28
22
2022-02-18
16
94,80
Friday
February
20220218
34
IJs
1
12
8
2022-01-26
5
19,75
Wednesday
January
20220126
35
IJs
5
-7
87
2022-01-30
1
1,33
Sunday
January
20220130
36
IJs
3
21
1
2022-02-04
6
35,55
Friday
February
20220204
37
IJs
3
3
18
2022-01-20
6
24,89
Thursday
January
20220120
38
IJs
1
-8
79
2022-02-11
6
24,89
Friday
February
20220211
39
Koffie
0
-5
37
2022-01-24
6
22,85
Monday
January
20220124
40
Koffie
3
0
79
2022-02-10
6
21,42
Thursday
February
20220210
41
Koffie
5
11
62
2022-02-13
1
6,53
Sunday
February
20220213
42
Koffie
5
24
88
2022-02-03
1
4,90
Thursday
February
20220203
43
Koffie
3
-2
20
2022-02-04
6
21,42
Friday
February
20220204
44
Koffie
3
10
37
2022-01-30
2
6,80
Sunday
January
20220130
45
Koffie
5
23
79
2022-01-21
9
48,96
Friday
January
20220121
46
Koffie
2
10
79
2022-01-20
4
13,60
Thursday
January
20220120
47
Koffie
4
14
34
2022-02-08
3
10,88
Tuesday
February
20220208
48
Koffie
0
2
89
2022-02-04
3
15,23
Friday
February
20220204
49
Koffie
0
9
57
2022-01-20
6
22,85
Thursday
January
20220120
50
Koffie
5
1
83
2022-01-22
1
5,71
Saturday
January
20220122
51
Koffie
2
23
10
2022-02-09
21
102,00
Wednesday
February
20220209
52
Koffie
0
1
75
2022-02-11
1
3,81
Friday
February
20220211
53
Koffie
1
0
81
2022-01-25
2
9,52
Tuesday
January
20220125
54
Koffie
5
21
53
2022-02-18
8
44,06
Friday
February
20220218
55
Koffie
5
4
35
2022-02-17
1
8,00
Thursday
February
20220217
56
Koffie
5
-5
31
2022-02-16
1
3,43
Wednesday
February
20220216
57
Koffie
4
11
51
2022-01-26
3
10,88
Wednesday
January
20220126
58
Koffie
1
24
9
2022-02-07
12
61,20
Monday
February
20220207
59
Koffie
2
11
42
2022-02-13
4
13,60
Sunday
February
20220213
60
Koffie
0
-10
86
2022-01-27
8
30,46
Thursday
January
20220127
61
Koffie
5
11
37
2022-02-05
3
11,42
Saturday
February
20220205
62
Koffie
1
22
44
2022-02-01
10
51,00
Tuesday
February
20220201
63
Koffie
4
-2
6
2022-02-07
1
3,81
Monday
February
20220207
64
Koffie
5
25
32
2022-01-28
1
9,79
Friday
January
20220128
65
Koffie
2
26
71
2022-02-18
4
20,40
Friday
February
20220218
66
Koffie
0
-7
88
2022-02-11
6
22,85
Friday
February
20220211
67
Koffie
1
9
10
2022-02-16
5
19,04
Wednesday
February
20220216
68
Koffie
3
11
64
2022-02-01
6
20,40
Tuesday
February
20220201
69
Koffie
4
-7
52
2022-02-14
4
15,23
Monday
February
20220214
70
Koffie
5
-1
27
2022-01-26
2
10,28
Wednesday
January
20220126
71
Koffie
0
-5
8
2022-01-20
3
11,42
Thursday
January
20220120
72
Koffie
5
8
60
2022-02-11
1
4,57
Friday
February
20220211
73
Koffie
0
28
9
2022-01-21
16
81,60
Friday
January
20220121
74
Koffie
3
28
1
2022-01-24
14
71,40
Monday
January
20220124
75
Koffie
2
-4
9
2022-02-12
1
2,38
Saturday
February
20220212
76
Koffie
5
8
79
2022-02-02
3
11,42
Wednesday
February
20220202
77
Koffie
2
22
71
2022-02-13
14
71,40
Sunday
February
20220213
78
Koffie
3
5
65
2022-02-16
4
14,28
Wednesday
February
20220216
79
Koffie
5
-6
19
2022-01-22
1
1,14
Saturday
January
20220122
80
Koffie
4
9
23
2022-02-06
1
5,71
Sunday
February
20220206
81
Koffie
0
8
35
2022-02-08
3
15,23
Tuesday
February
20220208
82
Koffie
3
5
40
2022-01-27
2
7,14
Thursday
January
20220127
83
Koffie
5
2
48
2022-01-27
1
6,85
Thursday
January
20220127
84
Koffie
4
-4
73
2022-01-29
1
7,62
Saturday
January
20220129
85
Koffie
1
-1
89
2022-02-10
3
11,90
Thursday
February
20220210
86
Koffie
3
7
4
2022-02-02
5
19,04
Wednesday
February
20220202
87
Koffie
1
20
90
2022-01-25
12
61,20
Tuesday
January
20220125
88
Koffie
2
-3
12
2022-02-14
4
14,28
Monday
February
20220214
89
Koffie
0
29
45
2022-02-04
12
65,28
Friday
February
20220204
90
Koffie
1
15
16
2022-01-25
6
20,40
Tuesday
January
20220125
91
Koffie
4
2
64
2022-02-02
5
19,04
Wednesday
February
20220202
92
Koffie
3
-4
4
2022-02-17
6
21,42
Thursday
February
20220217
93
Koffie
1
17
79
2022-01-31
5
17,00
Monday
January
20220131
94
Koffie
4
-2
30
2022-01-22
3
13,33
Saturday
January
20220122
95
Koffie
0
11
33
2022-02-18
12
43,52
Friday
February
20220218
96
Koffie
0
-5
49
2022-02-18
4
19,04
Friday
February
20220218
97
Koffie
1
-8
43
2022-01-26
4
16,66
Wednesday
January
20220126
98
Koffie
0
-10
23
2022-01-20
6
22,85
Thursday
January
20220120
99
Koffie
2
14
79
2022-02-10
1
3,40
Thursday
February
20220210
100
Koffie
1
21
43
2022-02-03
10
51,00
Thursday
February
20220203
101
Koffie
1
23
43
2022-02-09
18
91,80
Wednesday
February
20220209
102
Koffie
4
27
37
2022-02-04
6
32,64
Friday
February
20220204
103
Koffie
1
16
21
2022-01-28
8
27,20
Friday
January
20220128
104
Koffie
2
7
45
2022-01-22
5
19,04
Saturday
January
20220122
105
Koffie
2
29
69
2022-02-02
2
10,20
Wednesday
February
20220202
106
Koffie
3
11
16
2022-02-12
8
27,20
Saturday
February
20220212
107
Koffie
4
19
90
2022-02-07
6
32,64
Monday
February
20220207
108
Koffie
0
20
41
2022-02-11
28
146,88
Friday
February
20220211
109
Koffie
2
24
5
2022-01-24
12
61,20
Monday
January
20220124
110
Koffie
5
-10
15
2022-02-07
3
11,42
Monday
February
20220207
111
Koffie
0
-2
81
2022-01-21
8
30,46
Friday
January
20220121
112
Koffie
2
24
87
2022-01-23
12
61,20
Sunday
January
20220123
113
Koffie
3
24
76
2022-02-13
18
91,80
Sunday
February
20220213
114
Koffie
4
-5
61
2022-01-22
4
17,14
Saturday
January
20220122
115
Ijstaart
4
-5
74
2022-01-30
1
21,76
Sunday
January
20220130
116
Ijstaart
4
2
57
2022-01-25
1
29,01
Tuesday
January
20220125
117
Ijstaart
1
26
15
2022-02-08
2
38,85
Tuesday
February
20220208
118
Ijstaart
1
29
65
2022-02-11
21
388,50
Friday
February
20220211
119
Ijstaart
1
22
71
2022-01-28
14
271,95
Friday
January
20220128
120
Ijstaart
1
15
13
2022-02-03
6
77,70
Thursday
February
20220203
121
Ijstaart
3
-2
31
2022-02-16
7
90,65
Wednesday
February
20220216
122
Ijstaart
0
7
9
2022-02-05
9
130,54
Saturday
February
20220205
123
Ijstaart
1
28
14
2022-01-25
21
388,50
Tuesday
January
20220125
124
Ijstaart
5
27
3
2022-02-18
1
37,30
Friday
February
20220218
125
Ijstaart
4
-9
85
2022-01-30
4
65,27
Sunday
January
20220130
126
Ijstaart
5
29
53
2022-01-22
9
186,48
Saturday
January
20220122
127
Ijstaart
5
-5
83
2022-02-01
1
8,70
Tuesday
February
20220201
128
Ijstaart
4
0
57
2022-02-02
5
72,52
Wednesday
February
20220202
129
Ijstaart
0
10
62
2022-02-07
11
145,04
Monday
February
20220207
130
Ijstaart
1
27
8
2022-01-21
14
271,95
Friday
January
20220121
131
Ijstaart
1
-10
90
2022-01-23
1
18,13
Sunday
January
20220123
132
Ijstaart
5
26
68
2022-01-20
3
74,59
Thursday
January
20220120
133
Ijstaart
1
0
24
2022-02-15
1
9,07
Tuesday
February
20220215
134
Ijstaart
4
0
74
2022-02-18
1
21,76
Friday
February
20220218
135
Ijstaart
3
21
28
2022-01-21
12
233,10
Friday
January
20220121
136
Ijstaart
0
-6
21
2022-02-03
9
130,54
Thursday
February
20220203
137
Ijstaart
0
22
25
2022-02-11
3
62,16
Friday
February
20220211
138
Ijstaart
5
-4
27
2022-02-05
2
39,16
Saturday
February
20220205
139
Ijstaart
5
21
4
2022-02-15
3
74,59
Tuesday
February
20220215
140
Ijstaart
1
14
39
2022-02-16
9
116,55
Wednesday
February
20220216
141
Ijstaart
2
10
30
2022-01-30
8
103,60
Sunday
January
20220130
142
Ijstaart
0
16
37
2022-01-25
12
165,76
Tuesday
January
20220125
143
Ijstaart
4
3
49
2022-02-03
1
7,26
Thursday
February
20220203
144
Ijstaart
2
-9
62
2022-02-09
7
90,65
Wednesday
February
20220209
145
Ijstaart
5
25
54
2022-01-27
2
55,94
Thursday
January
20220127
146
Ijstaart
1
-2
53
2022-01-29
7
90,65
Saturday
January
20220129
147
Ijstaart
2
-9
56
2022-02-15
1
9,07
Tuesday
February
20220215
148
Ijstaart
0
8
78
2022-01-24
6
87,02
Monday
January
20220124
149
Ijstaart
2
28
78
2022-01-23
14
271,95
Sunday
January
20220123
150
Ijstaart
0
-4
4
2022-02-17
4
72,53
Thursday
February
20220217
151
Ijstaart
0
-10
58
2022-02-01
1
14,51
Tuesday
February
20220201
152
Ijstaart
0
26
36
2022-02-02
19
372,96
Wednesday
February
20220202
153
Softijs
5
2
52
2022-02-15
1
2,62
Tuesday
February
20220215
154
Softijs
0
11
10
2022-02-13
6
12,48
Sunday
February
20220213
155
Softijs
3
5
26
2022-01-20
7
13,65
Thursday
January
20220120
156
Softijs
4
17
21
2022-01-29
2
4,68
Saturday
January
20220129
157
Softijs
5
15
72
2022-01-24
4
9,36
Monday
January
20220124
158
Softijs
5
16
81
2022-01-24
2
4,68
Monday
January
20220124
159
Softijs
4
-3
64
2022-01-21
4
8,74
Friday
January
20220121
160
Softijs
0
-7
86
2022-02-02
1
2,19
Wednesday
February
20220202
161
Softijs
2
24
31
2022-01-20
14
40,95
Thursday
January
20220120
162
Softijs
3
22
27
2022-01-23
16
46,80
Sunday
January
20220123
163
Softijs
4
28
52
2022-02-07
1
4,68
Monday
February
20220207
164
Softijs
2
28
32
2022-01-24
18
52,65
Monday
January
20220124
165
Softijs
2
24
5
2022-01-26
18
52,65
Wednesday
January
20220126
166
Softijs
4
27
59
2022-01-30
16
46,80
Sunday
January
20220130
167
Softijs
5
-3
44
2022-01-21
1
2,62
Friday
January
20220121
168
Softijs
3
0
12
2022-02-13
1
2,73
Sunday
February
20220213
169
Softijs
3
4
25
2022-01-28
4
8,19
Friday
January
20220128
170
Softijs
0
24
63
2022-02-09
6
18,72
Wednesday
February
20220209
171
Softijs
0
-4
56
2022-02-08
8
17,47
Tuesday
February
20220208
172
Softijs
1
15
37
2022-01-30
1
1,95
Sunday
January
20220130
173
Softijs
2
19
83
2022-02-08
18
52,65
Tuesday
February
20220208
174
Softijs
5
16
33
2022-01-23
2
4,68
Sunday
January
20220123
175
Softijs
4
12
60
2022-02-04
1
3,12
Friday
February
20220204
176
Softijs
0
18
37
2022-01-28
3
6,24
Friday
January
20220128
177
Softijs
3
29
25
2022-02-03
18
52,65
Thursday
February
20220203
178
Softijs
4
26
59
2022-01-30
3
9,36
Sunday
January
20220130
179
Softijs
5
25
82
2022-02-01
1
2,81
Tuesday
February
20220201
180
Softijs
1
17
12
2022-02-13
4
7,80
Sunday
February
20220213
181
Softijs
2
3
38
2022-01-26
4
8,19
Wednesday
January
20220126
182
Softijs
4
23
77
2022-02-04
12
37,44
Friday
February
20220204
183
Softijs
0
5
63
2022-01-24
3
6,56
Monday
January
20220124
184
Softijs
0
8
79
2022-01-25
3
8,74
Tuesday
January
20220125
185
Softijs
5
4
71
2022-02-09
3
6,55
Wednesday
February
20220209
186
Softijs
4
14
23
2022-02-03
3
6,24
Thursday
February
20220203
187
Softijs
3
-1
71
2022-01-22
3
6,83
Saturday
January
20220122
188
Softijs
0
13
37
2022-01-31
3
6,24
Monday
January
20220131
189
Softijs
5
17
78
2022-02-08
2
4,68
Tuesday
February
20220208
190
Softijs
5
-4
40
2022-01-24
3
6,55
Monday
January
20220124
191
Softijs
3
15
66
2022-01-21
5
9,75
Friday
January
20220121
192
Softijs
0
-7
4
2022-01-20
8
17,47
Thursday
January
20220120
193
Softijs
2
16
14
2022-02-06
6
11,70
Sunday
February
20220206
194
Softijs
0
-5
32
2022-02-10
1
4,37
Thursday
February
20220210
195
Softijs
1
-3
80
2022-01-22
3
6,83
Saturday
January
20220122
196
Softijs
3
13
68
2022-01-24
3
5,85
Monday
January
20220124
197
Softijs
1
-9
38
2022-01-30
2
4,10
Sunday
January
20220130
198
Softijs
0
4
37
2022-02-09
6
15,30
Wednesday
February
20220209
199
Softijs
5
5
74
2022-01-26
1
3,93
Wednesday
January
20220126
200
Softijs
2
-7
40
2022-01-26
2
4,10
Wednesday
January
20220126
201
Softijs
4
19
20
2022-02-08
4
14,04
Tuesday
February
20220208
202
Softijs
1
2
41
2022-01-30
1
2,73
Sunday
January
20220130
203
Softijs
1
12
34
2022-02-14
6
11,70
Monday
February
20220214
204
Softijs
0
-5
19
2022-02-05
9
19,66
Saturday
February
20220205
205
Softijs
5
-2
2
2022-01-26
1
3,93
Wednesday
January
20220126
206
Softijs
2
25
73
2022-01-27
12
35,10
Thursday
January
20220127
207
Softijs
0
3
16
2022-01-27
6
13,10
Thursday
January
20220127
208
Softijs
5
27
2
2022-02-13
6
19,66
Sunday
February
20220213
209
Softijs
4
13
74
2022-02-06
4
9,36
Sunday
February
20220206
210
Softijs
5
8
33
2022-01-28
2
5,24
Friday
January
20220128
211
Softijs
5
-5
12
2022-02-07
1
3,28
Monday
February
20220207
212
Softijs
1
0
43
2022-02-04
2
5,46
Friday
February
20220204
213
Softijs
2
-2
31
2022-02-08
2
4,10
Tuesday
February
20220208
214
Softijs
2
6
46
2022-01-30
3
6,83
Sunday
January
20220130
215
Softijs
3
-1
79
2022-01-27
2
5,46
Thursday
January
20220127
216
Softijs
2
5
66
2022-01-29
1
2,73
Saturday
January
20220129
217
Softijs
5
11
17
2022-02-17
3
6,55
Thursday
February
20220217
218
Softijs
5
13
86
2022-02-14
1
3,74
Monday
February
20220214
219
Softijs
2
3
85
2022-01-21
1
1,37
Friday
January
20220121
220
Softijs
3
16
38
2022-01-30
9
17,55
Sunday
January
20220130
221
Softijs
0
2
26
2022-01-27
4
10,93
Thursday
January
20220127
222
Softijs
5
8
32
2022-02-06
1
1,31
Sunday
February
20220206
223
Softijs
1
-10
22
2022-02-06
3
6,83
Sunday
February
20220206
224
Softijs
3
23
9
2022-01-20
2
5,85
Thursday
January
20220120
225
Softijs
5
28
16
2022-01-24
9
28,08
Monday
January
20220124
226
Softijs
1
17
9
2022-02-09
6
11,70
Wednesday
February
20220209
227
Softijs
2
0
86
2022-01-20
7
13,65
Thursday
January
20220120
228
Softijs
5
15
44
2022-02-15
4
9,36
Tuesday
February
20220215
alse