Meeting Title: Brainforge Omni Analytics Integration Sync Date: 2026-02-04 Meeting participants: Elizah Joy, Sheshu Chandrasekar, Mustafa Raja


WEBVTT

1 00:00:33.350 00:00:34.860 Elizah Joy: Hi, can you hear me?

2 00:00:35.190 00:00:39.179 Sheshu Chandrasekar: Yep, I can hear you, that was weird. I was in the waiting room.

3 00:00:39.730 00:00:42.699 Elizah Joy: I’m so sorry about that, I did not realize.

4 00:00:43.400 00:00:51.120 Sheshu Chandrasekar: No, you’re okay. It happens. My… I’ve been having technical difficulties all morning today. It’s kind of weird, so… glad we’re able to do this.

5 00:00:52.070 00:00:52.560 Elizah Joy: All right.

6 00:00:52.560 00:00:53.379 Sheshu Chandrasekar: Cool.

7 00:00:54.090 00:00:59.299 Elizah Joy: Let me show you what I currently have. The one thing that I am, like.

8 00:01:00.100 00:01:10.890 Elizah Joy: sure, or something, is that I can’t pull out the data from here. I’m not sure if I did this correctly or set this up correctly. Like, whenever I try…

9 00:01:12.430 00:01:24.590 Elizah Joy: It’s just… Like, whenever I try adding in the dashboards, It does not It’s… Yeah, it just did the…

10 00:01:24.590 00:01:25.710 Sheshu Chandrasekar: Protestant key.

11 00:01:26.380 00:01:28.690 Elizah Joy: Yeah, okay, this one’s that.

12 00:01:29.190 00:01:40.590 Elizah Joy: Not sure. And then the… what’s this? Like, the data that it gets is from… the other…

13 00:01:43.230 00:01:47.070 Elizah Joy: Workbook that we have, but… Not sure.

14 00:01:48.240 00:01:55.069 Sheshu Chandrasekar: Okay, let’s start with one table. Let’s, let’s do linear issues, just for the test.

15 00:01:55.980 00:01:56.910 Elizah Joy: It’s sweet.

16 00:01:56.910 00:01:57.460 Sheshu Chandrasekar: Yeah.

17 00:02:03.650 00:02:04.430 Elizah Joy: Strait.

18 00:02:09.410 00:02:10.090 Sheshu Chandrasekar: Okay.

19 00:02:16.000 00:02:18.299 Sheshu Chandrasekar: Let’s just add all the fields in there.

20 00:02:33.300 00:02:38.490 Sheshu Chandrasekar: Oh, okay, I see what it’s doing. Let’s delete columns B through E.

21 00:02:38.700 00:02:42.699 Sheshu Chandrasekar: I was just trying to get the entire table. That was, like, my big thing. See if we can do.

22 00:02:42.700 00:02:44.099 Elizah Joy: Okay.

23 00:02:46.120 00:02:51.430 Elizah Joy: This one up until… Letter E, right? Oh, okay.

24 00:02:51.430 00:02:52.530 Sheshu Chandrasekar: Oh, yeah, yeah.

25 00:03:01.240 00:03:02.190 Elizah Joy: Okay.

26 00:03:02.190 00:03:05.010 Sheshu Chandrasekar: Why is the… why is that data now hidden?

27 00:03:09.550 00:03:10.940 Sheshu Chandrasekar: By calling me?

28 00:03:13.740 00:03:16.229 Elizah Joy: I’m not sure of that.

29 00:03:16.230 00:03:19.349 Sheshu Chandrasekar: Let’s… let’s drag that in again, see what happens.

30 00:03:30.410 00:03:31.150 Elizah Joy: Hmm.

31 00:03:31.920 00:03:33.179 Sheshu Chandrasekar: Yeah, that’s weird, okay.

32 00:03:34.690 00:03:37.929 Sheshu Chandrasekar: Okay, what’s the table that you’re working with right now?

33 00:03:38.790 00:03:42.949 Elizah Joy: So, this one is… this is just for the software, still. I think…

34 00:03:42.950 00:03:43.620 Sheshu Chandrasekar: Okay.

35 00:03:43.840 00:03:49.549 Elizah Joy: One thing for me is that once I figured out how it gets the data.

36 00:03:49.740 00:03:52.819 Elizah Joy: I think it’ll be easy for me. Not easy, but…

37 00:03:52.970 00:03:56.919 Elizah Joy: It’ll be manageable for me to set up the other.

38 00:03:56.920 00:03:57.560 Sheshu Chandrasekar: Yeah.

39 00:03:57.560 00:03:59.550 Elizah Joy: expenses that we have. So yeah.

40 00:04:00.000 00:04:06.080 Elizah Joy: that on my end. It’s just, at the moment, it’s not… showing.

41 00:04:09.470 00:04:14.369 Sheshu Chandrasekar: Hmm, okay, let’s remove all the columns. Let’s see if there’s something simpler that we can do.

42 00:04:15.320 00:04:17.629 Sheshu Chandrasekar: Cause I think it’s mess… it’s not…

43 00:04:18.339 00:04:21.700 Sheshu Chandrasekar: It’s messing up, like, there’s no relationship between.

44 00:04:21.700 00:04:22.420 Elizah Joy: The two.

45 00:04:22.420 00:04:25.110 Sheshu Chandrasekar: columns that we added. So we need to find something that has, like.

46 00:04:25.410 00:04:28.870 Sheshu Chandrasekar: a good, like, relationship, so if we go up…

47 00:04:30.990 00:04:34.530 Sheshu Chandrasekar: what does that say? No schema, clockify…

48 00:04:36.340 00:04:41.580 Sheshu Chandrasekar: Without everything from that Clockify right there. This… the top one?

49 00:04:42.270 00:04:47.479 Sheshu Chandrasekar: Like, if we could… No, yeah, right there. See, this right control? Right click?

