Meeting Title: Mattermore Meeting Date: 2025-06-11 Meeting participants: Awaish Kumar, Luke Daque, Amber Lin, Annie Yu


WEBVTT

1 00:04:53.230 00:04:55.030 Luke Daque: Hi, Annie! How’s it going.

2 00:04:57.140 00:04:58.339 Annie Yu: Oh, Hi Luke!

3 00:05:04.170 00:05:05.770 Luke Daque: How’s everything on your end?

4 00:05:07.340 00:05:09.027 Annie Yu: Not too bad.

5 00:05:11.970 00:05:22.989 Annie Yu: yeah, I mostly spend. I spend most of my time on Eden and feel like it’s always kind of busy, but not too bad. There! How are you?

6 00:05:24.030 00:05:25.838 Luke Daque: Yeah, not too bad as well.

7 00:05:26.820 00:05:35.290 Luke Daque: like I don’t have like, for I’m working on pull parts and matter more like as in terms of like clients. But like

8 00:05:35.510 00:05:39.920 Luke Daque: both of them are like, I don’t have much to do at the moment.

9 00:05:40.230 00:05:41.970 Luke Daque: Yeah, okay, yeah.

10 00:05:42.470 00:05:48.000 Luke Daque: So been working on also, like the data platform stuff. But yeah, other than that.

11 00:05:48.900 00:05:50.280 Annie Yu: Got it. Got it?

12 00:05:50.440 00:05:56.179 Annie Yu: Wait! Was there like a newly added holiday in the Philippines.

13 00:05:57.630 00:06:04.520 Luke Daque: I don’t think there’s an newly added one. But there, there is a holiday tomorrow, because, like it’s

14 00:06:04.790 00:06:07.070 Luke Daque: Independence Day in the Philippines.

15 00:06:07.070 00:06:08.340 Annie Yu: Okay. Nice.

16 00:06:08.340 00:06:08.990 Luke Daque: Hannah.

17 00:06:09.320 00:06:13.589 Annie Yu: Yeah, cause I I think I actually think I saw, Casey

18 00:06:15.300 00:06:19.569 Annie Yu: also added, like an a holiday few weeks back.

19 00:06:20.000 00:06:20.770 Annie Yu: And I thought.

20 00:06:20.770 00:06:21.300 Luke Daque: Cool.

21 00:06:21.470 00:06:27.179 Annie Yu: And I, I know, like wish they also had an like kind of like a newly added holiday.

22 00:06:27.320 00:06:30.490 Annie Yu: So I just thought, it’s a thing.

23 00:06:31.530 00:06:33.708 Luke Daque: Yeah, I don’t know. I’m not sure as well.

24 00:06:35.380 00:06:46.609 Luke Daque: I don’t usually take the holidays, though, like doesn’t really matter, because, like I’m working in night shift. So like doesn’t really matter that much unless, like we have some

25 00:06:47.786 00:06:51.520 Luke Daque: family need thing going on. But.

26 00:06:51.520 00:06:53.970 Annie Yu: Yeah. Oh, Hi, a wish.

27 00:06:53.970 00:06:54.789 Luke Daque: I wish.

28 00:06:55.540 00:06:57.690 Awaish Kumar: Hello! Sorry I was late.

29 00:06:58.760 00:07:00.640 Awaish Kumar: I don’t know if somebody’s joining.

30 00:07:02.800 00:07:03.680 Luke Daque: I don’t know.

31 00:07:04.260 00:07:08.039 Luke Daque: She set up the meeting itself.

32 00:07:10.130 00:07:15.099 Luke Daque: Yeah, she accepted the invite as well, so she should join. I guess.

33 00:07:19.060 00:07:20.540 Awaish Kumar: Oh! To zoom.

34 00:07:20.540 00:07:22.829 Amber Lin: Hi! Hi! Sorry I was.

35 00:07:23.650 00:07:38.860 Amber Lin: I’m sorry I was doing something else. I totally forgot. I saw yesterday. We think we made really great progress. I saw Luke. You posted the spreadsheet, and then we were able to get into power. Bi. But I think we’re still stuck on something.

36 00:07:39.472 00:07:44.570 Amber Lin: Were we able to get the permissions we need to transfer to Dbt.

37 00:07:45.340 00:07:45.705 Luke Daque: Nope.

38 00:07:47.342 00:07:49.330 Amber Lin: Okay, let me.

39 00:07:50.790 00:07:58.449 Awaish Kumar: Did you like? Did we send an like escalation to the client.

40 00:08:00.010 00:08:10.580 Amber Lin: Yeah, they sent. I sent one yesterday at night. They still haven’t responded, so can’t do much.

