Meeting Title: US x BF | Standup Date: 2025-07-11 Meeting participants: Emily Giant, Amber Lin, Demilade Agboola, Caio Velasco
WEBVTT
1 00:00:57.650 ⇒ 00:00:58.830 Emily Giant: Good morning!
2 00:01:21.830 ⇒ 00:01:23.110 Amber Lin: Hello!
3 00:01:23.970 ⇒ 00:01:24.930 Emily Giant: How are you?
4 00:01:25.880 ⇒ 00:01:29.730 Amber Lin: 2 days. Another day I rolled out of bed.
5 00:01:32.300 ⇒ 00:01:34.181 Emily Giant: You gotta do what you gotta do.
6 00:01:34.924 ⇒ 00:01:36.820 Amber Lin: As you can tell.
7 00:01:37.290 ⇒ 00:01:47.782 Emily Giant: No, it looks like it looks good. You have good hair, so it like makes nice shapes. I just rolled out of bed. Mine is like, just like the ends of an onion.
8 00:01:48.240 ⇒ 00:01:49.912 Emily Giant: It’s not right.
9 00:01:51.960 ⇒ 00:01:53.450 Amber Lin: It looks so cute.
10 00:01:53.450 ⇒ 00:01:54.410 Emily Giant: Possible.
11 00:01:57.571 ⇒ 00:02:04.890 Amber Lin: Okay, today is Friday. I’m very excited. Share screen.
12 00:02:06.870 ⇒ 00:02:08.850 Amber Lin: Wait. It says anything.
13 00:02:09.720 ⇒ 00:02:20.619 Amber Lin: Oh, good job! Everybody. Yesterday at the at the presentation. How did you guys, what do you guys think? What do you think? How did it? When? How did it go.
14 00:02:21.430 ⇒ 00:02:31.850 Emily Giant: It went really. Well, I think everyone’s excited to like use the data cause they’re hearing a lot of good things, and they’re like, give it to me, but I thought the presentation was really good.
15 00:02:32.190 ⇒ 00:02:34.110 Amber Lin: Yeah, I thought so, too.
16 00:02:37.820 ⇒ 00:02:39.029 Demilade Agboola: Yeah, I think you went well.
17 00:02:39.890 ⇒ 00:02:51.060 Demilade Agboola: I was waiting to hear Emily’s thoughts, because I mean, she’s she’s more familiar with people on her team, and like what they think, what they need, what they feel. And yeah, I think they they seem
18 00:02:51.230 ⇒ 00:02:58.469 Demilade Agboola: quite excited facially as well as some from some of the questions to be able to use the data and also
19 00:02:58.600 ⇒ 00:03:04.889 Demilade Agboola: interacts in such a way that they don’t run into the issues they ran into previously with, like some of the
20 00:03:05.400 ⇒ 00:03:10.060 Demilade Agboola: messed up infrastructure that they had before. So that was quite nice.
21 00:03:10.060 ⇒ 00:03:11.470 Amber Lin: Yay!
22 00:03:11.890 ⇒ 00:03:17.969 Emily Giant: And Felipe is always a good litmus test, like he’s to me the most knowledgeable about like
23 00:03:18.240 ⇒ 00:03:23.310 Emily Giant: inventory data parts of the business, like he just is
24 00:03:23.710 ⇒ 00:03:26.990 Emily Giant: super straightforward and is not gonna like.
25 00:03:28.090 ⇒ 00:03:32.540 Emily Giant: engage or encourage if he doesn’t mean it.
26 00:03:32.700 ⇒ 00:03:44.450 Emily Giant: And I think that he’s really excited. He’s been involved, too, with meetings, so he knows and can see the progress unlike some of the other stakeholders. But I could tell that he was like
27 00:03:44.750 ⇒ 00:03:51.660 Emily Giant: really supportive during the meeting yesterday, too. In his own way, in his very straightforward way, but.
28 00:03:51.660 ⇒ 00:04:08.749 Amber Lin: That’s really good cause now, like people can ask him, and he can speak for us, too. Do you guys think we should? Is there any other stakeholders we could involve in, say, working sessions. Maybe, Perry, we could invite her as well.
29 00:04:08.940 ⇒ 00:04:13.730 Emily Giant: Definitely during revenue. I think during inventory, Felipe is
30 00:04:14.639 ⇒ 00:04:17.959 Emily Giant: he’ll be the most straight to the point without
31 00:04:19.890 ⇒ 00:04:30.714 Emily Giant: adding time. I’m afraid, if we add more people right now, we’ll have to like start from the beginning of what we’re trying to do and explain it to them. And we’re so close to the end
32 00:04:31.300 ⇒ 00:04:33.979 Amber Lin: It makes a lot of sense.
33 00:04:34.090 ⇒ 00:04:49.150 Amber Lin: Okay, I think eventually, we need to tell them how to if they need help with Dbt and stuff. So that’s more of like a training that we should give everybody. But right now I agree, if Aliba would be the would be the best person.
34 00:04:49.150 ⇒ 00:04:49.790 Emily Giant: Yeah.
35 00:04:50.040 ⇒ 00:04:53.989 Amber Lin: Okay, looking at tickets here.
36 00:04:54.767 ⇒ 00:04:59.360 Amber Lin: Have you? Asked Zach. If we could close the crown job.
37 00:05:00.141 ⇒ 00:05:11.350 Emily Giant: That one. We’re just testing it still, but like that, work is done so that it can be closed. That’s fine, like Tom did the configuration.
38 00:05:11.734 ⇒ 00:05:13.270 Demilade Agboola: What was the testing?
39 00:05:13.740 ⇒ 00:05:19.910 Emily Giant: I’m just making sure that it it’s running on that schedule.
40 00:05:20.730 ⇒ 00:05:23.109 Emily Giant: since it’s a new feature for polytomic.
41 00:05:25.320 ⇒ 00:05:34.260 Emily Giant: he’s just keeping an eye on it and monitoring the like cost expenditure. But we can do that on our end. That doesn’t need to be on this board.
42 00:05:35.220 ⇒ 00:05:37.940 Amber Lin: Okay, what about this one?
43 00:05:39.450 ⇒ 00:05:41.430 Amber Lin: And I, yeah, I’m allowed to look at it.
44 00:05:41.815 ⇒ 00:05:44.130 Demilade Agboola: Think we can close like that.
45 00:05:46.550 ⇒ 00:05:47.920 Amber Lin: Okay. Awesome.
46 00:05:48.770 ⇒ 00:05:52.300 Amber Lin: Alright. These 2 are Utah. I’ll ask soon.
47 00:05:52.590 ⇒ 00:05:54.040 Demilade Agboola: Just popped off a call.
48 00:05:54.300 ⇒ 00:05:55.090 Amber Lin: Yeah.
49 00:05:56.420 ⇒ 00:06:02.380 Demilade Agboola: One second, all with Ryan, Luke.
50 00:06:02.660 ⇒ 00:06:19.739 Demilade Agboola: and we’re able to. We look like curbil connect to Redshift. So at least that allows us to start monitoring some of the core tables and being able to see historically what’s been going on, and also like, be ready for any issues that occur, like any spikes where it spikes or
51 00:06:20.747 ⇒ 00:06:24.400 Demilade Agboola: still data. So that’s that’s exciting.
52 00:06:25.300 ⇒ 00:06:36.269 Amber Lin: It’s in progress. Awesome. One of one of our clients had some big problems because they did not have Meta place. I’m excited that we’re gonna get it.
53 00:06:37.305 ⇒ 00:06:45.790 Amber Lin: Okay, let’s look at inventory. Are they all updated any things that I can.
54 00:06:46.416 ⇒ 00:06:50.779 Emily Giant: If you have any time after this call that I can show you a couple of things.
55 00:06:52.336 ⇒ 00:06:55.669 Demilade Agboola: Yes, I do. Give me one second.
56 00:06:55.670 ⇒ 00:06:56.200 Emily Giant: Okay.
57 00:06:58.360 ⇒ 00:07:02.099 Amber Lin: I can make this call so you can use this room.
58 00:07:02.440 ⇒ 00:07:05.280 Demilade Agboola: Yeah. So so that works alternatively.
59 00:07:05.570 ⇒ 00:07:13.740 Demilade Agboola: I have after 12 between 12 and one est, I’m free.
60 00:07:14.230 ⇒ 00:07:17.380 Emily Giant: That’s perfect. We can do 12 and one. I have a couple like
61 00:07:18.170 ⇒ 00:07:24.269 Emily Giant: things I don’t need help with. But after that I just wanna like, make sure the configuration
62 00:07:24.980 ⇒ 00:07:33.039 Emily Giant: is set up correctly because these need to be incremental or it’s gonna take forever. But I had to add it. We’ll talk about it at one.
63 00:07:33.580 ⇒ 00:07:34.200 Demilade Agboola: Okay.
64 00:07:34.200 ⇒ 00:07:40.310 Emily Giant: But yeah, I think we can finish this out if if I just have like a little bit of time to troubleshoot with you.
65 00:07:40.980 ⇒ 00:07:43.509 Demilade Agboola: Okay, so I think we can knock off
66 00:07:43.760 ⇒ 00:07:46.119 Demilade Agboola: 200 on 1, 3, 5 today.
67 00:07:47.430 ⇒ 00:08:02.760 Demilade Agboola: In the sense that we can definitely have the Prs ready. I’m generally against pushing Prs on Fridays, because, like, if everything goes weird, it’s over the weekend, so I think we can have the Pr. Ready, and we can have them in production like early next week. So like Monday, Thursday, Monday.
68 00:08:03.745 ⇒ 00:08:07.889 Demilade Agboola: So we can definitely close 201, 3, 5 out.
69 00:08:10.231 ⇒ 00:08:15.019 Demilade Agboola: Well, not necessarily like we do put them like Pr stage. That’s kind of where they are.
70 00:08:15.870 ⇒ 00:08:16.720 Amber Lin: Understand.
71 00:08:17.220 ⇒ 00:08:25.059 Emily Giant: 1, 9, 2 will be done well as long as I can. Well, as long as we can close out 1, 3, 5, then 1, 9, 2 will be easy.
72 00:08:25.590 ⇒ 00:08:26.480 Amber Lin: Okay?
73 00:08:27.536 ⇒ 00:08:35.030 Amber Lin: So that’s on track for early next week. I’m just looking at how we are in the current cycle. We have
74 00:08:35.470 ⇒ 00:08:38.139 Amber Lin: a bit over a week left.
75 00:08:39.559 ⇒ 00:08:40.589 Amber Lin: I
76 00:08:40.990 ⇒ 00:08:47.139 Amber Lin: I think with that time we’re pretty on track, any specific ones. These you want to update statuses of.
77 00:08:51.550 ⇒ 00:08:55.369 Demilade Agboola: So 1, 6, 6 is actually in progress.
78 00:08:55.370 ⇒ 00:08:56.370 Amber Lin: Hmm, okay.
79 00:08:56.370 ⇒ 00:08:57.100 Emily Giant: Hmm.
80 00:08:57.720 ⇒ 00:09:05.269 Demilade Agboola: It’s kind of tied to to 1, 3, 5, basically.
81 00:09:06.780 ⇒ 00:09:10.300 Amber Lin: Okay, Mark.
82 00:09:16.300 ⇒ 00:09:16.980 Amber Lin: okay.
83 00:09:18.480 ⇒ 00:09:25.990 Amber Lin: Looking here, taking the lesson from last time. Because last time we had a mix of
84 00:09:26.300 ⇒ 00:09:30.370 Amber Lin: revenue tickets and inventory. Can you guys tell me if
85 00:09:30.600 ⇒ 00:09:45.580 Amber Lin: all the tickets under Project inventory belongs there? It’s anything stale and needs to be taken out. Is everything captured? Because I know you guys have meetings with Felipe. Can you tell me if this is? If there’s any other ticket.
86 00:09:47.790 ⇒ 00:09:54.909 Emily Giant: Not with revenue, but I think we could probably move out the folder one just because it’s not crucial.
87 00:09:55.670 ⇒ 00:09:58.520 Emily Giant: It’s not as like stakeholder affecting.
88 00:09:59.020 ⇒ 00:10:08.749 Demilade Agboola: Yeah, it’s more structural. So I said, it’s an ongoing like theme as we’re doing it. It’s more of like as we’re building out the inventory, and like generally, everything, not just inventory.
89 00:10:09.310 ⇒ 00:10:15.619 Demilade Agboola: We’re ensuring that like, there’s a proper file structure and folder structure that we’re building in and on.
90 00:10:15.910 ⇒ 00:10:19.540 Demilade Agboola: I know where. Yeah. So, and that isn’t.
91 00:10:19.540 ⇒ 00:10:21.459 Amber Lin: Sorry go ahead.
92 00:10:22.260 ⇒ 00:10:29.089 Demilade Agboola: So, yeah, that’s not necessarily an inventory like specific thing in that sense. It’s just something to bear in mind and keep working with.
93 00:10:29.330 ⇒ 00:10:38.280 Amber Lin: I see I wanted to put it so that we can more confidently say we can close out inventory. I can. I can say this is like rename. All
94 00:10:41.090 ⇒ 00:10:44.900 Amber Lin: all inventory related items.
95 00:10:45.020 ⇒ 00:10:56.379 Amber Lin: And I can make. I can make a different one for revenue. But this helps us make a final check. That okay, inventory is ready to go. That’s mostly my
96 00:10:57.680 ⇒ 00:11:00.899 Amber Lin: my goal for this ticket. I’ll make one for revenue as well.
97 00:11:02.270 ⇒ 00:11:09.439 Amber Lin: Yeah. Is there anything that, Felipe said. That’s not captured in there anything you’re currently working on, but it’s not captured.
98 00:11:13.260 ⇒ 00:11:25.410 Demilade Agboola: I mean, I know he mentioned something about something Steven used to do about. There was an edge case he talked about. I can’t remember exactly what it was the details of it. I’ll have to go through the transcript of the meeting.
99 00:11:25.570 ⇒ 00:11:28.378 Demilade Agboola: Well, I know he mentioned something about
100 00:11:30.230 ⇒ 00:11:34.179 Demilade Agboola: Steven have Steven having to make Steve having to make like patches on it.
101 00:11:34.760 ⇒ 00:11:37.530 Demilade Agboola: because I’m trying to remember what exactly it was.
102 00:11:37.700 ⇒ 00:11:41.889 Emily Giant: There were 2 I think you mentioned. One was fulfillment date, which we definitely already have.
103 00:11:42.502 ⇒ 00:11:53.590 Emily Giant: Then the other one was something to do with the adjustments. But you’ve already worked in that logic. I’m I’m almost sure that you built already accounts for that.
104 00:11:53.830 ⇒ 00:11:57.660 Emily Giant: And Steven’s model. Is.
105 00:11:58.040 ⇒ 00:12:06.389 Emily Giant: It’s Inventory Xf and inventory transactions. Xf. And we’ve essentially like taken what is useful from those models.
106 00:12:06.620 ⇒ 00:12:07.570 Emily Giant: And
107 00:12:08.670 ⇒ 00:12:16.240 Emily Giant: I’ll I’ll think about it. I know what you mean. I know what you’re talking about, but I I’m pretty sure it’s not something new.
108 00:12:16.660 ⇒ 00:12:21.139 Amber Lin: Is it captured anywhere? Is it the meeting today?
109 00:12:21.510 ⇒ 00:12:23.259 Demilade Agboola: Oh, no! It was the meeting.
110 00:12:23.260 ⇒ 00:12:24.140 Amber Lin: Yesterday.
111 00:12:24.422 ⇒ 00:12:28.099 Demilade Agboola: No, it was yesterday or 2 days ago. I think it was yesterday.
112 00:12:28.100 ⇒ 00:12:28.650 Emily Giant: Yesterday.
113 00:12:28.650 ⇒ 00:12:33.810 Demilade Agboola: But don’t worry. I’ll go through. I’ll go through the Transcript, and I’ll let you know if there’s anything. If there’s anything I missed.
114 00:12:34.120 ⇒ 00:12:36.769 Amber Lin: Okay, sounds good. Cause I can.
115 00:12:37.760 ⇒ 00:12:46.419 Amber Lin: Yes, yesterday I looked at it. I just wanna check
116 00:12:46.870 ⇒ 00:12:50.950 Amber Lin: also. Emily, this is our AI and that’s cool.
117 00:12:52.010 ⇒ 00:12:56.228 Amber Lin: Someone that generates tickets. It’s very, very, very cool. I’m very happy.
118 00:12:57.695 ⇒ 00:13:03.230 Amber Lin: Yeah. Anyways, I got derailed going back to linear.
119 00:13:03.620 ⇒ 00:13:15.880 Amber Lin: Okay? So inventory is good. How? How’s how’s revenue? Should I edit those tickets? How’s progress? I know we wanted to do, I think.
120 00:13:16.250 ⇒ 00:13:17.390 Amber Lin: What is it?
121 00:13:17.690 ⇒ 00:13:23.100 Amber Lin: Orders and refunds or discounts.
122 00:13:23.360 ⇒ 00:13:27.400 Amber Lin: And I think we said, we want to do those. How how is those.
123 00:13:27.890 ⇒ 00:13:33.773 Caio Velasco: Yeah, yeah. So I was trying to. Well, trying to find a way to to build this
124 00:13:34.500 ⇒ 00:13:39.160 Caio Velasco: Tracking of disorder and learn along the way.
125 00:13:39.699 ⇒ 00:13:46.149 Caio Velasco: And at the end what I what I ended up doing was, I started from the source.
126 00:13:46.380 ⇒ 00:13:55.880 Caio Velasco: And then I was trying to mimic after I learned a bit of what each source is bringing. For example, Oms borders and
127 00:13:56.160 ⇒ 00:13:58.549 Caio Velasco: Oms line items.
128 00:13:59.226 ⇒ 00:14:12.579 Caio Velasco: I kind of noticed that some of them have some things. The other has other things. So I’m kind of learning about what was happening. And then at the end. What I end up doing was, for example, I was able to build some Ctes
129 00:14:12.890 ⇒ 00:14:23.899 Caio Velasco: and mimic stage suborders already, for example. So I know exactly what is happening in stage suborders, lots of accounts, a lot of
130 00:14:24.160 ⇒ 00:14:26.319 Caio Velasco: qualifies over within it.
131 00:14:26.950 ⇒ 00:14:28.780 Caio Velasco: And so now I kind of know
132 00:14:28.900 ⇒ 00:14:33.260 Caio Velasco: how are the supporters coming, and how the incremental model is being done.
133 00:14:34.170 ⇒ 00:14:40.330 Caio Velasco: So yeah, and refunds, or any any of the other things will take time.
134 00:14:40.888 ⇒ 00:14:53.800 Caio Velasco: And I already know, for example, that you have some like quantity price unit price and some things coming from line items. So maybe bit by bit, I’m I’m building or trying to build this revenue.
135 00:14:54.443 ⇒ 00:15:02.359 Caio Velasco: So yeah, it will take more time for sure. I I don’t know. I have no idea how long trying my best, because the models are huge.
136 00:15:03.460 ⇒ 00:15:07.220 Amber Lin: I see. Okay, are you? I know.
137 00:15:07.220 ⇒ 00:15:08.640 Caio Velasco: It was progress. Yeah.
138 00:15:08.640 ⇒ 00:15:15.099 Amber Lin: It sounds really good. Are you building it out as you audit it? Is that what is that? What you’re doing.
139 00:15:15.100 ⇒ 00:15:27.089 Caio Velasco: Because I don’t know how to separate all the thing from building, because I have to understand the specific details of as if I was building that myself. It’s impossible to do otherwise. And that’s why I ended up
140 00:15:27.470 ⇒ 00:15:28.860 Caio Velasco: taking a lot of time.
141 00:15:29.594 ⇒ 00:15:40.200 Caio Velasco: And but I think from now, for example, if I would go from stage supporters to the next one, which I there are, there are many next, but if I would do that, then I think.
142 00:15:40.929 ⇒ 00:15:47.400 Caio Velasco: I would probably be focusing only on the columns related to Price. So not on the whole thing.
143 00:15:47.540 ⇒ 00:15:49.380 Caio Velasco: So yeah, that’s what I’m trying to do.
144 00:15:49.630 ⇒ 00:15:55.069 Caio Velasco: So a couple more more days. I think I can get to a refunds or or something different.
145 00:15:55.510 ⇒ 00:15:57.660 Amber Lin: Oh, I see I hear.
146 00:15:57.750 ⇒ 00:16:02.719 Emily Giant: Understand revenue. So I I can’t imagine coming into a new business and
147 00:16:03.080 ⇒ 00:16:10.150 Emily Giant: like how you’re doing this without having worked at urban stems. It’s very complicated. Yeah.
148 00:16:10.150 ⇒ 00:16:11.000 Caio Velasco: That’s true.
149 00:16:11.000 ⇒ 00:16:11.510 Emily Giant: Yeah.
150 00:16:12.310 ⇒ 00:16:13.759 Caio Velasco: Well, at least like a.
151 00:16:13.760 ⇒ 00:16:14.340 Amber Lin: Yes, let’s see.
152 00:16:14.340 ⇒ 00:16:16.400 Caio Velasco: These are building the the same
153 00:16:16.570 ⇒ 00:16:21.501 Caio Velasco: more at the same stage sub order. So I think it’s at least it’s progress.
154 00:16:22.070 ⇒ 00:16:26.480 Amber Lin: That’s that’s great to hear. I think when we 1st started, I wanted
155 00:16:26.810 ⇒ 00:16:55.969 Amber Lin: you guys do. I know we said Kyle would do auditing. And then, Demo, you guys would build it together so it would be faster. Demo, I just wanna hear how you how you think you guys would collaborate, or how, as Kyle said, probably separating, it seems like separating, auditing, and building is pretty hard. Where? Where do you think the handoff is? How can you, you guys work to be work together the best way.
156 00:16:56.790 ⇒ 00:17:03.840 Amber Lin: And is this even like auditing tickets the right way to go? Or should we just say, like, build it. What do you guys think
157 00:17:13.829 ⇒ 00:17:15.150 Amber Lin: you’re muted.
158 00:17:17.170 ⇒ 00:17:25.540 Demilade Agboola: Yeah, just I saw the pop up my screen right now. Yeah, I think for me, the best way to go about this is being able to
159 00:17:26.690 ⇒ 00:17:41.020 Demilade Agboola: like, I get what Kyle means. Sometimes it’s really hard, like, even when I was working on some other things earlier, I just kind of ended up building up everything, because to fully understand stuff, you kind of have to take it apart, and when you take it apart, you can kind of understand how to rebuild it and put it together. Better.
160 00:17:41.717 ⇒ 00:17:43.179 Demilade Agboola: So there’s that.
161 00:17:44.230 ⇒ 00:17:49.470 Demilade Agboola: But I think in terms of building, we want to be able to build a with
162 00:17:49.960 ⇒ 00:17:57.570 Demilade Agboola: like best practices and ensure that what we’re doing is scalable, like it’s something that they can use
163 00:17:58.040 ⇒ 00:18:03.870 Demilade Agboola: years down the line 2. It’s clear like, we’re able to document what we’re doing.
164 00:18:04.200 ⇒ 00:18:06.130 Demilade Agboola: And so they understand
165 00:18:06.340 ⇒ 00:18:14.550 Demilade Agboola: again, what’s what’s going on there. And it’s easy to understand what the different models are what patches are, what’s what’s going on in there, that’s true.
166 00:18:14.750 ⇒ 00:18:21.659 Demilade Agboola: But I think in terms of like the project and us working together. I think it should like. What we can do is
167 00:18:21.830 ⇒ 00:18:26.189 Demilade Agboola: especially because the inventory is beginning to wrap up. In a sense.
168 00:18:26.689 ⇒ 00:18:32.380 Demilade Agboola: It’s once we’re done with hard codes. Once we’re done with the console daughters
169 00:18:33.170 ⇒ 00:18:39.319 Demilade Agboola: we’re like, and very, it’s more of like verifying and handling edge cases and things like that.
170 00:18:39.500 ⇒ 00:18:43.749 Demilade Agboola: I would have more bandwidth to be able to hop in specifically into revenue.
171 00:18:44.577 ⇒ 00:18:46.960 Demilade Agboola: And then we can kind of.
172 00:18:47.890 ⇒ 00:18:50.590 Demilade Agboola: because I have done some things with orders as well.
173 00:18:51.224 ⇒ 00:18:58.630 Demilade Agboola: So like we can kind of sync on that, like, maybe early next week. And we can, you know, come up with a plan in terms of like
174 00:18:58.900 ⇒ 00:18:59.900 Demilade Agboola: he.
175 00:19:00.520 ⇒ 00:19:12.270 Demilade Agboola: you handle orders. I handle transactions we meet and kind of see how things align or you handle orders. I just or you handle refunds, and I’ll focus on like discounts.
176 00:19:13.730 ⇒ 00:19:20.609 Demilade Agboola: and gift cards. Or I could just focus on subscriptions entirely. And that way, we can kind of yeah work together.
177 00:19:21.468 ⇒ 00:19:27.730 Demilade Agboola: And we can always sync on like what we’re doing. Why, we did make decisions we made.
178 00:19:27.840 ⇒ 00:19:34.559 Demilade Agboola: and also like documentation, such that, like either party, I think one of the tests of like good documentation is, if
179 00:19:34.750 ⇒ 00:19:37.979 Demilade Agboola: you put your documentation together, and I understand what you did.
180 00:19:38.220 ⇒ 00:19:50.839 Demilade Agboola: and I have my documentation, and you can understand what I did. That allows us to be able to ensure that when we hand over to urban stems, whoever reads our documentation on what we’re doing, and the process would also be very clear to them as well.
181 00:19:52.280 ⇒ 00:19:54.810 Amber Lin: Okay, I think, yeah, go ahead.
182 00:19:54.810 ⇒ 00:20:04.379 Emily Giant: Wanna quickly flag that like with revenue there are fundamental source source issues that you won’t be able to solve. Because
183 00:20:04.910 ⇒ 00:20:17.100 Emily Giant: coming in incorrectly. So I want to just make sure you don’t drive yourselves crazy. I can point to exactly where those are. They are in the like. The Dbt audit sheet. Kyle.
184 00:20:17.921 ⇒ 00:20:36.609 Emily Giant: I flagged them a bunch in there about like this. We cannot do what we need to do with the current structure. So that’s I just don’t want you to drive yourself crazy, auditing that and picking it apart because I’ve been there and at the end of the day until it is reconfigured at the source level.
185 00:20:36.920 ⇒ 00:20:39.149 Emily Giant: It’s gonna be wrong.
186 00:20:40.350 ⇒ 00:20:41.440 Caio Velasco: Okay. Okay.
187 00:20:41.440 ⇒ 00:20:42.780 Demilade Agboola: Well, that was exciting.
188 00:20:43.240 ⇒ 00:20:45.736 Emily Giant: Yeah, I know, right?
189 00:20:46.550 ⇒ 00:21:09.729 Amber Lin: I I might, I think, for me. What the requirements I need to fulfill is that I need to report on our project. Progress. So I would like, if possible, I want them a lot of you and Kyle to meet and discuss how you want to approach this and how I can. We can track progress, because right now I don’t think
190 00:21:10.189 ⇒ 00:21:39.049 Amber Lin: based on what I heard. We’re kind of mixing, auditing, and building, but we’re separating it by sections. So if you guys discuss and agree, that’s the case, I would change the tickets and say, define preliminary structure of orders and audit and audit it right, and then that will be a bigger task. But then we will move some of these out of cycle, because originally I just want us to complete what we
191 00:21:39.110 ⇒ 00:21:55.809 Amber Lin: committed to, and right now we originally committed to just auditing, but not building, but since now that we found that some part of it is building. I want to be able to track your progress and prove that you did work as well. So
192 00:21:56.765 ⇒ 00:22:01.649 Amber Lin: let me, can you guys tell me how you want the tickets to be structured.
193 00:22:04.887 ⇒ 00:22:06.409 Demilade Agboola: So I think
194 00:22:07.760 ⇒ 00:22:13.040 Demilade Agboola: what we can do is we can have audit and deal tickets so we can have an audit ticket and a deal ticket.
195 00:22:13.850 ⇒ 00:22:17.840 Demilade Agboola: To those 2 tickets, and then we can have those tickets in cycle.
196 00:22:18.150 ⇒ 00:22:27.779 Demilade Agboola: So that allows us to be able to say, Hey, we’re working on the audit orders, as well as to build orders to get together.
197 00:22:28.090 ⇒ 00:22:38.250 Amber Lin: Okay? So what should I move out of cycle? We have a week, and like, like we, a week and one or 2 days.
198 00:22:39.000 ⇒ 00:22:40.699 Demilade Agboola: It was the same week.
199 00:22:46.545 ⇒ 00:22:47.400 Demilade Agboola: I’ll make a.
200 00:22:47.400 ⇒ 00:22:48.075 Amber Lin: Build
201 00:23:05.730 ⇒ 00:23:08.589 Amber Lin: so I’ll do that.
202 00:23:20.870 ⇒ 00:23:22.350 Amber Lin: What else?
203 00:23:22.970 ⇒ 00:23:25.020 Amber Lin: What should I move out.
204 00:23:28.560 ⇒ 00:23:33.470 Demilade Agboola: So I think we can also do a build refunds.
205 00:23:33.960 ⇒ 00:23:36.689 Amber Lin: Okay, have that new cycle?
206 00:23:36.690 ⇒ 00:23:40.690 Amber Lin: Do discounts? Or are we doing refunds instead.
207 00:23:44.419 ⇒ 00:23:45.779 Demilade Agboola: Sure, that’s the discount.
208 00:23:46.880 ⇒ 00:23:48.140 Amber Lin: You guys tell me.
209 00:23:49.070 ⇒ 00:23:51.479 Demilade Agboola: I think. Well, I think discounts will.
210 00:23:51.700 ⇒ 00:23:52.540 Demilade Agboola: Well,
211 00:23:54.080 ⇒ 00:24:04.199 Demilade Agboola: yeah, they love like, I know, I’ve seen a lot of things around discounts in some of the models. So, being able to break that down to very helpful, we can do audits discounts, and then we can move.
212 00:24:04.380 ⇒ 00:24:07.420 Demilade Agboola: refund, and such refunds out of auto cycle.
213 00:24:07.840 ⇒ 00:24:15.210 Amber Lin: Okay, that’s great. So I’m gonna move that I’m gonna make a.
214 00:24:19.370 ⇒ 00:24:22.820 Amber Lin: So I’m gonna make one here.
215 00:24:25.950 ⇒ 00:24:31.069 Amber Lin: Are we going to start auditing for transactions?
216 00:24:34.263 ⇒ 00:24:42.189 Demilade Agboola: I’ll reach out to you on that today. I will need to scope that out and potentially, maybe that’s something I could take up for this cycle as well.
217 00:24:42.440 ⇒ 00:24:54.069 Amber Lin: Okay, yeah. I, I want you to be able to finish all the tasks and inventory. But if you have extra time left over you and you and Kyle can talk about how you want to split things.
218 00:24:55.710 ⇒ 00:24:57.896 Emily Giant: Okay transactions. One
219 00:24:59.220 ⇒ 00:25:04.909 Emily Giant: Would you like me to add a note about like the transaction tables from shopify and hevo
220 00:25:06.310 ⇒ 00:25:10.669 Emily Giant: I think ideally, we’ll want to replace what’s being ingested.
221 00:25:12.650 ⇒ 00:25:16.189 Demilade Agboola: Sure, please, can you? Can you send the the link to.
222 00:25:16.190 ⇒ 00:25:18.069 Emily Giant: Yep, you have a hevo login.
223 00:25:18.640 ⇒ 00:25:21.080 Emily Giant: That was a question. Do you have a heva login as well.
224 00:25:21.080 ⇒ 00:25:24.430 Demilade Agboola: Yes, I do. Yeah, I do have a login.
225 00:25:24.430 ⇒ 00:25:31.190 Emily Giant: And there’s some shopify packages, too, that like I don’t know if the out of the box stuff is ever all that helpful. But
226 00:25:32.430 ⇒ 00:25:33.430 Emily Giant: maybe.
227 00:25:35.770 ⇒ 00:25:44.619 Amber Lin: Then, Kyle, I know you already started modeling the orders. Can I say this is the audit audit. Orders are in like
228 00:25:44.900 ⇒ 00:25:48.040 Amber Lin: at least closer to a state to get reviewed, or it’s like
229 00:25:48.370 ⇒ 00:25:53.749 Amber Lin: internal review. Maybe you can have them let it look over it, since you’re already started modeling.
230 00:25:55.098 ⇒ 00:26:03.360 Caio Velasco: Yeah, yeah, I think so. Basically, what I did is I can trace from source to
231 00:26:04.720 ⇒ 00:26:11.469 Caio Velasco: to the tableau items except an order, okay, yeah, for example.
232 00:26:11.620 ⇒ 00:26:23.890 Amber Lin: I’ll market as like order. I just want to push. Be able to move these along. Okay, so my let’s see, we have 4 min left.
233 00:26:24.510 ⇒ 00:26:32.250 Amber Lin: Could we help quickly, roughly define? What does it mean to have done a model for orders.
234 00:26:36.090 ⇒ 00:26:43.940 Demilade Agboola: So I think what we need to get to is
235 00:26:48.320 ⇒ 00:26:52.369 Demilade Agboola: 11, which we have either effect orders or facts of orders
236 00:26:52.510 ⇒ 00:26:59.440 Demilade Agboola: that has all the information we need from like that has all the information from others. Well, bunch
237 00:27:00.490 ⇒ 00:27:02.169 Demilade Agboola: like put together.
238 00:27:02.310 ⇒ 00:27:15.739 Demilade Agboola: So right now, I have actually been able to create like some staging orders like foundational tables. But we can. I know we need to be able to put things together. So maybe what we need is the fact. Orders answer borders table, where everything is like. Put together.
239 00:27:16.480 ⇒ 00:27:22.949 Demilade Agboola: And we’re able to clearly put out the metrics or the numbers for each of the orders.
240 00:27:23.190 ⇒ 00:27:26.919 Demilade Agboola: So for each order, how much was sold?
241 00:27:27.370 ⇒ 00:27:37.590 Demilade Agboola: What is the discount on that order? Like all the information on the order just very clearly put together in such a way that the numbers match.
242 00:27:37.840 ⇒ 00:27:41.029 Demilade Agboola: and it is built out in an incremental way that
243 00:27:43.620 ⇒ 00:27:46.290 Amber Lin: We can use basically.
244 00:27:48.310 ⇒ 00:27:57.820 Caio Velasco: Maybe we can build the tickets in into fact orders, and maybe either dimensions or anything. And then we start breaking, break break down things
245 00:27:58.970 ⇒ 00:27:59.919 Caio Velasco: because orders in.
246 00:27:59.920 ⇒ 00:28:00.320 Demilade Agboola: Great.
247 00:28:00.320 ⇒ 00:28:01.910 Caio Velasco: The whole is just very broad.
248 00:28:03.120 ⇒ 00:28:06.680 Demilade Agboola: Okay. So so we can have fact orders. And we can have D motors.
249 00:28:06.940 ⇒ 00:28:08.099 Demilade Agboola: So we can.
250 00:28:08.100 ⇒ 00:28:09.089 Amber Lin: For both the demo.
251 00:28:09.090 ⇒ 00:28:09.810 Demilade Agboola: Entrance.
252 00:28:10.260 ⇒ 00:28:12.790 Demilade Agboola: So fact orders FACT.
253 00:28:15.720 ⇒ 00:28:17.600 Demilade Agboola: And then dim orders.
254 00:28:18.240 ⇒ 00:28:19.660 Amber Lin: And it it.
255 00:28:20.930 ⇒ 00:28:23.190 Demilade Agboola: So that DIDI, m
256 00:28:23.450 ⇒ 00:28:26.179 Demilade Agboola: you, you had it right the 1st time orders.
257 00:28:27.430 ⇒ 00:28:32.420 Demilade Agboola: So the idea is, we’re going to strip all the dimensions from the orders, and also have the
258 00:28:33.348 ⇒ 00:28:36.650 Demilade Agboola: fact of the orders as well.
259 00:28:36.650 ⇒ 00:28:43.640 Amber Lin: So dimensions would be, say, like metrics, such as like discounts.
260 00:28:44.510 ⇒ 00:28:45.270 Amber Lin: Is that true?
261 00:28:45.270 ⇒ 00:28:49.349 Demilade Agboola: Not not particularly dimensions. We more of like the product skew.
262 00:28:49.980 ⇒ 00:28:50.370 Amber Lin: I do?
263 00:28:50.370 ⇒ 00:28:55.720 Demilade Agboola: The like. Whatever information the contains. Yeah, names
264 00:28:55.900 ⇒ 00:29:03.640 Demilade Agboola: things like that. So the the information in the orders, the facts would be like, what was the quantity.
265 00:29:04.486 ⇒ 00:29:12.050 Demilade Agboola: How like the the cost, the total order, total things like that, like the actual.
266 00:29:12.230 ⇒ 00:29:12.890 Amber Lin: Hmm!
267 00:29:15.790 ⇒ 00:29:22.879 Amber Lin: I see. I have one last question for the last 1 min. Kyle, do you know
268 00:29:23.450 ⇒ 00:29:30.470 Amber Lin: how the model you’re currently building aligns with the best practices, and the Dvt. DVD. Standards.
269 00:29:31.570 ⇒ 00:29:32.459 Caio Velasco: It’s the same.
270 00:29:33.270 ⇒ 00:29:39.120 Amber Lin: Okay, sounds good. So you have a spelled out somewhere that this is where what we are going to follow.
271 00:29:40.910 ⇒ 00:29:42.580 Caio Velasco: What do you mean by this part.
272 00:29:43.355 ⇒ 00:29:46.400 Amber Lin: Asta Malade that he said.
273 00:29:46.400 ⇒ 00:29:49.640 Caio Velasco: I mean, I think the the best practices.
274 00:29:50.130 ⇒ 00:29:50.970 Caio Velasco: Yeah.
275 00:29:51.280 ⇒ 00:29:57.530 Caio Velasco: well, I think this is, this can be done in layers like understanding and building. Let’s say, cities that would
276 00:29:58.770 ⇒ 00:30:07.909 Caio Velasco: find what you want. It’s 1 thing putting that with ginger incremental modeling, and etc. Would be coming from Dbt. Then it would be like next layer.
277 00:30:09.550 ⇒ 00:30:10.580 Caio Velasco: So.
278 00:30:10.910 ⇒ 00:30:11.250 Amber Lin: Okay.
279 00:30:11.250 ⇒ 00:30:16.589 Caio Velasco: Yeah, first, st we would like build the fact orders, or the model or all the other tables in
280 00:30:16.950 ⇒ 00:30:21.220 Caio Velasco: in a normal SQL. Weight, test it, and then.
281 00:30:21.380 ⇒ 00:30:21.790 Amber Lin: Huh!
282 00:30:21.790 ⇒ 00:30:23.830 Caio Velasco: Portability. Practices. Yes.
283 00:30:23.830 ⇒ 00:30:24.600 Amber Lin: Okay,
284 00:30:25.840 ⇒ 00:30:47.999 Amber Lin: would you mind syncing with Kyle? Just so that you both are clear on what we actually mean by the Dbt best practices. I think this I don’t. As Kyle said, I don’t think we’re using it right away, but it’s helpful if we’re building anything to have that in mind. So would you. Would you guys mind having like a
285 00:30:48.110 ⇒ 00:30:52.170 Amber Lin: 20 to 30 min meeting about that, just just to agree on
286 00:30:52.340 ⇒ 00:30:58.430 Amber Lin: how we’re modeling things since we since we moved that into the cycle. Can you guys do that?
287 00:31:00.450 ⇒ 00:31:02.139 Demilade Agboola: Yeah, sure, that’s no problem.
288 00:31:02.410 ⇒ 00:31:06.139 Amber Lin: Okay, yeah, that’s that’s all. I’m just gonna record it here.
289 00:31:16.540 ⇒ 00:31:24.980 Amber Lin: awesome, that’s all I will. I’ll try to flush out that ticket. I’ll ask for some advice, and
290 00:31:25.430 ⇒ 00:31:27.229 Amber Lin: I’ll see you guys next week.
291 00:31:28.450 ⇒ 00:31:29.280 Caio Velasco: Perfect.
292 00:31:29.280 ⇒ 00:31:31.219 Caio Velasco: Alright, have a good weekend, bye.
293 00:31:31.705 ⇒ 00:31:32.720 Amber Lin: Bye, bye.