50 00:04:50.050 00:04:52.329 Sheshu Chandrasekar: It doesn’t let you, like, just drag it.

51 00:04:54.550 00:04:55.870 Elizah Joy: No.

52 00:04:55.870 00:04:57.629 Sheshu Chandrasekar: No. That’s weird.

53 00:04:58.930 00:05:07.320 Sheshu Chandrasekar: Okay. Let’s just add the… don’t add, like, the sub, just add date and time.

54 00:05:07.320 00:05:08.290 Elizah Joy: Sometimes.

55 00:05:08.290 00:05:09.330 Sheshu Chandrasekar: Let’s see what happens.

56 00:05:23.300 00:05:24.800 Elizah Joy: And then start time.

57 00:05:31.310 00:05:32.050 Sheshu Chandrasekar: Okay.

58 00:05:32.320 00:05:34.689 Sheshu Chandrasekar: And then duration of minutes, maybe?

59 00:05:34.810 00:05:36.970 Sheshu Chandrasekar: Yeah, that works, yeah, it’s good.

60 00:05:40.250 00:05:44.869 Sheshu Chandrasekar: And then, can we see who submitted? Like, if there’s, like, a who?

61 00:05:45.010 00:05:47.600 Sheshu Chandrasekar: Standardized team name, or username right there.

62 00:05:52.040 00:05:56.549 Sheshu Chandrasekar: Oh, okay, perfect, so it’s pulling everything, it’s pulling the date, the start time, the end time.

63 00:05:56.750 00:06:03.450 Sheshu Chandrasekar: And then… Yeah, when they… Okay, yeah, that’s nice.

64 00:06:04.800 00:06:09.060 Sheshu Chandrasekar: So I guess it’s really, like, relationship-based, okay?

65 00:06:09.440 00:06:12.560 Sheshu Chandrasekar: If we want to do a software expense, let’s look for a software name.

66 00:06:21.380 00:06:23.869 Sheshu Chandrasekar: Okay, so we need to import that data.

67 00:06:24.980 00:06:31.480 Elizah Joy: Is that different from… Like, adding those data in here, right?

68 00:06:32.710 00:06:39.439 Sheshu Chandrasekar: Yeah, I mean, let’s say add field, let’s see what it says. I wonder if you go to File, if you can just import, like, a datasheet.

69 00:06:39.760 00:06:40.979 Sheshu Chandrasekar: Is that what you tried doing?

70 00:06:40.980 00:06:48.520 Elizah Joy: Yeah, that’s what I did try doing, but it did not… pull anything here, so I’m…

71 00:06:48.520 00:06:49.200 Sheshu Chandrasekar: That’s exciting.

72 00:06:49.200 00:06:52.799 Elizah Joy: the way that… I think it’s the way that I’ve set it up.

73 00:06:53.540 00:06:55.800 Sheshu Chandrasekar: Maybe it’s, like, the mapping, maybe?

74 00:06:56.350 00:06:59.590 Elizah Joy: Yeah, because I did… what I did was I imported the…

75 00:06:59.770 00:07:06.660 Elizah Joy: The spread… not the entire spreadsheet for financial models, but the software expenses that we have.

76 00:07:07.030 00:07:12.400 Elizah Joy: That spreadsheet, but it’s… I don’t think… yeah, nothing’s showing.

77 00:07:13.730 00:07:16.590 Sheshu Chandrasekar: Okay, let me see if there’s a… you did that on Google Sheets, right?

78 00:07:16.830 00:07:18.620 Elizah Joy: Yeah, Google Sheets.

79 00:07:19.180 00:07:22.979 Sheshu Chandrasekar: Okay, let me see if there is an integration.

80 00:07:27.430 00:07:31.469 Sheshu Chandrasekar: Omni Analytics integrates with Google Sheets to demolitize scheduled data.

81 00:07:33.500 00:07:36.049 Sheshu Chandrasekar: Let’s say we want to import it.

82 00:07:45.330 00:07:52.929 Sheshu Chandrasekar: Okay, let’s do this. Let’s try doing it again. Let’s, go to Google Sheets.

83 00:07:53.570 00:07:54.300 Sheshu Chandrasekar: And then…

84 00:07:54.840 00:07:57.930 Sheshu Chandrasekar: download the CSV, or if you already have it, that’s fine. We can… and then go to.

85 00:07:57.930 00:08:01.540 Elizah Joy: Yeah, I do have the CSV of that.

86 00:08:02.370 00:08:09.570 Elizah Joy: How… Should I create a different, like… file for.

87 00:08:09.570 00:08:12.019 Sheshu Chandrasekar: No, I think… I think it’s fine.

88 00:08:12.150 00:08:13.900 Sheshu Chandrasekar: No, you’re good. I think it’s fine.

89 00:08:14.350 00:08:16.189 Sheshu Chandrasekar: Yeah, just go to File real quick.

90 00:08:16.970 00:08:18.389 Sheshu Chandrasekar: Top left.

91 00:08:19.950 00:08:20.980 Elizah Joy: Okay.

92 00:08:21.500 00:08:27.090 Sheshu Chandrasekar: And then it probably… wow, there’s no import. Okay, let’s do edit then, see what happens.

93 00:08:32.169 00:08:40.419 Sheshu Chandrasekar: Okay, now let’s do… file… Okay, right now it’s looking at the thing that we created. Okay.

94 00:08:48.850 00:08:49.930 Elizah Joy: Wait, let me try…

95 00:08:49.930 00:08:51.290 Sheshu Chandrasekar: Liza, give me one second.

96 00:08:51.510 00:08:52.779 Elizah Joy: Yep, sure.

97 00:09:02.810 00:09:11.639 Sheshu Chandrasekar: Okay, I think I… maybe… let’s delete rows 1 through 5? Maybe it’s, like, getting confused, right, that it’s not a table.