41 00:08:12.590 00:08:19.070 Amber Lin: I mean, do we have to wait for the permissions. Can we start, I guess, making it in our own.

42 00:08:19.210 00:08:24.479 Amber Lin: maybe just doing it in our own Dbt, and then figuring out later? Or how does this work?

43 00:08:24.840 00:08:27.550 Amber Lin: How do we work while we’re still blocked.

44 00:08:27.550 00:08:28.530 Awaish Kumar: We can.

45 00:08:29.400 00:08:33.730 Awaish Kumar: So we can move the views to Dvt project.

46 00:08:33.919 00:08:36.740 Awaish Kumar: But we can’t test them if they are working

47 00:08:37.409 00:08:44.850 Awaish Kumar: until we have the authentication. Okay, correct authorizations.

48 00:08:49.370 00:08:53.010 Awaish Kumar: So I think we we should start with Luke’s investigation right.

49 00:08:53.210 00:08:53.595 Amber Lin: Okay.

50 00:08:55.180 00:09:03.429 Luke Daque: Yeah, I already added comments to the Google Sheet. You can check it out. There’s a couple of most of the fields are there, but there’s, I think, the last

51 00:09:03.970 00:09:07.037 Luke Daque: be that is missing the

52 00:09:08.940 00:09:19.859 Luke Daque: the 3rd tertiary, like further segments, so I can always add that, and also in the time grains for the Pre or post office mandate. I’m not sure where to get that.

53 00:09:20.310 00:09:24.709 Luke Daque: so we’ll have to get context on what is pre or post of this mandate.

54 00:09:28.140 00:09:35.319 Luke Daque: Yeah, for the primary segments, the location and worker type that can always be inferred, I believe.

55 00:09:35.590 00:09:39.839 Luke Daque: So. Yeah, we can. I can add that to the existing models.

56 00:09:40.090 00:09:40.730 Amber Lin: Oh, okay.

57 00:09:40.730 00:09:45.179 Luke Daque: And for the other thing, which is like focus time.

58 00:09:48.140 00:09:56.370 Luke Daque: Yeah, we’ll have to add the missing part as well. But gaps between communication events.

59 00:09:58.973 00:10:05.150 Annie Yu: I do have one question, Luke. I’m looking at the atomic metric. I saw that you commented

60 00:10:05.880 00:10:13.989 Annie Yu: things for like call duration, communication event, count. I’m seeing that you refer to the

61 00:10:14.170 00:10:17.070 Annie Yu: columns that says 30 days.

62 00:10:17.790 00:10:32.429 Annie Yu: and I think we probably need to get the all timeframe instead of 30 day. And then to that same point, I see that here you refer to the employee engagement

63 00:10:32.850 00:10:33.720 Annie Yu: model.

64 00:10:33.720 00:10:34.140 Luke Daque: So.

65 00:10:34.690 00:10:39.879 Luke Daque: So both those models were like 30 days. We can always change that to all time, so that.

66 00:10:39.880 00:10:40.750 Annie Yu: Yeah, yeah, I.

67 00:10:40.750 00:10:50.140 Annie Yu: And I, I think I actually think the communication events model will work better, just because

68 00:10:50.630 00:11:14.490 Annie Yu: in this model all, no matter, the event type all the start, time and end time are in the same column as well as duration, and with another column that we can just filter on event type that says chat call things of that sort. But then, in employee engagement they are, if it’s call, it’s in one column. If it’s

69 00:11:14.700 00:11:28.700 Annie Yu: message. It’s it’s in one column. I think I I’m I’m thinking, with that the problem would be in power. Bi. That would be that would mean like they have to be separate visuals instead of one use reusable

70 00:11:28.920 00:11:30.499 Annie Yu: that we can filter.

71 00:11:30.670 00:11:31.970 Annie Yu: Does that make sense.

72 00:11:36.250 00:11:40.150 Luke Daque: Can you say that again, like which part the the.

73 00:11:40.150 00:11:40.780 Annie Yu: Oh! And then.

74 00:11:40.780 00:11:41.560 Luke Daque: Sales.

75 00:11:41.560 00:11:44.970 Annie Yu: Yeah, I see that in employee engagement

76 00:11:45.290 00:11:50.200 Annie Yu: everything like meeting meeting is one column. Email is one column.

77 00:11:50.650 00:11:57.779 Annie Yu: Chat is one column. But then, in communication events which I think will work better just because in communication events.

78 00:11:57.970 00:11:58.610 Luke Daque: Yeah.

