Meeting Title: Weekly-Sprint-Review Date: 2024-01-25 Meeting participants: Ryan Luke Daque, Uttam Kumaran


WEBVTT

1 00:18:30.430 00:18:32.529 Uttam Kumaran: Hello! Hello! Hello!

2 00:18:33.080 00:18:35.520 Uttam Kumaran: Hey! Hi, Otun! How’s it going?

3 00:18:35.580 00:18:39.500 Uttam Kumaran: Hey? Good! How are you? Sorry I was? I’m been trying to unmute for like

4 00:18:39.620 00:18:45.880 Uttam Kumaran: few minutes, but for some reason my laptop was like, I don’t know. I had to quit and come back in.

5 00:18:45.960 00:18:49.520 Ryan Luke Daque: Yeah, no worries. How’s everything going?

6 00:18:50.380 00:19:02.489 Uttam Kumaran: Things are good. yeah, thanks. It’s been a good week. Just been really head sound like focused. Been doing a couple of different sales things last few days.

7 00:19:02.950 00:19:06.169 Uttam Kumaran: and yeah, it’s been good. Yesterday, just

8 00:19:06.310 00:19:13.449 Uttam Kumaran: did a little bit of work. And today, hoping just to close that stuff for tomorrow’s client meeting and then spend the rest of the day on sales. So

9 00:19:14.820 00:19:15.530 Ryan Luke Daque: cool.

10 00:19:16.310 00:19:17.319 Uttam Kumaran: How about you?

11 00:19:18.000 00:19:20.819 Ryan Luke Daque: Yeah. Same thing. There’s there’s a lot of

12 00:19:21.350 00:19:25.359 Ryan Luke Daque: stuff to do. But yeah, I’ve finally been able to.

13 00:19:25.910 00:19:27.650 Ryan Luke Daque: Those are like a few of em.

14 00:19:27.670 00:19:33.680 Ryan Luke Daque: except for the the customer attribution. But yeah, everything’s fine so far.

15 00:19:34.870 00:19:39.130 Uttam Kumaran: How’s it been with like timing this week like, what do you think about?

16 00:19:39.450 00:19:42.449 Uttam Kumaran: the amount of work, and like, how much time you’re spending?

17 00:19:43.200 00:19:51.580 Ryan Luke Daque: yeah, I think it’s pretty fine so far. I’m trying not to push myself so much. I might like

18 00:19:52.800 00:19:53.560 Ryan Luke Daque: egg.

19 00:19:53.920 00:20:00.129 Ryan Luke Daque: you know, spend too much time and get like burnt out, or something, especially like, I’m still also working with a

20 00:20:00.420 00:20:01.510 Ryan Luke Daque: the other

21 00:20:01.600 00:20:03.910 Ryan Luke Daque: clients. Yeah, so yeah.

22 00:20:04.040 00:20:06.980 Ryan Luke Daque: But yeah, everything’s going well so far

23 00:20:07.320 00:20:22.279 Ryan Luke Daque: like the the the the light dash validation took. Took a while like the updates. Actually, like broke a lot of people send dashboards. But yeah, at least now it’s

24 00:20:22.980 00:20:33.060 Ryan Luke Daque: pretty much good to go like everything. There’s still a couple of tables especially like a private ones that I can. That’s

25 00:20:33.470 00:20:35.530 Ryan Luke Daque: but that was yeah.

26 00:20:36.240 00:20:38.540 Ryan Luke Daque: Everything’s looking good so far.

27 00:20:39.460 00:21:02.760 Uttam Kumaran: Okay, great. Yeah. I mean again, II also don’t want you to get burned out. So just just give me a heads up if you’re like, Hey, this is, it’s it’s we’re not. We’re there’s like so much going on. Again. W, we just, we just readjust the sprint. So. But yeah, that makes a lot of sense. Yeah, I know this week is, some of the tasks have been a lot, and even

28 00:21:02.890 00:21:05.549 Uttam Kumaran: I think they’ve all been really like modeling heavy.

29 00:21:05.630 00:21:10.430 Uttam Kumaran: so and then but again, I think the marketing stuff

30 00:21:10.730 00:21:17.230 Uttam Kumaran: so hopefully, that is just a lot more like chill. And it’s all new stuff, anyway, so

31 00:21:17.360 00:21:19.969 Uttam Kumaran: it’s not not a clean up or anything so

32 00:21:22.370 00:21:30.969 Uttam Kumaran: nice. Cool. I don’t know. Do you want to pull up the project board, and maybe we could just talk through. Yeah, sure. Let me share my screen.

33 00:21:36.480 00:21:38.309 Ryan Luke Daque: And can you see my screen now?

34 00:21:41.090 00:21:41.940 Uttam Kumaran: Yes.

35 00:21:44.660 00:21:50.150 Ryan Luke Daque: sure, I guess I can start everything here still in progress. But I guess this is

36 00:21:50.500 00:21:54.310 Ryan Luke Daque: should be in review except for

37 00:21:54.670 00:21:57.080 Ryan Luke Daque: the customer attribution table.

38 00:21:58.540 00:22:00.790 Ryan Luke Daque: So yes.

39 00:22:01.260 00:22:04.269 Ryan Luke Daque: oh, I can. I can only see the Vs code. Actually.

40 00:22:04.320 00:22:08.820 Ryan Luke Daque: Oh, really, let me share again. I guess I

41 00:22:11.950 00:22:15.250 Ryan Luke Daque: a peace sharing

42 00:22:16.760 00:22:18.160 Ryan Luke Daque: the whole screen.

43 00:22:21.680 00:22:23.660 Uttam Kumaran: It’s still just

44 00:22:24.510 00:22:26.000 Ryan Luke Daque: just a vista.