98 00:09:12.260 00:09:13.870 Elizah Joy: Mmm, okay.

99 00:09:18.810 00:09:21.240 Sheshu Chandrasekar: Perfect, okay, and then let’s delete column A.

100 00:09:22.560 00:09:24.000 Sheshu Chandrasekar: And row 1 again.

101 00:09:28.080 00:09:30.899 Sheshu Chandrasekar: Okay, now let’s save sheet.

102 00:09:31.560 00:09:34.499 Sheshu Chandrasekar: I wonder if we can map it. Let’s go to data.

103 00:09:43.470 00:09:44.760 Sheshu Chandrasekar: Cook data one more time?

104 00:09:47.480 00:09:49.129 Elizah Joy: Which one?

105 00:09:49.760 00:09:52.220 Sheshu Chandrasekar: Right next to Foreman… yeah, right there.

106 00:09:53.740 00:10:00.440 Sheshu Chandrasekar: Let’s see… Okay, right now it acts as a… Okay.

107 00:10:02.030 00:10:02.580 Elizah Joy: I think…

108 00:10:02.580 00:10:05.759 Sheshu Chandrasekar: Okay, it’s acting like accelerating. Yeah.

109 00:10:07.610 00:10:10.679 Elizah Joy: I did that one, I’m not sure if that’ll help.

110 00:10:56.840 00:10:59.310 Sheshu Chandrasekar: How do I… how do I annotate?

111 00:10:59.420 00:11:01.299 Sheshu Chandrasekar: How do I draw something?

112 00:11:02.850 00:11:07.729 Sheshu Chandrasekar: Oh, wait, let’s go, let’s go to the end real quick. It says…

113 00:11:09.050 00:11:11.030 Sheshu Chandrasekar: That’s weird, okay, let’s delete those.

114 00:11:14.840 00:11:15.970 Sheshu Chandrasekar: SafeSheet.

115 00:11:17.150 00:11:19.240 Sheshu Chandrasekar: Oh, now we have, like, a perfect table.

116 00:11:21.130 00:11:29.599 Sheshu Chandrasekar: And now, click the little corner button right above the 2, right next to the one. Right, shoot.

117 00:11:30.290 00:11:32.560 Elizah Joy: Mmm… It’s the one.

118 00:11:39.380 00:11:41.840 Sheshu Chandrasekar: Sorry, one sec, I’m trying to figure out how I can draw.

119 00:11:44.070 00:11:50.850 Sheshu Chandrasekar: I’m trying to just draw it for you. So right here, you see how there’s a V1 right next to savings? Like, the… above column G?

120 00:11:53.070 00:11:53.750 Elizah Joy: Mmm…

121 00:11:54.540 00:11:58.459 Sheshu Chandrasekar: You see that little arrow? Like, that white arrow right next to column G?

122 00:12:00.420 00:12:05.850 Elizah Joy: Wait, let me… Okay.

123 00:12:07.690 00:12:10.190 Elizah Joy: Oh, this one.

124 00:12:10.740 00:12:12.980 Sheshu Chandrasekar: No, no, right, right below it, right below it.

125 00:12:13.860 00:12:17.730 Sheshu Chandrasekar: Yeah, that one. If you click on it, it should highlight the entire… yep, okay.

126 00:12:19.630 00:12:22.870 Sheshu Chandrasekar: Now we should do model.

127 00:12:24.820 00:12:25.420 Elizah Joy: What?

128 00:12:31.460 00:12:32.739 Sheshu Chandrasekar: Okay. Workbook.

129 00:12:33.270 00:12:34.659 Sheshu Chandrasekar: Yeah, the entire workbook.

130 00:12:42.060 00:12:44.660 Sheshu Chandrasekar: Okay, it’s still pulling in data from…

131 00:12:46.220 00:12:49.089 Sheshu Chandrasekar: Here, IRS Lab Omni opened up, so let me…

132 00:12:49.090 00:12:49.450 Elizah Joy: Mom?

133 00:12:49.890 00:12:52.640 Elizah Joy: I think it did pull Lee.

134 00:12:52.820 00:12:56.590 Elizah Joy: It didn’t pull the softwares that we have.

135 00:12:56.900 00:13:02.490 Elizah Joy: Oh, perfect. Operating… Yeah.

136 00:13:02.720 00:13:05.530 Elizah Joy: if… If I’m correct.

137 00:13:07.640 00:13:08.610 Elizah Joy: It’s just…

138 00:13:08.610 00:13:09.650 Sheshu Chandrasekar: Okay, that’s good.

139 00:13:14.430 00:13:14.919 Elizah Joy: I can see.

140 00:13:14.920 00:13:16.410 Sheshu Chandrasekar: Can you select a model.

141 00:13:22.820 00:13:25.629 Sheshu Chandrasekar: Here, I’m gonna ask the, Omni Google Sheet.

142 00:13:26.220 00:13:28.919 Sheshu Chandrasekar: I have a Google Sheet.

143 00:13:30.630 00:13:33.869 Sheshu Chandrasekar: I want to import… And built.

144 00:13:34.630 00:13:36.850 Sheshu Chandrasekar: Big dashboard on…

145 00:13:46.790 00:13:48.540 Sheshu Chandrasekar: One second, I’m reading the…

146 00:13:49.450 00:13:51.860 Sheshu Chandrasekar: The documents right now.

147 00:13:52.600 00:13:53.080 Elizah Joy: Yep, sure.

148 00:13:53.080 00:13:54.379 Sheshu Chandrasekar: Summary there. Yep.

149 00:14:22.780 00:14:26.869 Sheshu Chandrasekar: Okay, let’s do this, you’re right. We should definitely create a new one, just…

150 00:14:27.440 00:14:28.139 Elizah Joy: Mmm.

151 00:14:28.140 00:14:28.900 Sheshu Chandrasekar: that happens.

