Meeting Title: Check on LMNT progress Date: 2026-03-27 Meeting participants: Amber Lin, Advait Nandakumar Menon
WEBVTT
1 00:02:52.320 ⇒ 00:02:53.420 Amber Lin: Hello, hello!
2 00:02:54.930 ⇒ 00:02:55.729 Advait Nandakumar Menon: How’s it going?
3 00:02:56.050 ⇒ 00:03:00.280 Amber Lin: I’m doing good. I just had lunch. I’m just reading through the model.
4 00:03:01.080 ⇒ 00:03:01.840 Advait Nandakumar Menon: Okay.
5 00:03:02.060 ⇒ 00:03:02.510 Amber Lin: Yeah.
6 00:03:02.510 ⇒ 00:03:05.049 Advait Nandakumar Menon: Funny enough, I haven’t had my lungs yet.
7 00:03:05.050 ⇒ 00:03:11.430 Amber Lin: It’s 1 o’clock for me. It’s 4PM for you! Wait, 3 p.m 4PM?
8 00:03:11.430 ⇒ 00:03:14.699 Advait Nandakumar Menon: Yeah. Yeah, it’s gonna be 4PM soon.
9 00:03:15.240 ⇒ 00:03:19.689 Amber Lin: Man, okay, after this, you should just get off work, because you work…
10 00:03:19.690 ⇒ 00:03:26.709 Advait Nandakumar Menon: It’s… it’s not… I’m just trying to catch, of course, you know, how it is first couple of days, so…
11 00:03:26.710 ⇒ 00:03:36.669 Amber Lin: Yeah, I promise it won’t be like this. I feel like when I first started, I also worked until, like, 8-ish, and that is not sustainable, but…
12 00:03:37.650 ⇒ 00:03:40.810 Amber Lin: Hopefully, it will soon be regular hour days.
13 00:03:41.350 ⇒ 00:03:48.659 Advait Nandakumar Menon: Yeah, yeah. Well, it’s… it’s fine, I guess, because I usually have a late lunch as well, so… Okay. Yeah.
14 00:03:48.660 ⇒ 00:03:49.890 Amber Lin: Okay, that’s good.
15 00:03:51.840 ⇒ 00:03:52.300 Advait Nandakumar Menon: Come on!
16 00:03:52.300 ⇒ 00:03:54.229 Amber Lin: Let’s read through this.
17 00:03:54.500 ⇒ 00:03:59.010 Advait Nandakumar Menon: Yeah, so just quickly, before, I had a…
18 00:03:59.020 ⇒ 00:04:06.689 Advait Nandakumar Menon: brief call with Avesh, and he really needed some things from me, like which field to use measures, and he was…
19 00:04:06.700 ⇒ 00:04:22.670 Advait Nandakumar Menon: not particularly concerned about the first two metrics, that is the sales velocity, and peaks of stock. It’s the sell-through period he wasn’t sure of, which we both of us confirmed it’s gonna be at the daily level, the daily grain. So, I was…
20 00:04:22.950 ⇒ 00:04:30.179 Advait Nandakumar Menon: I haven’t yet sent anything to him, but he already built out a model, I guess, and he pushed a PR, so I was surprised.
21 00:04:30.300 ⇒ 00:04:31.690 Advait Nandakumar Menon: About that, so I just wanted…
22 00:04:31.690 ⇒ 00:04:33.800 Amber Lin: I see, I see. I think he…
23 00:04:33.800 ⇒ 00:04:34.180 Advait Nandakumar Menon: yet.
24 00:04:34.180 ⇒ 00:04:41.269 Amber Lin: Like, he probably generated this and edited it really fast, and that’s why we’re, like, reading it right now.
25 00:04:41.270 ⇒ 00:04:41.960 Advait Nandakumar Menon: Okay.
26 00:04:41.960 ⇒ 00:04:43.000 Amber Lin: Yeah, I…
27 00:04:43.000 ⇒ 00:04:43.839 Advait Nandakumar Menon: I was just letting…
28 00:04:43.840 ⇒ 00:04:46.110 Amber Lin: Something grains.
29 00:04:46.970 ⇒ 00:04:49.700 Advait Nandakumar Menon: Okay. Yeah, I was just worried because I didn’t…
30 00:04:49.800 ⇒ 00:04:54.669 Advait Nandakumar Menon: Send it yet, anything, I mean, he generated the model already, so… Yeah, yeah. Okay, okay.
31 00:04:55.090 ⇒ 00:05:00.049 Amber Lin: Cause I think we want to get this in by the end of today, because it’s already Friday.
32 00:05:00.220 ⇒ 00:05:02.650 Amber Lin: Yeah, so let’s… let’s see.
33 00:05:03.650 ⇒ 00:05:04.540 Amber Lin: Fourth?
34 00:05:04.660 ⇒ 00:05:09.719 Amber Lin: Does these metric… like, first, does these metric names…
35 00:05:09.990 ⇒ 00:05:17.030 Amber Lin: Makes sense? Like, should this be called… Like, daily sales?
36 00:05:18.760 ⇒ 00:05:19.480 Amber Lin: How do I do?
37 00:05:19.480 ⇒ 00:05:20.480 Advait Nandakumar Menon: Boom.
38 00:05:25.240 ⇒ 00:05:31.440 Amber Lin: Like, shouldn’t this be… To… to make it a bit more… Like…
39 00:05:31.710 ⇒ 00:05:35.820 Amber Lin: Daily? Should it be, like, daily sales velocity?
40 00:05:37.520 ⇒ 00:05:38.630 Amber Lin: I don’t know.
41 00:05:40.210 ⇒ 00:05:40.780 Advait Nandakumar Menon: but…
42 00:05:40.780 ⇒ 00:05:42.669 Amber Lin: Like, this makes it feel like…
43 00:05:43.390 ⇒ 00:05:49.889 Amber Lin: I just don’t know if people will interpret it on a daily grain or weekly brain, but maybe that’s just me.
44 00:05:50.330 ⇒ 00:05:52.090 Amber Lin: Like, this makes sense to me.
45 00:05:52.960 ⇒ 00:05:56.050 Amber Lin: But maybe we… I feel like we used this before.
46 00:05:57.360 ⇒ 00:06:01.080 Amber Lin: Like, this was, like, total pipeline quantity we used to…
47 00:06:01.080 ⇒ 00:06:08.899 Advait Nandakumar Menon: That’s another thing I wanted to check with you, like, it is already there in total pipeline quantity, I think it’s a sum of these three.
48 00:06:09.220 ⇒ 00:06:09.770 Amber Lin: Yeah.
49 00:06:09.770 ⇒ 00:06:11.650 Advait Nandakumar Menon: So… Yeah.
50 00:06:23.190 ⇒ 00:06:25.040 Advait Nandakumar Menon: That should be, in fact, sales, right?
51 00:06:26.310 ⇒ 00:06:28.930 Amber Lin: It’s in the inventory.
52 00:06:28.930 ⇒ 00:06:30.020 Advait Nandakumar Menon: Definitely, yeah.
53 00:06:30.020 ⇒ 00:06:38.450 Amber Lin: Yeah, in fact, inventory by location… Yeah, and then…
54 00:06:40.130 ⇒ 00:06:44.000 Advait Nandakumar Menon: Yeah, so are we calling it stock versus your weeks of stock? Because…
55 00:06:44.130 ⇒ 00:06:47.769 Advait Nandakumar Menon: that you sent, that Slack message.
56 00:06:47.770 ⇒ 00:06:59.340 Amber Lin: Yeah, I agree. This… Let’s see how it goes here. On hand, da-da-da-da, available inventory.
57 00:07:00.040 ⇒ 00:07:02.040 Amber Lin: Velocity by what?
58 00:07:02.440 ⇒ 00:07:04.090 Amber Lin: One or… what?
59 00:07:07.270 ⇒ 00:07:15.190 Amber Lin: Okay, available inventory divided by… But this is daily. This is, like…
60 00:07:15.460 ⇒ 00:07:19.390 Amber Lin: Right now, this is, like, daily weeks of stock.
61 00:07:19.820 ⇒ 00:07:22.910 Amber Lin: Does this make sense? Because this is, like, daily.
62 00:07:23.130 ⇒ 00:07:24.689 Amber Lin: sales velocity.
63 00:07:24.830 ⇒ 00:07:25.480 Amber Lin: So this was.
64 00:07:25.480 ⇒ 00:07:25.850 Advait Nandakumar Menon: Yeah.
65 00:07:25.850 ⇒ 00:07:28.409 Amber Lin: daily weeks of stock. Maybe we just…
66 00:07:28.410 ⇒ 00:07:32.020 Advait Nandakumar Menon: I… yeah, I believed I called it out…
67 00:07:32.310 ⇒ 00:07:35.640 Advait Nandakumar Menon: Within the channel that it’s,
68 00:07:36.990 ⇒ 00:07:40.590 Advait Nandakumar Menon: The 4 months from the past 4 months or something is what you mentioned, right?
69 00:07:41.060 ⇒ 00:07:45.660 Amber Lin: Yeah, for the past 4 weeks. Yeah, we should call it… Chuck.
70 00:07:46.310 ⇒ 00:07:53.550 Amber Lin: Oh, a daily skill… What’s a better name to call this thing?
71 00:07:56.960 ⇒ 00:07:59.840 Advait Nandakumar Menon: What about just sales velocity?
72 00:08:00.320 ⇒ 00:08:01.939 Advait Nandakumar Menon: Will that make sense?
73 00:08:02.570 ⇒ 00:08:04.879 Amber Lin: Okay, so let’s just do this.
74 00:08:05.940 ⇒ 00:08:07.739 Amber Lin: Just… just call it…
75 00:08:08.680 ⇒ 00:08:14.689 Advait Nandakumar Menon: Oh, wait, actually, daily makes sense, because we’re setting the grain at daily, and then Blobby can maybe work its way out.
76 00:08:15.290 ⇒ 00:08:15.660 Amber Lin: Yeah.
77 00:08:15.990 ⇒ 00:08:21.480 Amber Lin: this. So let’s do this daily sales velocity, Available inventory.
78 00:08:23.760 ⇒ 00:08:29.339 Amber Lin: Total pinpoint quantity, and then we have this.
79 00:08:29.720 ⇒ 00:08:34.120 Amber Lin: Stock velocity… Let’s copy this…
80 00:08:40.309 ⇒ 00:08:46.200 Amber Lin: We should… should name this… Days of stock.
81 00:08:46.510 ⇒ 00:08:50.579 Amber Lin: So, that will be…
82 00:08:59.740 ⇒ 00:09:06.380 Advait Nandakumar Menon: the total pipeline quantity by daily sales velocity. But do we need daily stock velocity?
83 00:09:09.240 ⇒ 00:09:16.230 Amber Lin: What do you mean? I think we’re using this just to roll up…
84 00:09:16.570 ⇒ 00:09:17.080 Advait Nandakumar Menon: Okay, okay.
85 00:09:17.080 ⇒ 00:09:21.059 Amber Lin: Roll up into weeks, I think is the idea?
86 00:09:21.350 ⇒ 00:09:22.220 Amber Lin: Okay. Yeah.
87 00:09:22.700 ⇒ 00:09:43.300 Amber Lin: So, we would say… One sec, so we’ll see… Days… Tozo… Total pipeline quantity… Right, Dave.
88 00:09:44.460 ⇒ 00:09:52.110 Amber Lin: And roll… Bobby can roll this up, too.
89 00:09:52.230 ⇒ 00:09:56.730 Amber Lin: We… small ones… I’m just using, so…
90 00:10:04.210 ⇒ 00:10:10.639 Amber Lin: Wait, one question. When we roll this up to, for example, weeks of stock.
91 00:10:11.600 ⇒ 00:10:13.960 Amber Lin: I think the total pine blood quantity?
92 00:10:14.610 ⇒ 00:10:17.730 Amber Lin: Mmm, makes… sense?
93 00:10:18.090 ⇒ 00:10:29.489 Amber Lin: does this make sense? Like, do you think rolling… can we roll days of stock into weeks of… like, weeks of stock just by dividing by 7?
94 00:10:29.800 ⇒ 00:10:32.640 Amber Lin: Does that make sense?
95 00:10:34.160 ⇒ 00:10:41.470 Advait Nandakumar Menon: Oh, Yeah, now that you say it out loud, like, the pipeline quantity can…
96 00:10:41.620 ⇒ 00:10:43.750 Advait Nandakumar Menon: change by the end of 7?
97 00:10:43.750 ⇒ 00:10:45.579 Amber Lin: Yeah, right?
98 00:10:45.580 ⇒ 00:10:46.969 Advait Nandakumar Menon: I mean, 7 days.
99 00:11:00.300 ⇒ 00:11:05.170 Amber Lin: Seems… wrong, because, like, total… Hi.
100 00:11:06.680 ⇒ 00:11:15.549 Amber Lin: quantity… like, for example, if we’re not rolling it up, how will we calculate weeks of stock?
101 00:11:16.860 ⇒ 00:11:17.890 Amber Lin: Like, total pile…
102 00:11:17.890 ⇒ 00:11:18.330 Advait Nandakumar Menon: Good morning.
103 00:11:18.330 ⇒ 00:11:26.850 Amber Lin: quantity would just be a sum of everything? Like, what would… what would the total quantity be for weeks of stock?
104 00:11:28.250 ⇒ 00:11:32.049 Advait Nandakumar Menon: So, weeks of stock, we are checking on any given date, right?
105 00:11:32.180 ⇒ 00:11:33.010 Advait Nandakumar Menon: This is…
106 00:11:34.110 ⇒ 00:11:34.770 Amber Lin: Yeah.
107 00:11:35.800 ⇒ 00:11:37.040 Advait Nandakumar Menon: Yeah, so…
108 00:11:37.040 ⇒ 00:11:39.409 Amber Lin: So the… this will be the same, right?
109 00:11:41.690 ⇒ 00:11:49.920 Advait Nandakumar Menon: Yeah, but I would say the total pipeline quantity, or whatever, will be as of that day, and divided by,
110 00:11:51.270 ⇒ 00:11:56.820 Advait Nandakumar Menon: The weekly average units sold for the past 4 months from the given date, because that’s what…
111 00:11:57.850 ⇒ 00:12:00.739 Advait Nandakumar Menon: We agreed on Slack last, I remember.
112 00:12:00.740 ⇒ 00:12:04.040 Amber Lin: 4 months, or past 4… oh, what? Wait.
113 00:12:04.450 ⇒ 00:12:05.250 Advait Nandakumar Menon: Yeah, that’s…
114 00:12:05.250 ⇒ 00:12:08.540 Amber Lin: Months? Weeks? I thought he meant weeks.
115 00:12:09.040 ⇒ 00:12:12.330 Amber Lin: I think he said… My bad!
116 00:12:13.270 ⇒ 00:12:14.720 Amber Lin: Fast 4 weeks!
117 00:12:14.860 ⇒ 00:12:20.540 Amber Lin: I didn’t know I typed that, so… Yeah, huh?
118 00:12:20.540 ⇒ 00:12:24.609 Advait Nandakumar Menon: And I just tried to confirm it again, and Utam just gave a thumbs up as well, so…
119 00:12:24.610 ⇒ 00:12:35.239 Amber Lin: I see, I think he also read super fast, like, how I typed it. Okay, so this makes more sense. Total Kuala as of…
120 00:12:35.390 ⇒ 00:12:40.079 Amber Lin: that… Day would be the same.
121 00:12:40.760 ⇒ 00:12:44.959 Amber Lin: I think so, because we’re asking…
122 00:12:46.220 ⇒ 00:12:46.960 Advait Nandakumar Menon: Oh, yeah.
123 00:12:47.110 ⇒ 00:12:52.760 Amber Lin: So… Blobby can roll this up.
124 00:12:55.310 ⇒ 00:12:57.299 Amber Lin: Any given day.
125 00:12:58.160 ⇒ 00:13:00.859 Amber Lin: Cool, so we only need the restock.
126 00:13:01.870 ⇒ 00:13:02.770 Advait Nandakumar Menon: Okay, okay.
127 00:13:02.770 ⇒ 00:13:07.389 Amber Lin: Alright, so next, we have received daily, blah blah blah, makes sense.
128 00:13:08.360 ⇒ 00:13:09.580 Advait Nandakumar Menon: Should we call it?
129 00:13:09.840 ⇒ 00:13:12.140 Amber Lin: That makes sense. And then…
130 00:13:12.140 ⇒ 00:13:14.440 Advait Nandakumar Menon: Daily receipts?
131 00:13:14.440 ⇒ 00:13:17.120 Amber Lin: We call it daily receipts. It makes… it feels…
132 00:13:17.120 ⇒ 00:13:17.580 Advait Nandakumar Menon: Yeah.
133 00:13:17.580 ⇒ 00:13:20.580 Amber Lin: Feels right that way. Yeah.
134 00:13:20.800 ⇒ 00:13:21.669 Advait Nandakumar Menon: No, I agree.
135 00:13:30.500 ⇒ 00:13:38.150 Amber Lin: Cool, and then sell through… Okay, I also don’t like that naming, but let’s see. Sell through…
136 00:13:39.430 ⇒ 00:13:40.780 Advait Nandakumar Menon: Daily Central.
137 00:13:42.380 ⇒ 00:13:46.520 Advait Nandakumar Menon: I don’t know that… .
138 00:13:58.940 ⇒ 00:14:00.500 Amber Lin: Units sold.
139 00:14:00.780 ⇒ 00:14:07.599 Amber Lin: So, when somebody asks for sell-through rate, are… are they…
140 00:14:08.220 ⇒ 00:14:18.399 Amber Lin: Are they asking for what’s the sell-through of the past day, or sell-through of the past week, or do they just want, like, a sell-through number?
141 00:14:20.990 ⇒ 00:14:24.409 Advait Nandakumar Menon: Sell-through, that’s the thing, so sell-through is for a given period.
142 00:14:27.250 ⇒ 00:14:29.829 Amber Lin: So they have to specify that period.
143 00:14:30.320 ⇒ 00:14:35.780 Advait Nandakumar Menon: Yeah, so that’s why Avesh mentions, since that’s something dynamic,
144 00:14:36.060 ⇒ 00:14:44.419 Advait Nandakumar Menon: he wants to know how to set it within dbt Snowflake model, so that’s where you mentioned daily would make sense, right? So…
145 00:14:44.420 ⇒ 00:14:44.770 Amber Lin: Mmm.
146 00:14:44.770 ⇒ 00:14:50.710 Advait Nandakumar Menon: Mmm… Yeah, it would make sense within… Omni to…
147 00:14:50.840 ⇒ 00:14:53.630 Advait Nandakumar Menon: Give that period, or whatever period the client is gonna.
148 00:14:53.630 ⇒ 00:14:54.530 Amber Lin: I see.
149 00:14:54.640 ⇒ 00:14:59.999 Amber Lin: Self… so this definition is… sounds wrong.
150 00:15:04.070 ⇒ 00:15:07.900 Amber Lin: Units so divided.
151 00:15:09.480 ⇒ 00:15:13.469 Amber Lin: So how would this roll up to weeks?
152 00:15:13.640 ⇒ 00:15:15.520 Amber Lin: Or any given period.
153 00:15:18.520 ⇒ 00:15:20.690 Advait Nandakumar Menon: That’s a good question.
154 00:15:20.910 ⇒ 00:15:27.119 Amber Lin: Let’s see, I was thinking about that, I was like, how does this formula roll up to a week?
155 00:15:39.580 ⇒ 00:15:48.340 Amber Lin: Well, let’s see, if it’s… If there’s 7 days, Would we… Average?
156 00:15:52.510 ⇒ 00:15:57.580 Advait Nandakumar Menon: But average work yourself? It’s a person.
157 00:15:57.580 ⇒ 00:15:58.780 Amber Lin: Sunbage.
158 00:15:59.050 ⇒ 00:16:02.000 Advait Nandakumar Menon: It’s a percentage of the total units, right? So…
159 00:16:02.780 ⇒ 00:16:06.849 Amber Lin: Right, so we’ll have to, for any given period, will we use…
160 00:16:06.850 ⇒ 00:16:07.970 Advait Nandakumar Menon: Sum it up.
161 00:16:07.970 ⇒ 00:16:13.039 Amber Lin: beginning of period… Plus some receipts, right?
162 00:16:14.250 ⇒ 00:16:17.690 Amber Lin: We’ll do some receipts, because,
163 00:16:18.030 ⇒ 00:16:20.800 Amber Lin: Beginning of a period would be… would be fine.
164 00:16:21.250 ⇒ 00:16:23.229 Amber Lin: And then we need to do this.
165 00:16:24.040 ⇒ 00:16:27.150 Amber Lin: And there’s some… units…
166 00:16:27.510 ⇒ 00:16:28.769 Advait Nandakumar Menon: Units sold, yeah.
167 00:16:28.770 ⇒ 00:16:29.090 Amber Lin: Right?
168 00:16:29.090 ⇒ 00:16:30.670 Advait Nandakumar Menon: Yeah. Yeah.
169 00:16:30.670 ⇒ 00:16:37.730 Amber Lin: And then receipts is… I mean, I mean, we have receipts modeled out. Yeah.
170 00:16:37.860 ⇒ 00:16:42.830 Amber Lin: Okay, so…
171 00:16:46.460 ⇒ 00:16:54.369 Amber Lin: Like, does it even… Makes… Sense to… to do an average?
172 00:16:55.040 ⇒ 00:17:04.159 Amber Lin: So, average would… Sorry, I’m trying… my math is not mathing. So, this…
173 00:17:04.160 ⇒ 00:17:04.970 Advait Nandakumar Menon: No, that’s fine.
174 00:17:06.460 ⇒ 00:17:14.920 Amber Lin: Plus… Hey, this is… A1, B1, C1.
175 00:17:17.490 ⇒ 00:17:20.649 Amber Lin: Plus B, 22…
176 00:17:24.280 ⇒ 00:17:27.260 Amber Lin: And then we’ll have to divide this whole thing.
177 00:17:27.579 ⇒ 00:17:28.699 Amber Lin: by 2.
178 00:17:28.940 ⇒ 00:17:34.199 Amber Lin: And, like… Does the average work?
179 00:17:36.220 ⇒ 00:17:41.229 Advait Nandakumar Menon: We are taking an average of the whole… wait, I don’t understand, like, why we’re taking an average here.
180 00:17:42.240 ⇒ 00:17:49.700 Amber Lin: The sell-through rate. Like, if we had a daily sell-through, can it roll up into a… into a greater period?
181 00:17:51.790 ⇒ 00:17:52.580 Advait Nandakumar Menon: Okay.
182 00:17:54.350 ⇒ 00:17:56.360 Amber Lin: Do you think that’s possible?
183 00:17:59.450 ⇒ 00:18:00.350 Amber Lin: I don’t know.
184 00:18:01.080 ⇒ 00:18:03.899 Amber Lin: I don’t think this formula makes sense.
185 00:18:04.540 ⇒ 00:18:06.569 Amber Lin: Okay, so we can’t roll it up.
186 00:18:08.190 ⇒ 00:18:10.480 Advait Nandakumar Menon: Let me just ask GPT for this.
187 00:18:10.480 ⇒ 00:18:11.290 Amber Lin: Yeah.
188 00:18:12.340 ⇒ 00:18:15.460 Amber Lin: Here, the, here’s the… here’s the… Packs.
189 00:18:15.460 ⇒ 00:18:16.350 Advait Nandakumar Menon: There you go.
190 00:18:16.350 ⇒ 00:18:17.839 Amber Lin: If… if it helps.
191 00:18:18.020 ⇒ 00:18:19.970 Amber Lin: Wait, let me send it to you.
192 00:18:23.420 ⇒ 00:18:24.420 Amber Lin: Boom.
193 00:18:28.030 ⇒ 00:18:28.800 Amber Lin: Cool.
194 00:19:51.770 ⇒ 00:19:55.850 Advait Nandakumar Menon: So… What Guso is saying is.
195 00:19:57.960 ⇒ 00:20:05.169 Advait Nandakumar Menon: You can roll it up to a week or a month, but you should not roll it up by averaging the daily sell-through percentages, like.
196 00:20:05.530 ⇒ 00:20:10.050 Advait Nandakumar Menon: So, one period should be defined, and then use a single
197 00:20:10.960 ⇒ 00:20:13.690 Advait Nandakumar Menon: Numerator and denominator is what it’s saying.
198 00:20:14.270 ⇒ 00:20:18.219 Amber Lin: But how do you get the single numerator denominator?
199 00:20:19.150 ⇒ 00:20:23.360 Advait Nandakumar Menon: So… Daily is already defined like we just saw.
200 00:20:23.730 ⇒ 00:20:29.679 Advait Nandakumar Menon: So, for weekly or monthly, like, example, for a period, it’s 7 days.
201 00:20:30.220 ⇒ 00:20:34.350 Advait Nandakumar Menon: So, units sold is… Some of…
202 00:20:35.100 ⇒ 00:20:39.140 Advait Nandakumar Menon: All the units sold across the days and the period is what it’s saying.
203 00:20:41.290 ⇒ 00:20:48.960 Amber Lin: Yeah, so… so, essentially, I think it’s saying that we cannot Just start from this…
204 00:20:49.270 ⇒ 00:20:54.110 Amber Lin: Like, we cannot aggregate it from a daily sell-through. We’ll have to recalculate.
205 00:20:54.980 ⇒ 00:20:55.770 Advait Nandakumar Menon: Yeah.
206 00:20:56.860 ⇒ 00:20:57.530 Amber Lin: Okay.
207 00:20:58.510 ⇒ 00:21:06.580 Amber Lin: Yeah… Okay, so for sell-through.
208 00:21:06.680 ⇒ 00:21:10.909 Amber Lin: Do you think it would be helpful if we added, like, a
209 00:21:11.850 ⇒ 00:21:19.300 Amber Lin: add a daily sell-through, weekly sell-through, monthly sell-through for any… for every given day. Do you think that would be helpful?
210 00:21:21.830 ⇒ 00:21:27.240 Advait Nandakumar Menon: Do… you mean for daily… so the values will be repeated across each date, right?
211 00:21:27.440 ⇒ 00:21:36.280 Amber Lin: No… I think we’re, like, for example, we’ll have 3 columns. One is daily.
212 00:21:37.440 ⇒ 00:21:45.990 Amber Lin: And one is weekly, so the 7 days before, like, the given date. So let’s say the row is for March 27th, we’ll have.
213 00:21:45.990 ⇒ 00:21:46.400 Advait Nandakumar Menon: Hmm.
214 00:21:46.400 ⇒ 00:21:47.900 Amber Lin: Sell through that day.
215 00:21:48.470 ⇒ 00:21:51.550 Amber Lin: Sell through the week before that day.
216 00:21:51.750 ⇒ 00:21:56.410 Amber Lin: sell through the month before that date. Do you think that’s what people would want?
217 00:21:57.270 ⇒ 00:22:02.570 Amber Lin: Can you ask Kirscher, like, how do people usually ask about sell-through? Like, what do they want to know?
218 00:22:04.190 ⇒ 00:22:04.860 Advait Nandakumar Menon: Okay.
219 00:22:18.510 ⇒ 00:22:24.819 Amber Lin: Usually they do, like, a 30-day period, so having months would be important.
220 00:22:44.460 ⇒ 00:22:49.499 Amber Lin: Okay, so commonly, there’s one month, weekly, and quarterly.
221 00:22:50.810 ⇒ 00:22:53.979 Advait Nandakumar Menon: Yeah, some people might ask something like.
222 00:22:54.140 ⇒ 00:22:57.130 Advait Nandakumar Menon: Last 4 weeks, or whatever, but yeah, a month.
223 00:22:57.830 ⇒ 00:22:59.610 Amber Lin: Yeah.
224 00:23:00.080 ⇒ 00:23:04.449 Amber Lin: One month might be a little tricky, cause, like.
225 00:23:04.620 ⇒ 00:23:10.300 Amber Lin: month has different number of days. Should we just do 4 weeks as a way to add it?
226 00:23:12.530 ⇒ 00:23:14.949 Advait Nandakumar Menon: Yeah, I think…
227 00:23:14.950 ⇒ 00:23:17.200 Amber Lin: month. Past month will be kind of hard.
228 00:23:19.670 ⇒ 00:23:24.269 Advait Nandakumar Menon: I would say we can stick with 4 weeks, because I think Utam also mentioned, like.
229 00:23:25.050 ⇒ 00:23:27.599 Advait Nandakumar Menon: 28 days is the standard people use.
230 00:23:27.600 ⇒ 00:23:38.019 Amber Lin: Yeah, okay, okay. So let’s use… I think they turn over pretty fast, so let’s do, like, a weekly and monthly. How’s that? I think that’s pretty… that sounds good to me.
231 00:23:38.710 ⇒ 00:23:45.160 Advait Nandakumar Menon: Yeah, so they can ask something like, what’s the sell-through last week or last month, right? Yeah.
232 00:23:45.160 ⇒ 00:23:52.110 Amber Lin: So it will be… Yeah, so I think we’ll keep… Officials… 4 weeks.
233 00:23:52.220 ⇒ 00:23:54.279 Amber Lin: And then we’ll add another one.
234 00:23:55.260 ⇒ 00:23:57.040 Amber Lin: Oh. Okay.
235 00:23:57.490 ⇒ 00:24:04.300 Amber Lin: Sell through… Add another one for weekly.
236 00:24:26.830 ⇒ 00:24:27.710 Amber Lin: Okay.
237 00:24:27.910 ⇒ 00:24:28.780 Amber Lin: Alright.
238 00:24:29.530 ⇒ 00:24:35.090 Amber Lin: That sounds good to me. Why don’t we read the… read the logic here?
239 00:24:36.500 ⇒ 00:24:43.879 Amber Lin: I think these… these make sense, like, these are just set up, sales daily…
240 00:24:48.370 ⇒ 00:24:51.570 Amber Lin: Product key… Okay, product key?
241 00:24:55.100 ⇒ 00:24:59.710 Advait Nandakumar Menon: Yeah, then I… query in Snowflake.
242 00:25:00.290 ⇒ 00:25:01.720 Advait Nandakumar Menon: Product team was…
243 00:25:03.420 ⇒ 00:25:06.100 Amber Lin: Shouldn’t they use, like, Prada SK?
244 00:25:09.900 ⇒ 00:25:11.050 Amber Lin: What?
245 00:25:12.640 ⇒ 00:25:15.170 Amber Lin: Can you check real quick?
246 00:25:16.090 ⇒ 00:25:18.850 Amber Lin: In facts… sales…
247 00:25:20.070 ⇒ 00:25:21.110 Advait Nandakumar Menon: Yeah, let me check.
248 00:25:21.610 ⇒ 00:25:26.480 Amber Lin: Yeah, product key versus product SK, let’s figure out which one to use.
249 00:25:44.210 ⇒ 00:25:47.010 Amber Lin: Location type equals store…
250 00:26:14.970 ⇒ 00:26:17.280 Advait Nandakumar Menon: There is both within fact sales.
251 00:26:18.150 ⇒ 00:26:22.480 Amber Lin: Yeah, it should be in, in fact… skills.
252 00:26:22.750 ⇒ 00:26:23.720 Amber Lin: Right.
253 00:26:24.180 ⇒ 00:26:24.850 Amber Lin: Orange.
254 00:26:24.850 ⇒ 00:26:29.600 Advait Nandakumar Menon: No, no, I’m saying there is product SK and product key, like, there are both fields.
255 00:26:29.600 ⇒ 00:26:44.340 Amber Lin: Oh, I see. I think they both exist, but it seems like in this fact velocity sell-through model, we only are including product key. And my question is, is it better to use product key or use product SK?
256 00:26:45.690 ⇒ 00:26:48.920 Advait Nandakumar Menon: I mean, for that, I would need to know, like, what…
257 00:26:49.150 ⇒ 00:26:51.480 Advait Nandakumar Menon: the difference between both? Is there…
258 00:26:51.480 ⇒ 00:26:58.950 Amber Lin: Can you run a distinct count for both fields? Like, if some… if one of them is less, then maybe some of it is missing.
259 00:27:03.330 ⇒ 00:27:07.850 Advait Nandakumar Menon: So… Is it, like, are both the same things, essentially?
260 00:27:08.050 ⇒ 00:27:15.770 Amber Lin: Yeah, I think there are, like, different naming conventions, but can we check how many for each…
261 00:27:15.770 ⇒ 00:27:16.179 Advait Nandakumar Menon: Yeah, I’m.
262 00:27:16.180 ⇒ 00:27:16.830 Amber Lin: Serious.
263 00:27:16.830 ⇒ 00:27:17.180 Advait Nandakumar Menon: Yeah.
264 00:27:17.180 ⇒ 00:27:17.900 Amber Lin: Awesome.
265 00:27:17.900 ⇒ 00:27:18.500 Advait Nandakumar Menon: Okay.
266 00:27:32.160 ⇒ 00:27:33.380 Amber Lin: Oh, hmm…
267 00:27:45.450 ⇒ 00:27:49.490 Advait Nandakumar Menon: We have product key to be distinct, 38.
268 00:27:50.880 ⇒ 00:27:59.810 Advait Nandakumar Menon: From retail fax sales, oh, I’m checking this on staging, let me…
269 00:28:16.940 ⇒ 00:28:23.490 Advait Nandakumar Menon: Sure, okay, both distinct count of product FK and product key is 38, is what I’m seeing from retail vaccines.
270 00:28:23.590 ⇒ 00:28:25.710 Amber Lin: Cool, then it shouldn’t be a problem.
271 00:28:26.430 ⇒ 00:28:32.069 Advait Nandakumar Menon: Because I… if I remember now, when developing the topics for Omni as well, now that I recall.
272 00:28:32.390 ⇒ 00:28:37.520 Advait Nandakumar Menon: I also became confused because… Kosa was giving me a scan…
273 00:28:37.790 ⇒ 00:28:38.110 Amber Lin: Yeah.
274 00:28:38.110 ⇒ 00:28:41.739 Advait Nandakumar Menon: I mean, key, product key, and I remember you talking about SK, so…
275 00:28:41.740 ⇒ 00:28:48.579 Amber Lin: Yeah, yeah, yeah, I didn’t know they were, like… I thought SK was more complete, but I guess they’re the same.
276 00:28:48.830 ⇒ 00:28:54.340 Amber Lin: Alright, can you see my screen? I’m just reading… I’m reading this.
277 00:28:55.070 ⇒ 00:29:00.090 Amber Lin: receipts… the calculation for receipts. I think…
278 00:29:00.920 ⇒ 00:29:09.660 Amber Lin: On-hand quantity is just ending on-hand quantity, or is there, like, a… It’s on-hand quantity and…
279 00:29:10.850 ⇒ 00:29:14.339 Amber Lin: Like, is there a field called ending on-hand quantity?
280 00:29:16.640 ⇒ 00:29:21.369 Advait Nandakumar Menon: So there’s this beginning, and… so you’re saying just on-hand quantity is the end?
281 00:29:21.730 ⇒ 00:29:22.510 Amber Lin: Okay.
282 00:29:23.280 ⇒ 00:29:23.780 Advait Nandakumar Menon: No, I’m out.
283 00:29:23.780 ⇒ 00:29:27.070 Amber Lin: Are you looking at the DB? Okay, cool.
284 00:29:32.070 ⇒ 00:29:35.389 Advait Nandakumar Menon: No, I wasn’t saying it is the case, I was asking you about.
285 00:29:35.390 ⇒ 00:29:41.310 Amber Lin: Oh, yeah, I’m asking too. I’m not sure, so we need to check… Let’s check.
286 00:29:41.450 ⇒ 00:29:42.640 Advait Nandakumar Menon: Meaning X.
287 00:29:45.710 ⇒ 00:29:49.499 Amber Lin: I’ll just read… I think just reading the columns is enough.
288 00:29:54.140 ⇒ 00:29:59.610 Amber Lin: Proud… Me too.
289 00:30:05.340 ⇒ 00:30:10.840 Advait Nandakumar Menon: Should be with… within… Inventory by location, right?
290 00:30:10.840 ⇒ 00:30:17.065 Amber Lin: Yeah, I’m checking… on hand… Hmm…
291 00:30:21.290 ⇒ 00:30:22.070 Amber Lin: Huh.
292 00:30:22.970 ⇒ 00:30:24.220 Advait Nandakumar Menon: I don’t think this… and…
293 00:30:24.710 ⇒ 00:30:26.240 Amber Lin: I don’t think it’s in here.
294 00:30:30.870 ⇒ 00:30:37.060 Amber Lin: Yeah, it should be, it should be, like… Let me check… Here.
295 00:30:37.750 ⇒ 00:30:39.580 Amber Lin: I’ll just check the raw.
296 00:30:40.990 ⇒ 00:30:46.340 Amber Lin: Nope, not that one.
297 00:30:47.490 ⇒ 00:30:54.799 Amber Lin: Maybe is stage right now, or intermediate?
298 00:31:16.210 ⇒ 00:31:18.770 Amber Lin: Where does the wish get that from?
299 00:31:19.140 ⇒ 00:31:25.910 Amber Lin: He gets beginning on-hand quantity, Oak.
300 00:31:26.130 ⇒ 00:31:33.509 Amber Lin: Okay… Id. Where is ID?
301 00:31:43.570 ⇒ 00:31:44.340 Amber Lin: What?
302 00:31:45.670 ⇒ 00:31:47.680 Amber Lin: Wint, this is not in there.
303 00:31:50.200 ⇒ 00:31:50.990 Amber Lin: He gets a.
304 00:31:50.990 ⇒ 00:31:51.640 Advait Nandakumar Menon: Nope.
305 00:31:51.790 ⇒ 00:31:52.909 Amber Lin: You guys are from here.
306 00:31:53.610 ⇒ 00:31:58.279 Amber Lin: He says it’s in inventory by location. Do you see it? Am I just missing it?
307 00:31:58.280 ⇒ 00:32:01.300 Advait Nandakumar Menon: Just on… just… just on-hand quantity?
308 00:32:02.300 ⇒ 00:32:04.450 Amber Lin: Beginning on hearing quantity.
309 00:32:08.570 ⇒ 00:32:13.189 Amber Lin: Oh, there is. Never mind, I’m so silly. Yeah, there’s big any on-hand quantity.
310 00:32:13.840 ⇒ 00:32:14.490 Advait Nandakumar Menon: Okay.
311 00:32:14.680 ⇒ 00:32:16.070 Amber Lin: Cool. That’s good.
312 00:32:17.530 ⇒ 00:32:22.860 Advait Nandakumar Menon: My question was just the on-hand quantity. Is it the ending one?
313 00:32:23.070 ⇒ 00:32:24.010 Advait Nandakumar Menon: Is it the ending?
314 00:32:24.200 ⇒ 00:32:34.170 Amber Lin: I would… I think so, because they log this the day after. Like, for example, this is for…
315 00:32:34.410 ⇒ 00:32:43.639 Amber Lin: 11-16, and they… Updated it. They uploaded it at 1117.
316 00:32:44.570 ⇒ 00:32:50.589 Amber Lin: morning. Okay. So, I think this is… everything is, like, the day after, so on hand should be ending.
317 00:32:51.570 ⇒ 00:32:52.290 Advait Nandakumar Menon: Okay.
318 00:32:52.290 ⇒ 00:32:52.880 Amber Lin: Yeah.
319 00:32:53.750 ⇒ 00:32:54.990 Amber Lin: Okay.
320 00:32:55.200 ⇒ 00:32:57.989 Amber Lin: Wait, then does that introduce something?
321 00:32:58.120 ⇒ 00:32:59.860 Amber Lin: Questions?
322 00:33:00.020 ⇒ 00:33:01.519 Amber Lin: No, I think it’s fine.
323 00:33:02.300 ⇒ 00:33:03.180 Amber Lin: Okay.
324 00:33:03.610 ⇒ 00:33:04.720 Amber Lin: Right.
325 00:33:05.680 ⇒ 00:33:06.610 Amber Lin: Here.
326 00:33:06.860 ⇒ 00:33:07.650 Amber Lin: Right.
327 00:33:09.970 ⇒ 00:33:14.759 Amber Lin: Receives daily… Okay, what is this?
328 00:33:15.680 ⇒ 00:33:20.769 Advait Nandakumar Menon: Yeah, he, has built… Fields, like, columns for…
329 00:33:21.270 ⇒ 00:33:27.020 Advait Nandakumar Menon: One week, two weeks, I mean, up to 13 weeks, I think, has done something, I’m not sure entirely why, but…
330 00:33:27.020 ⇒ 00:33:32.769 Amber Lin: Yeah, I think he’s… he… this is why I say he’s generated it, because this is from our old message.
331 00:33:32.970 ⇒ 00:33:34.619 Amber Lin: So, we don’t, I think.
332 00:33:34.620 ⇒ 00:33:35.120 Advait Nandakumar Menon: Okay.
333 00:33:35.120 ⇒ 00:33:36.370 Amber Lin: Don’t need this.
334 00:33:37.400 ⇒ 00:33:38.760 Advait Nandakumar Menon: Yeah, he…
335 00:33:42.980 ⇒ 00:33:49.550 Advait Nandakumar Menon: He has done units sold from 1 to 13… 1, 4, and 13 weeks, same for recipes.
336 00:33:49.900 ⇒ 00:33:51.039 Advait Nandakumar Menon: Miniming on how…
337 00:33:51.040 ⇒ 00:34:00.670 Amber Lin: Oh, sure. If he has one unit sold one week, we would just go… We would go here.
338 00:34:01.300 ⇒ 00:34:03.840 Amber Lin: We’ll take the units sold.
339 00:34:04.990 ⇒ 00:34:06.420 Amber Lin: I won’t do…
340 00:34:10.449 ⇒ 00:34:11.320 Amber Lin: Thanks.
341 00:34:11.500 ⇒ 00:34:12.449 Amber Lin: this…
342 00:34:15.800 ⇒ 00:34:16.320 Amber Lin: Yes.
343 00:34:16.320 ⇒ 00:34:21.619 Advait Nandakumar Menon: So for every… so for everything, there is a 1 week, there’s a 4-week, and a 13-week value.
344 00:34:21.620 ⇒ 00:34:26.480 Amber Lin: Oh, cool. 13 weeks is, like, Quarter?
345 00:34:26.489 ⇒ 00:34:27.999 Advait Nandakumar Menon: Not 15, it’s 13.
346 00:34:28.000 ⇒ 00:34:30.670 Amber Lin: Yeah, like, that’s about, like.
347 00:34:30.670 ⇒ 00:34:33.460 Advait Nandakumar Menon: Oh, oh, you mean, yeah, I’ll get, Olga, yeah, yeah.
348 00:34:33.469 ⇒ 00:34:36.349 Amber Lin: Yeah, so we could give them…
349 00:34:36.819 ⇒ 00:34:39.369 Amber Lin: I mean, why not if he already has it?
350 00:34:39.909 ⇒ 00:34:41.669 Amber Lin: Quarterly…
351 00:34:46.199 ⇒ 00:34:47.099 Amber Lin: Okay.
352 00:34:48.619 ⇒ 00:34:49.859 Amber Lin: Just in case.
353 00:34:50.559 ⇒ 00:34:56.439 Amber Lin: Quarterly, alright, units sold… Receipts, blah blah blah.
354 00:34:57.499 ⇒ 00:34:59.709 Amber Lin: Receipts, receipts.
355 00:35:00.119 ⇒ 00:35:02.779 Amber Lin: This is beginning… what?
356 00:35:07.339 ⇒ 00:35:10.009 Amber Lin: First value. Okay, that makes sense, too.
357 00:35:10.239 ⇒ 00:35:12.329 Amber Lin: Enriched. Let’s see.
358 00:35:12.449 ⇒ 00:35:15.219 Amber Lin: So we have… these are the fields.
359 00:35:15.559 ⇒ 00:35:22.199 Amber Lin: Product key, product name, brand name… category…
360 00:35:23.089 ⇒ 00:35:27.109 Amber Lin: Unis sold on hand in transit, available inventory.
361 00:35:32.769 ⇒ 00:35:34.499 Amber Lin: Day count.
362 00:35:34.899 ⇒ 00:35:36.709 Amber Lin: What is date count?
363 00:35:37.819 ⇒ 00:35:42.749 Amber Lin: I think he… Used it to do the windows.
364 00:35:45.510 ⇒ 00:35:46.800 Amber Lin: Cool, okay.
365 00:35:46.960 ⇒ 00:35:52.970 Amber Lin: Okay, so case win. Oh, he already has this!
366 00:35:53.280 ⇒ 00:35:55.419 Amber Lin: Never mind, we don’t need that anymore.
367 00:35:55.680 ⇒ 00:35:56.720 Amber Lin: He already has that.
368 00:35:56.720 ⇒ 00:35:57.610 Advait Nandakumar Menon: you guys?
369 00:35:57.760 ⇒ 00:35:58.450 Advait Nandakumar Menon: Yeah. Okay.
370 00:35:58.450 ⇒ 00:36:00.430 Amber Lin: That’s that, so we don’t need this.
371 00:36:03.370 ⇒ 00:36:09.210 Amber Lin: I’ll… I’ll leave it be. I’ll… I’ll… I’ll let him have his naming.
372 00:36:10.210 ⇒ 00:36:12.200 Amber Lin: Stock velocity.
373 00:36:19.010 ⇒ 00:36:25.190 Amber Lin: I think star velocity is the main thing we’re… We’re changing.
374 00:36:25.930 ⇒ 00:36:26.760 Advait Nandakumar Menon: -
375 00:36:36.790 ⇒ 00:36:38.429 Amber Lin: So that would be…
376 00:36:48.050 ⇒ 00:36:53.390 Advait Nandakumar Menon: Wait, we are calling it back to days of stock, or, like, weeks of stock and stuff?
377 00:36:56.320 ⇒ 00:36:58.820 Amber Lin: Think, so… good.
378 00:36:58.820 ⇒ 00:37:01.589 Advait Nandakumar Menon: So, Jasmine said it’s stock velocity.
379 00:37:01.590 ⇒ 00:37:07.010 Amber Lin: Yeah, I think it’s because we used this, but it’s just.
380 00:37:07.010 ⇒ 00:37:08.100 Advait Nandakumar Menon: Oh, okay.
381 00:37:08.100 ⇒ 00:37:12.500 Amber Lin: likes to say weeks of stock. I think Jasmine’s words make sense.
382 00:37:13.610 ⇒ 00:37:15.549 Advait Nandakumar Menon: If it was the previous case, okay.
383 00:37:15.550 ⇒ 00:37:22.960 Amber Lin: Yeah, like, I just think the client wants weakest stock. Should we just directly calculate weak, weakest stock?
384 00:37:25.600 ⇒ 00:37:25.970 Advait Nandakumar Menon: What’s.
385 00:37:25.970 ⇒ 00:37:33.129 Amber Lin: Let’s just do this. Let’s just put, weeks… Weeks of stock.
386 00:37:36.740 ⇒ 00:37:37.879 Amber Lin: Let’s just put this.
387 00:37:37.880 ⇒ 00:37:38.849 Advait Nandakumar Menon: My son.
388 00:37:39.000 ⇒ 00:37:39.850 Advait Nandakumar Menon: Okay.
389 00:37:46.460 ⇒ 00:37:47.900 Amber Lin: Wait, what is this?
390 00:37:48.400 ⇒ 00:37:49.830 Amber Lin: We count…
391 00:37:56.010 ⇒ 00:37:56.870 Amber Lin: Okay.
392 00:37:57.210 ⇒ 00:38:00.340 Amber Lin: The other stuff seems fine.
393 00:38:23.350 ⇒ 00:38:26.420 Amber Lin: Cool, I’m gonna submit this comment.
394 00:38:27.000 ⇒ 00:38:29.399 Amber Lin: And…
395 00:38:33.720 ⇒ 00:38:37.160 Amber Lin: I’m gonna send this to…
396 00:38:37.850 ⇒ 00:38:44.360 Amber Lin: Cool, I think that’s… that’s most of it. Do you know if the voice changed the… I don’t care.
397 00:38:44.360 ⇒ 00:38:48.470 Advait Nandakumar Menon: Yeah, that’s what… that was the next thing. He said he’ll change it after some call.
398 00:38:48.470 ⇒ 00:38:49.170 Amber Lin: Yeah, I don’t think.
399 00:38:49.170 ⇒ 00:38:52.459 Advait Nandakumar Menon: Not sure what that… Yeah. Okay.
400 00:39:03.960 ⇒ 00:39:07.020 Advait Nandakumar Menon: What is this? Working hours? Do you know that?
401 00:39:07.240 ⇒ 00:39:14.589 Amber Lin: I feel like he just works US hours. He’s, like, he’s still working. I know that he’s still working.
402 00:39:15.330 ⇒ 00:39:16.649 Advait Nandakumar Menon: Okay, okay.
403 00:39:16.850 ⇒ 00:39:17.550 Amber Lin: Maybe…
404 00:39:17.550 ⇒ 00:39:18.180 Advait Nandakumar Menon: Christine?
405 00:39:18.180 ⇒ 00:39:20.220 Amber Lin: but… I don’t know.
406 00:39:21.550 ⇒ 00:39:23.290 Advait Nandakumar Menon: Okay. No, that’s fine.
407 00:39:23.560 ⇒ 00:39:28.930 Advait Nandakumar Menon: Yeah, so once this changes, then I should do the changes in Omni, right?
408 00:39:29.660 ⇒ 00:39:30.270 Amber Lin: Yeah.
409 00:39:30.640 ⇒ 00:39:35.480 Amber Lin: I think just including that topic, just including that model is fine.
410 00:39:37.970 ⇒ 00:39:42.190 Advait Nandakumar Menon: Oh, good. I mean… Oh, can I share my screen for a second? Yeah.
411 00:39:54.130 ⇒ 00:39:55.220 Advait Nandakumar Menon: They see it?
412 00:39:55.610 ⇒ 00:39:56.150 Amber Lin: Yep.
413 00:39:57.830 ⇒ 00:40:03.339 Advait Nandakumar Menon: Yeah, so this is the topic right now, and I’m joining in the DIM and the fact tables.
414 00:40:03.570 ⇒ 00:40:18.529 Advait Nandakumar Menon: And it’s able to answer, like, the sample queries and whatever questions I had proposed before to Greg, it’s able to answer that. But, we are bringing in these three other metrics, which is not able to answer… so we are modeling it in Snowflake, right?
415 00:40:18.590 ⇒ 00:40:23.859 Advait Nandakumar Menon: So do I just join this… this new table into this?
416 00:40:23.860 ⇒ 00:40:33.289 Amber Lin: Yeah, yeah, I think he… let me check his join keys. I think he just joined it on the…
417 00:40:34.110 ⇒ 00:40:35.739 Amber Lin: Because it’s the same…
418 00:40:35.940 ⇒ 00:40:45.340 Amber Lin: join key as your fact inventory by location. It’s essentially the same. It’s SKU… it’s daily SKU stored.
419 00:40:45.540 ⇒ 00:40:46.410 Amber Lin: So…
420 00:40:46.590 ⇒ 00:40:47.200 Advait Nandakumar Menon: Oh, good.
421 00:40:47.200 ⇒ 00:40:49.260 Amber Lin: You can just join it, and it’ll be the same.
422 00:40:50.930 ⇒ 00:40:54.720 Advait Nandakumar Menon: So I can just join in the new table, right? Whatever he’s creating.
423 00:40:54.720 ⇒ 00:40:55.320 Amber Lin: Yeah.
424 00:40:57.250 ⇒ 00:40:57.950 Advait Nandakumar Menon: Okay.
425 00:40:58.380 ⇒ 00:41:01.460 Advait Nandakumar Menon: And for that, I need to bring it into relationships first.
426 00:41:01.940 ⇒ 00:41:05.579 Amber Lin: Yes. If you… actually, if you send…
427 00:41:05.760 ⇒ 00:41:14.239 Amber Lin: I think if you just tell Cursor to do it, it will automatically update the relationship file, at least that’s what it did for me.
428 00:41:14.940 ⇒ 00:41:20.950 Advait Nandakumar Menon: Yeah, no, yeah, I… I was just trying from a… for my knowledge, I was trying to understand, so…
429 00:41:20.950 ⇒ 00:41:21.519 Amber Lin: Yeah.
430 00:41:23.140 ⇒ 00:41:31.220 Amber Lin: Once it updates in relationship, then it wouldn’t… like, once I didn’t do it, and it gave me join errors in Omni.
431 00:41:31.930 ⇒ 00:41:32.720 Advait Nandakumar Menon: Okay.
432 00:41:32.720 ⇒ 00:41:33.280 Amber Lin: Yeah.
433 00:41:34.100 ⇒ 00:41:37.629 Advait Nandakumar Menon: And once he does the rename… rename… sorry.
434 00:41:37.630 ⇒ 00:41:38.160 Amber Lin: Yeah.
435 00:41:38.160 ⇒ 00:41:47.660 Advait Nandakumar Menon: Renaming. Renaming, things from, revenue to sales, I should again change here in the topic, right?
436 00:41:47.660 ⇒ 00:41:48.280 Amber Lin: Yeah.
437 00:41:49.150 ⇒ 00:41:52.150 Advait Nandakumar Menon: Anywhere else I should be doing any changes with the Omni?
438 00:41:56.860 ⇒ 00:42:07.209 Amber Lin: No, all the other stuff is in the dashboards, and I feel like that’s for next week. If you get time, you can change it, but it’s already really late, so…
439 00:42:07.370 ⇒ 00:42:08.110 Advait Nandakumar Menon: Okay.
440 00:42:08.800 ⇒ 00:42:11.310 Amber Lin: yeah.
441 00:42:13.270 ⇒ 00:42:16.560 Advait Nandakumar Menon: Yeah, no, I was just trying to understand the next steps, that’s fine.
442 00:42:16.560 ⇒ 00:42:17.130 Amber Lin: Yeah.
443 00:42:17.710 ⇒ 00:42:22.279 Advait Nandakumar Menon: Cool. I don’t think I have anything else, but…
444 00:42:23.110 ⇒ 00:42:24.899 Advait Nandakumar Menon: Yeah, have you worked on default?
445 00:42:25.890 ⇒ 00:42:30.050 Amber Lin: Default… back then, a little bit. Like, a long time ago.
446 00:42:31.040 ⇒ 00:42:31.600 Advait Nandakumar Menon: Okay.
447 00:42:32.040 ⇒ 00:42:32.870 Advait Nandakumar Menon: Yeah.
448 00:42:32.870 ⇒ 00:42:34.550 Amber Lin: What are you working on for them?
449 00:42:35.260 ⇒ 00:42:39.909 Advait Nandakumar Menon: So, Utam just called me yesterday, like, he had…
450 00:42:40.070 ⇒ 00:42:45.510 Advait Nandakumar Menon: some call with default at 2PM ET, and he called me around, I think.
451 00:42:46.020 ⇒ 00:42:52.560 Advait Nandakumar Menon: 145ish, and wanted to look over a dashboard and clean it up with barely 10 minutes left.
452 00:42:52.710 ⇒ 00:42:53.400 Advait Nandakumar Menon: Cool.
453 00:42:53.400 ⇒ 00:42:53.990 Amber Lin: That’s no funny.
454 00:42:53.990 ⇒ 00:43:02.350 Advait Nandakumar Menon: Yeah. Yeah. Yeah, he did say it’s a crazy ask, but I had a look at it, I obviously couldn’t do it within 10 minutes, but…
455 00:43:02.490 ⇒ 00:43:08.300 Advait Nandakumar Menon: I made some changes to the dashboard, and he just wants my opinion on it, so… I was just wondering…
456 00:43:08.430 ⇒ 00:43:13.809 Advait Nandakumar Menon: Since I’m new to Omni, like, do you have any tips for working with dashboards?
457 00:43:13.930 ⇒ 00:43:27.210 Amber Lin: Not really. Jasmine has a lot of good formatting tips. Like, my knowledge is honestly as far as Blobby would go, and some aesthetic changes, but I would say
458 00:43:27.210 ⇒ 00:43:36.839 Amber Lin: Defaults clients are much more forgiving than Elements clients. They’re not very picky. They’re, like, the default clients are very scrappy, so even if you do something.
459 00:43:36.840 ⇒ 00:43:37.210 Advait Nandakumar Menon: Okay.
460 00:43:37.210 ⇒ 00:43:40.210 Amber Lin: As long as it’s cool, they’ll be very excited.
461 00:43:41.020 ⇒ 00:43:42.160 Advait Nandakumar Menon: Okay.
462 00:43:42.340 ⇒ 00:43:43.310 Advait Nandakumar Menon: Okay.
463 00:43:43.310 ⇒ 00:43:44.060 Amber Lin: Yeah.
464 00:43:44.770 ⇒ 00:43:45.470 Advait Nandakumar Menon: Okay.
465 00:43:46.220 ⇒ 00:43:56.080 Advait Nandakumar Menon: Yeah, I don’t… I don’t… so, do you consider yourself… As an Omni expert, Oniosadas.
466 00:43:56.080 ⇒ 00:44:02.759 Amber Lin: Yeah, I saw Robert’s message. I’m like, I’m not an expert, Robert, I don’t know what you want from me.
467 00:44:02.760 ⇒ 00:44:08.740 Advait Nandakumar Menon: Because I don’t know anyone else is gonna answer that, so I tried to help with the assistant.
468 00:44:08.740 ⇒ 00:44:09.789 Amber Lin: Yeah, I see.
469 00:44:09.790 ⇒ 00:44:10.130 Advait Nandakumar Menon: Yeah.
470 00:44:10.130 ⇒ 00:44:28.620 Amber Lin: That’s very, that’s very nice of you. I think between our team, Mustafa worked on some, like, topic development, like we did, but he mostly did, like, AI stuff, and then Greg has seen a lot of Omni stuff, but he didn’t develop anything, so I think it’s just you and I now.
471 00:44:28.970 ⇒ 00:44:46.039 Advait Nandakumar Menon: Okay. Yeah, I had a call with Mustafa since he worked on… he works on default, and just for your knowledge as well, I was checking with him, like, building dashboards. Oh, I did this with Cursor yesterday, like, that dashboard change with Utamas, I did it through Cursor, like.
472 00:44:46.040 ⇒ 00:44:49.029 Amber Lin: Oh, wait, really? Can you show me how to do that?
473 00:44:49.210 ⇒ 00:44:54.259 Advait Nandakumar Menon: Yeah, so, but it isn’t that good, and that’s something Mustafa also told me yesterday.
474 00:44:54.260 ⇒ 00:44:55.289 Amber Lin: I see. I mean…
475 00:44:55.290 ⇒ 00:44:55.870 Advait Nandakumar Menon: festivals.
476 00:44:55.870 ⇒ 00:45:00.320 Amber Lin: able to do it, it will save A lot of basic tasks.
477 00:45:00.750 ⇒ 00:45:04.849 Advait Nandakumar Menon: Yeah, I will show it to you, just give me a second, let me pull that cursor workspace.
478 00:45:07.210 ⇒ 00:45:11.809 Amber Lin: Is it through the same CLI, or is it a different, like, connection?
479 00:45:12.720 ⇒ 00:45:16.140 Advait Nandakumar Menon: It’s through the same API case you set up for…
480 00:45:16.360 ⇒ 00:45:22.139 Advait Nandakumar Menon: Yeah, only, like, this is the normal CLI connection, I would say.
481 00:45:22.680 ⇒ 00:45:24.140 Amber Lin: Okay.
482 00:45:25.720 ⇒ 00:45:32.719 Amber Lin: Because I tried to say, hey, make a dashboard for me, and it said, no, I can’t, so I feel like I may be asked in the wrong folder.
483 00:45:33.730 ⇒ 00:45:35.030 Advait Nandakumar Menon: Yeah, I’ll show it to you.
484 00:45:40.180 ⇒ 00:45:43.019 Advait Nandakumar Menon: So, all of this works with,
485 00:45:43.550 ⇒ 00:45:47.190 Advait Nandakumar Menon: Cursor skills, I’m not sure if you have…
486 00:45:48.010 ⇒ 00:45:51.469 Advait Nandakumar Menon: installed it for only on-cursor, have you?
487 00:45:51.470 ⇒ 00:45:53.110 Amber Lin: I will need to do that.
488 00:45:53.590 ⇒ 00:45:59.369 Amber Lin: Okay, where’s the crucial skill? Is it from Omni, or is it in our, like.
489 00:45:59.370 ⇒ 00:46:03.540 Advait Nandakumar Menon: Yeah, so… I thought it’s not…
490 00:46:03.820 ⇒ 00:46:06.629 Advait Nandakumar Menon: there, within our Bainforge platform, but…
491 00:46:06.790 ⇒ 00:46:11.820 Advait Nandakumar Menon: If you type up Omni over here, I could see…
492 00:46:11.880 ⇒ 00:46:12.970 Amber Lin: Aww.
493 00:46:13.640 ⇒ 00:46:15.990 Advait Nandakumar Menon: Why is it not popping up?
494 00:46:16.770 ⇒ 00:46:19.680 Amber Lin: Oh, there, I see it. Omni Content Builder.
495 00:46:20.180 ⇒ 00:46:20.850 Amber Lin: Oh, that’s it.
496 00:46:20.850 ⇒ 00:46:24.680 Advait Nandakumar Menon: Yeah, if you see here, some of these stops are, like, repeated.
497 00:46:24.990 ⇒ 00:46:31.610 Advait Nandakumar Menon: So, I think it’s there within the Brainforge platform, and I also installed it as an extension, so…
498 00:46:31.610 ⇒ 00:46:33.110 Amber Lin: I see, I see.
499 00:46:33.450 ⇒ 00:46:36.969 Advait Nandakumar Menon: Yeah, if you go to Cursor Settings and Marketplace.
500 00:46:39.340 ⇒ 00:46:43.200 Advait Nandakumar Menon: and search for Omni, so this is directly from their GitHub.
501 00:46:43.340 ⇒ 00:46:46.160 Advait Nandakumar Menon: You have to just install this.
502 00:46:48.580 ⇒ 00:46:51.640 Advait Nandakumar Menon: And make sure you add it to the project you’re working as well.
503 00:46:55.910 ⇒ 00:46:56.830 Amber Lin: Cool.
504 00:46:57.720 ⇒ 00:47:01.069 Advait Nandakumar Menon: And once that’s done, you can…
505 00:47:04.610 ⇒ 00:47:06.600 Advait Nandakumar Menon: Oh, there is the command.
506 00:47:08.600 ⇒ 00:47:11.830 Advait Nandakumar Menon: Yeah, you can just type a prompt like this.
507 00:47:12.280 ⇒ 00:47:19.070 Advait Nandakumar Menon: And it’ll give you some comments first. Then I asked… so it gave me a plan, as such, over here.
508 00:47:19.970 ⇒ 00:47:20.800 Amber Lin: Huh.
509 00:47:21.060 ⇒ 00:47:28.089 Advait Nandakumar Menon: In the Markdown file, like, it should look like this, the KPIs should go on top, and basically the charts are…
510 00:47:28.090 ⇒ 00:47:28.800 Amber Lin: Whoa.
511 00:47:28.800 ⇒ 00:47:36.340 Advait Nandakumar Menon: whatever. And then I asked the Omni… so Omni Content Builder is the one which can build your dashboards.
512 00:47:36.340 ⇒ 00:47:37.140 Amber Lin: Okay.
513 00:47:37.570 ⇒ 00:47:45.690 Advait Nandakumar Menon: there’s a content explorer for you to explore the dashboards, and it is even good at, like, building out the AI context.
514 00:47:45.780 ⇒ 00:47:57.679 Advait Nandakumar Menon: building out the topics and everything, so that’s something I learned from Mustafa. So, I didn’t use it for topic creation before, like, what we merged, the V2 main, I didn’t use it for that, but maybe I’ll use it for the next…
515 00:47:57.680 ⇒ 00:48:07.710 Advait Nandakumar Menon: one, but you can use the Omni AI Optimizer skill to do that, like, it can build topics, refine your AI context, and all those stuff.
516 00:48:11.050 ⇒ 00:48:11.780 Advait Nandakumar Menon: So…
517 00:48:12.170 ⇒ 00:48:19.270 Advait Nandakumar Menon: So, when I called this skill over here, it was going through my API environment variables and all that.
518 00:48:19.460 ⇒ 00:48:21.939 Advait Nandakumar Menon: And it was… it basically wrote the…
519 00:48:22.180 ⇒ 00:48:28.139 Advait Nandakumar Menon: dashboard to, defaults, Omni, portal, and it gave me the link.
520 00:48:28.140 ⇒ 00:48:30.940 Amber Lin: Wow, can you click on that? I wanna see.
521 00:48:31.750 ⇒ 00:48:34.130 Advait Nandakumar Menon: Yeah, I will… she’ll be…
522 00:48:46.490 ⇒ 00:48:50.469 Amber Lin: this, like, all this, they create… I mean, this is not bad.
523 00:48:50.660 ⇒ 00:48:52.990 Advait Nandakumar Menon: No, it didn’t create, it was…
524 00:48:52.990 ⇒ 00:48:53.760 Amber Lin: Okay, okay.
525 00:48:53.760 ⇒ 00:48:59.570 Advait Nandakumar Menon: very bad, so that’s why I’m saying the dashboard creation skill is not good, so I had to rearrange this.
526 00:48:59.740 ⇒ 00:49:12.079 Amber Lin: Oh, I think it… it can generate queries, but then the, like, the four… the layout is bad, and the formatting and stuff is bad, but, like, queries…
527 00:49:12.080 ⇒ 00:49:12.540 Advait Nandakumar Menon: Yeah.
528 00:49:12.540 ⇒ 00:49:13.240 Amber Lin: Fine.
529 00:49:13.780 ⇒ 00:49:29.929 Advait Nandakumar Menon: Yeah, and also some of the… I’m not sure, some of the charts which was previously working before Uttam asked me to look at it, those weren’t loading as well. I had to look at the query and correct it, so… It works, but it’s not there yet. Maybe they’ll improve it.
530 00:49:31.700 ⇒ 00:49:32.430 Amber Lin: Okay.
531 00:49:32.570 ⇒ 00:49:33.260 Amber Lin: Cool.
532 00:49:33.260 ⇒ 00:49:33.930 Advait Nandakumar Menon: Yeah.
533 00:49:34.250 ⇒ 00:49:35.569 Amber Lin: Thanks for showing me!
534 00:49:36.230 ⇒ 00:49:43.860 Amber Lin: Yeah, I answered some of Awesha’s questions, I think he would… He would change it soon?
535 00:49:45.220 ⇒ 00:49:47.839 Advait Nandakumar Menon: Oh, okay. I didn’t see that. Okay.
536 00:49:59.540 ⇒ 00:50:04.530 Amber Lin: Okay, cool. Alright, I’m gonna hop, I have to do slides for another… Yeah.
537 00:50:04.800 ⇒ 00:50:05.679 Amber Lin: Alright, thank you.
538 00:50:05.680 ⇒ 00:50:06.480 Advait Nandakumar Menon: I found someone.
539 00:50:06.770 ⇒ 00:50:07.310 Amber Lin: Alrighty.
540 00:50:07.310 ⇒ 00:50:08.340 Advait Nandakumar Menon: What’s nice all gonna do?
541 00:50:08.340 ⇒ 00:50:10.599 Amber Lin: Yeah, have a good weekend. Bye-bye.
542 00:50:10.600 ⇒ 00:50:12.549 Advait Nandakumar Menon: You too. You too. Bye-bye.