45 00:22:26.010 00:22:30.099 Uttam Kumaran: Well, try to. Yeah, I still only see the Vs code.

46 00:22:30.180 00:22:31.830 Ryan Luke Daque: Yeah, me.

47 00:22:37.500 00:22:38.410 Uttam Kumaran: nice.

48 00:22:39.450 00:22:40.579 Uttam Kumaran: Okay, yeah, that

49 00:22:41.730 00:22:50.450 Ryan Luke Daque: cool. So, yeah. Like, I mentioned. I moved, I just moved these 2 and review the the existing light. Dash validations.

50 00:22:50.690 00:22:53.299 Ryan Luke Daque: I think there’s also one

51 00:22:54.290 00:22:59.320 Ryan Luke Daque: done. That’s the renaming of the key metrics

52 00:22:59.440 00:23:01.280 Uttam Kumaran: somewhere here. Yeah.

53 00:23:01.560 00:23:04.240 Ryan Luke Daque: and estimated

54 00:23:04.870 00:23:07.799 Ryan Luke Daque: shipping cost, which I merged yesterday.

55 00:23:07.980 00:23:08.770 Uttam Kumaran: Okay.

56 00:23:08.880 00:23:13.350 Ryan Luke Daque: so basically, what I did here is initially, I

57 00:23:13.380 00:23:16.020 Ryan Luke Daque: just did a straight average

58 00:23:16.620 00:23:19.390 Uttam Kumaran: on like, based on the zone and weight

59 00:23:19.510 00:23:26.490 Ryan Luke Daque: product type. We really can’t use this because so we’re we’re using the order level.

60 00:23:26.630 00:23:29.379 Ryan Luke Daque: So I didn’t use this in.

61 00:23:29.820 00:23:32.669 Ryan Luke Daque: Yeah, there’s really not other.

62 00:23:32.700 00:23:43.819 Ryan Luke Daque: not enough other details that I can use. So basically, I just did a straight average on a zone and weight and then try to create an estimated

63 00:23:44.120 00:23:48.650 Ryan Luke Daque: should be calls on that one. But that didn’t turn out pretty good.

64 00:23:48.790 00:23:51.489 Uttam Kumaran: That’s because

65 00:23:52.080 00:24:00.489 Ryan Luke Daque: like different weights, have different prices like the the heavier the weight, the the more

66 00:24:00.530 00:24:08.380 Ryan Luke Daque: the shipping cost will also go high. So basically, II went for a period approach.

67 00:24:08.570 00:24:20.460 Ryan Luke Daque: So basically, there’s a price per per weight unit. whether it’s in kilograms or a pound. or like the first 20 kilograms. For example.

68 00:24:20.730 00:24:26.600 Ryan Luke Daque: there’s a price per wake, so you can actually see in my

69 00:24:37.870 00:24:39.340 Ryan Luke Daque: check it out.

70 00:24:44.800 00:24:45.490 Ryan Luke Daque: Yeah.

71 00:24:45.780 00:24:49.059 Ryan Luke Daque: So basically, these are the peers that I added, Yeah.

72 00:24:49.110 00:24:55.349 Ryan Luke Daque: so there’s like one to 5. Then there’s like 5 to 2020 to 40 and and

73 00:24:55.430 00:24:59.499 Ryan Luke Daque: or the above. And then I basically calculated the

74 00:25:00.570 00:25:05.460 Ryan Luke Daque: cost divided by weight, which is going to be the average cost per pound.

75 00:25:06.070 00:25:07.640 Ryan Luke Daque: And this is the average.

76 00:25:07.810 00:25:12.220 Ryan Luke Daque: And then, if I multiply that with the quantity ordered.

77 00:25:12.700 00:25:16.160 Ryan Luke Daque: I should be able to get the so

78 00:25:17.170 00:25:27.519 Ryan Luke Daque: any week. Basically wait would be the estimated shipping cost. And when I tested it and compared it with the actual

79 00:25:28.000 00:25:32.500 Ryan Luke Daque: cost, it was a lot closer and should be

80 00:25:32.780 00:25:33.870 Ryan Luke Daque: pretty great

81 00:25:34.200 00:25:36.419 Uttam Kumaran: with this one. So so

82 00:25:36.550 00:25:41.279 Uttam Kumaran: well. One thing is, I wanted to look at some of the results for this, but we can do at the end of this.

83 00:25:41.820 00:25:45.030 Ryan Luke Daque: Yeah, sure, we can do it now.

84 00:25:46.140 00:25:53.930 Uttam Kumaran: yeah, we can. II actually sent light dash Link, if you, you could probably open that, and that has

85 00:25:56.710 00:25:58.300 Uttam Kumaran: that has.

86 00:26:00.200 00:26:01.660 Uttam Kumaran: Yeah. Oh.

87 00:26:03.370 00:26:09.449 Uttam Kumaran: yeah, try that. This one. I just Ca, just compares the

88 00:26:11.460 00:26:22.430 Uttam Kumaran: the estimated to the actual for the last few days, and I was just going through, and I just wanted to go through

89 00:26:22.480 00:26:25.929 Uttam Kumaran: some of the days that so these are all past days.

90 00:26:26.530 00:26:34.989 Ryan Luke Daque: But I wanted to go through some of the days where there’s a high discrepancy. And just let’s let’s just look at some of the maybe this one.

91 00:26:35.530 00:26:46.200 Uttam Kumaran: So maybe if you can, you maybe just filter to if you go, if you just hit like explore explore from here or whatever. And you could just filter 2% differences that are

92 00:26:46.590 00:26:53.650 Uttam Kumaran: actually, actually, can you do yeah, for sent differences.

93 00:26:54.840 00:26:59.160 Uttam Kumaran: maybe greater than well, actually, if you wanna do