152 00:14:29.280 00:14:34.009 Sheshu Chandrasekar: I understand where the… the clockified data’s coming from. It’s coming from Snowflake?

153 00:14:34.610 00:14:41.449 Sheshu Chandrasekar: So, it looks like it’s already been pre-populated. They have the Eden database in there, Snowflake database.

154 00:14:41.710 00:14:44.750 Sheshu Chandrasekar: So, all the things that we were seeing earlier was already there.

155 00:14:45.320 00:14:50.010 Elizah Joy: Okay, so that’s that one, we have to add the fields, like, manually?

156 00:14:50.010 00:14:52.239 Sheshu Chandrasekar: Yeah, we probably have to add it manually.

157 00:14:52.340 00:14:53.199 Sheshu Chandrasekar: For right now.

158 00:14:54.050 00:14:54.940 Elizah Joy: like…

159 00:14:57.730 00:14:59.639 Sheshu Chandrasekar: Yeah, just pressed home,

160 00:15:02.440 00:15:09.910 Sheshu Chandrasekar: Okay, and then, yeah, let’s create… go to my documents, and then just create a new, like, entire file.

161 00:15:32.170 00:15:33.889 Sheshu Chandrasekar: This is so weird. How do you…

162 00:15:35.130 00:15:37.680 Sheshu Chandrasekar: How do you create a dashboard? Okay.

163 00:15:37.680 00:15:43.419 Elizah Joy: Yeah, I did, like, when I tried setting it up, it’s, like, folder, inside folders.

164 00:15:43.970 00:15:45.460 Sheshu Chandrasekar: That’s crazy. Okay.

165 00:15:46.050 00:15:47.800 Elizah Joy: Let’s just try this one.

166 00:15:51.420 00:15:52.970 Sheshu Chandrasekar: Where are you, Omni?

167 00:15:56.460 00:15:58.650 Elizah Joy: Okay, it’s a folder again.

168 00:15:59.820 00:16:00.530 Elizah Joy: Hmm.

169 00:16:02.180 00:16:03.930 Sheshu Chandrasekar: Okay, I’m looking at it right now.

170 00:16:31.800 00:16:36.090 Sheshu Chandrasekar: How do I create a dashboard using… Too many sheets.

171 00:16:37.100 00:16:42.930 Sheshu Chandrasekar: Okay, yeah, this UI is super weird, so I need to… I’m just asking the Omni assistant right now.

172 00:16:46.610 00:16:47.540 Elizah Joy: Hmm.

173 00:16:54.180 00:16:56.410 Elizah Joy: Like… Hmm.

174 00:16:56.600 00:16:57.120 Elizah Joy: Sus…

175 00:16:58.310 00:17:04.849 Sheshu Chandrasekar: It says you can upload CSV Excel files and put in workbooks, then build dashboards from there. Okay.

176 00:17:06.210 00:17:08.569 Sheshu Chandrasekar: Can you drop, like, a…

177 00:17:10.660 00:17:12.000 Elizah Joy: the CS… the CSO.

178 00:17:12.000 00:17:13.540 Sheshu Chandrasekar: Yeah, the CSV in there, yeah.

179 00:17:13.540 00:17:15.310 Elizah Joy: Here, let me try…

180 00:17:55.530 00:18:02.219 Sheshu Chandrasekar: Otherwise… we probably just will have to abandon Omni, because I’m understanding that Omni is only used with…

181 00:18:03.210 00:18:09.450 Sheshu Chandrasekar: Snowflake, Google… yeah, these are, like, big databases, not, like, something small for us.

182 00:18:11.060 00:18:17.170 Sheshu Chandrasekar: Which I think would be easier for… For us, honestly.

183 00:18:17.530 00:18:23.249 Elizah Joy: Let me just… John, but again, I can’t find it in my…

184 00:18:24.240 00:18:24.870 Sheshu Chandrasekar: Yeah.

185 00:18:25.290 00:18:26.370 Elizah Joy: downloads.

186 00:19:09.860 00:19:15.289 Sheshu Chandrasekar: Hey, so I’m looking at this right now. I don’t think there’s a, like, a Google Sheets…

187 00:19:16.810 00:19:21.980 Sheshu Chandrasekar: connection, but we can upload to CSV, but…

188 00:19:23.020 00:19:28.569 Sheshu Chandrasekar: I think it’s only coming from, like, a database, not, like… we can’t drag it from our computer or anything like that.

189 00:19:30.760 00:19:33.749 Sheshu Chandrasekar: Like, if you have it offline, you can’t add it to…

190 00:19:33.940 00:19:36.540 Sheshu Chandrasekar: on me. It’s gotta come from a database.

191 00:19:45.960 00:19:55.279 Elizah Joy: what I did with… Let me just… the previous one is, I think I added that… Can’t remember.

192 00:19:56.190 00:19:57.389 Elizah Joy: To where?

193 00:20:02.480 00:20:08.100 Elizah Joy: But I was able to upload the… CSV file.

194 00:20:10.910 00:20:13.110 Sheshu Chandrasekar: Got it, let me see, Google Sheets…

195 00:20:13.950 00:20:16.459 Elizah Joy: And now I can’t figure out how.

196 00:20:17.510 00:20:18.999 Elizah Joy: Oh, we added that.

197 00:20:35.650 00:20:38.869 Sheshu Chandrasekar: Here, let me ping Mustafo, see if he’s able to join.

198 00:21:18.630 00:21:21.749 Sheshu Chandrasekar: Okay, just paying Mustafo, let’s see what he says.

199 00:21:22.130 00:21:24.510 Sheshu Chandrasekar: Meanwhile… I can.

200 00:21:25.870 00:21:29.090 Elizah Joy: Yeah, I think… I think what I did bef- I think I…

201 00:21:29.350 00:21:35.760 Elizah Joy: added… I accidentally added this in… Maybe in this snowflake?

202 00:21:37.480 00:21:40.299 Elizah Joy: database, so I was able to add…

