Meeting Title: MatterMore | internal Standup Date: 2025-06-20 Meeting participants: Amber Lin, Annie Yu, Awaish Kumar
WEBVTT
1 00:00:18.010 ⇒ 00:00:22.270 Amber Lin: Hi! Annie waiting for a wish, and Luke.
2 00:00:22.470 ⇒ 00:00:23.720 Annie Yu: Yeah, sounds good.
3 00:00:25.035 ⇒ 00:00:34.600 Amber Lin: I saw that you sent the like the bigquery authentication.
4 00:00:34.890 ⇒ 00:00:42.810 Amber Lin: Have you tried using our our madam? Or account? Maybe that one has the authentication. I don’t know how that.
5 00:00:43.146 ⇒ 00:00:43.820 Annie Yu: No actually.
6 00:00:43.820 ⇒ 00:00:44.800 Amber Lin: That’s exactly.
7 00:00:44.800 ⇒ 00:00:50.073 Annie Yu: The the share account doesn’t have access to bigquery because that was removed. So.
8 00:00:50.450 ⇒ 00:00:51.170 Amber Lin: Oh! Dang!
9 00:00:51.170 ⇒ 00:00:54.900 Annie Yu: I think when we set it up he also used his personal.
10 00:00:57.590 ⇒ 00:01:04.619 Amber Lin: Let me see, maybe. Do you think? Adding, that will solve the problem? Hi, Aish.
11 00:01:05.220 ⇒ 00:01:06.479 Awaish Kumar: Hi Kyle.
12 00:01:10.240 ⇒ 00:01:12.559 Annie Yu: I would think so.
13 00:01:13.710 ⇒ 00:01:16.979 Annie Yu: Because that’s how how we used for tableau.
14 00:01:17.110 ⇒ 00:01:19.630 Amber Lin: We also use Json surface.
15 00:01:20.291 ⇒ 00:01:23.520 Annie Yu: Sur- surface account, Json, and that works.
16 00:01:24.470 ⇒ 00:01:34.310 Amber Lin: Oh, so so if we add our matter more account and have Trevor just authenticate it on his end.
17 00:01:35.080 ⇒ 00:01:39.810 Amber Lin: So he doesn’t have to give us the Json key. I don’t think he wants to give us that.
18 00:01:41.950 ⇒ 00:01:47.460 Annie Yu: Yeah, then he will have to come into the setting and authenticate that.
19 00:01:48.140 ⇒ 00:01:50.200 Amber Lin: What is this authentication for.
20 00:01:51.100 ⇒ 00:01:52.870 Annie Yu: The bigquery connection.
21 00:01:54.229 ⇒ 00:01:57.379 Amber Lin: Connection to haven’t established the connection yet.
22 00:01:58.850 ⇒ 00:02:00.060 Annie Yu: What’s that wish?
23 00:02:01.680 ⇒ 00:02:06.879 Awaish Kumar: Like I was asking, like, we haven’t established the connection to victory yet in.
24 00:02:07.333 ⇒ 00:02:23.649 Annie Yu: There is. But right now we are using our personal Brainforge account, which I think expires every 24 to 48 h. So when the models in the big power bi refresh, it just fails
25 00:02:24.020 ⇒ 00:02:29.650 Annie Yu: unless we like. Keep authenticate every 24 h, which I don’t think is possible.
26 00:02:29.820 ⇒ 00:02:35.329 Annie Yu: So I’m asking if we use the bigquery. Json.
27 00:02:35.330 ⇒ 00:02:41.800 Awaish Kumar: But I don’t fix it like. But do they want the real time data? Because.
28 00:02:42.910 ⇒ 00:02:55.849 Awaish Kumar: because, like what I understand from metamos requirements is that they want you to create a power bi dashboard, which they then just get the PBX file and
29 00:02:57.290 ⇒ 00:03:00.379 Awaish Kumar: use it somewhere else on their clients.
30 00:03:02.760 ⇒ 00:03:04.670 Awaish Kumar: What you say, power Bi.
31 00:03:04.670 ⇒ 00:03:06.750 Amber Lin: Yeah, so.
32 00:03:06.750 ⇒ 00:03:10.720 Awaish Kumar: We are not looking for live data, really, in our dashboards.
33 00:03:11.770 ⇒ 00:03:14.640 Annie Yu: So it will be just one time refresh. That’s okay.
34 00:03:15.560 ⇒ 00:03:23.249 Awaish Kumar: Yeah, like, when like, if if you go in and re like log in and rework on that, refresh to the data
35 00:03:23.660 ⇒ 00:03:25.890 Awaish Kumar: once a day like we can like
36 00:03:26.310 ⇒ 00:03:30.279 Awaish Kumar: with with it, like we can inform the client
37 00:03:30.580 ⇒ 00:03:35.390 Awaish Kumar: that that’s how the currently it works. If they want daily refreshes.
38 00:03:35.490 ⇒ 00:03:39.719 Awaish Kumar: then they might give have to give us the service, count, or something
39 00:03:41.010 ⇒ 00:03:43.789 Awaish Kumar: some of the like, some other way to authenticate like
40 00:03:44.110 ⇒ 00:03:46.289 Awaish Kumar: it. I think it serves count for
41 00:03:46.730 ⇒ 00:03:55.340 Awaish Kumar: number one like we should make it clear to the client like we can only with with the current authentication system.
42 00:03:55.560 ⇒ 00:04:04.069 Awaish Kumar: we can just do daily refreshes God, and if they work, want the data to be
43 00:04:04.620 ⇒ 00:04:07.900 Awaish Kumar: live like they, they need to give us the service account key.
44 00:04:08.610 ⇒ 00:04:23.709 Amber Lin: I see. So my ask to to Trevor would be, you have 2 options, one we we keep using our personal account, and we can’t do daily refreshes, and 2, you helped us connect the matter more.
45 00:04:23.710 ⇒ 00:04:24.260 Awaish Kumar: Okay.
46 00:04:25.270 ⇒ 00:04:25.700 Amber Lin: Huh!
47 00:04:25.700 ⇒ 00:04:32.589 Awaish Kumar: Sorry, just a clarification. But option one is that we can keep using our our own personal accounts.
48 00:04:33.120 ⇒ 00:04:38.599 Awaish Kumar: To authenticate power bi with victory, and and keep building the dashboards.
49 00:04:39.060 ⇒ 00:04:45.409 Awaish Kumar: That way. We can only do daily refresh like once a day, and he can log in and do a refresh.
50 00:04:45.820 ⇒ 00:04:50.039 Awaish Kumar: But it cannot be automated right? So.
51 00:04:51.170 ⇒ 00:04:53.700 Awaish Kumar: Like if they want like more than
52 00:04:54.214 ⇒ 00:05:01.770 Awaish Kumar: like like refreshes every few hours, or they want to automated like when Annie is not on
53 00:05:03.640 ⇒ 00:05:04.850 Awaish Kumar: and they wanted.
54 00:05:05.340 ⇒ 00:05:08.899 Awaish Kumar: In the night, or something like we can’t do that without service counts.
55 00:05:10.640 ⇒ 00:05:12.120 Amber Lin: So we would.
56 00:05:12.710 ⇒ 00:05:14.909 Amber Lin: What does service account mean?
57 00:05:15.740 ⇒ 00:05:22.159 Awaish Kumar: Service account is basically and way a way to authenticate
58 00:05:22.530 ⇒ 00:05:26.140 Awaish Kumar: 2 systems like with power bi, we can give access to it.
59 00:05:26.430 ⇒ 00:05:28.460 Amber Lin: So would that be.
60 00:05:28.580 ⇒ 00:05:32.230 Awaish Kumar: Would that be our brainforce user? Mattamore email?
61 00:05:33.860 ⇒ 00:05:37.730 Awaish Kumar: No like service counts are different than personal accounts.
62 00:05:38.100 ⇒ 00:05:44.020 Awaish Kumar: We we keep, we create those accounts just to integrate 2 systems.
63 00:05:44.810 ⇒ 00:05:46.880 Amber Lin: Oh.
64 00:05:47.442 ⇒ 00:05:54.639 Amber Lin: so what should I ask of him? I understood. Option one. I don’t really understand option. 2. Of how I how I can.
65 00:05:54.640 ⇒ 00:05:59.740 Awaish Kumar: So is that if we want to automate that connection, like, if we want power bi
66 00:06:00.050 ⇒ 00:06:07.250 Awaish Kumar: to connect to victory without anyone’s personal account, right and and.
67 00:06:07.250 ⇒ 00:06:07.620 Amber Lin: This is.
68 00:06:07.620 ⇒ 00:06:15.759 Awaish Kumar: Not like like more than one refreshes per day. We need service account key to do that.
69 00:06:18.550 ⇒ 00:06:21.140 Amber Lin: Can he do it on his end?
70 00:06:22.490 ⇒ 00:06:25.420 Awaish Kumar: Yeah, like, we can, they can create service accounts.
71 00:06:25.930 ⇒ 00:06:36.200 Awaish Kumar: Right? With the service account key, we can log in. They can even create the connection with power bi themselves like they can go in power, Bi, provide a service account key, and establish.
72 00:06:36.200 ⇒ 00:06:36.810 Amber Lin: Okay.
73 00:06:36.810 ⇒ 00:06:41.050 Awaish Kumar: Which any can use. But thing is, that.
74 00:06:41.550 ⇒ 00:06:48.590 Amber Lin: Can it? Can that service account be our Brainforge user matt@mattermore.ai email?
75 00:06:50.570 ⇒ 00:06:51.240 Amber Lin: Or does he.
76 00:06:51.240 ⇒ 00:06:51.920 Awaish Kumar: You can make a.
77 00:06:51.920 ⇒ 00:06:52.870 Amber Lin: New account.
78 00:06:53.340 ⇒ 00:06:59.210 Awaish Kumar: Yes, yeah. But it does not need to be a new user account, as we.
79 00:06:59.210 ⇒ 00:06:59.680 Amber Lin: Oh!
80 00:06:59.680 ⇒ 00:07:00.240 Awaish Kumar: Like.
81 00:07:00.940 ⇒ 00:07:07.560 Awaish Kumar: So it’s not a user account. It’s a service account. Service accounts are basically built for us
82 00:07:08.160 ⇒ 00:07:09.420 Awaish Kumar: very far, like.
83 00:07:09.780 ⇒ 00:07:11.170 Amber Lin: Oh!
84 00:07:11.170 ⇒ 00:07:12.450 Awaish Kumar: Integration, right.
85 00:07:12.800 ⇒ 00:07:17.970 Amber Lin: So I’m asking him for a service account, and then the key.
86 00:07:19.500 ⇒ 00:07:20.789 Awaish Kumar: Service account.
87 00:07:20.790 ⇒ 00:07:21.449 Amber Lin: Here’s the key!
88 00:07:21.450 ⇒ 00:07:25.839 Awaish Kumar: They create a service account, and then they download a key for that.
89 00:07:25.840 ⇒ 00:07:26.250 Amber Lin: Sounds, like.
90 00:07:26.250 ⇒ 00:07:26.870 Awaish Kumar: Conference.
91 00:07:27.250 ⇒ 00:07:27.940 Awaish Kumar: Please.
92 00:07:28.210 ⇒ 00:07:29.719 Awaish Kumar: Way to authenticate.
93 00:07:33.060 ⇒ 00:07:35.660 Amber Lin: Thank you. That makes it so much more clear.
94 00:07:36.960 ⇒ 00:07:41.479 Awaish Kumar: We are not really asking, but we are not really asking for that. It’s it’s for them.
95 00:07:41.480 ⇒ 00:07:43.930 Amber Lin: Yeah, yeah, I’m gonna okay.
96 00:07:43.930 ⇒ 00:07:49.680 Amber Lin: Him the 2 options. So that’s why I kind of wanted to make everything everything clear.
97 00:07:54.450 ⇒ 00:07:55.020 Amber Lin: Okay.
98 00:07:55.775 ⇒ 00:07:56.530 Awaish Kumar: Questions.
99 00:07:56.530 ⇒ 00:08:10.779 Annie Yu: The 1st option will require someone to log in every day to refresh. That’s not gonna be sustainable in the long term. I would think I think it’s okay with fake data sets because we we are not refreshing every day. But if.
100 00:08:11.620 ⇒ 00:08:13.799 Amber Lin: And we actually get the what does?
101 00:08:13.800 ⇒ 00:08:21.640 Amber Lin: What happens when we don’t refresh? Does our? Can we still use the previous data? Or does our whole power bi shut down.
102 00:08:21.640 ⇒ 00:08:25.430 Annie Yu: No, no, if we don’t refresh, it just doesn’t get new data, that’s all.
103 00:08:25.430 ⇒ 00:08:27.669 Amber Lin: Oh, okay, okay, I see.
104 00:08:28.040 ⇒ 00:08:32.630 Amber Lin: So I’m gonna I’m gonna add it.
105 00:08:34.750 ⇒ 00:08:38.500 Awaish Kumar: Like. Why I’m why I suspect that they
106 00:08:38.720 ⇒ 00:08:44.270 Awaish Kumar: they are not looking for option. 2 is because they are not really looking
107 00:08:44.370 ⇒ 00:08:47.030 Awaish Kumar: for us to refresh their data because
108 00:08:47.190 ⇒ 00:08:50.769 Awaish Kumar: they, what they would like is like they would like
109 00:08:50.920 ⇒ 00:08:53.000 Awaish Kumar: they will. They want to copy
110 00:08:54.740 ⇒ 00:09:00.769 Awaish Kumar: the dash like the charts and dashboards will build like the the just kind of a
111 00:09:01.360 ⇒ 00:09:05.780 Awaish Kumar: top level thing, and they want to keep it in some other like.
112 00:09:05.780 ⇒ 00:09:35.379 Amber Lin: Yeah. So they’re not gonna use the power bi, we’re currently using the yeah, or where you’re totally right. And so probably they’ll build this refresh on their own power. Bi, that’s directly connected to the clients. What we’ll what we will have access to is essentially what the client data looks like, but I guess when it refreshes I don’t think we’re directly responsible. But I think you guys re raise a really good point that we’ll go clarify with the clients.
113 00:09:47.990 ⇒ 00:09:55.650 Awaish Kumar: Yeah, if I take a programming example, what they want is like, any you write a function and they want to copy a function. I’ll use somewhere else.
114 00:09:58.210 ⇒ 00:10:02.070 Awaish Kumar: They’re not looking really for the out of that function in our system.
115 00:10:07.492 ⇒ 00:10:12.460 Annie Yu: Is that what they’re trying to do? So they will take the file.
116 00:10:12.630 ⇒ 00:10:12.970 Amber Lin: Yeah.
117 00:10:14.790 ⇒ 00:10:16.110 Annie Yu: Interesting.
118 00:10:16.110 ⇒ 00:10:36.550 Amber Lin: That’s what we currently understand. Maybe things will change when we get more data. But I’ll go clarify with that. But I think for now we can survive with the daily refresh. So we’re not technic. Technically, we’re not blocked on anything, but I’ll go confirm with them. So if they want it, they’ll create a service account.
119 00:10:37.164 ⇒ 00:11:00.139 Annie Yu: Then, I wanna request, because now we work with fake data which we know we are not getting new data every day. So it doesn’t make sense for me to manually do a daily refresh as we don’t get new data. But then, if Luke does something like he changes something to the models he can come in and manually refresh. Is that.
120 00:11:00.140 ⇒ 00:11:06.930 Amber Lin: Sure. So sure. Yeah, let’s delegate we should change the responsibility to him, refreshing every time he updates.
121 00:11:08.100 ⇒ 00:11:11.199 Annie Yu: Yeah, yeah, because we know we are not getting new data.
122 00:11:11.200 ⇒ 00:11:18.110 Amber Lin: Yeah, totally sounds good. do you guys know if he’s here.
123 00:11:18.910 ⇒ 00:11:23.290 Awaish Kumar: Like, where are we with power? Bi dashboards like, are we done, or.
124 00:11:24.070 ⇒ 00:11:25.590 Annie Yu: No, that’s working partner.
125 00:11:25.590 ⇒ 00:11:26.590 Awaish Kumar: Those changes?
126 00:11:28.050 ⇒ 00:11:33.050 Awaish Kumar: Yeah, can I go on linear like, do you have these deadlines set up? Rambo.
127 00:11:33.050 ⇒ 00:11:35.039 Amber Lin: Yeah, it’s it’s loading.
128 00:11:35.630 ⇒ 00:11:41.590 Amber Lin: So power. Bi, okay, this is testing.
129 00:11:44.770 ⇒ 00:11:49.339 Amber Lin: yeah, okay, so this is power. Bi, we sent it.
130 00:11:49.340 ⇒ 00:11:50.420 Awaish Kumar: Just have one.
131 00:11:52.270 ⇒ 00:11:56.130 Awaish Kumar: Question here for you, Amber like, do we want to?
132 00:11:56.470 ⇒ 00:12:06.340 Awaish Kumar: I don’t know that you have work with client, but do we want to keep pushing every day. To the client, or we just send a message and then wait.
133 00:12:08.270 ⇒ 00:12:09.829 Awaish Kumar: github stuff like
134 00:12:10.170 ⇒ 00:12:17.979 Awaish Kumar: if they don’t give a reply in a day like do we follow? Follow once a day my multiple times a day, or like how it goes.
135 00:12:18.990 ⇒ 00:12:23.859 Amber Lin: Yeah, I will. I will bump this up again like I will do that.
136 00:12:24.890 ⇒ 00:12:32.230 Awaish Kumar: No, in general, like, I want to just ask like, is that okay? If I just write down down a follow
137 00:12:32.790 ⇒ 00:12:38.790 Awaish Kumar: like instead of asking you, is it open? Like, like, yeah, totally
138 00:12:38.930 ⇒ 00:12:41.170 Awaish Kumar: totally like, as long as we’re.
139 00:12:41.170 ⇒ 00:12:53.119 Awaish Kumar: I just want to understand that frequency because I don’t know their mindset sending them a message like 2 messages a day, or something like that, to follow up messages.
140 00:12:53.530 ⇒ 00:12:54.470 Amber Lin: I think.
141 00:12:54.920 ⇒ 00:12:58.180 Amber Lin: Yeah, I think 2 probably would be
142 00:12:58.900 ⇒ 00:13:13.720 Amber Lin: okay per day. As long as we are aligned of whatever things we can escalate internally are done, and what whatever we escalate to them is really something that has has to be
143 00:13:14.340 ⇒ 00:13:17.539 Amber Lin: something that they do and not. It’s like
144 00:13:17.660 ⇒ 00:13:22.870 Amber Lin: we’ll escalate internally before we go to them. But if that’s the case, then we can ping them.
145 00:13:23.310 ⇒ 00:13:29.049 Amber Lin: Cause I that was yesterday and still haven’t heard anything.
146 00:13:34.820 ⇒ 00:13:41.320 Amber Lin: Yeah, that will be great. So those that’s Trevor.
147 00:13:43.610 ⇒ 00:13:44.380 Awaish Kumar: Managers.
148 00:13:47.910 ⇒ 00:13:48.340 Amber Lin: Yeah.
149 00:13:48.340 ⇒ 00:13:52.970 Awaish Kumar: So why, like DVD access to Ari? I think it it is it also
150 00:13:53.240 ⇒ 00:13:57.110 Awaish Kumar: what he’s asking for, like access to SQL. Query. We write.
151 00:13:57.220 ⇒ 00:14:01.390 Awaish Kumar: So it’s some. It’s also like access to Github, not the.
152 00:14:01.390 ⇒ 00:14:03.279 Amber Lin: Oh, oh, my bad.
153 00:14:03.280 ⇒ 00:14:05.929 Awaish Kumar: Just a code in the Github right?
154 00:14:07.170 ⇒ 00:14:09.001 Amber Lin: I see my bad
155 00:14:09.460 ⇒ 00:14:12.200 Awaish Kumar: Like DVD. Is just a code in Github. So.
156 00:14:12.500 ⇒ 00:14:13.820 Awaish Kumar: Oh, I think.
157 00:14:13.820 ⇒ 00:14:16.605 Amber Lin: My bad. I didn’t know that.
158 00:14:18.370 ⇒ 00:14:22.679 Amber Lin: Let me let me edit. How do I?
159 00:14:23.900 ⇒ 00:14:24.860 Amber Lin: Damn it!
160 00:14:25.160 ⇒ 00:14:26.679 Amber Lin: How do I edit this.
161 00:14:27.130 ⇒ 00:14:32.659 Awaish Kumar: I I don’t know. If, like, are they? They are using like I have to confirm with Luke is not here.
162 00:14:33.280 ⇒ 00:14:38.530 Awaish Kumar: But do you know, like if they’re using Dbt, core or Dbt cloud.
163 00:14:39.720 ⇒ 00:14:42.089 Amber Lin: Question for Luke.
164 00:14:42.420 ⇒ 00:14:43.100 Amber Lin: Don’t know.
165 00:14:43.100 ⇒ 00:14:43.690 Awaish Kumar: Okay?
166 00:14:46.310 ⇒ 00:14:49.299 Awaish Kumar: Because if it was dbt cloud, then.
167 00:14:49.700 ⇒ 00:14:53.050 Awaish Kumar: like we can write Dvt as well otherwise.
168 00:14:53.510 ⇒ 00:14:54.880 Awaish Kumar: So just write me down.
169 00:14:55.650 ⇒ 00:15:03.650 Amber Lin: Yeah, do we? I think I told Ari that we use. Dv, we don’t use. Dbt cloud, I’m not sure, though.
170 00:15:06.690 ⇒ 00:15:08.389 Amber Lin: Yeah, let me.
171 00:15:09.330 ⇒ 00:15:09.910 Awaish Kumar: Okay.
172 00:15:10.390 ⇒ 00:15:14.140 Annie Yu: Yeah, I think you can’t edit the message once it’s read.
173 00:15:14.140 ⇒ 00:15:15.030 Amber Lin: Oh!
174 00:15:15.220 ⇒ 00:15:15.940 Annie Yu: I really.
175 00:15:15.940 ⇒ 00:15:16.840 Amber Lin: Interesting.
176 00:15:16.980 ⇒ 00:15:20.300 Amber Lin: Yeah. So they read it and did nothing. Okay.
177 00:15:23.783 ⇒ 00:15:25.950 Amber Lin: okay, let’s look at this.
178 00:15:26.770 ⇒ 00:15:27.840 Amber Lin: I think.
179 00:15:35.260 ⇒ 00:15:41.119 Amber Lin: I guess I wish, do you have access to. Dbt, no right.
180 00:15:41.120 ⇒ 00:15:41.959 Awaish Kumar: You don’t know.
181 00:15:42.220 ⇒ 00:15:46.229 Amber Lin: Okay, you don’t have access to either of them. I’m gonna ask for.
182 00:15:46.230 ⇒ 00:15:49.649 Awaish Kumar: I don’t have. But what I’m trying to say is that.
183 00:15:49.650 ⇒ 00:15:53.510 Amber Lin: Yeah, yeah, I understand, like the sequel code here wants us in Github.
184 00:15:54.380 ⇒ 00:16:01.240 Awaish Kumar: Yeah. But the like Dbt is is a SQL code, right? It’s not a separate thing.
185 00:16:04.410 ⇒ 00:16:05.410 Amber Lin: I see.
186 00:16:06.000 ⇒ 00:16:08.620 Awaish Kumar: Dbt. Code, which is in the Github.
187 00:16:09.310 ⇒ 00:16:09.830 Amber Lin: Hmm.
188 00:16:09.830 ⇒ 00:16:11.080 Awaish Kumar: That’s.
189 00:16:12.910 ⇒ 00:16:20.420 Amber Lin: I see I’m just gonna delete delete message
190 00:16:28.480 ⇒ 00:16:29.310 Amber Lin: and.
191 00:16:33.340 ⇒ 00:16:40.709 Awaish Kumar: So like do we know the rep name of the Repository for the Dbt.
192 00:16:41.110 ⇒ 00:16:42.789 Amber Lin: I I don’t know.
193 00:16:44.950 ⇒ 00:16:46.100 Amber Lin: Okay, no.
194 00:16:46.100 ⇒ 00:16:48.299 Awaish Kumar: No, because he’s pushing the portal right.
195 00:16:50.140 ⇒ 00:16:50.750 Amber Lin: Yeah.
196 00:17:11.910 ⇒ 00:17:13.490 Amber Lin: okay, sounds good.
197 00:17:14.390 ⇒ 00:17:23.250 Amber Lin: Looking at this. Any? Do you wanna share some progress on the dashboard or anything you’re stuck on?
198 00:17:23.460 ⇒ 00:17:24.940 Amber Lin: Do you wanna share screen.
199 00:17:26.430 ⇒ 00:17:28.690 Annie Yu: Yeah, not I did.
200 00:17:32.407 ⇒ 00:17:38.139 Annie Yu: I did add. I did add some comments to
201 00:17:43.510 ⇒ 00:17:45.129 Annie Yu: not this one.
202 00:17:52.300 ⇒ 00:17:55.750 Annie Yu: So I did add some measures that.
203 00:17:55.750 ⇒ 00:17:56.360 Amber Lin: Hmm.
204 00:17:56.540 ⇒ 00:18:01.550 Annie Yu: Validated I so all the logics are here.
205 00:18:02.565 ⇒ 00:18:03.310 Annie Yu: So.
206 00:18:03.310 ⇒ 00:18:04.310 Amber Lin: Yay!
207 00:18:04.580 ⇒ 00:18:09.280 Annie Yu: Metrics are done and validated against bigquery.
208 00:18:10.618 ⇒ 00:18:17.370 Annie Yu: Right now, I’m just today I’ll keep building this part.
209 00:18:20.310 ⇒ 00:18:21.139 Amber Lin: I see.
210 00:18:21.140 ⇒ 00:18:26.500 Annie Yu: And I’m using this this part as the the guideline.
211 00:18:27.920 ⇒ 00:18:31.539 Annie Yu: So ideally it would be.
212 00:18:38.890 ⇒ 00:18:45.360 Annie Yu: It will be 3 paid pages, and I’m just focusing on
213 00:18:45.560 ⇒ 00:18:51.299 Annie Yu: like one page one page, one page, but then added, all the filters.
214 00:18:54.650 ⇒ 00:18:55.540 Amber Lin: Okay.
215 00:18:56.950 ⇒ 00:19:02.119 Awaish Kumar: The filters are on the top level. You may try these ones.
216 00:19:02.632 ⇒ 00:19:04.440 Annie Yu: Yeah, it should have.
217 00:19:04.860 ⇒ 00:19:07.710 Annie Yu: So in the finalized version, it will have
218 00:19:08.070 ⇒ 00:19:10.640 Annie Yu: filters on all the pages. I think.
219 00:19:10.640 ⇒ 00:19:12.870 Amber Lin: Oh, awesome!
220 00:19:13.010 ⇒ 00:19:20.729 Annie Yu: But yeah, but they will slightly differ. Just so, you know, like, here’s day of week. So it makes sense to have
221 00:19:20.900 ⇒ 00:19:22.360 Annie Yu: hour of date, filter.
222 00:19:23.290 ⇒ 00:19:29.399 Annie Yu: It doesn’t make sense to have that filter, but then it makes sense to have day of week filter.
223 00:19:29.400 ⇒ 00:19:30.380 Amber Lin: Makes sense.
224 00:19:30.650 ⇒ 00:19:42.189 Amber Lin: This is awesome. Do you mind dropping like a few screenshots? So I can. So I can share our progress with a client, or is this? Oh, this isn’t okay. I know where it is. I can go look at it.
225 00:19:43.150 ⇒ 00:19:46.510 Annie Yu: Yeah, it’s not. It’s not complete yet.
226 00:19:50.490 ⇒ 00:19:51.380 Annie Yu: Yeah.
227 00:19:51.620 ⇒ 00:20:00.369 Amber Lin: Yeah, I’ll just let them know that we’re working on things because they get really stressed out. And they think we’re not doing anything. I want them to know that we are.
228 00:20:01.130 ⇒ 00:20:04.409 Annie Yu: Yeah, I think, I added, Yeah, this is the the file.
229 00:20:04.410 ⇒ 00:20:11.439 Amber Lin: Oh, awesome, awesome! Thank you. There’s 1 other ticket. It’s sort of it’s not
230 00:20:11.780 ⇒ 00:20:16.510 Amber Lin: like a task, but more of documentation of as you build.
231 00:20:16.970 ⇒ 00:20:23.200 Amber Lin: I think you already have a lot of that of what dashboards of what fields they’re coming from.
232 00:20:23.530 ⇒ 00:20:43.269 Amber Lin: It’s on the very bottom. The last one document, power bi and lineage of cause. I put that as still to do, because I know you’re still finalizing what what graphs you’re using. But once we have it, would you mind just documenting what links to what field or what table
233 00:20:43.440 ⇒ 00:20:45.699 Amber Lin: that will that will help us?
234 00:20:46.930 ⇒ 00:20:48.079 Amber Lin: In the future?
235 00:20:49.372 ⇒ 00:20:54.799 Annie Yu: Yeah, sure. But right now it’s just using the communication
236 00:20:56.280 ⇒ 00:21:01.440 Annie Yu: table. I’m not using the others add to build.
237 00:21:03.770 ⇒ 00:21:06.790 Annie Yu: So we imported these 4. So right now.
238 00:21:08.070 ⇒ 00:21:09.799 Annie Yu: And these are for
239 00:21:10.200 ⇒ 00:21:21.519 Annie Yu: so you know, like day of week, and if we are just using this, it will default it to like descending or ascending, so it would be like Monday, Tuesday, Wednesday.
240 00:21:21.640 ⇒ 00:21:23.949 Annie Yu: So I had to build these kind of.
241 00:21:24.730 ⇒ 00:21:25.880 Amber Lin: Oh, I
242 00:21:30.070 ⇒ 00:21:30.550 Annie Yu: Yeah.
243 00:21:30.550 ⇒ 00:21:57.249 Amber Lin: I see. I think a good way to do it. You know, we have the data platform sheet. Maybe if you can, let’s make another tab, and in one column we’ll say, like all the charts, all the different charts that we are building, like the different visualizations, and then another one we can talk about where they’re linking to. And currently, we, we can just say everything is linking to communication events.
244 00:22:00.410 ⇒ 00:22:09.089 Annie Yu: Yeah, yeah. So but then, as far as where that’s like where this
245 00:22:09.320 ⇒ 00:22:12.619 Annie Yu: column comes from, I wouldn’t have the answer.
246 00:22:12.620 ⇒ 00:22:15.009 Amber Lin: Yeah, that that’s okay. That’s okay. Like, I think.
247 00:22:15.140 ⇒ 00:22:23.510 Amber Lin: if as long as we have what column we’re referring to, I believe we should already have documentation on the modeling side.
248 00:22:23.800 ⇒ 00:22:31.669 Amber Lin: So that wouldn’t be a question for you. That would be for Luke. As long as you name the columns correctly, we should have documentation on that.
249 00:22:33.400 ⇒ 00:22:36.963 Annie Yu: Okay, okay? And 1, 1 more quick question is,
250 00:22:38.420 ⇒ 00:22:41.109 Annie Yu: So I’m just using all the columns available. But.
251 00:22:41.520 ⇒ 00:22:45.670 Annie Yu: You have some that’s like unknown. So.
252 00:22:46.150 ⇒ 00:22:46.720 Amber Lin: Hmm.
253 00:22:46.940 ⇒ 00:22:52.869 Annie Yu: But I’m I’m bringing them in just because it’s listed here, and it’s available as a column.
254 00:22:52.870 ⇒ 00:22:53.580 Amber Lin: Okay.
255 00:22:54.330 ⇒ 00:22:55.210 Awaish Kumar: That’s okay.
256 00:22:55.910 ⇒ 00:22:56.580 Annie Yu: Okay.
257 00:22:58.300 ⇒ 00:23:03.420 Amber Lin: Yeah, I think we’re making great progress. I need to check in with Luke on other stuff. Yeah, I wish.
258 00:23:03.420 ⇒ 00:23:08.679 Awaish Kumar: When are when are we like targeting like power bi work.
259 00:23:14.910 ⇒ 00:23:16.200 Amber Lin: Annie, what do you think.
260 00:23:18.960 ⇒ 00:23:26.769 Annie Yu: I think we have Monday here which I think we can get it done by Monday. I’m not sure about today, but if
261 00:23:27.280 ⇒ 00:23:35.219 Annie Yu: if it’s smooth today, will probably be okay. But let’s say Monday.
262 00:23:36.240 ⇒ 00:23:36.630 Amber Lin: Okay.
263 00:23:36.630 ⇒ 00:23:37.140 Awaish Kumar: Yeah, but.
264 00:23:37.140 ⇒ 00:23:37.680 Amber Lin: Oh!
265 00:23:37.680 ⇒ 00:23:42.510 Awaish Kumar: So that so after you are done like, done with this on Monday, like
266 00:23:42.680 ⇒ 00:23:46.669 Awaish Kumar: like, have we built all the required
267 00:23:48.040 ⇒ 00:23:50.420 Awaish Kumar: like the dash, like the charts.
268 00:23:50.670 ⇒ 00:23:56.810 Annie Yu: In the power. We are not yet. That’s why it’s gonna be working progress still today.
269 00:23:58.130 ⇒ 00:23:58.970 Awaish Kumar: Not like.
270 00:24:00.190 ⇒ 00:24:02.060 Amber Lin: Oh, I see! I wish.
271 00:24:02.060 ⇒ 00:24:09.639 Awaish Kumar: Until Monday. You have something, but after after you are done with this on Monday, I’m just asking. Is there any.
272 00:24:09.900 ⇒ 00:24:13.360 Amber Lin: Charts which are missing apart from that, or will that?
273 00:24:13.360 ⇒ 00:24:19.879 Amber Lin: Yeah, I think that’s a question for me. So I would one. I would take what Annie has of
274 00:24:19.940 ⇒ 00:24:43.660 Amber Lin: how we separated the different charts to confirm. Okay, are these all the charts we need? And then I’m gonna confirm. Okay, do we have all the filters. Currently, we, we know that we have a current gap which is tool usage. And that’s something that Luke needs to generate synthetic data, and then do the modeling so that Annie can add to it. So by Monday our goal is to complete everything other than tool usage.
275 00:24:43.740 ⇒ 00:24:54.279 Amber Lin: And then Luke should have synthetic data, and then the modeling for 2 usage next week. And then that’s the last thing that we’ll need to add to our power Bi.
276 00:24:54.280 ⇒ 00:24:59.290 Annie Yu: I actually see a tool usage here.
277 00:24:59.580 ⇒ 00:25:00.380 Amber Lin: Oh!
278 00:25:00.380 ⇒ 00:25:04.060 Annie Yu: That’s that.
279 00:25:04.400 ⇒ 00:25:05.040 Annie Yu: But then.
280 00:25:05.040 ⇒ 00:25:06.660 Amber Lin: Where is? Where is it?
281 00:25:06.910 ⇒ 00:25:09.429 Annie Yu: Event, communication, event.
282 00:25:09.570 ⇒ 00:25:17.930 Amber Lin: I see I see. He’s still. I think he’s still generating the synthetic data for
283 00:25:18.390 ⇒ 00:25:20.359 Amber Lin: for the different tools.
284 00:25:20.460 ⇒ 00:25:23.919 Amber Lin: So there’s copilot. And then office 3, 65.
285 00:25:24.140 ⇒ 00:25:26.910 Amber Lin: I’m looking at. Yeah, let me share my screen.
286 00:25:29.100 ⇒ 00:25:32.199 Amber Lin: So I am looking at this.
287 00:25:32.950 ⇒ 00:25:38.349 Amber Lin: That’s still in progress. So these are the things that we need to do to get tool usage
288 00:25:38.550 ⇒ 00:25:47.590 Amber Lin: in there, right? So synthetic data, synthetic data modeling, modeling. And then we add that into power. Bi, so that Annie can
289 00:25:48.750 ⇒ 00:25:50.399 Amber Lin: add that to the charts.
290 00:25:52.817 ⇒ 00:25:58.545 Annie Yu: And so for tool usage, that’s is that I
291 00:26:01.460 ⇒ 00:26:04.790 Annie Yu: should that be a filter, or like some kind of.
292 00:26:04.790 ⇒ 00:26:09.790 Amber Lin: That’s similar to email and chat. So that will just be the
293 00:26:09.990 ⇒ 00:26:13.299 Amber Lin: base like event type. I would say.
294 00:26:14.850 ⇒ 00:26:15.970 Annie Yu: Oh, okay. Okay.
295 00:26:15.970 ⇒ 00:26:22.459 Amber Lin: Yeah, so it should be relatively easy for you, because you have all the other filters set up. This is just another like
296 00:26:22.830 ⇒ 00:26:25.120 Amber Lin: base level, raw data.
297 00:26:25.603 ⇒ 00:26:41.250 Amber Lin: I’ll clarify. Once he generates, once he generates data, we can clarify, if it’s by duration or by count. And if if by duration, how we’re calculating that duration. But I I need to talk to him to know how this is going.
298 00:26:42.660 ⇒ 00:26:47.290 Awaish Kumar: So are we keeping up with the clients of
299 00:26:48.020 ⇒ 00:26:50.870 Awaish Kumar: contract sign, sign up with their client.
300 00:26:51.808 ⇒ 00:27:03.629 Amber Lin: Yeah, I talked to them recently. They said, they’ll give me an update soon soon, which I assume is not gonna be next week. So I think we have time to finish off
301 00:27:04.140 ⇒ 00:27:07.869 Amber Lin: this. This cycle. So this current cycle
302 00:27:08.110 ⇒ 00:27:11.540 Amber Lin: ends in a week. Another week.
303 00:27:13.980 ⇒ 00:27:14.970 Awaish Kumar: Okay.
304 00:27:14.970 ⇒ 00:27:17.130 Amber Lin: Yeah, thank you for checking.
305 00:27:17.750 ⇒ 00:27:21.829 Amber Lin: I need to update them. And I need to talk to Luke.
306 00:27:22.470 ⇒ 00:27:26.430 Amber Lin: I don’t know if he has something right now.
307 00:27:28.010 ⇒ 00:27:31.207 Amber Lin: Yeah, I think we’re we’re good.
308 00:27:31.890 ⇒ 00:27:35.009 Amber Lin: I’ll go look at the data set. Yeah, go ahead.
309 00:27:35.376 ⇒ 00:27:43.800 Annie Yu: One small thing which I think look already. Read my message, but just know that if there’s any change he should refresh the
310 00:27:44.330 ⇒ 00:27:48.630 Annie Yu: matter more underscore import model
311 00:27:49.490 ⇒ 00:27:54.330 Amber Lin: Would you mind sending that in our internal chat, and add him.
312 00:27:54.860 ⇒ 00:27:55.419 Annie Yu: I did.
313 00:27:55.420 ⇒ 00:28:02.880 Amber Lin: And asking him if he okay, awesome. If he makes any updates moving forward, he should do the refresh instead of you. I should.
314 00:28:03.195 ⇒ 00:28:04.140 Annie Yu: I’ll make that.
315 00:28:04.140 ⇒ 00:28:07.730 Amber Lin: You make that clear to him. Okay, that will be great.
316 00:28:13.630 ⇒ 00:28:14.730 Annie Yu: Cool. Okay.
317 00:28:19.450 ⇒ 00:28:20.300 Amber Lin: Okay.
318 00:28:20.640 ⇒ 00:28:21.720 Amber Lin: Sounds good.
319 00:28:21.950 ⇒ 00:28:25.820 Amber Lin: Thanks, everyone. I’ll go check in with the clients and check in with Luke.
320 00:28:28.170 ⇒ 00:28:29.080 Annie Yu: Yeah, sounds good.
321 00:28:29.080 ⇒ 00:28:29.580 Awaish Kumar: Okay. Thank you.
322 00:28:29.580 ⇒ 00:28:37.619 Annie Yu: So you know, I actually realized, I can use. I can write docs on the power bi service.
323 00:28:37.850 ⇒ 00:28:38.860 Amber Lin: Yay!
324 00:28:39.260 ⇒ 00:28:45.310 Annie Yu: I’m not gonna have access to a windows. PC, next week. Just so, you know.
325 00:28:45.310 ⇒ 00:28:48.319 Amber Lin: Oh, oh, wait! Did you say you can or can’t.
326 00:28:48.650 ⇒ 00:28:56.750 Annie Yu: I can. So I’m I’m not bringing that, but that is to publish any models, but which.
327 00:28:56.750 ⇒ 00:29:00.040 Amber Lin: I mean it’s Luke’s is his side.
328 00:29:00.040 ⇒ 00:29:00.929 Annie Yu: Yeah, we’re supposed.
329 00:29:02.060 ⇒ 00:29:06.409 Amber Lin: Yeah, okay. As long as you can write Dacs like, that’s all you need for it.
330 00:29:06.410 ⇒ 00:29:10.510 Annie Yu: I’m right back on an existing model. Does that make sense?
331 00:29:10.990 ⇒ 00:29:12.079 Annie Yu: Yeah, I see.
332 00:29:12.080 ⇒ 00:29:12.690 Amber Lin: I see.
333 00:29:12.910 ⇒ 00:29:17.059 Amber Lin: Yeah, okay, sounds good. We’ll keep that in mind when we delegate things.
334 00:29:17.300 ⇒ 00:29:18.110 Annie Yu: Okay. Awesome.
335 00:29:18.110 ⇒ 00:29:19.140 Amber Lin: All right.
336 00:29:19.280 ⇒ 00:29:20.350 Amber Lin: Thanks.