79 00:11:58.610 00:12:06.879 Annie Yu: All of the duration are in one column, but then I can always refer to event type to to identify, if they are call or meeting.

80 00:12:07.500 00:12:10.640 Luke Daque: Okay, yeah, we can, we can change that. We can make it one.

81 00:12:10.640 00:12:11.120 Awaish Kumar: Oh!

82 00:12:11.120 00:12:20.030 Luke Daque: And just like, yeah, it’s make it one column instead of like separated columns for each event. Type

83 00:12:20.360 00:12:22.680 Luke Daque: is that will that be better?

84 00:12:22.680 00:12:29.419 Annie Yu: Yeah, I I would imagine if we just want to stick to one chart and reuse it.

85 00:12:30.320 00:12:32.319 Annie Yu: then that would be better.

86 00:12:32.880 00:12:33.610 Luke Daque: Okay.

87 00:12:34.910 00:12:35.440 Luke Daque: Sounds good.

88 00:12:35.440 00:12:36.319 Awaish Kumar: Can we like.

89 00:12:36.320 00:12:37.220 Luke Daque: I can update that.

90 00:12:37.220 00:12:45.000 Awaish Kumar: Okay, can we like? Look I saw on the sheet like you added, it has a comments it’s hard to like.

91 00:12:45.330 00:12:51.330 Awaish Kumar: Like. Read it. I like. What I meant was to have one more column on the right.

92 00:12:51.840 00:12:54.039 Awaish Kumar: where you give your feedback.

93 00:12:54.430 00:12:59.050 Awaish Kumar: So it’s easier to like, read and understand

94 00:12:59.360 00:13:05.870 Awaish Kumar: right now. It’s like all hidden for me until I go and scroll like, and the hover over over the

95 00:13:06.190 00:13:10.589 Awaish Kumar: actually the column to see what is present and what is missing?

96 00:13:12.080 00:13:12.770 Awaish Kumar: Yep.

97 00:13:12.770 00:13:15.769 Luke Daque: We can do that, I can always update it, change it.

98 00:13:15.910 00:13:26.680 Awaish Kumar: So yeah, just add it in a column from the right. And like, I want to get to like. Now, you have the idea of what is available, what is

99 00:13:26.950 00:13:34.889 Awaish Kumar: already modeled and what is not possible. So is there anything you found that it’s it’s not possible.

100 00:13:35.370 00:13:40.279 Luke Daque: Those in red are like missing. But I think you can add that the one that’s not

101 00:13:41.060 00:13:48.190 Luke Daque: like I’m not sure if it’s possible or not yet is the Pre or post office mandate. Because I need more context what that means.

102 00:13:49.173 00:13:53.419 Luke Daque: Also the all those in column. I basically.

103 00:13:56.480 00:14:01.330 Awaish Kumar: Okay, Amber can like, just share the screen, or can we not? Please don’t.

104 00:14:01.660 00:14:05.299 Amber Lin: Can someone share screen, and then I can comment on it.

105 00:14:13.290 00:14:14.420 Amber Lin: Hello.

106 00:14:15.080 00:14:17.899 Awaish Kumar: Luke, are you able to share the screen.

107 00:14:18.750 00:14:19.570 Luke Daque: Oh, sure!

108 00:14:29.630 00:14:31.020 Luke Daque: Can you see my screen.

109 00:14:32.145 00:14:32.440 Amber Lin: Yeah.

110 00:14:34.240 00:14:40.329 Awaish Kumar: So you mean that focus time is not the this time is not available or.

111 00:14:41.310 00:14:42.130 Luke Daque: So.

112 00:14:43.590 00:14:45.620 Awaish Kumar: The focus time field is available.

113 00:14:45.620 00:14:49.800 Luke Daque: In the current models. It’s not. But yeah, we can always add it.

114 00:14:49.800 00:14:50.999 Awaish Kumar: It’s in raw data.

115 00:14:51.660 00:14:52.300 Luke Daque: Yes.

116 00:14:53.130 00:14:57.569 Awaish Kumar: Okay, okay, it’s okay, like it’s not. It’s possible to do that right.

117 00:14:57.810 00:15:01.140 Awaish Kumar: And then for the P. And post office mandate.

118 00:15:01.558 00:15:06.499 Luke Daque: Yeah. Like, we figure out, we need to have a definition like what that means. Right?

119 00:15:06.820 00:15:07.400 Luke Daque: Yep.

120 00:15:08.140 00:15:15.390 Awaish Kumar: Okay, so that’s like, kind of 2 things we, we still say, like it’s possible to do. But they are missing.

121 00:15:15.510 00:15:20.520 Awaish Kumar: And the tertiary further segments. That’s like