203 00:21:40.730 00:21:44.150 Elizah Joy: Because it’s, it’s getting the data from that, right?

204 00:21:44.580 00:21:46.389 Sheshu Chandrasekar: Yeah, so that’s what I’m doing right now.

205 00:21:48.170 00:21:52.999 Sheshu Chandrasekar: Sure. I can share my screen, so you… Yep, sure. Yeah, let me do that.

206 00:21:53.480 00:22:01.790 Sheshu Chandrasekar: Okay, so I did exactly what you just said right now, because I was kind of curious. So… say…

207 00:22:04.330 00:22:08.230 Sheshu Chandrasekar: Okay, let me just go to… do you have the Google Sheets shared in me, by the way?

208 00:22:08.230 00:22:12.210 Elizah Joy: Yep, I will… I’ll send it in there.

209 00:22:13.130 00:22:14.249 Sheshu Chandrasekar: Sweet, thank you.

210 00:22:14.840 00:22:18.240 Elizah Joy: I think it’s… It’s better if I send in Slack.

211 00:22:18.690 00:22:19.870 Elizah Joy: Or this.

212 00:22:20.280 00:22:24.289 Sheshu Chandrasekar: No, you can just send it, like, you can just share it to me using my Brainforge email.

213 00:22:24.920 00:22:26.450 Sheshu Chandrasekar: Is it Google Sheets, right?

214 00:22:26.920 00:22:30.000 Elizah Joy: Yeah, or let me just upload it here.

215 00:22:30.370 00:22:32.580 Elizah Joy: If… if it’s easier.

216 00:22:34.070 00:22:35.440 Elizah Joy: Okay.

217 00:22:36.820 00:22:39.220 Elizah Joy: Okay, I’m… okay, I’ve sent it.

218 00:22:42.250 00:22:43.050 Sheshu Chandrasekar: That’d be cool.

219 00:22:45.510 00:22:48.260 Sheshu Chandrasekar: Mustaf is able to join, so let me add him here.

220 00:23:01.350 00:23:02.630 Sheshu Chandrasekar: Alright.

221 00:23:12.510 00:23:13.190 Mustafa Raja: Hey.

222 00:23:14.330 00:23:15.510 Sheshu Chandrasekar: Hey, Mustafa!

223 00:23:17.150 00:23:19.720 Mustafa Raja: How are you doing today? Yeah, doing good, how are you?

224 00:23:20.230 00:23:25.550 Sheshu Chandrasekar: Good. So, right now, we are trying to,

225 00:23:26.490 00:23:30.119 Sheshu Chandrasekar: connect, like, a spreadsheet to our Omni database.

226 00:23:30.950 00:23:37.450 Sheshu Chandrasekar: And so we built this file in the… Brainforge…

227 00:23:37.560 00:23:41.199 Sheshu Chandrasekar: Snowflake database, or Snowflake, model.

228 00:23:42.020 00:23:42.500 Elizah Joy: So…

229 00:23:43.370 00:23:45.960 Sheshu Chandrasekar: And Eliza shared…

230 00:23:46.810 00:23:51.039 Mustafa Raja: Sorry, and then goal would be to have it in some, dashboard, right?

231 00:23:51.550 00:23:52.760 Sheshu Chandrasekar: Yeah, exactly.

232 00:23:53.510 00:23:57.330 Mustafa Raja: Okay, so we have the data sources that we need here.

233 00:23:58.480 00:24:03.980 Sheshu Chandrasekar: No, we don’t. So, I have it right now, let me…

234 00:24:03.980 00:24:06.080 Elizah Joy: It’s in Zoom.

235 00:24:06.790 00:24:07.480 Sheshu Chandrasekar: Oh, it’s in Zoom.

236 00:24:07.840 00:24:08.530 Elizah Joy: Yep, yep.

237 00:24:10.510 00:24:11.039 Sheshu Chandrasekar: Sorry, say that one?

238 00:24:11.040 00:24:11.900 Elizah Joy: Amazing.

239 00:24:14.570 00:24:15.840 Mustafa Raja: Visiting the Zoom chat?

240 00:24:16.330 00:24:18.180 Sheshu Chandrasekar: Yeah, it’s in the Zoom chat right here.

241 00:24:18.360 00:24:20.230 Mustafa Raja: I can… I can’t cheat.

242 00:24:21.510 00:24:22.340 Elizah Joy: Oh, what?

243 00:24:22.660 00:24:23.550 Elizah Joy: Okay.

244 00:24:30.570 00:24:33.330 Mustafa Raja: Sorry, what’s the… what’s the data source here that we need?

245 00:24:34.690 00:24:37.250 Sheshu Chandrasekar: So, this is the data source that we need.

246 00:24:38.460 00:24:44.049 Mustafa Raja: Okay… And this is all local on your machine?

247 00:24:44.400 00:24:46.220 Sheshu Chandrasekar: Yeah, it’s all local in my machine.

248 00:24:46.590 00:24:51.550 Mustafa Raja: Okay, so we need to get it somewhere, right? Wait, let me figure that out.

249 00:24:52.470 00:24:55.189 Mustafa Raja: And these are all CSVs, I believe.

250 00:24:55.190 00:24:57.000 Sheshu Chandrasekar: These are all CSV scopes. Yeah.

251 00:24:58.360 00:25:02.920 Mustafa Raja: I’m wondering if we can just dump these in a data warehouse that we have?

252 00:25:03.690 00:25:05.679 Mustafa Raja: Wait. Give me a moment.

253 00:25:06.240 00:25:07.189 Sheshu Chandrasekar: Yeah, no worries.

254 00:25:07.380 00:25:13.009 Mustafa Raja: One more thing that I would want to… can you pull up one of these, one of these spreadsheets?

255 00:25:13.650 00:25:14.280 Sheshu Chandrasekar: Yeah.

