Meeting Title: Data Team Planning Session Date: 2025-02-12 Meeting participants: Luke Daque, Nicolas Sucari, Bo Yoon, Payas Parab, Awaish Kumar
WEBVTT
1 00:03:01.310 ⇒ 00:03:02.310 Nicolas Sucari: Hey! Luke!
2 00:03:05.920 ⇒ 00:03:07.650 Luke Daque: Hi, Nicholas, how’s it going.
3 00:03:09.870 ⇒ 00:03:10.850 Nicolas Sucari: Okay.
4 00:03:19.470 ⇒ 00:03:20.869 Luke Daque: You at home today.
5 00:03:22.400 ⇒ 00:03:25.940 Nicolas Sucari: Yes, I’m home. Yeah, I am right on.
6 00:03:26.140 ⇒ 00:03:29.199 Nicolas Sucari: Oh, yeah, yeah, no. Utami. Utami went to.
7 00:03:29.300 ⇒ 00:03:30.469 Luke Daque: Would look like.
8 00:03:30.960 ⇒ 00:03:31.350 Luke Daque: Oh.
9 00:03:31.350 ⇒ 00:03:35.740 Nicolas Sucari: Let’s yeah, like, like an hour on a ferry.
10 00:03:36.550 ⇒ 00:03:40.120 Nicolas Sucari: So he went to people.
11 00:03:40.480 ⇒ 00:03:44.259 Nicolas Sucari: yeah, so we’re not. But then we’ll see it later. Yeah, for dinner.
12 00:03:44.690 ⇒ 00:03:45.949 Luke Daque: Oh, nice! Cool!
13 00:03:45.950 ⇒ 00:03:51.670 Nicolas Sucari: Yeah, I’m gonna I need to see him to take a picture also, too, because if not, nobody’s gonna be able to do work together.
14 00:03:52.238 ⇒ 00:03:58.850 Luke Daque: Yeah, you you haven’t. We haven’t seen you together like you didn’t post any pictures or whatever. Yeah.
15 00:03:59.590 ⇒ 00:04:00.330 Nicolas Sucari: Yeah.
16 00:04:00.330 ⇒ 00:04:01.570 Luke Daque: But yeah, that’s cool.
17 00:04:06.870 ⇒ 00:04:07.600 Nicolas Sucari: Okay.
18 00:04:08.507 ⇒ 00:04:19.229 Nicolas Sucari: I don’t know. Gonna join Robertson’s gonna join. I don’t know the other folks, but maybe we can talk a little bit about what we have going our clients.
19 00:04:20.010 ⇒ 00:04:23.689 Nicolas Sucari: So, Bo, you have the pulper stuff right.
20 00:04:24.917 ⇒ 00:04:28.939 Bo Yoon: Yeah. Did you get a chance to look at the the Google sheet.
21 00:04:29.460 ⇒ 00:04:31.330 Nicolas Sucari: I’m gonna check that now.
22 00:04:31.560 ⇒ 00:04:31.970 Bo Yoon: Okay.
23 00:04:31.970 ⇒ 00:04:45.569 Nicolas Sucari: That is finished. Yeah, I’m gonna yeah. Just prepare that message. Or maybe you can like, yeah, prepare that message or by us to send to Dan and Ian because they haven’t answered the email yet. On the meeting.
24 00:04:46.490 ⇒ 00:04:53.959 Bo Yoon: On the meeting. Okay, yeah, I just, I just wanted you to check first.st before I get everything finalized here.
25 00:04:54.900 ⇒ 00:04:55.490 Nicolas Sucari: Okay.
26 00:04:55.490 ⇒ 00:04:59.890 Bo Yoon: I. I followed the logic that you explained yesterday and
27 00:05:01.100 ⇒ 00:05:04.219 Bo Yoon: But yeah, but but I’m not really sure if this is still.
28 00:05:05.290 ⇒ 00:05:07.430 Nicolas Sucari: Did you find it easy, or.
29 00:05:07.790 ⇒ 00:05:12.345 Bo Yoon: Yeah, I’m I mean, it wasn’t that complicated? It was just a few functions for the
30 00:05:12.630 ⇒ 00:05:13.390 Nicolas Sucari: Yeah, exactly.
31 00:05:13.390 ⇒ 00:05:22.910 Bo Yoon: In. Excel, yeah, cool. So I I basically added the another sheet for Asia connection sales details.
32 00:05:23.660 ⇒ 00:05:24.450 Nicolas Sucari: Okay, perfect.
33 00:05:24.450 ⇒ 00:05:28.339 Bo Yoon: And and I’m pulling that data to to the top. 20 skew sheet.
34 00:05:29.480 ⇒ 00:05:34.680 Nicolas Sucari: Perfect. Yeah. Okay, the Asia connection one. You’re only using island Rec and Pulbert, right?
35 00:05:35.720 ⇒ 00:05:45.140 Bo Yoon: Yeah. So so in Asia connection sales detail sheet, you can see that I filtered it to Island Rec, only.
36 00:05:45.530 ⇒ 00:05:49.570 Bo Yoon: okay. So I’m using those 2 sales data only.
37 00:05:50.110 ⇒ 00:05:57.729 Nicolas Sucari: Okay, yeah, this is great. I think we’re good with this. I’m gonna send this to pay us also so that he can check but
38 00:05:58.230 ⇒ 00:06:12.350 Nicolas Sucari: apart from that, I think we need to. Yeah, just send these to to Dan in the end. Let them let them know that we have all of these here and see how we can proceed. Okay? Because they have an answer for the meeting. But yeah, this will be good to send.
39 00:06:12.350 ⇒ 00:06:15.349 Bo Yoon: Are they usually not that responsive to our email.
40 00:06:15.350 ⇒ 00:06:18.719 Nicolas Sucari: Yeah, yeah, yeah, that’s that’s something useful. Yeah.
41 00:06:19.595 ⇒ 00:06:20.340 Bo Yoon: Alright!
42 00:06:20.340 ⇒ 00:06:20.890 Nicolas Sucari: Thank you.
43 00:06:21.090 ⇒ 00:06:22.490 Nicolas Sucari: Okay. Thank you. Both.
44 00:06:22.880 ⇒ 00:06:23.650 Nicolas Sucari: Great.
45 00:06:23.650 ⇒ 00:06:24.560 Bo Yoon: And no worries.
46 00:06:24.720 ⇒ 00:06:30.829 Bo Yoon: Is there anything else that you want me to do for for pool parts to go? Just just look at your data
47 00:06:31.540 ⇒ 00:06:32.360 Bo Yoon: overview.
48 00:06:32.747 ⇒ 00:06:35.850 Nicolas Sucari: Let me check if we have anything else.
49 00:06:39.420 ⇒ 00:06:51.590 Nicolas Sucari: I don’t think we have yet anything we need to finish that strategic document so that we understand, like which other projects, we can start exploring. And once that is ready, we can start with anything there. Yeah.
50 00:06:52.100 ⇒ 00:06:53.479 Bo Yoon: Hmm, okay. Okay.
51 00:06:53.480 ⇒ 00:06:54.090 Nicolas Sucari: Okay.
52 00:06:54.680 ⇒ 00:07:05.879 Nicolas Sucari: cool, great Luke. So I think the the post pilot stuff on pull parts was all done we need just by us to check the real dashboards. If that is correct, right.
53 00:07:06.310 ⇒ 00:07:11.549 Luke Daque: Yeah, that’s right, and maybe share that with Kim. If it’s good.
54 00:07:12.680 ⇒ 00:07:16.400 Nicolas Sucari: Okay, okay, great. And you don’t have anything else for Google Watch. Right?
55 00:07:16.920 ⇒ 00:07:18.540 Luke Daque: Not at the moment. No.
56 00:07:19.570 ⇒ 00:07:20.460 Nicolas Sucari: Excellent. Okay.
57 00:07:20.460 ⇒ 00:07:23.930 Bo Yoon: Can, can I? Can. I also have access to the real dashboard?
58 00:07:24.100 ⇒ 00:07:27.089 Bo Yoon: If? Yeah, yeah, of course, not too much. Yeah, thank you.
59 00:07:27.640 ⇒ 00:07:30.430 Nicolas Sucari: I’ll share. I’ll share that after the meeting. But yep.
60 00:07:30.430 ⇒ 00:07:31.969 Bo Yoon: Yeah, thank you so much.
61 00:07:33.100 ⇒ 00:07:40.219 Nicolas Sucari: Cool. Okay. And I wish I just saw that message. What are you not being able to like? Filter down.
62 00:07:42.500 ⇒ 00:07:43.610 Bo Yoon: For for which, one.
63 00:07:43.610 ⇒ 00:07:44.730 Awaish Kumar: I’m I’m just.
64 00:07:44.730 ⇒ 00:07:46.249 Nicolas Sucari: No, no. Sorry for a wage. Yeah.
65 00:07:46.370 ⇒ 00:07:47.337 Bo Yoon: Oh, sorry! Sorry!
66 00:07:47.660 ⇒ 00:07:52.749 Awaish Kumar: The tasks for status planned, and why, when I
67 00:07:52.950 ⇒ 00:07:57.819 Awaish Kumar: filter on status planned, just selects, not planned.
68 00:07:58.010 ⇒ 00:08:00.379 Awaish Kumar: and and shows all of the tasks.
69 00:08:00.380 ⇒ 00:08:00.920 Nicolas Sucari: So.
70 00:08:01.060 ⇒ 00:08:03.079 Awaish Kumar: Except the ones I want to see.
71 00:08:03.770 ⇒ 00:08:08.200 Nicolas Sucari: Let me share. Let me share. Is this one? Let me see.
72 00:08:10.570 ⇒ 00:08:11.590 Nicolas Sucari: Okay, wait.
73 00:08:12.750 ⇒ 00:08:18.709 Nicolas Sucari: So you’re you’re here on the Javi coffee page, right, and you want to filter down only by one status. Right?
74 00:08:18.710 ⇒ 00:08:19.070 Awaish Kumar: You’re.
75 00:08:19.070 ⇒ 00:08:20.009 Nicolas Sucari: Like to see these ones.
76 00:08:20.010 ⇒ 00:08:21.760 Awaish Kumar: Yes, yes, yes, yes.
77 00:08:21.760 ⇒ 00:08:24.669 Nicolas Sucari: So if you add a filter here.
78 00:08:25.730 ⇒ 00:08:26.110 Awaish Kumar: Okay.
79 00:08:26.110 ⇒ 00:08:26.530 Nicolas Sucari: It was.
80 00:08:26.530 ⇒ 00:08:27.200 Awaish Kumar: You know.
81 00:08:28.300 ⇒ 00:08:29.040 Nicolas Sucari: Planned.
82 00:08:29.350 ⇒ 00:08:30.890 Nicolas Sucari: You cannot see this.
83 00:08:32.080 ⇒ 00:08:37.850 Awaish Kumar: Okay, you are adding differently. I was just using this one on the right hand side. There is filter option.
84 00:08:39.299 ⇒ 00:08:39.999 Nicolas Sucari: We join.
85 00:08:40.229 ⇒ 00:08:40.699 Nicolas Sucari: Thank you.
86 00:08:40.700 ⇒ 00:08:42.770 Awaish Kumar: If you go on the right right hand side.
87 00:08:43.429 ⇒ 00:08:44.189 Nicolas Sucari: This one.
88 00:08:45.060 ⇒ 00:08:46.279 Awaish Kumar: Yeah, this one.
89 00:08:47.230 ⇒ 00:08:49.090 Awaish Kumar: Finally, not posting.
90 00:08:49.770 ⇒ 00:08:56.279 Nicolas Sucari: Okay, this opens up the filter options here. So yeah, you you can. Yeah, just click here, it will
91 00:08:56.280 ⇒ 00:08:58.290 Nicolas Sucari: open these status.
92 00:08:58.970 ⇒ 00:09:01.270 Awaish Kumar: Let me try again.
93 00:09:02.030 ⇒ 00:09:02.650 Nicolas Sucari: Okay.
94 00:09:04.330 ⇒ 00:09:06.139 Awaish Kumar: It wasn’t working for me.
95 00:09:06.330 ⇒ 00:09:17.229 Nicolas Sucari: Maybe maybe check which view like in which view you are on this board, because if you are in that like in the down view. You’re not going to be seeing any, because there is already another filter here, you see.
96 00:09:19.480 ⇒ 00:09:26.440 Nicolas Sucari: Go to the old tickets view. And yeah, just add the status fine.
97 00:09:26.440 ⇒ 00:09:31.900 Awaish Kumar: Yeah, like and can I share my screen?
98 00:09:32.530 ⇒ 00:09:33.750 Nicolas Sucari: Yeah, sure.
99 00:09:35.396 ⇒ 00:09:39.030 Awaish Kumar: Yeah. So can you see it?
100 00:09:41.960 ⇒ 00:09:45.070 Nicolas Sucari: Yeah, but you’re filtering with not for no plan there, right.
101 00:09:45.070 ⇒ 00:09:48.329 Awaish Kumar: Yes, but I selected this one.
102 00:09:50.640 ⇒ 00:09:56.349 Nicolas Sucari: Alright, but you’re you’re in the upcoming view. Can you check? Go to your old tickets there on the top?
103 00:10:01.130 ⇒ 00:10:07.689 Nicolas Sucari: No, no, in the same database that you are same database that you are. There. You see that on top of the filter it says upcoming.
104 00:10:07.690 ⇒ 00:10:08.500 Awaish Kumar: Come on. Yeah.
105 00:10:08.530 ⇒ 00:10:10.490 Nicolas Sucari: Click, click on all tickets.
106 00:10:11.170 ⇒ 00:10:11.980 Awaish Kumar: Okay.
107 00:10:12.630 ⇒ 00:10:16.430 Nicolas Sucari: Yeah, and do the filter. Now here, click on the filter.
108 00:10:16.540 ⇒ 00:10:18.999 Nicolas Sucari: add add a filter for status.
109 00:10:21.630 ⇒ 00:10:22.300 Awaish Kumar: Okay.
110 00:10:23.030 ⇒ 00:10:24.330 Nicolas Sucari: And go to plan.
111 00:10:25.010 ⇒ 00:10:27.040 Awaish Kumar: Okay. Okay.
112 00:10:28.010 ⇒ 00:10:29.259 Awaish Kumar: Okay. Thank you.
113 00:10:30.960 ⇒ 00:10:32.070 Nicolas Sucari: Cool. Okay?
114 00:10:32.547 ⇒ 00:10:41.829 Nicolas Sucari: So yeah, maybe a ways, we need to start looking at that stuff for Tiktok. And we need to check the data for the gorgeous stuff.
115 00:10:42.083 ⇒ 00:11:04.149 Nicolas Sucari: In the in the meeting with a man, you know, he he asked for those questions that we have for gorgeous. I send that to the external channel. So if you can take a look at the gorgeous data and see if we can, if you’re gonna be able to answer. Like all of those questions with the data that we have, that would be amazing. And then we can like start creating a ticket to understand how we can create that report in Meta base. Okay.
116 00:11:06.166 ⇒ 00:11:07.059 Awaish Kumar: Yeah, sure.
117 00:11:08.600 ⇒ 00:11:09.800 Nicolas Sucari: Cool. Okay.
118 00:11:10.290 ⇒ 00:11:11.050 Nicolas Sucari: Great.
119 00:11:11.540 ⇒ 00:11:13.520 Nicolas Sucari: What else do we have guys.
120 00:11:18.093 ⇒ 00:11:22.079 Luke Daque: Yeah, I’m still working on the stuff for tablets.
121 00:11:22.210 ⇒ 00:11:27.970 Luke Daque: We just already how? We the-the-
122 00:11:28.110 ⇒ 00:11:30.350 Luke Daque: data from segment is already in
123 00:11:30.500 ⇒ 00:11:35.860 Luke Daque: Snowflake. And so, yeah, I’ll be working on that one. And I also already created the mapping
124 00:11:36.550 ⇒ 00:11:40.430 Luke Daque: sheet for the pricing tiers which I will be incorporating into the
125 00:11:40.700 ⇒ 00:11:43.360 Luke Daque: data models that need the pricing tiers.
126 00:11:44.086 ⇒ 00:11:50.170 Luke Daque: So yeah, that’s basically, yeah, that’s what I’m working on. Essentially.
127 00:11:50.770 ⇒ 00:11:52.180 Nicolas Sucari: All great stuff. Good stuff.
128 00:11:52.180 ⇒ 00:11:52.830 Nicolas Sucari: Okay?
129 00:11:53.450 ⇒ 00:11:54.800 Nicolas Sucari: Perfect. Yeah.
130 00:11:57.240 ⇒ 00:11:58.390 Nicolas Sucari: Cool. Yeah.
131 00:11:59.000 ⇒ 00:12:03.590 Nicolas Sucari: And pay us. I can see you’re here, maybe. Yeah, hey.
132 00:12:03.590 ⇒ 00:12:04.240 Payas Parab: Yup, yeah.
133 00:12:04.240 ⇒ 00:12:09.039 Nicolas Sucari: You know I’m all good. I know you’re you’re you’re
134 00:12:09.150 ⇒ 00:12:12.239 Nicolas Sucari: started to work on the geomatching stuff or not yet.
135 00:12:12.240 ⇒ 00:12:13.240 Payas Parab: I am. Yeah.
136 00:12:15.850 ⇒ 00:12:23.088 Payas Parab: let me I I’ve I’ve already started to. I actually was just reviewing some of that just before this.
137 00:12:24.120 ⇒ 00:12:28.869 Payas Parab: we need to basically make the app. Are you sharing your screen? By the way, I don’t see that.
138 00:12:28.870 ⇒ 00:12:31.290 Nicolas Sucari: No, I’m not sharing, but I can share.
139 00:12:31.290 ⇒ 00:12:40.229 Payas Parab: Sorry. Sorry. So yeah. The Geo matching stuff. I do. You have like a sense of like when when they’re expecting or like what? What they when they want, that.
140 00:12:41.030 ⇒ 00:12:54.269 Nicolas Sucari: Yeah, I think we need to wait until Robert send, like these kind of road, new new stuff on the roadmap, because in the meeting we discussed and see a man asked to create like a chat conversation between him just in
141 00:12:54.673 ⇒ 00:13:05.610 Nicolas Sucari: you, and I don’t know who else on their side to discuss like, what’s the next steps for these projects? Yeah. So maybe we can wait until that one. I think I I thought that you were already starting to to work on that one.
142 00:13:05.610 ⇒ 00:13:16.360 Nicolas Sucari: I I did. Yeah, I I like it’s it’s more like just cleaning up. The code is like, basically. So we can rerun. They just need like a place where they can upload a spreadsheet. That’s what like. It’s the same thing we’ve already. We’ve already done.
143 00:13:16.530 ⇒ 00:13:19.939 Payas Parab: The core data work to it. It’s just a matter of getting the
144 00:13:20.190 ⇒ 00:13:24.219 Payas Parab: the streamlit app up and running so that they can upload a spreadsheet.
145 00:13:25.000 ⇒ 00:13:25.600 Nicolas Sucari: Okay.
146 00:13:25.910 ⇒ 00:13:26.700 Nicolas Sucari: Okay.
147 00:13:26.700 ⇒ 00:13:38.370 Payas Parab: But I wanted to make sure we never got feedback on like, did that matching thing go correctly? Did they actually find use? And like. You know what I mean. We never got any feedback. I don’t know if Aman shared anything, or if that was like purely a Justin project.
148 00:13:39.080 ⇒ 00:13:49.569 Nicolas Sucari: Yeah, I think it was purely adjusting one. But yeah, we we may need to have like that conversation between Aman Justin and us to see, like what else we need. They need there. Okay.
149 00:13:49.570 ⇒ 00:13:50.670 Payas Parab: Yeah, cool.
150 00:13:51.250 ⇒ 00:13:52.530 Nicolas Sucari: Okay, cool.
151 00:13:53.420 ⇒ 00:14:10.830 Nicolas Sucari: Great. Okay, yeah. Apart from that, yeah, from the Javi meeting. There are like new other tasks that Robert is working on, and he’ll share in the channel so that we can start like prioritizing. So yeah, maybe we should need to wait for that. Okay.
152 00:14:13.836 ⇒ 00:14:14.583 Awaish Kumar: Nicholas,
153 00:14:15.520 ⇒ 00:14:18.910 Nicolas Sucari: Yeah, about this tick. Tock, Api.
154 00:14:19.780 ⇒ 00:14:22.149 Awaish Kumar: I see the task I see that
155 00:14:23.020 ⇒ 00:14:28.940 Awaish Kumar: would like in the description. It says that we need to identify the connector.
156 00:14:29.160 ⇒ 00:14:34.311 Awaish Kumar: but the utham mentioned like we still committed yesterday about
157 00:14:35.835 ⇒ 00:14:38.209 Awaish Kumar: putting it on the portable roadmap.
158 00:14:38.490 ⇒ 00:14:41.549 Awaish Kumar: So like should we be asking portable team
159 00:14:41.860 ⇒ 00:14:48.160 Awaish Kumar: to to look into it like to look for the Tiktok to build this connector for us, are we?
160 00:14:48.160 ⇒ 00:14:51.499 Awaish Kumar: Yeah? Still looking, think? Yes, I.
161 00:14:51.730 ⇒ 00:15:05.239 Nicolas Sucari: I think we can do both things like as portable to see if they can add that into their roadmap and see when we can have, like that connector ready from them. But also, I think we can start taking a look if there is another way on getting that data directly from Tiktok.
162 00:15:06.480 ⇒ 00:15:13.730 Awaish Kumar: Okay. So if there is any other ways, are we looking for like free tools, or
163 00:15:14.360 ⇒ 00:15:15.850 Awaish Kumar: or any any other tool.
164 00:15:16.990 ⇒ 00:15:28.109 Nicolas Sucari: I’m not sure. So we just need to understand if there is another way, and then propose to them if we can do that, if there is another tool that has that connector ready, or we can use. Yeah, that’s possible.
165 00:15:29.510 ⇒ 00:15:30.270 Awaish Kumar: Okay.
166 00:15:31.370 ⇒ 00:15:32.000 Nicolas Sucari: Okay.
167 00:15:33.690 ⇒ 00:15:34.640 Nicolas Sucari: Okay.
168 00:15:35.090 ⇒ 00:15:39.620 Nicolas Sucari: Oh, okay, guys, I think we’re done. Let me know if you need anything else. Okay.
169 00:15:40.780 ⇒ 00:15:43.109 Luke Daque: That’s good and just a quick
170 00:15:43.722 ⇒ 00:15:47.960 Luke Daque: thing. I might log off earlier than usual today, cause I’m not really feeling
171 00:15:48.100 ⇒ 00:15:54.389 Luke Daque: that. Well, so if there’s anything urgent, just slack me or anything.
172 00:15:55.700 ⇒ 00:15:56.839 Nicolas Sucari: Yeah, okay.
173 00:15:56.840 ⇒ 00:15:58.819 Bo Yoon: Sure, hey? Pious!
174 00:15:59.500 ⇒ 00:16:02.340 Bo Yoon: I actually have a question.
175 00:16:02.340 ⇒ 00:16:02.980 Payas Parab: What the.
176 00:16:02.980 ⇒ 00:16:10.070 Bo Yoon: The the missing skews. Yeah. So did you get a chance to look at the Google sheet?
177 00:16:10.290 ⇒ 00:16:18.019 Payas Parab: Let me let me pull that up right now. We can quickly review that also. If they want to drop off they should. So you don’t have to just like sit here while we look.
178 00:16:18.500 ⇒ 00:16:22.580 Payas Parab: Ryan or Aisha, if it’s not relevant to you, feel free to drop off
179 00:16:22.880 ⇒ 00:16:29.380 Payas Parab: unless there’s other stuff right? And Nico, if you want to just drop on me. And Beau can just review the spreadsheet, but it is relevant to pool parts.
180 00:16:31.560 ⇒ 00:16:32.889 Nicolas Sucari: I’m staying. No problem.
181 00:16:32.890 ⇒ 00:16:43.730 Payas Parab: Great. Alright, thanks. Just wanna make sure we didn’t keep them on the call. Okay? So let’s look at the spreadsheet right now. I’m gonna quickly share my screen.
182 00:16:47.220 ⇒ 00:16:49.199 Payas Parab: Let me quickly.
183 00:16:52.240 ⇒ 00:16:54.479 Payas Parab: Sorry. I’m just looking for the right channel.
184 00:16:55.370 ⇒ 00:16:56.590 Payas Parab: And then.
185 00:16:56.710 ⇒ 00:17:09.750 Payas Parab: yeah. So you merge everything in. And you isolated to the it looks like you isolated to where the vendors are like pool parts is involved in the transaction, essentially, or like what we denote to be pool parts.
186 00:17:11.349 ⇒ 00:17:14.292 Bo Yoon: So so the blue columns are basically the
187 00:17:14.969 ⇒ 00:17:19.679 Bo Yoon: the data that I’m pulling from the Asia connection sales details sheet.
188 00:17:20.119 ⇒ 00:17:21.050 Payas Parab: Great.
189 00:17:22.280 ⇒ 00:17:29.600 Bo Yoon: So so that the blue collar cells, those blue collar cells are the average
190 00:17:31.300 ⇒ 00:17:34.950 Bo Yoon: price per of the orders, like per order.
191 00:17:35.500 ⇒ 00:17:36.460 Payas Parab: Got it?
192 00:17:36.650 ⇒ 00:17:38.339 Payas Parab: Average price per order.
193 00:17:38.480 ⇒ 00:17:41.260 Bo Yoon: Yeah. And the and the yellowish cells are the
194 00:17:42.376 ⇒ 00:17:46.680 Bo Yoon: are the data, and that that I’m getting from the skew table, which I mean.
195 00:17:46.680 ⇒ 00:17:47.750 Payas Parab: With price.
196 00:17:48.040 ⇒ 00:17:49.890 Bo Yoon: Yeah skew table with price sheet.
197 00:17:50.910 ⇒ 00:17:53.280 Bo Yoon: So Nico, I think.
198 00:17:53.430 ⇒ 00:18:01.310 Payas Parab: During our conversation yesterday. We wanted to compare those 2 prices. That’s what I did here.
199 00:18:01.760 ⇒ 00:18:02.230 Payas Parab: Okay.
200 00:18:02.230 ⇒ 00:18:03.000 Nicolas Sucari: Yeah. So
201 00:18:03.360 ⇒ 00:18:09.289 Nicolas Sucari: what what we did pay us was, get all of the sales details from Asia. Try to figure out like
202 00:18:09.540 ⇒ 00:18:22.449 Nicolas Sucari: that. Average sales. Price or the yeah, the unit price that we have for those skews. And the idea is to compare that with the cogs, the the cost of those skews that we have on Dan’s file. And with that we can say, Hey.
203 00:18:22.721 ⇒ 00:18:46.850 Nicolas Sucari: we are selling this product, maybe, or we have the cost for this product that is lower at what we at what Asia is selling to us, and that should be an issue that we need to discuss with them right like we don’t know which is the actual value that they are like they are using for costs. So I think this is like the best that we can have to discuss with them and understand. If we are like, we need to change any of the costs for this queue. That’s that that are on this list right?
204 00:18:47.310 ⇒ 00:18:51.200 Payas Parab: Yep so, and the the basis to that would be like the difference here between.
205 00:18:52.590 ⇒ 00:18:53.460 Nicolas Sucari: Exactly. Yeah.
206 00:18:53.500 ⇒ 00:19:01.089 Payas Parab: This is this one is your I guess we should flip it. But it would be like this price that you’re actually selling it for
207 00:19:01.400 ⇒ 00:19:05.769 Payas Parab: is 6% too low would be like the conclusion.
208 00:19:05.770 ⇒ 00:19:09.119 Nicolas Sucari: But how? How? How are you comparing that like 6% like we are
209 00:19:09.980 ⇒ 00:19:17.299 Nicolas Sucari: the wholesale price margin of 7% like we, what is that like? That’s the cost that we have from pull parts, from dance file.
210 00:19:17.950 ⇒ 00:19:21.970 Payas Parab: Yes, the and and that is like you assume a markup of
211 00:19:22.100 ⇒ 00:19:27.710 Payas Parab: you assume a markup of 7%. So that should reflect what the cost should.
212 00:19:28.420 ⇒ 00:19:34.629 Payas Parab: I can’t tell if that’s the cost, or like what they should be selling it for, like I’m trying to interpret, like basically like in
213 00:19:35.010 ⇒ 00:19:35.510 Payas Parab: no.
214 00:19:35.510 ⇒ 00:19:44.749 Nicolas Sucari: We don’t have like like that wholesale price margin like that is not the the sale price and what they are selling those queues right like what pull bars is selling.
215 00:19:44.750 ⇒ 00:19:45.450 Payas Parab: Yeah.
216 00:19:47.510 ⇒ 00:19:48.080 Payas Parab: The.
217 00:19:48.080 ⇒ 00:19:57.379 Bo Yoon: So what I understand is that the that the yellow cell is what they are paying to Asia to to bring the.
218 00:19:57.380 ⇒ 00:19:58.020 Nicolas Sucari: Click.
219 00:19:58.470 ⇒ 00:20:04.129 Bo Yoon: The products right? What they’re paying to Asia to to get the products.
220 00:20:09.640 ⇒ 00:20:11.450 Nicolas Sucari: But no, no, I think
221 00:20:11.560 ⇒ 00:20:20.240 Nicolas Sucari: I’m not sure about that. Yeah. So what I think they are paying to Asia is the blue one. But right like this is the because in the sales detail Asia is having like these.
222 00:20:20.360 ⇒ 00:20:27.016 Nicolas Sucari: they are selling like to pull parts and iron wreck these. These values right?
223 00:20:27.460 ⇒ 00:20:28.030 Bo Yoon: Okay.
224 00:20:28.240 ⇒ 00:20:50.439 Nicolas Sucari: Yeah, on average. But that’s fine, like this is the price they are paying for. Like the 1st queue. Right? What we need. What I’m trying to understand is all of these other, all of these other costs that we have from done. File the full cost, freight, duty, tariff, everything there until the wholesale price margin is like all of that. Like all of these sums, the cost that they have
225 00:20:50.990 ⇒ 00:21:02.579 Nicolas Sucari: like, they that they are actually assigning to that skew, or we should need to like, revisit that that cost because of the sale price that the that Asia has for them right
226 00:21:03.740 ⇒ 00:21:09.940 Nicolas Sucari: like, if we need to check, like only one field from the dance file, it should be this one. How are we getting
227 00:21:10.600 ⇒ 00:21:13.570 Nicolas Sucari: like these? 100 right.
228 00:21:15.240 ⇒ 00:21:23.150 Bo Yoon: So so maybe the problem would be that the that the cost, it’s not updated correctly.
229 00:21:24.020 ⇒ 00:21:24.580 Nicolas Sucari: Yeah, exactly.
230 00:21:25.370 ⇒ 00:21:28.529 Bo Yoon: Cost freight duty tariffs.
231 00:21:28.850 ⇒ 00:21:31.499 Bo Yoon: Maybe that’s that’s kind of outdated.
232 00:21:32.060 ⇒ 00:21:33.630 Bo Yoon: It needs to be updated
233 00:21:34.310 ⇒ 00:21:38.870 Bo Yoon: to. So so it can be matched to the to the blue cells that we’re seeing here.
234 00:21:44.920 ⇒ 00:21:46.800 Nicolas Sucari: Maybe. Yes, I mean, I don’t know
235 00:21:46.930 ⇒ 00:21:56.460 Nicolas Sucari: what I trying. What I’m trying to to get with this is Asia is selling at a at a price or poop, is buying information at some at at some price. That price is.
236 00:21:56.460 ⇒ 00:21:57.120 Bo Yoon: Thank you.
237 00:21:57.120 ⇒ 00:22:08.300 Nicolas Sucari: Column. U, right? Like, if you’re selling at that price, pool party is buying at this price. Okay? And what is the actual cost of that skew that pool parts is assigning to their products when they sell. That’s what
238 00:22:08.300 ⇒ 00:22:09.020 Nicolas Sucari: unique to it. Yeah.
239 00:22:09.020 ⇒ 00:22:21.460 Nicolas Sucari: right? So if we identify that that cost is is lower than what they are buying from Asia. They are losing because they are not gonna be selling so much like they are not gonna be reaching the margins that they want right.
240 00:22:21.850 ⇒ 00:22:24.730 Bo Yoon: Yeah, got it?
241 00:22:26.860 ⇒ 00:22:28.950 Nicolas Sucari: What do you think, payoff on that.
242 00:22:30.200 ⇒ 00:22:34.010 Payas Parab: That like sounds right. But we may need to just confirm that with like Dan, like.
243 00:22:34.010 ⇒ 00:22:34.770 Nicolas Sucari: Exactly. Yeah.
244 00:22:34.770 ⇒ 00:22:50.770 Payas Parab: We we have enough to like, basically be like, here’s the data. And here’s like what we cleaned up from your sheet and what we got from Ian, and like understanding what the best way to look at that might be. And we’re trying to understand, like, basic what’s that outcome you’re looking for. I I think we have enough here to like.
245 00:22:51.030 ⇒ 00:22:55.500 Payas Parab: just basically ask them these questions like, like, I like, we can’t magically know these answers.
246 00:22:55.780 ⇒ 00:22:56.460 Nicolas Sucari: Exactly. Yeah.
247 00:22:56.460 ⇒ 00:22:58.309 Payas Parab: Yeah, yeah, I think like.
248 00:22:58.630 ⇒ 00:23:17.099 Payas Parab: this is like, basically, we cleaned up that spreadsheet. We pulled it in. We like, tried to find, like, where there’s duplicate data like this kind of like the state where we’re at right. And then we also pulled the data from Asia. We found Bo. As you mentioned. There’s like filters, right of like which one we tried to match the best of our abilities based on skew. Here’s what we were able
249 00:23:17.650 ⇒ 00:23:22.730 Payas Parab: for these top 20. We know these to be the top 20. And so like.
250 00:23:22.870 ⇒ 00:23:26.289 Payas Parab: yeah, like, here’s and here’s the sales price that we’re seeing.
251 00:23:26.910 ⇒ 00:23:30.459 Payas Parab: And then how we interpret these, yeah.
252 00:23:30.800 ⇒ 00:23:54.239 Nicolas Sucari: Yeah, that’s perfect. I think that’s perfect. And they are. Gonna they are gonna be the ones who sell, who tell us that this is correct, or that we need to look at at different values, or I don’t know different information. So can we? Can. Can you pay us prepared like that message. And like, answer, my, the email that I sent yesterday asking for the meeting with this information and trying to see if we can catch their attention with with that.
253 00:23:54.460 ⇒ 00:23:59.290 Payas Parab: Yup, yeah, let’s see if we can. Just
254 00:24:01.700 ⇒ 00:24:03.439 Payas Parab: want to. Just draft that. Now.
255 00:24:04.280 ⇒ 00:24:05.080 Nicolas Sucari: Yeah, okay.
256 00:24:06.970 ⇒ 00:24:17.419 Payas Parab: So, hey, yeah, just to recap. So, hey, here’s what we’ve done. Here’s what we’ve reviewed. We have some clarifying questions, but also like, have some preliminary views that we can
257 00:24:18.110 ⇒ 00:24:19.660 Payas Parab: discuss essentially.
258 00:24:21.740 ⇒ 00:24:24.950 Payas Parab: Where is that from.
259 00:24:26.510 ⇒ 00:24:28.660 Nicolas Sucari: There, there is the 3rd one. Yeah.
260 00:24:28.660 ⇒ 00:24:29.780 Payas Parab: Out there one second.
261 00:24:30.660 ⇒ 00:24:33.430 Nicolas Sucari: Yeah, it’s gonna be, yeah. Second, one.
262 00:24:43.190 ⇒ 00:24:45.290 Payas Parab: Then Bo’s on this email as well. Yep.
263 00:24:45.570 ⇒ 00:24:46.110 Nicolas Sucari: Yep.
264 00:24:47.060 ⇒ 00:24:47.500 Bo Yoon: Shooter.
265 00:24:48.620 ⇒ 00:24:49.390 Payas Parab: What’s up?
266 00:24:50.210 ⇒ 00:24:56.329 Bo Yoon: Should I? Hey, Nico? Should I include island rag
267 00:24:57.030 ⇒ 00:24:59.940 Bo Yoon: for for this calculation as well? Or.
268 00:25:01.780 ⇒ 00:25:04.440 Nicolas Sucari: I’m not sure that’s something that we need to ask them.
269 00:25:04.440 ⇒ 00:25:05.020 Bo Yoon: And.
270 00:25:05.020 ⇒ 00:25:06.609 Nicolas Sucari: I’m not sure like. What’s the.
271 00:25:07.310 ⇒ 00:25:14.580 Bo Yoon: Or or only feel free by by pool parts to go, because the yeah do it by that.
272 00:25:15.400 ⇒ 00:25:17.560 Bo Yoon: Yeah, let me let me just add another.
273 00:25:19.720 ⇒ 00:25:21.759 Nicolas Sucari: Do it, do it only with pool parts. And then
274 00:25:22.190 ⇒ 00:25:25.560 Nicolas Sucari: if they, if we need to add in Island Rec, we can do it. Okay.
275 00:25:26.230 ⇒ 00:25:27.309 Bo Yoon: Okay, got it?
276 00:25:29.420 ⇒ 00:25:31.689 Nicolas Sucari: But I’m I’m not sure how like
277 00:25:32.550 ⇒ 00:25:36.200 Nicolas Sucari: how they they how island recollect plays in in all of this.
278 00:25:53.510 ⇒ 00:25:54.970 Payas Parab: Match them to
279 00:26:02.120 ⇒ 00:26:04.589 Payas Parab: the costing data provided by Dan.
280 00:26:05.350 ⇒ 00:26:05.940 Nicolas Sucari: Yeah.
281 00:26:12.900 ⇒ 00:26:18.349 Payas Parab: The the revenue data. You got it from from Ian, right? Like the top 20 skews. Okay.
282 00:26:19.040 ⇒ 00:26:25.659 Nicolas Sucari: Maybe maybe that’s something that we need to like. Let Dan know. And maybe we need to
283 00:26:25.820 ⇒ 00:26:37.319 Nicolas Sucari: just focus on like the top 20 on for pull parts, because from from the em files what we, what we understand is, or what I understand is that they are selling not only for pull parts, but also other
284 00:26:37.790 ⇒ 00:26:38.769 Nicolas Sucari: other clients. Right?
285 00:26:38.770 ⇒ 00:26:45.040 Payas Parab: My, my only my only hesitation with that assumption is that, like it seems weird, that they would send all of their data. Like all.
286 00:26:45.040 ⇒ 00:27:00.869 Nicolas Sucari: Yeah, that’s what. Bo? Yeah, that’s what Bo asked yesterday again. But what I tried to explain is Asia connection and pool parts. They are connected at some point, I think Asia connection is owned by Dan’s father-in-law, or something like that.
287 00:27:00.870 ⇒ 00:27:01.800 Payas Parab: Got it.
288 00:27:02.100 ⇒ 00:27:06.200 Nicolas Sucari: That’s why, I think they send everything regarding that.
289 00:27:17.730 ⇒ 00:27:21.290 Payas Parab: Listed in the revenue and costing data. Ian provided.
290 00:27:22.980 ⇒ 00:27:27.299 Nicolas Sucari: Yeah, it’s sales and purchase and sales. I think it’s right.
291 00:27:27.610 ⇒ 00:27:28.160 Payas Parab: Yep.
292 00:27:57.700 ⇒ 00:28:01.745 Payas Parab: what do we call that thing at the end? It’s like the like the landed cost or something.
293 00:28:07.520 ⇒ 00:28:11.020 Payas Parab: Also, we weren’t able to match all 20, right, or were we? I’m trying to think.
294 00:28:12.930 ⇒ 00:28:14.400 Bo Yoon: The the missing ones.
295 00:28:14.400 ⇒ 00:28:16.650 Payas Parab: Yeah, we have 5 missing ones.
296 00:28:19.210 ⇒ 00:28:25.919 Bo Yoon: Yeah, I mean, those were present on the Asia data sheet, but not on.
297 00:28:26.470 ⇒ 00:28:28.780 Nicolas Sucari: But from the skew table.
298 00:28:29.100 ⇒ 00:28:34.300 Bo Yoon: They were there, but not active, so there was no data for.
299 00:28:34.300 ⇒ 00:28:34.770 Payas Parab: Okay.
300 00:28:34.770 ⇒ 00:28:39.179 Bo Yoon: Yeah, I mean, not active or no. No data for the
301 00:28:39.580 ⇒ 00:28:42.210 Payas Parab: Yeah. No like this stuff was missing.
302 00:28:42.370 ⇒ 00:28:43.120 Bo Yoon: Yeah.
303 00:28:44.020 ⇒ 00:28:55.980 Payas Parab: Okay, cool top skews. We matched 15 out of 20 to the costing sheet.
304 00:28:59.770 ⇒ 00:29:00.860 Bo Yoon: 15, yeah.
305 00:29:01.490 ⇒ 00:29:03.370 Payas Parab: So do we review the.
306 00:29:12.380 ⇒ 00:29:14.689 Payas Parab: you know, to 20 to the costing sheet.
307 00:29:20.530 ⇒ 00:29:26.200 Payas Parab: We. From our discussion with Ian, we understood
308 00:29:29.550 ⇒ 00:29:34.694 Payas Parab: there are some limitations to like doing analysis at the skew level right.
309 00:29:35.350 ⇒ 00:29:35.900 Nicolas Sucari: Yeah.
310 00:29:35.900 ⇒ 00:29:38.480 Payas Parab: Customer level grouping may be better.
311 00:29:52.040 ⇒ 00:29:53.480 Payas Parab: let me see.
312 00:29:54.860 ⇒ 00:29:57.930 Payas Parab: Yeah. So we have this. We have the top 20.
313 00:30:00.490 ⇒ 00:30:05.499 Payas Parab: And then how should I describe. We’ve calculated the yeah. The wholesale price margin.
314 00:30:05.640 ⇒ 00:30:08.179 Payas Parab: the wholesale price of the margin of 7%.
315 00:30:08.360 ⇒ 00:30:13.230 Payas Parab: And also the actual sales price from the purchase data is that accurate.
316 00:30:14.800 ⇒ 00:30:18.270 Bo Yoon: Is this from purchase data or sales data? Bo, the sales data.
317 00:30:18.270 ⇒ 00:30:19.030 Nicolas Sucari: Sales, sales.
318 00:30:19.030 ⇒ 00:30:19.620 Bo Yoon: Yeah, sales. Sales.
319 00:30:21.790 ⇒ 00:30:22.870 Payas Parab: Excellent okay.
320 00:30:27.680 ⇒ 00:30:33.559 Payas Parab: and average price per skew from the sales data.
321 00:30:36.990 ⇒ 00:30:43.640 Payas Parab: How do we? We should probably call this out to Dan, because I don’t want to like. Put it on, Ian. I think it’s like more
322 00:30:45.450 ⇒ 00:30:47.079 Payas Parab: right. Or is this just both of them.
323 00:30:47.080 ⇒ 00:30:49.899 Nicolas Sucari: Yeah, yeah, it’s for Dan. I think it’s that’s okay.
324 00:30:52.390 ⇒ 00:30:58.240 Payas Parab: I think we need to the model
325 00:31:06.440 ⇒ 00:31:08.239 Payas Parab: from our discussion at the end.
326 00:31:09.510 ⇒ 00:31:15.690 Payas Parab: But we did pull settings, data, skew level.
327 00:31:27.294 ⇒ 00:31:29.950 Payas Parab: I’m sorry. What was the last question we said, oh, how do we?
328 00:31:30.190 ⇒ 00:31:33.580 Payas Parab: How do we view the difference between
329 00:31:37.030 ⇒ 00:31:41.829 Payas Parab: what do we call it? The land wholesale price margin
330 00:31:50.570 ⇒ 00:31:55.489 Payas Parab: between after the wholesale price margin versus the average price
331 00:31:56.050 ⇒ 00:31:59.620 Payas Parab: from the Asia sales data. Essentially, what Bo calculated
332 00:32:00.170 ⇒ 00:32:03.560 Payas Parab: is this kind of like a good summary of our outstanding questions.
333 00:32:14.110 ⇒ 00:32:18.074 Payas Parab: some limitations to skew level, costing, grouping, right.
334 00:32:21.140 ⇒ 00:32:29.279 Bo Yoon: Yeah, hey, Pius, before you send this email? Can you give me some time to just double check the data that I calculated.
335 00:32:29.280 ⇒ 00:32:38.250 Payas Parab: Sure. Yeah, what we could also do is we? We don’t like this. These questions, I don’t think are like you can double check that I don’t think we need to like. Wait on sending the email, though, right.
336 00:32:39.010 ⇒ 00:32:39.620 Bo Yoon: Oh, yeah. Yeah.
337 00:32:39.620 ⇒ 00:32:51.039 Payas Parab: I won’t. I won’t attach it. I won’t attach it. We’ll just go through it. Live and so that yeah, if you want to review it. But I say, we just send this now. So they have some sense of like what we’re doing and like where we’re stuck, and why
338 00:32:51.900 ⇒ 00:32:52.469 Bo Yoon: Okay. Okay.
339 00:32:52.470 ⇒ 00:32:58.270 Payas Parab: Think we have a good relationship with them, too. Right? Nico, like in general, like Dan.
340 00:32:58.270 ⇒ 00:32:59.040 Nicolas Sucari: Yeah.
341 00:32:59.040 ⇒ 00:33:02.319 Payas Parab: Over the time before I came on like a lot of trust. So I think
342 00:33:02.930 ⇒ 00:33:04.670 Payas Parab: I think it’s okay. If we’re like.
343 00:33:05.240 ⇒ 00:33:10.410 Payas Parab: yeah, we’re just we. I think we just send us. Does this look good? Nico beau? We good here.
344 00:33:11.220 ⇒ 00:33:18.870 Nicolas Sucari: Yeah, I think. Yeah. But let’s also add the link for the top. 20 skews sheet. Maybe.
345 00:33:18.870 ⇒ 00:33:20.040 Payas Parab: Wanna add it. Okay.
346 00:33:20.900 ⇒ 00:33:31.619 Payas Parab: okay, why don’t I? Why don’t I send this now and then? I’ll say Bo is reviewing the the data. One more time, and we’ll send the sheet that, like our progress so far.
347 00:33:32.310 ⇒ 00:33:34.179 Bo Yoon: Yeah, yeah.
348 00:33:34.310 ⇒ 00:33:34.900 Nicolas Sucari: Sure.
349 00:33:35.420 ⇒ 00:33:37.430 Payas Parab: A new member of our team
350 00:33:37.640 ⇒ 00:33:44.150 Payas Parab: has also been helping us with this wrangling, this.
351 00:33:44.440 ⇒ 00:33:50.889 Payas Parab: with this he will share our progress so far later today.
352 00:33:53.940 ⇒ 00:33:54.500 Nicolas Sucari: Yeah.
353 00:33:59.900 ⇒ 00:34:00.750 Payas Parab: We good.
354 00:34:01.840 ⇒ 00:34:03.050 Bo Yoon: Yeah. Looks. Good.
355 00:34:03.240 ⇒ 00:34:08.199 Payas Parab: Awesome. Thank you, guys, thank you, Bo, for jumping in. Thank you, Nico, for staying on top of it.
356 00:34:09.489 ⇒ 00:34:10.349 Nicolas Sucari: Thank you. Guys.
357 00:34:11.020 ⇒ 00:34:18.710 Payas Parab: And that’s everything. Then for this, for now. I just have to check the real dashboard which I’m checking now, Nico, and I’ll I’ll ping you on that right after here.
358 00:34:18.710 ⇒ 00:34:20.210 Nicolas Sucari: Thank you. Yeah.
359 00:34:20.400 ⇒ 00:34:22.530 Nicolas Sucari: Alright, thank you. Bye.
360 00:34:22.530 ⇒ 00:34:24.350 Bo Yoon: Have a nice day. Thank you.