Meeting Title: Data Analysis Sync with Awaish Date: 2026-03-06 Meeting participants: Awaish Kumar, Mustafa Raja
WEBVTT
1 00:00:29.250 ⇒ 00:00:30.180 Mustafa Raja: Okay.
2 00:00:33.030 ⇒ 00:00:33.870 Mustafa Raja: Hey.
3 00:00:34.980 ⇒ 00:00:36.579 Mustafa Raja: You, you’re muted.
4 00:00:43.760 ⇒ 00:00:47.270 Awaish Kumar: Okay, yeah, just let me know how to group this, that’s all, for now.
5 00:00:47.770 ⇒ 00:01:02.199 Mustafa Raja: Okay, group these, can you go to the chart? Yeah, and then… group dimensions in the table, or right side? On the right side, you’d see in the table… wait, let me mark it.
6 00:01:03.070 ⇒ 00:01:04.810 Mustafa Raja: Yeah. Yeah.
7 00:01:06.540 ⇒ 00:01:09.680 Mustafa Raja: Let’s see, okay, this should be good, right?
8 00:01:13.150 ⇒ 00:01:15.220 Awaish Kumar: Okay, yeah, it’s… it’s fine.
9 00:01:16.010 ⇒ 00:01:21.930 Awaish Kumar: Yeah, 2, 3, 6… It should match, I’ll sweep this one.
10 00:01:26.220 ⇒ 00:01:26.780 Mustafa Raja: Okay.
11 00:01:29.020 ⇒ 00:01:31.580 Mustafa Raja: So… so what’s next now?
12 00:01:32.780 ⇒ 00:01:36.760 Awaish Kumar: Why doesn’t… Why does Norage Match?
13 00:01:42.320 ⇒ 00:01:43.620 Mustafa Raja: What’s mismatching?
14 00:01:45.590 ⇒ 00:01:49.899 Awaish Kumar: This chart, as… Numbers, like this.
15 00:01:50.940 ⇒ 00:01:51.840 Awaish Kumar: down, what?
16 00:01:54.140 ⇒ 00:01:57.610 Awaish Kumar: Total lines up for March is 2377.
17 00:01:58.270 ⇒ 00:02:01.010 Awaish Kumar: And here is March 2362.
18 00:02:03.150 ⇒ 00:02:04.100 Mustafa Raja: Possums.
19 00:02:04.210 ⇒ 00:02:09.630 Mustafa Raja: Do we have exactly the same farm? Okay, can we go back, go back?
20 00:02:09.780 ⇒ 00:02:12.739 Mustafa Raja: to the order refund rate, I think I added a…
21 00:02:12.930 ⇒ 00:02:15.000 Mustafa Raja: One more filter in the pharmacy.
22 00:02:16.810 ⇒ 00:02:22.280 Mustafa Raja: Can we open up the pharmacy filter? Yeah, you see, it’s also including null.
23 00:02:22.460 ⇒ 00:02:24.520 Mustafa Raja: That’s why the mismatch is there.
24 00:02:24.720 ⇒ 00:02:27.700 Awaish Kumar: Oh, it’s… it’s also in here, also in Kurzlaw.
25 00:02:29.850 ⇒ 00:02:33.190 Mustafa Raja: Oh, he also is including none.
26 00:02:37.150 ⇒ 00:02:41.150 Mustafa Raja: Yeah, And these are exactly the same.
27 00:02:41.380 ⇒ 00:02:43.079 Mustafa Raja: The included pharmacies?
28 00:02:46.340 ⇒ 00:02:49.320 Awaish Kumar: Yeah, yeah. I just duplicated the other one.
29 00:02:49.960 ⇒ 00:02:51.270 Mustafa Raja: Okay, okay, hmm…
30 00:02:52.510 ⇒ 00:02:54.789 Awaish Kumar: This is where I eat is coming from.
31 00:02:56.570 ⇒ 00:03:01.150 Awaish Kumar: Aqua, what if I… Okay…
32 00:03:01.920 ⇒ 00:03:02.630 Mustafa Raja: Oh.
33 00:03:04.090 ⇒ 00:03:06.910 Awaish Kumar: Why is… is it matching now?
34 00:03:07.620 ⇒ 00:03:08.290 Awaish Kumar: Yay.
35 00:03:08.290 ⇒ 00:03:10.030 Mustafa Raja: It is exactly matching now.
36 00:03:10.540 ⇒ 00:03:12.340 Awaish Kumar: So, it’s just because of…
37 00:03:12.940 ⇒ 00:03:14.420 Mustafa Raja: Yeah, the standard product.
38 00:03:15.320 ⇒ 00:03:16.000 Awaish Kumar: Name.
39 00:03:19.650 ⇒ 00:03:23.859 Mustafa Raja: Did you want to do something about that. Where does this V2 come in from?
40 00:03:24.990 ⇒ 00:03:29.399 Mustafa Raja: This is just, fact transactions.
41 00:03:29.570 ⇒ 00:03:44.089 Mustafa Raja: V2, we, because V1 was fact transactions with complete, or with all orders, and then Demi suggested that we should have a topic, with a base view of fact transactions. So this is what it is.
42 00:03:44.720 ⇒ 00:03:49.180 Awaish Kumar: But then, why this single topic have so many… Connections.
43 00:03:49.180 ⇒ 00:03:57.469 Mustafa Raja: These are the, so it’s not only being used here, it’s being used in other charts also, where we do need these.
44 00:03:59.680 ⇒ 00:04:03.270 Awaish Kumar: Yeah, like, that’s why, like, I want… I wanted that…
45 00:04:03.680 ⇒ 00:04:10.790 Awaish Kumar: Even if we are doing sin, We could break, domain-specific… Topics?
46 00:04:10.920 ⇒ 00:04:12.210 Awaish Kumar: No, I don’t.
47 00:04:12.690 ⇒ 00:04:19.950 Awaish Kumar: We don’t… like, it’s hard to debug now which join might be… might be interested… interesting issues, we don’t know.
48 00:04:20.260 ⇒ 00:04:29.629 Mustafa Raja: Okay, so do you want only, the… Product and, fact transaction join.
49 00:04:30.690 ⇒ 00:04:33.020 Awaish Kumar: I just, you know, I just… I do have that.
50 00:04:33.350 ⇒ 00:04:34.459 Mustafa Raja: There’s one topic.
51 00:04:35.960 ⇒ 00:04:39.469 Awaish Kumar: Yeah, yeah, so… I don’t know, coming from, where…
52 00:04:40.290 ⇒ 00:04:47.840 Mustafa Raja: Oh, yeah, the refund, yeah, that’s… yeah, this is what Blobby created. We can… we can… what’s it called?
53 00:04:48.260 ⇒ 00:04:52.379 Mustafa Raja: So this is coming from frac transaction, so we could just replicate it over there, no?
54 00:04:53.830 ⇒ 00:04:54.500 Awaish Kumar: What?
55 00:04:55.420 ⇒ 00:04:57.830 Mustafa Raja: This is coming from cracked transactions, no?
56 00:04:58.400 ⇒ 00:04:59.480 Awaish Kumar: Oh, word, what?
57 00:05:01.200 ⇒ 00:05:05.760 Awaish Kumar: Oh, it’s coming from Fact Transaction, and… Filtering on…
58 00:05:06.390 ⇒ 00:05:08.949 Mustafa Raja: Refund amount. Where’s this refund amount, though?
59 00:05:09.050 ⇒ 00:05:13.130 Mustafa Raja: Order refunds. Okay, so order refunds table is being used here.
60 00:05:16.600 ⇒ 00:05:17.890 Awaish Kumar: Okay, yeah, this…
61 00:05:18.490 ⇒ 00:05:21.049 Mustafa Raja: Hmm… Some other reference table is being used here.
62 00:05:22.900 ⇒ 00:05:24.730 Awaish Kumar: Okay, anyway, I will just add.
63 00:05:24.940 ⇒ 00:05:26.699 Awaish Kumar: It’s not a big difference.
64 00:05:27.570 ⇒ 00:05:28.390 Mustafa Raja: Yeah.
65 00:05:33.360 ⇒ 00:05:34.790 Awaish Kumar: And also, it may be weak.
66 00:05:36.220 ⇒ 00:05:37.000 Awaish Kumar: Okay.
67 00:05:37.480 ⇒ 00:05:40.020 Mustafa Raja: Yeah, if you want to move the,
68 00:05:41.490 ⇒ 00:05:44.269 Mustafa Raja: Column to start, you can… yeah.
69 00:05:46.880 ⇒ 00:05:50.910 Mustafa Raja: In the results tab, you can move the columns.
70 00:05:52.140 ⇒ 00:05:53.149 Mustafa Raja: If you want.
71 00:05:55.040 ⇒ 00:05:55.690 Awaish Kumar: Sonny?
72 00:05:56.370 ⇒ 00:06:01.209 Mustafa Raja: Do you want the, product column to be next to order date?
73 00:06:05.290 ⇒ 00:06:07.050 Awaish Kumar: Oh, they have, like…
74 00:06:07.750 ⇒ 00:06:09.580 Mustafa Raja: Yeah, okay, okay.
75 00:06:12.840 ⇒ 00:06:14.849 Awaish Kumar: Weird, these products.
76 00:06:16.550 ⇒ 00:06:17.290 Awaish Kumar: Okay.
77 00:06:46.810 ⇒ 00:06:52.390 Awaish Kumar: Could it be because Straitai’s product name is… Null, for some…
78 00:06:53.100 ⇒ 00:06:59.870 Mustafa Raja: Yeah, it could be that. I think transactions might also have product name.
79 00:07:01.190 ⇒ 00:07:02.829 Awaish Kumar: No, it does not work.
80 00:07:03.890 ⇒ 00:07:04.750 Mustafa Raja: Oh, okay, okay.
81 00:07:05.140 ⇒ 00:07:15.069 Mustafa Raja: Yeah, for most of the… what’s it called? Most of the tables, or most of the charts, use the name coming from product dimension.
82 00:07:30.200 ⇒ 00:07:31.520 Awaish Kumar: Let’s verify.
83 00:07:48.510 ⇒ 00:07:50.130 Awaish Kumar: What happened to?
84 00:07:56.360 ⇒ 00:07:57.160 Awaish Kumar: Yeah.
85 00:07:57.360 ⇒ 00:08:02.460 Awaish Kumar: It’s like, it looks… It shows exactly same values now.
86 00:08:05.010 ⇒ 00:08:09.450 Awaish Kumar: It’s just because of, the snow. Okay.
87 00:08:09.590 ⇒ 00:08:12.969 Awaish Kumar: We should keep this, because otherwise, number.
88 00:08:12.970 ⇒ 00:08:14.620 Mustafa Raja: Oh, yeah, description, yeah.
89 00:08:25.530 ⇒ 00:08:27.719 Awaish Kumar: And without this, what was the value?
90 00:08:28.570 ⇒ 00:08:31.459 Mustafa Raja: 77, 15… 15 digits.
91 00:08:31.830 ⇒ 00:08:33.500 Mustafa Raja: Difference of 15 digits.
92 00:08:35.880 ⇒ 00:08:36.730 Awaish Kumar: Okay.
93 00:08:45.450 ⇒ 00:08:47.370 Awaish Kumar: Okay, how to ignore this?
94 00:08:50.980 ⇒ 00:08:52.239 Mustafa Raja: It’s not null.
95 00:08:52.790 ⇒ 00:09:00.510 Mustafa Raja: Okay, why? Wondering if we can include null in the standardized product, and that may… Any pass?
96 00:09:00.510 ⇒ 00:09:01.970 Awaish Kumar: What happened to these ones?
97 00:09:03.560 ⇒ 00:09:04.170 Mustafa Raja: What?
98 00:09:04.590 ⇒ 00:09:06.220 Mustafa Raja: Can we remove this?
99 00:09:09.050 ⇒ 00:09:10.060 Mustafa Raja: Come on.
100 00:09:16.850 ⇒ 00:09:18.270 Mustafa Raja: Can we refresh?
101 00:09:27.060 ⇒ 00:09:31.020 Mustafa Raja: Did the total… total…
102 00:09:32.280 ⇒ 00:09:33.600 Awaish Kumar: This is working.
103 00:09:49.760 ⇒ 00:09:50.910 Awaish Kumar: Oh, okay.
104 00:09:52.120 ⇒ 00:09:55.850 Awaish Kumar: Where’d be like… Recreat from this…
105 00:10:15.680 ⇒ 00:10:19.600 Awaish Kumar: Okay, yeah, let’s… I’ll try to close this, I think, yeah.
106 00:10:19.850 ⇒ 00:10:23.970 Awaish Kumar: That’s major, and you will just close whatever you have.
107 00:10:24.370 ⇒ 00:10:27.799 Mustafa Raja: I’m just close attention, and then I am working…
108 00:10:28.550 ⇒ 00:10:36.729 Mustafa Raja: I’m seeing if Demilade has pushed one DBT stuff or not. I don’t think he has, so I’ll work on the attrib… what was that?
109 00:10:39.040 ⇒ 00:10:41.089 Mustafa Raja: The one that you had.
110 00:10:41.420 ⇒ 00:10:43.460 Awaish Kumar: I heard this one, Life Cycle Marketing.
111 00:10:44.200 ⇒ 00:10:45.749 Mustafa Raja: Oh yeah, this life cycle.
112 00:10:47.360 ⇒ 00:10:53.329 Mustafa Raja: Yeah. So I’ll, for the time being, I’m looking into that.
113 00:10:54.540 ⇒ 00:10:56.020 Mustafa Raja: Or are you closing this?
114 00:10:57.540 ⇒ 00:11:00.160 Awaish Kumar: I’m just closing this one, auto journey, for now.
115 00:11:00.830 ⇒ 00:11:05.520 Mustafa Raja: Okay, okay, okay, yeah. I’ll be looking into this later.
116 00:11:06.180 ⇒ 00:11:07.969 Awaish Kumar: And what are you looking at, this one?
117 00:11:08.740 ⇒ 00:11:09.460 Awaish Kumar: For these ones.
118 00:11:09.640 ⇒ 00:11:11.399 Awaish Kumar: Who’s the particulars you’re working on?
119 00:11:12.290 ⇒ 00:11:17.059 Mustafa Raja: I, I will need dbt help for these ones.
120 00:11:17.860 ⇒ 00:11:18.760 Awaish Kumar: These ones?
121 00:11:19.080 ⇒ 00:11:20.040 Mustafa Raja: Yeah…
122 00:11:20.040 ⇒ 00:11:20.639 Awaish Kumar: Okay, let’s…
123 00:11:20.640 ⇒ 00:11:26.239 Mustafa Raja: So, these ones, these ones have the same, same dbt, need, you know?
124 00:11:26.870 ⇒ 00:11:31.300 Awaish Kumar: Yeah, let me close Order Journey Call Tracker, and then I work on these,
125 00:11:31.440 ⇒ 00:11:36.149 Awaish Kumar: requirement in the dbt thing for this, and… but… and then…
126 00:11:37.330 ⇒ 00:11:40.600 Mustafa Raja: Yeah, well, I’m taking a look at lifecycle marketing, yeah.
127 00:11:40.600 ⇒ 00:11:41.310 Awaish Kumar: Okay.
128 00:11:42.350 ⇒ 00:11:47.840 Awaish Kumar: And after that, we can see how to… Close these today, or…
129 00:11:48.840 ⇒ 00:11:50.939 Awaish Kumar: Maybe ask someone to… yeah.
130 00:11:50.940 ⇒ 00:11:51.460 Mustafa Raja: Okay.
131 00:11:52.060 ⇒ 00:11:52.810 Mustafa Raja: Okay.
132 00:11:54.060 ⇒ 00:11:55.190 Awaish Kumar: Okay, thanks.
133 00:11:55.190 ⇒ 00:11:56.690 Mustafa Raja: Okay, thank you. Bye.