256 00:25:14.520 00:25:18.609 Sheshu Chandrasekar: Eliza, is this one the most recent? Yeah, this looks the most recent.

257 00:25:18.880 00:25:22.390 Mustafa Raja: So… Do we need these… sorry.

258 00:25:23.470 00:25:30.660 Mustafa Raja: Let me… No, we don’t, we don’t need these rows right here. Okay, yeah, so it can be just, it can be just, in addition.

259 00:25:30.660 00:25:31.310 Sheshu Chandrasekar: to inform them.

260 00:25:31.310 00:25:33.479 Mustafa Raja: Yeah, yeah, this, this, like this, okay.

261 00:25:33.600 00:25:37.850 Mustafa Raja: Okay, yeah, that… okay, I can… we can just push that to…

262 00:25:38.740 00:25:45.080 Mustafa Raja: somewhere… let me see what sort of data connectors does Omni accept, and then we can… I’m moving forward.

263 00:25:45.080 00:25:46.150 Sheshu Chandrasekar: Yeah, so…

264 00:25:46.150 00:25:46.500 Mustafa Raja: minimal.

265 00:25:46.500 00:25:48.310 Sheshu Chandrasekar: It seems like… Yeah.

266 00:25:49.330 00:25:50.550 Mustafa Raja: Yeah, yeah, go on.

267 00:25:50.910 00:25:54.700 Sheshu Chandrasekar: No, no, no, I was just saying, it seems like they only take in data warehouses?

268 00:25:55.200 00:26:00.310 Sheshu Chandrasekar: like, Snowflake, your Databricks, SQL, MySQL.

269 00:26:00.460 00:26:02.819 Mustafa Raja: But we just want to work with spreadsheets right now.

270 00:26:04.160 00:26:09.320 Mustafa Raja: Okay, so you would want your source of truth to still be a spreadsheet, right?

271 00:26:09.980 00:26:12.369 Sheshu Chandrasekar: Yes, yeah. We maintain everything in a spreadsheet.

272 00:26:12.870 00:26:14.200 Mustafa Raja: Okay…

273 00:26:20.010 00:26:26.410 Mustafa Raja: Would you be, okay with working in, google Sheets?

274 00:26:27.640 00:26:31.919 Sheshu Chandrasekar: Yeah, so, Eliza, you got this from Google Sheets, right?

275 00:26:32.040 00:26:37.760 Elizah Joy: Yeah, it’s under… it’s inside the Brainforge Financial Models.

276 00:26:37.760 00:26:40.640 Mustafa Raja: Can we… can you share the link with me?

277 00:26:40.760 00:26:42.169 Elizah Joy: If that’s the case.

278 00:26:42.700 00:26:45.609 Sheshu Chandrasekar: Yeah, Liz, I’ll stop sharing.

279 00:26:50.000 00:26:53.010 Mustafa Raja: I’m just wondering if we already have that in our… what’s it called?

280 00:26:53.400 00:27:03.470 Mustafa Raja: In our snowflake, because I see some, financial… data from Google Sheet.

281 00:27:04.120 00:27:07.399 Elizah Joy: Okay, I’ve sent the link.

282 00:27:07.620 00:27:08.050 Mustafa Raja: Okay.

283 00:27:08.050 00:27:08.415 Elizah Joy: 2…

284 00:27:09.740 00:27:10.190 Mustafa Raja: In Slack.

285 00:27:10.190 00:27:15.120 Elizah Joy: your email, to your email. I added you in as an editor.

286 00:27:15.470 00:27:16.050 Mustafa Raja: Okay.

287 00:27:16.860 00:27:18.760 Mustafa Raja: Oh, let me check that.

288 00:27:19.880 00:27:23.159 Elizah Joy: Okay, let me… here’s the link, if you can access.

289 00:27:32.210 00:27:35.020 Mustafa Raja: Don’t think that I got the Emir…

290 00:27:35.330 00:27:39.300 Elizah Joy: Yeah, I sent… I tried sharing the link as well here.

291 00:27:39.700 00:27:45.290 Elizah Joy: In Zoom, I also added you as an editor for… For this spreadsheet.

292 00:27:50.230 00:27:55.459 Mustafa Raja: It’s asking me to request access, I’ve requested it. Can you, can you approve it?

293 00:27:58.820 00:28:05.940 Elizah Joy: Okay, let me see if I… Hmm, I think…

294 00:28:10.370 00:28:13.289 Elizah Joy: Yeah, cause it said that it asked.

295 00:28:15.110 00:28:17.810 Elizah Joy: Permission from the owner? I’m not sure.

296 00:28:18.440 00:28:20.659 Mustafa Raja: Might have gone to Utama someone.

297 00:28:24.880 00:28:25.200 Elizah Joy: Yeah.

298 00:28:25.200 00:28:26.640 Mustafa Raja: It might have gone through them.

299 00:28:26.960 00:28:30.090 Sheshu Chandrasekar: Yeah, let me… let me ping him right now.

300 00:28:39.590 00:28:45.590 Mustafa Raja: Finance, Google Sheets… What would be the name of the sheet? Would you know that?

301 00:28:46.850 00:28:48.589 Elizah Joy: Software review.

302 00:28:50.400 00:28:52.280 Elizah Joy: Let me share my screen.

303 00:28:56.280 00:29:06.600 Elizah Joy: Okay, so it should be the… this spreadsheet right here. So under Brainforge Financial Models, and then Software Review.

304 00:29:08.290 00:29:09.230 Mustafa Raja: Okay.

305 00:29:12.590 00:29:19.259 Sheshu Chandrasekar: Wait, editors, I think you’re able to… Accept his request, no?

306 00:29:20.260 00:29:24.909 Elizah Joy: Yeah, what I did was I added him here.

307 00:29:25.590 00:29:26.819 Sheshu Chandrasekar: Here, let me add him again.