94 00:26:59.610 00:27:05.269 Uttam Kumaran: if you can, you go to the calculation for percent difference. Can you just make it absolute value in there?

95 00:27:05.600 00:27:06.330 Ryan Luke Daque: Yes.

96 00:27:08.390 00:27:11.109 Uttam Kumaran: that way we can just do one filter.

97 00:27:12.180 00:27:13.440 Uttam Kumaran: Yeah, perfect this.

98 00:27:16.660 00:27:25.790 Uttam Kumaran: And then if you want to just filter. So maybe anything above 40, let’s just start with 40%. See, we could just take a look at some orders.

99 00:27:26.050 00:27:31.239 Uttam Kumaran: This actually, really nice. I’m and actually glad this is actually hopefully, just gonna be like, we can just spot check in.

100 00:27:32.260 00:27:35.419 Uttam Kumaran: you have to do 40%, I think.

101 00:27:35.660 00:27:37.610 Ryan Luke Daque: which is kind of weird.

102 00:27:40.020 00:27:43.080 Ryan Luke Daque: I can’t put the percent. So it was just 40.

103 00:27:43.220 00:27:46.360 Uttam Kumaran: I just don’t think it converts it to

104 00:27:48.870 00:27:52.450 Ryan Luke Daque: It’s like

105 00:27:52.520 00:27:56.580 Ryan Luke Daque: this again. is it showing the less important? Yeah, it is.

106 00:27:57.120 00:27:59.600 Uttam Kumaran: Can you go to the sequel. What does it do in the sequel?

107 00:28:02.880 00:28:03.940 Ryan Luke Daque: 0,

108 00:28:08.740 00:28:10.469 Ryan Luke Daque: yeah, maybe basement.

109 00:28:15.180 00:28:15.920 Ryan Luke Daque: Yep.

110 00:28:16.100 00:28:20.210 Uttam Kumaran: Oh, weird. Oh, that’s a good one. Maybe we should send that as a bug.

111 00:28:21.280 00:28:23.470 Ryan Luke Daque: Yeah, probably that’s a good way.

112 00:28:23.750 00:28:25.549 Uttam Kumaran: Okay, I’ll send it later.

113 00:28:25.840 00:28:39.240 Uttam Kumaran: Yeah. So maybe on this one, if you maybe if you just want to. Bring in the order details, which is like the skew, the weight or not, the skew, just the weight and the zone.

114 00:28:39.820 00:28:40.670 Ryan Luke Daque: Yeah.

115 00:28:47.380 00:28:49.909 Uttam Kumaran: you could do it right in in the light dash.

116 00:28:50.090 00:28:50.960 Ryan Luke Daque: Oh, really.

117 00:28:51.230 00:28:59.720 Uttam Kumaran: yeah, can I like just change? No, no, no meaning. You can bring in the wait and the zone, the dimensions. Yeah.

118 00:29:02.650 00:29:05.280 Uttam Kumaran: which it’s all I should all be in shipping, I think.

119 00:29:08.760 00:29:09.610 Ship name

120 00:29:11.310 00:29:12.370 Ryan Luke Daque: 8.

121 00:29:13.410 00:29:14.650 Uttam Kumaran: Shouldn’t wait

122 00:29:14.780 00:29:15.450 Ryan Luke Daque: so.

123 00:29:16.830 00:29:17.980 Uttam Kumaran: and then

124 00:29:18.180 00:29:21.939 Uttam Kumaran: zone. And then can you also do? Can you also do service

125 00:29:22.490 00:29:23.750 Uttam Kumaran: category.

126 00:29:24.730 00:29:26.719 Ryan Luke Daque: 6 category.

127 00:29:27.080 00:29:28.720 Uttam Kumaran: It’s above shipment weight.

128 00:29:29.670 00:29:30.340 Ryan Luke Daque: Oh.

129 00:29:30.660 00:29:33.889 Uttam Kumaran: service code category, yeah.

130 00:29:34.040 00:29:36.079 Uttam Kumaran: Yeah, that should be good.

131 00:29:41.570 00:29:46.569 Uttam Kumaran: oh, you’re gonna have to remove percent difference.

132 00:29:46.960 00:29:49.590 Uttam Kumaran: Oh, it’s gonna be okay.

133 00:29:50.090 00:29:53.909 Uttam Kumaran: wait. No, no, that shouldn’t. That should stay the same right?

134 00:29:55.610 00:29:57.919 Ryan Luke Daque: It should be visits. We just added a

135 00:30:02.940 00:30:10.940 Uttam Kumaran: can you? Can you filter to only orders with where shipment weight is greater than 0? It’s probably warranties.

136 00:30:12.940 00:30:17.430 Uttam Kumaran: So if if you add a filter for shipment weight.

137 00:30:21.930 00:30:24.040 Uttam Kumaran: And then you can just say greater than 0

138 00:30:36.460 00:30:42.769 Uttam Kumaran: the only business

139 00:30:42.950 00:30:45.470 Ryan Luke Daque: maybe we can

140 00:30:47.020 00:30:49.849 Ryan Luke Daque: what’s what’s the safe divide in

141 00:30:50.850 00:30:53.809 Ryan Luke Daque: snowflake is, if you did 0 or something.

142 00:30:54.560 00:30:59.449 Uttam Kumaran: It is the 0, I think.

143 00:31:01.210 00:31:02.040 Ryan Luke Daque: Oh, man.

144 00:31:10.680 00:31:12.369 Uttam Kumaran: that’s kind of weird.

145 00:31:14.820 00:31:20.310 Uttam Kumaran: maybe.

146 00:31:27.020 00:31:27.910 Uttam Kumaran: Huh!

147 00:31:32.880 00:31:35.050 Ryan Luke Daque: Sky moving one again.

