Meeting Title: Eden Project Tableau and DBT Sync Date: 2026-02-13 Meeting participants: Mustafa Raja, Mustafa’s Loom Notetaker, Demilade Agboola
WEBVTT
1 00:01:33.210 ⇒ 00:01:34.160 Mustafa Raja: Hey.
2 00:01:37.980 ⇒ 00:01:39.459 Demilade Agboola: Hi, Mustafo, how are you?
3 00:01:39.710 ⇒ 00:01:41.759 Mustafa Raja: Yeah, doing good, how are you? How’s your day?
4 00:01:42.820 ⇒ 00:01:47.850 Demilade Agboola: It’s alright. I’m just trying to see how much I can quickly get done with, so that…
5 00:01:48.280 ⇒ 00:01:49.880 Demilade Agboola: the Friday can’t begin.
6 00:01:50.500 ⇒ 00:01:51.340 Mustafa Raja: Okay.
7 00:01:51.340 ⇒ 00:01:54.339 Demilade Agboola: My Friday’s just… is just to sleep. I need to sleep, I haven’t.
8 00:01:54.340 ⇒ 00:01:57.350 Mustafa Raja: Oh, yeah, I need to,
9 00:01:57.700 ⇒ 00:02:05.210 Mustafa Raja: Yeah, I actually have a coding session with Utum after the end of the day, so I’ll be up late.
10 00:02:06.190 ⇒ 00:02:09.920 Mustafa Raja: But yeah, that rating helps, actually, so I’m happy about that.
11 00:02:10.889 ⇒ 00:02:18.940 Mustafa Raja: So I made this 45 minutes, I thought, 30 minutes we would talk about, Tableau and stuff, and then 15 minutes, let’s talk about…
12 00:02:19.640 ⇒ 00:02:21.390 Mustafa Raja: Default, right?
13 00:02:21.490 ⇒ 00:02:29.270 Mustafa Raja: Since I guess we would want to align this too, right? So… So, yeah.
14 00:02:29.920 ⇒ 00:02:33.850 Mustafa Raja: setup debris. Is this done? Like, is this pushed in the repo also?
15 00:02:34.640 ⇒ 00:02:39.020 Demilade Agboola: Oh, no, I’ve done it, and I’m just doing that now. I’ve done it since pushed the repo.
16 00:02:39.320 ⇒ 00:02:46.000 Mustafa Raja: Okay, so… Yeah, whenever you get the chance, push this to repo.
17 00:02:46.500 ⇒ 00:02:50.480 Mustafa Raja: And then, I believe this hasn’t been sent also, right?
18 00:02:51.800 ⇒ 00:02:52.990 Demilade Agboola: The stuffilar.
19 00:02:53.780 ⇒ 00:02:55.710 Mustafa Raja: The metric definition in alignment, yeah.
20 00:02:56.150 ⇒ 00:02:57.700 Demilade Agboola: No, no, not yet, Takshi.
21 00:02:57.880 ⇒ 00:03:06.720 Mustafa Raja: Okay, so… do you think, this could be done today? Do you think both of these could be… could be done today, or… or…
22 00:03:06.850 ⇒ 00:03:08.330 Mustafa Raja: Maybe only one.
23 00:03:09.460 ⇒ 00:03:16.629 Demilade Agboola: No, the setup for DBT is… again, I’ll literally just push the repo now, so I’m adding in the ad.
24 00:03:17.230 ⇒ 00:03:20.239 Mustafa Raja: Okay, then this… this then goes to Monday then, right?
25 00:03:21.150 ⇒ 00:03:22.290 Demilade Agboola: Yeah, most likely.
26 00:03:23.260 ⇒ 00:03:27.439 Mustafa Raja: Okay… So, do you think I should just do this?
27 00:03:32.230 ⇒ 00:03:33.210 Mustafa Raja: We…
28 00:03:34.240 ⇒ 00:03:35.800 Demilade Agboola: It’s not a full week of work.
29 00:03:36.020 ⇒ 00:03:37.089 Demilade Agboola: At this point.
30 00:03:37.090 ⇒ 00:03:40.649 Mustafa Raja: No, no, no, so what’s going to happen is this…
31 00:03:41.250 ⇒ 00:03:44.979 Mustafa Raja: This is like this, and then data modeling would be next week, right?
32 00:03:46.030 ⇒ 00:03:48.439 Demilade Agboola: I don’t know, make it, make it, like, till Tuesday.
33 00:03:50.160 ⇒ 00:03:51.140 Demilade Agboola: Like, dude?
34 00:03:51.380 ⇒ 00:03:54.610 Demilade Agboola: No, no, the other Tuesday, the Tuesday before.
35 00:03:54.870 ⇒ 00:03:55.750 Mustafa Raja: Okay, okay.
36 00:03:55.750 ⇒ 00:03:56.860 Demilade Agboola: Monday, Tuesday.
37 00:03:59.600 ⇒ 00:04:01.620 Demilade Agboola: So you can extend it to Tuesday.
38 00:04:02.100 ⇒ 00:04:03.040 Mustafa Raja: Okay.
39 00:04:03.680 ⇒ 00:04:04.669 Demilade Agboola: Alright, that’s fine.
40 00:04:06.740 ⇒ 00:04:09.420 Mustafa Raja: But that’s for this week, then, right?
41 00:04:10.770 ⇒ 00:04:16.070 Demilade Agboola: Oh, shoot, I get what you mean now. Okay, yeah, so move it… move… basically, I just need it to be Tuesday.
42 00:04:16.260 ⇒ 00:04:17.870 Mustafa Raja: Yeah, just the next one.
43 00:04:17.870 ⇒ 00:04:18.399 Demilade Agboola: review.
44 00:04:19.089 ⇒ 00:04:23.819 Mustafa Raja: I get you… so what I’m going to do is, I’m going to do this, I’m going to do this.
45 00:04:24.519 ⇒ 00:04:28.329 Mustafa Raja: And then I’m just going to extend this like this.
46 00:04:28.509 ⇒ 00:04:30.929 Mustafa Raja: Right? And this should make sense.
47 00:04:32.319 ⇒ 00:04:41.549 Mustafa Raja: Yeah, so we’re standing in 13, and then by 17, you’re planning to get this done with, and then…
48 00:04:42.769 ⇒ 00:04:47.799 Mustafa Raja: And then, yeah, next 5 days for modeling. What about this?
49 00:04:49.660 ⇒ 00:04:54.710 Demilade Agboola: Oh… So that was delayed because of the S3 stuff.
50 00:04:54.820 ⇒ 00:04:56.890 Demilade Agboola: So, we’re just gonna be starting that next week.
51 00:04:57.730 ⇒ 00:04:58.970 Mustafa Raja: This look good?
52 00:04:59.600 ⇒ 00:05:01.110 Demilade Agboola: Yeah, we can start on next week.
53 00:05:01.280 ⇒ 00:05:02.230 Mustafa Raja: Okay.
54 00:05:04.170 ⇒ 00:05:09.089 Mustafa Raja: I guess this is… All of this is going to be pushed back one week then, right?
55 00:05:11.350 ⇒ 00:05:11.920 Demilade Agboola: Yeah.
56 00:05:14.040 ⇒ 00:05:14.830 Mustafa Raja: Hmm.
57 00:05:20.260 ⇒ 00:05:29.100 Mustafa Raja: I guess we had this one week, there was, there was a, there was one week, you know, a blank one week. Do you still want that?
58 00:05:30.230 ⇒ 00:05:34.550 Mustafa Raja: Where, it was a week where we wouldn’t have any work.
59 00:05:35.860 ⇒ 00:05:37.630 Demilade Agboola: Oh, no, we shouldn’t have a wake-up anymore.
60 00:05:37.630 ⇒ 00:05:39.349 Mustafa Raja: Okay, then this is good.
61 00:05:40.030 ⇒ 00:05:46.660 Mustafa Raja: I’ll mark them as done, once you, you know, let me know that these are done.
62 00:05:46.780 ⇒ 00:05:52.540 Mustafa Raja: Do we have access to all of the sources? At least P0s, or, for this and this one?
63 00:05:54.010 ⇒ 00:05:55.679 Mustafa Raja: Did we get access to plane?
64 00:05:56.240 ⇒ 00:05:59.289 Demilade Agboola: Yes, yes, we have access to plane, we’ve connected it to polyatomic.
65 00:05:59.500 ⇒ 00:06:00.879 Mustafa Raja: Okay, and for…
66 00:06:00.880 ⇒ 00:06:06.360 Demilade Agboola: The only thing left is… is progress, so I’m still… I guess your name will reach out to Victor about that again.
67 00:06:06.650 ⇒ 00:06:10.390 Mustafa Raja: Okay, okay. And for any of these, do we need factors data?
68 00:06:11.890 ⇒ 00:06:14.579 Demilade Agboola: I think Fractors is for Stan?
69 00:06:16.300 ⇒ 00:06:16.840 Demilade Agboola: Right, is it?
70 00:06:16.840 ⇒ 00:06:17.440 Mustafa Raja: Stone.
71 00:06:17.440 ⇒ 00:06:20.110 Demilade Agboola: Is it live? I’m not sure, but I don’t think we need that.
72 00:06:20.110 ⇒ 00:06:20.980 Mustafa Raja: I’m good, then.
73 00:06:21.620 ⇒ 00:06:24.090 Demilade Agboola: And I think Fox is for Stone, so I don’t think we need it right.
74 00:06:24.550 ⇒ 00:06:33.610 Mustafa Raja: Okay, then I guess this is… this would be good to mark as done then, right? Either we mark it as done, or I just extend it. What do you say?
75 00:06:34.170 ⇒ 00:06:38.830 Mustafa Raja: No, no, no, extending doesn’t sound like good plans.
76 00:06:39.200 ⇒ 00:06:43.250 Mustafa Raja: Let’s say Market is done, we have P0s in there, so…
77 00:06:43.730 ⇒ 00:06:48.960 Mustafa Raja: Yeah, just let me know once we are good with these ones, and then… Moving forward with that.
78 00:06:51.560 ⇒ 00:06:57.209 Demilade Agboola: Okay, yeah, I’m trying to do the PR now, so that’s just done, and we know that…
79 00:06:58.520 ⇒ 00:06:58.920 Mustafa Raja: Oh, kidding.
80 00:06:58.920 ⇒ 00:06:59.700 Demilade Agboola: I don’t know.
81 00:06:59.890 ⇒ 00:07:00.870 Demilade Agboola: I’ve got pinned in.
82 00:07:01.410 ⇒ 00:07:03.169 Mustafa Raja: Do you have any plans for Vegan?
83 00:07:04.470 ⇒ 00:07:05.640 Demilade Agboola: Tennis and the.
84 00:07:05.640 ⇒ 00:07:06.310 Mustafa Raja: Sure.
85 00:07:06.730 ⇒ 00:07:07.220 Demilade Agboola: That’s it.
86 00:07:07.220 ⇒ 00:07:11.200 Mustafa Raja: Oh, I need… I need to put a gym in my routine, bro.
87 00:07:12.390 ⇒ 00:07:14.540 Demilade Agboola: It’s just, it’s just tennis and the gym.
88 00:07:15.720 ⇒ 00:07:19.840 Demilade Agboola: I have a friend, I just… I made a new friend in, like, the apartment I live in.
89 00:07:20.240 ⇒ 00:07:25.290 Demilade Agboola: He said there’s a gym, like, that’s a 10-minute walk from our place, so he said, we said we’ll check it out this weekend.
90 00:07:25.670 ⇒ 00:07:26.420 Mustafa Raja: Huh.
91 00:07:26.790 ⇒ 00:07:32.660 Demilade Agboola: And then… Tomorrow, I have about… 6 hours of tennis tomorrow.
92 00:07:33.330 ⇒ 00:07:35.670 Mustafa Raja: 6 hours of tennis only.
93 00:07:36.270 ⇒ 00:07:36.950 Demilade Agboola: Yeah.
94 00:07:37.170 ⇒ 00:07:39.969 Mustafa Raja: Tomorrow, so I have… That’s a lot of tennis, though.
95 00:07:40.370 ⇒ 00:07:41.969 Demilade Agboola: Yeah, I have,
96 00:07:43.710 ⇒ 00:07:52.729 Demilade Agboola: class, a group class, that would be 1 hour having matched, that’ll be, like, an hour and a half, and then I have, like, 3 hours of…
97 00:07:52.900 ⇒ 00:07:57.550 Mustafa Raja: Doubles tennis with some people, so… That’s nice.
98 00:07:58.190 ⇒ 00:08:00.729 Demilade Agboola: I mean, yeah, we’ll see, we’ll see.
99 00:08:01.800 ⇒ 00:08:06.680 Demilade Agboola: hopefully it’s not too crazy. I think when I’m done, my knee will hurt quite a bit, but…
100 00:08:06.850 ⇒ 00:08:07.890 Demilade Agboola: We will be fine.
101 00:08:09.560 ⇒ 00:08:10.240 Mustafa Raja: Yeah.
102 00:08:12.480 ⇒ 00:08:13.450 Demilade Agboola: Do you have any plans?
103 00:08:14.470 ⇒ 00:08:19.670 Mustafa Raja: N-no… I’m planning a trip.
104 00:08:19.900 ⇒ 00:08:23.529 Mustafa Raja: Mid, mid-April.
105 00:08:23.860 ⇒ 00:08:25.569 Mustafa Raja: So, I might get my…
106 00:08:25.570 ⇒ 00:08:26.110 Demilade Agboola: Do you want to go to?
107 00:08:27.970 ⇒ 00:08:28.959 Demilade Agboola: Where’d you want to go to?
108 00:08:29.620 ⇒ 00:08:31.559 Mustafa Raja: Oh, yeah, I’m going Saudi Arabia.
109 00:08:32.130 ⇒ 00:08:35.980 Demilade Agboola: Oh, nice. Baha’s really nice. I haven’t been there, but here’s really nice.
110 00:08:36.500 ⇒ 00:08:38.159 Mustafa Raja: Oh yeah, it’s really nice.
111 00:08:39.500 ⇒ 00:08:52.499 Mustafa Raja: Middle East, UAE, Qatar, and Bahrain, and Saudi, these are really nice places. When we get a chance to do visit… at least do visit UAE, you know?
112 00:08:54.570 ⇒ 00:08:55.130 Mustafa Raja: Doing…
113 00:08:55.130 ⇒ 00:08:55.540 Demilade Agboola: Everyone.
114 00:08:55.540 ⇒ 00:08:57.710 Mustafa Raja: Dubai and stuff is, you know…
115 00:08:57.890 ⇒ 00:09:00.230 Demilade Agboola: Yeah, everyone says, like, that’s a really nice place to go to.
116 00:09:02.740 ⇒ 00:09:04.030 Demilade Agboola: I literally have friends that.
117 00:09:04.030 ⇒ 00:09:08.690 Mustafa Raja: Aishi’s brother… I believe Avishi’s brother works in UAE.
118 00:09:09.310 ⇒ 00:09:09.900 Demilade Agboola: Oh, really?
119 00:09:09.900 ⇒ 00:09:11.139 Mustafa Raja: Jungle Bella, yeah.
120 00:09:11.980 ⇒ 00:09:12.869 Demilade Agboola: That’s pretty cool.
121 00:09:13.960 ⇒ 00:09:15.310 Demilade Agboola: That is pretty cool.
122 00:09:19.720 ⇒ 00:09:20.780 Demilade Agboola: I.
123 00:09:22.380 ⇒ 00:09:26.009 Mustafa Raja: Yeah, so I’ll be off for 10 days, mid-April.
124 00:09:28.150 ⇒ 00:09:29.740 Demilade Agboola: 10 days mid-April, okay.
125 00:09:30.010 ⇒ 00:09:34.329 Demilade Agboola: I hope you have fun, I hope you have a great time.
126 00:09:34.330 ⇒ 00:09:35.020 Mustafa Raja: Yeah.
127 00:09:36.360 ⇒ 00:09:39.229 Demilade Agboola: And hopefully, the visa isn’t too hard to get for you, is it?
128 00:09:39.460 ⇒ 00:09:40.000 Demilade Agboola: It’s interesting.
129 00:09:40.000 ⇒ 00:09:42.710 Mustafa Raja: No, no, no, the visa should be simple.
130 00:09:43.750 ⇒ 00:09:44.579 Demilade Agboola: That’s nice.
131 00:09:45.370 ⇒ 00:09:46.550 Demilade Agboola: That is nice.
132 00:09:46.550 ⇒ 00:09:47.440 Mustafa Raja: Sorry for that.
133 00:09:48.360 ⇒ 00:09:52.230 Demilade Agboola: Yeah, because I know sometimes visas can be quite gets.
134 00:09:52.440 ⇒ 00:09:53.050 Mustafa Raja: Yeah.
135 00:09:56.200 ⇒ 00:09:59.000 Demilade Agboola: And this is my first time flying, actually.
136 00:09:59.490 ⇒ 00:10:00.399 Demilade Agboola: Really? That…
137 00:10:01.990 ⇒ 00:10:08.330 Demilade Agboola: That should be fun, that should be fun. I mean, I remember my first time flying. It was, like, 2020?
138 00:10:09.140 ⇒ 00:10:09.820 Mustafa Raja: Hmm.
139 00:10:10.110 ⇒ 00:10:17.950 Demilade Agboola: But it was within Nigeria, it was a trip within Nigeria. But I was like, no, I had to just… I could have gone by road, but I was like, no, I want to fly.
140 00:10:19.280 ⇒ 00:10:20.160 Mustafa Raja: Yeah.
141 00:10:20.620 ⇒ 00:10:24.500 Demilade Agboola: It’s… since then, I’ve gone on multiple trips, but obviously…
142 00:10:25.670 ⇒ 00:10:31.459 Demilade Agboola: it’s a really different experience, I will say that. It’s quite nice.
143 00:10:31.460 ⇒ 00:10:32.079 Mustafa Raja: You know?
144 00:10:32.330 ⇒ 00:10:34.490 Demilade Agboola: Yeah, she used to visit me.
145 00:10:34.490 ⇒ 00:10:42.499 Mustafa Raja: Yeah. Yes, yes, you suggested me that I should carry a few Twingdoms, and… Yeah, yeah, for the flight.
146 00:10:42.880 ⇒ 00:10:43.809 Demilade Agboola: How long is it?
147 00:10:43.870 ⇒ 00:10:50.149 Mustafa Raja: I think it’s… It shouldn’t be more than two and a half hours, to be honest.
148 00:10:50.390 ⇒ 00:10:55.440 Demilade Agboola: Okay, that’s not too bad, but yes, it’s definitely important that you…
149 00:10:55.830 ⇒ 00:11:00.039 Demilade Agboola: Just get things… I usually use my iPad to entertain myself.
150 00:11:00.640 ⇒ 00:11:03.570 Demilade Agboola: So I usually will download, like, movies…
151 00:11:03.840 ⇒ 00:11:10.770 Demilade Agboola: Or, actually, I don’t really watch movies. I download things on YouTube, download, like, I have, like, Sudoku on my computer.
152 00:11:11.040 ⇒ 00:11:13.640 Mustafa Raja: Oh, you… oh, I haven’t played it at all.
153 00:11:13.910 ⇒ 00:11:17.170 Demilade Agboola: Yeah, just have, like, things, like, and do I have… I download, like, music?
154 00:11:17.600 ⇒ 00:11:22.020 Demilade Agboola: So just stuff I can just do, because usually if I’m going to the US, that’s, like.
155 00:11:22.440 ⇒ 00:11:24.909 Demilade Agboola: A maybe 8-hour flight, 9-hour flight?
156 00:11:25.190 ⇒ 00:11:25.659 Mustafa Raja: Yay.
157 00:11:25.670 ⇒ 00:11:28.090 Demilade Agboola: You definitely need to have some of those things.
158 00:11:28.700 ⇒ 00:11:36.390 Demilade Agboola: But yeah, flights are nice, you know? You get the view of, like, over the cities that you’re going to be landing in.
159 00:11:38.290 ⇒ 00:11:39.529 Demilade Agboola: You know, especially if…
160 00:11:39.820 ⇒ 00:11:52.129 Demilade Agboola: I mean, I haven’t flown business class, but I had a friend who flew business class, and he was just telling me, like, they just keep bringing, like, wine and food, and they just keep, you know… I think that’s a different level. I always play economy.
161 00:11:52.130 ⇒ 00:11:54.539 Mustafa Raja: Yeah, that’s an experience in itself, then, right?
162 00:11:54.540 ⇒ 00:11:58.159 Demilade Agboola: Exactly, exactly.
163 00:11:58.300 ⇒ 00:12:02.609 Demilade Agboola: I want to get to the stage where I don’t get… I don’t pay to fly business.
164 00:12:02.930 ⇒ 00:12:03.850 Demilade Agboola: Oh.
165 00:12:05.670 ⇒ 00:12:07.740 Demilade Agboola: That’s a good ambition, to be honest.
166 00:12:08.030 ⇒ 00:12:08.870 Demilade Agboola: Yeah.
167 00:12:09.090 ⇒ 00:12:12.269 Demilade Agboola: Where, like, the company’s like, oh, you’re coming to a paying business class.
168 00:12:12.930 ⇒ 00:12:20.460 Demilade Agboola: Because I think business class is one of those things where, from what people say, it’s so nice that you really want it to be how you fly all the time.
169 00:12:20.470 ⇒ 00:12:26.749 Mustafa Raja: But it’s so much more expensive than economy, like, it can be four times or 5 times more expensive than economy. So it’s like…
170 00:12:27.240 ⇒ 00:12:35.010 Demilade Agboola: You know, you really have to have… so, like, a flight might be, say, 800, or 1,000 euros, or, you know, dollars, or whatever amount you might be doing.
171 00:12:35.210 ⇒ 00:12:38.819 Demilade Agboola: And then the business class might be, like, 4,000 or 3… like, 4,000.
172 00:12:38.820 ⇒ 00:12:42.510 Mustafa Raja: Oh, that’s just… brutal.
173 00:12:42.940 ⇒ 00:12:47.100 Demilade Agboola: Yeah, so you… Like, I mean, obviously, you know.
174 00:12:47.200 ⇒ 00:12:52.939 Demilade Agboola: you could do it, but it’s one of those things where, for me, my father was an accountant, I’m just there, like.
175 00:12:53.100 ⇒ 00:12:55.760 Demilade Agboola: I… I don’t… I don’t need it that much, you know?
176 00:12:56.680 ⇒ 00:12:58.410 Mustafa Raja: No, no, no, that’s okay.
177 00:12:58.410 ⇒ 00:12:58.940 Demilade Agboola: Excellent.
178 00:12:58.940 ⇒ 00:13:01.550 Mustafa Raja: $4,000 in 8 hours, to be honest.
179 00:13:01.550 ⇒ 00:13:05.890 Demilade Agboola: Exactly, like, you could buy so many things with
180 00:13:06.060 ⇒ 00:13:08.560 Demilade Agboola: The… what you have left over from your…
181 00:13:08.560 ⇒ 00:13:08.920 Mustafa Raja: Yeah.
182 00:13:08.920 ⇒ 00:13:09.540 Demilade Agboola: upon.
183 00:13:10.130 ⇒ 00:13:16.459 Demilade Agboola: But also, like, if someone was paying for you to fly business, you would have said no. Yeah, so it’s one of those things, so…
184 00:13:16.460 ⇒ 00:13:17.329 Mustafa Raja: Yeah, I get it.
185 00:13:22.320 ⇒ 00:13:27.059 Demilade Agboola: Yeah, business is… business is quite nice. Business is quite nice, first class is also quite nice.
186 00:13:27.740 ⇒ 00:13:35.639 Demilade Agboola: Let me know if you have PR done, we can then move forward to Tableau, then… I’ve opened the PR, like, I’ve actually opened… I’ve created a PR.
187 00:13:35.820 ⇒ 00:13:41.189 Mustafa Raja: Okay, okay, then let’s do this, and then… I guess I’ll stop sharing, and you can take over.
188 00:13:41.920 ⇒ 00:13:42.550 Demilade Agboola: Okay.
189 00:13:42.890 ⇒ 00:13:51.819 Demilade Agboola: So… What context do you have about… What’s… what’s this called?
190 00:13:51.820 ⇒ 00:13:52.550 Mustafa Raja: Tableau?
191 00:13:53.410 ⇒ 00:13:54.130 Demilade Agboola: Yeah.
192 00:13:54.340 ⇒ 00:13:57.509 Mustafa Raja: No context. I haven’t worked with it at all.
193 00:14:01.550 ⇒ 00:14:02.490 Mustafa Raja: I’m kidding.
194 00:14:02.630 ⇒ 00:14:03.510 Demilade Agboola: venue.
195 00:14:06.510 ⇒ 00:14:25.490 Mustafa Raja: I guess, but I guess what I will be doing is, I will be just seeing how… how the joins are working, and how the dashboard is laid out under, I guess underneath, what’s the underneath logic of the charts, and that should be it then, right? I should be able to translate that into topics.
196 00:14:25.890 ⇒ 00:14:28.490 Mustafa Raja: And then go on with that, right?
197 00:14:29.880 ⇒ 00:14:37.000 Demilade Agboola: Yeah, so that’s part of what I’m thinking about. Do we want to do topics? So let me…
198 00:14:37.110 ⇒ 00:14:37.900 Demilade Agboola: Let’s…
199 00:14:38.810 ⇒ 00:14:41.600 Mustafa Raja: I think without topic, we cannot even work, right?
200 00:14:42.540 ⇒ 00:14:47.749 Demilade Agboola: Yeah, yeah, yeah, I’m… well, actually, I think you can… I’m not sure, I think you can use models.
201 00:14:49.760 ⇒ 00:14:56.540 Mustafa Raja: I think I tried. What happens is, so by models, you mean individual tables, right?
202 00:14:57.110 ⇒ 00:14:59.239 Demilade Agboola: Yeah, oh, you can also use queries, by the way.
203 00:14:59.240 ⇒ 00:15:03.080 Mustafa Raja: Yeah, what happens is,
204 00:15:03.480 ⇒ 00:15:13.109 Mustafa Raja: individual queries, it doesn’t update with the data, right? So, if I query it, the chart itself isn’t going to…
205 00:15:13.560 ⇒ 00:15:27.039 Mustafa Raja: update itself, right? So that, that is one issue, and then, if I, if I directly work with, tables themselves, I cannot select, any other table.
206 00:15:27.150 ⇒ 00:15:30.489 Mustafa Raja: If I choose one table, I’ll have to stay within it.
207 00:15:31.310 ⇒ 00:15:32.920 Demilade Agboola: Okay, yeah, that’s annoying.
208 00:15:33.350 ⇒ 00:15:39.690 Mustafa Raja: Yeah, that is why we have to do topics. And then, my question would be, what do you think
209 00:15:40.250 ⇒ 00:15:57.570 Mustafa Raja: About having one single topic for the whole thing, and then multiple topics. I think, Greg is sold out on multiple topics, just because, you know, we would have topics and, data in there for relevant people, you know?
210 00:15:58.260 ⇒ 00:16:01.220 Demilade Agboola: If we go the multiple topics route.
211 00:16:02.000 ⇒ 00:16:09.240 Demilade Agboola: Yeah, I think multiple topics is best, in terms of also, like, data governance, and just being able to say, hey, only these people can see this data.
212 00:16:09.460 ⇒ 00:16:16.660 Demilade Agboola: I mean, it’s not necessarily, like, important right now, but, like, the idea is, in the future, it might be.
213 00:16:16.770 ⇒ 00:16:22.109 Demilade Agboola: You don’t want to have to start doing things again because of… Data governance.
214 00:16:24.640 ⇒ 00:16:25.330 Mustafa Raja: Yeah.
215 00:16:30.860 ⇒ 00:16:35.560 Demilade Agboola: Okay, sorry, I’m trying to open up the… Dashboards, alright.
216 00:16:54.660 ⇒ 00:16:58.200 Demilade Agboola: So, have you connected Omni to… BigQuery.
217 00:16:58.940 ⇒ 00:17:00.690 Mustafa Raja: Avish has done that.
218 00:17:01.180 ⇒ 00:17:02.040 Demilade Agboola: Okay, nice.
219 00:17:03.420 ⇒ 00:17:05.210 Demilade Agboola: That’s great.
220 00:17:05.210 ⇒ 00:17:10.890 Mustafa Raja: Let me actually double-check, because I… I haven’t actually checked the connection.
221 00:17:12.609 ⇒ 00:17:16.440 Mustafa Raja: Just want to make sure that I can see it, you know, or I can access it.
222 00:17:21.460 ⇒ 00:17:22.720 Mustafa Raja: Yeah, it’s there.
223 00:17:25.859 ⇒ 00:17:28.640 Mustafa Raja: It is there, so it should be good.
224 00:17:28.860 ⇒ 00:17:32.069 Mustafa Raja: And then, let me see if I can see the tables…
225 00:17:33.080 ⇒ 00:17:34.880 Mustafa Raja: Okay, we have a lot of tables.
226 00:17:38.690 ⇒ 00:17:44.679 Mustafa Raja: I guess I’ll be working… I wouldn’t be working with, dev and raw tables then, right?
227 00:17:46.250 ⇒ 00:17:47.390 Demilade Agboola: No, no, it’s prod.
228 00:17:47.880 ⇒ 00:17:48.930 Mustafa Raja: Only Broad.
229 00:17:49.400 ⇒ 00:17:51.320 Demilade Agboola: Yeah, only productivity maths.
230 00:17:52.950 ⇒ 00:17:56.189 Mustafa Raja: Okay… and then, not even Basque, right?
231 00:17:56.900 ⇒ 00:17:57.590 Demilade Agboola: No.
232 00:17:57.590 ⇒ 00:17:58.150 Mustafa Raja: Only product.
233 00:17:58.630 ⇒ 00:17:59.930 Demilade Agboola: Any part, yeah.
234 00:18:00.320 ⇒ 00:18:03.539 Mustafa Raja: Oh yeah, these are… these are reasonable amounts of tables, then.
235 00:18:04.520 ⇒ 00:18:10.829 Demilade Agboola: Yeah… this… that’s why we said this can be doable. It’s not… it’s not… it’s not too expensive.
236 00:18:11.560 ⇒ 00:18:12.350 Mustafa Raja: It’s music.
237 00:18:12.350 ⇒ 00:18:16.970 Demilade Agboola: It’s basically these dashboards, the most important.
238 00:18:17.330 ⇒ 00:18:18.330 Demilade Agboola: Hmm.
239 00:18:18.330 ⇒ 00:18:21.839 Mustafa Raja: I’ll share the sheet link with me?
240 00:18:23.110 ⇒ 00:18:24.079 Demilade Agboola: This link? Okay.
241 00:18:24.080 ⇒ 00:18:25.719 Mustafa Raja: Yeah, yeah, yeah, I need this.
242 00:18:27.530 ⇒ 00:18:29.580 Mustafa Raja: In Zoom chat or somewhere, you know?
243 00:18:30.040 ⇒ 00:18:31.489 Demilade Agboola: Yes, it’s your slugs.
244 00:18:32.190 ⇒ 00:18:33.000 Mustafa Raja: Oh, thank you.
245 00:18:37.540 ⇒ 00:18:38.700 Mustafa Raja: Okay…
246 00:18:43.960 ⇒ 00:18:44.730 Mustafa Raja: Agreed.
247 00:18:44.730 ⇒ 00:18:46.780 Demilade Agboola: Are you also… are you in the Eden repo?
248 00:18:47.430 ⇒ 00:18:50.310 Demilade Agboola: Oh, sorry, no, Eden One Pass Vault.
249 00:18:50.910 ⇒ 00:18:53.819 Mustafa Raja: Let me check. I don’t think I am, though.
250 00:18:54.550 ⇒ 00:18:56.459 Mustafa Raja: Eden, I am not.
251 00:18:56.970 ⇒ 00:18:59.620 Demilade Agboola: You are not. Okay, let me reach out to…
252 00:18:59.860 ⇒ 00:19:02.650 Mustafa Raja: I… I’ll… I can reach out.
253 00:19:02.880 ⇒ 00:19:05.970 Mustafa Raja: That’s fine.
254 00:19:06.590 ⇒ 00:19:08.790 Demilade Agboola: Yeah, I was going to just ping Rico and ask him.
255 00:19:27.490 ⇒ 00:19:28.860 Mustafa Raja: Okay, this is good.
256 00:19:31.180 ⇒ 00:19:31.860 Demilade Agboola: Okay.
257 00:19:35.490 ⇒ 00:19:43.770 Demilade Agboola: Alright, so… There’s that… Alright, so I’m not sure, what else would you need…
258 00:19:44.670 ⇒ 00:19:51.130 Mustafa Raja: I think, a general walkthrough of, you know, where I will find… You know…
259 00:19:51.130 ⇒ 00:19:53.430 Demilade Agboola: Alright, so let’s, let’s start off with… stuff like that.
260 00:19:53.970 ⇒ 00:19:59.319 Demilade Agboola: Okay, let’s start off with the first, like… Maybe 5 dashboards?
261 00:19:59.580 ⇒ 00:20:00.980 Demilade Agboola: So this will be the first fight.
262 00:20:01.600 ⇒ 00:20:10.309 Demilade Agboola: Because these are, like, the highest priority that they use in, like, almost every day, sort of, dashboards. I mean, other dashboards are so important. I know they use marketing, but, like…
263 00:20:11.200 ⇒ 00:20:13.560 Demilade Agboola: Yeah, these are high pry.
264 00:20:14.750 ⇒ 00:20:20.410 Demilade Agboola: So the reason why I asked about the Tableau thing was because I would want you to look at it in Tableau.
265 00:20:21.060 ⇒ 00:20:22.190 Demilade Agboola: as well.
266 00:20:23.570 ⇒ 00:20:28.730 Demilade Agboola: So this is Eden Unit Economics and Profitability, blah blah blah.
267 00:20:29.970 ⇒ 00:20:32.799 Mustafa Raja: So this is one table, or multiple.
268 00:20:33.780 ⇒ 00:20:34.640 Demilade Agboola: Just one.
269 00:20:35.460 ⇒ 00:20:44.340 Demilade Agboola: So it’s using the ProdBT Marts, So, control… Megan.
270 00:20:55.950 ⇒ 00:20:57.889 Demilade Agboola: So, yeah, it’s using this table.
271 00:21:01.170 ⇒ 00:21:01.800 Demilade Agboola: Hmm.
272 00:21:14.610 ⇒ 00:21:19.619 Demilade Agboola: Yeah, so it’s just in this table, where for every day, we have the product name.
273 00:21:20.810 ⇒ 00:21:27.269 Demilade Agboola: Membership plans, the gender, and, like, how many were returning customers, all of that stuff.
274 00:21:28.050 ⇒ 00:21:32.520 Demilade Agboola: So we have basically, like, measures for those dimensions.
275 00:21:35.050 ⇒ 00:21:37.640 Demilade Agboola: And then we use that… Here.
276 00:21:39.490 ⇒ 00:21:47.059 Mustafa Raja: Okay, and can we actually, dig into the definition of graphs in the dashboard?
277 00:21:47.880 ⇒ 00:21:52.060 Demilade Agboola: Oh yeah, yeah, yeah. So when you open a dashboard, you’ll see all of this.
278 00:21:52.710 ⇒ 00:21:56.289 Demilade Agboola: Right. Which, I mean, obviously can seem a bit overwhelming.
279 00:21:56.870 ⇒ 00:21:59.519 Demilade Agboola: But if you open, click on Edit.
280 00:22:02.650 ⇒ 00:22:08.310 Demilade Agboola: you’ll see all the charts. So this tick right here, can you see this tick?
281 00:22:08.310 ⇒ 00:22:10.080 Mustafa Raja: Yeah, yeah, blue dick, yeah.
282 00:22:10.270 ⇒ 00:22:15.100 Demilade Agboola: Yeah, that blue tick means it’s currently being used in the dashboard, so that’s what you’re going to be getting.
283 00:22:15.310 ⇒ 00:22:20.010 Mustafa Raja: And then the ones that do not have a tick, I do not need to care about them, right?
284 00:22:20.180 ⇒ 00:22:22.390 Demilade Agboola: No, they’re just sheets, basically.
285 00:22:22.390 ⇒ 00:22:23.150 Mustafa Raja: Oh, ugly.
286 00:22:25.760 ⇒ 00:22:36.869 Mustafa Raja: Okay, and then, can we actually dig into the definition of the table? Because, I want to see, so for this chart that’s on the top, yeah, I want to see which columns,
287 00:22:37.140 ⇒ 00:22:38.599 Mustafa Raja: Built this, you know?
288 00:22:39.310 ⇒ 00:22:46.119 Demilade Agboola: Alright, so, sure. So for that, you will click on… you can click on the chat itself, so there are two ways. Once you click on the chat.
289 00:22:47.260 ⇒ 00:22:49.440 Demilade Agboola: You can see that it highlights one here, so that’s
290 00:22:49.780 ⇒ 00:22:58.139 Demilade Agboola: that you need to see. So you can either click on it here, or you can click on it here. What that will do, it will take you directly to the chart, to the sheet.
291 00:22:59.150 ⇒ 00:23:05.719 Demilade Agboola: And so now what you can see now is the sheets that make up Like, the column here.
292 00:23:06.680 ⇒ 00:23:08.950 Demilade Agboola: Is the month date?
293 00:23:10.430 ⇒ 00:23:11.640 Demilade Agboola: and the rules.
294 00:23:12.100 ⇒ 00:23:14.989 Demilade Agboola: At the measure values, in this case.
295 00:23:15.720 ⇒ 00:23:17.820 Demilade Agboola: And the projected revenue.
296 00:23:18.130 ⇒ 00:23:26.840 Demilade Agboola: So what these measure values means is just basically, it’s dividing it into, like, the measure names, new patient revenue, returning, and projected. That’s what’s going on here.
297 00:23:27.140 ⇒ 00:23:37.389 Mustafa Raja: And this major, major value, this column is coming, actually from the table, right? This is a major, I believe it’s coming from there, right?
298 00:23:37.850 ⇒ 00:23:42.000 Demilade Agboola: Yeah, so if you want to see that, you can just always go to, like, measure values are…
299 00:23:43.570 ⇒ 00:23:48.650 Demilade Agboola: new products revenue, so when you see… okay, so this is… you might have to look a bit deeper.
300 00:23:48.880 ⇒ 00:23:49.309 Mustafa Raja: Can you see…
301 00:23:49.310 ⇒ 00:23:50.980 Demilade Agboola: This… and these are not the same.
302 00:23:53.830 ⇒ 00:23:54.739 Demilade Agboola: It’s fine.
303 00:23:55.370 ⇒ 00:23:56.199 Mustafa Raja: American people.
304 00:23:56.200 ⇒ 00:23:57.340 Demilade Agboola: In front of it, yeah.
305 00:23:57.890 ⇒ 00:24:00.629 Demilade Agboola: That equals to sign means that it’s a calculated field.
306 00:24:01.270 ⇒ 00:24:02.010 Mustafa Raja: Okay.
307 00:24:02.990 ⇒ 00:24:05.739 Demilade Agboola: Right. So, like, maybe you’re in.
308 00:24:05.740 ⇒ 00:24:10.489 Mustafa Raja: In Omni, right? Because median is counted value in Omni?
309 00:24:11.020 ⇒ 00:24:14.589 Demilade Agboola: Mmm… not necessarily like that.
310 00:24:15.490 ⇒ 00:24:17.039 Demilade Agboola: What I mean by that is.
311 00:24:21.690 ⇒ 00:24:23.509 Demilade Agboola: Sorry, one second.
312 00:24:23.510 ⇒ 00:24:24.310 Mustafa Raja: Yeah.
313 00:24:26.280 ⇒ 00:24:26.990 Demilade Agboola: Oof.
314 00:24:28.090 ⇒ 00:24:31.019 Demilade Agboola: So I’m not actually locked up. I have no idea why I’m coughing.
315 00:24:34.410 ⇒ 00:24:42.970 Demilade Agboola: This just means that the value comes directly from the table that Tableau is connected to.
316 00:24:44.390 ⇒ 00:24:45.370 Demilade Agboola: Right?
317 00:24:45.370 ⇒ 00:24:45.690 Mustafa Raja: Yes.
318 00:24:45.690 ⇒ 00:24:50.770 Demilade Agboola: So what that… what that means is, for instance, if I have… gross revenue.
319 00:24:51.860 ⇒ 00:24:56.469 Demilade Agboola: And I have… Taxes and refund.
320 00:24:56.990 ⇒ 00:25:02.960 Demilade Agboola: And then I have another column, and I’ll come and calculate net revenue, and I have applied formula to it.
321 00:25:03.220 ⇒ 00:25:07.440 Demilade Agboola: That… not natural revenue will be considered a calculated field.
322 00:25:10.240 ⇒ 00:25:11.240 Mustafa Raja: Yeah.
323 00:25:11.410 ⇒ 00:25:24.779 Mustafa Raja: Okay, so this column is actually coming from, dbt itself, and then the one that has equals before them, we would be calculating them somewhere within Tableau, right?
324 00:25:25.420 ⇒ 00:25:27.580 Demilade Agboola: Yes, they are calculated within Taolo, yes.
325 00:25:27.580 ⇒ 00:25:28.370 Mustafa Raja: Okay.
326 00:25:29.120 ⇒ 00:25:30.180 Demilade Agboola: So if you want to see what…
327 00:25:30.180 ⇒ 00:25:31.909 Mustafa Raja: This, this looks…
328 00:25:32.100 ⇒ 00:25:39.930 Mustafa Raja: pretty similar to what we have in, you know, as major in Omni? Or Dimension. I think it’s Dimension or major, I’m not sure.
329 00:25:39.930 ⇒ 00:25:43.959 Demilade Agboola: It’s measures, it’s measures. Dimensions are, like, categories.
330 00:25:44.380 ⇒ 00:25:45.210 Mustafa Raja: Okay, okay.
331 00:25:46.630 ⇒ 00:25:50.319 Demilade Agboola: So, if you want to open this, like, see what’s… like, for instance, now…
332 00:25:51.270 ⇒ 00:25:55.949 Demilade Agboola: I said new customer cogs. Like I said, this shows that it comes directly from the table.
333 00:25:56.200 ⇒ 00:25:59.559 Demilade Agboola: So you can see Describe, and then describe will just say, hey.
334 00:25:59.670 ⇒ 00:26:05.480 Demilade Agboola: it is product sales summary by transaction dot new customer cocks. It tells you the table
335 00:26:06.020 ⇒ 00:26:08.020 Demilade Agboola: As well as the name.
336 00:26:08.740 ⇒ 00:26:09.819 Demilade Agboola: Of the column.
337 00:26:10.560 ⇒ 00:26:11.479 Demilade Agboola: Do you get…
338 00:26:11.660 ⇒ 00:26:14.979 Mustafa Raja: Oh, yeah, name of the column in, what’s it called?
339 00:26:15.130 ⇒ 00:26:16.060 Mustafa Raja: In BigQuery.
340 00:26:16.060 ⇒ 00:26:17.799 Demilade Agboola: In, yeah, yeah.
341 00:26:17.980 ⇒ 00:26:22.949 Demilade Agboola: So, that’s what I mean by it’s not calculated, it literally is pointing to an exact column.
342 00:26:22.950 ⇒ 00:26:24.230 Mustafa Raja: Yeah, I understand this.
343 00:26:24.230 ⇒ 00:26:30.220 Demilade Agboola: table. So that’s, that’s that. But when you say an equals to a sign, it means there was some calculation done.
344 00:26:30.440 ⇒ 00:26:33.090 Demilade Agboola: So if we take describe now, we can see…
345 00:26:34.260 ⇒ 00:26:39.879 Mustafa Raja: Yeah, this is the sum… aggregate… aggregation sum then, right? Oh, we do actually have formula also.
346 00:26:40.460 ⇒ 00:26:43.140 Mustafa Raja: Is this a song?
347 00:26:43.480 ⇒ 00:26:45.619 Demilade Agboola: Yeah, it’s just saying new customer revenue.
348 00:26:46.600 ⇒ 00:26:49.370 Demilade Agboola: It usually seems to be…
349 00:26:49.370 ⇒ 00:26:51.009 Mustafa Raja: I’m on this column, yeah.
350 00:26:51.010 ⇒ 00:26:51.570 Demilade Agboola: Yeah.
351 00:26:54.800 ⇒ 00:27:04.170 Demilade Agboola: So… That’s that, I like, so NCAT2 is also a calculation. Describe, so it’s the sum.
352 00:27:04.390 ⇒ 00:27:05.900 Demilade Agboola: of ad spend.
353 00:27:06.320 ⇒ 00:27:07.979 Demilade Agboola: So that’s been done on that column.
354 00:27:08.110 ⇒ 00:27:12.479 Demilade Agboola: Divided by the sum of new customer accounts, including offer.
355 00:27:15.340 ⇒ 00:27:15.950 Mustafa Raja: Yeah.
356 00:27:17.290 ⇒ 00:27:22.319 Demilade Agboola: So ad spend here is basically how much was spent on the customer, on ads.
357 00:27:22.510 ⇒ 00:27:25.420 Demilade Agboola: A new customer count is just basically…
358 00:27:25.800 ⇒ 00:27:30.309 Demilade Agboola: So, how many new customers were on the platform? So, it’s basically…
359 00:27:30.310 ⇒ 00:27:30.700 Mustafa Raja: traditional.
360 00:27:31.310 ⇒ 00:27:31.810 Demilade Agboola: Yeah.
361 00:27:31.810 ⇒ 00:27:37.170 Mustafa Raja: Yeah, so here we are seeing how much we spent to get per customer, right?
362 00:27:37.550 ⇒ 00:27:39.070 Demilade Agboola: Exactly, so that’s the NCOC.
363 00:27:39.540 ⇒ 00:27:43.249 Demilade Agboola: So that’s basically what you should just be doing, right? You’ll need to go through…
364 00:27:43.610 ⇒ 00:27:45.690 Demilade Agboola: all the filters that I used.
365 00:27:45.830 ⇒ 00:27:52.040 Demilade Agboola: For that, for each chart, this is where it gets tricky, that’s the tricky part, or the hard part.
366 00:27:52.550 ⇒ 00:27:54.509 Demilade Agboola: You need to know what,
367 00:27:54.810 ⇒ 00:27:56.589 Demilade Agboola: Filters were used for a chart.
368 00:27:57.360 ⇒ 00:28:02.039 Demilade Agboola: So, like, now you have summoning revenue, summon your returning patient, this, this, this, this.
369 00:28:02.690 ⇒ 00:28:06.230 Demilade Agboola: on… And then you use it.
370 00:28:06.640 ⇒ 00:28:10.979 Demilade Agboola: And then, so you come back to this, so that was just one chart.
371 00:28:11.340 ⇒ 00:28:12.140 Mustafa Raja: Hmm…
372 00:28:12.270 ⇒ 00:28:16.020 Demilade Agboola: And now the second chart would be this, you go to it.
373 00:28:16.720 ⇒ 00:28:26.199 Demilade Agboola: And so it’s mandate, measure values, measure values now is new order counts, as well as returning order counts. So that’s basically the color. That’s what used to give it color.
374 00:28:26.500 ⇒ 00:28:33.729 Mustafa Raja: Major values, aggregated project order, and previous one, what was that one? What was the second column there?
375 00:28:34.900 ⇒ 00:28:39.690 Mustafa Raja: Sorry, what was the previous one, the previous table that we looked into?
376 00:28:40.610 ⇒ 00:28:42.289 Demilade Agboola: Progress table…
377 00:28:44.160 ⇒ 00:28:48.519 Mustafa Raja: It was… Projected revenue, okay, okay.
378 00:28:49.020 ⇒ 00:28:50.580 Demilade Agboola: Protective everything monthly.
379 00:28:50.820 ⇒ 00:28:51.799 Mustafa Raja: Oh, okay, okay, okay.
380 00:28:52.780 ⇒ 00:28:58.449 Demilade Agboola: So that was also aggregated… Let me see producted revenue monthly…
381 00:29:01.390 ⇒ 00:29:04.550 Mustafa Raja: Yeah, projected revenue monthly, and this aggregated, right?
382 00:29:05.240 ⇒ 00:29:10.690 Demilade Agboola: So that’s the daily… Average revenue month to day.
383 00:29:10.810 ⇒ 00:29:13.050 Demilade Agboola: Times the days in the month.
384 00:29:13.680 ⇒ 00:29:21.859 Mustafa Raja: Hmm, so, so the signed AGG, is this added by, Tableau by itself?
385 00:29:23.110 ⇒ 00:29:25.700 Demilade Agboola: Yes.
386 00:29:26.510 ⇒ 00:29:33.050 Demilade Agboola: If I remember correctly, AGG is just basically… I mean, it’s aggregated in a certain way.
387 00:29:33.980 ⇒ 00:29:34.640 Demilade Agboola: Okay.
388 00:29:34.790 ⇒ 00:29:37.150 Demilade Agboola: I can’t remember what I’m gonna give me a second.
389 00:29:39.410 ⇒ 00:29:40.250 Demilade Agboola: Trying to think.
390 00:29:47.500 ⇒ 00:29:49.029 Demilade Agboola: And just Google it.
391 00:29:56.790 ⇒ 00:29:58.390 Demilade Agboola: Okay, yeah, so, like…
392 00:29:58.600 ⇒ 00:30:04.809 Demilade Agboola: In Tableau, HDD just means that a measure or calculation is already aggregated within a calculator field.
393 00:30:05.140 ⇒ 00:30:12.689 Demilade Agboola: So that means that below cannot apply, like, another sum on it, like, cannot apply another aggregation, so you cannot do sum of that anymore.
394 00:30:12.840 ⇒ 00:30:13.810 Mustafa Raja: Oh, okay.
395 00:30:13.810 ⇒ 00:30:15.110 Demilade Agboola: Yeah, good, yeah.
396 00:30:19.350 ⇒ 00:30:21.670 Mustafa Raja: Yeah, so…
397 00:30:21.670 ⇒ 00:30:27.190 Demilade Agboola: you do sum of profit divided by sum of sales, Tableau will label it as AGG.
398 00:30:27.570 ⇒ 00:30:29.100 Demilade Agboola: Because it’s purgated.
399 00:30:29.390 ⇒ 00:30:34.660 Mustafa Raja: Hmm, okay. So once we perform, so, so, so…
400 00:30:34.860 ⇒ 00:30:40.439 Mustafa Raja: So, a field that is already calculated, we cannot use it in a calculation, is what we are saying, right?
401 00:30:40.840 ⇒ 00:30:45.940 Demilade Agboola: Yeah, because it wouldn’t make any… like, for instance, this field is basically… some…
402 00:30:46.140 ⇒ 00:30:49.129 Demilade Agboola: of… what was it again? Multiplication of something.
403 00:30:50.540 ⇒ 00:30:51.910 Mustafa Raja: I think it was just some…
404 00:30:52.280 ⇒ 00:30:57.560 Demilade Agboola: It was date, no, it was daily revenue… daily average revenue month to date, times the number of days in the month.
405 00:30:57.860 ⇒ 00:31:01.419 Demilade Agboola: So you can’t sum that again, like, it just looks weird.
406 00:31:01.890 ⇒ 00:31:02.590 Mustafa Raja: Yeah.
407 00:31:04.170 ⇒ 00:31:05.140 Mustafa Raja: Yeah, this makes sense.
408 00:31:06.600 ⇒ 00:31:08.240 Demilade Agboola: So yeah, that’s.
409 00:31:08.240 ⇒ 00:31:11.469 Mustafa Raja: Now, can we… yeah, can we take a look at,
410 00:31:14.390 ⇒ 00:31:23.909 Mustafa Raja: I guess this is good, I would want to take a look at a dashboard that has… that’s working with multiple, multiple tables, you know?
411 00:31:24.620 ⇒ 00:31:25.090 Demilade Agboola: Okay, so…
412 00:31:25.090 ⇒ 00:31:26.860 Mustafa Raja: How that looks in Tableau.
413 00:31:27.600 ⇒ 00:31:29.329 Demilade Agboola: I was trying to find that,
414 00:31:32.310 ⇒ 00:31:35.079 Demilade Agboola: Okay, so this might have some…
415 00:31:35.080 ⇒ 00:31:38.319 Mustafa Raja: Oh, this is… this is… this has a lot of fun. Tables.
416 00:31:39.650 ⇒ 00:31:41.410 Demilade Agboola: Let’s look at it, let’s… what’s going on.
417 00:31:47.330 ⇒ 00:31:50.480 Demilade Agboola: So we have retention dashboards here.
418 00:31:51.870 ⇒ 00:31:54.400 Demilade Agboola: So this is based off the size…
419 00:31:59.570 ⇒ 00:32:02.240 Demilade Agboola: Of the cohorts, and how many people are coming back.
420 00:32:02.400 ⇒ 00:32:07.790 Demilade Agboola: So this was the month of all our first cohorts, all people coming back, ETC, ETC, it is, ETC.
421 00:32:11.110 ⇒ 00:32:13.269 Demilade Agboola: I’m surprised there are not too many things.
422 00:32:13.850 ⇒ 00:32:14.510 Demilade Agboola: Nice.
423 00:32:15.570 ⇒ 00:32:21.610 Demilade Agboola: Let’s see, oh, I was going to also say something, by the way. When you open a sheet.
424 00:32:21.890 ⇒ 00:32:22.760 Demilade Agboola: I just remembered.
425 00:32:23.490 ⇒ 00:32:25.950 Demilade Agboola: It would highlight what is being used to make it.
426 00:32:27.840 ⇒ 00:32:35.919 Mustafa Raja: These are the… these are… these are all of the fields, or the tables that I… is this a table, or the field?
427 00:32:37.100 ⇒ 00:32:38.460 Demilade Agboola: No, the filter below.
428 00:32:38.620 ⇒ 00:32:39.760 Mustafa Raja: Okay, okay.
429 00:32:40.880 ⇒ 00:32:43.090 Mustafa Raja: And this is the table? Yes.
430 00:32:43.090 ⇒ 00:32:43.860 Demilade Agboola: 15.
431 00:32:43.980 ⇒ 00:32:48.850 Demilade Agboola: So it’s saying first versus repeat order revenue is found using this table.
432 00:32:50.570 ⇒ 00:32:51.770 Demilade Agboola: That’s what I’m trying to say.
433 00:32:52.030 ⇒ 00:32:57.099 Demilade Agboola: So if you’re a bit confused as to, like, okay, I can see the month data, I can see the measure values.
434 00:32:57.240 ⇒ 00:33:04.570 Demilade Agboola: I can see all of this, but I don’t really know what table we’re using to create this when there are multiple tables. It will be highlighted for you.
435 00:33:05.630 ⇒ 00:33:06.409 Mustafa Raja: Yep.
436 00:33:07.530 ⇒ 00:33:10.470 Demilade Agboola: Okay, so let’s look at data sources…
437 00:33:15.140 ⇒ 00:33:19.270 Mustafa Raja: Is there a way to download this table in some sort of format?
438 00:33:19.720 ⇒ 00:33:27.659 Mustafa Raja: Like, can I, can I, what’s it called, download this workbook as TBW, TWBX?
439 00:33:28.300 ⇒ 00:33:29.410 Demilade Agboola: Is that a problem?
440 00:33:29.480 ⇒ 00:33:30.200 Mustafa Raja: Yeah.
441 00:33:30.540 ⇒ 00:33:31.820 Mustafa Raja: Because that one…
442 00:33:32.080 ⇒ 00:33:37.589 Mustafa Raja: That way, I may be able to, you know, give it to… what’s it called, cursor, and then…
443 00:33:38.090 ⇒ 00:33:41.759 Demilade Agboola: Oh, yeah, yeah, that would… that’s a good idea.
444 00:33:42.120 ⇒ 00:33:45.660 Demilade Agboola: Obviously, a couple of ways you could go about it. You could… if you open…
445 00:33:46.620 ⇒ 00:33:51.160 Demilade Agboola: The dashboard, so if you come in here, so, like, you know how you opened it.
446 00:33:51.390 ⇒ 00:33:53.039 Demilade Agboola: Click into the dashboard.
447 00:33:53.530 ⇒ 00:33:57.699 Demilade Agboola: You can then… Download that Tableau workbook, that’s TWB.
448 00:33:57.700 ⇒ 00:33:58.490 Mustafa Raja: Hmm.
449 00:33:58.850 ⇒ 00:34:00.310 Mustafa Raja: Nice. Okay, okay.
450 00:34:00.690 ⇒ 00:34:02.680 Demilade Agboola: This is good.
451 00:34:07.890 ⇒ 00:34:14.680 Mustafa Raja: Okay, and then there was one other thing. Okay, do you have,
452 00:34:15.210 ⇒ 00:34:26.599 Mustafa Raja: Let’s find one table that’s using multiple… sorry, not a table, let’s find a chart that’s using multiple tables, because I want to see…
453 00:34:27.110 ⇒ 00:34:30.800 Mustafa Raja: If I’ll be able to, you know… Find that…
454 00:34:31.250 ⇒ 00:34:32.820 Demilade Agboola: Bruh, let’s try and do.
455 00:34:36.469 ⇒ 00:34:39.999 Mustafa Raja: What does sheet mean in Tableau?
456 00:34:40.620 ⇒ 00:34:43.430 Demilade Agboola: of it, like, it’s kind of like work…
457 00:34:43.800 ⇒ 00:34:48.459 Demilade Agboola: query, like, you know how in Omni you have, like, query slash work, like, sheets? I don’t know how to explain.
458 00:34:48.600 ⇒ 00:34:51.890 Demilade Agboola: You know how in a dashboard, the dashboard is made up of multiple…
459 00:34:52.179 ⇒ 00:34:54.780 Demilade Agboola: What do they call it in Omni? What’s the word they use in Omni?
460 00:34:55.800 ⇒ 00:34:56.730 Demilade Agboola: Pardon?
461 00:34:57.060 ⇒ 00:34:57.930 Mustafa Raja: Topics?
462 00:34:58.510 ⇒ 00:35:04.559 Demilade Agboola: No, not topics. When you click into a topic, you create the… let me… let me just open on me.
463 00:35:17.750 ⇒ 00:35:19.330 Mustafa Raja: You shouldn’t have…
464 00:35:19.330 ⇒ 00:35:21.760 Demilade Agboola: Yeah, it’s my… it’s actually my personal notes.
465 00:35:23.710 ⇒ 00:35:27.869 Demilade Agboola: Something personal. What’s the… Keep making no mistake.
466 00:35:28.010 ⇒ 00:35:33.970 Demilade Agboola: So you know how, like, in a dashboard, Let’s see, metrics dashboard.
467 00:35:35.040 ⇒ 00:35:40.940 Demilade Agboola: Each of these are one nutshell, like, each dashboard is made up of one…
468 00:35:44.790 ⇒ 00:35:47.359 Mustafa Raja: Yeah, one tab in the workflow… workbook, right?
469 00:35:47.750 ⇒ 00:35:50.310 Demilade Agboola: Yeah… I don’t know what they call it.
470 00:35:50.310 ⇒ 00:35:51.879 Mustafa Raja: Yeah, I don’t either.
471 00:35:51.880 ⇒ 00:35:56.199 Demilade Agboola: It says it’s a workbook, but it’s, like, each of these things are…
472 00:35:56.690 ⇒ 00:35:58.249 Mustafa Raja: Yeah, a tab in there.
473 00:35:58.680 ⇒ 00:35:59.360 Demilade Agboola: Yeah.
474 00:35:59.810 ⇒ 00:36:03.380 Demilade Agboola: So that’s… this… each of these things are technically sheets in Tableau.
475 00:36:03.800 ⇒ 00:36:04.689 Mustafa Raja: Okay, okay.
476 00:36:04.860 ⇒ 00:36:05.740 Mustafa Raja: Yes.
477 00:36:06.340 ⇒ 00:36:07.420 Mustafa Raja: This makes sense.
478 00:36:08.440 ⇒ 00:36:10.259 Demilade Agboola: Alright, so that’s when it has to be clear.
479 00:36:11.040 ⇒ 00:36:12.269 Demilade Agboola: I thought, oh…
480 00:36:14.290 ⇒ 00:36:18.159 Mustafa Raja: And this is, this is also using only one table, right? This chart.
481 00:36:19.190 ⇒ 00:36:22.980 Demilade Agboola: Yeah, it looks like it, because I remember building out this table for…
482 00:36:24.900 ⇒ 00:36:27.410 Demilade Agboola: I think at that point it was, Annie.
483 00:36:29.000 ⇒ 00:36:30.090 Demilade Agboola: Did you miss Annie?
484 00:36:31.510 ⇒ 00:36:38.460 Mustafa Raja: I think, I’ve, she was… she was here when… when I joined for a few months.
485 00:36:38.460 ⇒ 00:36:38.779 Demilade Agboola: to them.
486 00:36:38.780 ⇒ 00:36:43.000 Mustafa Raja: No, but I never got to, you know… Work with them.
487 00:36:43.640 ⇒ 00:36:44.860 Demilade Agboola: Oh, okay.
488 00:36:45.330 ⇒ 00:36:49.590 Demilade Agboola: Yeah, I worked with her a couple of times, she was really, she was really, really nice.
489 00:36:52.300 ⇒ 00:36:53.360 Demilade Agboola: Really, really nice.
490 00:36:59.930 ⇒ 00:37:00.560 Mustafa Raja: Yeah.
491 00:37:00.560 ⇒ 00:37:03.609 Demilade Agboola: Two data sources, let’s see…
492 00:37:06.040 ⇒ 00:37:14.740 Mustafa Raja: It would have been nice to see which, you know, which tables, if graph is using multiple tables or not in this view, you know.
493 00:37:15.260 ⇒ 00:37:17.999 Demilade Agboola: Yeah, I think… I think this is using multiple tables, so I wanted to check.
494 00:37:18.000 ⇒ 00:37:18.580 Mustafa Raja: Boom.
495 00:37:19.780 ⇒ 00:37:23.740 Mustafa Raja: Yeah, this looks like it might be using the multiple tables.
496 00:37:26.050 ⇒ 00:37:28.029 Demilade Agboola: Give me one second, let’s see…
497 00:37:58.040 ⇒ 00:38:02.900 Demilade Agboola: Okay, so we have this, let’s say this, so there’s basically, like, a couple charts.
498 00:38:03.420 ⇒ 00:38:06.240 Demilade Agboola: So we have this chart, let’s click into it.
499 00:38:06.450 ⇒ 00:38:12.540 Demilade Agboola: Let’s see… what it does. Alright, so a couple of things,
500 00:38:16.890 ⇒ 00:38:21.129 Demilade Agboola: We can see that there is… Something called a…
501 00:38:22.740 ⇒ 00:38:28.380 Demilade Agboola: So you can see that it’s highlighted, right? And we can see that what is highlighted is fact transactions plus deem products.
502 00:38:29.060 ⇒ 00:38:29.900 Mustafa Raja: Yeah.
503 00:38:30.360 ⇒ 00:38:35.869 Demilade Agboola: Alright, so if we have two different tables, if you go into BigQuery, you will see that we have
504 00:38:36.550 ⇒ 00:38:38.210 Demilade Agboola: Black transactions…
505 00:38:44.010 ⇒ 00:38:45.540 Demilade Agboola: My bad, I didn’t close.
506 00:38:46.910 ⇒ 00:38:49.000 Demilade Agboola: And then, so that’s one table here.
507 00:38:50.570 ⇒ 00:38:52.520 Demilade Agboola: And then, then we have Doom Products.
508 00:38:53.070 ⇒ 00:38:55.719 Demilade Agboola: So this table basically is in two different tables.
509 00:38:57.630 ⇒ 00:38:59.230 Mustafa Raja: Oh, okay, okay.
510 00:38:59.850 ⇒ 00:39:06.079 Demilade Agboola: So, Dean Products is, like, it just explains what’s going on in the product, so that’s what was being used to make…
511 00:39:06.930 ⇒ 00:39:07.930 Demilade Agboola: this table.
512 00:39:08.170 ⇒ 00:39:11.429 Mustafa Raja: Okay, so, backgrounds, I think… So…
513 00:39:12.180 ⇒ 00:39:16.779 Mustafa Raja: That’s a weird way to represent using multiple tables.
514 00:39:17.110 ⇒ 00:39:21.340 Demilade Agboola: Yes, so now you can see that we have the join of our transactions on the products.
515 00:39:21.340 ⇒ 00:39:27.420 Mustafa Raja: Okay, do we, do we know, join is on what, what fields? And what sort of join is this?
516 00:39:27.960 ⇒ 00:39:29.890 Demilade Agboola: Yeah, so that is…
517 00:39:30.450 ⇒ 00:39:34.030 Mustafa Raja: I think it showed when you hovered over the, you know…
518 00:39:34.030 ⇒ 00:39:37.610 Demilade Agboola: Yeah, yeah, I’m just doing edit, but I’m not gonna actually edit it.
519 00:39:47.720 ⇒ 00:39:50.120 Mustafa Raja: And then after this, I have my last question.
520 00:39:50.280 ⇒ 00:39:51.700 Mustafa Raja: Once we get through this…
521 00:39:55.640 ⇒ 00:39:58.599 Demilade Agboola: Alright, so you can see the join…
522 00:39:58.600 ⇒ 00:40:06.989 Mustafa Raja: I see. So, artificial product, something, and artificial product, something. Exactly. Artificial product ID, and artificial product, okay, okay.
523 00:40:06.990 ⇒ 00:40:09.760 Demilade Agboola: Yeah, so that’s the drain. It’s nothing crazy.
524 00:40:10.240 ⇒ 00:40:11.380 Demilade Agboola: It’s a…
525 00:40:11.380 ⇒ 00:40:14.660 Mustafa Raja: How do we know it’s left or right, or, you know?
526 00:40:15.360 ⇒ 00:40:17.379 Mustafa Raja: The join is left to right.
527 00:40:18.100 ⇒ 00:40:20.780 Demilade Agboola: That is…
528 00:40:25.030 ⇒ 00:40:27.279 Demilade Agboola: Okay, one second, trying to think.
529 00:40:27.280 ⇒ 00:40:27.930 Mustafa Raja: Yeah, yeah.
530 00:40:31.680 ⇒ 00:40:44.870 Mustafa Raja: I mean, we could save time, and you could, you could, you know, maybe let me know in, let me know async on how I can identify that, and we could move to the last question, since we have 5 minutes only left.
531 00:40:45.690 ⇒ 00:40:51.340 Demilade Agboola: Okay, sure. I believe… yeah… I think it’s… they use relationships?
532 00:40:52.460 ⇒ 00:40:54.750 Demilade Agboola: Aunt’s relationships are different from John.
533 00:40:54.750 ⇒ 00:40:56.799 Mustafa Raja: traditional diagonal football, you know.
534 00:40:56.800 ⇒ 00:40:57.395 Demilade Agboola: What?
535 00:40:58.460 ⇒ 00:41:01.979 Demilade Agboola: Yeah, so you don’t need to define joint types, basically.
536 00:41:03.890 ⇒ 00:41:09.390 Mustafa Raja: So you don’t need to define it for less, so you don’t see a Venn diagram when you… well.
537 00:41:10.340 ⇒ 00:41:12.070 Demilade Agboola: Yeah, but I’ll just tell you this.
538 00:41:12.070 ⇒ 00:41:13.220 Mustafa Raja: That makes sense, though.
539 00:41:14.390 ⇒ 00:41:19.899 Demilade Agboola: Don’t worry about this. What I will just tell you, this, like, just basic principles of, like, modeling.
540 00:41:20.310 ⇒ 00:41:23.589 Demilade Agboola: Is the fact trans… the fact table will always be…
541 00:41:24.500 ⇒ 00:41:27.149 Demilade Agboola: The base table that you were left joined to.
542 00:41:27.740 ⇒ 00:41:29.960 Demilade Agboola: Any dimensional table.
543 00:41:29.960 ⇒ 00:41:30.460 Mustafa Raja: Yeah, okay.
544 00:41:30.460 ⇒ 00:41:33.059 Demilade Agboola: So that’s… that’s principles of, like, data modeling.
545 00:41:33.340 ⇒ 00:41:44.420 Mustafa Raja: Okay, okay, yeah, this makes sense. And then, to my last question, do you have a rough idea on, what sort of topics should I be, you know, creating?
546 00:41:49.750 ⇒ 00:41:51.419 Demilade Agboola: Let’s just quickly do a quick…
547 00:41:51.810 ⇒ 00:42:00.170 Demilade Agboola: run-through of some of the data that we have, so I have some context of… Thanks.
548 00:42:06.950 ⇒ 00:42:08.010 Demilade Agboola: products.
549 00:42:13.080 ⇒ 00:42:13.970 Demilade Agboola: There’s a claim.
550 00:42:24.410 ⇒ 00:42:25.850 Demilade Agboola: Let me just cross-fill.
551 00:42:26.880 ⇒ 00:42:28.980 Demilade Agboola: Yeah, to, like, product information.
552 00:42:41.290 ⇒ 00:42:46.020 Demilade Agboola: Data sources, so there’s the order journey. Okay, so this is slightly different.
553 00:42:46.370 ⇒ 00:43:01.090 Mustafa Raja: Okay, I’m wondering, when I download this, Tableau workbook, right, in Tableau format, does that also, include the data source that it’s going to be using?
554 00:43:01.680 ⇒ 00:43:02.310 Demilade Agboola: Yes.
555 00:43:03.010 ⇒ 00:43:15.389 Mustafa Raja: Okay, then I’m wondering if this would be a good pass for me to sort of download all of these, or at least P0s, since, for now I’m working only with P0s, right? So, for P0s.
556 00:43:15.390 ⇒ 00:43:24.770 Mustafa Raja: And then I could give it a cursor, and then let me… cursor, suggest me, you know, what sort of topics, you know, and which tables belong to what topics.
557 00:43:25.440 ⇒ 00:43:26.050 Demilade Agboola: Okay.
558 00:43:26.050 ⇒ 00:43:26.900 Mustafa Raja: In the frontal?
559 00:43:27.090 ⇒ 00:43:44.630 Mustafa Raja: And do you know, I might not have definitions for all of the topics, you know? Sorry, not topics, but tables, right? So, I might not have definitions for all of the tables. So, are the definitions for the tables documented somewhere?
560 00:43:46.210 ⇒ 00:43:49.940 Mustafa Raja: You know, or the purpose of each table, right?
561 00:43:50.350 ⇒ 00:43:51.800 Demilade Agboola: The purpose…
562 00:43:51.800 ⇒ 00:43:58.520 Mustafa Raja: It is, I believe, that sort of context we might need, for Cursor to, you know, brew up something.
563 00:43:59.270 ⇒ 00:44:02.630 Demilade Agboola: Yeah, I get what you mean. I’m also kind.
564 00:44:18.480 ⇒ 00:44:20.100 Demilade Agboola: Alright, yeah, you can use this.
565 00:44:20.100 ⇒ 00:44:21.990 Mustafa Raja: Oh, this… okay.
566 00:44:22.100 ⇒ 00:44:26.740 Mustafa Raja: Core metrics, where, data source, data pipeline, hmm…
567 00:44:29.050 ⇒ 00:44:30.980 Mustafa Raja: Do you think this is enough context?
568 00:44:32.230 ⇒ 00:44:34.330 Demilade Agboola: I think so.
569 00:44:34.850 ⇒ 00:44:41.069 Demilade Agboola: For every metric that is being used to define stuff, we have the table that has it and all of that, so that can help.
570 00:44:41.470 ⇒ 00:44:45.620 Demilade Agboola: I think… The only question is, obviously.
571 00:44:46.760 ⇒ 00:44:50.920 Demilade Agboola: Things like… or using arrows to represent things might be a bit tricky.
572 00:44:51.370 ⇒ 00:44:58.480 Demilade Agboola: But, like, I think in terms of, like, the… just the final data warehouse, and, like, the information, and, like, what it’s being used for…
573 00:44:58.930 ⇒ 00:45:03.280 Demilade Agboola: like, NAOV, all of that, like, it… you can find it. What…
574 00:45:03.400 ⇒ 00:45:10.060 Demilade Agboola: Dashboard, and what metrics build out? Like, what… What models build our dashboards?
575 00:45:10.220 ⇒ 00:45:12.140 Demilade Agboola: That will give you some context, too.
576 00:45:12.880 ⇒ 00:45:20.779 Mustafa Raja: Okay, okay, yeah, just, can you also, you know, copy this link to my, my Slack, you know?
577 00:45:21.070 ⇒ 00:45:21.850 Mustafa Raja: Yeah.
578 00:45:21.850 ⇒ 00:45:24.180 Demilade Agboola: Sure. Still the same… still the same, like…
579 00:45:24.600 ⇒ 00:45:31.030 Mustafa Raja: Yeah, I just don’t want to, you know, look into each tab and finally get to the…
580 00:45:31.030 ⇒ 00:45:31.830 Demilade Agboola: That’s open.
581 00:45:32.010 ⇒ 00:45:32.960 Demilade Agboola: Just answer.
582 00:45:33.570 ⇒ 00:45:37.319 Mustafa Raja: Oh, thank you. Yeah, I guess… I guess this is good.
583 00:45:37.600 ⇒ 00:45:42.020 Mustafa Raja: I might ping you, if I have any questions, though.
584 00:45:43.760 ⇒ 00:45:45.199 Demilade Agboola: Okay, alright, sounds good.
585 00:45:45.750 ⇒ 00:45:47.139 Mustafa Raja: Thank you. Have a good day.
586 00:45:47.140 ⇒ 00:45:48.720 Demilade Agboola: Okay. Alright.
587 00:45:48.930 ⇒ 00:45:50.030 Demilade Agboola: Yes, great.