Meeting Title: Data Service Standup Date: 2026-01-22 Meeting participants: Awaish Kumar, Ashwini Sharma, Mustafa Raja, Demilade Agboola, Uttam Kumaran
WEBVTT
1 00:00:23.230 ⇒ 00:00:24.300 Ashwini Sharma: Hey, everybody.
2 00:00:31.450 ⇒ 00:00:32.299 Ashwini Sharma: Hello.
3 00:00:50.470 ⇒ 00:00:51.200 Mustafa Raja: Hey.
4 00:00:51.980 ⇒ 00:00:52.980 Ashwini Sharma: Hey, Mustafa.
5 00:00:53.320 ⇒ 00:00:54.740 Mustafa Raja: Hey, how are you?
6 00:00:55.080 ⇒ 00:00:56.399 Ashwini Sharma: I’m good, man. How are you?
7 00:00:57.000 ⇒ 00:00:58.050 Mustafa Raja: Doing good.
8 00:00:58.790 ⇒ 00:01:00.109 Mustafa Raja: It’s raining here.
9 00:01:00.820 ⇒ 00:01:02.320 Ashwini Sharma: Oh, raining.
10 00:01:02.630 ⇒ 00:01:03.310 Mustafa Raja: Yeah.
11 00:01:03.500 ⇒ 00:01:05.339 Ashwini Sharma: Winter. Bad.
12 00:01:05.349 ⇒ 00:01:09.829 Mustafa Raja: I already don’t like winter and it’s raining.
13 00:01:14.619 ⇒ 00:01:15.879 Mustafa Raja: How’s the weather there?
14 00:01:16.620 ⇒ 00:01:17.980 Ashwini Sharma: It’s getting warmer.
15 00:01:18.160 ⇒ 00:01:19.339 Mustafa Raja: Oh, that’s nice.
16 00:01:19.340 ⇒ 00:01:25.220 Ashwini Sharma: Yeah, it’s getting slightly warmer. But yeah, I mean, I think by the end of January, we’ll know.
17 00:01:25.400 ⇒ 00:01:27.660 Ashwini Sharma: Whether the winter is really over or not.
18 00:01:28.080 ⇒ 00:01:28.940 Mustafa Raja: Yeah.
19 00:01:29.150 ⇒ 00:01:31.689 Mustafa Raja: And do you like it, the winter?
20 00:01:31.690 ⇒ 00:01:35.390 Ashwini Sharma: No, no, no, I don’t like winter. I like summer only.
21 00:01:35.600 ⇒ 00:01:41.530 Mustafa Raja: I don’t like summer either, I like… I like the weather in between winter and summer, you know?
22 00:01:41.740 ⇒ 00:01:43.110 Ashwini Sharma: Here, there is no in-between.
23 00:01:43.110 ⇒ 00:01:46.370 Mustafa Raja: It’s a little bit of itself.
24 00:01:49.990 ⇒ 00:01:56.029 Ashwini Sharma: Like, my AC has been running since, what, like, February end?
25 00:01:56.820 ⇒ 00:02:01.440 Ashwini Sharma: Or maybe March 1st week, till… Till December.
26 00:02:01.440 ⇒ 00:02:02.560 Awaish Kumar: Hi, everyone.
27 00:02:02.810 ⇒ 00:02:03.820 Mustafa Raja: Hey…
28 00:02:03.970 ⇒ 00:02:04.820 Ashwini Sharma: Yeah, we…
29 00:02:07.390 ⇒ 00:02:08.770 Awaish Kumar: I… hello?
30 00:02:09.250 ⇒ 00:02:09.910 Mustafa Raja: Hey…
31 00:02:10.870 ⇒ 00:02:11.480 Awaish Kumar: Okay.
32 00:02:12.370 ⇒ 00:02:13.000 Ashwini Sharma: Bye.
33 00:02:13.440 ⇒ 00:02:16.400 Awaish Kumar: How was your… Day yesterday.
34 00:02:18.380 ⇒ 00:02:27.170 Demilade Agboola: Pretty good. How’s everyone doing? I had a doctor’s appointment, so my day was full of, like, blood tests and just other…
35 00:02:27.410 ⇒ 00:02:33.979 Demilade Agboola: It’s just a bunch of tests, just to be sure I was good. Good news is I’m fine. Everything is good, I’m fine. I’m healthy, so that’s… that’s good.
36 00:02:35.240 ⇒ 00:02:35.800 Awaish Kumar: That’s…
37 00:02:37.690 ⇒ 00:02:38.880 Demilade Agboola: How’s everyone doing?
38 00:02:39.470 ⇒ 00:02:40.609 Awaish Kumar: Yeah, I’m good.
39 00:02:41.950 ⇒ 00:02:42.890 Mustafa Raja: Yeah, I’m good.
40 00:02:52.700 ⇒ 00:02:55.959 Awaish Kumar: Okay, since we are here, I can sort.
41 00:02:56.130 ⇒ 00:03:01.869 Awaish Kumar: I wanted to start with the… Oh, Magic Spoon.
42 00:03:06.770 ⇒ 00:03:11.950 Awaish Kumar: And, yeah, yeah. Demi, you wanna go?
43 00:03:13.860 ⇒ 00:03:23.899 Demilade Agboola: So for me, I have sent the full dbt audio doc to Otam. Otam’s going to, like.
44 00:03:24.090 ⇒ 00:03:26.759 Demilade Agboola: Look at it and just be able to get back to them.
45 00:03:27.060 ⇒ 00:03:30.870 Demilade Agboola: And I’m currently working on the dbt optimization.
46 00:03:31.000 ⇒ 00:03:41.199 Demilade Agboola: But just generally, Magic Spoon seemed excited. I know that, Otam was able to talk to the Magic Spoon team yesterday, Mary in particular.
47 00:03:41.420 ⇒ 00:03:48.349 Demilade Agboola: And she seems pretty excited about what we’re doing. She… deliverables, she’s looking forward to our DWT.
48 00:03:48.690 ⇒ 00:04:00.459 Demilade Agboola: optimization, as well as just, getting the spins data in. And for both of them, we’re very close to the end, so I think, we’re in a good spot with Magic Spoon, and they seem happy.
49 00:04:01.270 ⇒ 00:04:08.159 Awaish Kumar: Okay, yeah, that’s… That’s… he just mentioned.
50 00:04:09.630 ⇒ 00:04:13.830 Demilade Agboola: Yeah, so once the review is done from Utama, I’ll send it to them, and…
51 00:04:14.020 ⇒ 00:04:18.279 Demilade Agboola: I’m currently working on the… the implementation of the…
52 00:04:19.570 ⇒ 00:04:24.860 Demilade Agboola: review suggestions, basically, so… or the audit suggestions, so we should be able to get this done
53 00:04:25.290 ⇒ 00:04:26.430 Demilade Agboola: I know the door.
54 00:04:27.960 ⇒ 00:04:32.100 Awaish Kumar: Okay, so, yeah, in that case, I think we are good here.
55 00:04:32.240 ⇒ 00:04:42.819 Awaish Kumar: But, yeah, I… I don’t know, like, this prefect pipeline kind of thing, like, I, like…
56 00:04:43.010 ⇒ 00:04:47.519 Awaish Kumar: I, I, I… maybe we need a pairing session or whatever, like, we need to close it.
57 00:04:50.440 ⇒ 00:05:09.530 Awaish Kumar: maybe we can do a little bit more of, like, spend some more time as a team to figure out what’s happening, what’s going on. So I have already asked Ishwani to come up with a document where he can say, like, what he has already tried, so we don’t spend redoing the work, but we can just review it, and then
58 00:05:09.550 ⇒ 00:05:15.190 Awaish Kumar: I’ll move on with our suggestions, and we can just… Close it, really soon.
59 00:05:16.540 ⇒ 00:05:21.309 Ashwini Sharma: So, yeah, I had a talk with Michael yesterday, right? And
60 00:05:21.660 ⇒ 00:05:25.660 Ashwini Sharma: So, the initial increase in the number of measures and attributes.
61 00:05:25.770 ⇒ 00:05:28.540 Awaish Kumar: That caused the pipeline to fail.
62 00:05:28.680 ⇒ 00:05:42.089 Ashwini Sharma: And it also caused the, you know, GraphQL limit to exceed. So the GraphQL folks, the Spins folks, they increased the limit, so now I was able to load a subset of the data after discussing yesterday with Michael and…
63 00:05:42.100 ⇒ 00:05:50.730 Ashwini Sharma: And the other guy, right? So, we loaded a subset of the data with all measures and additional attributes, right?
64 00:05:50.780 ⇒ 00:06:06.619 Ashwini Sharma: That has been loaded. Now, the next step is they will go through that table, and then they will take a call on whether to keep certain attributes, to remove certain measures, things like that, right? And then, yesterday also we discussed the large volume of data being loaded in the initial load.
65 00:06:06.720 ⇒ 00:06:11.990 Ashwini Sharma: So, for that, we’ll have to think through on how we can, you know.
66 00:06:12.150 ⇒ 00:06:18.390 Ashwini Sharma: Scale it for, scale this pipeline for… for the entire, entire extract.
67 00:06:19.200 ⇒ 00:06:24.050 Awaish Kumar: Yeah, that was the actual point, that how we can optimize it for…
68 00:06:24.330 ⇒ 00:06:29.879 Awaish Kumar: For scaling, like, even if we add more features, maybe we can play with the date ranges or some… something?
69 00:06:30.030 ⇒ 00:06:38.080 Awaish Kumar: To minimize the volume of the data in one call, so that it processes it, and then we maybe do it iteratively.
70 00:06:38.330 ⇒ 00:06:39.970 Awaish Kumar: Right? Something like that.
71 00:06:40.370 ⇒ 00:06:49.920 Ashwini Sharma: So, yeah, I mean, like, those initial thoughts, I’ve already tried. I’ll list out what all I have tried, right? And then, after that, if we can think of something else.
72 00:06:50.080 ⇒ 00:06:52.989 Ashwini Sharma: Maybe we can do that, right? .
73 00:06:53.410 ⇒ 00:06:54.540 Awaish Kumar: Okay. But, yeah.
74 00:06:54.540 ⇒ 00:06:58.639 Ashwini Sharma: I’ll create that document, basically, just a write-up of small
75 00:06:58.870 ⇒ 00:07:05.660 Ashwini Sharma: small write of indicating, like, what all I have done, what all techniques I have tried, and all of them have failed.
76 00:07:05.930 ⇒ 00:07:07.010 Awaish Kumar: Okay, sure.
77 00:07:08.810 ⇒ 00:07:13.330 Awaish Kumar: Okay, and then we can discuss CTA.
78 00:07:15.290 ⇒ 00:07:20.420 Ashwini Sharma: So, CTA, I have started loading some of the new datasets that,
79 00:07:20.980 ⇒ 00:07:27.780 Ashwini Sharma: That, Catherine has added into S3, and I’ve created some additional tickets to load remaining datasets,
80 00:07:28.690 ⇒ 00:07:31.330 Ashwini Sharma: I cannot see them over here.
81 00:07:34.050 ⇒ 00:07:38.409 Ashwini Sharma: So, Avish, you will… you will also be doing something on the CTA front, right?
82 00:07:39.150 ⇒ 00:07:41.070 Awaish Kumar: Yeah, but… Hmm.
83 00:07:41.240 ⇒ 00:07:52.619 Awaish Kumar: Yeah, for me to come on and work on some tickets is, like, more like, we need to have a plan, like, what needs to be done this week, and then you can assign me some tickets.
84 00:07:52.730 ⇒ 00:07:56.810 Awaish Kumar: Like, what I can take, and then, yeah, I can deliver that. So…
85 00:07:56.940 ⇒ 00:08:02.629 Ashwini Sharma: you have some… you have, right, read access to AWS? I mean, login access to AWS?
86 00:08:03.460 ⇒ 00:08:06.249 Ashwini Sharma: Probably not. I don’t, like, I have…
87 00:08:06.810 ⇒ 00:08:14.010 Awaish Kumar: perceive that, like, you should be… if you have access, like, if it is one pass, I can just go in, but if it is…
88 00:08:14.010 ⇒ 00:08:24.619 Uttam Kumaran: It’s all… it’s all SSO through their Okta, so maybe… I sent a note yesterday requesting maybe a way she can just double… double up on that. Okay.
89 00:08:24.730 ⇒ 00:08:29.110 Uttam Kumaran: Yeah, it’s like… yeah, it’s all our own credentials.
90 00:08:31.620 ⇒ 00:08:37.399 Awaish Kumar: Okay, but like… What’s the… plan? What… what are something for me?
91 00:08:38.830 ⇒ 00:08:39.539 Awaish Kumar: AWS access.
92 00:08:39.549 ⇒ 00:08:43.699 Ashwini Sharma: So, there are a bunch of CSV files in S3.
93 00:08:43.859 ⇒ 00:08:51.249 Ashwini Sharma: We need to load them into tables, right? So if you can take a couple of them, I think that that will speed up the overall thing.
94 00:08:53.030 ⇒ 00:08:57.450 Uttam Kumaran: Once you get access, we can just discuss in Slack.
95 00:08:57.690 ⇒ 00:09:08.440 Uttam Kumaran: You’ll start to see the format. Basically, we need to load a bunch of flat files, produce a summary report that the CTA team is going to take and go display in Power BI.
96 00:09:08.590 ⇒ 00:09:14.200 Uttam Kumaran: So we’re just driving towards that objective. It’ll make more sense when you see the files.
97 00:09:14.580 ⇒ 00:09:21.600 Uttam Kumaran: Okay. But ultimately, yeah, we decided yesterday that they’re not gonna give us access to Power BI, they have some licensing issues.
98 00:09:21.880 ⇒ 00:09:25.910 Uttam Kumaran: So, we’re gonna just focus on producing those summary reports.
99 00:09:26.680 ⇒ 00:09:30.290 Awaish Kumar: Okay, and so we are just trying to do that, like.
100 00:09:31.490 ⇒ 00:09:37.929 Awaish Kumar: like, whatever ways we can, or we are looking to come up with some ETL plan, tool, or plan, or something?
101 00:09:38.190 ⇒ 00:09:43.049 Uttam Kumaran: So… so right now, these are all flat files that we just need to do one time.
102 00:09:43.050 ⇒ 00:09:46.319 Awaish Kumar: Okay. Because we have a report that we’re trying to help them get out.
103 00:09:46.320 ⇒ 00:09:55.610 Uttam Kumaran: Basically, after that, we’re gonna think through… basically, they’re gonna keep S3 as the data lake, and then we’re gonna… we’re gonna move things from S3
104 00:09:55.750 ⇒ 00:10:05.669 Uttam Kumaran: into Snowflake, and then model in Snowflake. So we already have all the core, sort of, modeling infrastructure set up. Right now they… yeah.
105 00:10:06.070 ⇒ 00:10:12.989 Awaish Kumar: for now, like, I need to move it to redshift, but afterwards, we are going to use Snowflake.
106 00:10:13.680 ⇒ 00:10:15.170 Uttam Kumaran: No, no, no, there’s no redshift.
107 00:10:15.170 ⇒ 00:10:17.819 Awaish Kumar: Okay, it needs to go to Snowflake right now, okay.
108 00:10:17.820 ⇒ 00:10:18.630 Uttam Kumaran: Yeah, correct.
109 00:10:20.730 ⇒ 00:10:34.340 Uttam Kumaran: There’s no, there’s no redshift at all, yeah. So, it needs to go into Snowflake. There’s just several different types of files that we need to load, so there’s, like, some schema mapping, and then we need to… and then Ashwini has the requirements for the final
110 00:10:34.340 ⇒ 00:10:42.390 Uttam Kumaran: Tables, but probably easily… more… probably the best thing is for him to do the final models, because it’s a lot of business logic.
111 00:10:42.420 ⇒ 00:10:50.180 Uttam Kumaran: And then, you can be a reviewer, and then, mainly, I think he needs help unloading some more of the files, because we got a bunch.
112 00:10:51.020 ⇒ 00:10:53.410 Awaish Kumar: Sure, I will… I will take that.
113 00:10:53.640 ⇒ 00:10:54.829 Uttam Kumaran: Okay, okay, fair.
114 00:10:54.830 ⇒ 00:11:04.229 Awaish Kumar: Okay, great. And yeah, that’s… I’m clear on what needs to be done, but, like, I just want this to be… this linear board to be reflect… reflection of what we are doing.
115 00:11:04.520 ⇒ 00:11:06.290 Awaish Kumar: Correct. Yeah, so…
116 00:11:06.290 ⇒ 00:11:15.189 Ashwini Sharma: I mean, most of the work that you see over here to do is going to be done later. I think the priority ones are…
117 00:11:15.510 ⇒ 00:11:17.919 Ashwini Sharma: Move it to next cycle? No, not next cycle.
118 00:11:17.920 ⇒ 00:11:19.530 Awaish Kumar: Next cycle, or whatever.
119 00:11:19.530 ⇒ 00:11:20.870 Ashwini Sharma: Something like backlog? Okay.
120 00:11:21.110 ⇒ 00:11:23.170 Awaish Kumar: We are moving to backlog, maybe. Okay.
121 00:11:23.360 ⇒ 00:11:24.100 Ashwini Sharma: Okay, alright.
122 00:11:26.730 ⇒ 00:11:29.359 Awaish Kumar: Okay, then we are on Element.
123 00:11:29.680 ⇒ 00:11:35.119 Awaish Kumar: So yeah, I’m planning on creating,
124 00:11:36.810 ⇒ 00:11:43.930 Awaish Kumar: like, final, like, fact order for Shopify, which basically have all the data for wholesale and e-commerce.
125 00:11:44.470 ⇒ 00:11:45.580 Awaish Kumar: And…
126 00:11:45.790 ⇒ 00:11:52.000 Awaish Kumar: Then, if we… if you want, like, me to create a summary view or something, which we created for wholesale.
127 00:11:52.160 ⇒ 00:11:55.260 Awaish Kumar: We can try to come up with something.
128 00:11:55.430 ⇒ 00:12:03.859 Awaish Kumar: By Monday, and we can show Shivani that, okay, that’s what we got from Shopify for e-commerce.
129 00:12:04.190 ⇒ 00:12:19.959 Awaish Kumar: And, like, that is mainly what we can do right now, like, on the modeling side, we… we don’t have data from other connectors yet. We only have Shopify. We do have recharge, but recharge data is kind of what we already have in Shopify.
130 00:12:21.450 ⇒ 00:12:25.849 Uttam Kumaran: Yeah, we, so I… so let’s just keep driving through for the Shopify piece, that’s okay.
131 00:12:25.850 ⇒ 00:12:26.480 Awaish Kumar: Okay.
132 00:12:26.880 ⇒ 00:12:27.450 Uttam Kumaran: Pushed up.
133 00:12:27.450 ⇒ 00:12:33.759 Awaish Kumar: Shopify, like… like, we… we… that’s all we can… that’s all we can do, like, create fact orders.
134 00:12:33.930 ⇒ 00:12:41.430 Awaish Kumar: DIM customer overall, and then some, summary tables, views like wholesale, right?
135 00:12:42.140 ⇒ 00:12:42.760 Uttam Kumaran: Yeah.
136 00:12:42.950 ⇒ 00:12:43.560 Awaish Kumar: Okay.
137 00:12:45.280 ⇒ 00:12:49.679 Awaish Kumar: Okay, that’s… that’s what I will be doing, on this.
138 00:12:50.180 ⇒ 00:12:55.780 Awaish Kumar: Apart from that, I… Yeah, like, we need to… I don’t know how…
139 00:12:55.930 ⇒ 00:13:01.139 Awaish Kumar: how far we went with the proposal? Should we nudge them again on, like, and listen.
140 00:13:01.140 ⇒ 00:13:14.510 Uttam Kumaran: Oh, yeah, so I talked to, yeah, so I spoke with, Shivani briefly after the meeting yesterday. She presented it, but most likely we’re not going to get feedback until next week, because she’s out next to… today and tomorrow.
141 00:13:14.510 ⇒ 00:13:14.890 Awaish Kumar: Okay.
142 00:13:14.890 ⇒ 00:13:16.700 Uttam Kumaran: So, yeah, but…
143 00:13:16.870 ⇒ 00:13:22.359 Uttam Kumaran: She said, like, she’ll… she’s gonna get feedback and come back to us with what the situation is.
144 00:13:22.720 ⇒ 00:13:23.500 Awaish Kumar: Okay.
145 00:13:23.500 ⇒ 00:13:26.920 Uttam Kumaran: And then, she’s not gonna be on tomorrow, so…
146 00:13:27.440 ⇒ 00:13:31.360 Uttam Kumaran: Like, we’re gonna… we’ll plan to present…
147 00:13:31.460 ⇒ 00:13:41.139 Uttam Kumaran: like, basically, we want to try to drive towards, like, those two models by, like, by Monday, you know? So we have some time. So if you send me some versions, I can review.
148 00:13:42.550 ⇒ 00:13:44.680 Awaish Kumar: Yes, yeah, I’m…
149 00:13:45.660 ⇒ 00:13:51.900 Awaish Kumar: Yeah, I’m doing some stuff for remote today, so maybe tomorrow I will come back on this.
150 00:13:52.410 ⇒ 00:13:53.260 Awaish Kumar: Okay.
151 00:13:54.470 ⇒ 00:14:00.729 Awaish Kumar: Yeah, and after that, yeah, yeah, I can share what… whatever progress I make.
152 00:14:01.600 ⇒ 00:14:02.300 Uttam Kumaran: Okay.
153 00:14:04.130 ⇒ 00:14:10.509 Awaish Kumar: We don’t have anything on… Urban Stamps, Readame.
154 00:14:10.980 ⇒ 00:14:15.710 Awaish Kumar: Then we have ABC, so I’ve already ingested the data for Evolve.
155 00:14:15.820 ⇒ 00:14:21.649 Awaish Kumar: That’s… that was the one-time, sync from a polyatomic
156 00:14:21.890 ⇒ 00:14:30.219 Awaish Kumar: to, like, like, SQL Server using Polytomic to our Google BigQuery, and I think we have those tables in BigQuery now.
157 00:14:32.540 ⇒ 00:14:33.260 Uttam Kumaran: Okay.
158 00:14:33.700 ⇒ 00:14:35.649 Awaish Kumar: Okay, yeah, yeah, if…
159 00:14:35.860 ⇒ 00:14:39.690 Uttam Kumaran: You can use that, Mustwa, like… That’s the stuff from Evolve?
160 00:14:40.460 ⇒ 00:14:41.280 Awaish Kumar: Sorry?
161 00:14:41.660 ⇒ 00:14:43.349 Uttam Kumaran: That’s the stuff from Evolve.
162 00:14:44.030 ⇒ 00:14:45.540 Awaish Kumar: Yeah, yeah, everything from…
163 00:14:45.540 ⇒ 00:14:48.450 Uttam Kumaran: How did you end up… how did you end up doing it?
164 00:14:49.430 ⇒ 00:14:50.920 Awaish Kumar: Yeah, and just use Bolitano.
165 00:14:51.150 ⇒ 00:14:53.360 Awaish Kumar: Okay, okay, great. That looks great.
166 00:14:53.560 ⇒ 00:14:55.400 Uttam Kumaran: Nice, okay, great.
167 00:14:58.350 ⇒ 00:15:01.880 Uttam Kumaran: And then, where are we at with the Google Analytics?
168 00:15:01.880 ⇒ 00:15:14.729 Mustafa Raja: Yeah, can you, let’s open that up. So, it’s blocked because, the BrainForge account that’s assigned to us does not have access to Google, Analytics, and,
169 00:15:14.850 ⇒ 00:15:27.390 Mustafa Raja: The access that we have are on personal Brainforge accounts, right? Which do not have access to, the BigQuery or Google Cloud Platform, so… What?
170 00:15:27.390 ⇒ 00:15:33.010 Uttam Kumaran: Why don’t… I don’t understand. Our accounts don’t have access to the… to BigQuery?
171 00:15:33.220 ⇒ 00:15:36.999 Mustafa Raja: Yeah, can you open the ticket up, Avish?
172 00:15:37.170 ⇒ 00:15:44.799 Mustafa Raja: I’ve added some… added a comment. So… So you… What the hell?
173 00:15:46.710 ⇒ 00:15:56.300 Mustafa Raja: Sorry. Okay, so, so your account, Amber’s account, and Zoran’s account has access to Google Analytics, but it’s not.
174 00:15:56.300 ⇒ 00:16:04.579 Uttam Kumaran: But isn’t the solution… isn’t the solution here just to get BigQuery? Like, how are we… how is Amber gonna use the data in BigQuery if she doesn’t have access?
175 00:16:05.210 ⇒ 00:16:10.300 Mustafa Raja: We have access to BigQuery, using the, Brainforge at Go and Twitter.
176 00:16:10.860 ⇒ 00:16:13.520 Uttam Kumaran: I know, but, like, what’s the problem in just giving us.
177 00:16:14.770 ⇒ 00:16:22.679 Mustafa Raja: I think, they have just not added us, in, in Google, Cloud Platform, sorry.
178 00:16:24.060 ⇒ 00:16:24.760 Uttam Kumaran: Okay.
179 00:16:25.200 ⇒ 00:16:37.969 Mustafa Raja: Yeah, so, if we can’t get access to Google Analytics on Bring4Chat, Go and Teeter, we can just ingest the Google Analytics in the, BigQuery.
180 00:16:39.860 ⇒ 00:16:40.650 Awaish Kumar: Oh.
181 00:16:41.680 ⇒ 00:16:42.230 Uttam Kumaran: Okay.
182 00:16:42.560 ⇒ 00:16:44.889 Mustafa Raja: So we, we do not have, like… Sorry?
183 00:16:44.890 ⇒ 00:16:47.370 Awaish Kumar: So, like, let me rephrase, like, Muswall.
184 00:16:47.620 ⇒ 00:16:52.650 Awaish Kumar: like, your account… or, like, Amber’s account have access to GF4, right?
185 00:16:53.010 ⇒ 00:16:55.090 Mustafa Raja: Yeah, but it’s not admin access.
186 00:16:55.670 ⇒ 00:16:58.760 Awaish Kumar: Okay, so we need admin access for that connection?
187 00:16:59.010 ⇒ 00:17:17.149 Mustafa Raja: Yeah, yeah, that’s correct. But admin access on Brainforge at GoAntEater.com. But, one other thing here is, Amber said that their Google Analytics is being managed by a third party, and they might be hesitant to give us admin access.
188 00:17:17.200 ⇒ 00:17:17.770 Awaish Kumar: Indeed.
189 00:17:17.770 ⇒ 00:17:20.690 Uttam Kumaran: No, that’s… that’s not… that’s not true, like…
190 00:17:21.280 ⇒ 00:17:29.429 Uttam Kumaran: I don’t… I just, like, don’t want us to… we’re making, like, way too many assumptions, like, on the simple, simple thing, like…
191 00:17:29.640 ⇒ 00:17:34.479 Uttam Kumaran: don’t know if they will give us admin. Like, Amber doesn’t know that, like…
192 00:17:35.600 ⇒ 00:17:35.980 Mustafa Raja: Okay.
193 00:17:35.980 ⇒ 00:17:43.160 Uttam Kumaran: You know, like, I’m interacting with those folks, and so they’re totally fine to give us whatever we need. But I guess, like.
194 00:17:44.120 ⇒ 00:17:56.680 Uttam Kumaran: Yeah, this is just, like, one thing I’m having here is, like, this is a very simple thing, like, you know, that we’re now, like, we’re now losing, like, so many days on, right? So there’s a couple… there’s a couple, like, if I just pull this one back…
195 00:17:56.720 ⇒ 00:18:06.159 Uttam Kumaran: Yeah. The goal is, like, to just sync Google Analytics to Bitcoin. Brainforge, I go in here, it doesn’t have access. Okay, so what are our options, right? The option…
196 00:18:06.570 ⇒ 00:18:08.070 Uttam Kumaran: Amber said, hey.
197 00:18:08.200 ⇒ 00:18:15.269 Uttam Kumaran: 3 people have access. Okay, so the first thing is, like, can we get those 3 people admin BigQuery access?
198 00:18:16.890 ⇒ 00:18:18.510 Mustafa Raja: Okay, I’ll take…
199 00:18:18.510 ⇒ 00:18:23.649 Awaish Kumar: The thing is, those three people don’t have admin access on GA4, we can’t do the sync.
200 00:18:24.030 ⇒ 00:18:26.099 Uttam Kumaran: No, we do have admin on GA4.
201 00:18:26.100 ⇒ 00:18:29.030 Awaish Kumar: I, I, okay, your account has admin access to GF4.
202 00:18:29.490 ⇒ 00:18:30.690 Uttam Kumaran: Yeah, all 3 of ours.
203 00:18:30.690 ⇒ 00:18:42.060 Awaish Kumar: Okay, then I… then I just can go in using this Brain4Jo and Teeter email, and add you as a user there in BigQuery, and then I can use your account for… for the.
204 00:18:42.060 ⇒ 00:18:48.700 Uttam Kumaran: Yeah, like, you could… yeah, like, 100 thou… 1,000%.
205 00:18:48.700 ⇒ 00:18:49.260 Mustafa Raja: Okay.
206 00:18:49.570 ⇒ 00:18:50.110 Mustafa Raja: Thank you.
207 00:18:50.320 ⇒ 00:18:51.660 Uttam Kumaran: So, like, so…
208 00:18:51.810 ⇒ 00:18:57.470 Uttam Kumaran: I… so, like, can we… can we conf… maybe we can stay on the call, let’s confirm at the end of the call that we can do that?
209 00:18:57.470 ⇒ 00:18:58.870 Mustafa Raja: Yeah, yeah, I’d love that.
210 00:18:59.650 ⇒ 00:19:03.329 Uttam Kumaran: Okay, okay, great. Yeah, so, like, I don’t know, I think maybe, like.
211 00:19:03.460 ⇒ 00:19:09.349 Uttam Kumaran: whenever there’s access issues, I really want us to, like, drive towards, like.
212 00:19:09.640 ⇒ 00:19:23.739 Uttam Kumaran: solving it, like, while we have, like, some momentum, right? Because this is yesterday afternoon, like, if someone would have pinged me, we could have probably figured this out yesterday. So… let’s just keep that in mind, that, like.
213 00:19:24.310 ⇒ 00:19:42.020 Uttam Kumaran: because I think… I think sometimes we get nervous about asking for access and things like that, and that’s probably… probably my fault, because, like, before, it used to be a little bit tougher, and we tried to get around that, but it’s not the case for every client, so… we just have to get our thoughts together, and then, like.
214 00:19:42.120 ⇒ 00:19:44.560 Uttam Kumaran: I think Awash is a good person to…
215 00:19:44.760 ⇒ 00:19:56.769 Uttam Kumaran: pray, give thoughts first, but then also, Mustafa, just, like, since this is… this is urgent, I would just, like, try to find a way to get in front of Awash, you know, and get… get your question answered.
216 00:19:56.770 ⇒ 00:19:57.860 Mustafa Raja: Okay.
217 00:19:57.860 ⇒ 00:20:00.759 Uttam Kumaran: You know, I know you pinged him in the thing, but…
218 00:20:01.110 ⇒ 00:20:02.960 Uttam Kumaran: Everyone’s very, very busy, so I’m
219 00:20:03.340 ⇒ 00:20:07.180 Uttam Kumaran: I don’t think anyone’s gonna mind pinging again and, like, figuring it out, you know?
220 00:20:07.180 ⇒ 00:20:07.820 Mustafa Raja: Okay.
221 00:20:08.400 ⇒ 00:20:09.190 Mustafa Raja: Yep.
222 00:20:09.520 ⇒ 00:20:12.450 Mustafa Raja: I’ll be more mindful, on these things.
223 00:20:12.570 ⇒ 00:20:13.130 Uttam Kumaran: Cool. Okay.
224 00:20:14.130 ⇒ 00:20:15.860 Mustafa Raja: Okay, and for…
225 00:20:15.860 ⇒ 00:20:21.719 Awaish Kumar: So, what are the next steps? Once we have evolved data there, GFO data there, then, like…
226 00:20:21.860 ⇒ 00:20:22.749 Awaish Kumar: Oh, only Amber?
227 00:20:22.750 ⇒ 00:20:29.969 Uttam Kumaran: Yeah, Amber, it’s blocking some, some, some, analysis that Amber needs to do by… for next Wednesday.
228 00:20:30.150 ⇒ 00:20:30.750 Awaish Kumar: Okay.
229 00:20:31.950 ⇒ 00:20:45.399 Mustafa Raja: And for the other one, there’s one more ticket over there. For this data, I have recorded the loom and, I’ve shared it in the engineering channel. I have tagged you and the Milade in there.
230 00:20:46.390 ⇒ 00:20:52.659 Mustafa Raja: Yeah, if you could take a look at that, and get back to me, that would be really nice.
231 00:20:52.940 ⇒ 00:20:55.509 Awaish Kumar: Okay, yeah, actually, I won’t do that today.
232 00:20:55.690 ⇒ 00:20:56.570 Mustafa Raja: Okay, thank you.
233 00:21:01.640 ⇒ 00:21:05.699 Awaish Kumar: Yeah, we can move on to default, and then…
234 00:21:07.610 ⇒ 00:21:11.209 Awaish Kumar: Yeah, Demi, you wanna go?
235 00:21:14.430 ⇒ 00:21:22.540 Demilade Agboola: So for default, yeah, I’m currently working on the dashboard for Salesforce data.
236 00:21:22.720 ⇒ 00:21:26.309 Demilade Agboola: I think… I should be able to finish that today.
237 00:21:26.410 ⇒ 00:21:35.260 Demilade Agboola: the… Overall client’s perspective is that they’ve, so far, they seem quite happy and excited about what we’re doing.
238 00:21:35.380 ⇒ 00:21:43.080 Demilade Agboola: Unfortunately, they still, in terms of, like, being able to select the tool, they seem like…
239 00:21:43.390 ⇒ 00:21:46.740 Demilade Agboola: slow with choosing, polyatomic.
240 00:21:46.980 ⇒ 00:21:57.609 Demilade Agboola: But they… we are planning a call, there’s a call on Friday with Polyatomic, so that’s tomorrow. Hopefully, we can get that over at the line, get any worries settled.
241 00:21:57.850 ⇒ 00:22:04.100 Demilade Agboola: And then we can get, polyatomic… Access by next week.
242 00:22:04.730 ⇒ 00:22:08.590 Demilade Agboola: Other than that, everything seems fine with the clients. They seem… they seem happy and fine.
243 00:22:10.000 ⇒ 00:22:14.680 Awaish Kumar: Okay, and we… do we have data platform documentation for this client?
244 00:22:15.740 ⇒ 00:22:16.590 Mustafa Raja: Yes.
245 00:22:17.400 ⇒ 00:22:17.940 Mustafa Raja: Yeah.
246 00:22:17.940 ⇒ 00:22:18.650 Demilade Agboola: Right.
247 00:22:18.920 ⇒ 00:22:19.580 Awaish Kumar: Okay.
248 00:22:20.060 ⇒ 00:22:27.709 Awaish Kumar: So, like, we have all the sources listed there, and… and marked, like, where we have the access, and for which sources we don’t have the access.
249 00:22:28.100 ⇒ 00:22:34.010 Demilade Agboola: Yeah, so we have that, and we’re trying to… one of the things we’re trying to do this week is push for access to certain platforms.
250 00:22:34.200 ⇒ 00:22:46.550 Demilade Agboola: But yeah, I would also just ping, Caitlin again today and just go, like, yo, we need access to this so we can start, like, verifying the access before, they sign the deal with Polyatomic.
251 00:22:47.400 ⇒ 00:22:51.860 Awaish Kumar: So, are these already done? Can we move it to done, or something?
252 00:22:52.350 ⇒ 00:22:58.110 Demilade Agboola: So for that one, I think, yeah, we could put that to Don.
253 00:22:58.440 ⇒ 00:23:00.379 Demilade Agboola: I believe. Oh, look at that.
254 00:23:01.880 ⇒ 00:23:02.510 Awaish Kumar: Okay.
255 00:23:03.790 ⇒ 00:23:15.269 Mustafa Raja: Okay, for the, for 219, I got access, for Crunchbase from Caitlin, via Clay, so it will be,
256 00:23:15.510 ⇒ 00:23:20.140 Mustafa Raja: Working on private companies’ data, using,
257 00:23:20.510 ⇒ 00:23:23.259 Mustafa Raja: Crunch base from, from clay.
258 00:23:27.560 ⇒ 00:23:28.320 Awaish Kumar: Okay.
259 00:23:30.700 ⇒ 00:23:31.250 Awaish Kumar: Okay.
260 00:23:31.250 ⇒ 00:23:32.450 Mustafa Raja: And we are on track.
261 00:23:32.450 ⇒ 00:23:34.940 Awaish Kumar: For this week, we are delivering,
262 00:23:35.160 ⇒ 00:23:37.819 Awaish Kumar: ETL plan, and then we are pushing on that.
263 00:23:38.430 ⇒ 00:23:43.520 Awaish Kumar: And then there’s, some work, Musa, you’re doing, right?
264 00:23:43.830 ⇒ 00:23:45.889 Mustafa Raja: Yeah, yeah, this is ad hoc request.
265 00:23:45.890 ⇒ 00:23:46.480 Awaish Kumar: Okay.
266 00:23:49.090 ⇒ 00:23:50.380 Awaish Kumar: Okay, great.
267 00:23:52.310 ⇒ 00:23:57.729 Awaish Kumar: Okay, I think that’s all from my side, if anybody else want to add anything.
268 00:23:59.150 ⇒ 00:24:03.380 Uttam Kumaran: Yeah, I think one question on, on default, guys, like,
269 00:24:03.810 ⇒ 00:24:07.730 Uttam Kumaran: try… one thing… one of the message I sent is to try to push the AI features.
270 00:24:08.060 ⇒ 00:24:12.719 Uttam Kumaran: It’s something that I think is really unique, and one of the big reasons we picked the platform.
271 00:24:12.890 ⇒ 00:24:27.210 Uttam Kumaran: So… I don’t know, that’s just one of my suggestions. For the other clients that were moving Omni, you know, that’s something that I’m gonna try to get stood up first, because it gives people just a quick way to get access to things without having to…
272 00:24:27.350 ⇒ 00:24:31.949 Uttam Kumaran: get the perfect dashboard, you know? So, I’m just interested in your thoughts on that.
273 00:24:38.190 ⇒ 00:24:41.640 Demilade Agboola: Yeah, I think we could definitely, push the…
274 00:24:42.040 ⇒ 00:24:47.159 Demilade Agboola: AI features that Omni has. I think it’s something that they will be quite interested in.
275 00:24:49.210 ⇒ 00:24:55.839 Demilade Agboola: I think once we start to push out more, like, for instance, the Salesforce dashboard that I’m working on.
276 00:24:55.970 ⇒ 00:24:58.850 Demilade Agboola: I think once I push that to the team.
277 00:24:59.320 ⇒ 00:25:14.189 Demilade Agboola: I can also ask, like, Stan, for instance, if he can try using the AI features in there, or if you’d like a tutorial. So, like, as while we’re handing over the dashboards, or handing over the work that we’re doing, we can also, like, do an AI
278 00:25:14.650 ⇒ 00:25:15.760 Demilade Agboola: tutorial.
279 00:25:15.990 ⇒ 00:25:31.009 Demilade Agboola: with the data, so they can also think of concepts that they will like with the data. So if they’re like, oh, can we enrich the data with more data from this part of the business, we can start to do that for them, and it’ll make them more productive with what they would want to use it for.
280 00:25:33.600 ⇒ 00:25:34.230 Uttam Kumaran: Okay.
281 00:25:39.310 ⇒ 00:25:44.220 Uttam Kumaran: The Salesforce stuff, it’s not yet 100% modeled.
282 00:25:45.090 ⇒ 00:25:56.350 Demilade Agboola: So, I have created the, like, a table within… because it’s a one-time export data, so I have created a table within Mother Doc, so I’m using that in Salesforce.
283 00:25:57.640 ⇒ 00:25:58.930 Uttam Kumaran: Okay, okay.
284 00:25:59.130 ⇒ 00:26:01.390 Demilade Agboola: Sorry, not… we’re using that within Omni.
285 00:26:01.950 ⇒ 00:26:02.830 Uttam Kumaran: Okay.
286 00:26:03.060 ⇒ 00:26:03.780 Demilade Agboola: Yeah.
287 00:26:08.070 ⇒ 00:26:08.980 Uttam Kumaran: Okay, great.
288 00:26:11.480 ⇒ 00:26:13.630 Awaish Kumar: Okay, yeah, thank you, everyone.
289 00:26:14.370 ⇒ 00:26:16.019 Uttam Kumaran: Thank you. Back to you guys soon.
290 00:26:16.020 ⇒ 00:26:16.490 Ashwini Sharma: Thank you.
291 00:26:16.490 ⇒ 00:26:17.300 Demilade Agboola: Thank you.
292 00:26:17.630 ⇒ 00:26:20.700 Uttam Kumaran: No, wait, wait, do you want to do the Google Analytics stuff?
293 00:26:20.700 ⇒ 00:26:21.809 Awaish Kumar: Oh, yeah, sure.
294 00:26:22.060 ⇒ 00:26:22.889 Uttam Kumaran: Okay, okay, okay.
295 00:26:22.890 ⇒ 00:26:27.830 Awaish Kumar: I don’t have access to the vault, so if anyone else wanna show the screen…
296 00:26:29.220 ⇒ 00:26:30.530 Mustafa Raja: I can.
297 00:26:35.220 ⇒ 00:26:40.910 Awaish Kumar: Yeah, let’s go to the… oh… Google Cloud console.
298 00:26:44.620 ⇒ 00:26:45.570 Mustafa Raja: Okay.
299 00:26:45.760 ⇒ 00:26:53.449 Awaish Kumar: can go into the IEM, like, on the left-hand side, IEM, and admin, yeah.
300 00:26:56.630 ⇒ 00:26:58.790 Mustafa Raja: We want to go over here, right?
301 00:26:59.670 ⇒ 00:27:01.620 Awaish Kumar: I want to see… yeah, yeah.
302 00:27:02.010 ⇒ 00:27:04.050 Mustafa Raja: Okay, here we are.
303 00:27:06.520 ⇒ 00:27:07.340 Awaish Kumar: Okay.
304 00:27:11.380 ⇒ 00:27:14.600 Mustafa Raja: Yeah, hmm.
305 00:27:15.180 ⇒ 00:27:17.410 Awaish Kumar: Okay, you… okay, you don’t have it.
306 00:27:18.400 ⇒ 00:27:19.730 Mustafa Raja: Yeah, we…
307 00:27:21.310 ⇒ 00:27:23.449 Awaish Kumar: Okay, this account don’t have access…
308 00:27:26.240 ⇒ 00:27:30.170 Mustafa Raja: Hmm. We need admin access and write over here, too.
309 00:27:33.620 ⇒ 00:27:36.510 Uttam Kumaran: I have admin on GA, but yeah, I guess…
310 00:27:39.080 ⇒ 00:27:39.660 Awaish Kumar: Okay.
311 00:27:41.470 ⇒ 00:27:45.589 Uttam Kumaran: You wanna just ping this to, you’re on that email with me and Tim, right?
312 00:27:46.100 ⇒ 00:27:47.829 Mustafa Raja: Yeah, I am.
313 00:27:48.630 ⇒ 00:27:52.810 Uttam Kumaran: Do you want to just ping this to him there, and just let him know, like, what it is?
314 00:27:53.450 ⇒ 00:27:54.170 Mustafa Raja: Okay.
315 00:27:54.440 ⇒ 00:27:55.120 Mustafa Raja: Aluna.
316 00:27:56.810 ⇒ 00:28:06.289 Awaish Kumar: Yeah, you can, like, share both, like, getting access on BigQuery, admin access, or also getting admin access on GA4.
317 00:28:06.360 ⇒ 00:28:12.150 Uttam Kumaran: The thing is, I don’t think GA is enabled for… They’re… Team.
318 00:28:12.320 ⇒ 00:28:13.520 Uttam Kumaran: the company?
319 00:28:13.520 ⇒ 00:28:14.580 Awaish Kumar: Okay, okay.
320 00:28:14.850 ⇒ 00:28:23.400 Uttam Kumaran: So I feel like there may be… some… Like, issue there.
321 00:28:24.370 ⇒ 00:28:28.180 Awaish Kumar: Okay, then try to, let’s just get the admin access on BigQuery.
322 00:28:29.190 ⇒ 00:28:30.380 Uttam Kumaran: Yeah, okay.
323 00:28:30.580 ⇒ 00:28:34.080 Uttam Kumaran: That would be great. Yeah, can we request that? Because this is, like,
324 00:28:34.700 ⇒ 00:28:38.930 Uttam Kumaran: this will solve a lot, but otherwise, Awash, you can also…
325 00:28:39.230 ⇒ 00:28:43.780 Uttam Kumaran: send to Amber, like, where she can start to look at the other data.
326 00:28:44.190 ⇒ 00:28:45.359 Awaish Kumar: Yeah, sure.
327 00:28:46.000 ⇒ 00:28:46.590 Uttam Kumaran: Bam.
328 00:28:47.650 ⇒ 00:28:48.180 Awaish Kumar: Yeah.
329 00:28:50.750 ⇒ 00:28:51.580 Awaish Kumar: Okay.
330 00:28:52.270 ⇒ 00:28:53.480 Awaish Kumar: Thank you. Bye.
331 00:28:53.480 ⇒ 00:28:54.010 Mustafa Raja: Okay.
332 00:28:54.370 ⇒ 00:28:55.290 Uttam Kumaran: Thank you.