Meeting Title: Looker planning Date: 2025-11-05 Meeting participants: Awaish Kumar, Emily Giant
WEBVTT
1 00:02:35.290 ⇒ 00:02:41.830 Emily Giant: Hello. Sorry, I was on with Demolade doing revenue stuff, so I was running a little late.
2 00:02:42.880 ⇒ 00:02:45.529 Awaish Kumar: How are you?
3 00:02:46.120 ⇒ 00:02:47.700 Awaish Kumar: I’m good, how about you?
4 00:02:48.040 ⇒ 00:02:52.549 Emily Giant: Oh, I’m good, I’m good. Just… busy. Busy, busy.
5 00:02:53.190 ⇒ 00:02:55.919 Emily Giant: You got the Aurora Borealis, that’s pretty.
6 00:02:58.150 ⇒ 00:03:00.410 Emily Giant: Alright, Looker.
7 00:03:01.640 ⇒ 00:03:03.510 Emily Giant: Where would you like to start?
8 00:03:04.810 ⇒ 00:03:11.660 Awaish Kumar: Yeah, I just want to discuss the plan for migration.
9 00:03:12.020 ⇒ 00:03:15.700 Awaish Kumar: I… like, I want to…
10 00:03:16.560 ⇒ 00:03:22.950 Awaish Kumar: Basically, just come up with some execution plans so we can… Start executing.
11 00:03:24.870 ⇒ 00:03:30.070 Awaish Kumar: So, one other thing I shared with you was a Google Sheets talk.
12 00:03:30.180 ⇒ 00:03:34.700 Awaish Kumar: I’m not sure if that, like, I joined late, so I’m not… I’m not sure if…
13 00:03:34.830 ⇒ 00:03:38.190 Awaish Kumar: That is… does not contain any
14 00:03:38.340 ⇒ 00:03:44.129 Awaish Kumar: archive dashes, or you already maybe worked on Looker Dashboards, and
15 00:03:44.850 ⇒ 00:03:50.699 Awaish Kumar: If, if all… all the dashboards are there, or the… I hope so.
16 00:03:50.880 ⇒ 00:03:54.989 Awaish Kumar: So instead of reinventing the wheel.
17 00:03:56.170 ⇒ 00:04:03.030 Awaish Kumar: Like, creating this kind of view of myself again, and going through one dash by dash.
18 00:04:03.150 ⇒ 00:04:15.429 Awaish Kumar: Well, I want to… what I want to do is that, like, maybe if we could use… I will, like, maybe you can verify, that if… if those dashboards are the ones which are still active, or are the…
19 00:04:15.880 ⇒ 00:04:17.110 Awaish Kumar: in dashboards.
20 00:04:17.320 ⇒ 00:04:18.430 Awaish Kumar: Hmm.
21 00:04:18.990 ⇒ 00:04:23.349 Awaish Kumar: then we can basically… what I can do is, for all those dashboards.
22 00:04:23.570 ⇒ 00:04:28.369 Awaish Kumar: I figured out that maybe there are a lot, like, more than 900 dashboards in the Google Sheet.
23 00:04:28.790 ⇒ 00:04:29.710 Awaish Kumar: Given…
24 00:04:30.090 ⇒ 00:04:30.710 Emily Giant: Yep.
25 00:04:30.890 ⇒ 00:04:35.809 Awaish Kumar: Only there are only, like, around 48 explorers which are feeding the data.
26 00:04:36.660 ⇒ 00:04:37.620 Awaish Kumar: dashboards.
27 00:04:38.900 ⇒ 00:04:41.370 Awaish Kumar: But my point is, maybe there are…
28 00:04:41.510 ⇒ 00:04:47.370 Awaish Kumar: Quite a few, dashboards, which are not being used.
29 00:04:48.600 ⇒ 00:04:54.910 Awaish Kumar: I… I’m pretty sure that… There is a good chunk of those are not being used.
30 00:04:55.200 ⇒ 00:05:05.429 Emily Giant: Yeah, definitely. Did you check through the other dashboard audit that Kayo did at the beginning? Because you’re going to be able to get a lot of the information from there, too.
31 00:05:05.430 ⇒ 00:05:09.019 Awaish Kumar: That’s what I… that sheet has all these things, like…
32 00:05:09.020 ⇒ 00:05:12.060 Emily Giant: Kayo and the, the one…
33 00:05:12.270 ⇒ 00:05:17.439 Awaish Kumar: For the dashboards, for,
34 00:05:17.560 ⇒ 00:05:20.580 Awaish Kumar: Explores for looks, like, they have…
35 00:05:21.360 ⇒ 00:05:29.110 Awaish Kumar: audits, so I want to come, like, one move, step, one step, I had, like,
36 00:05:29.430 ⇒ 00:05:38.020 Awaish Kumar: Ahead from there, like, And that is, like, Actually, Marking the dashboards.
37 00:05:38.150 ⇒ 00:05:40.469 Awaish Kumar: Which are… with a… with a…
38 00:05:40.720 ⇒ 00:05:45.230 Awaish Kumar: urgency, or with the importance, I would give them a flag.
39 00:05:45.420 ⇒ 00:05:46.360 Awaish Kumar: Okay.
40 00:05:46.520 ⇒ 00:05:49.420 Awaish Kumar: There are these 50 dashboards, really
41 00:05:50.600 ⇒ 00:05:56.209 Awaish Kumar: And we then come up with, like, okay, what are the…
42 00:05:56.560 ⇒ 00:06:01.920 Awaish Kumar: Models, or explores, or looks that are feeding these dashboards.
43 00:06:03.170 ⇒ 00:06:10.450 Awaish Kumar: And that will help me trim down the kind of work I’m doing, and actually give me something to work on.
44 00:06:10.670 ⇒ 00:06:12.340 Awaish Kumar: Yeah. When we…
45 00:06:13.360 ⇒ 00:06:21.899 Awaish Kumar: when we’re at that stage, I can, like, then say, okay, maybe this is explored, I need to work on from, like, to, to, like.
46 00:06:21.900 ⇒ 00:06:22.410 Emily Giant: Hmm.
47 00:06:22.610 ⇒ 00:06:25.660 Awaish Kumar: Actually support these 50 dashboards.
48 00:06:25.660 ⇒ 00:06:29.419 Emily Giant: What is basically I can replicate those explores.
49 00:06:31.430 ⇒ 00:06:38.349 Awaish Kumar: with a V2, like, version 2, and, try to change the source,
50 00:06:39.590 ⇒ 00:06:47.910 Awaish Kumar: For those dashboards from the, like, new models, and then also create a replicate of the dashboard, and then come up with the dashboard.
51 00:06:48.190 ⇒ 00:06:54.260 Awaish Kumar: And finally, like… Compare the dashboards, looks good, okay, delete this other one.
52 00:06:54.800 ⇒ 00:07:01.509 Emily Giant: Yep. Okay. So, something that we could do, right off the bat, that…
53 00:07:01.910 ⇒ 00:07:05.449 Emily Giant: Might be helpful is, filtering by the base view.
54 00:07:05.610 ⇒ 00:07:11.230 Emily Giant: Because I know which… Views they’ll be replaced with.
55 00:07:11.880 ⇒ 00:07:16.299 Emily Giant: or by the Explorer,
56 00:07:16.520 ⇒ 00:07:22.710 Emily Giant: I don’t know if that’d be helpful to you, but, like, let me share my screen quickly and show you what I mean.
57 00:07:24.770 ⇒ 00:07:25.940 Emily Giant: So…
58 00:07:26.220 ⇒ 00:07:27.219 Awaish Kumar: Where did this?
59 00:07:27.220 ⇒ 00:07:31.560 Emily Giant: down here. So, for example, Inventory XF,
60 00:07:36.820 ⇒ 00:07:39.799 Emily Giant: None of these need to be replaced.
61 00:07:39.930 ⇒ 00:07:48.489 Emily Giant: Because… there… All of our inventory is already, coming from another source now.
62 00:07:49.050 ⇒ 00:07:51.680 Emily Giant: So, these can just be deprecated.
63 00:07:53.190 ⇒ 00:08:01.079 Awaish Kumar: Like, okay, this needs to be deprecated, and like, do we have the… like, do…
64 00:08:01.870 ⇒ 00:08:07.120 Awaish Kumar: Okay, let me rephrase my words, like, are you saying we don’t need all of these dashboards? We have…
65 00:08:07.510 ⇒ 00:08:09.359 Awaish Kumar: Separate dashboards as well?
66 00:08:10.200 ⇒ 00:08:14.089 Emily Giant: For the most part. So, if I put, like, an action column here.
67 00:08:14.240 ⇒ 00:08:17.830 Emily Giant: Like, current week sales overview, we already have…
68 00:08:18.090 ⇒ 00:08:22.479 Emily Giant: we can just deprecate it. We do not need to recreate it.
69 00:08:22.970 ⇒ 00:08:26.129 Emily Giant: Because there’s already a new version of it.
70 00:08:27.540 ⇒ 00:08:31.890 Awaish Kumar: Okay, and that is coming from our new dbt model.
71 00:08:32.659 ⇒ 00:08:34.919 Emily Giant: Yep, and that one is…
72 00:08:40.039 ⇒ 00:08:40.879 Awaish Kumar: Okay, Shopify.
73 00:08:41.350 ⇒ 00:08:43.539 Emily Giant: It’s… here.
74 00:08:43.700 ⇒ 00:08:45.830 Emily Giant: The polyatomic inventory data.
75 00:08:46.730 ⇒ 00:08:49.949 Emily Giant: And everything joined, to the…
76 00:08:50.500 ⇒ 00:08:53.670 Emily Giant: inventory data. So it’s these two models.
77 00:08:53.960 ⇒ 00:08:56.290 Emily Giant: That have, essentially.
78 00:08:56.330 ⇒ 00:09:01.690 Awaish Kumar: Okay. Replaced all of inventory XF and inventory transactions XF.
79 00:09:04.170 ⇒ 00:09:08.400 Awaish Kumar: Okay, understood. What I’m trying to get here is…
80 00:09:10.520 ⇒ 00:09:12.869 Awaish Kumar: Are we still using the LookML?
81 00:09:13.240 ⇒ 00:09:15.269 Awaish Kumar: Like, formal. Yeah.
82 00:09:15.790 ⇒ 00:09:16.400 Awaish Kumar: Okay.
83 00:09:16.400 ⇒ 00:09:17.050 Emily Giant: No.
84 00:09:17.050 ⇒ 00:09:25.730 Awaish Kumar: I, like, this, like… For example, this model now referencing to the polyatomic Tables, and
85 00:09:26.080 ⇒ 00:09:29.670 Awaish Kumar: That should not be the case in an ideal situation.
86 00:09:29.870 ⇒ 00:09:35.630 Awaish Kumar: that data comes from Polytomic, debit it, does a transformation, or create an inventory mod.
87 00:09:36.530 ⇒ 00:09:39.079 Awaish Kumar: It gets referenced in the looker.
88 00:09:40.240 ⇒ 00:09:40.890 Emily Giant: Right.
89 00:09:43.210 ⇒ 00:09:44.720 Emily Giant: Yes, correct.
90 00:09:44.980 ⇒ 00:09:50.769 Emily Giant: like… These… this data doesn’t even run anymore. Like, the data feed is turned off.
91 00:09:51.010 ⇒ 00:09:54.510 Awaish Kumar: Okay, I got your point for the inventory, XF.
92 00:09:54.510 ⇒ 00:09:55.970 Emily Giant: We don’t…
93 00:09:55.970 ⇒ 00:10:00.299 Awaish Kumar: So there are, like, quite a few of… The dashboards, depending on it.
94 00:10:02.230 ⇒ 00:10:09.789 Awaish Kumar: So do you… like, if I duplicate this base view, that means all of these dashboards going to get
95 00:10:10.610 ⇒ 00:10:12.959 Awaish Kumar: Deprecated as well.
96 00:10:13.370 ⇒ 00:10:13.970 Emily Giant: Yep.
97 00:10:14.740 ⇒ 00:10:15.470 Awaish Kumar: Okay.
98 00:10:15.630 ⇒ 00:10:17.150 Awaish Kumar: And we are okay with that.
99 00:10:17.780 ⇒ 00:10:24.870 Emily Giant: Yep. They… they don’t work anymore anyway, so it would be… Moot point.
100 00:10:25.080 ⇒ 00:10:31.230 Emily Giant: to not deprecate them. The only one… the only thing I would add is that, like, ideally…
101 00:10:31.820 ⇒ 00:10:33.830 Emily Giant: A new version of this would be built.
102 00:10:36.050 ⇒ 00:10:52.170 Emily Giant: But you’ll see that this is, like, this dashboard pulls from not only inventory data, it also pulls from, like, sales data, yadda yadda yadda. But any reports in the Rolling 12, like, KPI, and I think that’s the only one that.
103 00:10:52.540 ⇒ 00:11:02.560 Awaish Kumar: Yeah, but that does not… that means, like, that we are not only replicating it, but we are basically replicate, like, replacing it with something else.
104 00:11:02.750 ⇒ 00:11:05.139 Emily Giant: Yes, but every other one of them?
105 00:11:05.470 ⇒ 00:11:08.800 Emily Giant: Deprecate, because they’ve already been rebuilt. Rebuilt.
106 00:11:09.540 ⇒ 00:11:11.410 Awaish Kumar: Okay, so only this one.
107 00:11:14.130 ⇒ 00:11:14.910 Awaish Kumar: Okay.
108 00:11:15.550 ⇒ 00:11:19.350 Awaish Kumar: Maybe we can have different wording for that. Replace?
109 00:11:19.640 ⇒ 00:11:21.519 Awaish Kumar: Maybe you can call it replace.
110 00:11:22.390 ⇒ 00:11:24.440 Emily Giant: Yes, blanket. Replace.
111 00:11:24.440 ⇒ 00:11:25.390 Awaish Kumar: Yep.
112 00:11:27.380 ⇒ 00:11:32.930 Emily Giant: Alright, and then I can do the same thing, like a big… This one.
113 00:11:34.650 ⇒ 00:11:35.510 Awaish Kumar: Okay.
114 00:11:36.300 ⇒ 00:11:40.750 Emily Giant: And we can say… Spread stitched out, these have all been replaced.
115 00:11:46.630 ⇒ 00:11:47.330 Awaish Kumar: Okay.
116 00:11:47.650 ⇒ 00:11:49.210 Emily Giant: None of them need to be replaced.
117 00:11:50.500 ⇒ 00:11:56.590 Awaish Kumar: And replicate, like, in the looker, is there option to archive them, or we need to delete?
118 00:11:58.310 ⇒ 00:12:03.670 Emily Giant: Okay, so… with Looker,
119 00:12:05.590 ⇒ 00:12:18.889 Emily Giant: If you delete or archive any of these, you’re gonna get so many errors that it will make your life impossible. So I guess what you were saying about building a new model.
120 00:12:20.640 ⇒ 00:12:23.029 Awaish Kumar: And only having the dashboards.
121 00:12:23.330 ⇒ 00:12:29.510 Emily Giant: That we’re gonna use based on that model, would… Probably be a good idea.
122 00:12:29.960 ⇒ 00:12:34.640 Emily Giant: So… For example.
123 00:12:34.710 ⇒ 00:12:35.619 Awaish Kumar: Sorry, go ahead.
124 00:12:35.780 ⇒ 00:12:44.269 Awaish Kumar: My point is, like, I see, like, now, if I open a dashboard list, I see 900 dashboards in Looker.
125 00:12:44.610 ⇒ 00:12:50.769 Awaish Kumar: maybe 200 of them, we just mark them as deprecated. We don’t need it anymore.
126 00:12:50.870 ⇒ 00:12:56.309 Awaish Kumar: Why to, like, keep them and look at night? Is there no way to, like, clean this up?
127 00:12:56.310 ⇒ 00:13:01.629 Emily Giant: Oh, no, you can do that. That’s fine. I was thinking… I’m sorry, I was talking about the Explore.
128 00:13:03.160 ⇒ 00:13:04.890 Emily Giant: Yeah, I… No, these you can just.
129 00:13:04.890 ⇒ 00:13:06.040 Awaish Kumar: We’ll explore, because…
130 00:13:06.440 ⇒ 00:13:13.669 Awaish Kumar: Then it will be… wherever it is being used, it will, like, give the errors all over the place.
131 00:13:14.220 ⇒ 00:13:21.029 Awaish Kumar: So, what I’m thinking of is, now I want to understand the usage of the Looker.
132 00:13:21.900 ⇒ 00:13:29.730 Awaish Kumar: So, mainly the BI tools are being used for Creating dashboards,
133 00:13:29.910 ⇒ 00:13:32.989 Awaish Kumar: And, all the execs, or…
134 00:13:33.160 ⇒ 00:13:36.489 Awaish Kumar: Different teams are consuming only the dashboards.
135 00:13:36.780 ⇒ 00:13:37.100 Awaish Kumar: For sure.
136 00:13:37.570 ⇒ 00:13:40.260 Awaish Kumar: All the teams consuming dashboards.
137 00:13:40.810 ⇒ 00:13:54.240 Awaish Kumar: Only the developers, like you, me, or someone else, like, we are the ones, we are… we are responsible for creating explores, models, views, flow, and building a dashboard.
138 00:13:54.600 ⇒ 00:13:57.289 Awaish Kumar: Just me and PK are the only ones.
139 00:13:58.280 ⇒ 00:14:11.020 Awaish Kumar: Okay, that means that, we are, like, if I identify… if we come up… if we go from the dashboards, because these are the main,
140 00:14:11.140 ⇒ 00:14:15.030 Awaish Kumar: Like, the end product, which are being used by big people.
141 00:14:15.920 ⇒ 00:14:17.479 Awaish Kumar: Start from dashboards.
142 00:14:17.600 ⇒ 00:14:23.819 Awaish Kumar: If I, like, filter out this list of deprecated, and we are… we then maybe
143 00:14:24.120 ⇒ 00:14:39.260 Awaish Kumar: also try to give them a flag, as I mentioned initially, that, okay, like, as you said, like, revenue marks are really, really the important, like, urgent thing, maybe. We can, like, let’s mark them as,
144 00:14:40.340 ⇒ 00:14:47.010 Awaish Kumar: P0, right? Maybe there are 50 revenue dashboards or something like that.
145 00:14:47.410 ⇒ 00:14:51.600 Awaish Kumar: And then I can come up with, like, okay, how many different explodes?
146 00:14:51.830 ⇒ 00:14:55.269 Awaish Kumar: All the… it depends on, and then how…
147 00:14:56.600 ⇒ 00:15:02.930 Awaish Kumar: And how many of, like… like, Demolat LED, also, I think he was saying he has changed
148 00:15:03.240 ⇒ 00:15:11.969 Awaish Kumar: Some explorers from, from old to the new model. So we will have that changes
149 00:15:12.230 ⇒ 00:15:19.800 Awaish Kumar: So, what I will do is, I will create a copy of that Explorer, maybe, Huh?
150 00:15:19.960 ⇒ 00:15:23.139 Awaish Kumar: Again, try to change everything, not, like…
151 00:15:23.310 ⇒ 00:15:27.770 Awaish Kumar: From, like, the old, like, like.
152 00:15:28.550 ⇒ 00:15:35.395 Awaish Kumar: Models to the new model, and then we can basically… Hmm…
153 00:15:36.630 ⇒ 00:15:44.290 Awaish Kumar: Then, like, yeah, we can, like, split it between us, like, for example, you can help me with finding out
154 00:15:45.500 ⇒ 00:15:48.199 Awaish Kumar: working in Looker, for example, like.
155 00:15:48.750 ⇒ 00:15:51.340 Awaish Kumar: These are the fields which are missing, like, we…
156 00:15:51.820 ⇒ 00:16:02.670 Awaish Kumar: We can come up with, like, 50 dashes, 2 explodes, or two… one model, or two models, which might be two explodes in there, and we can say.
157 00:16:02.920 ⇒ 00:16:16.519 Awaish Kumar: basically, okay, like, you can tell me, like, okay, these are, like, 50 different fields which are not available, or I can’t find it in any new model.
158 00:16:16.670 ⇒ 00:16:23.549 Awaish Kumar: And that’s, like, I can then take that over, and then go figure out, like, if…
159 00:16:23.900 ⇒ 00:16:29.469 Awaish Kumar: If it is available anywhere in dbt models, or I need to add it from somewhere.
160 00:16:29.850 ⇒ 00:16:34.300 Awaish Kumar: Things like that. And once I, like, we check all the boxes, it’s done.
161 00:16:34.650 ⇒ 00:16:38.640 Awaish Kumar: Then you can just, like, add in the looker and the…
162 00:16:38.770 ⇒ 00:16:42.160 Awaish Kumar: Explore is ready. When a new Explorer is ready.
163 00:16:42.770 ⇒ 00:16:49.010 Awaish Kumar: I hope that it is easy to, like, duplicate the dashboard, and we don’t have.
164 00:16:49.340 ⇒ 00:16:50.900 Awaish Kumar: Create all the looks, right?
165 00:16:51.680 ⇒ 00:16:52.040 Emily Giant: Right.
166 00:16:52.040 ⇒ 00:16:57.560 Awaish Kumar: basically duplicate and change the data source from Model 1 to Model 2, and.
167 00:16:58.070 ⇒ 00:17:00.130 Awaish Kumar: will populate everything. So I think…
168 00:17:00.130 ⇒ 00:17:00.510 Emily Giant: Okay.
169 00:17:00.510 ⇒ 00:17:02.879 Awaish Kumar: That will be our execution plan.
170 00:17:04.689 ⇒ 00:17:16.139 Awaish Kumar: So, next action item for us is, like, maybe, like, in this… sheet, Mark all the…
171 00:17:16.429 ⇒ 00:17:20.409 Awaish Kumar: Revenue dashboard? Revenue-related dashboard has P0.
172 00:17:22.979 ⇒ 00:17:27.979 Awaish Kumar: And if… if you have time, you can add priority for all.
173 00:17:28.690 ⇒ 00:17:35.480 Awaish Kumar: And then… Basically, the…
174 00:17:37.110 ⇒ 00:17:43.340 Awaish Kumar: Yeah, when you have that P0 thing, I can then go in and check, like, how many of
175 00:17:43.480 ⇒ 00:17:49.030 Awaish Kumar: Those dashboards are actually active, or… How many…
176 00:17:49.420 ⇒ 00:17:59.929 Awaish Kumar: what explodes are being used, and then maybe we can work together, then figuring out, like, the… the fields?
177 00:18:00.260 ⇒ 00:18:03.470 Emily Giant: Like, mappings, like, okay, like.
178 00:18:03.470 ⇒ 00:18:12.340 Awaish Kumar: We can grab, like, these are the 50 or 100 fields which are, needed In the new…
179 00:18:12.560 ⇒ 00:18:30.790 Awaish Kumar: explore, and we can basically… you can fill out for me the… the old ones, and I can fill the new ones, like this, and put it back in Looker, and if missing, I will add… if missing.
180 00:18:47.230 ⇒ 00:18:48.020 Emily Giant: Hello?
181 00:18:48.430 ⇒ 00:18:52.030 Emily Giant: Oh, there you are. Hi, no worries. Okay.
182 00:18:52.100 ⇒ 00:18:53.889 Awaish Kumar: On my part, so, yeah.
183 00:18:53.980 ⇒ 00:18:55.150 Emily Giant: No worries.
184 00:18:55.330 ⇒ 00:18:56.650 Emily Giant: Okay.
185 00:18:56.650 ⇒ 00:19:01.239 Awaish Kumar: Yeah, that’s what I’m suggesting, like, if you have any better recommendation, you can…
186 00:19:01.670 ⇒ 00:19:08.600 Emily Giant: No, no different recommendation, really. So, I just want to make sure I understand the part about
187 00:19:08.850 ⇒ 00:19:13.170 Emily Giant: order of operations. So, frequently used dashboards.
188 00:19:13.310 ⇒ 00:19:24.640 Emily Giant: That’s no problem. We already have that on another sheet. So, that hasn’t changed outside of, like, the polyatomic ones, and there aren’t very many. But you need to know what fields we do not have yet.
189 00:19:27.390 ⇒ 00:19:28.240 Awaish Kumar: Yeah, that’s right.
190 00:19:28.240 ⇒ 00:19:30.440 Emily Giant: the old Explorers that we plan to replace.
191 00:19:31.140 ⇒ 00:19:35.969 Awaish Kumar: Yeah, like, from the… like, I’m not just talking about frequently accessed dashboard.
192 00:19:36.490 ⇒ 00:19:40.090 Awaish Kumar: Because we cannot work on everything at once.
193 00:19:40.210 ⇒ 00:19:45.180 Awaish Kumar: I’m more like saying, frequently accessed dashboards, plus the…
194 00:19:45.520 ⇒ 00:19:51.909 Awaish Kumar: The… the… what’d you say, like… Agency, or the…
195 00:19:53.430 ⇒ 00:19:56.999 Awaish Kumar: For them, so we can basically say, like.
196 00:19:57.610 ⇒ 00:20:05.280 Awaish Kumar: only the revenue models are the ones which are really priority for us right now, so I can just let that explore.
197 00:20:06.550 ⇒ 00:20:08.329 Awaish Kumar: Only focus on the…
198 00:20:08.440 ⇒ 00:20:21.970 Awaish Kumar: the fields which are supporting those dashboards. And once we have all of them in there, then let’s take another… maybe we do, like, iteratively 3-4 passes and make it work.
199 00:20:22.830 ⇒ 00:20:23.590 Emily Giant: Okay.
200 00:20:23.690 ⇒ 00:20:31.209 Emily Giant: So… From the other Dashboard Audit tab.
201 00:20:32.520 ⇒ 00:20:36.540 Emily Giant: I… I feel like I’ve… I did this exercise where…
202 00:20:38.010 ⇒ 00:20:41.000 Emily Giant: We… we did a very similar…
203 00:20:42.390 ⇒ 00:20:47.999 Emily Giant: Audit, where, like, ranked them in terms of urgency, etc.
204 00:20:49.510 ⇒ 00:20:50.780 Emily Giant: trying to…
205 00:20:51.130 ⇒ 00:20:55.840 Awaish Kumar: I’m… I’m seeing the field, like, last access to view count, and the…
206 00:20:59.220 ⇒ 00:21:06.309 Awaish Kumar: And when… what it means when it says duplicate stakeholders or duplicate Emily Alex columns?
207 00:21:07.890 ⇒ 00:21:14.139 Awaish Kumar: What does that mean? Like, when it says deprecate, why? That means we don’t need this dashboard anymore?
208 00:21:14.660 ⇒ 00:21:15.440 Emily Giant: Correct.
209 00:21:19.370 ⇒ 00:21:23.169 Awaish Kumar: Okay. This was just two different audits. I would just go through…
210 00:21:24.290 ⇒ 00:21:32.129 Emily Giant: like, we know that this one is now replaced, so the Emily Alex column is… I’ll go through and, like, update the…
211 00:21:32.330 ⇒ 00:21:34.760 Emily Giant: stakeholder versus Emily Alex column.
212 00:21:34.920 ⇒ 00:21:39.929 Emily Giant: Decide in Layer 1.
213 00:21:40.590 ⇒ 00:21:43.549 Emily Giant: Deprecate Layer 1. I don’t know what any of that means, but,
214 00:21:44.590 ⇒ 00:21:53.990 Emily Giant: This tab should have a lot of the, answers in there already, which will speed up the process.
215 00:21:54.580 ⇒ 00:21:55.710 Emily Giant: But…
216 00:21:56.950 ⇒ 00:22:04.299 Awaish Kumar: Yeah, like, it says the last access, we can figure out the… using that, I can figure out frequently accessed ones.
217 00:22:05.050 ⇒ 00:22:11.280 Awaish Kumar: And we can… if it is deprecated, why? That means we don’t need to work on it anymore, I hope.
218 00:22:12.700 ⇒ 00:22:18.550 Awaish Kumar: But still, I don’t see the kind of priority kind of thing here.
219 00:22:18.850 ⇒ 00:22:24.579 Emily Giant: Okay, so what… what we need to add is the priority column. Okay, that… that makes sense.
220 00:22:24.580 ⇒ 00:22:28.590 Awaish Kumar: So, like, there are, like, multiple deprecated columns, I don’t…
221 00:22:28.590 ⇒ 00:22:39.290 Emily Giant: Those are not terribly useful. So, if I created an updated version of this tab, the Dashboards Audit, and ranked by priority.
222 00:22:39.480 ⇒ 00:22:42.350 Awaish Kumar: Okay. Is that essentially what you need for step one?
223 00:22:42.980 ⇒ 00:22:50.710 Awaish Kumar: Yeah, I don’t need the ones which we need to deprecate, right? If we can filter them out…
224 00:22:51.070 ⇒ 00:22:52.580 Awaish Kumar: And then…
225 00:22:53.180 ⇒ 00:22:56.839 Awaish Kumar: have some remaining ones. Out of those, we will have the…
226 00:22:56.970 ⇒ 00:23:01.029 Awaish Kumar: Priority, and the lost exist kind of things.
227 00:23:01.150 ⇒ 00:23:05.859 Awaish Kumar: View counts, maybe, is helpful, and
228 00:23:05.970 ⇒ 00:23:10.450 Awaish Kumar: That’s all, right? From that, like, first action item.
229 00:23:11.120 ⇒ 00:23:17.400 Awaish Kumar: Second one will be, for, like, from the priority…
230 00:23:18.300 ⇒ 00:23:25.160 Awaish Kumar: dashboards, we will, get the… the models that is being used, right?
231 00:23:25.350 ⇒ 00:23:27.420 Emily Giant: All the explodes.
232 00:23:27.560 ⇒ 00:23:29.080 Awaish Kumar: And,
233 00:23:29.260 ⇒ 00:23:38.879 Awaish Kumar: And then come up with, like, I can, like, we can come up with, like, okay, this is one model, like, sales model, that’s what… that’s what we need. That is the case.
234 00:23:39.120 ⇒ 00:23:41.579 Awaish Kumar: And, like, you know what…
235 00:23:42.540 ⇒ 00:23:49.730 Awaish Kumar: in the sales model, what fees are there, and things like that. From the looker’s perspective, we can also have one more sheet in here.
236 00:23:49.890 ⇒ 00:23:53.760 Awaish Kumar: You can… your fields, like, one column with all the old fields.
237 00:23:55.380 ⇒ 00:24:00.679 Awaish Kumar: or the relevant, like, table name or things like that, so I can actually know.
238 00:24:00.680 ⇒ 00:24:01.749 Emily Giant: Is that just his comment?
239 00:24:02.250 ⇒ 00:24:05.240 Awaish Kumar: And similarly for me, my exercise will be to…
240 00:24:06.040 ⇒ 00:24:08.770 Awaish Kumar: Map it to the new ones.
241 00:24:09.040 ⇒ 00:24:14.120 Awaish Kumar: Will DPD figure out what is the new table and new field for this?
242 00:24:16.570 ⇒ 00:24:19.699 Awaish Kumar: If not available, then,
243 00:24:20.170 ⇒ 00:24:24.719 Awaish Kumar: That will be another task for me, to, like, bring them in, if possible.
244 00:24:24.910 ⇒ 00:24:35.229 Awaish Kumar: If not possible, then we together have to make a decision. If it’s not possible to bring in a new data model, like, what is the way forward then?
245 00:24:36.170 ⇒ 00:24:42.600 Awaish Kumar: No… After that, when everything is mapped.
246 00:24:42.730 ⇒ 00:24:44.839 Awaish Kumar: Then we just have to, like, switch.
247 00:24:45.140 ⇒ 00:24:45.880 Awaish Kumar: Like, maybe…
248 00:24:46.280 ⇒ 00:24:59.310 Awaish Kumar: You can go in and switch with the mapped fields, and… but only one way, one additional thing I’m suggesting is that when we are making that switch, like, basically.
249 00:25:00.220 ⇒ 00:25:04.139 Awaish Kumar: Like, when the feeds are mapped and you are creating a new explore.
250 00:25:05.360 ⇒ 00:25:12.989 Awaish Kumar: don’t, like, maybe create a copy, like, call it V2, and dashboards as well.
251 00:25:13.100 ⇒ 00:25:15.709 Awaish Kumar: So, we don’t break anything.
252 00:25:16.250 ⇒ 00:25:22.800 Emily Giant: Okay, yeah. Alright, so just making sure, like, the structure works for you, of…
253 00:25:23.230 ⇒ 00:25:28.459 Emily Giant: what the plan is… let me share again. So, in this new tab that you created.
254 00:25:31.630 ⇒ 00:25:39.410 Emily Giant: So we want… let’s just erase this for now, because that will take zero time to update. We would put…
255 00:25:40.950 ⇒ 00:25:42.240 Emily Giant: Priority?
256 00:25:44.320 ⇒ 00:25:45.160 Awaish Kumar: Okay.
257 00:25:45.460 ⇒ 00:25:48.350 Emily Giant: And then, what else do you need next to these? Like…
258 00:25:48.610 ⇒ 00:25:55.330 Awaish Kumar: Like, yeah, priority, and also, like, if it is… if it does not need to be replaced, just, like.
259 00:25:55.870 ⇒ 00:25:59.719 Awaish Kumar: Replicate, like, action, right?
260 00:26:00.100 ⇒ 00:26:00.770 Emily Giant: Okay.
261 00:26:01.270 ⇒ 00:26:08.299 Emily Giant: So, priority, action, and then you already have the model and explore.
262 00:26:08.620 ⇒ 00:26:09.460 Emily Giant: So…
263 00:26:09.460 ⇒ 00:26:15.710 Awaish Kumar: I don’t really need that anymore. Like, basically, with this exercise, like, I,
264 00:26:15.910 ⇒ 00:26:21.240 Awaish Kumar: With the… if you are, like, more closer to the stakeholders.
265 00:26:22.080 ⇒ 00:26:25.789 Awaish Kumar: Maybe you know better what is the priority for each of the dashboards.
266 00:26:25.900 ⇒ 00:26:31.220 Awaish Kumar: That’s why, like, we need that from you, and then,
267 00:26:34.100 ⇒ 00:26:36.980 Awaish Kumar: Once we have that, and the Explorer.
268 00:26:37.240 ⇒ 00:26:40.320 Awaish Kumar: We have the model, so basically.
269 00:26:40.510 ⇒ 00:26:47.920 Awaish Kumar: I can grab the fields from, the looker, or, like, you can create, like, for example.
270 00:26:48.170 ⇒ 00:26:50.530 Awaish Kumar: another sheet in this same Google Sheet.
271 00:26:51.860 ⇒ 00:26:58.740 Awaish Kumar: Which will have, like, table name, like, explore name, table name, and the field name for the old, and…
272 00:26:58.980 ⇒ 00:27:06.559 Awaish Kumar: I will create the mapping, for the… each row, each field. I will have… I will have mapped field.
273 00:27:07.950 ⇒ 00:27:08.830 Emily Giant: Gotcha.
274 00:27:09.390 ⇒ 00:27:14.350 Emily Giant: Once we have the Explorers, and dashboard list.
275 00:27:14.620 ⇒ 00:27:18.500 Emily Giant: List out the fields, and map them to the new field that should be used instead.
276 00:27:18.500 ⇒ 00:27:19.180 Awaish Kumar: Yeah.
277 00:27:22.740 ⇒ 00:27:23.330 Emily Giant: Okay.
278 00:27:23.980 ⇒ 00:27:35.439 Emily Giant: Yeah, I’ll work on this, and then once that’s done, which I don’t think it’ll take me very long at all, since we’ve done a version of this, and there are only a handful of new dashboards,
279 00:27:36.240 ⇒ 00:27:42.309 Emily Giant: I’ll start working on the… listing out the fields, and what’s missing, what’s already there, etc.
280 00:27:43.650 ⇒ 00:27:44.540 Awaish Kumar: Yeah.
281 00:27:45.090 ⇒ 00:27:52.309 Emily Giant: Okay, that makes sense. Yeah, I don’t think I have any questions, it’s pretty clear. I can work on this this afternoon, too.
282 00:27:52.710 ⇒ 00:27:55.760 Awaish Kumar: Yeah, so I then… Basically, like.
283 00:27:56.000 ⇒ 00:28:00.509 Awaish Kumar: You will come up with whatever, like, you know, in terms of dbt models.
284 00:28:01.330 ⇒ 00:28:06.620 Awaish Kumar: Maybe you can leave the fields as it is, like, you don’t know, like, if it exists, or…
285 00:28:07.070 ⇒ 00:28:13.060 Awaish Kumar: If it does not, or whatever, like, I will take that over, and…
286 00:28:13.470 ⇒ 00:28:19.060 Awaish Kumar: go back to dbt models and figure out if it’s there anywhere, or I need to bring that in, or something like that.
287 00:28:19.210 ⇒ 00:28:24.120 Awaish Kumar: And once it’s all webbed out, we will just go back and create the dashboards again.
288 00:28:24.530 ⇒ 00:28:32.959 Emily Giant: Okay, sounds good. Alright, I’ll try to finish this. I won’t be able to finish the fields, I don’t think, this afternoon, but I should be able to finish this part, and then hopefully this one tomorrow.
289 00:28:33.320 ⇒ 00:28:37.409 Awaish Kumar: Yeah, but that is, like, we can do that model by model, like…
290 00:28:37.920 ⇒ 00:28:39.240 Emily Giant: That sounds good.
291 00:28:39.240 ⇒ 00:28:44.889 Awaish Kumar: Yeah, we don’t know, like, once one model is done, we can move to another one, like, iteratively, okay?
292 00:28:45.420 ⇒ 00:28:53.579 Emily Giant: Okay, I like it. Alright, I’ll work on this this afternoon, and then we’ll meet again, talk through the step two, and which model we’re gonna start with.
293 00:28:54.040 ⇒ 00:28:55.359 Awaish Kumar: Okay, sure, thank you.
294 00:28:55.360 ⇒ 00:28:58.939 Emily Giant: Alright, sounds good. Do you have any other questions while we’re here?
295 00:29:01.060 ⇒ 00:29:02.040 Awaish Kumar: Oh, actually.
296 00:29:02.310 ⇒ 00:29:04.660 Emily Giant: Do you have any other questions while we’re here together?
297 00:29:05.580 ⇒ 00:29:12.210 Awaish Kumar: Not regarding this, I already asked about time zones…
298 00:29:12.520 ⇒ 00:29:16.549 Emily Giant: Yeah, I think that’s a really good point. I think they’re all over the place.
299 00:29:16.850 ⇒ 00:29:20.780 Emily Giant: And we need to make sure to go into dbt and…
300 00:29:21.010 ⇒ 00:29:32.210 Emily Giant: yeah, codify that. Make sure they’re all in the same time zone while they’re getting ingested into Looker, because Looker does the transformation based on the viewer’s time zone.
301 00:29:32.630 ⇒ 00:29:34.650 Emily Giant: So, yeah.
302 00:29:34.970 ⇒ 00:29:37.679 Emily Giant: But that’s something that we just need to…
303 00:29:37.920 ⇒ 00:29:41.190 Emily Giant: Go back and do, because it isn’t happening right now.
304 00:29:41.670 ⇒ 00:29:48.720 Awaish Kumar: Okay, yeah, that’s, like, really… Is the same problem happening in Metaplain? Like, there’s a model…
305 00:29:48.850 ⇒ 00:29:56.210 Awaish Kumar: Which are… which… for which we have the alerts, but it’s not working because of the…
306 00:29:56.370 ⇒ 00:30:02.840 Awaish Kumar: like, the time zone differences, it is only, like, maybe 1 hour, difference in actual, but
307 00:30:03.290 ⇒ 00:30:09.880 Awaish Kumar: because of time zone, like, it is taking one field in the Navy Eastern, and one field in UDC, and
308 00:30:10.020 ⇒ 00:30:14.930 Awaish Kumar: And then, time differences, like 7 hours, and the thing like that, so it…
309 00:30:15.900 ⇒ 00:30:16.560 Awaish Kumar: I’m okay.
310 00:30:16.560 ⇒ 00:30:19.630 Emily Giant: I just created an issue in the backlog, in linear.
311 00:30:19.760 ⇒ 00:30:27.500 Emily Giant: It says, align time zones for all core models in dbt and Looker. So, now at least we have, like, a placeholder for that work.
312 00:30:27.690 ⇒ 00:30:29.829 Awaish Kumar: Okay, yeah, that’s fine.
313 00:30:30.230 ⇒ 00:30:30.920 Emily Giant: Okay.
314 00:30:30.920 ⇒ 00:30:32.470 Awaish Kumar: And platform.
315 00:30:33.250 ⇒ 00:30:37.529 Awaish Kumar: That, yeah, for the… yeah, how Arlington is the North Beam thing?
316 00:30:37.750 ⇒ 00:30:42.789 Awaish Kumar: I… I have quite a few things for Alban Stems on my plate now.
317 00:30:43.020 ⇒ 00:30:43.919 Emily Giant: Yeah, that’s good.
318 00:30:43.920 ⇒ 00:30:53.480 Awaish Kumar: I need to prioritize, like, So… so we have these, DVD jobs, and
319 00:30:53.650 ⇒ 00:30:56.140 Awaish Kumar: the North Bean export thing?
320 00:30:56.590 ⇒ 00:31:06.529 Awaish Kumar: And Metaplane thing, and then Looker we are talking about. So, which of them is, do you think is the highest priority? I looked…
321 00:31:06.530 ⇒ 00:31:07.270 Emily Giant: Earthbeam.
322 00:31:07.960 ⇒ 00:31:09.380 Emily Giant: Yeah, for sure.
323 00:31:10.360 ⇒ 00:31:13.700 Awaish Kumar: Okay, then I will work on that today, and maybe…
324 00:31:15.750 ⇒ 00:31:18.490 Awaish Kumar: Little bit on DVD jobs. Okay.
325 00:31:18.490 ⇒ 00:31:21.699 Emily Giant: Alright, sounds good. Thank you, I’ll talk to you soon.
326 00:31:21.880 ⇒ 00:31:22.580 Awaish Kumar: Right.
327 00:31:22.920 ⇒ 00:31:23.490 Emily Giant: Bye.