Meeting Title: Uttam_Casie Date: 2025-03-19 Meeting participants: Annie Yu, Uttam Kumaran, Casie Aviles
WEBVTT
1 00:00:15.230 ⇒ 00:00:16.370 Uttam Kumaran: Hi Casey
2 00:00:18.190 ⇒ 00:00:19.710 Casie Aviles: Hey Hey whatam!
3 00:00:20.180 ⇒ 00:00:21.469 Uttam Kumaran: Hey! How are you?
4 00:00:23.070 ⇒ 00:00:24.300 Casie Aviles: Yeah. Doing fine.
5 00:00:24.630 ⇒ 00:00:25.620 Casie Aviles: How about you?
6 00:00:25.980 ⇒ 00:00:33.199 Uttam Kumaran: Good do you mind if I just invite Annie to this real quick? She had a question about some data thing. I just wanna quickly walk through with her.
7 00:00:33.360 ⇒ 00:00:35.529 Uttam Kumaran: I think it’d be helpful for you to see it as well
8 00:00:35.910 ⇒ 00:00:37.129 Casie Aviles: Yeah, sure, no. Problem.
9 00:01:25.810 ⇒ 00:01:26.690 Annie Yu: Hello!
10 00:01:27.060 ⇒ 00:01:27.530 Uttam Kumaran: Hi.
11 00:01:29.960 ⇒ 00:01:37.773 Uttam Kumaran: okay, let’s sorry. Me and Casey, we’re gonna meet about some data stuff, anyway. So I was like, Okay, I have an hour to kind of work on some stuff. So let’s
12 00:01:39.150 ⇒ 00:01:53.130 Uttam Kumaran: So I think for Casey’s sake, the problem we’re finding is we have a data model where we’re trying to link 2 sources together, recharge, which is subscriptions for a client, and we’re trying to also link together that to
13 00:01:54.280 ⇒ 00:01:58.779 Uttam Kumaran: this is gorgeous, which is customer service tickets. Do I have that right?
14 00:02:01.380 ⇒ 00:02:03.220 Uttam Kumaran: I have that about right, Annie
15 00:02:03.500 ⇒ 00:02:05.659 Annie Yu: Oh, is that a question for me? Yes.
16 00:02:05.660 ⇒ 00:02:07.020 Uttam Kumaran: Yes. Okay, okay.
17 00:02:07.670 ⇒ 00:02:11.235 Uttam Kumaran: So let’s let’s just take a look at like what
18 00:02:13.250 ⇒ 00:02:19.820 Uttam Kumaran: what we’re seeing here. So let me also just share cursor.
19 00:02:22.680 ⇒ 00:02:27.530 Uttam Kumaran: Hold on, though.
20 00:02:28.520 ⇒ 00:02:32.910 Uttam Kumaran: Let’s look at a where are we? At my.
21 00:02:39.090 ⇒ 00:02:44.380 Uttam Kumaran: okay? So I’m gonna open Javi coffee. I’m gonna look at customer service.
22 00:02:44.620 ⇒ 00:02:46.909 Uttam Kumaran: So you were looking at fact tickets right?
23 00:02:47.180 ⇒ 00:02:48.010 Annie Yu: Yes.
24 00:02:49.310 ⇒ 00:02:56.799 Uttam Kumaran: Okay? So yeah, I don’t see any sort of customer related data here, either, I see. Oh, customer id.
25 00:02:56.920 ⇒ 00:02:58.010 Uttam Kumaran: Oh, okay.
26 00:02:58.550 ⇒ 00:03:00.830 Uttam Kumaran: So there’s some customer. Id thing here.
27 00:03:01.810 ⇒ 00:03:09.480 Uttam Kumaran: and it looks like satisfaction. Survey customer. Id is the customer. Id, but as you mentioned.
28 00:03:10.980 ⇒ 00:03:17.279 Uttam Kumaran: there’s some there may be some null, so you’re right. I think that’s a fair assumption. So let’s keep looking.
29 00:03:17.980 ⇒ 00:03:23.560 Uttam Kumaran: So fact tickets here. Fact reviews is not probably what we need.
30 00:03:27.570 ⇒ 00:03:32.979 Uttam Kumaran: Okay, so how about this. One thing that’s probably helpful here is to go look at
31 00:03:33.400 ⇒ 00:03:38.050 Uttam Kumaran: the raw for gorgeous and go to raw ticket fields.
32 00:03:45.400 ⇒ 00:03:49.110 Uttam Kumaran: okay, I don’t see anything here. So then let’s go to Snowflake.
33 00:03:50.470 ⇒ 00:03:54.289 Uttam Kumaran: So what I’m gonna do now is I’m gonna just go look
34 00:03:54.680 ⇒ 00:03:59.880 Uttam Kumaran: to see what’s in the raw fields, because maybe this is something we need to bring in
35 00:04:00.310 ⇒ 00:04:05.460 Annie Yu: Yeah, I talked to Kyle briefly, and he did mention there’s
36 00:04:07.690 ⇒ 00:04:16.269 Annie Yu: He wait. What did he say? Seem seems like there’s no charge data in the Mars yet.
37 00:04:17.329 ⇒ 00:04:19.250 Annie Yu: And I think that’s the
38 00:04:19.906 ⇒ 00:04:21.390 Uttam Kumaran: No, there is recharge data
39 00:04:21.399 ⇒ 00:04:23.559 Annie Yu: I think it’s charge
40 00:04:23.659 ⇒ 00:04:24.289 Uttam Kumaran: Let’s reach
41 00:04:24.290 ⇒ 00:04:25.170 Annie Yu: Charge.
42 00:04:25.530 ⇒ 00:04:26.930 Uttam Kumaran: Sorry it is there.
43 00:04:26.930 ⇒ 00:04:31.540 Annie Yu: You show this charge charges table what you say
44 00:04:31.540 ⇒ 00:04:34.150 Uttam Kumaran: Charge orders, factory charge, order lines.
45 00:04:35.010 ⇒ 00:04:35.880 Annie Yu: Okay.
46 00:04:38.440 ⇒ 00:04:39.930 Uttam Kumaran: I don’t know. What did he say?
47 00:04:42.900 ⇒ 00:04:49.130 Uttam Kumaran: Because base. Basically, we’re trying to join. So did you have a check to look at? What recharge and gorgeous are
48 00:04:49.520 ⇒ 00:04:50.330 Annie Yu: Yes.
49 00:04:50.840 ⇒ 00:04:52.880 Uttam Kumaran: So yeah, tell me what you found
50 00:04:55.710 ⇒ 00:05:02.539 Annie Yu: Wait in gorgeous. That’s we’re talking about the factory charge orders or the subscription right?
51 00:05:02.540 ⇒ 00:05:02.890 Annie Yu: I guess
52 00:05:03.020 ⇒ 00:05:03.589 Uttam Kumaran: I guess
53 00:05:03.950 ⇒ 00:05:09.380 Uttam Kumaran: I guess my most basic question is, do you know what gorgeous and recharge are like in general?
54 00:05:10.560 ⇒ 00:05:11.619 Annie Yu: Are they?
55 00:05:12.950 ⇒ 00:05:17.290 Uttam Kumaran: Try. I would take a second Google, take a second and just Google, that real quick
56 00:05:18.510 ⇒ 00:05:25.120 Annie Yu: I. I think I do have a pretty good understanding by looking at the data. But it’s it’s a good idea to Google it, too.
57 00:05:25.120 ⇒ 00:05:29.240 Uttam Kumaran: Just real quick. Just so you have a sense of like what what we’re working with. It’ll
58 00:05:29.570 ⇒ 00:05:31.529 Uttam Kumaran: it’ll clear a couple things up
59 00:05:32.610 ⇒ 00:05:33.890 Annie Yu: Georgia.
60 00:05:44.820 ⇒ 00:05:47.659 Annie Yu: Should I look at the Api reference
61 00:05:47.660 ⇒ 00:05:50.190 Uttam Kumaran: No, no, no! Just look at like what the company does.
62 00:05:50.460 ⇒ 00:05:52.189 Annie Yu: Okay, got it?
63 00:05:57.550 ⇒ 00:06:00.140 Uttam Kumaran: I know I’m being a little bit pedantic, but like
64 00:06:00.770 ⇒ 00:06:03.109 Uttam Kumaran: I think it’s helpful just to start with like what
65 00:06:03.320 ⇒ 00:06:05.600 Uttam Kumaran: what is gorgeous and what is recharge
66 00:06:07.650 ⇒ 00:06:09.010 Annie Yu: Which is.
67 00:06:13.090 ⇒ 00:06:15.280 Annie Yu: am I? How is?
68 00:06:15.970 ⇒ 00:06:17.710 Annie Yu: Did I spelled it wrong?
69 00:06:18.410 ⇒ 00:06:22.859 Uttam Kumaran: RECH, a, RGE, and then gorgeous GORG, IS.
70 00:06:25.530 ⇒ 00:06:27.920 Annie Yu: Got it, recharge subscription
71 00:06:35.340 ⇒ 00:06:36.650 Annie Yu: occurring.
72 00:06:40.450 ⇒ 00:06:47.029 Annie Yu: So they track the recurring charges from the subscriptions
73 00:06:47.970 ⇒ 00:06:50.990 Uttam Kumaran: Yep. So recharge is a subscription platform
74 00:06:51.940 ⇒ 00:06:59.009 Uttam Kumaran: So Javi coffee uses it so that people can subscribe to their to get coffee from them on a subscription
75 00:06:59.330 ⇒ 00:06:59.750 Annie Yu: Yeah.
76 00:06:59.750 ⇒ 00:07:01.880 Uttam Kumaran: They handle all the operations related to that.
77 00:07:03.130 ⇒ 00:07:06.400 Uttam Kumaran: So that’s clear. Now take a look at like, take a look at gorgeous
78 00:07:18.580 ⇒ 00:07:20.540 Annie Yu: Which section
79 00:07:21.010 ⇒ 00:07:22.870 Uttam Kumaran: Well, just again, just what they do
80 00:07:23.230 ⇒ 00:07:23.890 Annie Yu: Okay.
81 00:07:27.090 ⇒ 00:07:28.420 Annie Yu: how does.
82 00:07:40.450 ⇒ 00:07:44.050 Uttam Kumaran: Like very simply, Annie, you could just do like what is gorgeous
83 00:07:45.330 ⇒ 00:07:47.850 Annie Yu: I’m looking at their about us.
84 00:07:48.080 ⇒ 00:07:53.300 Uttam Kumaran: But even very even even simpler. Here you could just say what is gorgeous. And it’s like right here
85 00:07:53.980 ⇒ 00:07:54.790 Annie Yu: Okay.
86 00:07:55.250 ⇒ 00:07:56.450 Annie Yu: Thank you.
87 00:07:56.926 ⇒ 00:08:03.589 Uttam Kumaran: Sorry I’m not trying to. Again. I I think it’s helpful to start. So you get a sense of like what the data model should look like.
88 00:08:04.190 ⇒ 00:08:05.000 Annie Yu: Okay.
89 00:08:08.110 ⇒ 00:08:08.880 Annie Yu: Yeah.
90 00:08:12.070 ⇒ 00:08:14.480 Uttam Kumaran: So it’s like a it’s like it’s like a help desk
91 00:08:16.220 ⇒ 00:08:19.295 Annie Yu: Yeah, so is it like a
92 00:08:22.640 ⇒ 00:08:24.489 Annie Yu: Wait, what do you mean by help desk
93 00:08:24.490 ⇒ 00:08:28.414 Uttam Kumaran: Like, okay? So let’s say, you have a problem. Let’s say you have a problem with
94 00:08:28.890 ⇒ 00:08:31.230 Uttam Kumaran: with slack. What do you do like
95 00:08:31.380 ⇒ 00:08:35.820 Uttam Kumaran: you like. Let’s say you have a problem with an with like an integration. You want to build
96 00:08:35.929 ⇒ 00:08:37.839 Uttam Kumaran: what happens like, how do you go find help
97 00:08:39.570 ⇒ 00:08:40.919 Annie Yu: I, Google, it.
98 00:08:40.929 ⇒ 00:08:45.149 Uttam Kumaran: Okay. But let’s say you Google, it and it’s not there. Let’s say you looked at the docs. It’s not there.
99 00:08:46.450 ⇒ 00:08:48.320 Annie Yu: And that’s where we need gorgeous
100 00:08:48.600 ⇒ 00:08:50.049 Uttam Kumaran: No, no, no, but I guess like
101 00:08:50.240 ⇒ 00:08:56.419 Uttam Kumaran: like if it just just bear with me for this example, like, what would you do if you like looked in the docs for something. It’s not there
102 00:08:56.540 ⇒ 00:08:59.309 Annie Yu: You ask around. It’s not there like, how do you still get help?
103 00:09:01.040 ⇒ 00:09:02.150 Annie Yu: I called them
104 00:09:02.840 ⇒ 00:09:05.279 Uttam Kumaran: Or you submit a ticket. Right? Basically.
105 00:09:05.700 ⇒ 00:09:07.749 Uttam Kumaran: So gorgeous is a ticket.
106 00:09:08.010 ⇒ 00:09:10.290 Uttam Kumaran: There’s a ticketing software
107 00:09:11.180 ⇒ 00:09:12.000 Annie Yu: Okay.
108 00:09:12.300 ⇒ 00:09:16.509 Uttam Kumaran: So it’s a customer service software have you used? You may have used Zendesk before
109 00:09:17.060 ⇒ 00:09:18.140 Annie Yu: No.
110 00:09:18.290 ⇒ 00:09:23.170 Uttam Kumaran: Or just like, you know, when you just submit a ticket like if I was to say cool, my figma is broken. I need help.
111 00:09:23.730 ⇒ 00:09:25.070 Uttam Kumaran: I would go submit a ticket.
112 00:09:25.190 ⇒ 00:09:25.770 Annie Yu: Yeah, yeah.
113 00:09:25.770 ⇒ 00:09:33.970 Uttam Kumaran: It usually goes through gorgeous or Zendesk, or service now, or one of those, it’s basically like a system to manage tickets
114 00:09:35.900 ⇒ 00:09:43.169 Uttam Kumaran: So customers, customers, says my. For example, like, let’s go look at. And here’s here’s a sort of helpful thing to do like let’s say.
115 00:09:43.540 ⇒ 00:09:46.100 Uttam Kumaran: great. We’re looking at the data right here.
116 00:09:47.190 ⇒ 00:09:47.520 Annie Yu: Yep.
117 00:09:47.520 ⇒ 00:09:51.110 Uttam Kumaran: Did you happen to go, you you went and looked at the definitions for these tables at all
118 00:09:53.052 ⇒ 00:09:55.529 Annie Yu: Yeah. And in in Mars, yeah.
119 00:09:55.530 ⇒ 00:09:58.620 Uttam Kumaran: So, for you were looking at fact tickets right?
120 00:10:00.420 ⇒ 00:10:01.150 Annie Yu: Yes.
121 00:10:01.750 ⇒ 00:10:04.339 Uttam Kumaran: Did you look up? Did you pull up this code as well
122 00:10:05.085 ⇒ 00:10:05.670 Annie Yu: Yes.
123 00:10:05.670 ⇒ 00:10:10.309 Uttam Kumaran: So. So, you know, if you can. Look here, you see that it’s coming from raw, gorgeous tickets
124 00:10:10.450 ⇒ 00:10:14.500 Annie Yu: So what I’m gonna do is trace this down here to raw, gorgeous
125 00:10:14.660 ⇒ 00:10:20.329 Uttam Kumaran: Tickets, and then I can say, Great look! It’s coming from raw, portable, gorgeous dot tickets.
126 00:10:20.580 ⇒ 00:10:26.160 Uttam Kumaran: So I’m gonna go to Snowflake, and I’m just gonna say cool. Let me just do select from here.
127 00:10:26.910 ⇒ 00:10:28.729 Uttam Kumaran: and let’s just check out what it looks like.
128 00:10:29.110 ⇒ 00:10:29.830 Annie Yu: Yeah.
129 00:10:29.830 ⇒ 00:10:36.820 Uttam Kumaran: What you’re gonna see here is okay. I see us users channels. I see customer. Okay, so there’s something there
130 00:10:37.100 ⇒ 00:10:40.548 Uttam Kumaran: looks like that’s probably exactly what we mean.
131 00:10:41.510 ⇒ 00:10:44.370 Uttam Kumaran: and then it looks like, Okay, there’s almost like.
132 00:10:44.940 ⇒ 00:10:50.359 Uttam Kumaran: Hey, thank you for reaching out. I’m sorry you’re no longer subscription can. So these are customer service tickets, right?
133 00:10:50.810 ⇒ 00:10:51.540 Annie Yu: Yeah.
134 00:10:51.540 ⇒ 00:10:55.040 Uttam Kumaran: So it looks like this table. All it does is a primary key of Id, and has just
135 00:10:55.500 ⇒ 00:10:57.300 Uttam Kumaran: tickets between
136 00:10:57.600 ⇒ 00:11:03.984 Uttam Kumaran: people, their statuses. And if you go look at how this was made. Raw, gorgeous tickets. Yeah, it looks like they just selected all these.
137 00:11:04.400 ⇒ 00:11:08.950 Uttam Kumaran: The one thing I’m noticing here, though, is. There’s no customer information here
138 00:11:09.780 ⇒ 00:11:10.480 Annie Yu: Yeah.
139 00:11:10.960 ⇒ 00:11:13.910 Uttam Kumaran: So one thing I can do is take this. And I’m just gonna say.
140 00:11:14.090 ⇒ 00:11:20.730 Uttam Kumaran: great, this is exactly like what I’m gonna say, this is what currently this table is built from
141 00:11:21.330 ⇒ 00:11:27.829 Uttam Kumaran: is this table, which is this is all tickets the agent Id, and
142 00:11:28.530 ⇒ 00:11:30.930 Uttam Kumaran: basically the tags associated with the ticket.
143 00:11:31.441 ⇒ 00:11:39.310 Uttam Kumaran: It looks like there’s no customer information here and looks like that’s probably what we need. So let me go see how we can make that change.
144 00:11:39.510 ⇒ 00:11:44.930 Uttam Kumaran: So do you? Wanna so I’m I’m gonna show you how to do it. But I would actually
145 00:11:45.200 ⇒ 00:12:04.449 Uttam Kumaran: love. If you want to go make this Pr, and then you’ll go through the entire process. But basically, what we want to do is say, cool. I want to bring in the customer information from this table. Looks like the customer information is in this column. And let’s take a look at what this looks like. Cool looks like we have everything you need. There’s an email name, Id.
146 00:12:05.597 ⇒ 00:12:08.879 Uttam Kumaran: all types of great information. Right?
147 00:12:09.260 ⇒ 00:12:09.830 Annie Yu: Yeah.
148 00:12:10.260 ⇒ 00:12:15.166 Uttam Kumaran: So how about we do this? Let’s say, okay, we want to parse this out. Let’s say we want to take out
149 00:12:16.590 ⇒ 00:12:20.890 Uttam Kumaran: and you use snowflake? Have you used like the Json selectors before
150 00:12:21.640 ⇒ 00:12:23.690 Annie Yu: Not in snowflake.
151 00:12:24.500 ⇒ 00:12:27.109 Uttam Kumaran: Okay, very simply, though, you basically have to do like
152 00:12:27.410 ⇒ 00:12:31.260 Uttam Kumaran: Colon Colon. And then you can select what you want.
153 00:12:32.690 ⇒ 00:12:33.820 Uttam Kumaran: Which is like
154 00:12:34.840 ⇒ 00:12:40.590 Uttam Kumaran: colon colon and then id right. So let’s just do take id as customer. Id.
155 00:12:41.070 ⇒ 00:12:48.160 Uttam Kumaran: Let’s take customer, Colon Colon email as customer email.
156 00:12:48.500 ⇒ 00:12:52.240 Uttam Kumaran: Let’s take customer.
157 00:12:52.420 ⇒ 00:13:09.295 Uttam Kumaran: Colon Colon 1st name 1st name, and then we can do customer Colon Colon last name as
158 00:13:11.040 ⇒ 00:13:13.150 Uttam Kumaran: customer name.
159 00:13:13.310 ⇒ 00:13:15.829 Uttam Kumaran: I think it’s gonna want us to do this.
160 00:13:19.110 ⇒ 00:13:20.679 Uttam Kumaran: And that. Seems like
161 00:13:20.840 ⇒ 00:13:24.560 Uttam Kumaran: it’s a good amount of stuff. So let’s see what we get here. Probably get some error.
162 00:13:26.453 ⇒ 00:13:28.870 Uttam Kumaran: So on. So looks like
163 00:13:29.930 ⇒ 00:13:32.780 Uttam Kumaran: supported data type. Id, so let’s see this.
164 00:13:34.952 ⇒ 00:13:38.630 Uttam Kumaran: Okay, so assign a user, id.
165 00:13:43.385 ⇒ 00:13:52.290 Uttam Kumaran: okay, let’s just focus on how do we get this thing out. So we have
166 00:13:52.670 ⇒ 00:13:57.820 Uttam Kumaran: customer. So how does it work for assignee user? So assignee user?
167 00:13:59.990 ⇒ 00:14:04.689 Uttam Kumaran: Oh, okay, so it looks like we have to do just one colon.
168 00:14:05.280 ⇒ 00:14:07.130 Uttam Kumaran: So if I do this
169 00:14:08.640 ⇒ 00:14:09.250 Annie Yu: Okay.
170 00:14:10.493 ⇒ 00:14:14.859 Uttam Kumaran: And then looks like last name is not there? Oh, yeah, here
171 00:14:15.540 ⇒ 00:14:16.100 Annie Yu: Hmm.
172 00:14:17.560 ⇒ 00:14:22.110 Uttam Kumaran: Great. So looks like we have customer. Id, email is not here
173 00:14:22.480 ⇒ 00:14:23.870 Annie Yu: Though
174 00:14:24.020 ⇒ 00:14:27.170 Uttam Kumaran: Let’s see like, where is this? Oh, looks like
175 00:14:27.410 ⇒ 00:14:29.120 Uttam Kumaran: maybe I have to do all caps
176 00:14:32.340 ⇒ 00:14:33.939 Uttam Kumaran: nice. There it is.
177 00:14:34.490 ⇒ 00:14:42.050 Uttam Kumaran: The other thing we can do here is we can trim this, and we can take out all
178 00:14:43.165 ⇒ 00:14:47.369 Uttam Kumaran: Quotes right? You see the quotes on either end.
179 00:14:48.720 ⇒ 00:14:50.459 Uttam Kumaran: so we can take that out
180 00:14:51.000 ⇒ 00:14:56.949 Uttam Kumaran: and cool. You’re left with this. The other thing here is some of these don’t have emails. Right? So let’s take a look at like, what’s happening here.
181 00:14:58.010 ⇒ 00:15:03.710 Uttam Kumaran: Yeah, maybe they don’t have an email attached. So maybe it’s gonna be difficult. Maybe you’ll have to also look at
182 00:15:06.440 ⇒ 00:15:12.420 Uttam Kumaran: for you’ll have to also try to match on potentially the name right?
183 00:15:12.420 ⇒ 00:15:16.840 Annie Yu: The customer. Id. I I thought that would be sufficient
184 00:15:17.020 ⇒ 00:15:23.779 Uttam Kumaran: I don’t know whether the customer, id and gorgeous, is the same as in Zendesk, or it’s the same as in recharge. So
185 00:15:24.090 ⇒ 00:15:25.580 Annie Yu: Well, probably not.
186 00:15:25.830 ⇒ 00:15:26.759 Uttam Kumaran: Probably not. Yeah.
187 00:15:26.760 ⇒ 00:15:28.100 Annie Yu: Everything’s different.
188 00:15:28.240 ⇒ 00:15:31.970 Uttam Kumaran: Most likely you’ll have to join on email for now
189 00:15:32.450 ⇒ 00:15:33.470 Annie Yu: Okay.
190 00:15:33.470 ⇒ 00:15:37.960 Uttam Kumaran: But this is basically what we need. So the kind of the steps here now is, I would take this
191 00:15:38.430 ⇒ 00:15:39.480 Annie Yu: Right.
192 00:15:39.660 ⇒ 00:15:42.769 Uttam Kumaran: I would copy this. Put this right into here.
193 00:15:46.960 ⇒ 00:15:49.879 Uttam Kumaran: And then. Now this is available in raw, gorgeous tickets. Right?
194 00:15:50.730 ⇒ 00:15:53.069 Uttam Kumaran: The next step is to go to fact tickets.
195 00:15:53.810 ⇒ 00:15:58.109 Uttam Kumaran: And then you can see here that. Okay, we’re selecting all these things. T, dot.
196 00:15:58.690 ⇒ 00:16:04.119 Uttam Kumaran: So then you can also pull it in here. You can say, d dot customer name, customer, email, customer id.
197 00:16:04.490 ⇒ 00:16:09.390 Uttam Kumaran: And then the last thing to do is bring it into here. Right done.
198 00:16:13.730 ⇒ 00:16:16.799 Uttam Kumaran: Do you want to take a crack at making the pull request for this
199 00:16:18.689 ⇒ 00:16:25.010 Annie Yu: Wait! Do you mean I can edit it. I can edit on my own
200 00:16:25.870 ⇒ 00:16:26.620 Uttam Kumaran: Totally.
201 00:16:26.860 ⇒ 00:16:35.500 Annie Yu: Oh, okay, cause I I was. I thought that was something that I would like go through engineers. But then this is cool
202 00:16:35.750 ⇒ 00:16:40.809 Uttam Kumaran: You don’t have to. I mean I I would rather you do it on your own, because then you don’t have to go through anyone you can.
203 00:16:41.260 ⇒ 00:16:46.030 Uttam Kumaran: You can get whatever you want. I mean, someone will have to review the pull request right?
204 00:16:46.160 ⇒ 00:16:53.860 Uttam Kumaran: So that’s where there will be a check. But if you wait for Kyle, it’s going to be until tomorrow. And he already said he didn’t know where it was, so not worth waiting.
205 00:16:55.355 ⇒ 00:16:58.280 Uttam Kumaran: I would go ahead and make the make the code change
206 00:16:59.500 ⇒ 00:17:02.150 Annie Yu: Will I be able to do that in Snowflake
207 00:17:03.250 ⇒ 00:17:05.140 Uttam Kumaran: So you’ll have to do this in through Github
208 00:17:06.040 ⇒ 00:17:06.839 Annie Yu: Okay.
209 00:17:07.530 ⇒ 00:17:10.399 Uttam Kumaran: Have you used? Have you? Have you used github before
210 00:17:13.690 ⇒ 00:17:15.040 Annie Yu: Let me see.
211 00:17:19.250 ⇒ 00:17:23.769 Annie Yu: So would that be under the Brainforge data platform
212 00:17:25.171 ⇒ 00:17:32.649 Uttam Kumaran: No, this is gonna be in the Javi coffee repo. But like, have you used git or any sort of version control before
213 00:17:34.535 ⇒ 00:17:36.950 Annie Yu: I don’t really know what that means.
214 00:17:37.090 ⇒ 00:17:39.600 Uttam Kumaran: Like, have you pushed Code to Github before
215 00:17:40.190 ⇒ 00:17:41.480 Annie Yu: Oh, yeah. Yeah.
216 00:17:42.230 ⇒ 00:17:43.859 Uttam Kumaran: How did do you remember how you did that
217 00:17:44.708 ⇒ 00:17:47.099 Annie Yu: I use pie charm and commit and push.
218 00:17:48.210 ⇒ 00:17:49.040 Annie Yu: I cloned it.
219 00:17:49.040 ⇒ 00:17:52.439 Annie Yu: Maybe. Yeah. Maybe one thing I can
220 00:17:53.120 ⇒ 00:17:56.517 Uttam Kumaran: I think, take a stab. I’m gonna send you this.
221 00:17:57.110 ⇒ 00:18:00.630 Uttam Kumaran: I’m gonna send you these docs and data in the data team channel.
222 00:18:06.920 ⇒ 00:18:11.819 Uttam Kumaran: yeah, I I think you should try. This will be really, really helpful. And then, yeah, you can. Now, you don’t have to wait for anyone.
223 00:18:12.070 ⇒ 00:18:14.187 Uttam Kumaran: which is the best thing in life.
224 00:18:17.150 ⇒ 00:18:22.849 Uttam Kumaran: so take a look at this tutorial I sent. Give it a shot, and see if you could install github desktop.
225 00:18:23.000 ⇒ 00:18:29.210 Uttam Kumaran: The tutorial will walk you through how to clone this repository to your machine, and then ultimately, how to make a change
226 00:18:29.390 ⇒ 00:18:33.770 Uttam Kumaran: and do? Are you using Vs code right now, or any sort of ide
227 00:18:34.558 ⇒ 00:18:36.999 Annie Yu: Yes, I do have esc.
228 00:18:37.430 ⇒ 00:18:41.550 Uttam Kumaran: You can use Vs code. We also, I would also suggest trying cursor.
229 00:18:42.610 ⇒ 00:18:48.659 Uttam Kumaran: It’s like, it’s that’s how I was able to do the auto correct. It’s all has like, it’s really, really helpful with AI stuff
230 00:18:48.820 ⇒ 00:18:51.639 Annie Yu: Like you can ask questions about all the files.
231 00:18:52.940 ⇒ 00:18:54.219 Annie Yu: Is that a package
232 00:18:54.520 ⇒ 00:18:57.809 Uttam Kumaran: No, it’s like A, it’s like A. It’s like another version of Vs code.
233 00:18:58.010 ⇒ 00:18:59.490 Annie Yu: Okay. Okay.
234 00:19:04.100 ⇒ 00:19:05.820 Uttam Kumaran: I just that to you as well.
235 00:19:06.130 ⇒ 00:19:07.430 Uttam Kumaran: So give that a shot
236 00:19:09.720 ⇒ 00:19:10.830 Annie Yu: All right.
237 00:19:11.688 ⇒ 00:19:15.560 Uttam Kumaran: Sorry. I know we’re moving fast. I have to spend some time with Casey, but
238 00:19:15.850 ⇒ 00:19:20.466 Uttam Kumaran: it’s again. I think it’s really it’s all we have to do here, and and I’ll also share this.
239 00:19:20.910 ⇒ 00:19:27.499 Uttam Kumaran: I’ll share this. This, whatever this worksheet with you.
240 00:19:30.720 ⇒ 00:19:33.850 Uttam Kumaran: I don’t know. How do I do this. Okay, here.
241 00:19:34.570 ⇒ 00:19:37.739 Uttam Kumaran: Well, let me move to folder.
242 00:19:52.530 ⇒ 00:19:53.250 Uttam Kumaran: Okay?
243 00:19:56.700 ⇒ 00:19:59.450 Uttam Kumaran: And then what did what did Kyle mention to you as well
244 00:20:01.402 ⇒ 00:20:03.030 Annie Yu: Let me see
245 00:20:07.030 ⇒ 00:20:09.599 Uttam Kumaran: Yeah. And then I I didn’t see anything in the Channel, though.
246 00:20:14.250 ⇒ 00:20:24.150 Annie Yu: I was reading through his and robbers thread on the same topic.
247 00:20:27.780 ⇒ 00:20:31.210 Annie Yu: Well, not the same topic, but the one I’m trying to tackle.
248 00:20:33.270 ⇒ 00:20:37.539 Uttam Kumaran: Oh, okay, well, how about how about I’m gonna respond there
249 00:20:37.790 ⇒ 00:20:40.960 Uttam Kumaran: with some information based on what we saw today.
250 00:20:41.601 ⇒ 00:20:44.519 Annie Yu: Took me 10 min, so I don’t even know what
251 00:20:45.040 ⇒ 00:20:52.230 Uttam Kumaran: What the Comp. What like looks like. There’s like 3 days worth of discussion here. This took me like 10 min to figure out, so I don’t know what’s going on
252 00:20:52.700 ⇒ 00:20:53.130 Annie Yu: Okay.
253 00:20:54.750 ⇒ 00:20:59.789 Uttam Kumaran: But okay, go ahead and try cursor. Try pushing this as a Pr. And I’ll review it
254 00:21:00.890 ⇒ 00:21:04.789 Annie Yu: Okay? And so, okay, wait. Let me see
255 00:21:05.470 ⇒ 00:21:07.450 Annie Yu: my action. Item. Okay, I think I got it
256 00:21:07.450 ⇒ 00:21:10.534 Uttam Kumaran: Yeah, so that so then let me here. I’ll I can write down what the
257 00:21:11.060 ⇒ 00:21:21.190 Uttam Kumaran: what the steps are in slack. So one is install github desktop install cursor.
258 00:21:24.770 ⇒ 00:21:31.520 Uttam Kumaran: Set up github to clone the Javi coffee repository
259 00:21:32.220 ⇒ 00:21:32.740 Annie Yu: Yeah.
260 00:21:34.460 ⇒ 00:21:35.830 Uttam Kumaran: Confirm.
261 00:21:35.950 ⇒ 00:21:55.370 Uttam Kumaran: So make the changes to raw, gorgeous tickets and fact tickets to bring and customer info, and then.
262 00:21:55.940 ⇒ 00:22:04.520 Uttam Kumaran: once the Pr. Is made check Beijing Martz dot fact tickets
263 00:22:04.690 ⇒ 00:22:09.729 Uttam Kumaran: to see your change and verify that the join works.
264 00:22:16.770 ⇒ 00:22:20.249 Uttam Kumaran: So what’s gonna happen is, once you make a Pr
265 00:22:20.550 ⇒ 00:22:24.820 Annie Yu: That it will actually run, and you’ll be actually you’ll be able to go see the change
266 00:22:25.675 ⇒ 00:22:27.910 Uttam Kumaran: In staging marts
267 00:22:28.950 ⇒ 00:22:34.119 Annie Yu: So when you push that when you go make a change to fact tickets and it’s in a pull request
268 00:22:34.530 ⇒ 00:22:37.920 Uttam Kumaran: All you’re doing is saying, I want to request to pull this into production.
269 00:22:38.110 ⇒ 00:22:44.459 Uttam Kumaran: But while it’s in that phase, it’ll actually run here, so you’ll be able to go test out that fact. Tickets
270 00:22:44.720 ⇒ 00:22:47.850 Uttam Kumaran: actually has your fields and the join works. Now
271 00:22:49.310 ⇒ 00:22:54.420 Annie Yu: Got it, so can I also use the tables here
272 00:22:54.560 ⇒ 00:22:57.640 Annie Yu: for my Meta base dashboards or not.
273 00:22:57.850 ⇒ 00:23:03.609 Uttam Kumaran: No, I wouldn’t use any of this. So you can. You can. Actually, yeah, if you want to create a staging dashboard
274 00:23:04.210 ⇒ 00:23:05.580 Uttam Kumaran: Can use these
275 00:23:05.740 ⇒ 00:23:06.680 Annie Yu: But
276 00:23:06.950 ⇒ 00:23:08.709 Uttam Kumaran: This is not kept up to date.
277 00:23:08.860 ⇒ 00:23:11.869 Annie Yu: Meaning. This is all just changes that we’re like testing out
278 00:23:12.930 ⇒ 00:23:16.779 Uttam Kumaran: Right now metabase is pointing all towards product prodmarts
279 00:23:17.040 ⇒ 00:23:17.600 Annie Yu: Yeah.
280 00:23:17.740 ⇒ 00:23:29.410 Uttam Kumaran: But in terms of testing the change, you can just go in here. And once, once the once these fields are there, you can then say, okay, I want to try running a select this from
281 00:23:30.247 ⇒ 00:23:37.489 Uttam Kumaran: fact tickets. Join recharge on blah blah, right? You could test it out here
282 00:23:37.990 ⇒ 00:23:38.500 Annie Yu: Yeah.
283 00:23:38.500 ⇒ 00:23:39.550 Uttam Kumaran: To see that it worked.
284 00:23:40.020 ⇒ 00:23:48.569 Uttam Kumaran: But keep hitting me with questions like in slack. And yeah, it’s a lot to handle right now. But try it out. I want to see. I want you to see the full sort of process
285 00:23:49.000 ⇒ 00:24:00.250 Annie Yu: Yeah, that sounds good. And then one more question around the column you use on the Json object. Is that how they work? If it’s Jason
286 00:24:00.440 ⇒ 00:24:03.589 Uttam Kumaran: Yes. So if you go to Snowflake Json,
287 00:24:07.740 ⇒ 00:24:13.650 Uttam Kumaran: and you go to querying semi-structured data, you’ll see here that
288 00:24:15.140 ⇒ 00:24:16.710 Uttam Kumaran: this is how they do it.
289 00:24:17.580 ⇒ 00:24:18.310 Annie Yu: Yeah.
290 00:24:18.670 ⇒ 00:24:22.310 Uttam Kumaran: So I’m good. I’ll just copy. I’ll copy this. So you have it, too.
291 00:24:23.111 ⇒ 00:24:26.239 Uttam Kumaran: on how to query semi-structured data.
292 00:24:37.540 ⇒ 00:24:44.640 Uttam Kumaran: Okay, cool. I have to spend some time with Casey. You could feel free to stay on if you want to. But we’re gonna spend some time on some other data stuff
293 00:24:45.090 ⇒ 00:24:49.200 Annie Yu: Okay, I’m gonna hop off and just try these
294 00:24:50.290 ⇒ 00:24:51.590 Uttam Kumaran: Okay? No. Problem.
295 00:24:51.590 ⇒ 00:24:52.760 Annie Yu: You so much
296 00:24:52.760 ⇒ 00:24:54.130 Uttam Kumaran: Yeah, bye.
297 00:24:54.530 ⇒ 00:24:55.389 Annie Yu: Bye, for now
298 00:24:56.922 ⇒ 00:25:01.120 Uttam Kumaran: Casey, give me one second. Let me just respond to something on slack
299 00:25:01.470 ⇒ 00:25:02.070 Casie Aviles: Here.
300 00:29:27.280 ⇒ 00:29:29.489 Casie Aviles: Okay. I just went to the bathroom real quick.
301 00:29:29.830 ⇒ 00:29:30.979 Uttam Kumaran: Yeah, no. No. Problem.
302 00:31:05.560 ⇒ 00:31:07.240 Casie Aviles: Okay. I’m back now.
303 00:31:07.480 ⇒ 00:31:09.670 Uttam Kumaran: Okay? One sec. I’m just finishing this
304 00:36:34.420 ⇒ 00:36:35.340 Uttam Kumaran: one second
305 00:36:39.140 ⇒ 00:36:39.770 Casie Aviles: Okay.
306 00:36:59.440 ⇒ 00:37:05.660 Uttam Kumaran: Okay, alright cool. So what are we talking about today? Eval data getting into real right?
307 00:37:06.590 ⇒ 00:37:07.490 Casie Aviles: Oh, yeah.
308 00:37:08.430 ⇒ 00:37:14.780 Uttam Kumaran: Okay? So you have that data. Do you wanna share your screen?
309 00:37:15.545 ⇒ 00:37:20.010 Casie Aviles: Also, and I can keep it on one monitor, and then we can sort of walk through this and
310 00:37:20.180 ⇒ 00:37:21.140 Uttam Kumaran: Together.
311 00:37:23.060 ⇒ 00:37:24.829 Casie Aviles: Sure. Can you see my screen now?
312 00:37:27.520 ⇒ 00:37:29.530 Uttam Kumaran: Let me see. Hold on
313 00:37:32.890 ⇒ 00:37:37.160 Uttam Kumaran: and hold on.
314 00:37:45.587 ⇒ 00:37:47.629 Uttam Kumaran: Yeah, I can. I can see it now. Okay.
315 00:37:49.250 ⇒ 00:37:58.640 Casie Aviles: Okay, yeah. So earlier, we just basically, what we did was just export the
316 00:37:59.580 ⇒ 00:38:01.799 Casie Aviles: eval data from brain trust.
317 00:38:03.060 ⇒ 00:38:11.329 Casie Aviles: And so this is how it looks like. So I’m just displaying the latest yeah, the latest input.
318 00:38:11.610 ⇒ 00:38:14.300 Casie Aviles: And you can see some of these are from Janice
319 00:38:15.100 ⇒ 00:38:15.720 Uttam Kumaran: Cool.
320 00:38:17.260 ⇒ 00:38:23.660 Casie Aviles: Okay, yeah. And so it’s in this, although it’s in a separate table brain trust logs.
321 00:38:24.910 ⇒ 00:38:31.899 Casie Aviles: And I, I’ve also been just trying to have it on real. So
322 00:38:33.440 ⇒ 00:38:38.790 Uttam Kumaran: So let’s let’s do 2. Let’s let’s do 2 things first.st So the 1st thing I’ll do is
323 00:38:39.533 ⇒ 00:38:42.520 Uttam Kumaran: are you’re using. Get from the cli right
324 00:38:44.106 ⇒ 00:38:48.070 Casie Aviles: Yeah. But I did install github desktop just in case
325 00:38:48.070 ⇒ 00:38:53.189 Uttam Kumaran: Let’s use desktop. It’s so easy. Okay, so let’s let’s go to the ABC
326 00:38:54.285 ⇒ 00:38:57.049 Uttam Kumaran: issues. And let’s just check like what
327 00:38:57.220 ⇒ 00:39:04.449 Uttam Kumaran: I wanna look at 2 pieces. So which one? So we’re looking at, add snowflake data to real. This is the add, yeah.
328 00:39:04.650 ⇒ 00:39:12.760 Uttam Kumaran: add brain trust data to snowflake and create
329 00:39:12.880 ⇒ 00:39:17.479 Uttam Kumaran: real dashboard. Right? So this is the one you’re working on. You can see my screen still right
330 00:39:18.170 ⇒ 00:39:19.130 Casie Aviles: Oh, wait! No!
331 00:39:19.390 ⇒ 00:39:24.359 Uttam Kumaran: Sorry I don’t know. If you only have one monitor, then it’s fine. I’ll just. I’m just gonna make sure you have this
332 00:39:24.560 ⇒ 00:39:26.450 Casie Aviles: Yeah, I only have one monitor
333 00:39:26.790 ⇒ 00:39:30.550 Uttam Kumaran: Okay, have to get you an do you have space for another one?
334 00:39:33.460 ⇒ 00:39:34.310 Casie Aviles: I don’t.
335 00:39:34.450 ⇒ 00:39:35.969 Casie Aviles: I’m not sure I don’t think so.
336 00:39:35.970 ⇒ 00:39:38.080 Uttam Kumaran: No, no, no, no! Like on your desk.
337 00:39:39.050 ⇒ 00:39:40.439 Casie Aviles: Oh, I don’t
338 00:39:40.440 ⇒ 00:39:43.430 Uttam Kumaran: Okay, cause I wish I get I want to get you another one. Then.
339 00:39:45.490 ⇒ 00:39:47.849 Uttam Kumaran: like, what kind of monitor are you using right now?
340 00:39:48.100 ⇒ 00:39:49.829 Casie Aviles: I’m using a laptop
341 00:39:50.470 ⇒ 00:39:53.599 Uttam Kumaran: Wait, send me a can you send me a picture of how much space you have
342 00:39:53.790 ⇒ 00:39:56.749 Uttam Kumaran: cause? I’ll I’ll get you. I’ll get you another monitor
343 00:39:58.926 ⇒ 00:40:03.210 Casie Aviles: Really. Yeah, no, you don’t have to. I mean, it’s fine
344 00:40:03.440 ⇒ 00:40:09.362 Uttam Kumaran: No, I’m dude. You’re gonna get you like you have to. I need you to. You’re gonna get so much more work done. I promise you.
345 00:40:10.680 ⇒ 00:40:12.469 Casie Aviles: My desk is so small, like
346 00:40:12.470 ⇒ 00:40:15.100 Uttam Kumaran: Wait. Just send me. Just send me a picture on on slack.
347 00:40:15.830 ⇒ 00:40:17.459 Uttam Kumaran: and I’ll find one that works
348 00:40:18.510 ⇒ 00:40:19.559 Casie Aviles: Okay, sure.
349 00:40:21.946 ⇒ 00:40:24.130 Casie Aviles: Yeah. But okay.
350 00:41:00.560 ⇒ 00:41:02.339 Casie Aviles: okay, I just
351 00:41:11.800 ⇒ 00:41:12.889 Uttam Kumaran: You send it to me
352 00:41:13.310 ⇒ 00:41:14.130 Casie Aviles: Yes.
353 00:41:16.010 ⇒ 00:41:19.880 Uttam Kumaran: Oh, dude, you can fit. Okay, you can definitely fit.
354 00:41:24.420 ⇒ 00:41:29.760 Uttam Kumaran: Okay, let me give me a give me like a couple of days. I wanna get you a new setup because
355 00:41:29.920 ⇒ 00:41:36.390 Uttam Kumaran: dude, you’re doing too much work to be just working off this laptop. And I know because I used to run. I used to do the whole thing on my macbook.
356 00:41:36.750 ⇒ 00:41:41.060 Uttam Kumaran: So, okay, but that problem that problem aside.
357 00:41:41.180 ⇒ 00:41:46.659 Uttam Kumaran: Let me let me send you something in the ABC. Channel.
358 00:41:50.570 ⇒ 00:41:54.789 Uttam Kumaran: So this is the ticket. Right? So go ahead and open that ticket, and you’ll see a branch.
359 00:41:55.460 ⇒ 00:41:59.779 Uttam Kumaran: You’ll see a branch name at the at the ticket at the top of the ticket top. Right?
360 00:42:02.770 ⇒ 00:42:05.535 Uttam Kumaran: So go ahead and copy that branch.
361 00:42:07.670 ⇒ 00:42:09.250 Casie Aviles: Right. Where’s at this
362 00:42:09.250 ⇒ 00:42:10.860 Uttam Kumaran: Here. Yeah, so click on it
363 00:42:11.870 ⇒ 00:42:17.270 Uttam Kumaran: and then. Now in in Github desktop. Just make sure your branch name matches this.
364 00:42:17.580 ⇒ 00:42:19.689 Uttam Kumaran: So go ahead and open github desktop.
365 00:42:24.870 ⇒ 00:42:29.520 Uttam Kumaran: and then, yeah, so go ahead and clone.
366 00:42:30.110 ⇒ 00:42:31.939 Uttam Kumaran: Have you already done this step before
367 00:42:34.124 ⇒ 00:42:36.159 Casie Aviles: It’s been a while since I last used
368 00:42:36.340 ⇒ 00:42:43.209 Uttam Kumaran: Oh, okay, so here’s here’s the best way. Open. Open it up and open it up, and you go to github.com for the Javi
369 00:42:44.950 ⇒ 00:42:45.540 Casie Aviles: Okay.
370 00:42:46.009 ⇒ 00:42:46.949 Uttam Kumaran: The repo!
371 00:42:47.330 ⇒ 00:42:49.029 Uttam Kumaran: Yep, and then click on this
372 00:42:51.790 ⇒ 00:42:52.400 Casie Aviles: Just
373 00:42:53.790 ⇒ 00:42:55.379 Uttam Kumaran: Hoping we can have desktop. Yeah.
374 00:42:57.190 ⇒ 00:43:00.680 Uttam Kumaran: perfect. And then you can just name this brain forge. Dash real?
375 00:43:03.640 ⇒ 00:43:04.350 Uttam Kumaran: Yep.
376 00:43:09.710 ⇒ 00:43:11.210 Uttam Kumaran: try it again.
377 00:43:12.450 ⇒ 00:43:15.580 Uttam Kumaran: Hmm! Are you logged in with your right username? Here
378 00:43:22.550 ⇒ 00:43:23.556 Casie Aviles: Wait. Sorry.
379 00:43:27.220 ⇒ 00:43:28.789 Casie Aviles: This is my older one.
380 00:43:31.180 ⇒ 00:43:32.900 Uttam Kumaran: Like go to settings and account
381 00:43:34.090 ⇒ 00:43:35.760 Casie Aviles: Oh, okay. Settings. First, st
382 00:43:35.760 ⇒ 00:43:39.390 Uttam Kumaran: Options, file options.
383 00:43:40.270 ⇒ 00:43:41.419 Casie Aviles: File options, okay
384 00:43:43.860 ⇒ 00:43:46.849 Uttam Kumaran: This is your oh, okay, try this.
385 00:43:49.170 ⇒ 00:43:51.880 Uttam Kumaran: Or actually, you don’t need that.
386 00:43:55.770 ⇒ 00:43:59.189 Uttam Kumaran: Okay, hit X, just type it in. Try to type it in here.
387 00:44:02.800 ⇒ 00:44:05.939 Uttam Kumaran: Yeah. Brainforge, dash real. Yeah. Okay. Grab that. Yeah.
388 00:44:06.750 ⇒ 00:44:07.800 Uttam Kumaran: Hit clone.
389 00:44:09.820 ⇒ 00:44:13.520 Uttam Kumaran: Yep, as long way. Yeah, put it in. Github. Yeah.
390 00:44:16.320 ⇒ 00:44:18.869 Casie Aviles: Oh, wait! We did clone it yesterday, though.
391 00:44:20.630 ⇒ 00:44:20.965 Casie Aviles: Wait.
392 00:44:21.860 ⇒ 00:44:22.839 Uttam Kumaran: Oh, then
393 00:44:24.390 ⇒ 00:44:29.539 Uttam Kumaran: Just make sure you have to hit. You have to then open that one so click, cancel
394 00:44:30.405 ⇒ 00:44:31.980 Uttam Kumaran: add and do this one.
395 00:44:37.800 ⇒ 00:44:40.000 Uttam Kumaran: Why, that’s this. I saw it up there. Yeah.
396 00:44:40.490 ⇒ 00:44:41.350 Casie Aviles: Not this one?
397 00:44:49.370 ⇒ 00:44:50.040 Casie Aviles: Yeah.
398 00:44:55.540 ⇒ 00:44:57.309 Casie Aviles: okay, I think it’s here.
399 00:44:59.670 ⇒ 00:45:01.549 Casie Aviles: And then we just changed the branch.
400 00:45:08.860 ⇒ 00:45:10.290 Casie Aviles: Sorry did I cut off
401 00:45:10.290 ⇒ 00:45:17.670 Uttam Kumaran: Yes, so hit new branch, and then put in the name of that ticket in here. So whatever it gave you.
402 00:45:18.060 ⇒ 00:45:20.610 Uttam Kumaran: whatever branch thing it gave you. Yeah.
403 00:45:24.100 ⇒ 00:45:24.780 Uttam Kumaran: yep.
404 00:45:25.210 ⇒ 00:45:29.179 Uttam Kumaran: So it’s already copied, and then now you can just go paste it in. Github
405 00:45:35.590 ⇒ 00:45:37.960 Casie Aviles: And just leave my changes
406 00:45:43.696 ⇒ 00:45:45.080 Uttam Kumaran: No! Bring your changes!
407 00:45:45.830 ⇒ 00:45:46.730 Casie Aviles: Yep.
408 00:45:48.380 ⇒ 00:45:51.463 Uttam Kumaran: Cool. Okay, great. So now,
409 00:45:53.030 ⇒ 00:45:56.439 Uttam Kumaran: what we want to do is, so this is running locally
410 00:45:57.150 ⇒ 00:45:58.050 Casie Aviles: Yes.
411 00:45:58.550 ⇒ 00:45:59.340 Uttam Kumaran: Okay,
412 00:46:00.610 ⇒ 00:46:06.910 Uttam Kumaran: Now, what you want to do is go ahead and hit, publish, and
413 00:46:08.430 ⇒ 00:46:16.569 Uttam Kumaran: the next piece is to go ahead and hit this, and you can go create a create, a oh, you have to commit all this first, st
414 00:46:16.950 ⇒ 00:46:17.930 Uttam Kumaran: so
415 00:46:18.230 ⇒ 00:46:22.809 Uttam Kumaran: you can just make sure everything’s fine, and then you can write a commit message here, and then you could hit commit so
416 00:46:36.957 ⇒ 00:46:40.650 Casie Aviles: I did change the environment variable for
417 00:46:42.020 ⇒ 00:46:45.649 Casie Aviles: for real like, it was using Ryan’s
418 00:46:46.090 ⇒ 00:46:52.970 Uttam Kumaran: Oh, nice. Okay, that’s fine, I think. As long as you have it like.
419 00:46:53.570 ⇒ 00:46:56.829 Uttam Kumaran: oh, meaning you didn’t see the data unless you were using yours.
420 00:46:57.620 ⇒ 00:46:59.949 Casie Aviles: I think that’s how it works. Yes.
421 00:47:01.040 ⇒ 00:47:01.960 Uttam Kumaran: Okay,
422 00:47:12.860 ⇒ 00:47:17.869 Uttam Kumaran: Okay, go ahead and make this. Go ahead and push this. Pr, don’t don’t push the dot env.
423 00:47:18.570 ⇒ 00:47:20.949 Uttam Kumaran: But yeah, you added that to the get ignore right
424 00:47:22.610 ⇒ 00:47:24.450 Casie Aviles: Oh, yeah. Okay.
425 00:47:24.930 ⇒ 00:47:32.920 Uttam Kumaran: Yeah, it should already be ignored. Okay, just commit this, and then I’ll I sort of want to. I’ll I’m gonna add some changes from my side. So go ahead and hit, push origin.
426 00:47:33.680 ⇒ 00:47:36.459 Uttam Kumaran: and then you’ll see, pull, create, pull, request.
427 00:47:42.060 ⇒ 00:47:44.430 Uttam Kumaran: You can just hit preview or create. Yeah, whatever.
428 00:47:47.930 ⇒ 00:47:51.999 Uttam Kumaran: Yep. And then you can go ahead and just tag you can just like, yeah.
429 00:47:52.220 ⇒ 00:47:57.630 Uttam Kumaran: you can just say, add a descriptive title and a little description, and then you can add me as a suggested reviewer.
430 00:48:01.640 ⇒ 00:48:03.069 Casie Aviles: How do I add you again
431 00:48:04.820 ⇒ 00:48:09.540 Uttam Kumaran: Go to click on, just click on suggestions here, or click on reviewer. Sorry
432 00:48:11.400 ⇒ 00:48:12.190 Casie Aviles: Oh, okay.
433 00:48:12.760 ⇒ 00:48:14.740 Uttam Kumaran: And then you can look for me. Yeah.
434 00:48:34.460 ⇒ 00:48:36.430 Casie Aviles: I mean, this is pretty much it like.
435 00:48:38.730 ⇒ 00:48:40.890 Casie Aviles: do I just create the pull request? Now.
436 00:48:44.341 ⇒ 00:48:45.850 Uttam Kumaran: Yes, click, create, pull, request.
437 00:48:51.330 ⇒ 00:48:54.299 Uttam Kumaran: Nice. Okay. If you want to look at my screen. Now.
438 00:48:55.590 ⇒ 00:48:56.500 Casie Aviles: I’m just stuck
439 00:48:57.650 ⇒ 00:48:58.260 Uttam Kumaran: Okay?
440 00:48:59.286 ⇒ 00:49:01.620 Uttam Kumaran: So what you’re gonna see?
441 00:49:04.170 ⇒ 00:49:06.429 Uttam Kumaran: You’re gonna see that this is this is the
442 00:49:07.490 ⇒ 00:49:11.439 Uttam Kumaran: This is the ticket. Right? So you can see now the the pr got added. Here.
443 00:49:12.190 ⇒ 00:49:12.870 Casie Aviles: Yes.
444 00:49:13.230 ⇒ 00:49:18.139 Uttam Kumaran: Okay, cool. So one thing that I’m gonna do is I’m gonna go pull your
445 00:49:19.830 ⇒ 00:49:22.929 Uttam Kumaran: I’m going to go pull your code down and run it on my side.
446 00:49:25.910 ⇒ 00:49:30.280 Uttam Kumaran: so let me go ahead and do that. So if I go to Github
447 00:49:30.940 ⇒ 00:49:37.900 Uttam Kumaran: here so, as you can see, I already had. This is the code where I put in the the ABC conversation logs.
448 00:49:38.420 ⇒ 00:49:39.599 Uttam Kumaran: You see what I mean.
449 00:49:40.100 ⇒ 00:49:45.450 Uttam Kumaran: So what I’m gonna do now is I’m going to
450 00:49:47.490 ⇒ 00:49:51.520 Uttam Kumaran: I’m gonna switch to your branch.
451 00:49:58.640 ⇒ 00:50:01.690 Uttam Kumaran: Let me let me grab the latest.
452 00:50:06.210 ⇒ 00:50:07.930 Uttam Kumaran: Okay. So I’m gonna do there
453 00:50:11.730 ⇒ 00:50:13.160 Uttam Kumaran: one second.
454 00:50:26.500 ⇒ 00:50:33.920 Uttam Kumaran: Okay. So now I’m going to go into my Vs. I’m going to go into my cursor.
455 00:50:34.671 ⇒ 00:50:40.859 Uttam Kumaran: I’m going to go into Brainforge real let me go here.
456 00:50:41.090 ⇒ 00:50:48.410 Uttam Kumaran: I’m going to go ahead and also do real and poll.
457 00:50:54.700 ⇒ 00:50:57.039 Uttam Kumaran: And then I’m gonna do real upgrade
458 00:50:58.100 ⇒ 00:51:00.279 Uttam Kumaran: the get everything up to date.
459 00:51:09.930 ⇒ 00:51:11.479 Uttam Kumaran: Just gonna clean this up.
460 00:51:29.260 ⇒ 00:51:31.120 Uttam Kumaran: Oh, my God, I have so many.
461 00:51:46.590 ⇒ 00:51:49.090 Uttam Kumaran: Okay, so
462 00:51:59.800 ⇒ 00:52:02.960 Uttam Kumaran: okay, I’m going to do real start
463 00:52:06.720 ⇒ 00:52:07.660 Uttam Kumaran: cool.
464 00:52:08.440 ⇒ 00:52:10.770 Uttam Kumaran: This is the only one that isn’t working
465 00:52:11.190 ⇒ 00:52:17.500 Uttam Kumaran: just fine. One thing, though, that I want to do here is hold on! Let me just
466 00:52:18.030 ⇒ 00:52:20.099 Uttam Kumaran: bring a browser over here.
467 00:52:20.260 ⇒ 00:52:22.000 Uttam Kumaran: So if I go to real
468 00:52:22.450 ⇒ 00:52:29.770 Uttam Kumaran: ui.realdata.com. And I’m just going to have both of these side by side. I want to create a new project for ABC here.
469 00:52:30.020 ⇒ 00:52:35.520 Uttam Kumaran: So one thing that I’m gonna do here is I’m gonna hit this. I’m gonna say, real project.
470 00:52:36.190 ⇒ 00:52:39.300 Uttam Kumaran: And I’m gonna say, real project list.
471 00:52:40.250 ⇒ 00:52:42.140 Uttam Kumaran: And it looks like we have
472 00:52:42.260 ⇒ 00:52:46.249 Uttam Kumaran: brain forge, real brain forge, real run, brainforge, real manufacturing.
473 00:52:46.530 ⇒ 00:52:49.570 Uttam Kumaran: So what the heck are all these reinforce? Row one
474 00:52:55.230 ⇒ 00:53:00.909 Uttam Kumaran: so Brainforge, real manufacturing is nothing. So let me. Let me see if I can just drop brain forge real one.
475 00:53:02.620 ⇒ 00:53:05.200 Uttam Kumaran: Oh, actually, brain forge rail.
476 00:53:05.430 ⇒ 00:53:10.899 Uttam Kumaran: Normally, I’m gonna drop. And I’m gonna rename the other one. So let’s do
477 00:53:12.231 ⇒ 00:53:21.120 Uttam Kumaran: real project. Delete brain forge, rail, brain forge real?
478 00:53:22.180 ⇒ 00:53:27.219 Uttam Kumaran: And then I’m gonna do real project delete brain forge.
479 00:53:29.102 ⇒ 00:53:30.129 Uttam Kumaran: What is it?
480 00:53:30.370 ⇒ 00:53:43.759 Uttam Kumaran: Rail, manufacturing rail manufacture, the manufacturing rainforge drill manufacturing.
481 00:53:44.760 ⇒ 00:53:45.700 Uttam Kumaran: Nice.
482 00:53:46.220 ⇒ 00:53:50.180 Uttam Kumaran: Okay? So let’s also do real project.
483 00:53:50.370 ⇒ 00:53:54.160 Uttam Kumaran: And I want to do real project.
484 00:53:57.190 ⇒ 00:53:58.860 Uttam Kumaran: Is there a create.
485 00:54:07.880 ⇒ 00:54:11.050 Uttam Kumaran: Let me open up just the real stuff here.
486 00:54:12.400 ⇒ 00:54:13.630 Uttam Kumaran: So
487 00:54:38.230 ⇒ 00:54:41.910 Uttam Kumaran: so is real projects or real projects.
488 00:54:53.280 ⇒ 00:54:55.690 Uttam Kumaran: Oh, okay.
489 00:54:57.680 ⇒ 00:55:09.500 Uttam Kumaran: so we almost want to create. I see. Okay. So one of the things I’m gonna do here is I’m gonna do a new folder called ABC. Home and Commercial
490 00:55:11.980 ⇒ 00:55:16.350 Uttam Kumaran: or ABC home and commercial.
491 00:55:22.210 ⇒ 00:55:26.489 Uttam Kumaran: And what we’re gonna do here is I’m going to
492 00:55:26.990 ⇒ 00:55:32.139 Uttam Kumaran: go out of this CD to ABC home and commercial real.
493 00:55:35.150 ⇒ 00:55:37.480 Uttam Kumaran: What the heck is it to start here.
494 00:55:45.650 ⇒ 00:55:47.280 Uttam Kumaran: Real start.
495 00:55:49.800 ⇒ 00:55:51.989 Uttam Kumaran: Yes. So I’m gonna create a new project.
496 00:55:58.430 ⇒ 00:56:03.979 Uttam Kumaran: I’m gonna start with an empty project here. And what I’m actually gonna do now is, I’m going to just make sure that
497 00:56:04.180 ⇒ 00:56:07.459 Uttam Kumaran: we can move some of our sources up to here.
498 00:56:07.710 ⇒ 00:56:12.829 Uttam Kumaran: So I’m gonna go ahead in here. I’m gonna do a new folder called sources.
499 00:56:13.720 ⇒ 00:56:19.019 Uttam Kumaran: and I’m gonna have a new folder called dashboard. So you kind of see what I’m doing right? I’m just sort of isolating stuff
500 00:56:20.010 ⇒ 00:56:20.700 Casie Aviles: Yes.
501 00:56:20.880 ⇒ 00:56:23.371 Uttam Kumaran: So I’m gonna move our
502 00:56:24.230 ⇒ 00:56:27.839 Uttam Kumaran: these 3, I’m gonna move to sources.
503 00:56:28.430 ⇒ 00:56:35.059 Uttam Kumaran: And then, I’m also gonna create. I’m gonna move these 2,
504 00:56:35.780 ⇒ 00:56:42.350 Uttam Kumaran: all feedback. Great. I’m gonna move these to dashboards and
505 00:56:54.330 ⇒ 00:56:56.990 Uttam Kumaran: And one thing I’m gonna look at is
506 00:57:21.760 ⇒ 00:57:26.510 Uttam Kumaran: okay. So do we have this here. Let me just go make sure this is the project is here.
507 00:57:27.517 ⇒ 00:57:31.780 Uttam Kumaran: And then let me just go check on this real dot. Yaml here.
508 00:57:32.860 ⇒ 00:57:43.020 Uttam Kumaran: Okay, so gonna go to real dot Yaml, let’s say, ABC, home and commercial.
509 00:57:44.360 ⇒ 00:57:45.740 Uttam Kumaran: I’m going to
510 00:57:51.810 ⇒ 00:57:53.170 Uttam Kumaran: do this.
511 00:58:05.620 ⇒ 00:58:09.549 Uttam Kumaran: Let me just check what else I need to add here.
512 00:58:20.900 ⇒ 00:58:24.240 Uttam Kumaran: So this one, I’m also gonna just copy this.
513 00:58:24.740 ⇒ 00:58:28.189 Uttam Kumaran: And I’m gonna put a version of this here
514 00:58:31.370 ⇒ 00:58:35.169 Uttam Kumaran: and then let’s go ahead and see what we’re working with here.
515 00:58:36.980 ⇒ 00:58:40.220 Uttam Kumaran: So I’m gonna go out here. I’m gonna go real
516 00:58:45.410 ⇒ 00:58:47.900 Uttam Kumaran: I’m gonna go real start.
517 00:58:48.440 ⇒ 00:58:54.390 Uttam Kumaran: Let’s just check out what we got going on ABC home and commercial dashboards.
518 00:58:54.710 ⇒ 00:58:57.700 Uttam Kumaran: ABC. Brain trust models does not exist.
519 00:58:58.070 ⇒ 00:59:03.899 Uttam Kumaran: The one thing I’m also gonna do here is just check out how Ryan did this stuff for stack. Let’s
520 00:59:32.020 ⇒ 00:59:39.849 Uttam Kumaran: okay. So looks like what they did here is, this is actually
521 00:59:46.540 ⇒ 00:59:53.200 Uttam Kumaran: So this is actually metrics. And then the dashboards themselves.
522 00:59:55.440 ⇒ 00:59:58.360 Uttam Kumaran: I’m gonna go here and go new.
523 00:59:59.810 ⇒ 01:00:01.875 Uttam Kumaran: Oh, shit! I have to run!
524 01:00:02.220 ⇒ 01:00:04.920 Uttam Kumaran: Oh, let me let me call you back in 20 min.
525 01:00:05.390 ⇒ 01:00:06.399 Casie Aviles: Okay? Sure. Sure.
526 01:00:06.400 ⇒ 01:00:07.070 Casie Aviles: Okay. Okay. Bye.
527 01:01:39.630 ⇒ 01:01:40.580 Uttam Kumaran: Nice to meet you.
528 01:02:43.240 ⇒ 01:02:51.600 Uttam Kumaran: Awesome, very excited. Yeah, that is like what our next phase of world is right. Now, Marion and myself and Nico sort of manage all that.
529 01:02:51.780 ⇒ 01:03:15.190 Uttam Kumaran: We have a hundred other things we also do. So that’s usually just a tough, sore spot for us, so really excited to work with you on that, and yes, benefits, you know, is one of the big milestones that we’re looking for, you know, to offer for our, you know some us W. 2 folks here in the next quarter. So that’s definitely one thing from this meeting is like, what is our timeline towards that, and and
530 01:03:15.250 ⇒ 01:03:23.529 Uttam Kumaran: I don’t know anything about that. I’m i i’ll learn as much as I need to, but definitely looking to lean on this team as a resource there so
531 01:03:28.310 ⇒ 01:03:29.210 Uttam Kumaran: correct.
532 01:03:30.990 ⇒ 01:03:31.870 Uttam Kumaran: Yes.
533 01:03:36.070 ⇒ 01:03:43.989 Uttam Kumaran: we’ve tried to keep everything there. We have like one person. I still pay through wise because their bank account isn’t working with gusto.
534 01:03:45.084 ⇒ 01:03:48.400 Uttam Kumaran: But they are in gusto, and we’ve tried.
535 01:03:48.530 ⇒ 01:03:51.400 Uttam Kumaran: We try every time, and it usually just fails.
536 01:03:52.156 ⇒ 01:03:53.310 Uttam Kumaran: But yeah.
537 01:04:08.740 ⇒ 01:04:09.450 Uttam Kumaran: sure.
538 01:04:15.190 ⇒ 01:04:26.729 Uttam Kumaran: yeah. So maybe I’ll give a brief intro. And then, Nico, if you want to go, and then Marianne. So my name is Utah. Really nice to meet everyone. I’m the CEO of brain forge. Brain forge is the company I started in
539 01:04:27.930 ⇒ 01:04:51.478 Uttam Kumaran: July of 2023. I worked as a data engineer. For a number of startups in New York, and then moved here to Austin, a few years back, and then quit my job, and was sort of trying to figure out what’s next, and started the company. We primarily started as a data analytics. Consulting firm. Now, we offer both data analytics and AI services.
540 01:04:51.940 ⇒ 01:04:55.239 Uttam Kumaran: So everything around data infrastructure data, modeling analytics.
541 01:04:56.660 ⇒ 01:04:58.570 Uttam Kumaran: We’re now a team of
542 01:04:58.860 ⇒ 01:05:04.190 Uttam Kumaran: on any given day between 15 and 20 people, both part time and full time.
543 01:05:04.726 ⇒ 01:05:21.299 Uttam Kumaran: We have team globally, so we have a few people in New York and in La, and we have you know, Nico’s in Argentina. Marianne’s in the Philippines. We have a global team. I’m currently the only W. 2 Us. Employee.
544 01:05:21.964 ⇒ 01:05:29.650 Uttam Kumaran: But of course, we have some people. We’re trying to hire some roles where that’s going to change. So that’s on the forefront, I mean, yeah, we’re we.
545 01:05:30.190 ⇒ 01:05:47.779 Uttam Kumaran: you know, from the beginning. I’ve used someone to manage our books. I have a little bit of a financial background. I also done. We do a lot of financial data analysis. So I’m definitely like you don’t have to spare the jargon. I’m pretty familiar with with what we’re doing for ourselves, too. And I’m actually.
546 01:05:47.880 ⇒ 01:06:03.190 Uttam Kumaran: of course, we’re a data company. So having really great reporting and extremely specific reporting about each part of our income statement is really really important to me. Right now, as a function of time. I don’t spend much time looking at it. I have.
547 01:06:03.270 ⇒ 01:06:30.370 Uttam Kumaran: I know what’s coming in. I know what’s coming out, but I think with this team. We’ll work to really get better at how do we assign expenses? And for me to get a better sense of our of our profitability? And so yeah, we are in terms of what’s coming up. We are continuing to sign more clients. We have several clients. All in the Us across e-commerce. And software, typically like B, 2 C or B, 2 B sas, these clients are anywhere from
548 01:06:30.460 ⇒ 01:06:38.340 Uttam Kumaran: like anywhere from 5 to 100 million in revenue and our typical contract sizes are anywhere from 10 to 30 KA month.
549 01:06:39.290 ⇒ 01:06:57.550 Uttam Kumaran: We again do. We’re we primarily do engineering services. So we’ve used to charge a bit hourly. Now, most of our stuff is all fixed price monthly, and that’s where we’re really heading towards. Of course, sometimes clients. We move month to month. But that’s a lot of our billing structure. Everything’s like net. 30 payments.
550 01:06:58.330 ⇒ 01:07:02.139 Uttam Kumaran: Yeah, we have quickbooks all set up. Everything’s in gusto.
551 01:07:02.805 ⇒ 01:07:16.039 Uttam Kumaran: All of our employees are are through Google. Everybody’s in slack. And then we communicate through Zoom. We’ve done a pretty good job and really credit to Marianne on keeping all of our contracts organized for both people and for clients.
552 01:07:16.553 ⇒ 01:07:42.899 Uttam Kumaran: Definitely in quickbooks, though I have not we. Everything is in there. And we have an accounting firm that we work with. Now flow 5. That will be transitioning over. All the ledger items are there, whether they are accurately put in the right bucket. Definitely. Not so that’s probably something. As we go into this next tax season, I would love to probably review more of like, how we allocate expenses, some expenses definitely that are in there that are
553 01:07:43.320 ⇒ 01:07:48.229 Uttam Kumaran: probably need to be shuffled around. But everything is in there. So we’re not starting completely from 0.
554 01:07:50.290 ⇒ 01:08:12.120 Uttam Kumaran: yeah, that was a really long intro up for the business and for me. But I’m very, very excited to to work with you all. And yeah, this next phase is, we’re just, we’re growing really fast. So so this is definitely an area of support that we need. One last thing I’ll mention is, of course, healthcare, and being able to offer healthcare for our Wsw. 2 folks is really important, I think additionally.
555 01:08:13.010 ⇒ 01:08:16.130 Uttam Kumaran: I merged our business with
556 01:08:16.870 ⇒ 01:08:36.350 Uttam Kumaran: a now business partner of mine, and we’re currently deciding on the best forward structure for the business. And so one of the things I think a project that we’ll be working on is whether we need to transition this to a C Corp, whether we want to remain as S. Corp. How we do the equity. And then also talking about in the future, how we want to offer.
557 01:08:36.630 ⇒ 01:08:42.410 Uttam Kumaran: you know, potential equity incentives to either employees or to advisors. So that’s something also
558 01:08:43.020 ⇒ 01:08:46.210 Uttam Kumaran: on my to do. List to figure out with this crew.
559 01:08:46.594 ⇒ 01:08:51.289 Uttam Kumaran: But maybe I’ll pause. There, Nick, I would love if you want to introduce yourself and Marianne if you want to go next.
560 01:10:20.310 ⇒ 01:10:49.390 Uttam Kumaran: So with this crew, really, all of us are focused on operations. My role is shifting more to be more of a coach for all of our engineers, but also starting to focus on the business as a whole, and of course doing a lot more in sales. So yeah, I think this crew is probably the best interface with the with the business and sort of is for all of our employees. The 1st touch they have when they almost go into the offer stage and then also the the 1st touch for our our clients as well.
561 01:11:08.900 ⇒ 01:11:09.740 Uttam Kumaran: Yes.
562 01:11:24.460 ⇒ 01:11:25.230 Uttam Kumaran: great.
563 01:11:28.800 ⇒ 01:11:29.550 Uttam Kumaran: cool.
564 01:11:38.560 ⇒ 01:11:39.480 Uttam Kumaran: perfect.
565 01:12:08.850 ⇒ 01:12:09.640 Uttam Kumaran: Yeah.
566 01:12:15.320 ⇒ 01:12:16.060 Uttam Kumaran: Okay.
567 01:12:33.280 ⇒ 01:12:34.140 Uttam Kumaran: yes.
568 01:12:46.660 ⇒ 01:12:47.540 Uttam Kumaran: totally
569 01:13:10.230 ⇒ 01:13:10.940 Uttam Kumaran: great.
570 01:13:17.430 ⇒ 01:13:18.180 Uttam Kumaran: Yeah.
571 01:13:34.980 ⇒ 01:13:42.279 Uttam Kumaran: definitely. And this is actually something that we that I maintain I have a revenue growth model. I have an excel sheet where I look at
572 01:13:42.580 ⇒ 01:13:51.260 Uttam Kumaran: broadly, like operational metrics mixed with some financial metrics. We do have some key kpis like our our billable rates.
573 01:13:52.360 ⇒ 01:13:59.580 Uttam Kumaran: like kind of our average, hourly in terms of cost. Things like that. So that’ll definitely be like the other thing is, you know.
574 01:13:59.895 ⇒ 01:14:20.579 Uttam Kumaran: we’re gonna start to bring some of that data in, because lovely thing is, we’re a data company. So we do a lot of data visualization of our own data. And so I think I’ll be excited to not only see that in quickbooks, but also find some more automated ways to merge that with. Some of our other information, like, we have project management software where we’re looking at what everyone is tasked to do
575 01:14:20.610 ⇒ 01:14:41.179 Uttam Kumaran: for me, as I’m sort of leading engineering and execution. I’ll be looking a little bit at you know. What is our efficiency? How how we’re spending money on on folks and software, and how that links to to revenue growth. But definitely, I think it’ll be marrying both some of the operational stuff with the financial metrics. And then, definitely, I think, to have a pulse on
576 01:14:41.532 ⇒ 01:14:53.319 Uttam Kumaran: I think this business the toughest part is is you know, accounts receivable like we have. Everything’s like net 30 for us, but we have payments that are going out for employees, especially that are both mid month.
577 01:14:53.702 ⇒ 01:15:10.999 Uttam Kumaran: The nice thing is, we have some folks that are paid more on net 30, which is most of the contracts we’ve signed. But we I want to sort of try to shorten a lot of that. And so it’s a classic like cash flow struggle there that that I definitely need some help on how to strategically. You know, work within those bounds. So.
578 01:15:29.240 ⇒ 01:15:32.451 Uttam Kumaran: yeah, I agree. Same for me.
579 01:15:50.990 ⇒ 01:15:53.940 Uttam Kumaran: Yeah, we have New York and California.
580 01:15:54.612 ⇒ 01:15:58.239 Uttam Kumaran: We just have one more person that’s in the DC area. Now.
581 01:15:58.490 ⇒ 01:16:17.229 Uttam Kumaran: that’s like really the shortest term need for benefits. But I think I’ll sort of give you a layout of everybody we have, and where everybody is. But yes, in the shortest term it’s gonna be New York, Texas, and maybe one more. One more State. I don’t know whether he’s in Maryland or he’s in DC, actually.
582 01:16:49.590 ⇒ 01:17:02.009 Uttam Kumaran: yeah, and I guess one question is like during this process you know, it’s helpful for us to also get a lot organized like, I think we’ve been going to try to organize all of our customer contracts, all of our employee contracts.
583 01:17:02.290 ⇒ 01:17:08.460 Uttam Kumaran: but like any sort of framework you have for organizing that in in drive, or wherever that we can follow.
584 01:17:09.500 ⇒ 01:17:31.879 Uttam Kumaran: that would be so helpful, because I’m sort of directing that now. But we’re just doing that. I’m sort of doing that in anticipation of something like this. And so I just want to just do whatever the right thing is here, and make sure that we have everything in the right place, easily accessible, and of course, like as we do contract renewals with employees or adjustments, or with clients as well. How do we keep track of those?
585 01:17:32.383 ⇒ 01:17:42.210 Uttam Kumaran: That’s something that’s kind of like we have it in in our document platform, or in Pdfs like in adobe. But just, however, we organize all those.
586 01:17:48.890 ⇒ 01:18:15.260 Uttam Kumaran: Yes, we do so in terms of the con in terms of the clients. Yes, we have the renewal dates tracked that will likely move to Hubspot. We have it in notion right now. Hubspot will probably become like our sales. Crm, eventually. But then, of course, that’s also so. We we only have like we have, like 8 clients now so and roughly keep all those numbers in my head. But as we move, and right now those are just in spread, those are in A, we have just have a spreadsheet, and it’s a notion.
587 01:18:15.740 ⇒ 01:18:18.890 Uttam Kumaran: So yeah, it’s also in the contract, of course.
588 01:18:24.881 ⇒ 01:18:27.189 Uttam Kumaran: That’s also in. So we
589 01:18:27.360 ⇒ 01:18:46.409 Uttam Kumaran: we we’ve sent out for signing both through adobe cloud and through documents. So all of those we end up downloading and putting into Google drive as well. Just so, there’s like one place for for all those. I’m sure we’re missing some of the ones from like 2023 or early 2024. So
590 01:18:46.550 ⇒ 01:18:48.290 Uttam Kumaran: this will be helpful, as like
591 01:18:48.410 ⇒ 01:18:53.309 Uttam Kumaran: I start to see, like, what are we missing? I I have to just go into my computer and find those or my email.
592 01:18:59.940 ⇒ 01:19:00.730 Uttam Kumaran: Okay.
593 01:19:05.030 ⇒ 01:19:05.790 Uttam Kumaran: okay.
594 01:19:31.170 ⇒ 01:19:49.160 Uttam Kumaran: no, no, no, no like next quarter as an end of next quarter. No, but I mean I don’t. I just where I don’t know how long these things take, so I’m on your speed, whatever it is. We do have one employee. That we’re trying to bring on. And this is one of the core things that he needs.
595 01:19:49.460 ⇒ 01:19:55.240 Uttam Kumaran: But we he can also. One thing that we agreed with him is like, maybe he can just go on cobra. We can cover that
596 01:19:55.350 ⇒ 01:20:02.239 Uttam Kumaran: until we get established. But certainly for me. And my business partner, Robert.
597 01:20:02.340 ⇒ 01:20:21.780 Uttam Kumaran: we don’t. We’re not on health insurance right now. So we want to solve that problem ideally sometime soon. After not having health insurance for like a while. So it’s just top of mind, I would say, that is top of mind. And then, whatever we’re gonna do with yes, Corp or the C Corp, that’s the other. Those are the 2 things that are
598 01:20:21.880 ⇒ 01:20:25.230 Uttam Kumaran: really like the my core work streams that I’m trying to
599 01:20:25.400 ⇒ 01:20:35.529 Uttam Kumaran: just cross the box box off, you know. Of course there’s there’s everything else, and moving the business forward otherwise. But those are. Those are 2 2 things I want to get done as soon as we can.
600 01:20:49.440 ⇒ 01:20:50.320 Uttam Kumaran: Yeah.
601 01:21:07.640 ⇒ 01:21:08.470 Uttam Kumaran: bye.
602 01:21:15.710 ⇒ 01:21:19.690 Uttam Kumaran: Okay, I I’ve I’ve I’ve said, end of Q. 2.
603 01:21:19.820 ⇒ 01:21:21.320 Uttam Kumaran: As just a.
604 01:21:21.670 ⇒ 01:21:26.020 Uttam Kumaran: That’s what our goal is. So anything beyond that
605 01:21:26.240 ⇒ 01:21:44.669 Uttam Kumaran: like that would be great again. I I only I have some friends that work in like benefits, sector, and all I know is that there’s just like this is too complicated. So, but but it’s like whatever I can make a best decision for a short term and long term. And then understanding the cost. That’s that’s really what I need. You know.
606 01:21:48.450 ⇒ 01:21:49.325 Uttam Kumaran: Great.
607 01:21:57.430 ⇒ 01:21:58.110 Uttam Kumaran: Okay.
608 01:22:15.840 ⇒ 01:22:24.719 Uttam Kumaran: yeah, I mean you. You tell me, I mean, we’re about 10 days from this close. They’re gonna start working on, probably this month close. I think they asked me for some statements.
609 01:22:25.222 ⇒ 01:22:30.470 Uttam Kumaran: We can all hop on a call access like we can. I can get you access to every single thing
610 01:22:30.910 ⇒ 01:22:37.279 Uttam Kumaran: whenever so just sort of running on your cadence as you guys see fit.
611 01:22:52.130 ⇒ 01:23:06.860 Uttam Kumaran: Yes, yeah, we have. We have an accounting at Brain Forge, and then I sent bills get sent there. And then, yeah, typically, our invoices get sent out from it gets sent out for that, or it gets sent over from quickbooks. But CC to that or whatever the process is. Yeah.
612 01:23:17.710 ⇒ 01:23:18.490 Uttam Kumaran: cool.
613 01:23:29.670 ⇒ 01:23:30.460 Uttam Kumaran: Great.
614 01:23:40.540 ⇒ 01:23:41.250 Uttam Kumaran: Okay.
615 01:23:51.260 ⇒ 01:23:52.130 Uttam Kumaran: totally
616 01:23:56.790 ⇒ 01:24:04.739 Uttam Kumaran: individual level. Yeah, yeah, we we have like a bunch of clients where, yeah, we
617 01:24:04.990 ⇒ 01:24:21.099 Uttam Kumaran: we? We’re so we have a 1 password that we have set up for accounting. I’m happy to share that with with everybody here, and then, if there’s stuff we need to share password wise that can all go into there. Or if you guys use a password manager, we can go into there. But yeah, this is something we deal with with.
618 01:24:21.330 ⇒ 01:24:29.720 Uttam Kumaran: like every customer in one form or another, where there was like. Oh, I don’t know. Our one password is like a thousand different accounts in it. So I think we’re pretty good at like
619 01:24:29.870 ⇒ 01:24:32.129 Uttam Kumaran: segmenting it. And
620 01:24:32.340 ⇒ 01:24:36.960 Uttam Kumaran: yeah, just running past. If there’s stuff we need to share, we can, we can have it all there. It’s fine.
621 01:24:39.750 ⇒ 01:24:45.639 Uttam Kumaran: Yeah. Yeah. So actually, one password just added, the ability to do Mfa in there.
622 01:24:46.010 ⇒ 01:24:56.189 Uttam Kumaran: which is really really helpful because we’re we’re well. We’re cheaping out on some software where we’re all sharing some stuff and it’s helpful to have the
623 01:24:56.310 ⇒ 01:24:59.390 Uttam Kumaran: the 2 fa thing in there as a code.
624 01:25:03.720 ⇒ 01:25:09.280 Uttam Kumaran: So who’s got the email with what login code? Yeah, yes.
625 01:25:17.900 ⇒ 01:25:29.029 Uttam Kumaran: We also, we use slack for all of our communication. If you guys are interested in in getting out of there. Or if you guys also use slack, we can do slack, connect. I mean, email and
626 01:25:29.440 ⇒ 01:25:37.550 Uttam Kumaran: meetings is totally fine. Also call, Okay.
627 01:25:50.690 ⇒ 01:25:51.490 Uttam Kumaran: perfect.
628 01:26:04.490 ⇒ 01:26:12.320 Uttam Kumaran: So we already have a, we have a finance channel. I can just try to add y’all to that. And then we can all.
629 01:26:12.490 ⇒ 01:26:17.810 Uttam Kumaran: It’s just fine. It’s just anything related to anything sensitive like finance. Legal. Hr.
630 01:26:17.960 ⇒ 01:26:24.329 Uttam Kumaran: it just goes into there. We also have an operations channel. But maybe we’ll just start with the one finance channel. Then, if there’s anything else
631 01:26:24.440 ⇒ 01:26:31.399 Uttam Kumaran: you guys want to share on your end, we could do that. That would work perfectly. I mean, we’re in slack all day. So that’s where our company works.
632 01:26:47.940 ⇒ 01:26:48.610 Uttam Kumaran: Okay.
633 01:27:23.580 ⇒ 01:27:24.310 Uttam Kumaran: okay?
634 01:27:32.290 ⇒ 01:27:33.160 Uttam Kumaran: Perfect.
635 01:27:37.520 ⇒ 01:27:38.260 Uttam Kumaran: Okay?
636 01:27:39.740 ⇒ 01:27:40.490 Uttam Kumaran: Perfect.
637 01:28:13.020 ⇒ 01:28:30.200 Uttam Kumaran: Yeah. And it’s nice. We have some redundancy, too, because I’m anything I touch. The that’s a risk of the ball getting dropped these days. So we have, like some redundancy around the team. There’s so some stuff in my brain that I think this process will help us get all that out, especially about like the 2023, like early 2024.
638 01:28:30.663 ⇒ 01:28:36.730 Uttam Kumaran: I have it all. I have it all the data. I have, everything saved. So I knew that there’d be a time where we need everything.
639 01:28:37.223 ⇒ 01:28:42.396 Uttam Kumaran: So we have all the old contracts. I have all the company file everything we need.
640 01:28:44.050 ⇒ 01:28:48.700 Uttam Kumaran: So just tell me what you need and how fast you need us to move. And yeah, I think we’re good.
641 01:29:08.890 ⇒ 01:29:09.650 Uttam Kumaran: Okay.
642 01:29:22.280 ⇒ 01:29:35.130 Uttam Kumaran: yeah, not like all pen and paper. No, I I knew this day would come, of course, like, when I started the company. You don’t know what it’s gonna be. But I was like, Okay, just like, make sure we do all this stuff right. And so everything’s in there somewhere.
643 01:29:35.290 ⇒ 01:29:39.179 Uttam Kumaran: Nothing’s like, not tracked. So yeah, I’m glad.
644 01:29:43.440 ⇒ 01:29:44.260 Uttam Kumaran: Okay.
645 01:29:50.050 ⇒ 01:29:51.860 Uttam Kumaran: perfect. Thank you so much.
646 01:29:53.160 ⇒ 01:29:53.940 Uttam Kumaran: Bye.