Meeting Title: ABC Standup Date: 2025-07-16 Meeting participants: Luke Daque, Mustafa Raja, Casie Aviles, Amber Lin, Annie Yu
WEBVTT
1 00:00:35.220 ⇒ 00:00:36.430 Amber Lin: Hello!
2 00:00:38.100 ⇒ 00:00:41.010 Amber Lin: I just hopped from another call.
3 00:00:41.503 ⇒ 00:00:45.059 Amber Lin: Let me pull up our tickets and let’s go over them.
4 00:00:46.890 ⇒ 00:00:51.080 Amber Lin: So this is
5 00:00:54.690 ⇒ 00:01:00.779 Amber Lin: that’s my test. Let’s start with.
6 00:01:02.280 ⇒ 00:01:10.750 Amber Lin: Okay, wait.
7 00:01:13.860 ⇒ 00:01:14.730 Amber Lin: Okay.
8 00:01:15.219 ⇒ 00:01:18.729 Amber Lin: For the dashboard, Luke. How is it? How is it going.
9 00:01:25.350 ⇒ 00:01:27.220 Luke Daque: Oh, sorry I was on mute, but.
10 00:01:27.220 ⇒ 00:01:27.760 Amber Lin: Hmm.
11 00:01:28.300 ⇒ 00:01:33.570 Luke Daque: Yeah. The yeah. We already have. I already have a VR for that. The.
12 00:01:33.970 ⇒ 00:01:36.249 Luke Daque: Up an Api for the timestamp.
13 00:01:36.841 ⇒ 00:01:43.470 Luke Daque: I think that’s in review by always. And then, yeah, once that’s done, I we can start working on
14 00:01:43.590 ⇒ 00:01:46.260 Luke Daque: mode modeling that.
15 00:01:46.900 ⇒ 00:01:47.890 Amber Lin: Okay, so.
16 00:01:47.890 ⇒ 00:01:49.040 Luke Daque: Evt and stuff.
17 00:01:49.560 ⇒ 00:02:01.889 Amber Lin: Yay awesome. So these are in progress. That’s really great to hear. I think, that lets Annie start out her work for the dashboards. I think these are kind of just
18 00:02:02.763 ⇒ 00:02:06.300 Amber Lin: it’ll be great to get them done and set up.
19 00:02:07.600 ⇒ 00:02:09.640 Amber Lin: Is Annie here?
20 00:02:11.204 ⇒ 00:02:15.180 Amber Lin: No, she’s not okay.
21 00:02:15.880 ⇒ 00:02:27.109 Amber Lin: Let’s do the other. Can someone ping if Annie can hop on so we can talk about her dashboards, for now Casey must have a will talk. Look, can you message, Annie? If she can hop on.
22 00:02:27.820 ⇒ 00:02:28.600 Luke Daque: Sure.
23 00:02:29.040 ⇒ 00:02:29.440 Amber Lin: Okay.
24 00:02:31.500 ⇒ 00:02:34.070 Amber Lin: Mustafa. How is your tickets going.
25 00:02:34.070 ⇒ 00:02:38.810 Mustafa Raja: Yeah. Yeah. So for my Andy one, I have some screenshots in the comment.
26 00:02:42.630 ⇒ 00:02:43.460 Mustafa Raja: oh, great!
27 00:02:43.460 ⇒ 00:02:47.870 Mustafa Raja: Let me know how this looks. If if this is all that needs to be done.
28 00:02:48.690 ⇒ 00:02:57.029 Amber Lin: Honestly, I think that I think that is, I’ll put it into testing so that I can test it. And then I’m gonna
29 00:02:57.430 ⇒ 00:03:01.873 Amber Lin: make ask the trainers to test it. I think this is really good for now.
30 00:03:02.500 ⇒ 00:03:03.030 Mustafa Raja: Yeah.
31 00:03:03.030 ⇒ 00:03:03.510 Amber Lin: Now.
32 00:03:04.355 ⇒ 00:03:24.100 Mustafa Raja: One more thing. So in the in the spreadsheet, what I did is I control left the Central Doc and I search for the template keyword and every template that I can find I could find. I I put that into the spreadsheet so.
33 00:03:24.550 ⇒ 00:03:29.660 Mustafa Raja: I might be missing any templates. So that’s that’s a heads up.
34 00:03:30.462 ⇒ 00:03:36.879 Amber Lin: Okay? If we identify any missing templates?
35 00:03:37.894 ⇒ 00:03:47.959 Amber Lin: All we need do you can you put the spreadsheet link here, so then I can. If then we don’t have to go back to you, you can just add we can just add it to the templates.
36 00:03:47.960 ⇒ 00:03:48.680 Mustafa Raja: Oh, to the.
37 00:03:48.680 ⇒ 00:03:49.530 Amber Lin: Spreadsheet.
38 00:03:50.450 ⇒ 00:03:54.959 Mustafa Raja: Let me quickly add this, I’ll I’ll add this as a comment.
39 00:03:55.390 ⇒ 00:03:56.789 Amber Lin: Okay. Awesome.
40 00:03:57.896 ⇒ 00:04:00.330 Amber Lin: I think the other one.
41 00:04:00.610 ⇒ 00:04:02.640 Mustafa Raja: Yeah, I need to start working on that.
42 00:04:02.640 ⇒ 00:04:09.509 Amber Lin: Okay, okay, no worries. Then, Casey, how is yours? Returned Urls.
43 00:04:09.930 ⇒ 00:04:12.290 Amber Lin: Portal. URL. Oh, wow!
44 00:04:12.290 ⇒ 00:04:12.830 Casie Aviles: Yeah.
45 00:04:13.180 ⇒ 00:04:14.040 Amber Lin: Wow!
46 00:04:14.900 ⇒ 00:04:15.280 Casie Aviles: That’s.
47 00:04:15.280 ⇒ 00:04:15.930 Amber Lin: Right.
48 00:04:16.769 ⇒ 00:04:24.959 Casie Aviles: Yeah. So I managed to get the Urls there, although, like, there is one issue that come, yeah, that popped up
49 00:04:25.603 ⇒ 00:04:34.379 Casie Aviles: I feel like I feel like querying like, you know, the process of getting this the contacts from Central Doc start it’s starting to spike in terms of
50 00:04:34.759 ⇒ 00:04:35.809 Casie Aviles: response times.
51 00:04:35.810 ⇒ 00:04:36.420 Amber Lin: Hmm.
52 00:04:36.420 ⇒ 00:04:38.269 Casie Aviles: I’m not sure if it’s just with me.
53 00:04:39.920 ⇒ 00:04:40.860 Casie Aviles: But yeah, I think.
54 00:04:40.860 ⇒ 00:04:41.800 Amber Lin: Feel that too.
55 00:04:42.860 ⇒ 00:04:47.969 Casie Aviles: Yeah, I feel it. It looks like it’s starting to, you know. I’ll get.
56 00:04:48.540 ⇒ 00:04:53.089 Casie Aviles: you know. Yeah, it takes longer now, so I’ll I’ll have to do some.
57 00:04:53.430 ⇒ 00:04:59.970 Casie Aviles: I mean I I close. I I put this in internal review, but I guess that other issue is I I will
58 00:05:00.260 ⇒ 00:05:03.800 Casie Aviles: put some more time into that, because.
59 00:05:03.800 ⇒ 00:05:04.280 Amber Lin: Excuse me.
60 00:05:04.280 ⇒ 00:05:05.380 Casie Aviles: The URL.
61 00:05:06.802 ⇒ 00:05:11.750 Amber Lin: I mean, what? What else needs to be done for this?
62 00:05:12.590 ⇒ 00:05:16.030 Amber Lin: I think that’s it looks really good. Yeah, it looks really good.
63 00:05:16.030 ⇒ 00:05:16.920 Casie Aviles: We can make a.
64 00:05:16.920 ⇒ 00:05:19.159 Amber Lin: Another ticket for processing time.
65 00:05:19.160 ⇒ 00:05:23.679 Casie Aviles: Okay, yeah, we didn’t really add any new urls. So far, right?
66 00:05:24.336 ⇒ 00:05:24.803 Amber Lin: No
67 00:05:25.270 ⇒ 00:05:25.780 Casie Aviles: Okay.
68 00:05:25.780 ⇒ 00:05:35.080 Amber Lin: If if I add them, do I just add them to the Central Doc? Or would a separate spreadsheet also help with that? Just like how Mustafa is doing the templates.
69 00:05:37.070 ⇒ 00:05:37.790 Casie Aviles: I think.
70 00:05:38.380 ⇒ 00:05:43.609 Casie Aviles: Let’s yeah. It’s fine. If we could just have it on Central Doc, for now.
71 00:05:43.610 ⇒ 00:05:44.250 Amber Lin: Okay.
72 00:05:44.530 ⇒ 00:05:50.589 Casie Aviles: Because they’re tied to like the specific questions like, you know, the topics. So it’s fine for now.
73 00:05:51.010 ⇒ 00:05:57.020 Amber Lin: Valid. Okay? I think so feel free to hop off
74 00:06:01.053 ⇒ 00:06:12.940 Amber Lin: Casey might keep you a little bit longer, because I want to talk about the response time at the end. Annie, thanks for joining. Luke has got the Timestamps to
75 00:06:15.610 ⇒ 00:06:20.710 Amber Lin: to work, and then can we
76 00:06:21.270 ⇒ 00:06:24.449 Amber Lin: do? You have all you need to start the dashboards.
77 00:06:25.920 ⇒ 00:06:32.890 Annie Yu: Are those fields in the S 3 data cause I checked earlier. I did another
78 00:06:34.880 ⇒ 00:06:41.679 Annie Yu: poll, and I don’t think I see the fields in the in the S. 3 source, unreal.
79 00:06:43.350 ⇒ 00:06:49.030 Luke Daque: Yeah, I’ll have to check that. I it looks like the Pr was already merged. So
80 00:06:49.820 ⇒ 00:06:52.849 Luke Daque: yeah, I’ll check the S 3 bucket. Maybe I can. I can
81 00:06:54.190 ⇒ 00:06:55.990 Luke Daque: get back to you on that, Annie.
82 00:06:56.580 ⇒ 00:07:03.719 Annie Yu: Okay, yeah. If if they’re in there, I think I then can can do the join and then build the dashboard.
83 00:07:04.470 ⇒ 00:07:21.030 Amber Lin: Okay, cause? Would it be possible? Since we now have the current data, can we have the current data like at least fill out the current. Kpi dashboard like is, does that take a lot of time?
84 00:07:21.880 ⇒ 00:07:23.370 Annie Yu: What do you mean by that.
85 00:07:24.084 ⇒ 00:07:37.589 Amber Lin: You know the current dashboard is not the new one. You’re building the current Kpi, one where you did the join like within, I think, within real. I’m not sure where you did that. But right now that one we only have
86 00:07:37.930 ⇒ 00:07:48.670 Amber Lin: say until end of May like, now that we have the Api that we can pull the fresh data. Is there a way that we can just show new data here.
87 00:07:52.350 ⇒ 00:07:58.250 Annie Yu: If that’s the route we’re gonna go with. I then have to get the
88 00:07:58.960 ⇒ 00:08:04.940 Annie Yu: like. All the fields that we got from Brian to make sure that the fields are aligned, and then load them.
89 00:08:04.940 ⇒ 00:08:15.099 Amber Lin: Oh, okay, okay, that that makes sense. So that sounds like it’ll take a while. Would it take less time if you’re just building a new one.
90 00:08:16.540 ⇒ 00:08:17.705 Annie Yu: Probably.
91 00:08:19.420 ⇒ 00:08:32.770 Annie Yu: that’s that’s my hope. Cause I did the I did kind of like the prep work for the new data that we got so my hope is just that from here I just have to
92 00:08:33.309 ⇒ 00:08:35.599 Annie Yu: do the right join, and then.
93 00:08:36.860 ⇒ 00:08:37.490 Amber Lin: Hmm.
94 00:08:38.350 ⇒ 00:08:43.089 Annie Yu: Do like a kind of like a copy and paste for metrics, and then.
95 00:08:44.259 ⇒ 00:08:44.729 Amber Lin: Okay.
96 00:08:44.730 ⇒ 00:08:47.139 Annie Yu: Okay, the dashboard from there. That’s.
97 00:08:47.140 ⇒ 00:08:48.676 Amber Lin: I see, I see.
98 00:08:49.060 ⇒ 00:08:57.499 Annie Yu: I think that shouldn’t require much like more new work that makes sense.
99 00:08:57.650 ⇒ 00:08:59.080 Casie Aviles: I see so.
100 00:09:00.800 ⇒ 00:09:03.480 Amber Lin: I mean, for the basic ones.
101 00:09:04.280 ⇒ 00:09:18.140 Amber Lin: Could I see a I mean, it’s part of building your new dashboard. Just to have the total calls right? Is, is there a way that you can just put the total calls on there so I can show the screenshot to tomorrow to when I present
102 00:09:18.250 ⇒ 00:09:21.319 Amber Lin: like, I know you still have to do the joins, but I don’t think you need
103 00:09:22.010 ⇒ 00:09:32.370 Amber Lin: showing the total calls. Probably don’t don’t require any joins like this. This is what requires stuff to join. I don’t know if that makes sense.
104 00:09:35.070 ⇒ 00:09:40.130 Amber Lin: Just like something very, very basic, based on what you have like, just for me to show.
105 00:09:40.130 ⇒ 00:09:47.369 Annie Yu: Okay, so prior prioritize, showing something in the new dashboard over the the join right.
106 00:09:47.830 ⇒ 00:09:56.899 Amber Lin: Yeah, cause ideally. If you, if you help me, show them something, I think it will buy us another week, so that Lou can help you.
107 00:09:57.280 ⇒ 00:09:59.250 Amber Lin: Joins in the Dbt. Model.
108 00:10:01.060 ⇒ 00:10:04.309 Annie Yu: Okay, okay, yeah, that, yeah, I can do that.
109 00:10:04.310 ⇒ 00:10:07.489 Amber Lin: Yeah, I think that will make the future stuff easier.
110 00:10:07.980 ⇒ 00:10:08.710 Amber Lin: Sorry?
111 00:10:09.250 ⇒ 00:10:10.679 Annie Yu: We want this by today.
112 00:10:12.069 ⇒ 00:10:14.149 Amber Lin: Tomorrow morning.
113 00:10:14.420 ⇒ 00:10:14.810 Annie Yu: Okay.
114 00:10:16.560 ⇒ 00:10:20.860 Amber Lin: Yeah. But we don’t have to remember the whole thing right? So just something.
115 00:10:20.860 ⇒ 00:10:21.889 Amber Lin: Yeah, it just works.
116 00:10:21.890 ⇒ 00:10:22.680 Annie Yu: One thing I just want.
117 00:10:22.680 ⇒ 00:10:31.610 Amber Lin: Show like, Hey, we got the data from 8 by 8, like I was like, we’re we’re on track. My meetings at 12. So before 12 is fine.
118 00:10:32.300 ⇒ 00:10:45.060 Annie Yu: Okay, I’ll try to. I’ll I’ll try to at least share something by today. I guess. One question, though, is that because usually I put someone as the reviewer, even for the dashboard.
119 00:10:45.650 ⇒ 00:10:49.720 Amber Lin: Oh, I can. I think I can review the dashboards if you if you need.
120 00:10:49.820 ⇒ 00:10:54.080 Amber Lin: I don’t know if I can help review the code, but I can review what it looks like.
121 00:10:54.450 ⇒ 00:10:56.540 Annie Yu: Yeah, yeah. And I’ll take a screenshot.
122 00:10:57.060 ⇒ 00:10:57.790 Amber Lin: Okay.
123 00:10:58.350 ⇒ 00:11:02.233 Amber Lin: Awesome so that’s that.
124 00:11:03.480 ⇒ 00:11:05.950 Amber Lin: Luke, can we close this one out?
125 00:11:08.520 ⇒ 00:11:11.569 Amber Lin: If Annie takes a look at it, then we can close.
126 00:11:11.860 ⇒ 00:11:12.230 Luke Daque: The.
127 00:11:12.230 ⇒ 00:11:13.799 Amber Lin: 5, 31 out.
128 00:11:14.030 ⇒ 00:11:14.770 Luke Daque: Yeah.
129 00:11:15.170 ⇒ 00:11:18.780 Amber Lin: Okay, Annie, have you got a chance to look at it yet?
130 00:11:20.625 ⇒ 00:11:20.990 Annie Yu: Wait.
131 00:11:20.990 ⇒ 00:11:21.810 Luke Daque: That’s what.
132 00:11:22.120 ⇒ 00:11:23.120 Luke Daque: And you mentioned.
133 00:11:23.120 ⇒ 00:11:24.430 Amber Lin: The Timestamps.
134 00:11:24.970 ⇒ 00:11:27.409 Amber Lin: Oh, okay, see it yet. So yeah, I’ll have to.
135 00:11:27.410 ⇒ 00:11:27.800 Amber Lin: I see.
136 00:11:27.800 ⇒ 00:11:30.240 Luke Daque: Got 3 s. 3 and stuff like that. So new.
137 00:11:30.240 ⇒ 00:11:38.730 Amber Lin: Okay, yeah. And then when you get time we said, we’re gonna set up Dbt, for ABC.
138 00:11:38.730 ⇒ 00:11:39.090 Luke Daque: Yeah.
139 00:11:39.090 ⇒ 00:11:39.890 Amber Lin: A.
140 00:11:39.890 ⇒ 00:11:40.290 Luke Daque: I haven’t.
141 00:11:40.290 ⇒ 00:11:40.860 Amber Lin: I’m sorry.
142 00:11:40.860 ⇒ 00:11:43.940 Luke Daque: Did on that. Yet. You said like, I was actually working on 2 parts.
143 00:11:43.940 ⇒ 00:11:49.119 Amber Lin: Yeah, that’s that’s okay, is it? Still, it’s still 3 points, right? Is it 2 or 3.
144 00:11:50.430 ⇒ 00:11:52.850 Luke Daque: What did I put the 3? I think, yeah.
145 00:11:53.270 ⇒ 00:12:01.660 Amber Lin: Okay, sounds good. So we’ll we’ll aim to have it by Friday. We it’s not like for today. I know you had other work, too. Okay.
146 00:12:02.089 ⇒ 00:12:07.130 Amber Lin: I’ll stay on with Casey for a bit to talk about the processing time. Thank you all for joining the stand up.
147 00:12:07.570 ⇒ 00:12:07.910 Luke Daque: Field.
148 00:12:07.910 ⇒ 00:12:13.410 Luke Daque: One more thing, guys, before I I go. I’ll just fyi. I’ll be away
149 00:12:14.292 ⇒ 00:12:18.540 Luke Daque: on Friday, because I’ll be flying to the Us. So.
150 00:12:18.810 ⇒ 00:12:20.500 Amber Lin: Oh, okay, wait.
151 00:12:21.700 ⇒ 00:12:22.919 Amber Lin: Where are you going?
152 00:12:23.560 ⇒ 00:12:25.839 Luke Daque: I’ll be in.
153 00:12:26.480 ⇒ 00:12:30.739 Luke Daque: Well, I’ll I’ll land at Dallas, and I’ll be like having a land.
154 00:12:30.740 ⇒ 00:12:31.110 Amber Lin: Why?
155 00:12:31.110 ⇒ 00:12:35.769 Luke Daque: In New York, so I guess I don’t know any. Where are you at, Annie, or like.
156 00:12:35.770 ⇒ 00:12:37.630 Annie Yu: I’m in Portland, Oregon.
157 00:12:37.780 ⇒ 00:12:38.470 Luke Daque: Oh! If.
158 00:12:38.470 ⇒ 00:12:43.760 Amber Lin: If you’re landing in Dallas, Utam is in Austin, you guys should totally meet up.
159 00:12:43.760 ⇒ 00:12:48.210 Luke Daque: I’m not sure if we can meet, though, because, like.
160 00:12:49.370 ⇒ 00:12:50.170 Amber Lin: Come on!
161 00:12:50.170 ⇒ 00:12:53.229 Annie Yu: Dallas again. I think I missed that.
162 00:12:53.720 ⇒ 00:12:54.919 Luke Daque: What? What was that?
163 00:12:54.920 ⇒ 00:12:57.520 Annie Yu: Where? Where are you going from? From Dallas?
164 00:12:58.755 ⇒ 00:13:04.020 Luke Daque: Through Atlanta, I believe, and then we’ll be doing a land trip to New York.
165 00:13:04.740 ⇒ 00:13:10.170 Amber Lin: Well, Robert’s in New York that’s so cool.
166 00:13:10.860 ⇒ 00:13:15.689 Luke Daque: I’ll check my schedule and I’ll let you guys know how about you? Where are you, or and and.
167 00:13:15.690 ⇒ 00:13:20.804 Amber Lin: I’m in. I’m in Los Angeles, so I’m very far from where you’re going.
168 00:13:21.660 ⇒ 00:13:24.559 Annie Yu: So how long in total are you gonna be?
169 00:13:24.780 ⇒ 00:13:26.129 Annie Yu: Wait! What.
170 00:13:26.920 ⇒ 00:13:29.930 Luke Daque: Portland is. That’s West coast right.
171 00:13:30.500 ⇒ 00:13:33.579 Annie Yu: Yeah, that’s in the north of California.
172 00:13:33.580 ⇒ 00:13:35.821 Luke Daque: Yeah, I might be there.
173 00:13:36.520 ⇒ 00:13:38.839 Luke Daque: The 1st week of August, Portland.
174 00:13:38.840 ⇒ 00:13:40.369 Annie Yu: Hey? For real? Are you doing like.
175 00:13:40.370 ⇒ 00:13:41.370 Amber Lin: What?
176 00:13:41.370 ⇒ 00:13:43.089 Luke Daque: What what I’ve been in.
177 00:13:43.090 ⇒ 00:13:56.400 Amber Lin: Wait. So you’re flying here, and then you go all the way to I don’t know even where Atlanta is. You’re going to Atlanta, and you’re going all the way up to New York, and then you’re flying across the country to Portland.
178 00:13:56.400 ⇒ 00:13:57.679 Luke Daque: Wait! Is that.
179 00:13:57.850 ⇒ 00:14:01.799 Annie Yu: Are you flying flying to Portland from New York, or.
180 00:14:01.800 ⇒ 00:14:04.150 Amber Lin: Or is this like the Portland on the east coast.
181 00:14:04.150 ⇒ 00:14:07.659 Luke Daque: It’s the the Oregon one, so I’ll be there.
182 00:14:07.660 ⇒ 00:14:13.780 Amber Lin: Oh, in Portland in the 1st week of August, so maybe thick.
183 00:14:13.970 ⇒ 00:14:19.369 Annie Yu: What happened are you? Are you coming with your family, friends?
184 00:14:19.670 ⇒ 00:14:22.330 Luke Daque: Yeah, it’s my family, basically.
185 00:14:23.130 ⇒ 00:14:29.200 Amber Lin: Oh, okay, 1st week of August. I’ll see if I can go, Dallas, I think.
186 00:14:29.760 ⇒ 00:14:33.419 Amber Lin: I think, yeah, all this Putham’s here.
187 00:14:33.740 ⇒ 00:14:38.339 Amber Lin: He’s in Austin, you’re you’re in. You’re gonna be in Dallas. Okay?
188 00:14:38.340 ⇒ 00:14:39.430 Luke Daque: Before, but.
189 00:14:39.430 ⇒ 00:14:42.693 Amber Lin: Okay. If he wants to drive, he can drive up there.
190 00:14:42.990 ⇒ 00:14:47.620 Luke Daque: I’ll check, because I think Dallas is just. I’ll I’ll just be there for a layover, because I’ll be.
191 00:14:47.996 ⇒ 00:14:48.750 Amber Lin: I see!
192 00:14:48.750 ⇒ 00:14:49.260 Luke Daque: Yeah.
193 00:14:49.260 ⇒ 00:14:50.560 Amber Lin: Okay. Valid.
194 00:14:51.076 ⇒ 00:14:56.243 Annie Yu: That’s another excuse to get the team over to Portland.
195 00:14:56.760 ⇒ 00:14:59.339 Amber Lin: I wouldn’t mind, I would not mind.
196 00:14:59.720 ⇒ 00:15:00.480 Luke Daque: Go ahead!
197 00:15:01.910 ⇒ 00:15:02.380 Amber Lin: Okay.
198 00:15:02.380 ⇒ 00:15:10.889 Luke Daque: So so Friday, I’ll be off, and maybe Monday and Tuesday. But yeah, I can still like log on log in log in
199 00:15:11.540 ⇒ 00:15:17.625 Amber Lin: Okay, yeah, I I set the due date for the Dbt to tomorrow. So that, like, you’re free, Friday.
200 00:15:18.604 ⇒ 00:15:22.150 Amber Lin: and then next week, we’ll do the joints and stuff.
201 00:15:22.520 ⇒ 00:15:23.429 Luke Daque: Sounds good.
202 00:15:23.610 ⇒ 00:15:25.269 Amber Lin: Okay, thanks. You, too.
203 00:15:25.710 ⇒ 00:15:31.959 Annie Yu: I’m sorry. One more. One more question when you say, Do the joint wait. So is it?
204 00:15:32.270 ⇒ 00:15:37.430 Annie Yu: Is it gonna be, Luke to do the join going forward, or I I guess I just am not sure.
205 00:15:37.765 ⇒ 00:16:00.230 Amber Lin: Yeah. So my goal, I think it’s best that we set up the logic and Dvt, I know. Currently, you have it in real. I think Luke can help you set it up in Dbt, so that I think it’s a better way to do these things, because we might have more logic in the future, and it’s just easier if it’s in Dbt. To manage.
206 00:16:00.740 ⇒ 00:16:07.856 Annie Yu: Yeah, that makes sense. And I can still do like a very scrappy version within real. And then Luke will do the.
207 00:16:08.510 ⇒ 00:16:09.350 Luke Daque: Yeah, so
208 00:16:09.630 ⇒ 00:16:18.369 Luke Daque: like, like, the Dv thing might not be a very high priority, just like we can always do it in real. For now, and this just move it to to. DVD,
209 00:16:18.370 ⇒ 00:16:19.440 Luke Daque: okay, okay.
210 00:16:20.330 ⇒ 00:16:27.910 Annie Yu: Okay, sounds good. So any you might end up doing a scrappy version early next week if Lucas on his vacation.
211 00:16:28.330 ⇒ 00:16:34.330 Annie Yu: Yeah, that’s fine as long as there’s look to review and refine. I think that that’s fine.
212 00:16:34.710 ⇒ 00:16:36.480 Amber Lin: Okay. Sounds great.
213 00:16:37.900 ⇒ 00:16:43.020 Amber Lin: Thanks you, too. I’ll talk with Casey about remaining stuff.
214 00:16:43.370 ⇒ 00:16:44.120 Annie Yu: Sounds good.
215 00:16:44.120 ⇒ 00:16:45.540 Luke Daque: Okay.
216 00:16:45.640 ⇒ 00:16:46.150 Amber Lin: Bye.
217 00:16:46.150 ⇒ 00:16:46.680 Annie Yu: Okay.
218 00:16:48.830 ⇒ 00:16:57.630 Amber Lin: Casey, what are we gonna do for the response time? It is getting longer. I can feel it every time like, why is there no answer. Why is there no answer? It’s like, Oh, it’s taking so long.
219 00:16:57.990 ⇒ 00:17:05.910 Casie Aviles: Yeah, I think it’s, is it also because we’re adding stuff into the central dock like all that? Like, yeah, continuously.
220 00:17:06.630 ⇒ 00:17:16.442 Amber Lin: Yeah, the central doc is still probably the same length, like, relatively to when we started, because 70 pages and 80 pages doesn’t change that much
221 00:17:17.954 ⇒ 00:17:24.400 Amber Lin: but like I don’t, I don’t exactly know what’s making it so slow.
222 00:17:24.839 ⇒ 00:17:28.029 Casie Aviles: I’ll take care of investigating that.
223 00:17:28.490 ⇒ 00:17:34.200 Amber Lin: Do you think it makes it slower because we’re also adding all the
224 00:17:35.110 ⇒ 00:17:40.039 Amber Lin: spreadsheets? Is that why, or are they like separate routes? When people.
225 00:17:40.398 ⇒ 00:17:42.190 Casie Aviles: They’re separate. Yes, they’re separate.
226 00:17:42.190 ⇒ 00:17:45.459 Amber Lin: Oh, so it’s the central doc that’s taking forever.
227 00:17:45.780 ⇒ 00:18:05.620 Casie Aviles: Yes, I noticed. I tried asking yeah, for the past inspectors. It’s it sends the message around less than 10 seconds. But with Central Doc it takes more around sometimes even a minute now. So I’m just concerned. So yeah, I really, I need.
228 00:18:05.620 ⇒ 00:18:06.360 Amber Lin: Yeah.
229 00:18:06.360 ⇒ 00:18:11.549 Casie Aviles: Check this out, and I’m considering like if it if we can’t do anything
230 00:18:12.721 ⇒ 00:18:14.380 Casie Aviles: in terms of you know
231 00:18:14.960 ⇒ 00:18:21.460 Casie Aviles: the prompt or the the routing we might have to do rug. But yeah, that’s just a consideration, for now.
232 00:18:21.460 ⇒ 00:18:29.989 Amber Lin: Hmm, yeah. How was do we ever try rag on the central dock?
233 00:18:31.347 ⇒ 00:18:37.890 Casie Aviles: No, no, not really. I don’t think we did like a full rag on the central dock, so we might have to
234 00:18:38.300 ⇒ 00:18:43.399 Casie Aviles: do that I’m just getting, you know, because it might help with
235 00:18:44.502 ⇒ 00:18:47.520 Casie Aviles: What do you call this? With lessening the response times since we’re just.
236 00:18:47.980 ⇒ 00:18:51.540 Casie Aviles: Getting chunks of the central dock instead of loading every.
237 00:18:51.540 ⇒ 00:18:52.180 Amber Lin: Hmm!
238 00:18:53.190 ⇒ 00:18:58.733 Amber Lin: I see. I know Mustafa did somewhat of a rag for Central Doll, because I asked him
239 00:18:59.400 ⇒ 00:19:04.370 Amber Lin: as let me show you here, so I
240 00:19:04.620 ⇒ 00:19:18.509 Amber Lin: asked if he can help say, Retrieve where it is in the Central Doc. So I think he did do somewhat of a quick rag. If you need to check with him, we can check the response. Time
241 00:19:19.380 ⇒ 00:19:20.060 Casie Aviles: I see.
242 00:19:21.210 ⇒ 00:19:23.040 Amber Lin: It arrived.
243 00:19:23.700 ⇒ 00:19:28.110 Amber Lin: Oh, for a central Doc can check
244 00:19:29.100 ⇒ 00:19:34.740 Amber Lin: response time. And then, in terms of routing like.
245 00:19:35.080 ⇒ 00:19:44.970 Amber Lin: I think there is a possibility to route. Say, if it’s billing because billing takes billing, probably takes up a big chunk
246 00:19:45.750 ⇒ 00:19:48.819 Amber Lin: like that could be that could get routed.
247 00:19:49.879 ⇒ 00:19:50.939 Amber Lin: And then.
248 00:19:50.940 ⇒ 00:19:52.790 Casie Aviles: I see. Yeah, that’s that’s a good.
249 00:19:52.790 ⇒ 00:19:54.529 Amber Lin: Schedule? Yeah.
250 00:19:54.530 ⇒ 00:19:55.706 Casie Aviles: We could do that.
251 00:19:57.770 ⇒ 00:20:01.749 Amber Lin: Let me check how many pages billing is.
252 00:20:02.010 ⇒ 00:20:03.300 Amber Lin: So that’s
253 00:20:06.640 ⇒ 00:20:09.100 Amber Lin: so, that’s from
254 00:20:16.140 ⇒ 00:20:19.009 Amber Lin: okay. And it’s gonna grow. So I think
255 00:20:19.240 ⇒ 00:20:28.460 Amber Lin: because they’re adding these, all these processes probably should take billing out to a different like routing procedure.
256 00:20:30.200 ⇒ 00:20:30.980 Casie Aviles: Yeah.
257 00:20:38.860 ⇒ 00:20:39.510 Amber Lin: Okay.
258 00:20:40.020 ⇒ 00:20:52.789 Amber Lin: yeah. And then in this, you know, currently, I wanna update you, currently, we’re discussing with another department so mechanical to include their documents. So we’re only gonna get more and.
259 00:20:52.790 ⇒ 00:20:53.490 Casie Aviles: I see? Yeah.
260 00:20:53.490 ⇒ 00:21:12.799 Amber Lin: What they wanted to do is they wanted to use the same Andy and then route differently. So we will have to figure out how we’re gonna do routing and how to do it. Well, because we’re gonna either route to pest or route to mechanical and we probably need a need, a spike to do that.
261 00:21:13.640 ⇒ 00:21:17.159 Casie Aviles: Yeah, I see. I see. Yeah, we’re we’re getting more documents now.
262 00:21:17.600 ⇒ 00:21:27.089 Amber Lin: Yeah, we’re gonna get a lot like at least another central doc like this, like I can work on cutting it down. But like technically, we need to figure out how to
263 00:21:27.470 ⇒ 00:21:28.890 Amber Lin: out of route.
264 00:21:32.140 ⇒ 00:21:35.749 Amber Lin: Do you think I think this is a pretty important one?
265 00:21:39.090 ⇒ 00:21:53.089 Amber Lin: Route Central Doc? Questions like. I guess we can have separate docs or routes, 2 different sections.
266 00:21:53.260 ⇒ 00:21:54.189 Amber Lin: I don’t know.
267 00:21:56.400 ⇒ 00:21:57.070 Casie Aviles: Okay.
268 00:21:58.050 ⇒ 00:22:02.579 Amber Lin: Yeah, we’ll probably. Do you think this is a discussion? We should involve Utam in.
269 00:22:06.110 ⇒ 00:22:10.219 Casie Aviles: I mean, yeah, I think it it would. It would be fine. But
270 00:22:10.330 ⇒ 00:22:15.100 Casie Aviles: I can do like a an initial spike first, st so we don’t just ask
271 00:22:16.010 ⇒ 00:22:16.550 Amber Lin: Okay.
272 00:22:16.960 ⇒ 00:22:19.329 Casie Aviles: With, yeah, without prior research.
273 00:22:20.060 ⇒ 00:22:27.450 Amber Lin: Okay, yeah, I I like that. So we’ll put it here, create the issue.
274 00:22:28.280 ⇒ 00:22:42.840 Amber Lin: Think, response time or central Doc, questions, test response, time for routing versus frag, because
275 00:22:42.960 ⇒ 00:22:45.980 Amber Lin: there’s I don’t think we can reduce it much.
276 00:22:48.620 ⇒ 00:22:54.680 Amber Lin: And then service error spreadsheets routing.
277 00:22:55.790 ⇒ 00:22:58.029 Amber Lin: Oh, sorry which? What?
278 00:22:58.750 ⇒ 00:23:05.449 Amber Lin: Oh, I added this, I think because just right now.
279 00:23:07.900 ⇒ 00:23:13.019 Amber Lin: sometimes it still doesn’t route correctly. If I’m not mistaken.
280 00:23:13.586 ⇒ 00:23:20.470 Amber Lin: I was just checking. We were checking the feedback on one day, and
281 00:23:22.010 ⇒ 00:23:25.130 Amber Lin: I think I tried to test it.
282 00:23:25.300 ⇒ 00:23:34.300 Amber Lin: I think it still got it wrong. Let me just check here if I can replicate a situation
283 00:23:34.530 ⇒ 00:23:37.589 Amber Lin: like, how do we handle routing to these different
284 00:23:38.070 ⇒ 00:23:44.060 Amber Lin: different sheets? I guess right now it’s just technicians and inspectors. How do we handle the routing for that.
285 00:23:44.820 ⇒ 00:23:49.299 Casie Aviles: What I did was I just prompted the. So we have like 2 workflows.
286 00:23:49.440 ⇒ 00:23:55.180 Casie Aviles: We have one that draws from the tech, the yeah, the technicians.
287 00:23:55.440 ⇒ 00:24:00.250 Casie Aviles: And we have another that draws from inspectors.
288 00:24:03.030 ⇒ 00:24:06.970 Casie Aviles: And yeah, and what I did is it’s primarily prompting.
289 00:24:07.190 ⇒ 00:24:09.150 Casie Aviles: No, it’s not responding now.
290 00:24:09.150 ⇒ 00:24:10.540 Amber Lin: Oh, no!
291 00:24:10.700 ⇒ 00:24:14.150 Amber Lin: Oh, no! Is it because the Lm. Is down?
292 00:24:16.180 ⇒ 00:24:23.050 Casie Aviles: Yeah, yeah, I’m not sure right now. But yeah, I’ll check. I’ll I’ll I’ll spend some more time here.
293 00:24:23.050 ⇒ 00:24:23.450 Amber Lin: Okay.
294 00:24:23.791 ⇒ 00:24:29.930 Casie Aviles: But yeah, going back with how I do, how I roush it’s just a prompt
295 00:24:30.759 ⇒ 00:24:37.970 Casie Aviles: so I I told I I instructed Andy like. If it’s base. If it’s asking for technicians, then
296 00:24:38.170 ⇒ 00:24:46.059 Casie Aviles: go to the technician Doc or spreadsheet, and if not, if it’s about inspectors, then go there
297 00:24:46.820 ⇒ 00:24:48.630 Casie Aviles: something like that, and.
298 00:24:48.730 ⇒ 00:25:02.400 Amber Lin: Okay, yeah, I think the only thing we can do is to like improve the prompting. If more issues come up. I’ll ask them for, like common aliases
299 00:25:02.520 ⇒ 00:25:14.540 Amber Lin: for technicians. This is for inspectors. I think I sent this a while ago. It’s like bids. Estimates like the these are like.
300 00:25:14.970 ⇒ 00:25:18.979 Amber Lin: Inspector goes to like Inspector Sheet.
301 00:25:19.290 ⇒ 00:25:33.299 Amber Lin: And then for technicians like like service, I need to check if maintenance included, I can check on what’s what’s included. But I think as long as instructor and technician are routed correctly, we should be good.
302 00:25:35.210 ⇒ 00:25:37.859 Amber Lin: Let’s say this is 1 point.
303 00:25:38.340 ⇒ 00:25:39.770 Amber Lin: I’ll say medium.
304 00:25:40.070 ⇒ 00:25:50.170 Amber Lin: Okay, back here, and then like, next week.
305 00:25:51.060 ⇒ 00:25:56.659 Amber Lin: next week, we can do this. Okay, I think that’s all. I’ll probably ask Utam for
306 00:25:56.880 ⇒ 00:26:05.885 Amber Lin: a meeting to do the routing questions. I would say that that would be nice to have
307 00:26:08.750 ⇒ 00:26:11.059 Amber Lin: because we want to discuss this week
308 00:26:11.260 ⇒ 00:26:14.069 Amber Lin: probably want to discuss Thursday, so
309 00:26:14.260 ⇒ 00:26:21.990 Amber Lin: I’ll I’ll set it for tomorrow. I’ll ask Utam when he can meet, and ideally we can get it done before get this done before we talk to Utam.
310 00:26:22.670 ⇒ 00:26:23.819 Casie Aviles: Okay. Sure. Sure.
311 00:26:23.950 ⇒ 00:26:25.590 Amber Lin: Okay, thank you.
312 00:26:25.730 ⇒ 00:26:28.850 Amber Lin: And then the Andy problem.
313 00:26:28.950 ⇒ 00:26:33.410 Amber Lin: Oh, wait it! It just responded. It said it didn’t respond. And now it responded.
314 00:26:33.980 ⇒ 00:26:38.149 Casie Aviles: Yeah, it just takes a long time when it takes a long time. It says it’s not responding.
315 00:26:38.680 ⇒ 00:26:45.560 Amber Lin: Oh, okay, okay. Then we need to look at the why did it suddenly get so slow?
316 00:26:46.530 ⇒ 00:26:47.700 Casie Aviles: Yeah, it’s okay.
317 00:26:47.700 ⇒ 00:26:59.910 Amber Lin: Yeah. Okay, okay, need to note that down response time are getting slow.
318 00:27:00.200 ⇒ 00:27:05.920 Casie Aviles: I’m not sure if it’s the models, or like I did add a few lines of But
319 00:27:06.510 ⇒ 00:27:09.010 Casie Aviles: I don’t know. I’m not sure why that would.
320 00:27:09.210 ⇒ 00:27:12.389 Casie Aviles: I wouldn’t think that that would result longer. But.
321 00:27:12.980 ⇒ 00:27:14.130 Amber Lin: Okay, I’ll have to check.
322 00:27:14.770 ⇒ 00:27:18.720 Amber Lin: Okay, let me know how it goes. Probably we need to look at that one as well.
323 00:27:19.317 ⇒ 00:27:31.429 Amber Lin: Cause they will come to us and like it’s so slow like there’s not, it’s not responding, and he’s down. Then, like we’ll have trouble. So, thanks for taking a look at that.
324 00:27:31.680 ⇒ 00:27:32.860 Casie Aviles: Okay. Sure. Sure. Sure.
325 00:27:33.730 ⇒ 00:27:36.160 Amber Lin: Alright. Okay. I gotta hop to another meeting.
326 00:27:36.340 ⇒ 00:27:39.379 Casie Aviles: Thanks, Amber, I’ll thank you.
327 00:27:39.950 ⇒ 00:27:41.820 Amber Lin: Alright! Thanks! Talk to you tomorrow.