148 00:31:53.360 00:31:55.890 Uttam Kumaran: Oh, it’s now you put. There’s a comma.

149 00:31:57.370 00:31:58.979 Uttam Kumaran: See between

150 00:32:00.350 00:32:02.180 Uttam Kumaran: it’s absolutely. It needs to be

151 00:32:02.440 00:32:05.660 Uttam Kumaran: does that change

152 00:32:08.240 00:32:21.119 Uttam Kumaran: so and then there’s another parentheses.

153 00:32:26.290 00:32:31.720 Uttam Kumaran: no, no, no, no, not that not the end. I’m in in front of all orders.

154 00:32:32.280 00:32:35.340 Uttam Kumaran: Yeah, if no, no, no, I delete that one

155 00:32:35.570 00:32:39.239 Uttam Kumaran: it’s a after the div after the division sign.

156 00:32:39.580 00:32:40.340 Ryan Luke Daque: Yeah.

157 00:32:40.450 00:32:41.730 Uttam Kumaran: pointing right?

158 00:32:42.730 00:32:44.680 Uttam Kumaran: But less of the dollar sign.

159 00:32:44.880 00:32:45.830 Uttam Kumaran: Yeah.

160 00:32:46.040 00:32:48.639 Uttam Kumaran: Yeah. The other way.

161 00:32:52.610 00:32:55.899 Uttam Kumaran: No, no, no. Meaning. Yeah, that way. Yeah. Yeah.

162 00:32:57.130 00:33:00.770 Uttam Kumaran: But you don’t you? There’s already one on the right side. I think.

163 00:33:03.510 00:33:04.260 Uttam Kumaran: Yeah.

164 00:33:21.140 00:33:26.829 Uttam Kumaran: Yeah. So you’re getting you’re getting division by 0. But that’s because all orders estimated shipping cost

165 00:33:27.450 00:33:34.369 Uttam Kumaran: or the yeah. The all the all orders estimated shipping cost is gonna be is for some reason, 0 in some cases.

166 00:33:34.830 00:33:35.500 Ryan Luke Daque: Hmm!

167 00:33:36.710 00:33:37.859 Ryan Luke Daque: Why wasn’t it

168 00:33:39.850 00:33:41.160 Ryan Luke Daque: cause we?

169 00:33:42.360 00:33:44.520 Ryan Luke Daque: We included these.

170 00:33:44.840 00:33:49.140 Uttam Kumaran: but I don’t know why it shouldn’t. There shouldn’t be anything where it’s 0.

171 00:33:49.980 00:34:04.209 Uttam Kumaran: But can you just do like a in the calculation, can you? Just you can you div 0 the ho, that whole thing or no.

172 00:34:05.320 00:34:06.550 Uttam Kumaran: that not work.

173 00:34:08.929 00:34:10.409 Ryan Luke Daque: You mean in

174 00:34:10.860 00:34:13.870 Uttam Kumaran: in percent difference.

175 00:34:14.790 00:34:15.480 Uttam Kumaran: Okay?

176 00:34:18.280 00:34:28.659 Uttam Kumaran: Yeah, I think I just think you could probably try Div. 0 now that all the parentheses are all fine. just you could just div oh, what is it? Is it. What is the formula for? Div. 0.

177 00:34:31.110 00:34:34.299 Ryan Luke Daque: I think it’s just this one. And instead of the.

178 00:34:36.620 00:34:41.049 Ryan Luke Daque: that’s why this whole thing.

179 00:34:45.860 00:34:47.050 Ryan Luke Daque: Oh, it’s

180 00:34:55.520 00:34:56.589 Ryan Luke Daque: yeah. There you go.

181 00:34:57.330 00:34:58.580 Uttam Kumaran: Okay, great.

182 00:34:59.270 00:35:00.519 Ryan Luke Daque: And so well.

183 00:35:03.070 00:35:07.609 Uttam Kumaran: So now, can you bring in the service category

184 00:35:11.720 00:35:13.620 Uttam Kumaran: and then on the chart?

185 00:35:16.890 00:35:22.269 Uttam Kumaran: Let’s find out where the differences are. So first, let’s graph.

186 00:35:23.100 00:35:30.110 Uttam Kumaran: can you actually do not percent difference, but just dollar difference.

187 00:35:31.580 00:35:33.569 Uttam Kumaran: a as another calculation.

188 00:35:39.150 00:35:46.909 Uttam Kumaran: So what we’re gonna do is just yeah, take the difference between an estimated and then I wanna I wanna be able to see where all of the difference

189 00:35:47.320 00:35:49.390 Uttam Kumaran: is accumulating from

190 00:35:54.920 00:35:57.910 Uttam Kumaran: the the absolute value. There’s an extra parentheses.

191 00:36:04.030 00:36:09.840 Uttam Kumaran: And then if you want to chart. oh, yeah, if you want to chart

192 00:36:12.010 00:36:14.290 Uttam Kumaran: yeah, you could just do.

193 00:36:15.790 00:36:25.650 Uttam Kumaran: actually, you don’t even need to do a bar chart you could just get rid of the day. Could just hide the day. Yeah. or yeah.

194 00:36:27.280 00:36:36.800 Uttam Kumaran: when you when you run it, does it aggregate, or what happens now?

195 00:36:46.120 00:36:49.889 Uttam Kumaran: Yeah, just so. Just hide, hide, hide, shipment weight, and then hide

196 00:36:56.710 00:36:59.660 Uttam Kumaran: and hide zone.

197 00:37:00.850 00:37:02.779 Uttam Kumaran: and then see if you can run it again.

198 00:37:03.440 00:37:08.439 Ryan Luke Daque: So you’re you’re wondering. Maybe it’s has to do with the

199 00:37:08.770 00:37:09.760 Ryan Luke Daque: different.

