Meeting Title: US x BF | Standup Date: 2025-06-23 Meeting participants: Emily Giant, Amber Lin, Demilade Agboola, Caio Velasco
WEBVTT
1 00:00:15.360 ⇒ 00:00:19.419 Emily Giant: Good morning or afternoon morning for you. That’s right.
2 00:00:21.120 ⇒ 00:00:22.290 Amber Lin: Hello!
3 00:00:24.510 ⇒ 00:00:26.890 Amber Lin: Oh, I see a cat calendar!
4 00:00:27.280 ⇒ 00:00:33.530 Emily Giant: This cat everything, every view will have a different view of cat.
5 00:00:34.720 ⇒ 00:00:38.000 Emily Giant: I think both of the cats are inside right now.
6 00:00:38.380 ⇒ 00:00:46.419 Emily Giant: We usually have. We have tracker collars, and they have both successfully lost them. So they’re not allowed to go outside without them. So they’re just stuck inside.
7 00:00:48.440 ⇒ 00:00:50.439 Amber Lin: How long have you had the cat?
8 00:00:51.328 ⇒ 00:01:06.799 Emily Giant: One of them is not our cat. He wandered up onto the porch like 7 or 8 months ago, and has never left. He’s but he’s a little older. He’s such a bruiser, a ridiculous looking cat, the other one. She’s 3.
9 00:01:07.200 ⇒ 00:01:07.850 Amber Lin: Hmm.
10 00:01:08.090 ⇒ 00:01:10.259 Emily Giant: And we’ve had her since she was a kitten. So we’ve had her a while.
11 00:01:10.640 ⇒ 00:01:12.209 Emily Giant: You know. She’s very sweet.
12 00:01:12.530 ⇒ 00:01:13.220 Amber Lin: Cute.
13 00:01:14.690 ⇒ 00:01:15.920 Emily Giant: Okay.
14 00:01:17.130 ⇒ 00:01:23.290 Amber Lin: We have 2 meetings today, we have this one. And then we have a okay.
15 00:01:25.050 ⇒ 00:01:28.309 Amber Lin: Okay. Kyle, I wouldn’t mind.
16 00:01:28.750 ⇒ 00:01:30.125 Caio Velasco: Just so that you know.
17 00:01:30.400 ⇒ 00:01:30.845 Emily Giant: No.
18 00:01:35.320 ⇒ 00:01:45.370 Amber Lin: Okay, I still need to do that. Okay, looking at these tickets.
19 00:01:47.139 ⇒ 00:01:53.879 Amber Lin: let’s start with Emily’s tickets. How are these 2.
20 00:01:54.080 ⇒ 00:02:22.140 Emily Giant: I worked literally all 4 days that I had off on, still fixing the everything that happened. So they’re not done. But I am in like internal review of all the changes that I made for the 5,000 issues that broke our looker everything last week. So not done. I realize it’s a blocker. I’m sorry, but I I will do them absolutely next. I can’t imagine what would get in front of them.
21 00:02:22.790 ⇒ 00:02:23.630 Amber Lin: Okay.
22 00:02:23.630 ⇒ 00:02:24.280 Emily Giant: Yes.
23 00:02:24.360 ⇒ 00:02:30.879 Amber Lin: Okay, okay. Sounds good for them. Audit. What about your tickets?
24 00:02:33.120 ⇒ 00:02:40.589 Demilade Agboola: Oh, so for me, I was actually just updating them. So for me, I’m about to send the Pr. In the next like couple of hours, so that would have
25 00:02:42.032 ⇒ 00:02:43.990 Demilade Agboola: the staging like
26 00:02:44.950 ⇒ 00:02:54.400 Demilade Agboola: the staging orders that was supposed to be last week Friday as well as due today, so that staging delivery area and staging or something.
27 00:02:54.951 ⇒ 00:03:07.938 Demilade Agboola: So I will do that, and I’ll tag Emmy to review the one that I’m behind on is also auditing, like the revenue March rebuild plan. But, to be honest, I’ve had a call with
28 00:03:08.720 ⇒ 00:03:13.540 Demilade Agboola: Kyle today. And so I think that has empowered him to be
29 00:03:14.534 ⇒ 00:03:21.169 Demilade Agboola: on it a bit, but I will definitely be. Look at it more today, tomorrow.
30 00:03:21.670 ⇒ 00:03:22.370 Amber Lin: Okay.
31 00:03:22.540 ⇒ 00:03:34.929 Amber Lin: I mean all of these we still have today to close out. So probably. Well, we should be on track to deliver most of this by today.
32 00:03:36.750 ⇒ 00:03:40.959 Amber Lin: And then we’ll see what gets carried over to the next cycle.
33 00:03:42.020 ⇒ 00:03:43.420 Demilade Agboola: Okay. Sounds good.
34 00:03:43.420 ⇒ 00:03:44.070 Amber Lin: Yeah.
35 00:03:45.348 ⇒ 00:03:49.829 Amber Lin: For Kyle, what do you? How are your tickets?
36 00:03:51.060 ⇒ 00:03:58.699 Caio Velasco: So today I had this conversation with Emilade and then also with Utah, the Utah one. It’s the 1, 44,
37 00:03:59.080 ⇒ 00:04:04.639 Caio Velasco: and we didn’t talk only about the deprecation, but also the modeling part.
38 00:04:04.900 ⇒ 00:04:14.060 Caio Velasco: So. But, for example, if you go to the deprecation, one which is 1, 1 4, yes.
39 00:04:14.240 ⇒ 00:04:21.089 Caio Velasco: I already posted at the end that this work is actually still a lot of things to do.
40 00:04:21.240 ⇒ 00:04:29.019 Caio Velasco: So we turned them into 6 new tickets, more or less they could be even 3 or 4. But this should be a bit more granular.
41 00:04:29.789 ⇒ 00:04:39.699 Caio Velasco: Cause I will also to. Well, I was talking with you, Tom and I still have to understand a bit more about the explores and the views. The mapping between
42 00:04:40.060 ⇒ 00:05:03.409 Caio Velasco: dashboards and the associated tables and the tables. Mostly dbt, models it’s done but then, now to really go into the deprecation rules, we would need to go a bit more into the explores and see what is being used or not into the views and what’s being used or not. So there’s still about the other few layers.
43 00:05:03.550 ⇒ 00:05:08.530 Caio Velasco: and we can turn them into tickets. Just to be precise.
44 00:05:09.292 ⇒ 00:05:11.347 Caio Velasco: So yeah, that was the outcome.
45 00:05:14.110 ⇒ 00:05:20.420 Demilade Agboola: It does seem that we can turn up. We can not turn off. We can close some of the tickets. Can you go back a bit, please.
46 00:05:22.400 ⇒ 00:05:26.846 Demilade Agboola: Oh, not like back. Like to the cycle. Yeah.
47 00:05:29.550 ⇒ 00:05:36.140 Demilade Agboola: So, for instance, like the let me see, revenue models
48 00:05:36.750 ⇒ 00:05:41.199 Demilade Agboola: also. Okay, the use. Look at dashboards flagged by accuracy.
49 00:05:41.460 ⇒ 00:05:45.889 Demilade Agboola: Are we done with that, or is that still in progress like us? 84.
50 00:05:46.510 ⇒ 00:05:49.100 Emily Giant: The dashboards and looker that should be done.
51 00:05:50.740 ⇒ 00:05:56.060 Emily Giant: or they’re flagged for deprecation, anyway. But maybe not for accuracy. That’s a different ticket.
52 00:05:56.940 ⇒ 00:06:02.650 Demilade Agboola: I I just I just wanted to know like which ones we can close or which ones will be closed out. This sprint.
53 00:06:05.030 ⇒ 00:06:10.710 Amber Lin: The this one would be close. I’m just gonna convert Kyle’s comments into new tickets.
54 00:06:11.807 ⇒ 00:06:16.470 Amber Lin: I think for this one. We talked about it last time.
55 00:06:16.600 ⇒ 00:06:21.060 Amber Lin: I’m not sure if this would be done would.
56 00:06:21.060 ⇒ 00:06:21.560 Caio Velasco: So.
57 00:06:21.560 ⇒ 00:06:22.320 Amber Lin: Trial.
58 00:06:22.510 ⇒ 00:06:29.959 Caio Velasco: So this one that you can also open and go to the comments. So this is also part of what I talked with and with your thumb.
59 00:06:30.060 ⇒ 00:06:38.640 Caio Velasco: So yeah, basically, I will have to go into the main model that we currently have, which I think is the tableau items, except.
60 00:06:38.850 ⇒ 00:06:43.519 Caio Velasco: And then from there go, you know, direction to shopify.
61 00:06:43.640 ⇒ 00:06:48.610 Caio Velasco: and then see what I can learn from all the transformations. And
62 00:06:48.840 ⇒ 00:06:56.689 Caio Velasco: you know, trying to document each step each. Well, what is if there’s subscription things with funds, discounts, etc.
63 00:06:56.860 ⇒ 00:07:08.950 Caio Velasco: So yeah, at least, I had like an idea of what it is. And also it didn’t matter. And then I think this ticket could be something. I mean, how much hours it’s like story points again like 4 story points.
64 00:07:09.480 ⇒ 00:07:29.829 Caio Velasco: because for this. I will have to like work on one or 2 days, and really go into lots of details, going to shopify documentation, to understand how they define revenue. That should be something mapped also in urban stems, in a way. But yeah, so it’s it’s gonna be. It could be also 2 3 tickets. But I think one. It’s okay.
65 00:07:32.600 ⇒ 00:07:35.949 Amber Lin: I see, so probably
66 00:07:36.100 ⇒ 00:07:43.040 Amber Lin: this will get moved to next cycle. Along with because we have the different.
67 00:07:43.480 ⇒ 00:07:44.150 Caio Velasco: Yes.
68 00:07:44.150 ⇒ 00:07:51.189 Amber Lin: Revenue audits. I think this one is slightly sep.
69 00:07:51.290 ⇒ 00:07:54.429 Amber Lin: This is a different segmentation from
70 00:07:56.100 ⇒ 00:08:04.409 Amber Lin: segmentation from the revenue audits. This is the legacy in before migration models.
71 00:08:04.680 ⇒ 00:08:11.680 Amber Lin: So I could move this to next cycle. But what about the other tickets? Can can
72 00:08:12.800 ⇒ 00:08:20.687 Caio Velasco: So the 3, rd the 1st one, if you can. Well, just mark that as done, and then turn them into the other tickets.
73 00:08:21.580 ⇒ 00:08:34.309 Caio Velasco: Then for the second one since the the tickets will be created, I think the second one is also related, because it’s part of how we are deprecating. Following you 6 steps.
74 00:08:36.629 ⇒ 00:08:49.769 Caio Velasco: the 1, 1 6. It’s also, you know. Let’s say that I’m starting with revenue now and doing all this exploration, and then at some point. It will be also related to those all the ones that you showed
75 00:08:50.285 ⇒ 00:08:58.009 Caio Velasco: so they are kind of related as well. I’m already working on them, probably because it’s just part of learning the revenue model.
76 00:08:58.189 ⇒ 00:09:00.629 Caio Velasco: Okay, so that one is like in progress.
77 00:09:01.129 ⇒ 00:09:04.210 Amber Lin: Okay, well, about, can we close that.
78 00:09:04.210 ⇒ 00:09:06.110 Caio Velasco: Because I yes, I did with you.
79 00:09:06.110 ⇒ 00:09:08.620 Amber Lin: Awesome, awesome.
80 00:09:09.600 ⇒ 00:09:14.160 Caio Velasco: For today. So I guess today, we have.
81 00:09:14.770 ⇒ 00:09:27.799 Amber Lin: A few things in progress. I don’t know if we can do this ticket, Tablana. What do you think? Have we turned off enough to estimate the cost of them, or should this be a later ticket.
82 00:09:28.390 ⇒ 00:09:45.790 Caio Velasco: Let’s be before them. I also talked this with about this with you, Thumb and he also proposed a different idea of looking at costs like looking more also at some intangible things of when you deprecate something or you turn off something. What is?
83 00:09:46.410 ⇒ 00:09:56.990 Caio Velasco: How’s that related to engineering work that we are also saving. And how? How’s that related to even human hours, or something a bit more intense? I will have to go into the
84 00:09:57.634 ⇒ 00:10:04.550 Caio Velasco: recording again, because he told me things that I that I didn’t fully understand. But there’s value in that.
85 00:10:04.800 ⇒ 00:10:06.840 Caio Velasco: So it’s not only about, you know.
86 00:10:07.080 ⇒ 00:10:17.410 Caio Velasco: counting the roles that are not being jested. That’s what I mean. There’s something a bit more bit more interesting in there, so I have to spend a bit more time into that one.
87 00:10:18.430 ⇒ 00:10:19.210 Amber Lin: Oh!
88 00:10:20.360 ⇒ 00:10:25.630 Caio Velasco: But then they’re not up to you also. You also have experience with that. So if you have any other opinion.
89 00:10:27.170 ⇒ 00:10:31.299 Demilade Agboola: Oh, yeah, I was. I was saying that what I was thinking of was like.
90 00:10:31.440 ⇒ 00:10:35.059 Demilade Agboola: I mean, I don’t think we can do a final cost estimate right now.
91 00:10:35.808 ⇒ 00:10:41.229 Demilade Agboola: I think it’s still work in progress, because we’re still literally doing these things as we speak.
92 00:10:41.679 ⇒ 00:10:52.220 Demilade Agboola: But we can always start with a document that can be progressive. And as we as things move along, we can update it with like the updated cost, as we’re doing more things.
93 00:10:52.400 ⇒ 00:11:03.699 Demilade Agboola: And yeah, like the like, Kyle said, just now, you know, maybe we can even view cost in in different ways as well. But ultimately, I, if if we’re viewing it as like the final cost?
94 00:11:04.760 ⇒ 00:11:06.039 Demilade Agboola: I don’t actually think
95 00:11:06.240 ⇒ 00:11:16.319 Demilade Agboola: that’s like we’re not done yet. But if we’re feeling it as like, okay, what exactly have we done so far? And what’s that impact? We can also, we can start that progress. So.
96 00:11:18.120 ⇒ 00:11:18.970 Amber Lin: Sure
97 00:11:19.440 ⇒ 00:11:33.770 Amber Lin: we can get that one started. Then it doesn’t have to be complete and we don’t have to have the right assumptions about working hours, or how much say each row would save. But to have that reference in place would be really helpful.
98 00:11:34.540 ⇒ 00:11:46.205 Caio Velasco: Okay, yeah, that’s in progress. And 1 1 thing that I also wanna quickly ask is, Emily’s here? When I started looking to stitch, and I went to the 1st pipeline that we turned off
99 00:11:49.110 ⇒ 00:11:50.130 Caio Velasco: and
100 00:11:50.370 ⇒ 00:12:02.160 Caio Velasco: that one has just one table. And then I went to stage and try to understand, where is the historical loads? And then I found a place. But then I couldn’t access any data because it was already off.
101 00:12:02.410 ⇒ 00:12:15.570 Caio Velasco: So then I was like, but why? Because I’m using the last 7 days, the last 15 days, the last 30 days, and nothing. So then I went to redship, and I queried that table for the Max and minimum, I think batch date or something.
102 00:12:16.070 ⇒ 00:12:19.609 Caio Velasco: and the last one was actually November last year.
103 00:12:19.790 ⇒ 00:12:22.913 Caio Velasco: But it was still on. So yeah.
104 00:12:23.360 ⇒ 00:12:25.562 Emily Giant: Yep, that has to have been
105 00:12:26.600 ⇒ 00:12:35.969 Emily Giant: affiliated with our migration, because November is when we changed to shopify. So anything that hasn’t run since then, I would think, is like directly related to salesforce.
106 00:12:36.160 ⇒ 00:12:37.670 Emily Giant: and switching that off
107 00:12:39.850 ⇒ 00:12:44.867 Caio Velasco: So let’s say that we have a cost, for that is 0. When we turned off we didn’t do anything. At the end of the day
108 00:12:45.930 ⇒ 00:12:49.489 Caio Velasco: before the others. Yeah, sure, that would be something there.
109 00:12:53.730 ⇒ 00:12:54.380 Amber Lin: But it’s it.
110 00:12:55.710 ⇒ 00:12:58.290 Amber Lin: So I assume
111 00:12:58.800 ⇒ 00:13:09.549 Amber Lin: I think I’ll change this ticket for to Kyle, just starting exploration with revenue models, I think just wanna check if these could be done
112 00:13:09.820 ⇒ 00:13:11.870 Amber Lin: by tomorrow’s stand up.
113 00:13:14.610 ⇒ 00:13:15.820 Amber Lin: So these.
114 00:13:22.460 ⇒ 00:13:26.320 Caio Velasco: For my end, for the cost estimate. They can see what I can do, because.
115 00:13:26.320 ⇒ 00:13:26.730 Amber Lin: Okay.
116 00:13:26.730 ⇒ 00:13:31.660 Caio Velasco: Doing this exploration for the Amazon. I even saw that it was already kind of off.
117 00:13:32.315 ⇒ 00:13:43.369 Caio Velasco: So I can see what I can do for the others and try to see just a rough estimate of something. So yeah, definitely can work on that until end of cycle tomorrow.
118 00:13:43.850 ⇒ 00:13:44.470 Amber Lin: Okay.
119 00:13:46.120 ⇒ 00:13:46.540 Demilade Agboola: And.
120 00:13:46.540 ⇒ 00:13:50.320 Emily Giant: Yeah, I can have it. I’m working on it right now. It’s.
121 00:13:50.320 ⇒ 00:13:50.760 Amber Lin: Okay.
122 00:13:50.760 ⇒ 00:13:51.960 Emily Giant: So it should be done. Yeah.
123 00:13:51.960 ⇒ 00:13:58.680 Amber Lin: Okay. Awesome, Tamara. Anything you you think will need to get pushed back to next cycle.
124 00:13:59.410 ⇒ 00:14:04.673 Demilade Agboola: So I’ll try and get everything across the line, but
125 00:14:05.400 ⇒ 00:14:09.029 Demilade Agboola: but, like the other 3, I should, I should be able to knock them off.
126 00:14:09.210 ⇒ 00:14:15.949 Amber Lin: Yeah. And for 1 0, 5. Honestly, we still have audit tickets for these different areas. So
127 00:14:16.120 ⇒ 00:14:20.489 Amber Lin: just do as much as you can, and we’ll flesh out the plan as we do. More audits.
128 00:14:22.760 ⇒ 00:14:24.210 Demilade Agboola: Okay. Sounds good.
129 00:14:24.210 ⇒ 00:14:27.290 Amber Lin: Okay, thank you all. I’ll see you guys later in the retro.
130 00:14:27.540 ⇒ 00:14:28.619 Emily Giant: Thanks, bye.
131 00:14:28.620 ⇒ 00:14:29.600 Amber Lin: Okay. Bye-bye.
132 00:14:29.950 ⇒ 00:14:30.870 Caio Velasco: My bank.