122 00:15:20.730 00:15:25.870 Awaish Kumar: that’s not in the scope. Right? Amber, for this 1st pass, at least.

123 00:15:28.110 00:15:28.550 Amber Lin: Sorry.

124 00:15:28.550 00:15:29.940 Awaish Kumar: The the column I.

125 00:15:30.980 00:15:35.599 Amber Lin: Yeah, we’re we’re all we’re not doing. Column I. So we’re good.

126 00:15:36.170 00:15:37.480 Awaish Kumar: That’s okay. So.

127 00:15:37.480 00:15:38.700 Luke Daque: And we should be but.

128 00:15:38.700 00:15:45.369 Awaish Kumar: What I understand from this Luke, is that everything else is moded out except these 2 things.

129 00:15:45.810 00:15:47.040 Luke Daque: Yep right.

130 00:15:47.470 00:15:50.460 Awaish Kumar: And like once, you know, like

131 00:15:51.137 00:16:00.350 Awaish Kumar: like, you already, have a focus time. So if you model this out, for if you bring that in into our models. How long is going to take you

132 00:16:00.700 00:16:02.579 Awaish Kumar: to bring in that focus time?

133 00:16:04.140 00:16:08.370 Luke Daque: I can do that. If I start working on the Dbt models today, that should be.

134 00:16:09.040 00:16:11.960 Luke Daque: wait, guys, I don’t think we need to focus time.

135 00:16:12.510 00:16:16.570 Amber Lin: For this round of deliverables. I think we put.

136 00:16:16.570 00:16:17.210 Awaish Kumar: We.

137 00:16:17.210 00:16:19.880 Amber Lin: Didn’t we put this focus time in there

138 00:16:20.070 00:16:22.970 Amber Lin: like, I don’t think the client put the focus time in here.

139 00:16:25.250 00:16:27.770 Luke Daque: But, like Luke says it’s.

140 00:16:28.750 00:16:33.820 Awaish Kumar: Like, if it takes like a very small time like you can just need that.

141 00:16:35.221 00:16:41.370 Amber Lin: I think we should prioritize the I I think the primary segments what we don’t have yet right.

142 00:16:41.590 00:16:42.480 Amber Lin: And then

143 00:16:42.820 00:16:50.680 Amber Lin: we do the focus time last, but if we have time, then we’re more than welcome to do it. But it was not required in the class.

144 00:16:50.680 00:17:04.559 Awaish Kumar: But the Luke says, like the 5, th what I see from here, the majority of things are already moded out, so we we are only missing 2 things, the focus time and the Pre and post office mandate thing.

145 00:17:05.099 00:17:12.389 Awaish Kumar: Luke does not have a clarity like he needs a feedback from the client what is pre and post office mandate.

146 00:17:12.569 00:17:15.099 Awaish Kumar: and then he can model focus time.

147 00:17:15.359 00:17:17.839 Awaish Kumar: Only these 2 things are missing.

148 00:17:19.209 00:17:19.799 Awaish Kumar: Okay.

149 00:17:19.800 00:17:38.879 Amber Lin: Let me go. Let me go check with the Pre. And post office mandate. Let me go, get some feedback from them also, nudge them, nudging them on power beyond. Dvt again. What is the yellow highlights for in the primary segments of column G. So we have green and yellow. Does it mean the yellow? We don’t have completely yet?

150 00:17:39.440 00:17:42.339 Luke Daque: They? It’s not in the models yet, but we can add them.

151 00:17:43.650 00:17:47.640 Luke Daque: Yeah, because, like geography, that’s that link.

152 00:17:47.840 00:17:48.200 Amber Lin: I see.

153 00:17:48.200 00:17:51.839 Luke Daque: Can always add that like, make it Europe, whatever.

154 00:17:51.840 00:17:52.210 Awaish Kumar: So.

155 00:17:52.210 00:17:55.030 Luke Daque: We want the geography to be, and stuff like that. So.

156 00:17:56.330 00:18:08.059 Awaish Kumar: So it’s like, it’s not difficult. Right? Is it? Is it like to add, add these into like duty? Require a lot of work, or is it like it’s in raw table. You just need to bring it in.

157 00:18:08.440 00:18:16.129 Luke Daque: Yep, we just need to. Well, it’s not in the raw tables, but it can be inferred right like we we know, like what geographies based on

158 00:18:17.455 00:18:20.070 Luke Daque: like location and stuff like that.

159 00:18:21.070 00:18:23.080 Luke Daque: And like worker type, we can also.

160 00:18:23.080 00:18:24.230 Awaish Kumar: You need something.