200 00:37:10.720 00:37:12.910 Uttam Kumaran: We’ll see it’s not aggregating.

201 00:37:13.590 00:37:16.149 Ryan Luke Daque: I guess we can remove them here.

202 00:37:17.140 00:37:24.089 Uttam Kumaran: So it aggregates. Yeah, let’s do that. So let’s just get rid of order, date. shipment, weight and zone.

203 00:37:32.160 00:37:35.000 Uttam Kumaran: Yep, so I want to see where it’s accumulating, too

204 00:37:38.730 00:37:46.019 Uttam Kumaran: uncategorized. Okay, but that’s okay. So we’re really inflating uncategorized.

205 00:37:47.100 00:37:52.109 Uttam Kumaran: So so maybe if you wanna can, we you I could just take some notes in slack.

206 00:37:52.560 00:38:05.510 Uttam Kumaran: And that way we can come back and take a look at this have to do today. I just or just wanna make sure it’s it’s a little bit closer. So one is on categorized

207 00:38:07.750 00:38:11.140 Uttam Kumaran: service category.

208 00:38:11.340 00:38:16.250 Ryan Luke Daque: The uncategorized is the highest in terms of percent difference. Percent

209 00:38:17.150 00:38:19.700 Ryan Luke Daque: ups the one bets of time.

210 00:38:19.880 00:38:20.830 Ryan Luke Daque: yeah.

211 00:38:22.140 00:38:24.549 Ryan Luke Daque: or actually on what’s on.

212 00:38:27.110 00:38:32.500 Ryan Luke Daque: Wish. Fedex, I thought I saw Fedex and Usps.

213 00:38:35.360 00:38:37.430 Uttam Kumaran: Oh, I guess

214 00:38:37.830 00:38:43.880 Ryan Luke Daque: it’s the percent difference for filter now is like, gonna be tougher.

215 00:38:44.190 00:38:49.450 Uttam Kumaran: hmm!

216 00:38:50.320 00:38:54.469 Uttam Kumaran: Actually. no, no. What what I think we should do is

217 00:38:58.530 00:39:02.969 Uttam Kumaran: can you add those those dimensions back? And let’s just do a bar chart.

218 00:39:07.490 00:39:11.829 Uttam Kumaran: And we were doing order date right? And yeah, don’t don’t worry about date.

219 00:39:13.180 00:39:16.059 Uttam Kumaran: So if you hit run and then let’s do a bar chart.

220 00:39:22.700 00:39:26.590 Uttam Kumaran: and then you can get rid of yeah, just category. And then

221 00:39:27.020 00:39:30.590 Uttam Kumaran: you could just do you could just do difference the dollar sign difference.

222 00:39:36.430 00:39:37.940 Uttam Kumaran: and then don’t group it.

223 00:39:40.660 00:39:41.709 Uttam Kumaran: There it is.

224 00:39:44.740 00:39:46.430 Uttam Kumaran: Hit. Run again.

225 00:39:51.820 00:39:52.710 Uttam Kumaran: Yeah.

226 00:39:56.690 00:39:59.459 Uttam Kumaran: So Fedex is the highest.

227 00:40:01.190 00:40:02.650 Ryan Luke Daque: Also, let’s

228 00:40:03.210 00:40:09.389 Uttam Kumaran: let’s just filter. Let’s start with just Fedex. If you just filter to Fedex category.

229 00:40:12.600 00:40:18.390 Uttam Kumaran: So also, what you can do is you can hit shipment service category. The column on the bottom

230 00:40:19.750 00:40:24.559 Uttam Kumaran: if you hit the if you hit the the little, the arrow not in the results, area

231 00:40:26.160 00:40:29.490 Uttam Kumaran: in the in the results set.

232 00:40:30.380 00:40:34.799 Uttam Kumaran: If you hit the little carrot. you can actually hit filter from here.

233 00:40:36.050 00:40:38.919 Uttam Kumaran: Yeah, just in case it’s a little quicker.

234 00:40:40.380 00:40:42.710 Uttam Kumaran: And if you just want to filter to Fedex.

235 00:40:54.640 00:41:02.160 Uttam Kumaran: and then let’s actually just do it based on zone. Now. So if you change the X access to zone.

236 00:41:13.020 00:41:16.149 Ryan Luke Daque: okay, it’s pretty even pretty, even.

237 00:41:16.650 00:41:19.540 Uttam Kumaran: Can you now do it? Based on

238 00:41:20.580 00:41:26.310 Uttam Kumaran: shipment way the shipment weights gonna be tough because we may want to do it based on rounded shipment weight.

239 00:41:26.570 00:41:27.280 Ryan Luke Daque: Yeah?

240 00:41:27.690 00:41:32.499 Uttam Kumaran: Or are you? Wanna you honestly want your weight category, right? Your tiers.

241 00:41:32.560 00:41:36.939 Ryan Luke Daque: Yeah, we can add the 2 years ago. So I believe, I added, the teams.

242 00:41:39.240 00:41:46.390 Uttam Kumaran: you can even round you can even round the ship. Yeah, I don’t, or I don’t know if you added the tiers here, but I don’t think you did.

243 00:41:46.480 00:41:48.080 Ryan Luke Daque: Oh, I didn’t. Yeah.

244 00:41:49.460 00:41:54.469 Uttam Kumaran: yeah, maybe we can. I can change the tiers to.

245 00:41:55.060 00:42:00.980 Ryan Luke Daque: because this is quite wide, if you like. 5 to 20 might be to.

246 00:42:02.190 00:42:06.280 Ryan Luke Daque: So that. So that’s so, that’s what I’m trying to look at is like.

247 00:42:06.330 00:42:12.929 Uttam Kumaran: Why don’t actually why don’t you just copy this in