308 00:29:27.310 00:29:32.640 Elizah Joy: And then it said that… Request sent to owner. So that’s what’s happening.

309 00:29:33.020 00:29:35.250 Mustafa Raja: I think, I think this is going to do with them.

310 00:29:35.510 00:29:37.220 Sheshu Chandrasekar: Yeah, let me ping him right now.

311 00:30:30.560 00:30:32.030 Sheshu Chandrasekar: Okay, just pinged him.

312 00:30:33.620 00:30:41.160 Mustafa Raja: Okay… We do have a… let me… let me also share my screen.

313 00:30:43.660 00:30:45.759 Mustafa Raja: So I’m seeing that we do have…

314 00:30:46.800 00:30:50.690 Mustafa Raja: We do have this job that’s syncing finance Google Sheets.

315 00:30:50.870 00:30:54.639 Mustafa Raja: In our warehouse, I’m just going to check if the warehouse…

316 00:30:56.030 00:30:58.369 Mustafa Raja: Is the appropriate change or not?

317 00:31:49.370 00:31:52.659 Sheshu Chandrasekar: Oh, I see. Financial Google Sheets? There it is, nice.

318 00:31:53.710 00:31:56.099 Mustafa Raja: Mmm, yeah, this one has one table, though.

319 00:31:58.280 00:32:02.180 Sheshu Chandrasekar: Do we need to convert the software expenses to table?

320 00:32:05.800 00:32:09.730 Mustafa Raja: Let’s see what this has… I think this is just a table.

321 00:32:15.440 00:32:17.849 Mustafa Raja: Yeah, I don’t think so that’s pinged.

322 00:32:18.450 00:32:19.230 Mustafa Raja: You know?

323 00:32:19.410 00:32:22.609 Sheshu Chandrasekar: Also, the table in Google Sheets is called Projected Expenses.

324 00:32:24.460 00:32:30.989 Mustafa Raja: Okay… Yeah, I don’t think this, the table is in here.

325 00:32:33.360 00:32:34.590 Sheshu Chandrasekar: Interesting, okay.

326 00:32:39.540 00:32:43.800 Mustafa Raja: I can’t actually see what’s being… what’s being selected over here, too.

327 00:32:46.270 00:32:47.270 Mustafa Raja: All fruit…

328 00:33:03.260 00:33:07.270 Mustafa Raja: Yeah, I think we need a new connection for this. This is something else.

329 00:33:08.900 00:33:09.600 Sheshu Chandrasekar: Okay.

330 00:33:10.190 00:33:14.389 Mustafa Raja: Yeah, once I get access to the, I’ll take a look into that then.

331 00:33:16.120 00:33:20.300 Sheshu Chandrasekar: Okay, I’m also deleting… I just made a copy of the software review.

332 00:33:20.550 00:33:23.929 Sheshu Chandrasekar: sheet, Eliza, and I’m just gonna convert that to a table.

333 00:33:24.350 00:33:25.200 Elizah Joy: Mustafa, when you go.

334 00:33:25.200 00:33:29.900 Sheshu Chandrasekar: in there, you can… See it, and play around with the connections.

335 00:33:30.500 00:33:32.090 Mustafa Raja: Okay,

336 00:33:32.410 00:33:38.199 Mustafa Raja: Sorry, what’s the… what’s the name of the sheet? The exact name of the sheet that you would want in there?

337 00:33:38.870 00:33:43.239 Sheshu Chandrasekar: Yeah, so I just created it right now. It’s called Software Review DB.

338 00:33:43.690 00:33:44.150 Mustafa Raja: Okay, okay.

339 00:33:44.150 00:33:44.980 Sheshu Chandrasekar: Here, I’m just kidding.

340 00:33:45.380 00:33:47.060 Sheshu Chandrasekar: I’m just gonna type it in here.

341 00:33:47.380 00:33:51.230 Mustafa Raja: Okay, once I get that, I’ll go ahead, create the furniture, and I’ll let you know.

342 00:33:53.940 00:33:57.670 Sheshu Chandrasekar: Cool. This is the name of the DB that I’m converting to a table.

343 00:33:58.230 00:33:58.940 Mustafa Raja: Hmm.

344 00:33:59.880 00:34:01.250 Mustafa Raja: Okay, okay.

345 00:34:01.440 00:34:01.920 Mustafa Raja: Okay.

346 00:34:01.920 00:34:03.020 Sheshu Chandrasekar: Okay, thanks for stopping.

347 00:34:03.520 00:34:04.980 Mustafa Raja: No worries. Thank you.

348 00:34:04.980 00:34:05.920 Elizah Joy: Thank you.

349 00:34:05.920 00:34:08.569 Mustafa Raja: So, once we have the data, right?

350 00:34:08.750 00:34:10.880 Sheshu Chandrasekar: Absolutely. Yep, talk soon.

351 00:34:11.330 00:34:11.989 Sheshu Chandrasekar: Bye.

352 00:34:14.040 00:34:16.880 Sheshu Chandrasekar: Eliza, we’ll see what she says, and then we’ll follow.

353 00:34:16.889 00:34:17.579 Elizah Joy: Yeah.

354 00:34:17.580 00:34:19.480 Sheshu Chandrasekar: Like, in a couple hours.

355 00:34:19.489 00:34:19.949 Elizah Joy: Yep.

356 00:34:19.949 00:34:22.509 Sheshu Chandrasekar: But I guess now that I have you here… sorry, go ahead.

357 00:34:22.800 00:34:24.360 Elizah Joy: I think notions…

358 00:34:24.909 00:34:26.229 Sheshu Chandrasekar: Yeah, notions are pending.

359 00:34:26.230 00:34:27.790 Elizah Joy: Fayward. Yeah.

360 00:34:27.790 00:34:28.429 Sheshu Chandrasekar: Yeah.

361 00:34:28.760 00:34:32.319 Sheshu Chandrasekar: If you can, if you can just help me with the…