161 00:18:24.836 00:18:27.250 Luke Daque: User, base, yeah.

162 00:18:28.620 00:18:30.510 Awaish Kumar: Like location like like.

163 00:18:31.290 00:18:33.640 Awaish Kumar: If you have some field you can.

164 00:18:33.640 00:18:37.820 Luke Daque: If you have city, we can always figure out geography or something right.

165 00:18:38.660 00:18:40.009 Awaish Kumar: Sorry. What? What do we have.

166 00:18:41.580 00:18:43.409 Luke Daque: Like city, for example.

167 00:18:43.760 00:18:50.919 Awaish Kumar: Oh, okay, okay. But then we need a full. If we just have a city then.

168 00:18:51.080 00:18:53.670 Awaish Kumar: and they need like, what do they need?

169 00:18:53.890 00:18:59.399 Awaish Kumar: What do they need like in term what they mean by location, just the city information, or

170 00:18:59.770 00:19:02.200 Awaish Kumar: also the province country? Everything.

171 00:19:02.510 00:19:07.259 Luke Daque: We can. Always we can add anything so that we they can filter

172 00:19:07.500 00:19:11.989 Luke Daque: by location, whether it’s city state, whatever.

173 00:19:13.710 00:19:20.219 Awaish Kumar: Okay? And what is possible. Do you know, like how much granular we can go like

174 00:19:20.330 00:19:22.819 Awaish Kumar: country province, region, city.

175 00:19:26.910 00:19:28.110 Luke Daque: We’ll have to check.

176 00:19:28.860 00:19:29.240 Awaish Kumar: Okay.

177 00:19:29.240 00:19:31.509 Luke Daque: But whatever we can add, we’ll add

178 00:19:31.850 00:19:34.650 Luke Daque: whatever is not there. We won’t add, that’s basically.

179 00:19:34.650 00:19:35.440 Awaish Kumar: So.

180 00:19:35.630 00:19:36.170 Luke Daque: We can do.

181 00:19:36.170 00:19:43.030 Awaish Kumar: Like from here. Amber. I see 2 action items for Luke, one to bring

182 00:19:44.150 00:19:56.769 Awaish Kumar: All the views like create a Dbt project. Or maybe I think they already have a DVD project. So just bring those views in the clients DVD project, and then, plus add all these

183 00:19:57.420 00:20:02.859 Awaish Kumar: missing fields like these are 2 tickets, for now

184 00:20:05.870 00:20:07.310 Awaish Kumar: he he can work on.

185 00:20:07.890 00:20:16.739 Amber Lin: Okay, so transfer. Dbt, even if we do, how are we able to do that without the clients? Dbt, instance? Or.

186 00:20:16.740 00:20:21.490 Amber Lin: yeah, we have a client degree project. He’s just going to create some files.

187 00:20:21.899 00:20:28.550 Amber Lin: Put the skill code in there, but he’s he’s not going to test it right now, because we don’t. He don’t have access.

188 00:20:28.550 00:20:29.090 Amber Lin: I see.

189 00:20:29.090 00:20:35.689 Awaish Kumar: Whenever we get the access he he can run the models and then create the actual tables in the bigquery.

190 00:20:36.050 00:20:44.960 Amber Lin: I see awesome, and then the other part is through, create the remaining modeling right.

191 00:20:44.960 00:20:56.679 Awaish Kumar: Other. Yeah. Other part is to bring those fields. I don’t know how you want to handle it. If you want to create a separate ticket for each of these things, or just one ticket we we need to bring in, like the

192 00:20:56.940 00:21:04.779 Awaish Kumar: reinforced office mandate. And then these location and the the things in yellow, and the 3rd one was focus time.

193 00:21:05.000 00:21:09.920 Amber Lin: Okay, great. I’ll make a ticket for each, and I’ll assign priorities to them.

194 00:21:11.350 00:21:25.430 Amber Lin: let’s try to do the location. I mean, I guess the in order of sequence. I think 1st of all is the Dbt models. Second is to look at the location one, and then let me go. Confirm for the in office, mandate and focus.

195 00:21:28.750 00:21:32.580 Awaish Kumar: Okay. And the last thing is focus time. If we have the time to do that.

196 00:21:32.970 00:21:34.560 Amber Lin: Yeah. Sounds good.

197 00:21:35.400 00:21:37.410 Amber Lin: Awesome. Thank you. All.

198 00:21:39.020 00:21:40.140 Awaish Kumar: Okay. Thank you.

199 00:21:40.420 00:21:41.359 Amber Lin: Alrighty! Bye-bye.