A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | sales_id | date | country | location | sales_quantity | product_id | payment_method | sales_price | sales_cost | shipping_cost | ship_mode | sales_priority | salesperson | sales_lead | total_sales | sales_margin | ||||||||||||
2 | MY-01 | 2021/01/01 | Malaysia | Kuala Lumpur | 30 | P14 | debit card | 207 | 2001 | 500 | Second Class | medium | Ibrahim Ali | event | 6210 | 3709 | ||||||||||||
3 | MY-02 | 2021/01/02 | Malaysia | Miri | 30 | P39 | ewallet | 368 | 2049 | 644 | Second Class | high | Satiswaran | 11040 | 8347 | |||||||||||||
4 | MY-03 | 2021/01/03 | Malaysia | Miri | 39 | P30 | wire transfer | 307 | 1796 | 612 | Standard Class | high | Rageswasri | call | 11973 | 9565 | ||||||||||||
5 | MY-04 | 2021/01/04 | Malaysia | Penang | 37 | P35 | cash | 432 | 1842 | 508 | Second Class | high | Fiona Tan | 15984 | 13634 | |||||||||||||
6 | MY-05 | 2021/01/05 | Malaysia | Johor Bahru | 29 | P33 | ewallet | 207 | 2053 | 711 | First Class | high | Fiona Tan | direct sales | 6003 | 3239 | ||||||||||||
7 | MY-06 | 2021/01/06 | Malaysia | Kuching | 26 | P5 | ewallet | 318 | 2036 | 548 | Standard Class | medium | Ibrahim Ali | 8268 | 5684 | |||||||||||||
8 | MY-07 | 2021/01/07 | Malaysia | Penang | 30 | P28 | wire transfer | 426 | 1911 | 520 | Second Class | medium | Ibrahim Ali | direct sales | 12780 | 10349 | ||||||||||||
9 | MY-08 | 2021/01/08 | Malaysia | Ipoh | 36 | P2 | ewallet | 226 | 2255 | 738 | First Class | high | Jackson Wong | direct sales | 8136 | 5143 | ||||||||||||
10 | MY-09 | 2021/01/09 | Malaysia | Subang Jaya | 38 | P14 | wire transfer | 369 | 2333 | 684 | Standard Class | low | Ong Keng Bin | direct sales | 14022 | 11005 | ||||||||||||
11 | MY-10 | 2021/01/10 | Malaysia | Penang | 31 | P24 | ewallet | 292 | 1772 | 548 | Second Class | medium | Ibrahim Ali | event | 9052 | 6732 | ||||||||||||
12 | MY-11 | 2021/01/11 | Malaysia | Petaling Jaya | 25 | P5 | ewallet | 347 | 1796 | 642 | Second Class | low | Siti Aisha | 8675 | 6237 | |||||||||||||
13 | MY-12 | 2021/01/12 | Malaysia | Johor Bahru | 31 | P32 | ewallet | 248 | 2012 | 671 | Second Class | high | Rageswasri | call | 7688 | 5005 | ||||||||||||
14 | MY-13 | 2021/01/13 | Malaysia | Seremban | 28 | P7 | ewallet | 355 | 2105 | 656 | Second Class | medium | Ong Keng Bin | 9940 | 7179 | |||||||||||||
15 | MY-14 | 2021/01/14 | Malaysia | Shah Alam | 38 | P32 | ewallet | 286 | 2261 | 635 | Second Class | medium | Fiona Tan | 10868 | 7972 | |||||||||||||
16 | MY-15 | 2021/01/15 | Malaysia | Petaling Jaya | 33 | P1 | ewallet | 383 | 2004 | 692 | Standard Class | low | Rageswasri | direct sales | 12639 | 9943 | ||||||||||||
17 | MY-16 | 2021/01/16 | Malaysia | Kuantan | 39 | P9 | cheque | 424 | 1903 | 558 | First Class | low | Ong Keng Bin | event | 16536 | 14075 | ||||||||||||
18 | MY-17 | 2021/01/17 | Malaysia | Penang | 29 | P37 | ewallet | 420 | 2016 | 722 | Second Class | high | Rageswasri | 12180 | 9442 | |||||||||||||
19 | MY-18 | 2021/01/18 | Malaysia | Miri | 34 | P26 | ewallet | 330 | 2186 | 571 | First Class | low | Satiswaran | direct sales | 11220 | 8463 | ||||||||||||
20 | MY-19 | 2021/01/19 | Malaysia | Kota Kinabalu | 39 | P29 | cash | 240 | 1757 | 607 | Standard Class | low | Rageswasri | call | 9360 | 6996 | ||||||||||||
21 | MY-20 | 2021/01/20 | Malaysia | Kuala Lumpur | 37 | P20 | cash | 448 | 2215 | 542 | First Class | low | Fiona Tan | call | 16576 | 13819 | ||||||||||||
22 | MY-21 | 2021/01/21 | Malaysia | Penang | 20 | P4 | credit card | 305 | 2251 | 600 | First Class | high | Ibrahim Ali | direct sales | 6100 | 3249 | ||||||||||||
23 | MY-22 | 2021/01/22 | Malaysia | Miri | 30 | P29 | debit card | 351 | 2147 | 572 | Standard Class | low | Rageswasri | direct sales | 10530 | 7811 | ||||||||||||
24 | MY-23 | 2021/01/23 | Malaysia | Kuantan | 23 | P39 | credit card | 339 | 2203 | 565 | Second Class | low | Fiona Tan | call | 7797 | 5029 | ||||||||||||
25 | MY-24 | 2021/01/24 | Malaysia | Kuala Lumpur | 26 | P40 | cheque | 228 | 1907 | 736 | Standard Class | low | Rageswasri | direct sales | 5928 | 3285 | ||||||||||||
26 | MY-25 | 2021/01/25 | Malaysia | Penang | 38 | P11 | ewallet | 394 | 1837 | 731 | Second Class | medium | Rageswasri | direct sales | 14972 | 12404 | ||||||||||||
27 | MY-26 | 2021/01/26 | Malaysia | Kota Kinabalu | 24 | P18 | cheque | 343 | 2102 | 518 | First Class | high | Satiswaran | 8232 | 5612 | |||||||||||||
28 | MY-27 | 2021/01/27 | Malaysia | Kota Kinabalu | 30 | P41 | ewallet | 425 | 1988 | 619 | First Class | medium | Aliff Jamaluddin | direct sales | 12750 | 10143 | ||||||||||||
29 | MY-28 | 2021/01/28 | Malaysia | Miri | 27 | P13 | ewallet | 356 | 2215 | 720 | Second Class | low | Rageswasri | event | 9612 | 6677 | ||||||||||||
30 | MY-29 | 2021/01/29 | Malaysia | Ipoh | 32 | P38 | ewallet | 365 | 1896 | 541 | Second Class | low | Rageswasri | direct sales | 11680 | 9243 | ||||||||||||
31 | MY-30 | 2021/01/30 | Malaysia | Kuala Lumpur | 34 | P30 | cash | 429 | 1840 | 511 | Second Class | high | Jackson Wong | 14586 | 12235 | |||||||||||||
32 | MY-31 | 2021/01/31 | Malaysia | Seremban | 30 | P41 | debit card | 370 | 2266 | 692 | Second Class | high | Ibrahim Ali | 11100 | 8142 | |||||||||||||
33 | MY-32 | 2021/02/01 | Malaysia | Johor Bahru | 27 | P49 | wire transfer | 431 | 1757 | 720 | Standard Class | low | Aliff Jamaluddin | event | 11637 | 9160 | ||||||||||||
34 | MY-33 | 2021/02/02 | Malaysia | Kota Kinabalu | 36 | P13 | debit card | 307 | 1964 | 646 | Second Class | medium | Ibrahim Ali | 11052 | 8442 | |||||||||||||
35 | MY-34 | 2021/02/03 | Malaysia | Seremban | 29 | P17 | cash | 414 | 1776 | 723 | Standard Class | high | Rageswasri | call | 12006 | 9507 | ||||||||||||
36 | MY-35 | 2021/02/04 | Malaysia | Alor Setar | 34 | P4 | cheque | 448 | 1927 | 501 | Standard Class | medium | Rageswasri | 15232 | 12804 | |||||||||||||
37 | MY-36 | 2021/02/05 | Malaysia | Ipoh | 27 | P16 | wire transfer | 411 | 2062 | 747 | Standard Class | medium | Siti Aisha | 11097 | 8288 | |||||||||||||
38 | MY-37 | 2021/02/06 | Malaysia | Kuching | 32 | P31 | cash | 202 | 1970 | 712 | Second Class | low | Aliff Jamaluddin | call | 6464 | 3782 | ||||||||||||
39 | MY-38 | 2021/02/07 | Malaysia | Johor Bahru | 30 | P12 | cash | 440 | 2030 | 669 | Second Class | high | Satiswaran | 13200 | 10501 | |||||||||||||
40 | MY-39 | 2021/02/08 | Malaysia | Alor Setar | 23 | P43 | wire transfer | 378 | 2184 | 598 | Second Class | low | Rageswasri | call | 8694 | 5912 | ||||||||||||
41 | MY-40 | 2021/02/09 | Malaysia | Alor Setar | 29 | P6 | ewallet | 434 | 1917 | 648 | Second Class | low | Rageswasri | call | 12586 | 10021 | ||||||||||||
42 | MY-41 | 2021/02/10 | Malaysia | Ipoh | 24 | P33 | cheque | 283 | 1962 | 634 | First Class | medium | Aliff Jamaluddin | call | 6792 | 4196 | ||||||||||||
43 | MY-42 | 2021/02/11 | Malaysia | Petaling Jaya | 39 | P1 | credit card | 384 | 2124 | 553 | Standard Class | low | Rageswasri | 14976 | 12299 | |||||||||||||
44 | MY-43 | 2021/02/12 | Malaysia | Kota Kinabalu | 34 | P4 | ewallet | 260 | 1874 | 716 | Second Class | medium | Siti Aisha | event | 8840 | 6250 | ||||||||||||
45 | MY-44 | 2021/02/13 | Malaysia | Kuala Lumpur | 34 | P5 | cheque | 385 | 2250 | 630 | Second Class | low | Jackson Wong | 13090 | 10210 | |||||||||||||
46 | MY-45 | 2021/02/14 | Malaysia | Penang | 38 | P37 | debit card | 373 | 2227 | 541 | First Class | high | Fiona Tan | event | 14174 | 11406 | ||||||||||||
47 | MY-46 | 2021/02/15 | Malaysia | Shah Alam | 36 | P21 | ewallet | 438 | 1912 | 549 | Second Class | medium | Ibrahim Ali | event | 15768 | 13307 | ||||||||||||
48 | MY-47 | 2021/02/16 | Malaysia | Kuala Lumpur | 35 | P37 | cheque | 388 | 2305 | 744 | First Class | low | Siti Aisha | event | 13580 | 10531 | ||||||||||||
49 | MY-48 | 2021/02/17 | Malaysia | Shah Alam | 27 | P39 | credit card | 275 | 2171 | 546 | Second Class | low | Rageswasri | direct sales | 7425 | 4708 | ||||||||||||
50 | MY-49 | 2021/02/18 | Malaysia | Shah Alam | 39 | P29 | credit card | 309 | 1934 | 530 | Standard Class | medium | Ong Keng Bin | 12051 | 9587 | |||||||||||||
51 | MY-50 | 2021/02/19 | Malaysia | Penang | 37 | P13 | ewallet | 302 | 2157 | 739 | Standard Class | medium | Ibrahim Ali | direct sales | 11174 | 8278 | ||||||||||||
52 | MY-51 | 2021/02/20 | Malaysia | Shah Alam | 21 | P34 | cash | 393 | 1845 | 547 | Standard Class | low | Aliff Jamaluddin | 8253 | 5861 | |||||||||||||
53 | MY-52 | 2021/02/21 | Malaysia | Petaling Jaya | 39 | P50 | credit card | 374 | 2341 | 687 | Second Class | low | Ong Keng Bin | call | 14586 | 11558 | ||||||||||||
54 | MY-53 | 2021/02/22 | Malaysia | Subang Jaya | 21 | P49 | ewallet | 272 | 2305 | 631 | Second Class | low | Jackson Wong | direct sales | 5712 | 2776 | ||||||||||||
55 | MY-54 | 2021/02/23 | Malaysia | Alor Setar | 22 | P38 | cheque | 302 | 2112 | 742 | Standard Class | high | Fiona Tan | call | 6644 | 3790 | ||||||||||||
56 | MY-55 | 2021/02/24 | Malaysia | Kuching | 40 | P9 | cash | 219 | 1873 | 695 | Standard Class | high | Ong Keng Bin | 8760 | 6192 | |||||||||||||
57 | MY-56 | 2021/02/25 | Malaysia | Johor Bahru | 32 | P4 | debit card | 300 | 2195 | 634 | Second Class | medium | James Wan | 9600 | 6771 | |||||||||||||
58 | MY-57 | 2021/02/26 | Malaysia | Kuala Lumpur | 34 | P41 | debit card | 242 | 2306 | 554 | First Class | low | Jackson Wong | 8228 | 5368 | |||||||||||||
59 | MY-58 | 2021/02/27 | Malaysia | Alor Setar | 26 | P50 | debit card | 207 | 1867 | 724 | Second Class | low | Jackson Wong | event | 5382 | 2791 | ||||||||||||
60 | MY-59 | 2021/02/28 | Malaysia | Penang | 24 | P27 | ewallet | 248 | 1982 | 539 | Second Class | high | Aliff Jamaluddin | event | 5952 | 3431 | ||||||||||||
61 | MY-60 | 2021/03/01 | Malaysia | Kuantan | 20 | P5 | wire transfer | 202 | 2318 | 738 | Second Class | high | Siti Aisha | 4040 | 984 | |||||||||||||
62 | MY-61 | 2021/03/02 | Malaysia | Johor Bahru | 33 | P20 | credit card | 423 | 2342 | 601 | First Class | low | Ong Keng Bin | direct sales | 13959 | 11016 | ||||||||||||
63 | MY-62 | 2021/03/03 | Malaysia | Shah Alam | 20 | P5 | ewallet | 422 | 1853 | 640 | Standard Class | medium | Rageswasri | 8440 | 5947 | |||||||||||||
64 | MY-63 | 2021/03/04 | Malaysia | Ipoh | 28 | P4 | ewallet | 312 | 2315 | 617 | Second Class | high | Fiona Tan | direct sales | 8736 | 5804 | ||||||||||||
65 | MY-64 | 2021/03/05 | Malaysia | Miri | 39 | P43 | cheque | 428 | 2084 | 687 | First Class | low | Rageswasri | call | 16692 | 13921 | ||||||||||||
66 | MY-65 | 2021/03/06 | Malaysia | Petaling Jaya | 36 | P10 | debit card | 238 | 2293 | 605 | Second Class | medium | Aliff Jamaluddin | direct sales | 8568 | 5670 | ||||||||||||
67 | MY-66 | 2021/03/07 | Malaysia | Kuantan | 22 | P44 | cheque | 224 | 2282 | 540 | Second Class | high | Jackson Wong | 4928 | 2106 | |||||||||||||
68 | MY-67 | 2021/03/08 | Malaysia | Penang | 24 | P17 | cash | 361 | 1922 | 660 | Second Class | low | Ong Keng Bin | direct sales | 8664 | 6082 | ||||||||||||
69 | MY-68 | 2021/03/09 | Malaysia | Kuala Lumpur | 40 | P25 | ewallet | 249 | 2050 | 743 | Standard Class | high | Ibrahim Ali | 9960 | 7167 | |||||||||||||
70 | MY-69 | 2021/03/10 | Malaysia | Subang Jaya | 40 | P5 | cash | 297 | 2066 | 556 | Second Class | low | Ibrahim Ali | call | 11880 | 9258 | ||||||||||||
71 | MY-70 | 2021/03/11 | Malaysia | Miri | 35 | P3 | debit card | 381 | 1990 | 744 | Standard Class | medium | Aliff Jamaluddin | call | 13335 | 10601 | ||||||||||||
72 | MY-71 | 2021/03/12 | Malaysia | Petaling Jaya | 28 | P20 | cash | 306 | 1929 | 516 | Second Class | high | Satiswaran | direct sales | 8568 | 6123 | ||||||||||||
73 | MY-72 | 2021/03/13 | Malaysia | Alor Setar | 26 | P38 | cash | 295 | 1883 | 661 | Standard Class | medium | Ong Keng Bin | direct sales | 7670 | 5126 | ||||||||||||
74 | MY-73 | 2021/03/14 | Malaysia | Petaling Jaya | 39 | P9 | credit card | 354 | 2087 | 522 | Standard Class | low | Rageswasri | direct sales | 13806 | 11197 | ||||||||||||
75 | MY-74 | 2021/03/15 | Malaysia | Johor Bahru | 34 | P23 | cash | 226 | 1813 | 529 | Second Class | low | Ibrahim Ali | direct sales | 7684 | 5342 | ||||||||||||
76 | MY-75 | 2021/03/16 | Malaysia | Alor Setar | 33 | P32 | debit card | 226 | 2077 | 538 | Standard Class | low | Jackson Wong | event | 7458 | 4843 | ||||||||||||
77 | MY-76 | 2021/03/17 | Malaysia | Seremban | 31 | P35 | wire transfer | 232 | 2192 | 512 | Standard Class | low | Rageswasri | direct sales | 7192 | 4488 | ||||||||||||
78 | MY-77 | 2021/03/18 | Malaysia | Johor Bahru | 22 | P20 | cash | 216 | 2251 | 682 | Second Class | medium | Rageswasri | 4752 | 1819 | |||||||||||||
79 | MY-78 | 2021/03/19 | Malaysia | Kota Kinabalu | 38 | P11 | cash | 204 | 2280 | 509 | Standard Class | high | Ibrahim Ali | call | 7752 | 4963 | ||||||||||||
80 | MY-79 | 2021/03/20 | Malaysia | Subang Jaya | 25 | P16 | cheque | 309 | 1821 | 695 | Standard Class | low | Jackson Wong | 7725 | 5209 | |||||||||||||
81 | MY-80 | 2021/03/21 | Malaysia | Ipoh | 23 | P20 | cash | 341 | 2345 | 670 | First Class | medium | Aliff Jamaluddin | call | 7843 | 4828 | ||||||||||||
82 | MY-81 | 2021/03/22 | Malaysia | Kuala Lumpur | 28 | P40 | ewallet | 376 | 1893 | 733 | First Class | medium | Ibrahim Ali | direct sales | 10528 | 7902 | ||||||||||||
83 | MY-82 | 2021/03/23 | Malaysia | Kuala Lumpur | 25 | P39 | ewallet | 444 | 1950 | 528 | First Class | high | Fiona Tan | event | 11100 | 8622 | ||||||||||||
84 | MY-83 | 2021/03/24 | Malaysia | Seremban | 35 | P11 | cash | 424 | 2104 | 658 | Second Class | low | Siti Aisha | direct sales | 14840 | 12078 | ||||||||||||
85 | MY-84 | 2021/03/25 | Malaysia | Penang | 30 | P4 | wire transfer | 318 | 2237 | 709 | Second Class | low | Aliff Jamaluddin | 9540 | 6594 | |||||||||||||
86 | MY-85 | 2021/03/26 | Malaysia | Kuching | 24 | P23 | cash | 384 | 1764 | 569 | First Class | low | Aliff Jamaluddin | direct sales | 9216 | 6883 | ||||||||||||
87 | MY-86 | 2021/03/27 | Malaysia | Petaling Jaya | 35 | P22 | ewallet | 293 | 1837 | 550 | Standard Class | low | Jackson Wong | direct sales | 10255 | 7868 | ||||||||||||
88 | MY-87 | 2021/03/28 | Malaysia | Alor Setar | 21 | P42 | ewallet | 307 | 2235 | 731 | First Class | medium | Aliff Jamaluddin | event | 6447 | 3481 | ||||||||||||
89 | MY-88 | 2021/03/29 | Malaysia | Alor Setar | 38 | P24 | debit card | 226 | 2071 | 638 | First Class | medium | Fiona Tan | direct sales | 8588 | 5879 | ||||||||||||
90 | MY-89 | 2021/03/30 | Malaysia | Miri | 34 | P19 | ewallet | 244 | 1941 | 538 | Second Class | high | Satiswaran | event | 8296 | 5817 | ||||||||||||
91 | MY-90 | 2021/03/31 | Malaysia | Kuala Lumpur | 32 | P27 | credit card | 398 | 1882 | 725 | Standard Class | high | Siti Aisha | direct sales | 12736 | 10129 | ||||||||||||
92 | MY-91 | 2021/04/01 | Malaysia | Petaling Jaya | 35 | P15 | ewallet | 269 | 2232 | 708 | First Class | low | Ong Keng Bin | call | 9415 | 6475 | ||||||||||||
93 | MY-92 | 2021/04/02 | Malaysia | Penang | 20 | P20 | ewallet | 222 | 2341 | 649 | First Class | low | Jackson Wong | direct sales | 4440 | 1450 | ||||||||||||
94 | MY-93 | 2021/04/03 | Malaysia | Penang | 34 | P45 | credit card | 242 | 2212 | 666 | Standard Class | low | Aliff Jamaluddin | 8228 | 5350 | |||||||||||||
95 | MY-94 | 2021/04/04 | Malaysia | Ipoh | 28 | P45 | wire transfer | 227 | 2231 | 525 | Standard Class | low | Rageswasri | call | 6356 | 3600 | ||||||||||||
96 | MY-95 | 2021/04/05 | Malaysia | Petaling Jaya | 37 | P5 | cash | 273 | 2208 | 573 | Standard Class | low | Rageswasri | 10101 | 7320 | |||||||||||||
97 | MY-96 | 2021/04/06 | Malaysia | Kuala Lumpur | 29 | P27 | cheque | 304 | 1972 | 594 | First Class | high | Aliff Jamaluddin | 8816 | 6250 | |||||||||||||
98 | MY-97 | 2021/04/07 | Malaysia | Subang Jaya | 33 | P18 | ewallet | 247 | 2330 | 601 | First Class | low | Ong Keng Bin | 8151 | 5220 | |||||||||||||
99 | MY-98 | 2021/04/08 | Malaysia | Kuching | 21 | P19 | cash | 395 | 2029 | 682 | Standard Class | medium | Ong Keng Bin | direct sales | 8295 | 5584 | ||||||||||||
100 | MY-99 | 2021/04/09 | Malaysia | Penang | 37 | P16 | wire transfer | 341 | 1822 | 596 | Standard Class | low | Ibrahim Ali | 12617 | 10199 |