362 00:34:32.320 00:34:32.880 Elizah Joy: Yeah.

363 00:34:32.880 00:34:47.899 Sheshu Chandrasekar: the front-end stuff, like the design, and, like, there’s some documents I just need help formatting, and if you could help me add databases, that’d be great. But I think the biggest thing that you could knock out in the next hour would be just, like, constructing those pages, right? Like, CSO,

364 00:34:48.389 00:34:50.079 Sheshu Chandrasekar: AI, and stuff like that.

365 00:34:50.670 00:34:53.479 Elizah Joy: For, CSOs…

366 00:34:53.810 00:35:02.000 Elizah Joy: Just to confirm, we’re just gonna use the similar structure that we have in the current no.

367 00:35:02.000 00:35:06.629 Sheshu Chandrasekar: That’s a good question. I’m kind of thinking about revamping it. I’ll… let me share my screen.

368 00:35:06.630 00:35:08.060 Elizah Joy: Real quick.

369 00:35:08.550 00:35:14.040 Sheshu Chandrasekar: And I want your thoughts, too, because maybe I’m… maybe this is not the best way to go about it, but.

370 00:35:19.220 00:35:26.799 Sheshu Chandrasekar: So, I’m thinking for customer success, EP, CSOs, like, it’d be like this, like, a full definition of the role.

371 00:35:26.920 00:35:27.719 Sheshu Chandrasekar: because I…

372 00:35:27.720 00:35:28.199 Elizah Joy: I want to.

373 00:35:28.200 00:35:32.119 Sheshu Chandrasekar: leverage this forging, the future document.

374 00:35:32.280 00:35:34.010 Sheshu Chandrasekar: Because it has everything here.

375 00:35:34.460 00:35:39.739 Sheshu Chandrasekar: But it’s, like, it’s, like, hidden, right? No one’s, like, gonna go into this document and read it, and…

376 00:35:40.650 00:35:54.490 Sheshu Chandrasekar: I feel like there’s a lot of things here that are very useful that we can just import into Notion here. So, like, for example, full definition role, this could be, like, a call-out box, right? And then I’ll just… you can just go in there and copy and paste.

377 00:35:54.630 00:36:02.930 Sheshu Chandrasekar: like, the cadences, that’s also in the Forging the Future document, KPIs, call-out boxes, right? So we have, like, all the necessary information.

378 00:36:04.400 00:36:11.510 Sheshu Chandrasekar: And then additional files would just be a replication of the documents DB, and we would just filter it by EP, or CSO.

379 00:36:11.510 00:36:15.670 Elizah Joy: Yeah. Just on this, I don’t think I have…

380 00:36:15.860 00:36:19.549 Elizah Joy: a copy of this one yet? Can you share this to me?

381 00:36:20.070 00:36:22.860 Sheshu Chandrasekar: Yeah, I’m gonna share it to you. I just created it, like, an hour or two ago.

382 00:36:22.860 00:36:23.600 Elizah Joy: Oh, okay.

383 00:36:24.450 00:36:26.449 Elizah Joy: Okay, yep, I can set this up.

384 00:36:27.620 00:36:31.260 Sheshu Chandrasekar: Yeah, let me send you a link to the 14th Future as well.

385 00:36:31.450 00:36:34.059 Sheshu Chandrasekar: So you can just copy and paste. I also…

386 00:36:34.170 00:36:37.560 Sheshu Chandrasekar: created in a cursor, so I could send you this document as well.

387 00:36:42.660 00:36:45.100 Sheshu Chandrasekar: So, like, it already does everything for us, like…

388 00:36:45.250 00:36:47.679 Sheshu Chandrasekar: It tells you what information we should copy and paste.

389 00:36:48.170 00:36:49.290 Elizah Joy: Yeah,

390 00:36:58.320 00:37:01.170 Sheshu Chandrasekar: Here, I’m gonna paste this here… Oh.

391 00:37:25.880 00:37:29.119 Sheshu Chandrasekar: And then we’re gonna go to Documents…

392 00:37:48.250 00:37:51.610 Sheshu Chandrasekar: Okay. You can use both of these as guides to populate the.

393 00:37:52.040 00:37:57.159 Sheshu Chandrasekar: And then this is the wireframe right here, so I think that should be helpful.

394 00:37:57.720 00:38:04.220 Elizah Joy: Yep, yep. I’ll set this up, and then… just…

395 00:38:05.030 00:38:09.150 Elizah Joy: We’re still on for our call for the Notion working session, right?

396 00:38:09.730 00:38:13.520 Sheshu Chandrasekar: Yeah, I’ll join back at 2.45.

397 00:38:13.520 00:38:14.040 Elizah Joy: Okay.

398 00:38:14.040 00:38:15.650 Sheshu Chandrasekar: So we can get knocked that out of the park.

399 00:38:16.600 00:38:18.819 Elizah Joy: Alright, yeah, I’ll set this up.

400 00:38:19.190 00:38:20.760 Elizah Joy: After our call.

401 00:38:21.570 00:38:22.890 Sheshu Chandrasekar: Okay, sounds good.

402 00:38:23.160 00:38:25.590 Sheshu Chandrasekar: I’m gonna go grab a quick bite to eat, and I’ll…

403 00:38:26.030 00:38:26.660 Sheshu Chandrasekar: hop on.

404 00:38:27.150 00:38:31.510 Elizah Joy: Alright, thank you so much. I’ll let you know if I do have questions in Slack.

405 00:38:31.510 00:38:32.920 Sheshu Chandrasekar: Absolutely. Yeah.

406 00:38:32.920 00:38:34.149 Elizah Joy: Alright, thank you.

407 00:38:34.150 00:38:34.770 Sheshu Chandrasekar: Thanks, Eliza.

408 00:38:35.470 00:38:37.180 Elizah Joy: Thank you, bye!