Meeting Title: PoolParts data team Date: 2025-01-03 Meeting participants: Luke Daque, Nicolas Sucari, Payas Parab
WEBVTT
1 00:02:48.310 ⇒ 00:02:49.310 Nicolas Sucari: Hey, Luke.
2 00:02:55.350 ⇒ 00:02:57.349 Nicolas Sucari: you told me you’re not gonna join.
3 00:02:59.970 ⇒ 00:03:02.060 Nicolas Sucari: Hi! There! Can hear you.
4 00:03:04.130 ⇒ 00:03:04.810 Luke Daque: Hello!
5 00:03:05.530 ⇒ 00:03:06.150 Nicolas Sucari: Yeah, I guess.
6 00:03:06.150 ⇒ 00:03:06.590 Nicolas Sucari: Do you know.
7 00:03:06.590 ⇒ 00:03:09.550 Luke Daque: Oh, there, yeah, yeah, I was.
8 00:03:10.310 ⇒ 00:03:14.600 Luke Daque: I I figured, yeah, I’m still awake. So yeah, let me just join.
9 00:03:16.380 ⇒ 00:03:17.370 Nicolas Sucari: That’s fine
10 00:03:22.420 ⇒ 00:03:24.729 Nicolas Sucari: in creating the tickets right now.
11 00:03:25.800 ⇒ 00:03:31.069 Nicolas Sucari: And I need to write that email for Ian, can you share my screen?
12 00:03:34.240 ⇒ 00:03:35.869 Nicolas Sucari: I’m not sure
13 00:03:40.850 ⇒ 00:03:43.159 Nicolas Sucari: we have these? No.
14 00:06:00.580 ⇒ 00:06:04.719 Nicolas Sucari: do you think is this makes sense creating it like this?
15 00:06:05.840 ⇒ 00:06:10.649 Nicolas Sucari: So we have sale. Okay, here.
16 00:06:10.790 ⇒ 00:06:13.810 Nicolas Sucari: this queue data cleanup. This is
17 00:06:15.960 ⇒ 00:06:19.840 Nicolas Sucari: the distance algorithm was asking to you to do.
18 00:06:20.590 ⇒ 00:06:22.560 Luke Daque: Yeah, I think that’s fine.
19 00:06:23.840 ⇒ 00:06:26.659 Luke Daque: Yeah, that one. And.
20 00:06:27.710 ⇒ 00:06:35.829 Nicolas Sucari: Then I have the sales data integration. This is asking Ian to try to include
21 00:06:36.680 ⇒ 00:06:45.499 Nicolas Sucari: the last 2 years of sales data into the Asia list. This is for me. Maybe.
22 00:06:45.770 ⇒ 00:06:49.830 Luke Daque: There was also something about the categorization, right or something
23 00:06:50.594 ⇒ 00:06:55.550 Luke Daque: but I think that was Dan, or some to identify.
24 00:07:00.660 ⇒ 00:07:05.019 Nicolas Sucari: Identify categorization of of one model, the model stuff.
25 00:07:05.020 ⇒ 00:07:07.180 Luke Daque: Oh, yeah. The model stuff. Yeah.
26 00:07:07.513 ⇒ 00:07:10.179 Nicolas Sucari: Okay, yeah, I think it’s in the same.
27 00:07:10.610 ⇒ 00:07:22.240 Nicolas Sucari: Okay, it was almost gonna do that. So I’m not sure. Let me. So I have these. I have the pricing and cost verification, because once we get the full cost from Ian
28 00:07:22.760 ⇒ 00:07:23.580 Nicolas Sucari: right.
29 00:07:24.090 ⇒ 00:07:24.500 Luke Daque: Yeah.
30 00:07:24.910 ⇒ 00:07:28.810 Nicolas Sucari: We need to do this to pay us, too.
31 00:07:29.910 ⇒ 00:07:30.760 Nicolas Sucari: Think?
32 00:07:32.780 ⇒ 00:07:38.480 Nicolas Sucari: And then we we talked about doing it only for 20
33 00:07:38.690 ⇒ 00:07:40.979 Nicolas Sucari: prior, the the top 20 skus
34 00:07:41.420 ⇒ 00:07:44.810 Nicolas Sucari: the revenue, so that we start cleaning that up right.
35 00:07:44.810 ⇒ 00:07:45.623 Luke Daque: Right. Yep.
36 00:07:47.290 ⇒ 00:07:47.990 Nicolas Sucari: Okay?
37 00:07:52.340 ⇒ 00:07:55.639 Nicolas Sucari: And this is like the 1st step. Then we have
38 00:07:55.890 ⇒ 00:07:58.840 Nicolas Sucari: last. One would be like, use those
39 00:07:58.940 ⇒ 00:08:01.820 Nicolas Sucari: use that costs. And you’re pricing in
40 00:08:01.980 ⇒ 00:08:06.959 Nicolas Sucari: the platforms right? But I’ll make sure that for later
41 00:08:18.380 ⇒ 00:08:19.940 Nicolas Sucari: anybody else. How are you.
42 00:08:19.940 ⇒ 00:08:21.360 Payas Parab: How are you? Sorry I’m late?
43 00:08:22.280 ⇒ 00:08:25.440 Nicolas Sucari: No problem. I’m I’m sorry I didn’t see you. There.
44 00:08:26.079 ⇒ 00:08:30.490 Payas Parab: Didn’t want to interrupt your flow here. Okay? So I see, I I’m clear on the.
45 00:08:30.490 ⇒ 00:08:31.110 Nicolas Sucari: No, no.
46 00:08:31.110 ⇒ 00:08:31.860 Payas Parab: Yeah.
47 00:08:32.020 ⇒ 00:08:32.700 Payas Parab: Saw some.
48 00:08:34.429 ⇒ 00:08:36.279 Nicolas Sucari: We are trying to.
49 00:08:36.885 ⇒ 00:08:50.039 Nicolas Sucari: We. We had a meeting with Dan an hour ago where we talked about this queue stuff. But that’s the the requirement that we’ve been working on to get all the skews from all of
50 00:08:50.040 ⇒ 00:08:50.460 Nicolas Sucari: they differ
51 00:08:50.460 ⇒ 00:09:00.480 Nicolas Sucari: platforms that they have, and from the from where they are buying all of their their pumps and their products. And we’re gonna we’re
52 00:09:00.660 ⇒ 00:09:03.280 Nicolas Sucari: we’re trying to consolidate all of those
53 00:09:03.960 ⇒ 00:09:27.399 Nicolas Sucari: lists into having only one, so that we can then share to everyone in the company, and also apply that cost on pricing in all of the platforms. So they start selling at the correct price and buying also at the correct price. So that’s what we are talking about right now. In the meeting we we already have. Let me try to see if I can share here. Okay.
54 00:09:27.820 ⇒ 00:09:35.710 Nicolas Sucari: it’s so. What we worked with Luke here before is creating this this table where we have
55 00:09:35.900 ⇒ 00:09:46.560 Nicolas Sucari: this Asia list. Skew is where they are buying from. They have, like a huge amount of huge yeah, thousands of skews
56 00:09:47.052 ⇒ 00:10:00.399 Nicolas Sucari: with all of the products. So we are trying, we’re trying to identify which ones were active and inactive, matching that with all of the skills that we can extract from all of the platforms. So that’s why we have, like the Hsq list and the platform skill list.
57 00:10:00.908 ⇒ 00:10:18.959 Nicolas Sucari: Those are 2 different ones. We get the. We got the light latest order date from the platforms. But what we’re gonna try to get right now is also, which are the the skews from the Asia list that are that have orders in the past 2 years
58 00:10:19.210 ⇒ 00:10:21.519 Nicolas Sucari: so that we can focus on that ones.
59 00:10:23.742 ⇒ 00:10:43.150 Nicolas Sucari: But yeah, once we got that list from Ian that I’m gonna send an email asking for that, we will need to to work on creating like this new database with the skews, the cost, the pricing description, name, and everything that we can to have like these master list of skews. Okay.
60 00:10:45.050 ⇒ 00:10:54.633 Nicolas Sucari: that’s that’s what we were talking about. We split that task kind in 3 different parts. The data integration one is something that.
61 00:10:55.440 ⇒ 00:11:14.499 Nicolas Sucari: yeah, it’s to include all of that list from Ian. The data cleanup is right. And look here, we’ll we’ll work on doing one function in Snowflake. That will clean the names of these queues, trying to delete some characters that are kind of messing up the matching. And then we have. Yeah, we need to verify the pricing and the cost
62 00:11:14.869 ⇒ 00:11:29.580 Nicolas Sucari: and just use the top 20 skews by revenue, so that we can focus on 20. Try to work backwards on having the cost of everything, and then pushing that into to everyone in the company, and then we can continue with the other ones.
63 00:11:30.250 ⇒ 00:11:34.840 Payas Parab: Got it is this top 20 skews that’s also like, just focus on the Asia one. Right? It’s just.
64 00:11:35.650 ⇒ 00:11:36.640 Nicolas Sucari: Yeah, yeah.
65 00:11:37.210 ⇒ 00:11:38.220 Payas Parab: Got it. Okay.
66 00:11:40.080 ⇒ 00:11:54.429 Nicolas Sucari: The the 1st step here is to send that I’m I’m gonna send an email to Ian asking for that list so that we can get the latest orders or the the orders from the past 2 years from that from that initial list. And then we can start working towards that. Okay.
67 00:11:56.350 ⇒ 00:12:09.189 Nicolas Sucari: apart from that, we have the Kim request that, I tag you in this like channel. That, I think is already here daily. Kpi dashboard.
68 00:12:09.510 ⇒ 00:12:10.270 Nicolas Sucari: Yeah.
69 00:12:10.797 ⇒ 00:12:26.662 Nicolas Sucari: Here, what we need to do is we we were working on this document we need to explain her like, how we are calculating that profit and to explain what she was saying is that they don’t know exactly why.
70 00:12:27.280 ⇒ 00:12:55.019 Nicolas Sucari: when they’re the property is going down, or when they are having, like positive profit. And the the source of truth that they are looking at is the is our dashboard, our real dashboard. So what I told her in order to understand that profit value is that we were gonna explain all of those metrics. So the idea is to explain all of these costs that we are that we have, and the total sale value that we have. How? How that is calculated?
71 00:12:55.671 ⇒ 00:12:59.360 Nicolas Sucari: And so that Kim can tell us if
72 00:12:59.970 ⇒ 00:13:04.369 Nicolas Sucari: if if that values are okay, or if we need to change something on the definition
73 00:13:04.710 ⇒ 00:13:06.440 Nicolas Sucari: of those measures. Okay.
74 00:13:06.620 ⇒ 00:13:10.140 Payas Parab: Got it. And so here we yeah, we just want to be a little bit more detailed around the source.
75 00:13:10.140 ⇒ 00:13:10.490 Nicolas Sucari: Yeah.
76 00:13:10.520 ⇒ 00:13:12.220 Payas Parab: It’s embellish. Okay?
77 00:13:13.790 ⇒ 00:13:33.660 Nicolas Sucari: Yeah, exactly. Yeah. The idea is to give her details on what we are. Where are we getting the information from? For example, in the total revenues or total sales. We’re getting the data from Shopify Amazon. Which values are we get? Are we summing up to get that measure? And that kind of stuff right?
78 00:13:37.550 ⇒ 00:13:50.760 Nicolas Sucari: The same for all of the costs. And and yeah, we need to check also the spikes that we have in some of the costs, for example, that 40 K that we have in marketing costs on November 13.th
79 00:13:51.271 ⇒ 00:14:05.260 Nicolas Sucari: That’s something weird. And we we need to explain that, or try to look into more details of that value so that we can give her more information. And she can tell us if that’s correct, or is something wrong? Okay.
80 00:14:07.710 ⇒ 00:14:15.210 Nicolas Sucari: so that’s that’s what we have. Right now. I was just creating these tickets for the
81 00:14:16.210 ⇒ 00:14:41.340 Nicolas Sucari: for this queue stuff. I’m gonna keep. I’m gonna email, Ian, about that at least that he need us to provide with all the costs and the orders from the past 2 years, and we can keep working on on this, I think, from the weather analysis. That was great. What you shared by us, so I don’t know if we need anything else from, for now I don’t know if we don’t ask you about anything else to do with that.
82 00:14:42.000 ⇒ 00:14:57.420 Payas Parab: I think I think, for now we’re just gonna see what they respond to like. We have a target list, and we we may have to. If they approve that test, or they want to try that test, then we’ll have to go get the forward looking data stuff. But this is all the the historical analysis is done, so depending on how you want to denote that.
83 00:14:59.550 ⇒ 00:15:02.017 Nicolas Sucari: Okay, okay, perfect.
84 00:15:03.350 ⇒ 00:15:15.010 Nicolas Sucari: great. And then, I created the meeting on for Monday to for all the data team you, Sahana Luke me Roberts into Tom, so that we can start planning the week
85 00:15:15.448 ⇒ 00:15:37.129 Nicolas Sucari: on Mondays and trying to set us some goals for the week in order to achieve some tasks. The idea is to have that meeting every Monday so that we can plan the week and see what we are gonna try to accomplish for each client. I’m still working with Marianne on on setting up the notion. But everything should be created in these
86 00:15:37.280 ⇒ 00:16:05.850 Nicolas Sucari: in this kind of ports. Here is the the data homepage so if we create tasks here everything will will show up in in each client. I mean, we can create a new new page, and then we can add all of the properties needed. So feel free to add anything that you’re working on the idea to track. Yeah, the idea is to track almost everything. And once this gets going, what I’m trying to do also is to create the personal dashboards
87 00:16:05.870 ⇒ 00:16:19.140 Nicolas Sucari: for you guys so that you can access like one place and see exactly what are your task, independent of which clients are you working on. For example, you look you have here. I can change the name to look if you want.
88 00:16:22.383 ⇒ 00:16:43.359 Nicolas Sucari: But I but here you have, like all your your tasks that you’re tagged on obviously they’re all from pull parts, but if you have any other tasks from other clients, they will show up here by status, or you will have here the upcoming overview which ones are done you will have, like the overdue, the ones that have dates which which ones are priorities. This is kind of cool
89 00:16:44.460 ⇒ 00:16:57.250 Nicolas Sucari: that you can find everything. I’m I’m gonna ask Marianne to have the page created for Youtube. I asked, that you can access here and see everything. But if you go to the data one, we have here all of the
90 00:16:58.200 ⇒ 00:17:01.160 Nicolas Sucari: all, all of the tasks for the data team. Okay.
91 00:17:03.040 ⇒ 00:17:12.399 Nicolas Sucari: you’ll see. We have here some from Eden, and if we have, when we start with our helper we’ll have this task here, too. What else
92 00:17:12.910 ⇒ 00:17:14.660 Nicolas Sucari: should I go through?
93 00:17:15.768 ⇒ 00:17:32.800 Nicolas Sucari: No, yeah. And then maybe by us, when you have that analysis on the total profit ready. We can set up a meeting so that I can so that you can talk to Kim and also introduce you to Ben and Dan. And we need to start asking them if they are using
94 00:17:33.800 ⇒ 00:17:41.770 Nicolas Sucari: the dashboards and or or not. And we need to to try to get the the conversation going so that we
95 00:17:42.079 ⇒ 00:18:07.169 Nicolas Sucari: get more requirements from them. These skew stuff is a really big thing. So if we do this correctly, the 1st steps we will have like a lot to work on, so that will be great for us. But yeah, I mean, apart from that skew stuff. We’ll need to keep talking to Chuck, Kim, Ben and Dan asking always for new requirements. So getting you involved with them, it will be, it will be good. Okay.
96 00:18:07.340 ⇒ 00:18:07.920 Payas Parab: Got it.
97 00:18:10.230 ⇒ 00:18:13.190 Nicolas Sucari: Excellent! What else?
98 00:18:13.300 ⇒ 00:18:14.650 Nicolas Sucari: Anything else? Guys.
99 00:18:17.160 ⇒ 00:18:18.060 Luke Daque: Yeah, I think.
100 00:18:18.590 ⇒ 00:18:20.859 Luke Daque: Thank you. Let’s see, we have everything.
101 00:18:22.440 ⇒ 00:18:27.867 Nicolas Sucari: Cool. Okay, let me know if you need anything
102 00:18:28.930 ⇒ 00:18:38.559 Nicolas Sucari: project manager wise, or if you need some task created, or you’re not finding anything in notion guys. And I can work towards helping you on that. Okay.
103 00:18:39.070 ⇒ 00:18:39.410 Payas Parab: 3.
104 00:18:39.410 ⇒ 00:18:40.156 Luke Daque: Sounds good.
105 00:18:40.530 ⇒ 00:18:41.280 Payas Parab: Sounds good.
106 00:18:42.010 ⇒ 00:18:42.760 Nicolas Sucari: You guys.
107 00:18:43.310 ⇒ 00:18:46.310 Luke Daque: Bye, bye, thanks, everyone, bye, bye.