Meeting Title: US x BF | Sprint Kickoff Date: 2025-08-19 Meeting participants: Uttam Kumaran, Demilade Agboola, Amber Lin, Emily Giant
WEBVTT
1 00:00:26.930 ⇒ 00:00:27.770 Demilade Agboola: Here we go.
2 00:00:28.750 ⇒ 00:00:29.880 Uttam Kumaran: Ayy.
3 00:01:33.860 ⇒ 00:01:34.830 Amber Lin: Hello.
4 00:01:35.270 ⇒ 00:01:36.080 Uttam Kumaran: No.
5 00:01:48.640 ⇒ 00:01:50.840 Amber Lin: March Urban Stems.
6 00:01:51.500 ⇒ 00:01:53.139 Amber Lin: Here.
7 00:01:57.320 ⇒ 00:02:03.130 Amber Lin: Okay, so… A few things that carried over.
8 00:02:04.430 ⇒ 00:02:08.030 Amber Lin: So we have the line items.
9 00:02:09.070 ⇒ 00:02:14.040 Amber Lin: The… The transaction models?
10 00:02:15.880 ⇒ 00:02:19.079 Amber Lin: And then I put in the fact.
11 00:02:19.910 ⇒ 00:02:29.630 Amber Lin: models Along with the… weekly, monthly, daily revenue summary.
12 00:02:31.500 ⇒ 00:02:36.350 Amber Lin: So who would be owning which models? How can I assign these?
13 00:02:41.420 ⇒ 00:02:42.190 Demilade Agboola: …
14 00:02:42.520 ⇒ 00:02:56.200 Demilade Agboola: So I think, because I have a bit of space, I pushed the PR for the split line items, so it just remains to tidy up the line items, which shouldn’t be… the split line items is generally more tricky than the line items.
15 00:02:56.680 ⇒ 00:02:59.619 Demilade Agboola: Especially knowing that today.
16 00:02:59.960 ⇒ 00:03:06.690 Demilade Agboola: … I could probably handle, like, the other models, especially. Can we go back… can we go back down?
17 00:03:07.190 ⇒ 00:03:11.010 Demilade Agboola: Thank you. So I could probably do, like…
18 00:03:11.340 ⇒ 00:03:16.119 Demilade Agboola: Facts, transaction, facts, orders, facts of orders.
19 00:03:16.620 ⇒ 00:03:19.890 Demilade Agboola: And also, probably, like, fact line items as well.
20 00:03:20.530 ⇒ 00:03:21.200 Amber Lin: Okay.
21 00:03:21.750 ⇒ 00:03:23.730 Amber Lin: Mmm… Nope.
22 00:03:24.180 ⇒ 00:03:32.520 Amber Lin: And then… this one… I think Utemo assigned to users, you’re also doing the staging transaction.
23 00:03:32.730 ⇒ 00:03:33.410 Uttam Kumaran: Yes.
24 00:03:33.410 ⇒ 00:03:35.150 Amber Lin: Models… oh.
25 00:03:36.660 ⇒ 00:03:37.345 Amber Lin: Damn…
26 00:03:41.630 ⇒ 00:03:42.290 Amber Lin: Nope.
27 00:03:44.340 ⇒ 00:03:48.510 Amber Lin: And then… …
28 00:03:50.060 ⇒ 00:04:00.399 Amber Lin: These are adding dbt tests. Do we do it as we create the models, or do we need a reminder so I can keep these tickets?
29 00:04:03.080 ⇒ 00:04:08.799 Demilade Agboola: Yeah, it’s best to do it as you’re creating the models, but we would always create some after, if we are.
30 00:04:08.800 ⇒ 00:04:10.500 Uttam Kumaran: Yeah, after, yeah.
31 00:04:10.730 ⇒ 00:04:11.400 Amber Lin: Okay.
32 00:04:14.920 ⇒ 00:04:16.410 Amber Lin: And then…
33 00:04:25.960 ⇒ 00:04:26.890 Amber Lin: Alright.
34 00:04:27.700 ⇒ 00:04:35.729 Amber Lin: So for… … Alright, so there’s…
35 00:04:37.700 ⇒ 00:04:42.259 Amber Lin: Subscriptions, summaries, marketing, revenue summaries, and then these…
36 00:04:42.470 ⇒ 00:04:46.870 Amber Lin: Summary tables? How should I assign these?
37 00:04:49.290 ⇒ 00:04:52.190 Amber Lin: Or is that something that we’re not doing this cycle?
38 00:04:54.380 ⇒ 00:05:00.750 Demilade Agboola: I think, ideally… We should be able to get through to this cycle.
39 00:05:01.910 ⇒ 00:05:07.430 Demilade Agboola: But there are no guarantees on that. I think it kind of depends on… especially because…
40 00:05:07.630 ⇒ 00:05:10.480 Demilade Agboola: Things like subscription have not started.
41 00:05:12.220 ⇒ 00:05:21.649 Demilade Agboola: Yeah, because we’re still trying to integrate, like, loop into all of this. So we might get to, like, ideally we would want to, but there’s no guarantees.
42 00:05:24.740 ⇒ 00:05:25.620 Amber Lin: I see.
43 00:05:32.040 ⇒ 00:05:34.239 Amber Lin: I’ll keep it down here for now.
44 00:05:34.780 ⇒ 00:05:41.429 Amber Lin: Can I… Is there anything here that we can close on?
45 00:05:41.430 ⇒ 00:05:47.970 Uttam Kumaran: Yeah, any… anything on loop, Anything on polyatomic, just assign to me. I don’t… I don’t think…
46 00:05:48.490 ⇒ 00:05:50.369 Uttam Kumaran: It needs to go to you, Amber.
47 00:05:51.900 ⇒ 00:05:56.180 Uttam Kumaran: Yeah, like, all… like, all of these you could just put on me.
48 00:05:56.500 ⇒ 00:06:01.949 Amber Lin: Oh, I think I’ve assigned them to me so that I can remember to check in.
49 00:06:01.950 ⇒ 00:06:04.170 Uttam Kumaran: Oh, okay, okay, okay, okay, never mind that.
50 00:06:04.170 ⇒ 00:06:05.000 Amber Lin: Yeah.
51 00:06:07.370 ⇒ 00:06:11.200 Amber Lin: … Are these ones?
52 00:06:11.630 ⇒ 00:06:13.950 Amber Lin: Can we close, though?
53 00:06:15.300 ⇒ 00:06:18.429 Uttam Kumaran: I don’t believe they’ve been merged yet, but….
54 00:06:18.430 ⇒ 00:06:19.649 Amber Lin: Okay, I see.
55 00:06:20.150 ⇒ 00:06:21.449 Uttam Kumaran: They’re still in review.
56 00:06:21.730 ⇒ 00:06:22.440 Amber Lin: Okay.
57 00:06:23.620 ⇒ 00:06:28.809 Uttam Kumaran: And then, is there anything on, … Yeah, there’s a couple of….
58 00:06:28.810 ⇒ 00:06:30.399 Emily Giant: Those have definitely been merged.
59 00:06:30.400 ⇒ 00:06:31.030 Uttam Kumaran: I guess… Oh, okay.
60 00:06:31.030 ⇒ 00:06:36.469 Emily Giant: That’s why I turned off the jobs. I just had to tweak the YAML file, and….
61 00:06:36.930 ⇒ 00:06:37.490 Uttam Kumaran: IRA.
62 00:06:37.490 ⇒ 00:06:38.370 Emily Giant: Those are done.
63 00:06:38.550 ⇒ 00:06:39.220 Uttam Kumaran: Okay.
64 00:06:39.440 ⇒ 00:06:57.379 Emily Giant: Although, I do have some questions, like, not for today, but about DIM customers and, like, how we’re integrating that into some of the, downstream tables with LMS as the source of truth, but it’s more just for my clarification. But I’ll either throw time on your calendar or, like, write you a sync.
65 00:07:01.540 ⇒ 00:07:06.490 Amber Lin: This… I think this one can also be closed.
66 00:07:06.900 ⇒ 00:07:08.749 Amber Lin: Polyatomic and North Dream.
67 00:07:12.010 ⇒ 00:07:12.750 Emily Giant: ….
68 00:07:13.130 ⇒ 00:07:19.339 Uttam Kumaran: This is also in review still. I have yesterday been working on some of these failures, I did not confirm this.
69 00:07:19.910 ⇒ 00:07:20.500 Amber Lin: Okay.
70 00:07:25.650 ⇒ 00:07:27.620 Amber Lin: Alright, …
71 00:07:32.360 ⇒ 00:07:33.330 Amber Lin: Alright.
72 00:07:35.480 ⇒ 00:07:42.759 Amber Lin: How should I… What can you get done this week, and what will have to be for next week?
73 00:07:42.920 ⇒ 00:07:47.699 Uttam Kumaran: … So, the subscriptions revenue will be for next week.
74 00:07:47.850 ⇒ 00:07:52.599 Amber Lin: Anything related to subscriptions, because we don’t have Lupin yet, so…
75 00:07:54.990 ⇒ 00:08:07.800 Emily Giant: And there’s gonna be a lot of work on, like, aligning historical, and, like, after inventory, I feel like, just because I have, like, the institutional knowledge, if you want to assign me, like, the historical
76 00:08:07.940 ⇒ 00:08:08.820 Emily Giant: Work.
77 00:08:09.100 ⇒ 00:08:16.210 Emily Giant: so that y’all can focus on, like, building out how it’s supposed to be. I’m totally good with that.
78 00:08:16.560 ⇒ 00:08:22.330 Amber Lin: Hmm. Do we have a… What would that ticket be called? I don’t think we have that yet.
79 00:08:25.650 ⇒ 00:08:40.039 Emily Giant: I think we need to make sure we do that for every mart. Like, I’m finding that even with inventory, I’m still working through just, like, streamlining some of the historical stuff, because I hadn’t, like, put enough thought into it. That was no fault of Polytomic. That was me not, like…
80 00:08:40.140 ⇒ 00:08:49.610 Emily Giant: expressing how shitty, our historical inventory was. But revenue’s the same way. Like.
81 00:08:49.820 ⇒ 00:08:50.330 Amber Lin: Okay.
82 00:08:50.330 ⇒ 00:08:55.229 Emily Giant: Demolati’s very briefed on that, though. Like, we had a whole working session just about, like.
83 00:08:55.420 ⇒ 00:09:01.650 Emily Giant: Certain things that have been incorrect regarding revenue, Forever.
84 00:09:02.830 ⇒ 00:09:11.059 Amber Lin: Okay so I can make you a ticket per model, is that something that we should do?
85 00:09:11.320 ⇒ 00:09:12.220 Emily Giant: Yeah.
86 00:09:12.380 ⇒ 00:09:13.610 Emily Giant: I, I think so.
87 00:09:13.610 ⇒ 00:09:14.330 Amber Lin: Okay.
88 00:09:16.680 ⇒ 00:09:19.310 Amber Lin: Where would you… what would you start with?
89 00:09:21.120 ⇒ 00:09:22.020 Emily Giant: …
90 00:09:22.220 ⇒ 00:09:37.210 Emily Giant: for subscriptions, I think it depends on, like, what loop integration’s gonna look like, because we have 3 different subscription, legacy programs that we used, and I think that, like, with revenue, Demolade
91 00:09:37.210 ⇒ 00:09:44.399 Emily Giant: he gets the gist of, like, the historical. But subscriptions are, like, very specific and have never been correct.
92 00:09:44.610 ⇒ 00:09:46.959 Emily Giant: So I feel like that one would take…
93 00:09:47.170 ⇒ 00:09:48.919 Emily Giant: A lot more time to, like.
94 00:09:49.060 ⇒ 00:09:53.279 Emily Giant: pass off to anyone else. I would say, like, align, …
95 00:09:55.640 ⇒ 00:09:59.690 Emily Giant: There’s probably, like, two different sections of this, which is, like.
96 00:09:59.900 ⇒ 00:10:12.579 Emily Giant: Sticky was our previous subscription provider, and then before that, we, like, hosted it ourselves in admin. So, I don’t know if we want to break those into chunks, or just say, like, align legacy subscriptions to…
97 00:10:12.770 ⇒ 00:10:21.800 Emily Giant: updated Mart model, but in my mind, like, the new MART would need to be done first for me to know how to align these.
98 00:10:24.250 ⇒ 00:10:28.010 Emily Giant: Does that make sense, Utam? Yeah, I don’t want to… Yeah, okay.
99 00:10:28.230 ⇒ 00:10:28.950 Uttam Kumaran: Yes.
100 00:10:29.880 ⇒ 00:10:37.199 Emily Giant: And, like, that’s kind of what happened with inventory, which, you know, live and learn. We didn’t know what the mart was gonna…
101 00:10:37.590 ⇒ 00:10:42.159 Emily Giant: we didn’t know how to, like, do historical before the new setup was done. So, like…
102 00:10:42.370 ⇒ 00:10:46.399 Emily Giant: It was just impossible to align it until we knew exactly what we wanted.
103 00:10:48.950 ⇒ 00:10:49.830 Amber Lin: I see.
104 00:10:50.800 ⇒ 00:10:58.300 Amber Lin: … Alright, is there any other historical-related tickets that you want to add?
105 00:10:59.030 ⇒ 00:11:01.970 Emily Giant: Subscriptions is the biggest, …
106 00:11:04.100 ⇒ 00:11:07.160 Emily Giant: Let me think, let me think. Not off the top of my head.
107 00:11:07.420 ⇒ 00:11:13.750 Emily Giant: Okay. But I do think there’s gonna be a large component of that in, the marketing focus.
108 00:11:14.110 ⇒ 00:11:18.490 Amber Lin: With, like, GA4 data versus North Beam.
109 00:11:18.690 ⇒ 00:11:23.469 Emily Giant: versus what we can sub in with Shopify, native data tables, blah blah blah.
110 00:11:23.470 ⇒ 00:11:25.750 Amber Lin: But their data is….
111 00:11:26.820 ⇒ 00:11:29.990 Emily Giant: Really all over the place when it comes to historicals.
112 00:11:30.410 ⇒ 00:11:31.130 Amber Lin: I see.
113 00:11:31.600 ⇒ 00:11:35.949 Amber Lin: So that should be… What should I call the ticket?
114 00:11:36.150 ⇒ 00:11:43.660 Emily Giant: Maybe historical… … Paid media?
115 00:11:44.680 ⇒ 00:11:49.200 Emily Giant: mart alignment, or something like that? Because it’s the paid media aspect of it that’s, like….
116 00:11:49.200 ⇒ 00:11:49.770 Amber Lin: Hmm.
117 00:11:50.160 ⇒ 00:11:53.959 Emily Giant: Or paid marketing channels, that’s, like, a total show.
118 00:11:56.740 ⇒ 00:12:02.070 Amber Lin: Is this blocked by any of the current work? What needs to get done for you to start this?
119 00:12:02.070 ⇒ 00:12:04.479 Emily Giant: It would… it would be, North Beam.
120 00:12:04.840 ⇒ 00:12:05.690 Amber Lin: I see.
121 00:12:09.750 ⇒ 00:12:10.750 Amber Lin: Alright.
122 00:12:12.760 ⇒ 00:12:14.319 Amber Lin: I’ll create it there.
123 00:12:14.630 ⇒ 00:12:17.729 Amber Lin: Can I close this one?
124 00:12:18.860 ⇒ 00:12:20.289 Emily Giant: Yes, yes you can.
125 00:12:20.290 ⇒ 00:12:20.850 Amber Lin: Okay.
126 00:12:21.610 ⇒ 00:12:23.170 Amber Lin: So that’s done.
127 00:12:27.700 ⇒ 00:12:30.089 Amber Lin: And, ….
128 00:12:32.300 ⇒ 00:12:35.379 Emily Giant: Those just carry them over.
129 00:12:35.750 ⇒ 00:12:40.079 Emily Giant: They’re not really… blocking anything?
130 00:12:40.080 ⇒ 00:12:41.150 Amber Lin: Huh.
131 00:12:41.150 ⇒ 00:12:50.210 Emily Giant: But they do need to be done for, like, more for, like, internal urban settings purposes, I’m just keeping them there, but, like, you don’t have to count those against
132 00:12:50.470 ⇒ 00:12:55.500 Emily Giant: Like, your progress reports. Those are more, like.
133 00:12:56.300 ⇒ 00:13:01.139 Emily Giant: for my own sanity, I move certain things into here so I’m not, like, on 3 different project planning boards.
134 00:13:01.140 ⇒ 00:13:02.200 Amber Lin: Hmm.
135 00:13:02.410 ⇒ 00:13:03.190 Emily Giant: Yeah.
136 00:13:03.190 ⇒ 00:13:08.300 Amber Lin: After ComponentsXF, that one is very revenue-related and had a lot of bugs.
137 00:13:08.720 ⇒ 00:13:09.080 Amber Lin: fault.
138 00:13:09.080 ⇒ 00:13:14.999 Emily Giant: really push Demolade’s work forward. I’m almost… I’m almost done with it. I’d probably give it two more days.
139 00:13:15.450 ⇒ 00:13:20.090 Amber Lin: Okay, testing. And then this one… is this inventory?
140 00:13:20.600 ⇒ 00:13:21.159 Amber Lin: Or is it….
141 00:13:21.160 ⇒ 00:13:21.850 Emily Giant: Everyone?
142 00:13:21.850 ⇒ 00:13:23.580 Amber Lin: Shopify session data and look.
143 00:13:24.100 ⇒ 00:13:25.390 Emily Giant: That’s revenue.
144 00:13:26.440 ⇒ 00:13:27.370 Amber Lin: Great.
145 00:13:28.010 ⇒ 00:13:30.770 Amber Lin: And then these are still, to-do.
146 00:13:31.650 ⇒ 00:13:33.689 Emily Giant: For a sub, yeah…
147 00:13:34.120 ⇒ 00:13:50.020 Emily Giant: And then the GA4 one is in progress. I’m trying to pass it off to PK. He’s the, the developer on the marketing team, and I don’t think we want to, like, start bringing him into the fold once we have North Beam data. Like, we can definitely pass off some of the, modeling data.
148 00:13:50.320 ⇒ 00:13:58.969 Amber Lin: Yeah, he’s in our ticketing board. Would you like him to start joining our stand-up, or start having tasks assigned to him?
149 00:13:58.970 ⇒ 00:14:01.119 Emily Giant: Let me ask his supervisor, if that’s okay.
150 00:14:01.120 ⇒ 00:14:01.760 Amber Lin: Okay.
151 00:14:01.760 ⇒ 00:14:03.039 Emily Giant: And then I will, yeah.
152 00:14:03.040 ⇒ 00:14:03.740 Amber Lin: Great.
153 00:14:04.260 ⇒ 00:14:05.040 Amber Lin: Okay.
154 00:14:05.580 ⇒ 00:14:10.519 Amber Lin: … Let me sort this by…
155 00:14:12.630 ⇒ 00:14:23.850 Amber Lin: Due date. So, Utam, right here, I see the transaction models for this week, and then subscriptions for next week.
156 00:14:24.600 ⇒ 00:14:28.780 Amber Lin: When would we be doing these two?
157 00:14:32.400 ⇒ 00:14:38.309 Uttam Kumaran: So, refunds will be… this week?
158 00:14:41.270 ⇒ 00:14:44.450 Uttam Kumaran: I’m not sure about 294, probably next week.
159 00:14:44.450 ⇒ 00:14:50.779 Demilade Agboola: Just very random. I think we also need to, like, Make a decision on, like.
160 00:14:51.150 ⇒ 00:14:53.350 Demilade Agboola: How we want to attack this.
161 00:14:53.350 ⇒ 00:14:53.890 Uttam Kumaran: Yeah.
162 00:14:53.990 ⇒ 00:14:57.939 Demilade Agboola: This is from OMS data, but, like, Shopify has its data already.
163 00:14:57.940 ⇒ 00:14:58.790 Amber Lin: Yeah.
164 00:14:58.790 ⇒ 00:15:03.059 Demilade Agboola: data, and it’s part of what I modeled in the other line items.
165 00:15:03.060 ⇒ 00:15:03.910 Uttam Kumaran: Okay.
166 00:15:03.910 ⇒ 00:15:07.200 Demilade Agboola: The advantage of OMS is it goes further back.
167 00:15:08.140 ⇒ 00:15:14.729 Demilade Agboola: And in some cases, in some cases, it already has some information already added to it. …
168 00:15:15.020 ⇒ 00:15:19.039 Demilade Agboola: that Shopify data doesn’t have already. …
169 00:15:19.550 ⇒ 00:15:24.250 Demilade Agboola: But, historically speaking, some parts of it are messy.
170 00:15:25.090 ⇒ 00:15:29.809 Demilade Agboola: And that’s where Shopify, you know, obviously has the advantage.
171 00:15:31.510 ⇒ 00:15:43.099 Demilade Agboola: So, I think for certain, maybe certain time periods, we could just model it, strictly off of Shopify data. And prior to that, we can also then… we can then use, like, QMS data.
172 00:15:44.230 ⇒ 00:15:52.940 Emily Giant: I think that’s a good approach. And I’m wondering, like, so, Demolade, I’m trying to work on that ComponentsXF model that, like, has
173 00:15:53.140 ⇒ 00:15:58.030 Emily Giant: The lack of removing the, … Forced upgrades.
174 00:15:58.730 ⇒ 00:16:01.080 Emily Giant: And I… I don’t know how we’re gonna…
175 00:16:01.610 ⇒ 00:16:07.530 Emily Giant: backfill that through history, but I feel like it’s gonna have to be, like, some table that does not yet exist.
176 00:16:07.740 ⇒ 00:16:08.800 Emily Giant: for those.
177 00:16:10.090 ⇒ 00:16:12.610 Emily Giant: Or some, like, data feed that doesn’t.
178 00:16:15.100 ⇒ 00:16:17.529 Emily Giant: Like, I might have to build it in Hivo myself.
179 00:16:20.900 ⇒ 00:16:21.990 Demilade Agboola: ….
180 00:16:22.320 ⇒ 00:16:24.460 Amber Lin: What does it mean for this ticket?
181 00:16:25.430 ⇒ 00:16:28.529 Emily Giant: I think I can still work on Future State.
182 00:16:29.650 ⇒ 00:16:36.239 Emily Giant: and, like, set it up for just using Shopify and OMS, like, because we don’t need to get rid of the OMS
183 00:16:36.520 ⇒ 00:16:42.669 Emily Giant: data tables, they’re just not as reliable, as Shopify, because that’s, like.
184 00:16:43.530 ⇒ 00:16:48.249 Emily Giant: Reliable’s not the word. We may move away from Dash, we’re not moving away from Shopify.
185 00:16:48.740 ⇒ 00:16:53.669 Emily Giant: So, the more we can lean on Shopify as our, like, source of truth, the better.
186 00:16:54.020 ⇒ 00:16:54.750 Emily Giant: ….
187 00:16:54.750 ⇒ 00:17:05.909 Uttam Kumaran: Yeah, so we’re gonna be moving… so that’s something that I already started looking into. We’re gonna be moving everything off of OMS using Shopify as source of truth for as much as possible.
188 00:17:06.180 ⇒ 00:17:07.040 Uttam Kumaran: …
189 00:17:07.170 ⇒ 00:17:13.290 Uttam Kumaran: So these are all sort of linked, I guess, like, all of these will be completed this sprint, I just don’t know what the timing is gonna be.
190 00:17:13.970 ⇒ 00:17:15.950 Amber Lin: Hmm, I’ll say end of cycle then.
191 00:17:15.950 ⇒ 00:17:16.540 Uttam Kumaran: Excellent.
192 00:17:19.930 ⇒ 00:17:20.940 Amber Lin: Right.
193 00:17:25.810 ⇒ 00:17:26.690 Amber Lin: H.
194 00:17:27.030 ⇒ 00:17:33.480 Amber Lin: Okay, let’s look at… Yeah, kids. Oh, which I’m also…
195 00:17:34.020 ⇒ 00:17:38.990 Amber Lin: These redshift tickets are… are we still doing them?
196 00:17:40.570 ⇒ 00:17:42.549 Amber Lin: I can put them to backlog.
197 00:17:42.550 ⇒ 00:17:44.369 Uttam Kumaran: Let’s move on to the backlog.
198 00:17:44.370 ⇒ 00:17:48.239 Amber Lin: Yeah, this is just related to the views, which is very minimal.
199 00:17:48.470 ⇒ 00:17:54.320 Amber Lin: And then… This one… Like…
200 00:17:55.400 ⇒ 00:17:59.810 Amber Lin: Kyle needed some help on. I’ll put it to backlog for now.
201 00:18:01.850 ⇒ 00:18:06.490 Amber Lin: For Metaplain, is it still… still going on, or is it….
202 00:18:06.490 ⇒ 00:18:11.259 Uttam Kumaran: Yeah, this is actually something that will be done this week. I’m actually halfway through that today.
203 00:18:11.260 ⇒ 00:18:12.950 Amber Lin: Awesome. Alright.
204 00:18:13.840 ⇒ 00:18:15.659 Amber Lin: Alright, let’s go up….
205 00:18:17.030 ⇒ 00:18:18.130 Uttam Kumaran: Here….
206 00:18:18.850 ⇒ 00:18:26.279 Amber Lin: … Is this part… is this done? Is… I know the DIM products is done.
207 00:18:31.370 ⇒ 00:18:35.180 Uttam Kumaran: I… you can assign it to me, I need to confirm this.
208 00:18:35.420 ⇒ 00:18:36.430 Amber Lin: Okay.
209 00:18:40.200 ⇒ 00:18:42.950 Uttam Kumaran: Yeah, I need to check, I didn’t see this, actually.
210 00:18:48.580 ⇒ 00:18:52.270 Emily Giant: Tom, I can drop into that ticket, like, the name of the table that I.
211 00:18:52.270 ⇒ 00:18:52.630 Uttam Kumaran: Excellent.
212 00:18:52.630 ⇒ 00:18:58.379 Emily Giant: recently built, and you can audit it, but it works pretty well so far. It’s built off of Shopify.
213 00:18:59.610 ⇒ 00:19:00.490 Uttam Kumaran: Okay.
214 00:19:03.590 ⇒ 00:19:09.750 Amber Lin: For these, semi, which one do you think you will complete this week?
215 00:19:12.980 ⇒ 00:19:26.970 Demilade Agboola: This week? … I’ll probably say… I mean, 284… And… We might need to, like…
216 00:19:28.120 ⇒ 00:19:34.239 Demilade Agboola: I mean, I need to, like, look into 273 and, like, what exactly we want to do, for that, because…
217 00:19:34.590 ⇒ 00:19:38.610 Demilade Agboola: We might not necessarily need it if we have a good staging line item, but we’ll see.
218 00:19:38.740 ⇒ 00:19:44.610 Demilade Agboola: … But I will look into 27… 273-2A4 this week.
219 00:19:45.710 ⇒ 00:19:51.589 Demilade Agboola: Potentially… … 282.
220 00:19:53.040 ⇒ 00:19:54.670 Amber Lin: Okay.
221 00:19:56.440 ⇒ 00:20:01.820 Amber Lin: Alright, and I’ll have the facts, suborders, orders, for….
222 00:20:02.190 ⇒ 00:20:03.149 Demilade Agboola: End of cycle.
223 00:20:03.150 ⇒ 00:20:08.590 Amber Lin: In the cycle. I think this is actually what Otum did.
224 00:20:09.680 ⇒ 00:20:13.859 Amber Lin: … Chess short that.
225 00:20:14.150 ⇒ 00:20:20.850 Amber Lin: And then… See, these are end of cycle.
226 00:20:21.420 ⇒ 00:20:25.550 Amber Lin: That can be end of… This week.
227 00:20:25.950 ⇒ 00:20:27.010 Amber Lin: Alright.
228 00:20:27.510 ⇒ 00:20:35.290 Amber Lin: Is there anything that… Like, for…
229 00:20:36.080 ⇒ 00:20:43.550 Amber Lin: These inventory tickets has been here for a while. Are they valid? Should I backlog them?
230 00:20:43.550 ⇒ 00:20:48.690 Uttam Kumaran: Yeah, I guess them a lot of, like, well, how do you want to close out the inventory, the, like, these three?
231 00:20:49.570 ⇒ 00:20:52.369 Uttam Kumaran: Like, do you want to take that on first, or…?
232 00:20:52.710 ⇒ 00:20:53.640 Emily Giant: No.
233 00:20:54.050 ⇒ 00:21:03.799 Demilade Agboola: No, so for 2 to 9, I think that’s, like, there’s basically a blocker with that. Like, it’s basically a system issue, we need, like, Alex to…
234 00:21:04.660 ⇒ 00:21:05.689 Demilade Agboola: Backfield to data.
235 00:21:05.690 ⇒ 00:21:09.170 Emily Giant: So that part’s working now, but it’s not backfilled.
236 00:21:09.440 ⇒ 00:21:11.069 Emily Giant: So I still need to, like.
237 00:21:11.360 ⇒ 00:21:16.010 Emily Giant: You can assign that to me, honestly. Like, I’d rather have done a lot of working on, ….
238 00:21:16.010 ⇒ 00:21:16.480 Uttam Kumaran: Okay.
239 00:21:18.130 ⇒ 00:21:26.199 Emily Giant: And that’s pretty tied into what I’m working on right now, so… It just needs, like, the historical context for forced upgrades, but going forward, that part’s done.
240 00:21:26.340 ⇒ 00:21:27.460 Amber Lin: Okay.
241 00:21:27.810 ⇒ 00:21:30.379 Amber Lin: What about these two?
242 00:21:32.430 ⇒ 00:21:36.559 Emily Giant: I would just… The inventory-related items?
243 00:21:37.440 ⇒ 00:21:38.469 Demilade Agboola: That’s stupid.
244 00:21:38.920 ⇒ 00:21:40.350 Emily Giant: Go for it, Delaney, sorry.
245 00:21:40.540 ⇒ 00:21:46.789 Demilade Agboola: Yeah, so I think for those part, I think since we’ve already, like, rolled out the data.
246 00:21:48.070 ⇒ 00:21:54.699 Demilade Agboola: Like, it’s available in Looker. So I think this part is largely done.
247 00:21:54.850 ⇒ 00:21:55.460 Emily Giant: Yeah.
248 00:21:55.930 ⇒ 00:22:02.159 Demilade Agboola: … And then… the renaming and restructuring, like, I think…
249 00:22:02.390 ⇒ 00:22:08.559 Demilade Agboola: so far, the structure is pretty good. There isn’t, like, anything to necessarily do, per se.
250 00:22:08.560 ⇒ 00:22:09.180 Amber Lin: Hmm.
251 00:22:09.330 ⇒ 00:22:10.670 Demilade Agboola: In terms of this.
252 00:22:10.670 ⇒ 00:22:15.120 Amber Lin: And backlog them, just in case we need to check in the future.
253 00:22:15.550 ⇒ 00:22:16.400 Amber Lin: Okay.
254 00:22:16.580 ⇒ 00:22:17.860 Amber Lin: That’s….
255 00:22:17.860 ⇒ 00:22:37.799 Emily Giant: I know that this is, like, later on. One thing I would say, like, our, refreshes for the inventory mart, I flagged this this morning, but they went from, like, 10 minutes to, like, an hour, and I don’t know if we, like, need to review the incremental logic or add it in some of the models, but I just… I did want to flag that as maybe something to add to this cycle.
256 00:22:39.790 ⇒ 00:22:43.100 Emily Giant: Just because the collisions keep happening, and then they time out, and….
257 00:22:43.100 ⇒ 00:22:43.520 Uttam Kumaran: Yeah.
258 00:22:43.990 ⇒ 00:22:45.430 Amber Lin: Who would take that?
259 00:22:45.430 ⇒ 00:22:47.970 Uttam Kumaran: I’m taking that right now.
260 00:22:48.300 ⇒ 00:22:50.990 Uttam Kumaran: So, I think there is a ticket on… yeah.
261 00:22:50.990 ⇒ 00:22:51.720 Amber Lin: establishment?
262 00:22:52.450 ⇒ 00:22:55.780 Uttam Kumaran: So this one, you can just set the priority as urgent. That’s, ….
263 00:22:56.630 ⇒ 00:22:59.719 Emily Giant: That is actually what I’m going to be working on right now.
264 00:23:00.080 ⇒ 00:23:00.810 Amber Lin: Okay.
265 00:23:01.610 ⇒ 00:23:04.910 Uttam Kumaran: But I basically need to clear up, and we need to see at least, like.
266 00:23:05.200 ⇒ 00:23:10.460 Uttam Kumaran: If I fix it today, we need to see it working until the end of the week, otherwise I’m just gonna kind of keep iterating on this.
267 00:23:10.730 ⇒ 00:23:15.329 Emily Giant: Utom, could you wait till tomorrow to do it, just because I’m gonna deploy something that will, like.
268 00:23:16.220 ⇒ 00:23:21.270 Emily Giant: significantly change what’s even necessary to have in the daily refresh.
269 00:23:21.390 ⇒ 00:23:22.330 Uttam Kumaran: Okay.
270 00:23:22.330 ⇒ 00:23:27.360 Emily Giant: like, the… the big historical, inventory update, I’m gonna be able to, like.
271 00:23:27.870 ⇒ 00:23:32.449 Emily Giant: archive half of those things that make it take too long. So…
272 00:23:33.140 ⇒ 00:23:35.730 Emily Giant: It will just be better use of your time tomorrow.
273 00:23:35.730 ⇒ 00:23:43.730 Uttam Kumaran: Yeah, all I did is I, I just, re-ran the inventory refresh with no timeout.
274 00:23:44.160 ⇒ 00:23:48.259 Uttam Kumaran: So I just want to see how long it takes to end.
275 00:23:48.260 ⇒ 00:23:48.730 Emily Giant: Yeah.
276 00:23:48.750 ⇒ 00:23:54.249 Uttam Kumaran: So let’s just do that, and I’m… yeah, let’s just see how long that takes.
277 00:23:54.460 ⇒ 00:23:55.260 Emily Giant: Cool.
278 00:23:58.270 ⇒ 00:23:59.120 Amber Lin: Awesome.
279 00:23:59.710 ⇒ 00:24:06.990 Amber Lin: … Right, anything… Else, I think we’re good to go.
280 00:24:12.130 ⇒ 00:24:13.120 Amber Lin: Alright.
281 00:24:13.730 ⇒ 00:24:14.830 Amber Lin: ….
282 00:24:15.210 ⇒ 00:24:23.549 Emily Giant: Oh, I have one other thing, one question, just while we’re all here. Demolade, the snapshots, in my instance, like, how do you…
283 00:24:24.100 ⇒ 00:24:34.550 Emily Giant: update a snapshot. Like, remember we talked about me adding surrogate key instead of the inventory number ID as, like, the unique identifier for the inventory mark? It will not let me successfully do that.
284 00:24:36.080 ⇒ 00:24:42.209 Demilade Agboola: I’m not exactly sure I understand what you mean by it wouldn’t succe- like, when you think, what happens, what error do you see?
285 00:24:42.530 ⇒ 00:24:44.669 Emily Giant: It just says, like, it doesn’t exist.
286 00:24:45.400 ⇒ 00:24:45.980 Emily Giant: In the.
287 00:24:45.980 ⇒ 00:24:46.750 Demilade Agboola: But hot.
288 00:24:47.070 ⇒ 00:24:51.329 Demilade Agboola: Have you pushed the surrogate… have you added the surrogate key to the model?
289 00:24:51.330 ⇒ 00:24:52.100 Emily Giant: Yes.
290 00:24:52.630 ⇒ 00:24:55.460 Demilade Agboola: And have you run that model? Does it exist?
291 00:24:55.970 ⇒ 00:25:02.159 Emily Giant: Yes. Even if I run, like, a full refresh up until the snapshot, it won’t…
292 00:25:02.370 ⇒ 00:25:05.050 Emily Giant: I’ll do a screen recording and send it to you.
293 00:25:05.380 ⇒ 00:25:06.480 Demilade Agboola: Alright, great.
294 00:25:06.480 ⇒ 00:25:07.920 Emily Giant: Yeah, that’d be easier.
295 00:25:12.520 ⇒ 00:25:13.190 Amber Lin: Okay.
296 00:25:14.040 ⇒ 00:25:18.880 Amber Lin: … No, that seems to be…
297 00:25:19.360 ⇒ 00:25:21.250 Amber Lin: What we have for this cycle.
298 00:25:21.510 ⇒ 00:25:27.220 Amber Lin: … We have a stand-up tomorrow. We could…
299 00:25:27.650 ⇒ 00:25:46.920 Amber Lin: do that async. Actually, I’m gonna be out on Thursday and Friday, so I think we’ll have stand-up tomorrow. Thursday we’re meeting with the analysts, and then tomorrow we can talk about if there’s anything we want to present to them, or have a
300 00:25:47.040 ⇒ 00:25:51.710 Amber Lin: brief working session with them, and then we… that’s for Thursday.
301 00:25:51.710 ⇒ 00:25:52.250 Uttam Kumaran: Okay.
302 00:25:53.700 ⇒ 00:25:54.340 Amber Lin: Okay.
303 00:25:54.670 ⇒ 00:25:56.680 Amber Lin: Alright, thanks everyone, I’ll see you tomorrow.
304 00:25:56.680 ⇒ 00:25:58.290 Uttam Kumaran: Hi, thanks.
305 00:25:58.290 ⇒ 00:25:58.840 Amber Lin: ain’t….