Meeting Title: PoolParts-Client-Meeting-Prep Date: 2024-08-28 Meeting participants: Suraj, Nicolas Sucari, Uttam Kumaran
WEBVTT
1 00:01:11.470 ⇒ 00:01:12.640 Uttam Kumaran: Hey? How’s it going.
2 00:01:13.320 ⇒ 00:01:14.310 suraj: Hey! Tim!
3 00:01:15.350 ⇒ 00:01:16.210 Uttam Kumaran: How’s everything?
4 00:01:17.550 ⇒ 00:01:19.316 suraj: Good. Yeah.
5 00:01:20.200 ⇒ 00:01:22.849 Uttam Kumaran: I look like you now we’re we’re matching today.
6 00:01:24.560 ⇒ 00:01:29.359 suraj: Yeah, I I love wearing black T-shirts. It matches with everything. Right? So don’t worry
7 00:01:30.530 ⇒ 00:01:31.190 suraj: with it.
8 00:01:31.190 ⇒ 00:01:39.720 Uttam Kumaran: Yeah, today I had like a sales call, and I don’t know now that I work from home like some for some calls. It’s very serious. I dress. I have like a.
9 00:01:40.000 ⇒ 00:01:40.639 suraj: Oh, yeah.
10 00:01:40.640 ⇒ 00:01:50.819 Uttam Kumaran: Thing, but some calls, especially you work with like tech people. It’s kind of like lax, and you’ll see, even like even all of our clients, like, for the most part, are very relaxed
11 00:01:51.400 ⇒ 00:01:56.060 Uttam Kumaran: and like our company internally, like, I, I don’t care. I don’t like care at anything at all.
12 00:01:57.360 ⇒ 00:02:01.040 Uttam Kumaran: Yeah, you’re right. It’s as a guy it’s like, just throw a T-shirt on, or whatever.
13 00:02:01.040 ⇒ 00:02:02.340 suraj: Exactly
14 00:02:02.420 ⇒ 00:02:03.355 suraj: exactly
15 00:02:05.744 ⇒ 00:02:09.159 suraj: you live in Texas. Right? You say.
16 00:02:09.160 ⇒ 00:02:09.650 Uttam Kumaran: Yes.
17 00:02:09.650 ⇒ 00:02:12.049 suraj: Austin. Austin. Texas. Okay. Okay.
18 00:02:12.580 ⇒ 00:02:14.390 Uttam Kumaran: Have you visited here before.
19 00:02:14.800 ⇒ 00:02:16.929 suraj: Yeah, yeah. Actually, I think.
20 00:02:17.946 ⇒ 00:02:30.039 suraj: last year I visited one of my relatives we came to Houston and then drove to Austin to meet them. So that’s the only that’s the only time I visited Austin, Texas. Yeah.
21 00:02:30.040 ⇒ 00:02:30.870 Uttam Kumaran: Nice. Okay.
22 00:02:31.650 ⇒ 00:02:32.390 suraj: Yeah.
23 00:02:35.680 ⇒ 00:02:39.090 suraj: I I was reviewing like these 3
24 00:02:39.160 ⇒ 00:02:49.210 suraj: task Nicholas put on the notions, for I think it’s for me, of course. So yeah, I’m just reviewing this tables and the flow.
25 00:02:49.680 ⇒ 00:02:50.870 suraj: All the things.
26 00:02:52.880 ⇒ 00:03:00.160 Uttam Kumaran: Yeah, I think, Nico said. He’s about to join, but maybe we can just walk through those 3. I haven’t looked at it yet. Today.
27 00:03:00.570 ⇒ 00:03:02.063 suraj: Yeah, sure.
28 00:03:06.080 ⇒ 00:03:08.410 suraj: Let me share my screen.
29 00:03:28.730 ⇒ 00:03:35.590 suraj: He added review metrics for ken improved data. Kpi dash whisper, to add more dimensions.
30 00:03:35.610 ⇒ 00:03:39.791 suraj: and to create a brand new report for data where?
31 00:03:40.220 ⇒ 00:03:42.689 suraj: warehouse comparison dashboards?
32 00:03:43.499 ⇒ 00:03:47.755 suraj: So I think this, this is the most important one and
33 00:03:48.180 ⇒ 00:03:50.673 suraj: So this one is about like adding,
34 00:04:05.460 ⇒ 00:04:12.800 suraj: think Ryan is looking into this? Why, the data is revenue is not flowing into these platforms.
35 00:04:13.230 ⇒ 00:04:14.780 suraj: Okay? Nicholas?
36 00:04:14.980 ⇒ 00:04:15.610 suraj: Yes.
37 00:04:15.610 ⇒ 00:04:16.969 Nicolas Sucari: Hey, guys, how are you.
38 00:04:17.790 ⇒ 00:04:18.940 suraj: Good! How are you?
39 00:04:19.769 ⇒ 00:04:20.629 Nicolas Sucari: All good.
40 00:04:21.459 ⇒ 00:04:23.034 suraj: I was just showing what
41 00:04:23.359 ⇒ 00:04:26.139 suraj: the the task, you added. In the notion.
42 00:04:27.080 ⇒ 00:04:28.010 Nicolas Sucari: Yeah, okay.
43 00:04:28.500 ⇒ 00:04:29.250 Nicolas Sucari: perfect.
44 00:04:29.250 ⇒ 00:04:29.930 suraj: Yep.
45 00:04:30.120 ⇒ 00:04:30.895 suraj: yeah,
46 00:04:32.310 ⇒ 00:04:39.139 suraj: so did you had any update on this? Nicholas from ran on on metrics for King.
47 00:04:39.890 ⇒ 00:04:43.189 Nicolas Sucari: No, not yet. I think Ryan was working on the
48 00:04:44.428 ⇒ 00:04:49.029 Nicolas Sucari: alerting stuff so I don’t know if he’s been able to check
49 00:04:49.220 ⇒ 00:04:50.809 Nicolas Sucari: all of these metrics.
50 00:04:52.590 ⇒ 00:04:53.160 suraj: Okay.
51 00:04:53.160 ⇒ 00:04:57.609 Nicolas Sucari: But yeah, I’m gonna I’m gonna check with him tomorrow, so that we
52 00:04:57.790 ⇒ 00:05:04.140 Nicolas Sucari: understand if he’s gonna be able to look into that one, or if we need to go and review everything ourselves, rush.
53 00:05:04.960 ⇒ 00:05:05.740 suraj: Okay?
54 00:05:06.980 ⇒ 00:05:09.388 suraj: And then I was
55 00:05:11.750 ⇒ 00:05:17.759 suraj: reviewing, adding, the more dimensions to this dashboard. This is existing dashboards
56 00:05:17.860 ⇒ 00:05:21.770 suraj: as a sealed. There are only one dimension as of now.
57 00:05:24.960 ⇒ 00:05:34.029 suraj: so like. I have few questions on this like I was reviewing. I I see the the source is this daily Kpi aggregate.
58 00:05:34.440 ⇒ 00:05:34.850 Uttam Kumaran: Yeah.
59 00:05:35.191 ⇒ 00:05:43.740 suraj: Not sure what what is loading into this. So, as I see, only there is only date is the only 1 9 dimensions.
60 00:05:43.930 ⇒ 00:05:49.140 suraj: And I see what they want to add. It looks interesting.
61 00:05:53.160 ⇒ 00:05:53.960 suraj: Yeah, this is.
62 00:05:53.960 ⇒ 00:05:54.740 Nicolas Sucari: Jeff, like.
63 00:05:54.740 ⇒ 00:05:55.250 suraj: That makes.
64 00:05:55.250 ⇒ 00:05:56.789 Nicolas Sucari: Yeah, this is the task.
65 00:05:56.970 ⇒ 00:06:03.360 Nicolas Sucari: This is a test that I created using the file that we have. And using Claude
66 00:06:03.775 ⇒ 00:06:14.150 Nicolas Sucari: that was looking into the file, that is, into that table, right? So, having that table, I I asked the AI to give us a couple of dimensions that
67 00:06:14.901 ⇒ 00:06:17.430 Nicolas Sucari: Would be useful to have there.
68 00:06:20.260 ⇒ 00:06:22.900 Uttam Kumaran: Is this something that they asked for like, how do we
69 00:06:23.290 ⇒ 00:06:24.240 Uttam Kumaran: like? What is it? What.
70 00:06:24.240 ⇒ 00:06:24.580 Nicolas Sucari: Yeah.
71 00:06:24.580 ⇒ 00:06:25.859 Uttam Kumaran: Half or show currently.
72 00:06:26.980 ⇒ 00:06:29.520 Nicolas Sucari: Go. Do! Do you want to go to real or.
73 00:06:30.760 ⇒ 00:06:32.309 suraj: It’s already here. Yeah.
74 00:06:32.310 ⇒ 00:06:34.850 Uttam Kumaran: Oh, okay. So it just has day right now.
75 00:06:35.440 ⇒ 00:06:37.300 suraj: Yeah, did? We have only.
76 00:06:41.790 ⇒ 00:06:48.300 Nicolas Sucari: Yeah. Yeah. But the dimension on the right there, that that small table that’s the only thing that we have. But what’s
77 00:06:48.330 ⇒ 00:06:55.699 Nicolas Sucari: what he. What she was asking was, yeah, to try to have like more dimensions there as we have for the other dashboards.
78 00:06:56.590 ⇒ 00:07:01.390 Nicolas Sucari: I don’t know if if that is something we can do. But I
79 00:07:01.650 ⇒ 00:07:04.270 Nicolas Sucari: I told her we were, gonna look into it. I think.
80 00:07:04.270 ⇒ 00:07:05.030 Uttam Kumaran: Pandemic.
81 00:07:05.030 ⇒ 00:07:12.710 Nicolas Sucari: We have all. Yeah, and I think we we should be able to add some something in there, right.
82 00:07:13.480 ⇒ 00:07:16.479 Uttam Kumaran: Yeah, that makes sense. So let’s walk through like
83 00:07:16.650 ⇒ 00:07:29.680 Uttam Kumaran: like the flow for a task like this. So one is, our goal is to add dimensions in real. So I think, Siraj, you are looking mainly at what dimensions we currently have available. So if you go back
84 00:07:29.830 ⇒ 00:07:31.130 Uttam Kumaran: to Snowflake
85 00:07:33.430 ⇒ 00:07:39.590 Uttam Kumaran: or even if you yeah. So currently yours, it’s pulling from this at the moment. It looks like we only have
86 00:07:39.680 ⇒ 00:07:44.070 Uttam Kumaran: date dimensions here, the way to actually come and see
87 00:07:44.520 ⇒ 00:07:48.390 Uttam Kumaran: like where this table is coming from is. If you go into github
88 00:07:48.817 ⇒ 00:07:51.969 Uttam Kumaran: I’ll show you like where you can go. See the actual sequel logic for this table.
89 00:07:53.100 ⇒ 00:07:59.839 Uttam Kumaran: So if you go into Dbt project and you should see daily, Kpi Ag is right there under Kpi.
90 00:08:00.780 ⇒ 00:08:01.510 suraj: Yes.
91 00:08:02.110 ⇒ 00:08:04.539 Uttam Kumaran: So this is the sequel that we’re doing for
92 00:08:05.290 ⇒ 00:08:06.690 Uttam Kumaran: this table right now.
93 00:08:08.010 ⇒ 00:08:10.940 suraj: Yeah, yeah, I was already looking into this.
94 00:08:10.940 ⇒ 00:08:11.569 Uttam Kumaran: Oh, okay. Cool.
95 00:08:11.887 ⇒ 00:08:14.430 suraj: Before before the just before the meeting. So
96 00:08:14.730 ⇒ 00:08:15.770 suraj: okay.
97 00:08:16.290 ⇒ 00:08:18.090 suraj: so we all we have is.
98 00:08:18.090 ⇒ 00:08:20.140 Uttam Kumaran: Here is like, Yeah, how do we add?
99 00:08:22.890 ⇒ 00:08:27.280 Uttam Kumaran: how do we add? Like, where the order the selling platform is coming from?
100 00:08:29.990 ⇒ 00:08:30.390 Nicolas Sucari: Jigs.
101 00:08:30.390 ⇒ 00:08:34.039 Uttam Kumaran: I think, yeah, I think the fulfillment channel
102 00:08:34.250 ⇒ 00:08:35.750 Uttam Kumaran: and the product class.
103 00:08:39.650 ⇒ 00:08:44.519 Uttam Kumaran: So it’s mainly like, I think this is actually a good task, because it’ll kind of allow you to look at
104 00:08:44.680 ⇒ 00:08:47.650 Uttam Kumaran: where each of these are coming from. So, for example.
105 00:08:48.520 ⇒ 00:08:51.740 Uttam Kumaran: selling platform, if you scroll, it’s coming.
106 00:08:51.880 ⇒ 00:09:00.089 Uttam Kumaran: Basically the the way this table is structured is a join between multiple different sources. So we have an order source. We have marketing source, and we have.
107 00:09:00.090 ⇒ 00:09:02.809 suraj: Marketing. So shipment refunds.
108 00:09:02.810 ⇒ 00:09:11.510 Uttam Kumaran: It’s all coming from these ctes, right? So if you look at order, Kpis, if you scroll to the top of this file, you’ll see the order, Kpis
109 00:09:13.710 ⇒ 00:09:14.930 Uttam Kumaran: cte.
110 00:09:15.500 ⇒ 00:09:19.290 Uttam Kumaran: and you can see from the table all orders were only.
111 00:09:19.290 ⇒ 00:09:19.800 suraj: Yeah.
112 00:09:19.800 ⇒ 00:09:20.520 Uttam Kumaran: And
113 00:09:21.310 ⇒ 00:09:23.040 Uttam Kumaran: a couple of dimensions.
114 00:09:23.760 ⇒ 00:09:26.690 suraj: They are true just to by day. I will say
115 00:09:27.120 ⇒ 00:09:30.680 suraj: so. All orders. We will have this in the mark.
116 00:09:31.170 ⇒ 00:09:33.552 Uttam Kumaran: Yeah. So if you go to
117 00:09:34.300 ⇒ 00:09:38.139 Uttam Kumaran: it’s gonna be here. If you go into reporting
118 00:09:40.240 ⇒ 00:09:41.040 Uttam Kumaran: issues, your.
119 00:09:42.440 ⇒ 00:09:44.349 suraj: Oh, yes, yes, it’s here.
120 00:09:44.350 ⇒ 00:09:52.530 Uttam Kumaran: And so these are all this is a pretty large table, but if you scroll to the bottom you’ll see it, or if you go into Snowflake. You’ll see the contents of this table.
121 00:09:56.030 ⇒ 00:09:57.730 Nicolas Sucari: Yeah, I think the easiest.
122 00:09:57.770 ⇒ 00:10:01.249 Nicolas Sucari: the easiest way of checking what this table has is
123 00:10:01.310 ⇒ 00:10:03.389 Nicolas Sucari: just querying in Snowflake.
124 00:10:03.490 ⇒ 00:10:06.760 Nicolas Sucari: You’ll see like a preview of the data. And
125 00:10:07.040 ⇒ 00:10:10.029 Nicolas Sucari: that way you can figure out like what we can use.
126 00:10:10.270 ⇒ 00:10:10.849 Nicolas Sucari: I think.
127 00:10:10.850 ⇒ 00:10:11.770 suraj: Exactly
128 00:10:14.160 ⇒ 00:10:14.825 suraj: his
129 00:10:32.550 ⇒ 00:10:33.490 Nicolas Sucari: Yep.
130 00:10:39.860 ⇒ 00:10:46.440 Nicolas Sucari: But yeah, I mean, I don’t know how to do this autumn, but I think it is like, if in the aggregate table we already have.
131 00:10:46.540 ⇒ 00:10:54.859 Nicolas Sucari: like like sources like from from different tables, I think we should be able to have, like
132 00:10:54.920 ⇒ 00:10:58.879 Nicolas Sucari: some kind of dimensions from board on one table, right.
133 00:10:59.400 ⇒ 00:11:12.259 Uttam Kumaran: Yeah, it should be fairly easy for you to. For example, if you want to bring this column in, I think the decision we need to make Nico is is this is something that sirage can handle and push the Pr. Or, if we want to just have this get tossed over to.
134 00:11:12.260 ⇒ 00:11:12.850 Nicolas Sucari: I mean.
135 00:11:13.470 ⇒ 00:11:20.859 Nicolas Sucari: Yeah, I mean the the task. The task is there for Ryan. But as he was working on other stuff
136 00:11:20.870 ⇒ 00:11:28.210 Nicolas Sucari: yesterday and today, I don’t know. If you. If you feel okay and try to do this, I I will leave this to you.
137 00:11:28.250 ⇒ 00:11:30.730 Nicolas Sucari: It’s it’s as it’s as you wish. I mean.
138 00:11:31.687 ⇒ 00:11:49.439 Nicolas Sucari: everything that we were having with Kim tomorrow is gonna be cancelled. And she didn’t answer to me. I’m gonna ask again about if we can move that to Friday, or we will just keep it and have the next week one. So I think we can have like some time to work on this one.
139 00:11:49.440 ⇒ 00:12:08.060 Uttam Kumaran: Yeah, I mean. So here’s here’s like the breakdown of the task for this one, for example, like, let’s walk through the example of you want to add selling platform to Daily Kpi, right? So you notice that it’s currently not in the Daily Kpi table, but it’s here, here in all orders. So the way this task works is one. We need to add it to the Dbt
140 00:12:08.427 ⇒ 00:12:11.280 Uttam Kumaran: we need to add it to the Dbt table.
141 00:12:11.300 ⇒ 00:12:27.000 Uttam Kumaran: so Pr needs to get made in Github, where we add that column in it runs and then emerges. The second thing that happens is in real. Now your source will have that column. Then you need to add that dimension into the real email. So that’s the breakup of tasks here.
142 00:12:27.000 ⇒ 00:12:27.790 suraj: Yeah.
143 00:12:28.494 ⇒ 00:12:33.039 Uttam Kumaran: Though the thing I would say is, I think this is a pretty easy
144 00:12:33.080 ⇒ 00:12:35.310 Uttam Kumaran: thing for Ryan to do
145 00:12:35.829 ⇒ 00:12:43.900 Uttam Kumaran: but, however and there is, there will be a little bit of learning curve if you want to try and do the dbt. Thing, so I’ll leave it to you.
146 00:12:45.400 ⇒ 00:13:09.920 suraj: Yeah, so this is currently a a low priority. Also. Right? So I, what I will do is I will explore this like entire thing and start adding, like as we see here. I think we have. So do you want to? Do you want me to look into all these all these dimensions, or only selling platform, or like whatever coming from all orders. Table for now.
147 00:13:09.920 ⇒ 00:13:12.860 Uttam Kumaran: Yeah, I think I think my ask would be
148 00:13:13.030 ⇒ 00:13:34.629 Uttam Kumaran: break down exactly what what you need from Ryan to do. For example, if it’s like, pull this from this table, pull this from this table. If you give that to him, he’ll get it done in like half an hour right? And I think the what happens is once he adds that he’ll let you know. Hey, this is done. It’s now available in the Daily Kpi table, and then you can go, take it and move it to real.
149 00:13:35.430 ⇒ 00:13:36.140 Uttam Kumaran: Okay?
150 00:13:36.980 ⇒ 00:13:37.820 suraj: Sure.
151 00:13:39.011 ⇒ 00:13:43.229 Nicolas Sucari: From all of these ones like I I just like tried to
152 00:13:43.390 ⇒ 00:13:55.220 Nicolas Sucari: to add a bunch of them, so so to to see if all of these ones were useful. But just try to understand which ones will be like, more useful to have, and which ones don’t or don’t make sense and just remove them. Okay.
153 00:13:55.780 ⇒ 00:13:59.299 suraj: Okay, yeah, I’ll I’ll I’ll look into deep into this. Yeah, understand?
154 00:13:59.300 ⇒ 00:14:03.250 Uttam Kumaran: Yeah, like, like, for example, on customer segment, I don’t think we have
155 00:14:03.450 ⇒ 00:14:03.989 Uttam Kumaran: at the moment.
156 00:14:03.990 ⇒ 00:14:04.750 Nicolas Sucari: Yeah, exactly.
157 00:14:04.750 ⇒ 00:14:20.070 Uttam Kumaran: Anything around segment. So that’ll be something that maybe we kick it down the road. But this is a good task. Again, I think this involves updates to rail. It involves, like a key table that we have, which is the Daily Kpi, which is all their core company Kpis.
158 00:14:20.200 ⇒ 00:14:36.190 Uttam Kumaran: And then it involves also adding some new columns. So I think if you’re able to, if you’re able to make this concrete into like, okay, cool, we. These are the 5 columns you want. I need Ryan to bring in this column from here this column here. He’ll go ahead and do that.
159 00:14:36.510 ⇒ 00:14:37.060 suraj: Okay.
160 00:14:37.060 ⇒ 00:14:38.159 Uttam Kumaran: So that seems great.
161 00:14:38.580 ⇒ 00:14:39.869 suraj: Okay, got it
162 00:14:39.950 ⇒ 00:14:41.150 suraj: vanishing
163 00:14:41.260 ⇒ 00:14:42.080 suraj: and.
164 00:14:42.080 ⇒ 00:14:46.320 Nicolas Sucari: I’m just gonna ask if he hasn’t started working on this one.
165 00:14:49.740 ⇒ 00:14:50.440 suraj: Okay?
166 00:14:53.150 ⇒ 00:15:02.170 suraj: And the next one, the 3rd one is a brand new dashboard. This also look interesting to me. The videos, comparison dashboard. So.
167 00:15:03.030 ⇒ 00:15:04.140 suraj: yeah, so this is.
168 00:15:04.140 ⇒ 00:15:06.649 Uttam Kumaran: I think this one, you should have all the data
169 00:15:06.770 ⇒ 00:15:08.660 Uttam Kumaran: for the most part available already.
170 00:15:09.090 ⇒ 00:15:10.954 suraj: Yeah, true. Right? Yeah.
171 00:15:11.580 ⇒ 00:15:14.410 suraj: I think. But this will. This will be a all
172 00:15:14.420 ⇒ 00:15:18.306 suraj: new type of visualizations for them. Right? I think map view, and
173 00:15:18.780 ⇒ 00:15:22.500 suraj: having a heat map for these performances.
174 00:15:24.000 ⇒ 00:15:27.181 Uttam Kumaran: Yeah. So the I think that the thing is here.
175 00:15:28.200 ⇒ 00:15:32.400 Uttam Kumaran: real will only be able to handle a certain amount of these.
176 00:15:35.110 ⇒ 00:15:43.319 Uttam Kumaran: so we’ll need to decide like how we handle the other visualizations. But I guess, like, let’s start with the the actual like, ask here, you kind of get
177 00:15:43.540 ⇒ 00:15:45.899 Uttam Kumaran: what they’re trying to do here overall, right.
178 00:15:46.470 ⇒ 00:15:48.790 suraj: Yeah, yeah, yeah, I understand that.
179 00:15:49.220 ⇒ 00:15:50.600 Uttam Kumaran: So basically, they have
180 00:15:50.770 ⇒ 00:15:53.519 Uttam Kumaran: multiple warehouses they ship from.
181 00:15:53.650 ⇒ 00:16:00.089 Uttam Kumaran: And we want to help them understand, like basically, how much it costs to ship from any of the warehouses. How much volume.
182 00:16:00.260 ⇒ 00:16:07.030 Uttam Kumaran: how many packages, what products are shipping from each warehouse? Did you have a chance to look at the shipments table.
183 00:16:07.260 ⇒ 00:16:08.730 suraj: No, not yet.
184 00:16:09.030 ⇒ 00:16:11.550 Uttam Kumaran: Okay, so I would recommend looking at that.
185 00:16:12.140 ⇒ 00:16:12.930 suraj: Okay.
186 00:16:13.440 ⇒ 00:16:17.979 Uttam Kumaran: That’s going to give you all the information about every shipment that’s coming out from the client.
187 00:16:19.560 ⇒ 00:16:23.578 suraj: Got it so here, whereas performance in in means like
188 00:16:24.060 ⇒ 00:16:32.370 suraj: shipping from warehouse to various like customer addresses. And what is the cost of, based on the cost it distribute. They decide the performance right.
189 00:16:32.760 ⇒ 00:16:33.910 Uttam Kumaran: Yeah, exactly.
190 00:16:33.910 ⇒ 00:16:34.570 Nicolas Sucari: Yeah.
191 00:16:34.570 ⇒ 00:16:35.370 suraj: Okay.
192 00:16:35.910 ⇒ 00:16:43.729 suraj: how efficiently they are doing. Basically, the deliveries, like, for example, Texas, to nearby States, and like all other warehouses.
193 00:16:44.250 ⇒ 00:16:54.160 Uttam Kumaran: So in the warehouse dimensions you’re going to see the few warehouses that they have, and then in shipments you’ll see every shipment associated with an order associated with the warehouse.
194 00:16:54.620 ⇒ 00:16:56.470 Uttam Kumaran: So you should. It should.
195 00:16:56.620 ⇒ 00:17:03.470 Uttam Kumaran: Basically. The biggest things that you’ll start to see now is that you can. You can group. You can join shipments to all orders.
196 00:17:03.880 ⇒ 00:17:08.249 Uttam Kumaran: There’s a link there. There’s all orders. You can join the customers. And then, of course.
197 00:17:08.300 ⇒ 00:17:20.999 Uttam Kumaran: the shipments linked to a warehouse. So the biggest thing they want, they want to know is like, and I also want to know is like, Are we saving them money on? Are they saving money on shipments, now that they have
198 00:17:21.060 ⇒ 00:17:27.159 Uttam Kumaran: these multiple warehouses. So if you go into real and you go into shipments. Now.
199 00:17:27.710 ⇒ 00:17:30.000 Uttam Kumaran: there’s a shipments dashboard that you should see.
200 00:17:31.160 ⇒ 00:17:35.619 Uttam Kumaran: So this is the current shipments dashboard. So you’re seeing how much they’re spending on shipments.
201 00:17:35.660 ⇒ 00:17:39.180 Uttam Kumaran: all the shipments they’re shipping out where it’s coming from
202 00:17:39.380 ⇒ 00:17:42.500 Uttam Kumaran: right. And so the all this logic is in the shipments table.
203 00:17:43.010 ⇒ 00:17:48.590 Uttam Kumaran: and this I you know, you should get very, very comfortable with, is on the shipment side, and the all order side.
204 00:17:55.500 ⇒ 00:17:59.079 Nicolas Sucari: We don’t have. We don’t have like any order yet from
205 00:17:59.390 ⇒ 00:18:02.889 Nicolas Sucari: total shipping amount from California. I think we had right.
206 00:18:05.856 ⇒ 00:18:07.290 Uttam Kumaran: Yeah, we
207 00:18:08.760 ⇒ 00:18:10.260 Uttam Kumaran: we should
208 00:18:13.390 ⇒ 00:18:15.660 Uttam Kumaran: But again, see, these are these are things where, like
209 00:18:15.890 ⇒ 00:18:21.159 Uttam Kumaran: again, Nico, like half, we have to get all the questions in a place and work with Ryan like, I’m not very familiar with.
210 00:18:21.160 ⇒ 00:18:23.009 Nicolas Sucari: Yeah, yeah, exactly.
211 00:18:23.010 ⇒ 00:18:25.399 Uttam Kumaran: These are things that, like again, I will.
212 00:18:25.640 ⇒ 00:18:29.969 Uttam Kumaran: If we’re noticing these issues, then the client is definitely not getting the right data.
213 00:18:30.070 ⇒ 00:18:31.160 Uttam Kumaran: So
214 00:18:31.280 ⇒ 00:18:36.289 Uttam Kumaran: one of the goals here is that we’re ahead of them in terms of like, how these dashboards work
215 00:18:36.390 ⇒ 00:18:37.410 Uttam Kumaran: and
216 00:18:37.520 ⇒ 00:18:48.140 Uttam Kumaran: the data that’s flowing in, and whether it’s accurate or not. So you’re totally right. We’re only seeing Jacksonville, which is Florida, and we’re seeing yapping, which is New York the moment they have 4 active warehouses.
217 00:18:48.170 ⇒ 00:18:50.930 Uttam Kumaran: So the initial question is like, Yeah, where is the
218 00:18:50.960 ⇒ 00:18:52.720 Uttam Kumaran: where is the data from
219 00:18:52.950 ⇒ 00:18:59.419 Uttam Kumaran: California and Texas right now? But that’s a question. Again, between you 2 and Ryan, we should have the answer.
220 00:18:59.420 ⇒ 00:19:00.580 Nicolas Sucari: Yeah.
221 00:19:02.600 ⇒ 00:19:13.970 Nicolas Sucari: yeah, of course I was not I. I haven’t been checking this dashboard. I just yeah. So that like real quick now. But yeah, we will need to understand how that
222 00:19:14.565 ⇒ 00:19:24.440 Nicolas Sucari: how the how the data is coming from here. And yeah, and the data is accurate. That’s why, like I was thinking about having like that
223 00:19:24.520 ⇒ 00:19:36.909 Nicolas Sucari: dashboard, with like the comparison of the different warehouses. So that should be like super clear, you know, in in some place not like loose around the shipments. Table.
224 00:19:37.690 ⇒ 00:19:38.180 Uttam Kumaran: Yeah.
225 00:19:38.517 ⇒ 00:19:42.230 Nicolas Sucari: That. That’s why I thought like that dashboard should be useful.
226 00:19:42.810 ⇒ 00:19:44.190 Uttam Kumaran: That’s fair. I’m actually so.
227 00:19:44.190 ⇒ 00:19:45.490 Nicolas Sucari: That far. Yeah.
228 00:19:45.910 ⇒ 00:19:51.729 Uttam Kumaran: So I think you I think we have all the I mean again. I think, Siraj, the main question is for you. If you have all the information you need.
229 00:19:52.450 ⇒ 00:19:54.240 Uttam Kumaran: or what other questions you have.
230 00:19:55.481 ⇒ 00:20:02.809 suraj: I think I I got more clarification now like about the role and things. So yeah, I I will dig deep into that 2 tasks.
231 00:20:03.010 ⇒ 00:20:04.250 suraj: I’ll I’ll
232 00:20:04.600 ⇒ 00:20:06.730 suraj: start with it. Start with that.
233 00:20:07.450 ⇒ 00:20:12.349 Uttam Kumaran: Okay? And then, I think on the warehouse task, I think. Don’t worry about the
234 00:20:12.390 ⇒ 00:20:18.609 Uttam Kumaran: visualizations, for now the main thing is that we have a clear dashboard where we can compare
235 00:20:18.700 ⇒ 00:20:20.070 Uttam Kumaran: the warehouses.
236 00:20:20.080 ⇒ 00:20:22.140 Uttam Kumaran: Right? That’s the primary goal.
237 00:20:22.250 ⇒ 00:20:23.900 Uttam Kumaran: So like.
238 00:20:23.980 ⇒ 00:20:26.059 Uttam Kumaran: I’m just gonna move. Let’s just
239 00:20:26.110 ⇒ 00:20:29.019 Uttam Kumaran: consider this like off the table. For now the
240 00:20:29.360 ⇒ 00:20:33.290 Uttam Kumaran: any sort of custom biz, because you’re not, it’s gonna be difficult to do in real
241 00:20:33.730 ⇒ 00:20:37.800 Uttam Kumaran: this is something that we’ll have to think about how we do it otherwise.
242 00:20:38.385 ⇒ 00:20:41.339 Uttam Kumaran: But I I want to focus on getting a dashboard
243 00:20:41.710 ⇒ 00:20:46.310 Uttam Kumaran: with the accurate information about the warehouses in real as soon as possible.
244 00:20:47.250 ⇒ 00:20:47.990 suraj: Okay.
245 00:20:50.789 ⇒ 00:20:59.440 Uttam Kumaran: Okay, yeah. I mean again, the the big thing is like, I’ll just be looking for questions from you. But again, between you and Ryan Ryan has all the information about
246 00:20:59.910 ⇒ 00:21:03.019 Uttam Kumaran: what, how the tables are structured where data is coming in.
247 00:21:03.110 ⇒ 00:21:06.460 Uttam Kumaran: So I kind of want to see some interaction between you guys.
248 00:21:07.728 ⇒ 00:21:09.620 Uttam Kumaran: kind of see some progress
249 00:21:09.760 ⇒ 00:21:11.360 Uttam Kumaran: on this stuff. Yeah.
250 00:21:12.757 ⇒ 00:21:19.292 Nicolas Sucari: So, Raj, if if you want, I mean, I can schedule a meeting with Ryan every day, just to catch up between.
251 00:21:20.041 ⇒ 00:21:44.829 Nicolas Sucari: are 3 of us. And yeah, discuss any issue, any questions that we have in that meeting. If you don’t wanna obviously know what. Don’t wait until the meeting. But you can go through slack always. But if you want, and you think it’s be, it’s gonna be useful for this yeah, for these days that you’re starting to work on these tables, on, on rail, and if you would like to have like a meeting
252 00:21:45.134 ⇒ 00:22:03.249 Nicolas Sucari: like an hour meeting, just to catch up, try to see, like, what are you are doing? Try to explain. Try to ask any question. If you have about the models we we can do that. I mean, I’m available as as I text you, as I chat with you every day, like, if you have any questions, ask me, I’m gonna try to help you.
253 00:22:03.840 ⇒ 00:22:08.610 suraj: Okay, sure. Sure. Nicholas, I think. Meeting with Ryan
254 00:22:08.740 ⇒ 00:22:12.519 suraj: every day at least 30 min. No, I think it will be helpful.
255 00:22:12.650 ⇒ 00:22:13.060 suraj: And
256 00:22:13.470 ⇒ 00:22:14.560 Nicolas Sucari: Okay. Yeah.
257 00:22:15.110 ⇒ 00:22:16.290 suraj: Yeah, sure.
258 00:22:16.850 ⇒ 00:22:19.490 Uttam Kumaran: And Ryan sometime?
259 00:22:19.680 ⇒ 00:22:31.019 Uttam Kumaran: Yeah. And so I would just rely on him for any model changes. And then any questions about like, Hey, how does this data go or like? This doesn’t look accurate. I would go to him first.st You’ll have all the contacts.
260 00:22:34.300 ⇒ 00:22:36.420 Uttam Kumaran: and then I again, ideally, I think.
261 00:22:36.430 ⇒ 00:22:40.090 Uttam Kumaran: as soon as we can. I wanna make sure that you can go through the process of
262 00:22:40.170 ⇒ 00:22:42.290 Uttam Kumaran: pushing some changes to rail.
263 00:22:42.340 ⇒ 00:22:45.309 Uttam Kumaran: getting a Pr created and then making it there.
264 00:22:45.330 ⇒ 00:22:52.510 Uttam Kumaran: So that’s the probably the last thing before I think you’ll have enough context to get started. There’s only a couple of key models
265 00:22:52.530 ⇒ 00:23:06.460 Uttam Kumaran: at the reporting layer for pool parts. There’s shipments, there’s orders. There’s order items, right, all things that you’re probably used to. So I think once you get a hang of like which tables are the core. It’ll start to just run.
266 00:23:06.460 ⇒ 00:23:10.160 suraj: Yeah, exactly. Exactly. I think, yeah.
267 00:23:12.050 ⇒ 00:23:20.600 suraj: yeah. Now, I got the proper understanding. So I think, you can set up a meeting Nicholas anytime. Tomorrow is fine.
268 00:23:20.600 ⇒ 00:23:21.220 Nicolas Sucari: Okay.
269 00:23:21.220 ⇒ 00:23:25.420 suraj: With the with Ryan, so that we can discuss this. Starting with this.
270 00:23:26.870 ⇒ 00:23:27.980 Nicolas Sucari: Perfect. Yep.
271 00:23:28.390 ⇒ 00:23:28.930 suraj: Starting.
272 00:23:28.930 ⇒ 00:23:35.950 Nicolas Sucari: Okay. I’ll set up sometime. Yes, 30 min, maybe tomorrow, and then we’ll see on Friday, if you need something to. I will schedule.
273 00:23:37.120 ⇒ 00:23:37.730 suraj: Yeah.
274 00:23:38.130 ⇒ 00:23:47.479 suraj: I think I’ll start with pushing these dimensions into real. I think that will be kind of a 1st thing. Once once, we add this into that
275 00:23:47.860 ⇒ 00:23:49.070 suraj: table itself.
276 00:23:49.440 ⇒ 00:23:50.600 suraj: Yeah.
277 00:23:50.890 ⇒ 00:23:54.499 Uttam Kumaran: Yeah. And then until then, I think I think you should have all the information
278 00:23:54.590 ⇒ 00:23:57.989 Uttam Kumaran: already in the tables for the
279 00:23:58.730 ⇒ 00:23:59.910 Uttam Kumaran: warehouse task.
280 00:24:01.148 ⇒ 00:24:04.760 Uttam Kumaran: And within real, you can do expressions and things like that.
281 00:24:04.760 ⇒ 00:24:07.840 suraj: Yeah, yeah, I. I was also looking at that.
282 00:24:08.290 ⇒ 00:24:12.060 suraj: All these expressions like advancement. So.
283 00:24:12.060 ⇒ 00:24:17.020 Uttam Kumaran: Yeah. And you, you’re you’re not able to run it locally. And it and everything is like kind of working right.
284 00:24:18.160 ⇒ 00:24:19.820 suraj: Yeah, everything is working.
285 00:24:20.090 ⇒ 00:24:20.770 Uttam Kumaran: Okay.
286 00:24:20.980 ⇒ 00:24:36.660 Uttam Kumaran: yeah. So the main, the basic development process is like, you run real locally, you make code changes. You’ll see it locally, and then we’ll we’ll use Github to basically push a pull request. I don’t know, Nico, if if you, if you’ve set up
287 00:24:36.680 ⇒ 00:24:40.070 Uttam Kumaran: Github on his machine yet, or if we’ve done that process. But
288 00:24:40.520 ⇒ 00:24:41.729 Uttam Kumaran: we probably need to do that.
289 00:24:41.730 ⇒ 00:24:42.130 Nicolas Sucari: And that’s.
290 00:24:42.130 ⇒ 00:24:42.570 Uttam Kumaran: Well.
291 00:24:42.570 ⇒ 00:24:47.399 Nicolas Sucari: I mean. I I think he he, I think, sure as you already cloned the code, you have a
292 00:24:48.600 ⇒ 00:24:59.750 Nicolas Sucari: he he was able to run real locally. So that’s fine. I don’t know if like, if you, if you have any doubt on how to create a pull request, or that’s that kind of stuff, let me know, and I can help you as well.
293 00:24:59.920 ⇒ 00:25:13.260 suraj: Yeah, I think once we add this data, I’ll I’ll then we can have a working session how to do without all step by step. Yeah. Once, like, I’ll do sample one. I will get it, and I think we can do it for next one.
294 00:25:13.260 ⇒ 00:25:20.070 Uttam Kumaran: Yeah, yeah, no, no, no worries on like I know it’s just baby steps at the moment. The biggest thing is like.
295 00:25:20.844 ⇒ 00:25:27.200 Uttam Kumaran: I want to get you to like the 1st thing where you see the whole flow, and then you’ll start to get it. You know.
296 00:25:27.200 ⇒ 00:25:28.050 suraj: Exactly.
297 00:25:28.050 ⇒ 00:25:30.970 Uttam Kumaran: Most. And the thing is is like most of it, I think.
298 00:25:31.110 ⇒ 00:25:44.969 Uttam Kumaran: is like, Okay, we need this additional column, or like, Hey, we’re missing this data. That’s gonna go to Ryan. Everything else, I think, on the analysis side between real and like excel. And like kind of some of the questions that we get today, which is like, Hey, do you pull this data for us?
299 00:25:44.970 ⇒ 00:25:45.900 suraj: Exactly.
300 00:25:45.900 ⇒ 00:25:47.340 Uttam Kumaran: That’s most of it. So.
301 00:25:47.670 ⇒ 00:25:53.079 suraj: Okay. So how often we receive these kind of requests, like from from check or kim.
302 00:25:53.080 ⇒ 00:25:55.617 Uttam Kumaran: Usually like once or twice a week.
303 00:25:55.980 ⇒ 00:25:56.370 suraj: Okay.
304 00:25:56.370 ⇒ 00:25:58.850 Uttam Kumaran: Like, pull this again. The
305 00:25:58.920 ⇒ 00:26:06.649 Uttam Kumaran: our goal is for them to be able to get that themselves in real, because all you did was go into rail and export anyways.
306 00:26:06.650 ⇒ 00:26:07.230 suraj: Yeah, yeah.
307 00:26:07.230 ⇒ 00:26:14.420 Uttam Kumaran: In there. But again, it takes some confidence from you to be like. Here’s how to go do it in real right and like kind of work.
308 00:26:14.420 ⇒ 00:26:15.100 suraj: Exactly.
309 00:26:15.100 ⇒ 00:26:17.709 Uttam Kumaran: That. So that’s the thing we want to get to is like.
310 00:26:17.780 ⇒ 00:26:28.899 Uttam Kumaran: chuck is comfortable enough with the data in there that he can go do it. But, for example, if we don’t have the right warehouses they’re gonna mention, hey? I don’t see the warehouses right? So then it’s like.
311 00:26:28.900 ⇒ 00:26:29.220 Nicolas Sucari: Faculty.
312 00:26:29.220 ⇒ 00:26:53.539 Uttam Kumaran: Those are things that we really need to get through really quickly, making sure that we’re we’re very comfortable with the data, you know. Another thing we can do every week, and this is what we do, you know, with some of the company stuff is every week we I’m happy to go through and look at the dashboards, and immediately, if I saw that dashboard I’d be like, we’re missing this. We’re missing this, and that’s something I would encourage you to do, or you and Nico to do, which is just like
313 00:26:53.700 ⇒ 00:27:04.189 Uttam Kumaran: start of the week. Here’s like some like low hanging fruit, things that we need to. Just like, figure out, basically, again, if we don’t catch it, they’re going to catch it. And if they catch it, then it’s going to be like a red alert.
314 00:27:04.953 ⇒ 00:27:05.600 Uttam Kumaran: you know.
315 00:27:05.600 ⇒ 00:27:06.200 suraj: Sure.
316 00:27:06.200 ⇒ 00:27:10.777 Nicolas Sucari: Yeah, we we need to to be like one step ahead of them.
317 00:27:11.290 ⇒ 00:27:28.859 Nicolas Sucari: But yeah, I would. I would say, for example, with that issue that we’re done. We’re we don’t have the all of the warehouses which I see. Yeah, Frank and Jacksonville like we know that there were orders shipped from the other warehouses. So probably we need like to start the week and check how many orders were from each
318 00:27:29.161 ⇒ 00:27:42.289 Nicolas Sucari: were shipped from each warehouse and try to see if we already have them, those on real. And if we don’t have that, that means that we have an issue right? Something like that. When something like that, we need to start start doing.
319 00:27:42.330 ⇒ 00:27:42.929 Nicolas Sucari: Probably.
320 00:27:45.640 ⇒ 00:27:53.230 suraj: Do? Do we have any? Where we can select see number of views for this dashboard, or last seen by whom kind of thing.
321 00:27:53.560 ⇒ 00:27:55.729 Uttam Kumaran: We don’t have any metrics
322 00:27:55.820 ⇒ 00:27:57.710 Uttam Kumaran: now on usage.
323 00:28:01.110 ⇒ 00:28:05.059 Uttam Kumaran: But good question. I don’t know. I don’t think you can see that in real at the moment.
324 00:28:06.820 ⇒ 00:28:17.250 Nicolas Sucari: No, and I don’t know if if we can add like hags or something in in these views, right? Because this is actually real platform.
325 00:28:17.780 ⇒ 00:28:19.890 Uttam Kumaran: Yeah, I think Kim uses it
326 00:28:19.910 ⇒ 00:28:22.200 Uttam Kumaran: like occasionally, like during the week.
327 00:28:22.450 ⇒ 00:28:23.479 Uttam Kumaran: But again, I.
328 00:28:23.480 ⇒ 00:28:24.000 Nicolas Sucari: I guess I’ll just.
329 00:28:24.000 ⇒ 00:28:29.579 Uttam Kumaran: I want. Yeah, Chuck isn’t using it. And I want Ben and Dan to start using it more often, you know.
330 00:28:30.710 ⇒ 00:28:31.290 Uttam Kumaran: Yes.
331 00:28:31.540 ⇒ 00:28:53.610 Nicolas Sucari: That’s why I think we need to like to fix these issues for Kim and and Chuck. And then we need to review, like, what are the dashboards that we have here, which ones are really useful and like? Try to clean this up, and probably like split into 3 different folders, marketing shipments, shipping, and yeah, business analysis, or kind of that stuff
332 00:28:54.081 ⇒ 00:29:02.929 Nicolas Sucari: so that we can like be more directly, like point what we we want them to be seeing here right.
333 00:29:03.750 ⇒ 00:29:06.280 suraj: Do we have that folders project options here.
334 00:29:06.280 ⇒ 00:29:26.369 Nicolas Sucari: No, no, but if you if you go like one if you click on full parts to go there, yeah, on the top, you’ll see like there, there is like project, maybe. This is something we can like, create 3 different projects and manage it like that. Or I don’t know if there is another way of creating like dashboards in folders, but that is like low priority. Now.
335 00:29:26.550 ⇒ 00:29:36.249 suraj: Yeah, yeah, of course. But like, yeah, organizing in for future purpose. Like, usually, project is a department. So we can add marketing operations or inventory. As I mentioned.
336 00:29:36.250 ⇒ 00:29:36.690 Uttam Kumaran: Yeah.
337 00:29:36.690 ⇒ 00:29:43.029 suraj: And then split and give access based on that like these kind of things.
338 00:29:44.730 ⇒ 00:29:48.070 Nicolas Sucari: Yeah, that that was my kind of idea. Because if if Kim like
339 00:29:48.110 ⇒ 00:29:52.169 Nicolas Sucari: comes here and try to go and see every like, she’s not gonna go
340 00:29:52.580 ⇒ 00:29:59.313 Nicolas Sucari: through all of these dashboards. She’s gonna go into the one says scheme, and that’s where she’s gonna go right.
341 00:29:59.830 ⇒ 00:30:09.469 Nicolas Sucari: that’s why, like I I would try to clean this up a little bit and make it more yeah, easier for them to go on and look within it.
342 00:30:11.110 ⇒ 00:30:25.889 Nicolas Sucari: But yeah, I mean, that’s the task that we can work on later. If you start working on those 2 tasks for the Kpis report and the shipping stuff. You will kind of understand, like the
343 00:30:26.140 ⇒ 00:30:33.519 Nicolas Sucari: like, the general view of everything on, on how they are working, and that the the other changes should be.
344 00:30:34.150 ⇒ 00:30:35.460 suraj: Yeah, yeah, true.
345 00:30:38.450 ⇒ 00:30:38.840 Nicolas Sucari: Nice.
346 00:30:38.840 ⇒ 00:30:42.789 suraj: Yeah, I’ll I’ll look forward for the meeting with Ryan and
347 00:30:42.870 ⇒ 00:30:44.850 suraj: for tomorrow. Then we’ll go from there.
348 00:30:44.850 ⇒ 00:30:45.470 Nicolas Sucari: Okay.
349 00:30:46.300 ⇒ 00:30:46.890 Uttam Kumaran: Okay. Cool.
350 00:30:46.890 ⇒ 00:30:47.590 Nicolas Sucari: Perfect.
351 00:30:49.460 ⇒ 00:30:50.290 Uttam Kumaran: Alright, guys.
352 00:30:50.670 ⇒ 00:30:51.630 Uttam Kumaran: thank you.
353 00:30:51.920 ⇒ 00:30:54.140 suraj: Yeah. Alright. Bye, everyone.
354 00:30:54.140 ⇒ 00:30:54.800 Uttam Kumaran: Taxing.
355 00:30:55.180 ⇒ 00:30:55.870 Nicolas Sucari: And I.