248 00:42:13.820 00:42:18.539 Uttam Kumaran: as a calculation, and then just change shipment weight to reference the column.

249 00:42:20.640 00:42:21.600 Ryan Luke Daque: What is that

250 00:42:22.790 00:42:27.230 Uttam Kumaran: like if you copy this? The SQL. In for a case

251 00:42:27.730 00:42:30.770 Uttam Kumaran: into a calculator field.

252 00:42:34.340 00:42:35.270 Ryan Luke Daque: So here.

253 00:42:35.580 00:42:37.929 Uttam Kumaran: Umhm, and then just change

254 00:42:37.970 00:42:39.460 Uttam Kumaran: shipment weight to

255 00:42:41.100 00:42:44.589 Uttam Kumaran: yep. And then maybe you just copy paste that whole thing

256 00:43:00.360 00:43:08.870 Uttam Kumaran: you probably don’t need to end as

257 00:43:12.960 00:43:15.450 Uttam Kumaran: yeah, yeah, that’s good.

258 00:43:17.740 00:43:20.670 Uttam Kumaran: Now, let’s change the X axis to tier.

259 00:43:27.350 00:43:28.480 Uttam Kumaran: Yeah, run

260 00:43:32.330 00:43:34.170 Uttam Kumaran: a

261 00:43:36.220 00:43:37.020 Uttam Kumaran: but

262 00:43:49.950 00:43:52.320 Uttam Kumaran: but

263 00:43:53.610 00:43:55.100 Ryan Luke Daque: but it’s shown here.

264 00:43:55.980 00:43:58.540 Uttam Kumaran: Yeah, so can you.

265 00:44:00.780 00:44:03.139 Uttam Kumaran: Can you get rid of or

266 00:44:05.330 00:44:06.879 Uttam Kumaran: get rid of zone.

267 00:44:12.480 00:44:17.969 Uttam Kumaran: And then also, can you can you include more results? It just says 500 on the top. Right.

268 00:44:20.110 00:44:22.440 Uttam Kumaran: Wait, I see that run? Query.

269 00:44:22.680 00:44:24.000 Ryan Luke Daque: Oh, Gotcha.

270 00:44:24.760 00:44:27.109 Uttam Kumaran: just do 5,000. Yeah.

271 00:44:30.790 00:44:33.330 Ryan Luke Daque: it’s it doesn’t.

272 00:44:33.900 00:44:35.489 Ryan Luke Daque: Maybe we can.

273 00:44:40.120 00:44:41.320 Uttam Kumaran: What?

274 00:44:46.140 00:44:47.560 Ryan Luke Daque: Maybe

275 00:44:48.420 00:44:51.640 Uttam Kumaran: you can’t have a X axis be a calculated field.

276 00:44:53.300 00:44:55.020 Ryan Luke Daque: Try to dial up differently

277 00:45:02.840 00:45:04.060 doesn’t look like.

278 00:45:07.090 00:45:07.830 Uttam Kumaran: hmm.

279 00:45:14.690 00:45:15.380 Ryan Luke Daque: that

280 00:45:17.020 00:45:20.220 Ryan Luke Daque: it works

281 00:45:20.760 00:45:22.989 Ryan Luke Daque: the tier 4 is the biggest.

282 00:45:23.050 00:45:26.450 Uttam Kumaran: Okay, so let’s let’s modify it. Now.

283 00:45:27.530 00:45:31.139 Ryan Luke Daque: yeah, cause like 2,000.

284 00:45:31.370 00:45:33.079 Ryan Luke Daque: And if you look at my

285 00:45:33.210 00:45:36.590 Ryan Luke Daque: queries just like 14 above. Yes.

286 00:45:36.680 00:45:45.480 Ryan Luke Daque: so I guess we I can add more tiers like until this thousands, I guess right? Because this is really

287 00:45:46.410 00:45:47.550 Uttam Kumaran: huge.

288 00:45:48.310 00:45:53.079 Uttam Kumaran: So can we go back to the wait? Can we go back to the logic again?

289 00:45:56.810 00:45:57.590 Ryan Luke Daque: This one?

290 00:46:00.870 00:46:02.669 Ryan Luke Daque: This is basically just

291 00:46:03.150 00:46:09.940 Uttam Kumaran: so you’re finding the average cost per pound per week. Yeah, it’s gonna be really, really off. Yeah.

292 00:46:11.240 00:46:18.900 Uttam Kumaran: because the average cost for pot for something that’s 50 pounds is gonna be way different. Something that’s 300 pounds.

293 00:46:18.960 00:46:22.790 Ryan Luke Daque: So I guess I can. I can add more tiers or something.

294 00:46:23.300 00:46:29.349 Uttam Kumaran: I wonder if we add more tiers or

295 00:46:30.410 00:46:40.580 Uttam Kumaran: I know it’s honestly good suggestion for AI to ask what the what we could do.

296 00:46:41.440 00:46:47.310 Ryan Luke Daque: Yeah, II actually did. I use like chat. Gp, to like, do some

297 00:46:48.910 00:46:53.280 Ryan Luke Daque: I wonder if you can ask it for? Tell it like.

298 00:46:53.830 00:46:55.969 Uttam Kumaran: yeah, we found out that.

299 00:46:57.840 00:46:59.550 Uttam Kumaran: we realized that

300 00:47:00.350 00:47:05.770 Uttam Kumaran: we needed more tiers because we have products ranging higher weights.

301 00:47:06.310 00:47:10.210 Ryan Luke Daque: Yeah. yeah, that makes sense. But

302 00:47:10.900 00:47:17.060 Ryan Luke Daque: yeah, I can. We can do that. I can try updating this. But what’s like our

303 00:47:17.240 00:47:18.160 Ryan Luke Daque: target.

