Initial State
Practice Exercise 1
Find the five employees with the highest number of transactions in the Southern region and remove the "Tenure", "Income", and "Computer_ID" columns.
An Input Data tool contains 100 records, each representing a unique employee transaction information. The Employee ID (a unique identifier for each employee) and Sector provide basic information about the employee. The "TransPerWk" column represents the average number of expense report transactions that employee makes per week.
In this exercise, drop the columns "Tenure", "Income", and "Computer_ID". Then find the 5 employees with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.
Final State
2
100
Corporate
West
1.5
7.59
59753
182973
57
100
Consumer
North
0.4
10
49931
204379
16
103
Small Business
South
0.5
59.49
68081
580336
115
104
Home Office
South
0.571428571
35.46
99599
418191
145
106
Small Business
North
0.111111111
1.74
38917
108213
172
105
Corporate
West
0.1
4.48
42236
153108
220
102
Home Office
West
1
15
44750
147492
252
109
Corporate
East
0.142857143
15.22
47798
95597
281
109
Corporate
North
0.333333333
18.79
67263
228993
326
108
Consumer
South
0.307692308
20.59
57112
288348
354
100
Home Office
East
1
5.45
54056
156875
391
107
Corporate
South
0.2
34.69
83098
348550
330
107
Home Office
North
0.090909091
25
36930
181912
440
102
Corporate
North
0.1
13.79
40090
179281
483
105
Corporate
South
1
18.29
68794
372262
466
104
Small Business
South
1
37.71
99081
979869
560
101
Small Business
South
1
38.57
96370
731132
582
105
Corporate
East
0.285714286
22.03
66990
146405
618
101
Consumer
West
0.2
7
29346
97035
643
109
Corporate
North
0.25
29.03
27515
140062
689
101
Small Business
South
0.2
12.78
64057
200433
726
104
Consumer
South
1
29.61
86959
386109
739
106
Consumer
South
0.2
8.85
44997
200821
787
104
Home Office
South
1.714285714
25.17
70006
367880
822
101
Small Business
North
0.1
5.65
43177
178146
851
100
Corporate
North
0.25
38.35
79372
306647
856
108
Small Business
South
0.166666667
11.92
57401
231505
911
100
Corporate
West
1
12.23
71335
161299
960
102
Home Office
North
0.666666667
12.43
50741
145256
997
100
Small Business
West
1.333333333
24.69
136217
503319
1035
103
Home Office
South
0.454545455
25.58
35143
163267
1042
104
Small Business
South
0.111111111
23.01
29033
130351
1088
103
Corporate
North
0.125
46.15
75803
364184
1128
108
Consumer
South
3
19.64
57789
205600
1150
103
Corporate
South
0.6
34.02
36668
264344
1186
107
Consumer
West
0.111111111
15.32
50832
177922
1221
107
Small Business
West
0.125
12.42
70563
254234
1261
107
Home Office
West
0.25
6.67
43290
79985
1283
107
Small Business
West
1
14.71
41490
127179
1319
104
Home Office
West
0.375
18.79
49376
222487
1354
105
Consumer
West
0.625
24.16
102087
443018
1389
102
Corporate
South
0.6
6.86
44895
178803
1413
101
Corporate
North
1
14.29
39957
169461
1457
100
Corporate
South
0.285714286
11.76
45542
338207
1478
105
Consumer
West
0.142857143
8.47
53995
276446
1526
109
Home Office
West
0.5
20.25
73326
306425
1558
100
Consumer
West
0.4
17.39
58223
159308
1595
105
Corporate
West
1
10.91
74192
387798
1630
101
Home Office
West
0.166666667
15.91
63659
276448
1665
100
Consumer
West
1
3.45
41959
141242
1712
109
Corporate
North
0.9
31.13
72575
306816
1739
105
Corporate
South
1
26.88
26116
224442
1777
100
Consumer
North
1
18.79
67263
228993
1799
100
Corporate
North
2
23.71
37267
205532
1842
108
Consumer
North
0.333333333
9.3
45341
165010
1872
108
Corporate
South
0.307692308
20.59
57112
288348
1900
105
Consumer
North
1
10.47
56330
170874
1933
104
Corporate
West
1.333333333
7.22
37519
177184
1983
103
Consumer
South
0.545454546
13.99
38737
339234
2019
100
Home Office
West
1
7.46
36075
98482
2020
102
Home Office
West
0.2
4.35
36922
139379
2080
100
Home Office
North
0.5
14.18
62416
241973
2125
105
Corporate
North
0.333333333
16.67
38285
232355
2159
104
Corporate
North
0.333333333
16.67
38285
232355
2195
108
Small Business
West
0.166666667
15.03
63484
286082
2230
101
Consumer
South
0.333333333
37.5
58143
598544
2268
105
Small Business
West
0.2
9.09
53393
149593
2306
100
Small Business
East
0.25
6.57
53577
90504
2341
104
Home Office
South
0.111111111
13.14
49539
416485
2372
105
Corporate
East
0.333333333
2.19
54446
185461
2407
108
Consumer
West
0.75
9.22
38687
151726
2444
108
Consumer
South
0.454545455
25.58
35143
163267
2466
105
Corporate
East
1
24.16
75454
148734
2494
108
Home Office
North
3
9.93
56395
123716
2535
105
Small Business
West
0.272727273
8.82
48661
201505
2464
101
Consumer
North
0.333333333
16.8
66558
116906
2599
103
Corporate
North
0.25
10.94
36921
162048
2629
100
Small Business
West
0
14.53
52528
192554
2655
100
Consumer
West
1.333333333
4.88
38708
112077
2700
105
Small Business
East
0.375
0
54972
116080
2736
103
Small Business
North
0.428571429
10.81
61867
259800
2770
104
Corporate
South
0.111111111
66.39
92884
822256
2804
103
Small Business
East
1
5.43
61980
151626
2834
107
Small Business
West
0.333333333
20.23
64921
222516
2861
109
Corporate
North
0.333333333
15.91
62990
133639
2911
107
Home Office
South
2
9.41
57481
210726
2944
101
Corporate
West
0.2
6.19
30685
95822
2989
100
Home Office
West
0.625
5.83
48253
190261
3018
106
Corporate
South
0.2
7.49
53624
314738
3053
101
Corporate
North
0.333333333
16.8
66558
116906
3076
101
Small Business
West
0.285714286
6.04
40978
153757
3116
101
Home Office
North
0.125
11.01
40606
183015
3163
101
Corporate
North
3
9.2
47858
143181
3196
106
Home Office
East
0.454545455
8.63
47233
98212
3239
107
Corporate
South
1
7.63
50541
160016
3266
107
Corporate
West
0.333333333
12
59936
212575
3310
104
Small Business
South
0.5
47.5
143404
1030786
3277
104
Small Business
South
1
7.35
48145
233721
3342
100
Home Office
South
0.111111111
18.71
58268
278146
3403
107
Consumer
South
0.090909091
8.09
46272
474121
Start File
Start File
1128
108
Consumer
South
3
2911
107
Home Office
South
2
787
104
Home Office
South
1.714285714
483
105
Corporate
South
1
466
104
Small Business
South
1
Final State
Final State
Simple
=
Region
True
fixed
2020-07-04 23:02:33
0
2020-07-04 23:02:33
2020-07-04 23:02:33
South
[Region] = "South"
Weekly Transactions - Descending
First
5
First 5
C:\Users\saurai\AppData\Local\Temp\Engine_36728_1ab956ef11e74b149e06d5013760e9c1_\Engine_38860_de83c3e7fed64a219ac9b0247bed7ce6_.yxdb
Single
Profile
Horizontal
Knowledge Check 1