This is for a management info systems class. I can't post the data here because its a lot under one spreadsheet. all i need is help with these steps and I'll try to recreate it unde google cloud platform and placing it on the bigquery.

Upload the data into bigquery, then create a data Studio dashboard rfm.csv Provide 1. Treemap Provide 2. Table Provide 3. Provide Statistics (mean, standard deviation) Al fx customers B O OOOOO 125 80 75 75 888 888 60 50 1 customero Agency 9761 739 4 9163 9152 737 7 1004 8 2708 9 4558 10 10324 11 2617 12 3774 13 4138 14 5363 15 624 16 1167 17 4823 18 9149 19 10605 20 2182 21 4960 22 9748 23 12907 24 810 25 1763 26 5835 27 6944 28 7657 29 900 NNNNNNN8E C D E transactions last purchas Revenue Rank BB 2/20/20 18092.66 69 1/14/20 1137705 0 95 7/9/20 9543.64 5/20/20 1036411 80 3/30/20 7439 16 0 70 10/5/19 7768.44 0 100 6/11/20 4363.82 0 100 5/15/20 1905.78 0 100 7/15/20 5410.8 0 1/6/20 4045.23 0 6/16/20 3759.97 0 7/17/20 4424,81 0 5/20/20 6072.42 97 2/1/20 4717.06 0 97 4/28/20 3900. 62 97 1/22/20 5045.15 97 3/3/20 508241 97 7/22/20 4364.74 96 6/20/20 4428.81 94 3/22/20 3916.89 94 5/23/20 4346.64 93 7/26/20 4477.45 92 6/10/20 4189.74 92 12/16/10 4180.67 92 11/23/19 3798.84 92 7/24/20 41948 92 7/5/20 43344 BR 8/31/19 4647.29 898899999988888888888 M N Receney Frequency Filter Frequivalue Recent Sed Frequency Value Score SCORE 357 152 23 1 1502.66 5 5 5 403 154 69 1 11872.DS 5 4 4 466 17 95 1 954364 5 5 3 435 67 1 1036411 5 5 3 568 118 80 1 7439.16 5 4 3 554 295 70 1 7768 44 5 3 875 45 100 1 4363.82 5 5 2 788 41 100 1 4905.78 5 5 2 730 11 100 1 54108 5 5 2 943 202 99 1 404523 5 2 40 99 1 3759.97 5 5 2 862 9 1 1424,84 5 $ 2 666 59 98 1 5072.42 5 5 2 817 176 97 1 471706 5 5 2 963 89 92 1 390063 3 5 2 766 136 97 1 5045.15 5 5 2 764 145 97 5082 41 5 5 2 874 4 97 1 4364.74 5 5 2 861 36 56 1 4428.81 5 5 2 959 126 94 1 3916.89 5 5 2 877 54 34 1 4346.64 5 5 2 845 0 93 1 4477.45 5 5 2 910 46 1 4189.74 5 5 2 912 223 92 1 5 5 2 978 246 92 1 3798.34 5 5 2 92 1 2 909 5 5 41948 2 21 880 92 1 43344 5 5 2 330 826 1 4647.29 5 5 2 373183 5 5 2 5 %8mm 88 OOOOOOOOOOOOO 50 50 50 50 50 50 50 SO 50 50 50 50 50 so 50 50 50 50 50 50 28888888888 C F G H M N 068 TE CR 0 1 T 5 S 19 16 3 50 50 32 9223 4911 1464 3047 0 0 B2 36 84 34 84 OS 86 84 54 84 EE 5 5 5 5 5 5 5 5 ES 9 34 35 36 0 O GESP 464 137 1 1 1 1 1 2 1 1 1 4387.88 6083 42 669889 3905.53 377171 3875.87 3948 19 3735. OS 6867.73 50 50 50 50 327 6169 83 o 0 0 0 ZE 665 619 962 981 965 955 990 606 870 900 254 505 498 S 5 2 2 2 2 2 2 2 2 2 2 2 5 5 ISE OS 98 38 39 40 82 5 B3 22 82 32 81 36 50 5 5 5 5 5 5 5 2 3 4626 4912 315 15 SERBE Os 5814 9 0 0 O O 18 1 1 1 42 65 4 313 157 65 2453 1711 657 272 E E 0 0 52 97 52 97 50 50 45 45 40 40 40 95 DES 6/17/20 7/10/20 7/2120 7/20/20 5/9/19 V11/20 4/21420 5/1/20 91519 7/11/20 7/20/20 7/22/20 9/11/19 2/20/20 4/19/10 12/16/17 2/18 7320 7/1/20 3/13/20 1/16/20 2/29/20 7/5/20 1/16/20 9/11/19 1/24/19 5/21/19 5/7/20 7/25/20 12/19/19 40 45 41 47 48 2602 4287.88 603.42 498 3905.53 3771.71 3875.7 1948.19 3735.05 6867.73 43657 3701 184562 3818.97 891395 4436.43 3731.40 3872.49 3702.52 4384.77 500 4082 4149 29 40824 4062.27 291235 4089 29 4212.90 617115 35565 4445.1 06 5 5 -5 0 0 99 2214 1022 1723 1441 OP 0 O 4 1 AP 5 5 5 5 5 5 5 4 3 4 5 5 5 5 5 5 5 5 5 5 5 953 872 23 23 131 132 DES 21 10 36 79 79 16 74 71 1 1 1 1 1 1 1 1 1 1 40 40 4 S 0 991 966 1000 871 775 931 917 929 939 960 845 37803 I562 8818.97 1911.95 44364) 373149 387249 370752 4394.77 SO088 40 72 41470 4092.4 406227 3912 13 4483 42120 6171.15 5556.57 1565 O 0 79 79 76 74 71 71 70 70 69 4 4 7 OV 0 50 51 52 53 54 55 56 57 58 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 40 40 0 O 4 4 4 4 7205 7907 697 9640 1173 3960 11340 5811 544 SE OT GLE 1 1 ERRSS 38 69 0 0 0 2 TOS 337 432 30 4 657 718 40 40 40 40 40 1 1 1 1 ass 65 5 1 56 65 3 5.1 220 GO ESE O N a F D G B H C 65 2 2 60 853 813 5 50 0 0 0 19 2 564 3425 5063 10198 5072 60 966 20 40 40 40 10 36 44451 475825 3726.12 4601.22 S009.02 106274 62 63 64 65 66 O O 0 62 78 95 93 2 220 148 45 183 212 1170 1545 1107 1358 141 129 278 DE 65 65 63 63 62 78 95 93 83 59 57 56 55 0 0 0 0 30 10 3583 3622 1796 548 11193 1074 3075 12615 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4445.1 4753.25 372617 444122 SOO902 106274 43043 4775.82 3697.95 4553.7 4330.95 399155 466687 5074.00 4907.19 4046.17 11025.15 268807 5 5 5 1 3 3 3 3 5 5 5 ER OF CE 4 4 4 4 4 1 5 5 5 1 3 3 3 3 3 1 2 59 57 56 S 854 774 426 B02 308 1003 83 882 948 23 675 os M2 415 1100 1464 1095 O G 69 70 71 72 73 74 0 E 9 0 2 0 0 SS 477583 3692.95 45537 4130.95 399155 4666.87 5974.00 420739 1046 17 1102515 2688.02 2017 140 54 S S SE 1 12/19/19 3/29/20 6/11/20 1/25/20 12/27/15 51117 5/3/16 7/15/12 11/6/16 2/29/20 V1920 10/22/19 7/20/20 1/29/20 9/11/20 W2119 7/11/10 5/27/20 7/13/20 1/19/20 /10/20 12/15/19 2/23/20 12/20/19 7/21/20 2/14/20 7/22/20 3/8/20 7/21/20 4/5/19 152 25 5 491 45 0 52 1 5 2 2 3 2 2 2 2 2 2 2 2 2 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 30 10 30 10 30 30 25 25 25 25 25 25 CE GLE 09 5 20 77 78 79 0 D 0 5 5 CORE 13 189 TE TEE 1 0 100 100 100 100 100 100 5 5 ses PE OR 224 5 5 5 5 5 5 63 3032 674 3216 40R2 434 4399 5301 H262 3905 7054 8644 8916 11844 1272 0 0 0 1 IST 81 82 83 84 1 1 SC 1 1 1 1 1 1 1 1 1 1 1 1 1 0 001 2250.67 25535 2858.61 1856.27 3154.01 170063 15664 1348 1244 1711 1149 1628 1911 &&&&B 333421 2250.67 2553.52 2858.61 1856.27 3154.04 1700.63 1586.4 337355 120391 25013 5 3823333 8888 99 0 0 1 210 5 163 4 140 2 478 5 5 5 5 5 5 5 5 5 SB 66 66 5 5 5 5 25 25 25 25 25 25 99 SSELEE 1 86 87 1081 E DONO 1201.91 99 99 98 2247 1360 E10 S 68