304 00:47:18.460 00:47:28.140 Ryan Luke Daque: like 40, if it’s within 20.

305 00:47:29.510 00:47:37.259 Ryan Luke Daque: Yeah, I can figure that out like, modify. Let’s just modify a couple of these, and let’s see

306 00:47:37.360 00:47:38.680 Uttam Kumaran: if it works.

307 00:47:40.130 00:47:47.370 Uttam Kumaran: I don’t want to spend a ton of time more on this right now and then. What we can also do is.

308 00:47:47.490 00:47:53.170 Uttam Kumaran: yeah, that’s I think that’s your. The logic you have is actually, really, really good. I just think

309 00:47:53.230 00:47:55.150 Uttam Kumaran: we need more tiers.

310 00:47:55.310 00:47:56.830 Ryan Luke Daque: Yeah, I agree.

311 00:47:57.630 00:48:09.909 Uttam Kumaran: yeah, that’s honestly pretty much it cause we have some stuff that’s like 2,000 pounds things like that like 4,000. Even. So, this is probably

312 00:48:09.990 00:48:17.850 Uttam Kumaran: it’s gonna be. So. There’s honestly probably some function that you can write that that linearly scales the cost

313 00:48:18.860 00:48:24.239 Uttam Kumaran: based on the weight. but which is, which is pretty much what you’re doing right?

314 00:48:24.580 00:48:27.490 Ryan Luke Daque: Right? But this is just way to

315 00:48:27.600 00:48:29.909 Uttam Kumaran: oh, yeah, it’s

316 00:48:30.020 00:48:35.309 Uttam Kumaran: yeah. It’s like, I don’t know what that factor is at the moment which we can figure out.

317 00:48:35.350 00:48:37.820 Uttam Kumaran: But for now I would suggest.

318 00:48:38.200 00:48:43.530 Uttam Kumaran: I mean, honestly, either you could write. You could write a Dvt macro that does this

319 00:48:43.660 00:48:45.000 Uttam Kumaran: or.

320 00:48:45.090 00:48:47.120 Uttam Kumaran: yeah, just add a bunch more tiers.

321 00:48:49.080 00:48:50.919 Ryan Luke Daque: I mean the the closer

322 00:48:51.240 00:48:58.220 Ryan Luke Daque: I guess the best way I mean the the the more granular the tier the better. With that

323 00:48:59.750 00:49:05.579 Ryan Luke Daque: I didn’t make up a lot of stuff. But yeah, maybe we, I can utilize a macro for that.

324 00:49:06.190 00:49:10.090 Uttam Kumaran: Yeah. And you can say, Hey, I want to do increment. I wanna do increments of

325 00:49:10.680 00:49:19.130 Ryan Luke Daque: 10,000, whatever the high is.

326 00:49:19.320 00:49:27.460 Uttam Kumaran: I mean, I guess that’s the thing. It’s it’s tough cause. Otherwise, what I would say, is like we should do analysis to find out how.

327 00:49:28.290 00:49:31.230 Uttam Kumaran: what, how does weight scale with cost?

328 00:49:31.550 00:49:36.569 Uttam Kumaran: And we should use the scale which is on which it should be on a pound basis. Right?

329 00:49:36.660 00:49:41.369 Ryan Luke Daque: Yeah. Looks like the highest we have here is like 4,000 pounds, so should be.

330 00:49:42.130 00:49:42.890 Ryan Luke Daque: But in.

331 00:49:44.130 00:49:49.439 Uttam Kumaran: But it’s like, see, the estimated is so high is way higher than the the total.

332 00:49:50.960 00:49:54.829 Uttam Kumaran: and maybe E, even that total like I don’t know what’s going on.

333 00:49:57.400 00:50:01.990 Ryan Luke Daque: Maybe it has to do with the product type as well. Right?

334 00:50:02.330 00:50:04.670 Ryan Luke Daque: Like, maybe an electronic.

335 00:50:05.340 00:50:11.539 Uttam Kumaran: That’s the thing for for product type and stuff. II would. I don’t care. As long as we’re within 20%,

336 00:50:11.690 00:50:18.980 Uttam Kumaran: right? We could. That’s the main thing. So let yeah, let’s see, maybe I have tiers, and we can see how far we get. Okay, sounds good.

337 00:50:19.530 00:50:26.500 Uttam Kumaran: If you want to go back to projects, maybe we can just clean up. See what else we can close out.

338 00:50:27.150 00:50:28.720 Ryan Luke Daque: I guess this one we can.

339 00:50:29.390 00:50:31.300 Uttam Kumaran: Yeah, let’s close that one out.

340 00:50:34.830 00:50:39.890 Uttam Kumaran: and then let’s close the Amazon refunds.

341 00:50:43.820 00:50:49.670 Uttam Kumaran: Can you create a ticket in the backlog for Amazon fees, modeling.

342 00:50:51.630 00:50:56.379 Uttam Kumaran: Just say Amazon fees from 5 tran. yeah, or something like that.

343 00:51:01.980 00:51:06.210 Uttam Kumaran: Great and then

344 00:51:11.090 00:51:13.420 Uttam Kumaran: I think that’s the

345 00:51:15.800 00:51:21.520 Uttam Kumaran: that’s pretty much it for me. I’m gonna be working on some of this other stuff. Somebody’s emails today. So

346 00:51:24.470 00:51:30.820 Ryan Luke Daque: from my end as well like, I started working on this, and it looks like we can utilize actually, the

347 00:51:31.250 00:51:37.070 Ryan Luke Daque: 5 trends DBT. Package, for at thesis Shopify customers.

348 00:51:37.410 00:51:41.189 Ryan Luke Daque: it actually already pretty has pretty much has

349 00:51:41.810 00:51:45.980 Ryan Luke Daque: everything, for instance. But

