Meeting Title: Rill-Dashboards-Review Date: 2024-09-02 Meeting participants: Suraj, Nicolas Sucari, Uttam Kumaran
WEBVTT
1 00:00:07.120 ⇒ 00:00:07.790 Yes.
2 00:02:40.530 ⇒ 00:02:41.390 Uttam Kumaran: Thanks. Raj.
3 00:02:41.390 ⇒ 00:02:42.050 suraj: Option.
4 00:02:42.690 ⇒ 00:02:43.599 suraj: Hello, Tom.
5 00:02:44.200 ⇒ 00:02:45.190 Uttam Kumaran: Hey! How are you?
6 00:02:45.500 ⇒ 00:02:47.169 suraj: Good! How are you?
7 00:02:47.620 ⇒ 00:02:48.350 Uttam Kumaran: Good
8 00:03:29.450 ⇒ 00:03:30.209 Uttam Kumaran: in town.
9 00:03:33.500 ⇒ 00:03:35.229 Uttam Kumaran: How’s it been going so far?
10 00:03:36.898 ⇒ 00:03:41.281 suraj: Yeah, going good. I just finished those 2 tasks. And
11 00:03:41.780 ⇒ 00:03:46.729 suraj: I was waiting for this call, for, as I told you, I’ll be online of day.
12 00:03:49.710 ⇒ 00:03:53.360 suraj: I’ll be off after this call. And yeah.
13 00:03:54.780 ⇒ 00:03:58.430 Uttam Kumaran: Okay, cool. How’s it been going? So which which tasks were you able to get done.
14 00:03:59.322 ⇒ 00:04:03.487 suraj: The purchase order it’s an ad hoc request.
15 00:04:05.010 ⇒ 00:04:08.070 suraj: yeah, I send those 2 files in that channel.
16 00:04:08.900 ⇒ 00:04:09.550 Nicolas Sucari: Guys.
17 00:04:10.810 ⇒ 00:04:11.979 suraj: Hey, Nicholas.
18 00:04:14.470 ⇒ 00:04:16.350 Nicolas Sucari: Sorry for being late.
19 00:04:16.459 ⇒ 00:04:17.700 Nicolas Sucari: I I
20 00:04:18.160 ⇒ 00:04:20.200 Nicolas Sucari: was not aware that you were already here.
21 00:04:21.519 ⇒ 00:04:22.950 Nicolas Sucari: Or is that a strong? Okay.
22 00:04:23.820 ⇒ 00:04:24.650 Nicolas Sucari: okay.
23 00:04:26.220 ⇒ 00:04:29.470 Uttam Kumaran: Yeah, just, I guess, before jumping into everything, I just wanted to review
24 00:04:29.740 ⇒ 00:04:31.892 Uttam Kumaran: stuff in progress against
25 00:04:32.640 ⇒ 00:04:35.509 Uttam Kumaran: what’s in the notion, Docs? Maybe if you want to share
26 00:04:35.580 ⇒ 00:04:37.989 Uttam Kumaran: notion, we can walk through that. And then.
27 00:04:38.280 ⇒ 00:04:41.069 Uttam Kumaran: yeah, the core of this meeting. I just wanted to.
28 00:04:41.885 ⇒ 00:05:01.084 Uttam Kumaran: Answer any questions about the overall structure of the repo. And then also, I wanted for us to walk through, like all the dashboards, basically, and start to answer any questions you have and I’m starting to kind of create some larger documentation pieces on the structure of the overall code repository. So hopefully, it gets easier to
29 00:05:01.570 ⇒ 00:05:04.890 Uttam Kumaran: to kind of navigate. So yeah.
30 00:05:06.760 ⇒ 00:05:08.889 Nicolas Sucari: Okay, do you want me to share.
31 00:05:10.302 ⇒ 00:05:12.750 Uttam Kumaran: Yeah, maybe, Siraj, if you have it up you can share.
32 00:05:13.930 ⇒ 00:05:14.990 suraj: I mean, yeah.
33 00:05:29.496 ⇒ 00:05:34.470 Uttam Kumaran: I mean, do you want? Can we? Can we walk through the notion 1st about any of the tasks that are in flight?
34 00:05:46.250 ⇒ 00:05:47.490 Uttam Kumaran: Obviously, one thing, you’re
35 00:05:48.389 ⇒ 00:05:52.790 Uttam Kumaran: okay. So which test were you able to complete.
36 00:05:52.790 ⇒ 00:05:57.636 suraj: This one. So it’s I. I just put in progress. So
37 00:05:58.180 ⇒ 00:06:03.360 suraj: once chuck reviews. And he, once it’s done I’ll complete the session.
38 00:06:03.360 ⇒ 00:06:05.880 Uttam Kumaran: Is there a review status.
39 00:06:08.670 ⇒ 00:06:09.820 suraj: no
40 00:06:10.900 ⇒ 00:06:12.249 suraj: Nico can, can you?
41 00:06:12.520 ⇒ 00:06:14.740 Uttam Kumaran: Yeah, yeah.
42 00:06:14.740 ⇒ 00:06:15.160 Nicolas Sucari: Just like.
43 00:06:15.160 ⇒ 00:06:25.890 Uttam Kumaran: I just wanna just want to be clear on like if it’s stuff is blocked by us or not. So if it’s in his hands. Then that’s great. That that means we just gotta follow up with him. Basically.
44 00:06:26.270 ⇒ 00:06:26.930 suraj: Yeah.
45 00:06:30.680 ⇒ 00:06:31.490 suraj: Oh.
46 00:06:31.780 ⇒ 00:06:33.710 Nicolas Sucari: There. There is an interview, you know.
47 00:06:34.210 ⇒ 00:06:36.929 suraj: Yeah, okay, that sounds good.
48 00:06:37.050 ⇒ 00:06:59.069 Nicolas Sucari: Yeah, I’m checking that one because, I’m finding that there are some lines on those files that are kind of, I don’t know. Yeah, maybe they’re wrong, and maybe we can just like export it once with everything with all of the information needed. And then, just like filtering the Excel file with some pivot table so that we can show the
49 00:06:59.090 ⇒ 00:07:02.400 Nicolas Sucari: information to check, like in an easy, easiest way.
50 00:07:03.003 ⇒ 00:07:09.719 Nicolas Sucari: But yeah, I’ll I’ll finish checking those files, and I’ll I’ll answer on that thread and slack. Okay.
51 00:07:11.110 ⇒ 00:07:20.309 suraj: Okay, okay, yeah, I can put that those 2 in one file. Basically, it’s just by platform. And the skews. So
52 00:07:22.740 ⇒ 00:07:23.450 suraj: Alex.
53 00:07:23.450 ⇒ 00:07:24.089 Nicolas Sucari: Yeah, I think.
54 00:07:24.090 ⇒ 00:07:26.170 suraj: And I’ll add it in the Channel.
55 00:07:27.183 ⇒ 00:07:37.810 Nicolas Sucari: Export a new file as an excel. File with everything on it, and show you in the Channel, and I will go through that one. And maybe I can create different views for chuck
56 00:07:37.850 ⇒ 00:07:38.860 Nicolas Sucari: to.
57 00:07:39.130 ⇒ 00:07:40.220 Nicolas Sucari: Yeah.
58 00:07:40.220 ⇒ 00:07:40.720 suraj: Shirt.
59 00:07:40.720 ⇒ 00:07:45.459 Nicolas Sucari: To check by by channel, by scube, or by anything you want.
60 00:07:46.490 ⇒ 00:07:47.210 suraj: Alright.
61 00:07:49.316 ⇒ 00:07:51.200 suraj: Yeah, that is one part
62 00:07:55.640 ⇒ 00:07:59.726 suraj: and review metrics booking. Use that one for
63 00:08:00.670 ⇒ 00:08:03.340 suraj: that I think Ryan is looking into it.
64 00:08:05.980 ⇒ 00:08:09.400 Nicolas Sucari: Yeah, I mean, I think, we need to
65 00:08:09.490 ⇒ 00:08:18.689 Nicolas Sucari: to get into this one like between you and Ryan. I don’t know if Ryan has already started because Ryan was working on some other stuff
66 00:08:19.150 ⇒ 00:08:32.830 Nicolas Sucari: at the end of last week, so I don’t think he was able to start checking all of that ones. But yeah, we need to to go deeper into into that task and see how we can like
67 00:08:33.333 ⇒ 00:08:42.449 Nicolas Sucari: get the conversions from different channels that are missing, or getting the details for each of the campaigns that are missing, so that we can get all of the measures
68 00:08:42.490 ⇒ 00:08:51.360 Nicolas Sucari: right, because for now we are, we are having some some empty values on conversions. And
69 00:08:51.755 ⇒ 00:08:59.069 Nicolas Sucari: yeah, some of the other measures. And what we are trying to share there is is, I think, is wrong.
70 00:08:59.427 ⇒ 00:09:04.670 Nicolas Sucari: So I think we need like to do a deeper analysis on what is the information that we have and how we can
71 00:09:05.089 ⇒ 00:09:11.470 Nicolas Sucari: combine everything to have like a general measure, or if we need to split the the report in different things.
72 00:09:13.190 ⇒ 00:09:19.129 suraj: Got it. Got it? Sure. Okay, okay, I’ll review back end stuff on that.
73 00:09:19.360 ⇒ 00:09:20.850 Nicolas Sucari: I’ll I’ll say.
74 00:09:20.850 ⇒ 00:09:27.409 Uttam Kumaran: We’ve been, we. Yeah, we talked. We talked about this last week as well. So I just want to be clear on, like, who’s doing what.
75 00:09:31.140 ⇒ 00:09:57.819 Nicolas Sucari: Oh, yes, yes, this task. I think it was for Ryan, but he was working on a on on the workflow stuff last week, and I don’t think he was able to start this one, because last week what we said is rush to take the the other task that was to add some dimensions onto the other dashboard. That was more kind of a complete task going through the models and understanding which dimensions can we add?
76 00:09:58.148 ⇒ 00:10:08.320 Nicolas Sucari: I’m working a little bit on Dbt, and then on the real folder, too. So yeah, I think the metrics one is for Ryan and the Daily Kpi was for Srush.
77 00:10:08.830 ⇒ 00:10:12.960 Uttam Kumaran: Yeah, can we put, can we put a people’s names here? Yeah, it’s not. Yeah.
78 00:10:15.750 ⇒ 00:10:16.730 Nicolas Sucari: Fine, too.
79 00:10:17.420 ⇒ 00:10:19.959 Uttam Kumaran: And that’d be great.
80 00:10:20.340 ⇒ 00:10:22.260 Nicolas Sucari: Add it here.
81 00:10:23.030 ⇒ 00:10:23.630 Uttam Kumaran: Alright!
82 00:10:23.630 ⇒ 00:10:24.990 Nicolas Sucari: And although
83 00:10:26.130 ⇒ 00:10:28.410 Nicolas Sucari: I landed all of them, okay.
84 00:10:30.350 ⇒ 00:10:38.160 Uttam Kumaran: If we can do that. And then, yeah, I just want to. And, Siraj, I I just want you to be very clear with on like, if you have all the
85 00:10:38.240 ⇒ 00:10:40.159 Uttam Kumaran: requirements, you need to do something.
86 00:10:40.320 ⇒ 00:10:45.190 Uttam Kumaran: Well, if you don’t, it’s fine. You just you just gotta say, really, clearly, like, hey? I’m not really sure what’s going on.
87 00:10:45.653 ⇒ 00:10:56.309 Uttam Kumaran: Otherwise we’re gonna really lose time, like meeting every week and talking about the same thing. So the thing I you know, we have a couple like, basically, we’re all looking at this from different angles, right? I think.
88 00:10:56.380 ⇒ 00:11:07.550 Uttam Kumaran: from Nico side. He sees like the timelines and everything. But on your side you’re actually executing the test. So if you don’t know what exactly is going on or what you’re assigned to, then nothing happens right. Same thing.
89 00:11:07.550 ⇒ 00:11:08.319 suraj: Yeah, yeah.
90 00:11:08.320 ⇒ 00:11:20.299 Uttam Kumaran: If he thinks that you’re assigned, and you’re not so these sorts of things. I want to just get through a bit quicker. So the I mean minimum. We want to know who’s working on what what the progress is.
91 00:11:20.650 ⇒ 00:11:24.989 Uttam Kumaran: That’s it, right? So I think you know, we’re getting better at that now.
92 00:11:25.300 ⇒ 00:11:26.010 suraj: True, true.
93 00:11:26.010 ⇒ 00:11:30.960 Uttam Kumaran: Moment you have the. So Ryan has the review metrics for Kim. That’s not started yet.
94 00:11:31.020 ⇒ 00:11:34.919 Uttam Kumaran: That’s linked to the 3rd item, which is the improved
95 00:11:35.200 ⇒ 00:11:41.109 Uttam Kumaran: Daily Kpi with more dimensions. So is there anything else that you’re currently working on that’s
96 00:11:41.280 ⇒ 00:11:42.750 Uttam Kumaran: in progress.
97 00:11:43.714 ⇒ 00:11:53.775 suraj: So right now, yeah. As I said that, I just finished up this one. So I I’ll start looking into review metrics for Kim but if you say so like
98 00:11:56.390 ⇒ 00:11:58.300 suraj: I’ll I’ll start.
99 00:11:58.300 ⇒ 00:12:01.950 Uttam Kumaran: What does that mean? So what? What like? What does that one? What does that one include.
100 00:12:03.040 ⇒ 00:12:10.930 suraj: This one is only adding, like the the revenue for all other platforms were missing from camp marketing.
101 00:12:10.950 ⇒ 00:12:12.877 suraj: So in the dashboard.
102 00:12:13.640 ⇒ 00:12:19.079 suraj: so I have to look into the back end data to understand where it is coming from. Basically
103 00:12:19.690 ⇒ 00:12:21.339 suraj: like this stuff.
104 00:12:23.110 ⇒ 00:12:44.650 Nicolas Sucari: So yeah, it’s adding, we we don’t have the revenue for Facebook, Google and Amazon. What we need to do is check. If in this in in those 3 platforms we can add the revenue into this model, so that we can have, like the correct revenue value for everything, and also is checking not only the revenue metric, but also the Cpm.
105 00:12:44.650 ⇒ 00:12:45.410 suraj: Cb.
106 00:12:45.410 ⇒ 00:12:48.820 Nicolas Sucari: Cpa, yeah. And all of those ones that we have there.
107 00:12:50.580 ⇒ 00:12:53.990 Uttam Kumaran: Okay, cool. Okay, great. I see that in the ticket. So, yeah, that would be
108 00:12:54.520 ⇒ 00:12:56.469 Uttam Kumaran: that would be great to work on next.
109 00:12:56.980 ⇒ 00:12:57.435 suraj: Okay.
110 00:12:57.890 ⇒ 00:13:00.769 Uttam Kumaran: Again. It looks like it’s assigned to Ryan. So that’s why I just.
111 00:13:00.770 ⇒ 00:13:01.360 Nicolas Sucari: Yeah, that’s already.
112 00:13:01.360 ⇒ 00:13:02.070 Uttam Kumaran: Like.
113 00:13:04.700 ⇒ 00:13:05.130 Nicolas Sucari: There!
114 00:13:06.250 ⇒ 00:13:07.250 suraj: Okay, I guess.
115 00:13:07.250 ⇒ 00:13:14.380 Uttam Kumaran: There will be tasks that go between you guys depending on like, what sort of thing it is, but ideally, all the tasks that go to rhyme
116 00:13:15.410 ⇒ 00:13:16.650 Uttam Kumaran: years. So.
117 00:13:17.300 ⇒ 00:13:21.415 suraj: Okay, I’ll I’ll start digging into this, and if I need help I’ll I’ll I’ll
118 00:13:22.110 ⇒ 00:13:23.979 suraj: helping Ryan on this.
119 00:13:25.090 ⇒ 00:13:35.060 suraj: Yeah. And regarding this one. We already had discussion like adding, if you remember adding more dimensions to the the existing dashboard.
120 00:13:35.917 ⇒ 00:13:37.650 suraj: Yeah, this one.
121 00:13:38.410 ⇒ 00:13:42.553 suraj: Yeah. Like we discussed on this last week. Like, so basically,
122 00:13:43.090 ⇒ 00:13:54.770 suraj: what I put up is like, basically we have here the marketing metrics as well as the inventory metrics like here. The marketing cost all this stuff
123 00:13:55.200 ⇒ 00:14:03.990 suraj: where this marketing cost and the impressions clicks. These are not, not at like a dimension level, right? Those like
124 00:14:04.450 ⇒ 00:14:12.220 suraj: the platform or those kind of inventory. So I thought, like, there are 2 things I want to. Input like one is.
125 00:14:12.930 ⇒ 00:14:21.210 suraj: this dashboard can be as it is like what what we are saying. This is just Kpi looking like for the whole company, for all different metrics.
126 00:14:21.604 ⇒ 00:14:32.179 suraj: We already have other metric, or or else like removing the marketing metrics, and add those other dimensions which which says, of course, the inventory dashboard, nothing but
127 00:14:33.930 ⇒ 00:14:40.229 suraj: Or else, if we add that more dimensions and still have the marketing metrics like the clicks and impressions.
128 00:14:40.490 ⇒ 00:14:43.810 suraj: the data will be duplicated at those levels. Right? So.
129 00:14:43.810 ⇒ 00:14:45.619 Uttam Kumaran: Yeah, that makes sense.
130 00:14:45.620 ⇒ 00:15:13.799 suraj: I thought like it’s not appropriate to add dimensions into this dashboard, either. We can remove this 3 metrics, clicks, impressions, and marketing cost, and add those metrics and have separate dashboard for this marketing exactly have those dimensions which which makes sense to have for marketing like campaigns or the platforms. Kind of things. So we wanted to discuss actually with you about this particular dashboard.
131 00:15:13.800 ⇒ 00:15:29.989 Uttam Kumaran: No, no, that’s spot on. So you’re totally right. I think. Let’s do that. So I basically, I want to think about right now we have all the sales. Data is coming from like all orders. I wonder whether do you think we should have like multiple Kpi dashboards like we should have
132 00:15:30.210 ⇒ 00:15:33.110 Uttam Kumaran: one for marketing, one for sales.
133 00:15:33.110 ⇒ 00:15:35.929 suraj: Exactly one for inventory shipping.
134 00:15:36.950 ⇒ 00:15:53.949 Nicolas Sucari: Yeah, that’s what we discussed last week with Ryan and Raj. Because if we if we don’t split it and we add dimensions when you like. Click on one of the dimensions, you will be filtering down some stuff, and every and and the rest of it the measures that don’t include that dimension. They will be empty.
135 00:15:57.870 ⇒ 00:16:04.460 suraj: But yeah, that is one possibility. But I’m not sure if you really can do that kind of things.
136 00:16:04.920 ⇒ 00:16:05.730 Nicolas Sucari: Yeah.
137 00:16:06.860 ⇒ 00:16:10.550 Uttam Kumaran: Okay, so let’s just agree on on this like, yeah, it would be great to have
138 00:16:10.930 ⇒ 00:16:15.150 Uttam Kumaran: basically one. Keep this one. That’s just the overall company
139 00:16:15.270 ⇒ 00:16:19.199 Uttam Kumaran: keep, and then let’s have 2 others that are one for sales
140 00:16:19.310 ⇒ 00:16:20.780 Uttam Kumaran: and one for
141 00:16:21.390 ⇒ 00:16:23.489 Uttam Kumaran: one for sales, one for
142 00:16:23.910 ⇒ 00:16:25.250 suraj: Marketing.
143 00:16:25.250 ⇒ 00:16:27.210 Uttam Kumaran: One for one for marketing.
144 00:16:27.490 ⇒ 00:16:32.309 Uttam Kumaran: I would suggest that we decide whether we want to repurpose the other one
145 00:16:33.470 ⇒ 00:16:34.320 Uttam Kumaran: right?
146 00:16:34.640 ⇒ 00:16:37.680 Uttam Kumaran: Or you wanna create a new table. That’s gonna be my question.
147 00:16:37.690 ⇒ 00:16:40.010 suraj: So what? I’m.
148 00:16:40.010 ⇒ 00:16:44.249 Nicolas Sucari: When you’re talking about the other one. Sorry the other one is paid marketing performance dashboard.
149 00:16:44.250 ⇒ 00:16:45.490 Uttam Kumaran: Yes. Yeah.
150 00:16:45.660 ⇒ 00:16:46.370 Uttam Kumaran: Yeah.
151 00:16:47.040 ⇒ 00:16:47.370 suraj: Yeah.
152 00:16:47.370 ⇒ 00:16:57.269 Uttam Kumaran: Right. So I want to know between all of these, like, if we create, for example, right now, we have the Daily Kpis. If you create daily sales. Kpis
153 00:16:59.170 ⇒ 00:17:03.719 Uttam Kumaran: seems like there’s a place for that, right? That’s not doesn’t already exist really clearly.
154 00:17:04.339 ⇒ 00:17:05.970 Uttam Kumaran: But what about daily
155 00:17:05.980 ⇒ 00:17:08.939 Uttam Kumaran: shipping? Right? That almost seems like shipment staples.
156 00:17:09.930 ⇒ 00:17:10.599 Nicolas Sucari: Yeah.
157 00:17:10.819 ⇒ 00:17:29.510 Nicolas Sucari: yeah, that’s why we we need like to reorganize all of this, maybe split on the 3 like big categories that we have, that is, sales, shipping, and marketing, and see what we need for each of them, and try to repurpose the dashboards that we have, or create new ones. Accordingly, to what we need.
158 00:17:30.700 ⇒ 00:17:32.620 Uttam Kumaran: Yeah. So I guess so, Roger, what should we do?
159 00:17:33.210 ⇒ 00:17:46.670 suraj: So I already explored having like like. If there are possibility to have 3 folders, something like that. And we we look at it. Other tools, right? But I don’t think we have some such kind of thing like we.
160 00:17:46.670 ⇒ 00:17:49.809 Uttam Kumaran: But that’s just like, but that’s like that’s okay. Let’s say
161 00:17:49.850 ⇒ 00:17:54.329 Uttam Kumaran: we can do that or whatever. But we only have 10. We only have like 15 dashboards here.
162 00:17:54.880 ⇒ 00:17:55.970 Uttam Kumaran: Oh.
163 00:17:56.130 ⇒ 00:18:02.039 Uttam Kumaran: let’s just talk about like just the doctor says like, are you? Do you want to create additional ones?
164 00:18:02.250 ⇒ 00:18:02.620 suraj: So.
165 00:18:02.620 ⇒ 00:18:03.499 Uttam Kumaran: This? Do you want to.
166 00:18:03.500 ⇒ 00:18:32.880 suraj: Yeah, what I wanted to say is here, like, for example, here we have paid marketing performance. This one is already having, like most of the dimensions which are related to marketing. And we can modify this to have more dimensions, and not to disturb this flow and correct. Whatever is incorrect here like this, adding revenues or all other stuff. So we can. We can say this as like one marketing dashboard for go to place for marketing.
167 00:18:33.080 ⇒ 00:18:45.770 suraj: and same like for shipments. We already have shipments dashboard, and we can modify accordingly to have to include all of those things any missing missing dimensions. And same for inventory.
168 00:18:45.870 ⇒ 00:19:02.599 suraj: And yeah, like, and it’s it’s good to have a refunds and warranties dashboard as separate, because those fall under like those metrics, comes later after the sales. Right? So it’s good to have. These are like, not like everyday dashboards. These are like once once in a.
169 00:19:02.600 ⇒ 00:19:02.920 Uttam Kumaran: Yeah.
170 00:19:02.920 ⇒ 00:19:28.709 suraj: So we can. Just have them like this. And yeah, and maybe renaming these dashboards and have any missing dimensions or metrics we can add to those, and reuning as like sales Kpi dashboard shipment, Kpi and inventory Kpi. Something like this. So inventory matrix. For this we have everything here, so there is no need to build new one, and
171 00:19:29.170 ⇒ 00:19:30.949 suraj: what we need to do is
172 00:19:32.210 ⇒ 00:19:35.759 suraj: change like, add or remove the dimensions or metrics.
173 00:19:35.760 ⇒ 00:19:44.869 Uttam Kumaran: Yeah. So I think so. So yeah, that I guess that’s spot on. So let’s if if you can handle that, then let’s just make sure to add those details somewhere. And then, yeah, feel.
174 00:19:44.870 ⇒ 00:19:45.250 suraj: Yeah.
175 00:19:45.250 ⇒ 00:19:46.250 Uttam Kumaran: To.
176 00:19:46.250 ⇒ 00:19:46.700 suraj: So.
177 00:19:46.700 ⇒ 00:19:47.620 Uttam Kumaran: Strangers.
178 00:19:47.770 ⇒ 00:20:09.790 suraj: So what I will do is in in the part of reorganizing stuff. I’ll I’ll start with sales and this each topic, and see from the database. What all the dimensions we have. 1st of all, the metrics and measures and dimensions, list of all, list out, all of them, and see to match what we have in the dashboards.
179 00:20:09.880 ⇒ 00:20:20.339 suraj: and if we have everything, then it is good. If if in, if not we can. We can modify accordingly. So I I’ll start with that part. What? What do you think.
180 00:20:20.980 ⇒ 00:20:22.509 Uttam Kumaran: Okay, that’s fine. Yeah.
181 00:20:23.450 ⇒ 00:20:30.320 Uttam Kumaran: So I would focus on again. Don’t I don’t think inventory is gonna be a huge priority. So let’s just start with
182 00:20:30.340 ⇒ 00:20:34.869 Uttam Kumaran: sales, shipments, and marketing.
183 00:20:35.230 ⇒ 00:20:36.650 suraj: Yeah, yeah.
184 00:20:36.650 ⇒ 00:20:40.360 Uttam Kumaran: And then ideally, yeah, feel free. Whatever changes you want to make.
185 00:20:40.420 ⇒ 00:20:52.369 Uttam Kumaran: go for it again, it will. It will require you to you know, modify code and create a pull request and Github. And then we can get that merged. Basically, sure.
186 00:20:52.370 ⇒ 00:20:56.430 suraj: Sure. Sure, once I get to the point, I’ll I will discuss with the team. Yeah.
187 00:20:58.120 ⇒ 00:21:07.200 suraj: And something like, like, for example, daily, Kpi means not like this is, forget about my we can have this. Okay. But the.
188 00:21:07.200 ⇒ 00:21:18.090 Uttam Kumaran: Yeah, that’s fine. Yeah. As you mentioned, like, we can’t add other. We can’t add domain specific dimensions, because we’ll start to get duplicates. So this the way it is is fine. Let’s just leave this as like.
189 00:21:18.090 ⇒ 00:21:18.630 suraj: Yeah, I.
190 00:21:18.630 ⇒ 00:21:20.889 Uttam Kumaran: Executive kpis, or something like that.
191 00:21:20.890 ⇒ 00:21:28.930 suraj: Exactly. So. Let’s imagine having a sales dashboard similar to this, and there we can have only sales for
192 00:21:29.220 ⇒ 00:21:58.479 suraj: the dimensions like oh, it that you don’t need like. For example, you have filters here saying platform like Amazon shop here you have to select indefinitely. Right? So if you have direct metric for Amazon sales shopify sales, as we have only 3 platforms we can just show them directly, like a kpi means kpi. Once you open the dashboard, you only see what metrics it is shown. We don’t need to filter all of the all of like other dimensions. It would be like a kind of detailed dashboard.
193 00:21:59.338 ⇒ 00:22:06.200 suraj: The sales kpi. I think it should have a direct looking metrics instead of filtering.
194 00:22:06.240 ⇒ 00:22:20.255 suraj: and they can easily also compare alright, like by looking at. For example, if we have here Amazon sales, shopify sales, Walmart sales and they can see the trend. Okay, shopify is going down. Amazon is going up kind of things instead of filtering and
195 00:22:20.950 ⇒ 00:22:22.550 suraj: seeing the stuff
196 00:22:23.260 ⇒ 00:22:28.450 suraj: th those kind of things make sense to have in a Kpi, that’s like a sales. Kpi dashboard.
197 00:22:29.050 ⇒ 00:22:30.220 suraj: What do you think?
198 00:22:30.540 ⇒ 00:22:32.309 suraj: Okay, that’s fine.
199 00:22:33.220 ⇒ 00:22:34.600 suraj: Yeah.
200 00:22:36.260 ⇒ 00:22:39.918 suraj: yeah, I I’ll come up with that. And I’ll I’ll show you guys
201 00:22:40.200 ⇒ 00:22:46.240 Uttam Kumaran: Okay, cool. Yeah, that’s great. So I mean, like, again, I think you’re getting the hang of it. So yeah, the big things I just want to know.
202 00:22:46.330 ⇒ 00:22:56.520 Uttam Kumaran: since I’m not involved day to days. I just want to know what tasks are in flight. And then questions like that which is like, Hey, we want to make these effort changes that that makes sense to run through me.
203 00:22:56.580 ⇒ 00:23:19.669 Uttam Kumaran: The biggest things that I’m gonna be looking for is like, what tasks are we working on? What’s blocked things like that? That’s why I wanna come to these, come to come to these meetings and kind of be able to see that like, Hey, it’s really clear what everybody’s working on. There’s not like, oh, so and so is doing this so and so is doing this like, it’s pretty clear on, like I need to rename these dashboards. I need to add these dimensions right? That’s the sort of thing I want to see.
204 00:23:20.250 ⇒ 00:23:21.770 Uttam Kumaran: so great.
205 00:23:22.300 ⇒ 00:23:24.579 suraj: Got it. Yeah, sounds good.
206 00:23:25.307 ⇒ 00:23:26.919 suraj: Yeah, that is.
207 00:23:27.920 ⇒ 00:23:29.420 suraj: that is still here.
208 00:23:29.830 ⇒ 00:23:30.495 suraj: And
209 00:23:31.330 ⇒ 00:23:33.839 suraj: yeah, that’s all I have reviewed.
210 00:23:36.580 ⇒ 00:23:37.094 Uttam Kumaran: Okay.
211 00:23:38.140 ⇒ 00:23:55.990 Uttam Kumaran: okay, great. I think the other thing that I’m gonna be starting to do is I’m I’m adding documentation on the like, basically the entire like repository. So you’ll have kind of like business context on where sources are coming from. And like the key tables.
212 00:23:56.510 ⇒ 00:24:06.350 Uttam Kumaran: the thing that’s that I really like the key things that I would love for you to take a look at further is the all orders and the all order items table. Have you taken a look at that.
213 00:24:06.890 ⇒ 00:24:08.560 suraj: Yeah, yeah, I I looked at it.
214 00:24:09.100 ⇒ 00:24:11.760 Uttam Kumaran: And have you? Did you take a look at the sequel? Logic for those.
215 00:24:13.020 ⇒ 00:24:14.239 suraj: Not yet.
216 00:24:14.640 ⇒ 00:24:15.320 Uttam Kumaran: Okay.
217 00:24:16.140 ⇒ 00:24:20.790 Uttam Kumaran: that would be my suggestion. Those 2 tables basically power everything.
218 00:24:21.751 ⇒ 00:24:26.169 Uttam Kumaran: And taken the sources from Amazon, Shopify and Walmart.
219 00:24:26.450 ⇒ 00:24:36.549 Uttam Kumaran: You know the order early level. So you have all the different product related information and the order level, which has like discounts, taxes all that stuff.
220 00:24:36.600 ⇒ 00:24:41.660 Uttam Kumaran: And then those basically go to power. The key salesmen
221 00:24:41.710 ⇒ 00:24:47.570 Uttam Kumaran: really key to know kind of how those 2 tables work and kind of see the inputs there
222 00:24:47.580 ⇒ 00:24:59.339 Uttam Kumaran: and then. Yeah, the other, the basically, I think, nico, like we, we have the meeting on Thursday with Kim. Right? Is there anything we want to try to plan for for that meeting?
223 00:25:01.088 ⇒ 00:25:04.399 Nicolas Sucari: So for that meeting, I think we need to
224 00:25:04.460 ⇒ 00:25:29.720 Nicolas Sucari: if we, if we want, is like to to show her something maybe it’s worth showing any of these analyses that we’re trying to do with these new dashboards or trying to split the dashboard that we have on paid marketing performance and accurately show her like the correct revenue on what we have, or give her a clear status of where we’re standing with the Google, Facebook and Amazon stuff.
225 00:25:30.215 ⇒ 00:25:33.189 Nicolas Sucari: Because right now, we need like to
226 00:25:33.300 ⇒ 00:25:38.330 Nicolas Sucari: work on that one is what we is. That’s what she’s expecting, I think.
227 00:25:40.540 ⇒ 00:25:41.520 Nicolas Sucari: because now.
228 00:25:41.520 ⇒ 00:25:44.079 Uttam Kumaran: Is it clear what we wanted? What like
229 00:25:44.960 ⇒ 00:25:48.190 Uttam Kumaran: are the things that Sera is working on? Gonna tackle that or.
230 00:25:48.900 ⇒ 00:26:10.349 Nicolas Sucari: Yeah, I think if so, if Raj. If you work rash on understanding that marketing dashboard and creating that new daily Kpi or that new dashboard with the kpis you want, and with the dimensions only for marketing that will be super useful, so that we can show Kim and see if that values are more accurate to what she was expecting.
231 00:26:11.260 ⇒ 00:26:13.470 suraj: Yeah, yeah, that sounds good.
232 00:26:13.850 ⇒ 00:26:14.739 Uttam Kumaran: Okay, so, twice.
233 00:26:14.740 ⇒ 00:26:15.430 Nicolas Sucari: I think.
234 00:26:15.430 ⇒ 00:26:19.900 Uttam Kumaran: That meeting is on Thursday. So I just wanna make sure that that’s possible by
235 00:26:20.470 ⇒ 00:26:23.799 Uttam Kumaran: Wednesday or so like to kind of like, get these changes in.
236 00:26:26.180 ⇒ 00:26:27.770 suraj: Yeah, yeah, sure.
237 00:26:28.310 ⇒ 00:26:28.900 suraj: I.
238 00:26:28.900 ⇒ 00:26:32.480 Nicolas Sucari: I think that should be now like like our top priority, for now.
239 00:26:33.510 ⇒ 00:26:41.899 Nicolas Sucari: like trying to to nail this stuff on marketing first, st and then we can move in with sales and shipping.
240 00:26:43.180 ⇒ 00:26:43.720 suraj: Okay.
241 00:26:43.720 ⇒ 00:26:44.310 Uttam Kumaran: Place.
242 00:26:44.510 ⇒ 00:26:51.820 Uttam Kumaran: Okay, cool. So Wednesday, I’m gonna I’m gonna check in and see kind of like what progress is like, because we have a meeting with her on on Thursday.
243 00:26:51.940 ⇒ 00:26:55.789 Uttam Kumaran: So by Wednesday I want to kind of get a sense of like. Did we add
244 00:26:55.980 ⇒ 00:27:01.349 Uttam Kumaran: like, are we able to get answers for her. Do we make these dashboard updates things like that? So
245 00:27:01.530 ⇒ 00:27:03.269 Uttam Kumaran: we have about
246 00:27:04.230 ⇒ 00:27:04.970 Uttam Kumaran: 16.
247 00:27:06.330 ⇒ 00:27:07.819 suraj: Got it? Sure, sure.
248 00:27:08.750 ⇒ 00:27:11.540 Nicolas Sucari: Okay, yeah. So suresh, if you wanna focus on that one.
249 00:27:11.540 ⇒ 00:27:12.220 Uttam Kumaran: Yeah.
250 00:27:12.970 ⇒ 00:27:18.719 Nicolas Sucari: Yeah, I think, just just focus on that one. And I can handle with the file that you
251 00:27:18.760 ⇒ 00:27:31.059 Nicolas Sucari: sent on the shipping stuff for chuck. I can create the the excel file and and share it in the external channel, or I’ll I’ll let you. I’ll let you share. But I prefer the document. Don’t worry. Okay.
252 00:27:31.370 ⇒ 00:27:33.310 suraj: Okay? Okay, sure.
253 00:27:34.180 ⇒ 00:27:36.140 suraj: I’ll start with the marketing.
254 00:27:36.610 ⇒ 00:27:37.245 Nicolas Sucari: Okay.
255 00:27:38.910 ⇒ 00:27:41.259 Uttam Kumaran: Great guys anything else. For some reason.
256 00:27:41.940 ⇒ 00:27:47.887 Nicolas Sucari: No utam. Just if you can loop me in with the unleashed person so that I can
257 00:27:48.610 ⇒ 00:27:54.320 Nicolas Sucari: try. Yeah. Asking about what we need there, that will be great.
258 00:27:54.740 ⇒ 00:27:56.009 Uttam Kumaran: Okay. I’ll do that right now.
259 00:27:56.830 ⇒ 00:27:58.350 Nicolas Sucari: Excellent. Thank you.
260 00:27:59.610 ⇒ 00:28:01.939 Uttam Kumaran: Okay, guys, I’ll talk to you guys soon.
261 00:28:01.940 ⇒ 00:28:02.570 suraj: Yeah.
262 00:28:03.200 ⇒ 00:28:04.390 Nicolas Sucari: Thanks, bye, bye.
263 00:28:04.390 ⇒ 00:28:05.510 Uttam Kumaran: Thank you.