350 00:51:46.110 00:51:51.410 Ryan Luke Daque: I think the more challenging part here is the attribution, because I’m trying to

351 00:51:51.620 00:51:58.190 Ryan Luke Daque: find a way to like, join the tables from Google ads into shopify.

352 00:51:58.280 00:52:06.040 Uttam Kumaran: And like, yeah, this is like the more challenging point. So I’m still trying to figure out like the best way we can

353 00:52:06.410 00:52:07.400 Ryan Luke Daque: merge.

354 00:52:07.800 00:52:11.890 Uttam Kumaran: So if you if you can go to the shopify business table

355 00:52:14.080 00:52:15.580 Ryan Luke Daque: customer visiting.

356 00:52:16.580 00:52:18.629 Uttam Kumaran: yeah, shopify customer visits.

357 00:52:36.410 00:52:38.459 Uttam Kumaran: And if you could just preview it

358 00:52:41.680 00:52:47.649 Uttam Kumaran: like see above a custody app up to the left to that. See the little magnifying glass?

359 00:52:47.830 00:52:50.259 Uttam Kumaran: No, no, no! If you actually click the magnifying glass

360 00:52:50.960 00:52:55.039 Ryan Luke Daque: nearest it says, 79.8 K. Rows.

361 00:52:55.200 00:52:56.120 Uttam Kumaran: Yeah.

362 00:52:57.740 00:53:07.460 Ryan Luke Daque: first, the last. I guess we can

363 00:53:07.570 00:53:11.570 Uttam Kumaran: use the landing page to to if you keep scrolling right?

364 00:53:15.050 00:53:17.220 Ryan Luke Daque: You’re gonna see where it came from.

365 00:53:17.300 00:53:22.370 Ryan Luke Daque: I see. So yeah, I guess we can use this. This should be nice.

366 00:53:22.610 00:53:26.349 Uttam Kumaran: And then if you keep keep scrolling right? Let’s see what else they got.

367 00:53:37.720 00:53:40.550 Uttam Kumaran: Sam. I just take some analysis of this table.

368 00:53:41.190 00:53:45.719 Uttam Kumaran: Also, there’s tables in in the in shopify staging.

369 00:53:49.910 00:53:50.760 Uttam Kumaran: that’s all.

370 00:53:50.920 00:53:55.749 Uttam Kumaran: Yeah. So you should see a lot of the logic they do to build.

371 00:53:55.970 00:53:56.840 Ryan Luke Daque: Yeah.

372 00:53:57.220 00:54:00.150 Uttam Kumaran: So in case you need it, it’s also here, too.

373 00:54:00.590 00:54:03.190 Ryan Luke Daque: Yeah, we can actually see there.

374 00:54:04.510 00:54:07.109 Ryan Luke Daque: models here.

375 00:54:07.620 00:54:08.760 Uttam Kumaran: Yeah.

376 00:54:09.810 00:54:22.259 Ryan Luke Daque: I was wondering if maybe we can like, instead of instead of having the 5 trend do the data transformation. We do the data transformation in.

377 00:54:22.690 00:54:30.939 Uttam Kumaran: Yeah, we could do it. I mean, again, if you can. If you can mimic it, then we will just transition to our own.

378 00:54:31.400 00:54:37.909 Ryan Luke Daque: just have to add the package here, like in packages, I guess.

379 00:54:38.490 00:54:40.650 Ryan Luke Daque: Just like. And then over and then override it.

380 00:54:42.200 00:54:43.590 Ryan Luke Daque: We can.

381 00:54:44.700 00:54:48.540 Ryan Luke Daque: So the model should be in here right in the dB packages.

382 00:54:49.350 00:54:52.530 Uttam Kumaran: But then, would you? Would you just override it from there?

383 00:54:53.460 00:54:57.620 Ryan Luke Daque: We can create our own, like models on top of them.

384 00:54:59.550 00:55:02.639 Ryan Luke Daque: But now they now they exist as tables, right?

385 00:55:02.880 00:55:08.049 Uttam Kumaran: Yeah, like here. Oh, so you’re saying, just have them here, so we can modify the logic.

386 00:55:08.940 00:55:12.210 Ryan Luke Daque: I guess we can do that. Yeah.

387 00:55:12.920 00:55:16.310 I guess like it. It depends on what you’re trying to modify. Like.

388 00:55:16.540 00:55:17.350 Ryan Luke Daque: yes.

389 00:55:19.380 00:55:32.310 Ryan Luke Daque: Well, yeah, as long as we have the the see. If we can get to a base version today, just on top of the visits.

390 00:55:32.370 00:55:33.650 Uttam Kumaran: And then

391 00:55:33.980 00:55:35.230 Uttam Kumaran: we can go from there

392 00:55:35.450 00:55:36.450 Ryan Luke Daque: sounds good.

393 00:55:36.890 00:55:38.560 Ryan Luke Daque: Yeah. Should be great.

394 00:55:40.140 00:55:41.600 Uttam Kumaran: Okay, cool.

395 00:55:42.750 00:56:04.290 Uttam Kumaran: Okay. So I’ll I’ll probably chat with you later today or tomorrow. And then, yeah, let’s just this week. Just let me know. We’ll try. Not if we push something. Let’s try to push it today, and before the end of the day we can make sure everything has is ready, and then we can get back to stuff after the call tomorrow morning. My time.

396 00:56:05.020 00:56:05.940 Ryan Luke Daque: Thanks.

397 00:56:06.100 00:56:08.449 Uttam Kumaran: Okay, perfect. Let me know if you need anything.

398 00:56:09.020 00:56:09.790 Ryan Luke Daque: Sure.

399 00:56:10.120 00:56:12.729 Uttam Kumaran: Okay, have a nice day. Bye, bye, you, too.