Meeting Title: US | Looker Migration Date: 2025-10-28 Meeting participants: Uttam Kumaran, Awaish Kumar, pk.arthur, Emily Giant, Demilade Agboola
WEBVTT
1 00:00:26.730 ⇒ 00:00:29.060 Uttam Kumaran: Hey, how’d it go? Did you hear me and stuff?
2 00:00:29.900 ⇒ 00:00:33.689 Awaish Kumar: Yeah, it went well, I just sent the next steps in the select trend.
3 00:00:34.460 ⇒ 00:00:35.590 Uttam Kumaran: Hmm, okay.
4 00:00:35.740 ⇒ 00:00:36.530 Uttam Kumaran: Nice.
5 00:00:39.640 ⇒ 00:00:41.410 Uttam Kumaran: Nice!
6 00:00:41.410 ⇒ 00:00:42.580 pk.arthur: Hello, hello.
7 00:00:43.330 ⇒ 00:00:44.240 Uttam Kumaran: Hey!
8 00:00:47.880 ⇒ 00:00:52.980 Uttam Kumaran: Good to see you again? I think it’s probably been a long time. I don’t know if I… if I officially said aye.
9 00:00:52.980 ⇒ 00:00:53.520 pk.arthur: God.
10 00:00:53.520 ⇒ 00:00:54.110 Uttam Kumaran: book.
11 00:00:54.570 ⇒ 00:00:59.510 pk.arthur: Yeah, I think we’re at a bigger call, but yeah, nice to officially meet you.
12 00:00:59.880 ⇒ 00:01:01.420 Uttam Kumaran: Yeah, nice to meet you too.
13 00:01:03.260 ⇒ 00:01:04.689 Uttam Kumaran: This should be a good meeting.
14 00:01:05.379 ⇒ 00:01:09.109 pk.arthur: Yes, I have to run at the top of the hour, though, so…
15 00:01:09.110 ⇒ 00:01:09.490 Uttam Kumaran: Cool.
16 00:01:09.760 ⇒ 00:01:10.740 pk.arthur: Just point that out.
17 00:01:17.180 ⇒ 00:01:19.089 pk.arthur: Waiting for anyone? Emily?
18 00:01:19.090 ⇒ 00:01:21.369 Uttam Kumaran: Yeah, Emily and Demolade.
19 00:01:21.560 ⇒ 00:01:22.400 pk.arthur: Okay.
20 00:01:29.590 ⇒ 00:01:34.539 pk.arthur: How’s it been working with, like, Urban trying to fix everything so far?
21 00:01:35.060 ⇒ 00:01:39.820 Uttam Kumaran: This… I love it. I think this is great. I, I think…
22 00:01:40.870 ⇒ 00:01:44.289 Uttam Kumaran: I feel like, when we first started, I think…
23 00:01:44.430 ⇒ 00:01:48.750 Uttam Kumaran: Zach and Alex were a little bit, like, Unsure about the scope.
24 00:01:48.940 ⇒ 00:02:03.150 Uttam Kumaran: And I was like, guys, there’s actually, like, quite a bit going on. And then we started, like, chipping away at it, and then finally, like, I think we’ve made a lot of progress. I’m still, like… I feel… I still feel like there’s a lot to do.
25 00:02:03.550 ⇒ 00:02:10.810 Uttam Kumaran: But we’ve… we’ve come a long way, and I think this next phase of, like, kind of tearing into Looker is really, like, the next…
26 00:02:11.080 ⇒ 00:02:14.740 Uttam Kumaran: That piece that really affects… A lot more people.
27 00:02:15.010 ⇒ 00:02:25.529 Uttam Kumaran: But it’s good, I mean, look, we’re… we’re cleaning up, like, 8 years of DBT work in, like, a few months, so… not… not, like, bad. Yeah.
28 00:02:25.530 ⇒ 00:02:28.979 pk.arthur: I can’t imagine it, so definitely appreciate your help.
29 00:02:29.240 ⇒ 00:02:31.030 Uttam Kumaran: Yeah, of course, of course.
30 00:02:32.300 ⇒ 00:02:43.779 Uttam Kumaran: This is, just done Looker for a long time, and Looker at DBT stuff for a long time, so it’s really nice when we get to have some space to come in and, like, plan this out, and…
31 00:02:45.280 ⇒ 00:02:48.260 Uttam Kumaran: sometimes it can be more urgent. I know that there’s been…
32 00:02:48.450 ⇒ 00:02:53.390 Uttam Kumaran: sort of fires here and there, but of course everything, I think once we got through Mother’s Day and stuff.
33 00:02:53.640 ⇒ 00:02:57.900 Uttam Kumaran: we’re now like, okay, just until next Mother’s Day, we have to just keep cranking, so…
34 00:02:57.900 ⇒ 00:02:58.280 Emily Giant: Yeah.
35 00:02:58.280 ⇒ 00:02:59.040 pk.arthur: Yeah.
36 00:02:59.950 ⇒ 00:03:06.529 Uttam Kumaran: Okay, cool, so I think everyone’s here. Awwish, maybe you can message them a lot, but even first case,
37 00:03:06.920 ⇒ 00:03:10.140 Uttam Kumaran: It’s no problem. So, today, I kind of wanted to…
38 00:03:10.380 ⇒ 00:03:13.700 Uttam Kumaran: talk holistically about, like, our Looker…
39 00:03:13.810 ⇒ 00:03:23.880 Uttam Kumaran: sort of migration. But I want to hit, like, a couple of other items as well, like, in this conversation. So I’m gonna share, this…
40 00:03:24.180 ⇒ 00:03:27.059 Uttam Kumaran: Notion Doc, where I’m gonna be,
41 00:03:27.640 ⇒ 00:03:31.089 Uttam Kumaran: taking notes, but I will also share my screen.
42 00:03:31.920 ⇒ 00:03:33.660 Uttam Kumaran: Or I may ask…
43 00:03:33.880 ⇒ 00:03:40.950 Uttam Kumaran: someone else to sort of share Looker at some point. But if we can walk through this, that would be great. PK, I’ll just,
44 00:03:41.340 ⇒ 00:03:43.560 Uttam Kumaran: Make sure you have access to this.
45 00:03:43.950 ⇒ 00:03:45.680 pk.arthur: Yeah, I just requested access.
46 00:03:45.910 ⇒ 00:03:47.289 Uttam Kumaran: Okay, you should have it now
47 00:03:55.490 ⇒ 00:03:56.659 Uttam Kumaran: everybody in.
48 00:03:58.190 ⇒ 00:03:59.290 Emily Giant: Not yet.
49 00:03:59.290 ⇒ 00:04:00.760 pk.arthur: Yeah, give me a second.
50 00:04:04.310 ⇒ 00:04:05.120 Emily Giant: I’m in.
51 00:04:06.960 ⇒ 00:04:07.650 Uttam Kumaran: Okay.
52 00:04:09.520 ⇒ 00:04:10.000 pk.arthur: Same.
53 00:04:10.000 ⇒ 00:04:10.670 Uttam Kumaran: Cool.
54 00:04:11.390 ⇒ 00:04:19.450 Uttam Kumaran: So, as part of Looker, there’s kind of even more I want to tackle here beyond just, like, we’re swapping out views.
55 00:04:21.040 ⇒ 00:04:29.759 Uttam Kumaran: I also want to, while we’re poking around in there, I want to hit all of the content validation issues. I want to hit the slowest
56 00:04:30.130 ⇒ 00:04:31.390 Uttam Kumaran: PDTs.
57 00:04:31.700 ⇒ 00:04:39.439 Uttam Kumaran: And I also want to just ditch, like, old dashboards. We can’t do a lot of that until we have, like.
58 00:04:39.570 ⇒ 00:04:51.409 Uttam Kumaran: what the new places are. But very similarly to our, like, our migration work, as soon as we have new dashboards that answer the same questions, we can start to move people over. Additionally.
59 00:04:51.520 ⇒ 00:04:53.860 Uttam Kumaran: We can even just start replacing, like.
60 00:04:54.300 ⇒ 00:04:57.860 Uttam Kumaran: What’s underneath the iceberg for some of the dashboards.
61 00:04:58.260 ⇒ 00:05:05.550 Uttam Kumaran: I think that’s going to be the debate that we kind of have today. So I think the big, you know, piece here is, like.
62 00:05:05.850 ⇒ 00:05:23.849 Uttam Kumaran: we already have access to a lot of Looker reports, top PDTs. I actually think that these are going to be a little bit easier. There’s a lot of PDTs that just need to move over to the warehouse and things like that that we can do. I think what’s more important to me is to understand, like, what all of our current explorers are.
63 00:05:24.030 ⇒ 00:05:26.520 Uttam Kumaran: What views roll up into them?
64 00:05:26.690 ⇒ 00:05:29.090 Uttam Kumaran: And then, like, what we want the future…
65 00:05:29.210 ⇒ 00:05:34.610 Uttam Kumaran: to look like. So maybe we can… just start…
66 00:05:34.910 ⇒ 00:05:40.000 Uttam Kumaran: like, there. I mean, the biggest thing, I guess we can start in this, like,
67 00:05:41.180 ⇒ 00:05:51.539 Uttam Kumaran: ideally, I kind of just want to start writing. So I don’t know if Emily or PK, you guys want to just articulate, like, what are the core explorers, and, like, what rolls up
68 00:05:52.010 ⇒ 00:05:58.070 Uttam Kumaran: into them, And we can start to note down
69 00:05:59.180 ⇒ 00:06:13.840 Uttam Kumaran: we can start to just basically note down, at least get a current index of everything that’s in there, and then we can start to… once we start mapping one-to-one old views to new views, it’ll help us kind of determine what the new explorers could look like. I also… I’m a little bit opinionated on, like.
70 00:06:14.060 ⇒ 00:06:20.679 Uttam Kumaran: how we should do the explore, so if we don’t have a clear methodology of how we did it, we can certainly have one.
71 00:06:21.200 ⇒ 00:06:22.440 Uttam Kumaran: Going forward.
72 00:06:22.800 ⇒ 00:06:29.519 Emily Giant: Yeah, we definitely don’t have a methodology. It’s just like, oh, does this have a suborder ID that I can join to this? Let’s do it.
73 00:06:29.520 ⇒ 00:06:30.090 Uttam Kumaran: Yes.
74 00:06:30.090 ⇒ 00:06:32.770 Emily Giant: That’s our current methodology.
75 00:06:32.770 ⇒ 00:06:33.390 Uttam Kumaran: Okay.
76 00:06:33.390 ⇒ 00:06:37.470 Emily Giant: Main one is sales… data.
77 00:06:38.210 ⇒ 00:06:38.940 Uttam Kumaran: Yes.
78 00:06:39.840 ⇒ 00:06:41.440 Emily Giant: Then component data.
79 00:06:45.700 ⇒ 00:06:48.240 Emily Giant: And then the polyatomic inventory models.
80 00:06:51.110 ⇒ 00:06:55.790 Emily Giant: which I do in, like, a future state, have them combined into one.
81 00:06:55.930 ⇒ 00:06:58.699 Emily Giant: So that it’s not… but because so many people built
82 00:06:58.970 ⇒ 00:07:05.580 Emily Giant: looks on using them separately. I just was like, I’m gonna do this all at once, so that I’m not, like.
83 00:07:06.150 ⇒ 00:07:12.580 Emily Giant: piecing these together. Sales component, inventory, let me open up… Looker.
84 00:07:12.580 ⇒ 00:07:15.869 Uttam Kumaran: Yeah, and I’ll actually also have it up next to me here.
85 00:07:17.630 ⇒ 00:07:25.979 Emily Giant: So, there are a couple… there are 3 different models that I think people leverage, but the main one leveraged is the, top-line sales data.
86 00:07:29.190 ⇒ 00:07:36.440 Emily Giant: And then, there are so many… So many.
87 00:07:36.800 ⇒ 00:07:40.799 Emily Giant: Explores, but I’m just gonna page through them real quick.
88 00:07:41.640 ⇒ 00:07:47.609 Emily Giant: Shopify orders is the first one, but that is limited to, like, 5 people in the company.
89 00:07:48.620 ⇒ 00:07:51.950 Emily Giant: Component data is a big one, I already said that one.
90 00:07:57.910 ⇒ 00:08:06.240 Emily Giant: I don’t know what to do with Braintree refund data. We still use Braintree for Loop, but I’m hoping that we don’t have to use that one at all, and we can just nix it.
91 00:08:07.120 ⇒ 00:08:07.710 Uttam Kumaran: Okay.
92 00:08:07.710 ⇒ 00:08:12.329 Emily Giant: Inventory transaction data, get rid of it.
93 00:08:14.100 ⇒ 00:08:16.599 Emily Giant: Non-floral inventory data, get rid of it.
94 00:08:18.320 ⇒ 00:08:23.370 Emily Giant: New level forecast? No idea what that is. Let me see what’s tied to it.
95 00:08:24.350 ⇒ 00:08:34.280 Emily Giant: I think… Mmm, I think get rid of it, but I don’t know for sure. It looks like nonsense.
96 00:08:34.520 ⇒ 00:08:40.049 Uttam Kumaran: Yeah, so one thing we can do is I can run a query after this that sort of shows usage by Explore.
97 00:08:41.820 ⇒ 00:08:46.199 Uttam Kumaran: But roughly, it seems like we do have some explorers that we can just already ditch.
98 00:08:46.860 ⇒ 00:08:47.809 Uttam Kumaran: Nobody’s using it.
99 00:08:48.600 ⇒ 00:08:53.139 Emily Giant: Yeah, new component level forecasts should be folded up into the new sales data.
100 00:08:54.360 ⇒ 00:08:55.459 Emily Giant: Sorry, do you want me to, like…
101 00:08:57.520 ⇒ 00:09:04.069 Uttam Kumaran: No, no, this is fine, because it’ll be in this transcript, so… I’m just typing so I can start to build a little bit of structure.
102 00:09:04.380 ⇒ 00:09:08.360 Uttam Kumaran: And then I’ll kind of end up putting it in here eventually.
103 00:09:09.120 ⇒ 00:09:25.010 Emily Giant: Primary Zendesk data, we can get rid of it, because that’s going to fold into gorgeous data, but it’s, like, not used currently. We don’t have that software anymore. Subscriptions… There’s no way it works, so get rid of it. That should be its own new explorer.
104 00:09:28.740 ⇒ 00:09:31.409 Emily Giant: Oh, God, segment flow custom query?
105 00:09:31.790 ⇒ 00:09:36.099 Emily Giant: No idea, but PK might know, because segment sounds like a marketing word.
106 00:09:36.550 ⇒ 00:09:36.899 Uttam Kumaran: It is.
107 00:09:36.900 ⇒ 00:09:40.190 pk.arthur: a marketing word, but I’ve never actually seen that. I think it was probably…
108 00:09:40.280 ⇒ 00:09:41.950 Emily Giant: Prior to my time here.
109 00:09:43.090 ⇒ 00:09:44.329 Emily Giant: And mine, too.
110 00:09:44.330 ⇒ 00:09:49.659 pk.arthur: Yeah. I’m… I’m usually just only, in sales data, to be honest.
111 00:09:49.850 ⇒ 00:09:58.160 Emily Giant: Okay, and then, like, it looks like it’s only joined on customer ID, so that should be rolled up into the new DIM customers, like, these shouldn’t…
112 00:09:59.200 ⇒ 00:10:06.249 Emily Giant: I don’t know what these are. I don’t know at all. Active recurring subscriptions, kill it, that should be in the subscriptions only.
113 00:10:06.420 ⇒ 00:10:10.959 Emily Giant: Border level build, kill it. It’s just a, like, chunk of…
114 00:10:11.150 ⇒ 00:10:14.290 Emily Giant: sales data, it’s all available in sales data.
115 00:10:14.530 ⇒ 00:10:15.500 Emily Giant: FedEx.
116 00:10:15.500 ⇒ 00:10:22.030 Uttam Kumaran: So, for example, like, if I… if we just talk about subscriptions, there’s all of these… Here.
117 00:10:22.030 ⇒ 00:10:25.200 Emily Giant: Yeah, those are, PDTs.
118 00:10:25.900 ⇒ 00:10:32.739 Emily Giant: the care ones, I don’t know what deferred subscription detail is, but we gotta get rid of it. It doesn’t work anymore.
119 00:10:32.950 ⇒ 00:10:39.509 Emily Giant: And it should be whatever components of that should be in the new subscription explorer.
120 00:10:40.410 ⇒ 00:10:46.419 Emily Giant: But none of the top-line sales subscription explorers should be existing anymore.
121 00:10:49.660 ⇒ 00:10:50.240 Uttam Kumaran: Hey.
122 00:10:53.080 ⇒ 00:10:55.230 Emily Giant: And then FedEx… no.
123 00:10:55.380 ⇒ 00:10:56.440 Emily Giant: Done.
124 00:10:57.180 ⇒ 00:10:59.320 Emily Giant: Holiday delivery forecast.
125 00:10:59.600 ⇒ 00:11:04.230 Emily Giant: No.
126 00:11:04.330 ⇒ 00:11:05.390 Emily Giant: Should be done.
127 00:11:05.940 ⇒ 00:11:11.249 Emily Giant: Holiday purchase forecast… Like, there should be a whole, like, forecast explore.
128 00:11:11.730 ⇒ 00:11:12.860 Emily Giant: Like, just one.
129 00:11:12.860 ⇒ 00:11:13.260 Uttam Kumaran: Yeah.
130 00:11:13.260 ⇒ 00:11:20.439 Emily Giant: there’s, like, too many different holiday, purchase, holiday delivery, like, no. Just, it should be one. Forecast, explore.
131 00:11:20.620 ⇒ 00:11:26.249 Emily Giant: Current date fiscal count… no, that’s not an Explorer. A holiday NVR forecast? Nope.
132 00:11:27.100 ⇒ 00:11:34.500 Emily Giant: Active recurring subscriptions… nope. Okay, so I think we’re… no, we’re just getting into, like, duplicates here. What’s going on?
133 00:11:34.500 ⇒ 00:11:35.280 Uttam Kumaran: Yeah.
134 00:11:36.460 ⇒ 00:11:45.710 Emily Giant: Let me see… Holiday delivery… Holiday purchase, Holiday NVR, Holiday FC Purchase Forecast? No.
135 00:11:46.040 ⇒ 00:11:51.220 Emily Giant: That should just be part of the forecast delivery capacity.
136 00:11:58.320 ⇒ 00:12:00.279 Emily Giant: Yeah, I guess that one stays.
137 00:12:05.670 ⇒ 00:12:08.159 Emily Giant: User Credits XF stays.
138 00:12:10.220 ⇒ 00:12:13.940 Emily Giant: Send a… or in stock by Geo? No.
139 00:12:14.960 ⇒ 00:12:21.219 Awaish Kumar: Should we create a, like, a Google Sheet with these names, and then we mark them as…
140 00:12:25.020 ⇒ 00:12:28.349 Uttam Kumaran: Yeah, I’m… I’m basically gonna… I’m basically gonna…
141 00:12:28.530 ⇒ 00:12:35.780 Uttam Kumaran: like, well, one, we have this transcript, so it’s helpful just to get Emily’s context, and then also we’ll have the data here, which is, like.
142 00:12:36.250 ⇒ 00:12:40.270 Uttam Kumaran: for example, what I’m going to be looking at here is we should see, like, the earliest
143 00:12:41.180 ⇒ 00:12:47.520 Uttam Kumaran: We should see the last… the latest time, like, an explorer was… Was basically ran out.
144 00:12:47.830 ⇒ 00:12:48.410 Emily Giant: Huh.
145 00:12:48.930 ⇒ 00:12:51.430 Uttam Kumaran: So that’s also what I’m gonna work on.
146 00:12:54.320 ⇒ 00:13:01.860 Emily Giant: InStock by Geo should be replaced by, the new… snapshot data.
147 00:13:03.880 ⇒ 00:13:11.390 Emily Giant: Google Analytics, PK, what’s… is joined to literally nothing, it’s just its own little blob.
148 00:13:12.310 ⇒ 00:13:14.100 Emily Giant: But I’m guessing we’re keeping it?
149 00:13:14.100 ⇒ 00:13:18.840 pk.arthur: Yeah, we should definitely keep that. That is, needed.
150 00:13:19.450 ⇒ 00:13:20.120 Emily Giant: Okay.
151 00:13:20.400 ⇒ 00:13:24.759 Emily Giant: Yachtpo survey results, we still use Yachtpo.
152 00:13:24.870 ⇒ 00:13:31.579 Emily Giant: should probably keep that, but it should really be rolled into more of, like, a customer experience type explore.
153 00:13:31.990 ⇒ 00:13:39.280 Emily Giant: I don’t think it should necessarily live on its own, because then there’s no utility there. It’s like, just go to Yachtpo if it isn’t joined to anything.
154 00:13:41.980 ⇒ 00:13:47.889 Emily Giant: Inventory Utilization Master, No clue what that is. That’s old.
155 00:13:48.290 ⇒ 00:13:54.310 Emily Giant: Custom Ops Capacity Query, I don’t know what that is.
156 00:13:55.490 ⇒ 00:13:58.039 Emily Giant: But we should probably ask someone about that one.
157 00:13:58.720 ⇒ 00:14:02.220 Uttam Kumaran: I doubt it’s been used in years, but just in case.
158 00:14:02.220 ⇒ 00:14:06.020 Emily Giant: Unified refund derived table. Nope, that should be replaced by…
159 00:14:07.030 ⇒ 00:14:16.059 Emily Giant: the historical revenue, yada yada, that new Shopify Mart, product SKU performance… no, that’s from 2022.
160 00:14:16.600 ⇒ 00:14:19.130 Emily Giant: Buffer snapshot, deprecated.
161 00:14:20.360 ⇒ 00:14:22.190 Emily Giant: Promo categories.
162 00:14:22.340 ⇒ 00:14:27.559 Emily Giant: That’s its own Explorer, and that should be part of a different Explorer, so we don’t need it on its own.
163 00:14:28.150 ⇒ 00:14:29.620 pk.arthur: I think there might be an older…
164 00:14:29.970 ⇒ 00:14:30.970 pk.arthur: version of it.
165 00:14:31.190 ⇒ 00:14:33.370 Emily Giant: Yeah, and all it is, is just…
166 00:14:35.120 ⇒ 00:14:42.120 Emily Giant: just promo code information, like, nothing else, so… I don’t really think it’s used. Attached product-derived tables? No.
167 00:14:42.270 ⇒ 00:14:43.880 Emily Giant: Q&D table.
168 00:14:44.130 ⇒ 00:14:52.720 Uttam Kumaran: So, it looks like even these, like, active recurring subscriptions, attached products to roundtable, blended ARP feed, capacity, CDL, these can all get ditched.
169 00:14:52.860 ⇒ 00:14:54.430 Emily Giant: Yeah. Yeah.
170 00:14:54.430 ⇒ 00:14:56.630 Uttam Kumaran: Sick. Let’s go.
171 00:14:57.250 ⇒ 00:14:58.520 Uttam Kumaran: That’s great.
172 00:14:58.520 ⇒ 00:15:00.330 Emily Giant: We’re gonna have, like, 4 Explorers.
173 00:15:00.570 ⇒ 00:15:02.899 Uttam Kumaran: Yes, you don’t need more. You don’t need any more.
174 00:15:02.900 ⇒ 00:15:06.480 Emily Giant: Why do I have so many of these?
175 00:15:07.260 ⇒ 00:15:11.430 Emily Giant: Q&D Explorer, I don’t know if that’s ever been used.
176 00:15:12.360 ⇒ 00:15:16.359 Emily Giant: retention model, I’m curious as to what that is.
177 00:15:17.270 ⇒ 00:15:19.120 pk.arthur: I think that was, like, a Steven…
178 00:15:19.540 ⇒ 00:15:23.349 pk.arthur: projects in the back. I’ve looked at it before, but I don’t… I don’t use that.
179 00:15:23.620 ⇒ 00:15:28.349 Emily Giant: Okay. And then there’s the staging retention model, which I can’t imagine is…
180 00:15:28.490 ⇒ 00:15:31.270 Emily Giant: meant to be in Looker.
181 00:15:32.130 ⇒ 00:15:37.969 Emily Giant: Explore GA4 audience behavior. That should be rolled up into, like, one bigger GA.
182 00:15:38.750 ⇒ 00:15:39.600 Emily Giant: Bing.
183 00:15:39.700 ⇒ 00:15:41.530 Emily Giant: Loyalty events.
184 00:15:43.640 ⇒ 00:15:48.709 Emily Giant: That should be in the same Explorer as, like, the other marketing data, not on its own.
185 00:15:51.630 ⇒ 00:15:59.510 Emily Giant: in-line snapshot detail, couldn’t tell ya. Get rid of it. The K-SKU pairings, get rid of it.
186 00:16:00.780 ⇒ 00:16:02.890 Emily Giant: Hub O export.
187 00:16:03.250 ⇒ 00:16:04.540 Emily Giant: Get rid of it.
188 00:16:04.830 ⇒ 00:16:15.419 Emily Giant: DIM customer segmentation, get rid of it. Zip code maps, keep it. Weirdly… it should be worked into more of a, like, operations explorer.
189 00:16:15.780 ⇒ 00:16:17.429 Emily Giant: It shouldn’t be on its own.
190 00:16:17.770 ⇒ 00:16:21.620 Emily Giant: But it shouldn’t… it shouldn’t be its own explorer, but it should be…
191 00:16:22.210 ⇒ 00:16:27.340 Emily Giant: not completely deleted. Blended ARP feed.
192 00:16:29.440 ⇒ 00:16:35.110 Emily Giant: I don’t… I… Don’t know what that is. Had you ever used that, PK?
193 00:16:35.630 ⇒ 00:16:36.730 pk.arthur: Never seen it.
194 00:16:37.180 ⇒ 00:16:47.250 Emily Giant: No clue, I don’t… I don’t know if that’s used at all. User XF, get rid of it, like, I don’t know what the point of having that would be… separate from a sales table.
195 00:16:50.490 ⇒ 00:16:53.110 Emily Giant: Like, I can see it being a view, but not an explore.
196 00:16:54.510 ⇒ 00:16:59.289 Emily Giant: Dim Yachtpo reviews. Sounds a lot like Yachtpo, the other thing.
197 00:17:00.510 ⇒ 00:17:06.770 Emily Giant: But that should, also be in, like, the customer care…
198 00:17:06.920 ⇒ 00:17:10.860 Emily Giant: explore, dim me up for reviews, da-da-da-da, I didn’t care to… yeah.
199 00:17:12.760 ⇒ 00:17:13.510 Emily Giant: Okay.
200 00:17:14.640 ⇒ 00:17:20.299 Emily Giant: That’s all of them in top-line sales. Then there’s a user retention correlation model.
201 00:17:20.400 ⇒ 00:17:25.120 Emily Giant: Pk, you might be able to speak better to this one.
202 00:17:25.609 ⇒ 00:17:28.169 pk.arthur: Yeah, I have not even used that before, too.
203 00:17:28.170 ⇒ 00:17:32.039 Emily Giant: Let me see if there’s anything… there’s first purchase characteristics.
204 00:17:33.060 ⇒ 00:17:34.039 Emily Giant: So we just need.
205 00:17:34.040 ⇒ 00:17:36.440 pk.arthur: Isn’t that… isn’t that top line sales?
206 00:17:37.300 ⇒ 00:17:39.820 Emily Giant: it’s tied to top-line sales. So…
207 00:17:40.000 ⇒ 00:17:48.830 Emily Giant: I don’t know why it’s in a different model entirely. So, I think probably… Segmentation timeline, or segments Timeline.
208 00:17:50.940 ⇒ 00:17:53.640 Emily Giant: It’s also tied to top-line sales.
209 00:17:56.740 ⇒ 00:17:59.430 pk.arthur: I have not used Segment’s Timeline before, either, too.
210 00:18:00.840 ⇒ 00:18:04.820 pk.arthur: I think that these are… yeah, these all should just be pulled into, like.
211 00:18:04.820 ⇒ 00:18:06.740 Emily Giant: Marketing Mart.
212 00:18:07.050 ⇒ 00:18:09.310 Emily Giant: It shouldn’t be their own model at all.
213 00:18:10.160 ⇒ 00:18:14.439 pk.arthur: And some can honestly be get, can honestly be got rid of, to be honest.
214 00:18:14.440 ⇒ 00:18:21.619 Emily Giant: Yeah Infrastructure model is not a thing, it just says Soligo.
215 00:18:21.780 ⇒ 00:18:25.159 Emily Giant: Kpis model.
216 00:18:26.920 ⇒ 00:18:29.580 Emily Giant: KPI Unified. This should all go into, like.
217 00:18:29.770 ⇒ 00:18:35.879 Emily Giant: I mean, it’s gonna be its own Explorer, but there’s 3 different Explorers. One’s KPI Unified, and it’s…
218 00:18:36.070 ⇒ 00:18:39.459 Emily Giant: All of the different, like, budget purchase stuff.
219 00:18:40.200 ⇒ 00:18:42.339 Emily Giant: So that should go in the forecasting.
220 00:18:44.870 ⇒ 00:18:47.269 Emily Giant: And then, Component Economics.
221 00:18:47.440 ⇒ 00:18:53.899 Emily Giant: Unprofitable customers, purchased, fiscal calendar subscriptions. This should be, like.
222 00:18:56.990 ⇒ 00:18:58.660 Emily Giant: In the marketing mart.
223 00:19:02.320 ⇒ 00:19:08.940 Emily Giant: But it’s full of models that we’re not gonna use anymore. So it’s like, demo mess, CareTags is getting redone.
224 00:19:09.240 ⇒ 00:19:16.420 Emily Giant: The only thing I see in here that I’m like, what is this, is an unprofitable customer’s View…
225 00:19:18.420 ⇒ 00:19:21.949 pk.arthur: How accurate, or how recent is that? Because I’ve never even seen that either, too.
226 00:19:22.320 ⇒ 00:19:23.829 Emily Giant: Let me look at the view.
227 00:19:24.550 ⇒ 00:19:25.700 pk.arthur: Profitable.
228 00:19:30.800 ⇒ 00:19:32.199 Emily Giant: Oh, it’s a PD.
229 00:19:32.840 ⇒ 00:19:34.090 Emily Giant: It says…
230 00:19:34.420 ⇒ 00:19:35.319 pk.arthur: of PDP?
231 00:19:36.270 ⇒ 00:19:37.240 Emily Giant: It’s a…
232 00:19:37.390 ⇒ 00:19:45.830 Emily Giant: something derived table. Persistent derived table, it’s like a query in, instead of doing it in dbt, and…
233 00:19:45.930 ⇒ 00:19:48.439 Emily Giant: therefore making Looker really slow.
234 00:19:48.440 ⇒ 00:19:48.980 pk.arthur: Oh.
235 00:19:48.980 ⇒ 00:19:56.910 Emily Giant: queries, like, directly into a view. So, this one is combine user ID, count distinct orders, coalesce.
236 00:19:57.820 ⇒ 00:20:01.629 Emily Giant: Gross margin, as gross margin dollars.
237 00:20:01.990 ⇒ 00:20:07.699 Emily Giant: And then, from scratch, as component economics, Kill it.
238 00:20:07.960 ⇒ 00:20:11.259 Emily Giant: Kill it. It doesn’t even make sense.
239 00:20:12.040 ⇒ 00:20:18.079 Emily Giant: to us now. Like, what it’s looking at doesn’t… it made sense when it was made, but it doesn’t anymore.
240 00:20:18.750 ⇒ 00:20:27.930 Emily Giant: Mode migration model, kill it, like, the entire… excuse me, the entire, model should go away.
241 00:20:28.340 ⇒ 00:20:40.870 Emily Giant: NetSuite cash sales, entire model should go away. New core model, I can delete it now. Or I can’t, I can’t, because I think PK has, like, two views that we need to just, or two looks that we need to move over to the new…
242 00:20:41.110 ⇒ 00:20:42.519 pk.arthur: Oh, there’s Shopify, and .
243 00:20:42.520 ⇒ 00:20:43.080 Emily Giant: Yeah.
244 00:20:43.220 ⇒ 00:20:45.439 Emily Giant: But I’ll keep that there, it’s no… it’s no rush.
245 00:20:45.770 ⇒ 00:20:49.440 pk.arthur: Yeah, and the inventory balance snapshot, too.
246 00:20:49.990 ⇒ 00:20:50.810 Emily Giant: Yeah.
247 00:20:51.810 ⇒ 00:20:56.680 Emily Giant: And then, the last model…
248 00:20:56.880 ⇒ 00:21:01.820 Emily Giant: Delivery zip code, schedule rule, DAO, distribution points.
249 00:21:04.090 ⇒ 00:21:06.490 Emily Giant: I don’t think we… I don’t think we need this.
250 00:21:08.920 ⇒ 00:21:12.180 Emily Giant: It’s not tied to anything… That we use anymore.
251 00:21:16.110 ⇒ 00:21:16.800 Emily Giant: Okay.
252 00:21:17.490 ⇒ 00:21:19.419 Emily Giant: I think that’s all of the Explorers.
253 00:21:20.450 ⇒ 00:21:25.489 Uttam Kumaran: Okay, cool. So I can go map it. I’m gonna start building this. We also have some old…
254 00:21:26.350 ⇒ 00:21:39.779 Uttam Kumaran: analysis from when we did our first audit, so I can basically put it there. Sometimes, some of these are used in dashboards, though, so I guess my question is, if they’re used in dashboards, what is our path forward?
255 00:21:40.130 ⇒ 00:21:42.170 Uttam Kumaran: Like, should we… yeah.
256 00:21:45.340 ⇒ 00:21:47.479 Emily Giant: I think we need to do, like.
257 00:21:47.720 ⇒ 00:21:50.589 Emily Giant: Sessions with stakeholders to rebuild them.
258 00:21:50.780 ⇒ 00:21:51.450 Uttam Kumaran: Okay.
259 00:21:54.100 ⇒ 00:21:59.909 Emily Giant: Or ask those stakeholders, like, do you really use this look? Do you really use this part of the dashboard? Because…
260 00:22:01.330 ⇒ 00:22:03.950 Emily Giant: This is a deprecated Explore.
261 00:22:05.600 ⇒ 00:22:09.500 Emily Giant: And sales data isn’t deprecated, it just… isn’t.
262 00:22:10.580 ⇒ 00:22:16.589 Emily Giant: correctly… calculating revenue. So we just need to move all of those reports.
263 00:22:16.770 ⇒ 00:22:18.540 Emily Giant: into the new Shopify.
264 00:22:19.340 ⇒ 00:22:23.909 Uttam Kumaran: So one thing that’s pretty easy to do, for example, and I would kind of just…
265 00:22:24.200 ⇒ 00:22:28.490 Uttam Kumaran: be down to do it. Emily, if you’re down, is I can just deprecate
266 00:22:28.890 ⇒ 00:22:33.930 Uttam Kumaran: Dashboards that haven’t been used in, like, A year? Two years?
267 00:22:35.210 ⇒ 00:22:37.020 Uttam Kumaran: That’ll cut, like, half of them out.
268 00:22:37.250 ⇒ 00:22:37.870 Emily Giant: Yeah.
269 00:22:38.000 ⇒ 00:22:42.519 Uttam Kumaran: If we look at, like,
270 00:22:44.120 ⇒ 00:22:49.670 Uttam Kumaran: Yeah, I mean, I think that would cut, like, a good… that would cut a fair bit out, and then I can start to rank them
271 00:22:49.990 ⇒ 00:22:53.210 Uttam Kumaran: I could start to rank them by views, and then we can…
272 00:22:54.730 ⇒ 00:23:00.540 Uttam Kumaran: Start to look at the individual looks that are, like, culprits, and either delete them,
273 00:23:02.840 ⇒ 00:23:17.260 Uttam Kumaran: Like, if… okay, so that’s helpful. Because, for example, if a… if a… if a Explorer… well, actually, the problem is, like, if an Explorer has not been queried in a long time, then it’s not… it’s not in any dashboard that’s been loaded recently.
274 00:23:17.260 ⇒ 00:23:17.730 Emily Giant: Right.
275 00:23:17.730 ⇒ 00:23:22.159 Uttam Kumaran: But let’s say an explorer Isn’t a dashboard.
276 00:23:22.570 ⇒ 00:23:24.080 Uttam Kumaran: And it’s been queried.
277 00:23:24.320 ⇒ 00:23:28.669 Uttam Kumaran: but it’s not useful. That is something that we’ll have to go dashboard by dashboard.
278 00:23:28.800 ⇒ 00:23:38.410 Uttam Kumaran: So I want to nix as many explorers as possible in this initial first run, and then nix a bunch of dashboards, and then we’ll have a smaller subset, so we can go line by line.
279 00:23:39.220 ⇒ 00:23:41.990 Uttam Kumaran: That would be good.
280 00:23:42.550 ⇒ 00:23:44.249 Demilade Agboola: Excuse me?
281 00:23:44.880 ⇒ 00:23:53.360 Demilade Agboola: Also, would it be possible for us to, like, remove deep explorers, but, like, yeah. …potentially keep the logic of it
282 00:23:53.510 ⇒ 00:23:55.830 Demilade Agboola: So that if we need to, like…
283 00:23:56.160 ⇒ 00:23:59.459 Demilade Agboola: Restore it on a really short notice, we could do that.
284 00:24:00.270 ⇒ 00:24:05.760 Uttam Kumaran: Yeah, what we did last time is we act… we did a very similar thing. We just… we changed it to hidden.
285 00:24:09.050 ⇒ 00:24:14.539 Uttam Kumaran: I don’t know where, I forgot… yeah, we put that… we put that somewhere here, but we just… we just changed the…
286 00:24:15.300 ⇒ 00:24:18.089 Uttam Kumaran: the Explore thing to hit in.
287 00:24:18.370 ⇒ 00:24:22.679 Uttam Kumaran: And then I can… and then I can start commenting it out, too, that way it’s just.
288 00:24:22.680 ⇒ 00:24:23.370 Demilade Agboola: air.
289 00:24:24.310 ⇒ 00:24:24.639 Uttam Kumaran: I think…
290 00:24:24.640 ⇒ 00:24:32.069 Demilade Agboola: I think we should just, like, do deep cuts, and if no one makes any comments about it, then it really never mattered.
291 00:24:32.330 ⇒ 00:24:36.659 Demilade Agboola: If they do, then we can look at how we can, you know, restore that.
292 00:24:37.330 ⇒ 00:24:37.920 Uttam Kumaran: Okay.
293 00:24:40.650 ⇒ 00:24:41.710 Emily Giant: Okay.
294 00:24:42.780 ⇒ 00:24:47.399 Uttam Kumaran: One thing let’s also talk about while we’re here is just, like, naming conventions.
295 00:24:47.540 ⇒ 00:24:50.610 Uttam Kumaran: So, how do you guys, like.
296 00:24:51.080 ⇒ 00:24:55.519 Uttam Kumaran: for PK and Emily, like, how should we… Name things moving forward.
297 00:24:56.160 ⇒ 00:25:04.849 Uttam Kumaran: I mean, this just seems pretty standard for if you just, like, kind of create explorers as they go, but do you think it’s helpful to do one per mart?
298 00:25:05.380 ⇒ 00:25:10.919 Uttam Kumaran: Like, is this another… The biggest thing is, like, one.
299 00:25:11.760 ⇒ 00:25:17.970 Uttam Kumaran: Explores are just joins, right? So, one, you don’t want to have, like, Explore with, like, a hundred different joins.
300 00:25:17.970 ⇒ 00:25:18.580 Emily Giant: Yeah.
301 00:25:18.580 ⇒ 00:25:26.069 Uttam Kumaran: Like, 5 or so is okay, but if you’re joining 100 things together, we want to just now create another view.
302 00:25:26.220 ⇒ 00:25:28.359 Uttam Kumaran: You know, for you to access.
303 00:25:28.580 ⇒ 00:25:34.690 Uttam Kumaran: So ideally, we end up with, like, 10 to 15 explorers.
304 00:25:34.890 ⇒ 00:25:39.020 Uttam Kumaran: And then they roughly cover each part of the business at the granularities that you need.
305 00:25:40.460 ⇒ 00:25:44.910 Uttam Kumaran: So, I know we’re… we’re… we have one for invent… we can do one for inventory.
306 00:25:45.160 ⇒ 00:25:48.030 Uttam Kumaran: could do one for… for revenue. I guess, like.
307 00:25:48.690 ⇒ 00:25:54.300 Uttam Kumaran: We should… we could do one for subscriptions, so it’s outside of that, if needed.
308 00:25:54.410 ⇒ 00:25:58.019 Uttam Kumaran: But it could just point to the same views.
309 00:25:58.300 ⇒ 00:26:03.139 Uttam Kumaran: But I guess, like, let me know what else you think we should… could try to start to build towards.
310 00:26:03.610 ⇒ 00:26:13.770 Emily Giant: Yeah, I also think that there’s a lot of utility in, like, you can do, user access groups and stuff, so if there’s certain things that we can tie into…
311 00:26:13.920 ⇒ 00:26:16.699 Emily Giant: the modeling, so that…
312 00:26:17.090 ⇒ 00:26:24.969 Emily Giant: maybe there aren’t 10 to 15 explorers, maybe there are 7, but, like, when care gets on to,
313 00:26:25.090 ⇒ 00:26:35.510 Emily Giant: the… sales or, like, orders view. Maybe they don’t see all of the, forecast stuff.
314 00:26:35.620 ⇒ 00:26:52.550 Emily Giant: Because they’ll never need that. But there are certain people that will need forecasts definitely tied to sales. And my experience with how people use Looker is that they’re gonna go… tell me if I’m wrong, PK… they’re gonna find one explorer, and they’re gonna use it for literally everything, and they’re never gonna look at any of the other ones.
315 00:26:53.090 ⇒ 00:26:54.350 pk.arthur: You’re actually right.
316 00:26:54.350 ⇒ 00:26:54.780 Emily Giant: Yeah.
317 00:26:54.780 ⇒ 00:26:57.609 pk.arthur: I’d be… Guilty of that, too, sometimes.
318 00:26:57.610 ⇒ 00:26:58.220 Emily Giant: Every…
319 00:26:58.220 ⇒ 00:27:02.759 Uttam Kumaran: No, it’s, I mean, it’s pretty clear from the data, too, that, like, most of the people are just using, like.
320 00:27:03.210 ⇒ 00:27:06.500 Uttam Kumaran: These, these couple of main ones.
321 00:27:07.740 ⇒ 00:27:09.960 Uttam Kumaran: Like, sales data, yeah.
322 00:27:10.150 ⇒ 00:27:12.389 Emily Giant: Alright, this is so small, but yeah.
323 00:27:12.640 ⇒ 00:27:14.300 Uttam Kumaran: Okay, cool, so…
324 00:27:14.300 ⇒ 00:27:21.039 Emily Giant: Using that function will help us a lot, so that we’re not, like, Creating Explorers that nobody uses.
325 00:27:22.080 ⇒ 00:27:22.710 Uttam Kumaran: Okay.
326 00:27:23.320 ⇒ 00:27:28.850 Uttam Kumaran: So yeah, we could totally do groups. I guess, can you, is there…
327 00:27:29.210 ⇒ 00:27:34.089 Uttam Kumaran: And a work chart, and, like, should we adhere to that? Or, like, is it more, like, functional groups?
328 00:27:34.390 ⇒ 00:27:36.710 Uttam Kumaran: Like, what do you think, guys?
329 00:27:37.270 ⇒ 00:27:41.509 Uttam Kumaran: Okay, yeah, can we list that, and then I can…
330 00:27:41.890 ⇒ 00:27:52.050 Uttam Kumaran: it’s fine if people land in more than one group, but ideally, the way to think about groups, and I don’t know, Wish, let me know if you have a different opinion, but some groups will have access
331 00:27:52.400 ⇒ 00:28:03.729 Uttam Kumaran: to, like, various Explorers, some groups will have access to deeper parts of an Explorer. You only want some people with customer PII access. So what you’ll do is basically create a group
332 00:28:04.230 ⇒ 00:28:17.050 Uttam Kumaran: that’s, like, basically, you’ll have a role that’s, like, PII access, and then… or a user attribute that’s, like, PII access, and then no matter what group you’re in, if you have that… so there’s a couple of different ways of architecting this.
333 00:28:17.150 ⇒ 00:28:19.289 Emily Giant: Ideally, it’s a mix of roles.
334 00:28:19.460 ⇒ 00:28:23.590 Uttam Kumaran: Which are… like, we should… we kind of already are…
335 00:28:23.950 ⇒ 00:28:27.490 Uttam Kumaran: there’s a bunch here, I’ll also probably slim this down.
336 00:28:27.970 ⇒ 00:28:33.279 Uttam Kumaran: But yeah, maybe we could start by articulating the groups, then I can ask some questions about roles.
337 00:28:34.090 ⇒ 00:28:35.409 Emily Giant: Yeah, I’d say marketing.
338 00:28:36.120 ⇒ 00:28:36.720 Uttam Kumaran: Okay?
339 00:28:37.490 ⇒ 00:28:39.909 Emily Giant: And then… Customer care.
340 00:28:40.790 ⇒ 00:28:41.380 Uttam Kumaran: Okay?
341 00:28:43.320 ⇒ 00:28:50.900 Emily Giant: Like… okay, so… finance and…
342 00:28:51.140 ⇒ 00:28:56.140 Emily Giant: Sales and operations planning are, like, so the same to me in my brain.
343 00:28:56.440 ⇒ 00:28:57.880 Emily Giant: Outside of that…
344 00:28:57.880 ⇒ 00:28:59.589 Uttam Kumaran: They can be part of… they can be part of two groups.
345 00:28:59.590 ⇒ 00:29:00.310 Emily Giant: Okay.
346 00:29:00.560 ⇒ 00:29:00.990 Uttam Kumaran: to St.
347 00:29:00.990 ⇒ 00:29:01.680 Emily Giant: people.
348 00:29:01.830 ⇒ 00:29:08.600 Emily Giant: And then, SNIP won’t need, transactions, though. Like, that transaction data.
349 00:29:09.080 ⇒ 00:29:14.520 Emily Giant: So maybe we do split them out, and then once, there’s a…
350 00:29:15.390 ⇒ 00:29:32.919 Emily Giant: a bunch going on with NetSuite that they’re gonna start putting in, like, the QuickBooks stuff, so that will eventually need to be separate, so might as well just make them separate now. And then I would say, like, fulfillment operations, or… I’m trying to think of what to call, like… supply chain, sorry, supply chain.
351 00:29:34.070 ⇒ 00:29:34.630 Uttam Kumaran: Okay.
352 00:29:42.530 ⇒ 00:29:45.999 Emily Giant: Marketing, customer care, finance, S&P, Supply Chain.
353 00:29:46.480 ⇒ 00:29:51.120 Emily Giant: Mmm… PK, can you think of any others?
354 00:29:51.890 ⇒ 00:29:57.039 Emily Giant: Or Demolade, I know you’ve talked with so many humans at this organization.
355 00:30:00.780 ⇒ 00:30:03.200 Demilade Agboola: Mmm… no.
356 00:30:04.870 ⇒ 00:30:08.520 pk.arthur: Yeah, I don’t think so either, too. I think you might have hit all.
357 00:30:09.470 ⇒ 00:30:13.460 Demilade Agboola: Where will, Felipe… Fall under here.
358 00:30:13.700 ⇒ 00:30:17.130 Emily Giant: Both SNFP and supply chain.
359 00:30:17.270 ⇒ 00:30:22.489 Emily Giant: It’s a great question, though. He is in both teams equally. And one of the only ones, so…
360 00:30:23.410 ⇒ 00:30:28.460 Emily Giant: But SNOP and some of the… so, like, supply chain won’t need
361 00:30:29.410 ⇒ 00:30:37.810 Emily Giant: Much of the revenue data, is my understanding, but they’ll need all of the, like, sales and inventory data, and…
362 00:30:39.120 ⇒ 00:30:43.139 Emily Giant: plus the, like, delivery data, like FedEx…
363 00:30:43.340 ⇒ 00:30:49.190 Emily Giant: etc. All of that, like, inventory snapshot, are things sending optimally type data?
364 00:30:50.850 ⇒ 00:30:55.980 Emily Giant: But definitely, like, intermixed, those two. There’ll be a lot of similarities, but…
365 00:30:56.010 ⇒ 00:30:56.960 Uttam Kumaran: Okay. Yeah.
366 00:31:01.830 ⇒ 00:31:04.180 Emily Giant: But that’s… I really think that might be it.
367 00:31:04.530 ⇒ 00:31:08.610 Emily Giant: e-com, maybe, but I feel like e-comm and… .
368 00:31:09.750 ⇒ 00:31:10.130 Uttam Kumaran: today.
369 00:31:10.130 ⇒ 00:31:11.750 pk.arthur: Marketing.
370 00:31:11.750 ⇒ 00:31:12.730 Emily Giant: Yeah.
371 00:31:12.730 ⇒ 00:31:13.380 pk.arthur: Yeah.
372 00:31:15.190 ⇒ 00:31:27.679 Uttam Kumaran: But let’s create a look, like, ideally, we can’t… you can never have too many groups, but, like, if groups are the same people, then they can be redundant. So, it’s fine if they are the same people, like, as long as it’s not more than 10 or so.
373 00:31:28.070 ⇒ 00:31:34.240 Uttam Kumaran: this is fine if they’re all the same people, and I… you can be in both, and that way it’s at least clear for the future.
374 00:31:34.610 ⇒ 00:31:35.500 Emily Giant: Yeah.
375 00:31:37.190 ⇒ 00:31:41.950 Uttam Kumaran: Okay, then talk to me about, like, roles, so I don’t… I’m not too concerned about…
376 00:31:42.170 ⇒ 00:31:50.400 Uttam Kumaran: admin developer, but let’s talk about Explore… Versus viewer…
377 00:31:50.700 ⇒ 00:31:56.159 Uttam Kumaran: like, do you guys have a clear sense of that? Like, to give you a reason why
378 00:31:56.350 ⇒ 00:32:00.829 Uttam Kumaran: like, I’m not just… why this is important is, like, that’s what’s driving the cost up.
379 00:32:01.410 ⇒ 00:32:13.959 Uttam Kumaran: So for Zach, what I’d like to deliver is, like, hey, we’re… we went through and looked at everything, and we’re able to now move these people from Explore to Vue. Some of these people on Vue no longer even need it, so they can… they can just get
380 00:32:14.330 ⇒ 00:32:15.310 Uttam Kumaran: Kicked.
381 00:32:15.400 ⇒ 00:32:18.009 Emily Giant: That’s, like, kind of the things that I want to focus on.
382 00:32:18.380 ⇒ 00:32:25.250 Emily Giant: So, I just did a, a refresh of all of that, but what we need to do still is, like.
383 00:32:25.590 ⇒ 00:32:35.039 Emily Giant: the entire supply chain team has Explore Access, and they just need, like, one email address, because they’re not doing anything that is confidential.
384 00:32:35.370 ⇒ 00:32:48.679 Emily Giant: to one another. They’re just… and you can do, like, group seats on Looker. And they’re not doing, like, dashboard building a lot, but they’re doing a lot of, like, one-off queries of things to get answers, so they all need it, but they’re not, like…
385 00:32:49.490 ⇒ 00:32:54.460 Emily Giant: Needing it in a sustaining… Analyst type of way.
386 00:32:55.690 ⇒ 00:32:58.059 Uttam Kumaran: Yeah, the promise you can’t… we can’t,
387 00:32:58.290 ⇒ 00:33:01.279 Uttam Kumaran: So you’re saying they would just use one email address, or what do you think?
388 00:33:02.660 ⇒ 00:33:04.050 Emily Giant: Potentially.
389 00:33:04.760 ⇒ 00:33:06.140 Uttam Kumaran: Are they doing that now?
390 00:33:06.140 ⇒ 00:33:07.010 Emily Giant: -
391 00:33:07.320 ⇒ 00:33:07.980 Uttam Kumaran: Okay.
392 00:33:08.770 ⇒ 00:33:11.259 Uttam Kumaran: Okay, so I’ll just put that as a possibility.
393 00:33:12.140 ⇒ 00:33:15.639 Uttam Kumaran: So SNOP could share one user.
394 00:33:16.000 ⇒ 00:33:16.710 Emily Giant: Yeah.
395 00:33:19.070 ⇒ 00:33:24.270 Uttam Kumaran: And then if we looked at, like, Explorer, for example.
396 00:33:27.060 ⇒ 00:33:29.720 Emily Giant: I actually have a… what’s it called?
397 00:33:29.870 ⇒ 00:33:32.710 Emily Giant: Confluence article that has everyone listed.
398 00:33:32.910 ⇒ 00:33:33.760 Uttam Kumaran: Oh, nice, okay.
399 00:33:33.760 ⇒ 00:33:37.239 Emily Giant: And, like, my ideas of how to consolidate.
400 00:33:46.650 ⇒ 00:33:49.269 Uttam Kumaran: I mean, Awash, like, what’s the best thing? We should do group?
401 00:33:51.120 ⇒ 00:33:51.670 Uttam Kumaran: role.
402 00:33:52.270 ⇒ 00:33:56.750 Uttam Kumaran: like, in the group. Like, Customer Care Explorer, Customer Care Analyst.
403 00:33:59.090 ⇒ 00:33:59.900 Awaish Kumar: like…
404 00:34:01.430 ⇒ 00:34:10.529 Uttam Kumaran: Because I don’t want… I don’t… I don’t like what this… like, we shouldn’t assign… you shouldn’t assign the roles to users, right? So we should assign it to groups.
405 00:34:10.679 ⇒ 00:34:16.810 Uttam Kumaran: the groups, I would suggest we should just do, like, Customer Care, Explorer, right?
406 00:34:18.659 ⇒ 00:34:23.059 Awaish Kumar: Okay, and in the groups, we can define, like, which explore they can access.
407 00:34:24.639 ⇒ 00:34:26.699 Uttam Kumaran: Yeah, so everything rolls up to groups.
408 00:34:27.380 ⇒ 00:34:29.820 Uttam Kumaran: There shouldn’t be any direct access granted.
409 00:34:31.590 ⇒ 00:34:38.059 Uttam Kumaran: Because ideally, someone joins Urban Stems, they get tossed in a group, they get everything they need, versus, like, to go press this 10 other times.
410 00:34:38.060 ⇒ 00:34:38.830 Emily Giant: Yeah.
411 00:34:41.069 ⇒ 00:34:41.949 Awaish Kumar: Nope.
412 00:34:42.400 ⇒ 00:34:46.519 Uttam Kumaran: And then who, like, who on here, Emily, like, needs to see, like, PII data? Is that, like…
413 00:34:47.420 ⇒ 00:34:50.660 Uttam Kumaran: We could talk about that during this whole process, too, like…
414 00:34:50.840 ⇒ 00:34:55.580 Uttam Kumaran: PII data typically is, like, email, phone number, address.
415 00:34:56.679 ⇒ 00:34:58.709 Emily Giant: Marketing and Supply Chain.
416 00:35:00.780 ⇒ 00:35:01.960 Emily Giant: Any thumb, I guess.
417 00:35:02.160 ⇒ 00:35:03.420 Emily Giant: Because they’re similar.
418 00:35:04.410 ⇒ 00:35:05.929 pk.arthur: Oh, a customer care right now.
419 00:35:07.020 ⇒ 00:35:08.010 Emily Giant: Oh, yeah.
420 00:35:08.010 ⇒ 00:35:08.440 Uttam Kumaran: Yeah.
421 00:35:08.440 ⇒ 00:35:09.310 Emily Giant: Me too.
422 00:35:09.700 ⇒ 00:35:12.600 Uttam Kumaran: So, okay, so, like, well, I guess they all need it.
423 00:35:12.600 ⇒ 00:35:15.989 Emily Giant: Everyone does, yeah. They need different elements of it, but…
424 00:35:17.710 ⇒ 00:35:18.410 Uttam Kumaran: Okay.
425 00:35:27.110 ⇒ 00:35:27.910 Uttam Kumaran: Okay?
426 00:35:30.580 ⇒ 00:35:34.160 Uttam Kumaran: And then let’s talk about, while we’re in here, let’s talk about folders.
427 00:35:36.070 ⇒ 00:35:45.980 Uttam Kumaran: Any… like… Thoughts on how we should… Do content folders.
428 00:35:47.230 ⇒ 00:35:51.759 Uttam Kumaran: Like, would you rather have it aligned with the parts of the org?
429 00:35:52.140 ⇒ 00:35:52.910 Emily Giant: Yes.
430 00:35:53.170 ⇒ 00:35:54.520 Emily Giant: I think so. Okay.
431 00:35:54.880 ⇒ 00:35:56.829 Uttam Kumaran: Because right now, they’re pretty functional.
432 00:35:57.740 ⇒ 00:36:00.589 Uttam Kumaran: Like, they’re related to, like, parts of…
433 00:36:01.250 ⇒ 00:36:03.509 Emily Giant: I think that that’s how people…
434 00:36:04.050 ⇒ 00:36:08.610 Emily Giant: Conceptualize them, and then people build their own, like, boards.
435 00:36:09.320 ⇒ 00:36:12.570 Emily Giant: For things that are interdepartmental.
436 00:36:17.320 ⇒ 00:36:20.839 Awaish Kumar: Yeah, similar to the deep smarts, we can have…
437 00:36:22.130 ⇒ 00:36:28.240 Awaish Kumar: Marketing, and under marketing, it can be multiple different… sub… subdomains.
438 00:36:31.340 ⇒ 00:36:32.030 Uttam Kumaran: Okay.
439 00:36:34.990 ⇒ 00:36:40.910 Uttam Kumaran: Yeah, I just wanna make sure, like, I wanna make… right now, there’s too many, like, top-level Burps.
440 00:36:42.180 ⇒ 00:36:53.229 Uttam Kumaran: So ideally, I mean, look, I’ll probably look through and be able to cut, like, half of these, just for being, like, not useful, toss the rest under something else, and ideally, we have…
441 00:36:54.550 ⇒ 00:36:55.920 Awaish Kumar: basically…
442 00:36:56.190 ⇒ 00:37:00.170 Uttam Kumaran: Each of these gets their own… area.
443 00:37:00.370 ⇒ 00:37:04.729 Uttam Kumaran: people from other divisions can go into there. That’ll be up to…
444 00:37:05.170 ⇒ 00:37:07.699 Uttam Kumaran: To you guys, but yeah, that should be okay.
445 00:37:09.300 ⇒ 00:37:13.850 Uttam Kumaran: Okay.
446 00:37:16.550 ⇒ 00:37:26.930 Uttam Kumaran: And then I guess, like, let’s… while we’re also talking about Looker, like, can we talk about, like, naming conventions within Explorers? Like, let’s go into sales, for example,
447 00:37:31.510 ⇒ 00:37:42.429 Uttam Kumaran: Like, were we, opinionated on, like, how we named… Dates, dimensions, measures at all?
448 00:37:45.270 ⇒ 00:37:47.060 Emily Giant: I am.
449 00:37:47.060 ⇒ 00:37:47.720 Uttam Kumaran: Okay.
450 00:37:48.860 ⇒ 00:37:51.599 Emily Giant: Like, open order ready by date.
451 00:37:51.770 ⇒ 00:37:53.230 Emily Giant: Under capacities.
452 00:37:55.110 ⇒ 00:37:58.220 Emily Giant: I hate when it’s, like, order ready by date date. So…
453 00:37:58.220 ⇒ 00:38:01.659 Uttam Kumaran: Oh, I… yeah, I know, I just, like, I’m gonna blow my brains out.
454 00:38:01.660 ⇒ 00:38:07.849 Emily Giant: So, yeah, exactly. So, I’m very opinionated about that, like, let’s not put date in there twice.
455 00:38:08.030 ⇒ 00:38:11.419 Emily Giant: Like, delivery date month, or delivery date date month.
456 00:38:11.420 ⇒ 00:38:17.450 Uttam Kumaran: Well, yeah, I’m also like, look, are people using, like, all of these date dimensions?
457 00:38:17.580 ⇒ 00:38:24.499 Emily Giant: And name them better. Like… I don’t even know, it’s always, like, created at. I’m like, created what at?
458 00:38:24.500 ⇒ 00:38:24.930 pk.arthur: Yeah.
459 00:38:24.930 ⇒ 00:38:25.490 Emily Giant: Yeah.
460 00:38:25.490 ⇒ 00:38:26.870 pk.arthur: That’s very confusing.
461 00:38:26.870 ⇒ 00:38:27.640 Emily Giant: Yeah.
462 00:38:30.460 ⇒ 00:38:34.150 Uttam Kumaran: So one thing that I’d like to do, if we talk about a, like.
463 00:38:34.710 ⇒ 00:38:39.259 Uttam Kumaran: So this is on license, let’s do… we’ll talk about, like, explore…
464 00:38:41.790 ⇒ 00:38:44.900 Uttam Kumaran: We want to also consider,
465 00:38:45.810 ⇒ 00:38:50.330 Uttam Kumaran: naming conventions. I think this is something, I wish we can think about, like.
466 00:38:51.560 ⇒ 00:38:57.849 Uttam Kumaran: If we can pull a report of all… Metrics, measures, and columns.
467 00:38:57.970 ⇒ 00:39:01.260 Uttam Kumaran: And then we can do… we can use AI to do a little bit of, like, a rename.
468 00:39:02.490 ⇒ 00:39:07.089 Uttam Kumaran: Ideally, like, we don’t need to change the underlying SQL, it’s just a display label.
469 00:39:07.690 ⇒ 00:39:12.639 Uttam Kumaran: So… It’s just… it’s fine as long as we kind of, like, do it carefully.
470 00:39:12.930 ⇒ 00:39:20.740 Uttam Kumaran: So, naming, we also have, like… and… okay, so we have that.
471 00:39:25.620 ⇒ 00:39:30.109 Uttam Kumaran: Yeah, I mean, like, for me, this is just, like, oh, it’s so hard to use.
472 00:39:30.250 ⇒ 00:39:36.270 Uttam Kumaran: So we’ll have to think about, like, how we… how we restructure.
473 00:39:40.700 ⇒ 00:39:42.900 Uttam Kumaran: That’ll be fun.
474 00:39:44.390 ⇒ 00:39:46.669 Uttam Kumaran: Wanna get rid of, like, these generic counts.
475 00:39:52.970 ⇒ 00:40:03.290 Emily Giant: Also, there’s a big issue with, like, fields that should be… sums?
476 00:40:03.550 ⇒ 00:40:11.079 Emily Giant: are… displayed as numbers, and thus are not filterable, so we have to be able to…
477 00:40:11.820 ⇒ 00:40:16.359 Emily Giant: Make sure that every field is Typecast correctly.
478 00:40:21.660 ⇒ 00:40:22.330 Uttam Kumaran: Okay.
479 00:40:23.870 ⇒ 00:40:24.750 Uttam Kumaran: Fair.
480 00:40:30.900 ⇒ 00:40:38.220 Uttam Kumaran: like, and this is another example. If an explorer is just one dimension, you can change the ex… the…
481 00:40:38.690 ⇒ 00:40:44.869 Uttam Kumaran: If a view is just one dimension, you can change the view name so that it’ll just pop up into the one it’s joining to.
482 00:40:44.870 ⇒ 00:40:45.460 Emily Giant: Yeah.
483 00:40:45.460 ⇒ 00:40:50.679 Uttam Kumaran: That way you don’t get, like, multiple, and the user doesn’t really care, right? So, this is sort of like…
484 00:40:50.680 ⇒ 00:41:04.169 Emily Giant: with the new, like, or even making certain views, you can tie them together so that one only shows… it only shows up if you’re using… Yeah. Yeah. I think we’re probably saying the same thing.
485 00:41:04.170 ⇒ 00:41:05.999 Uttam Kumaran: Yeah, exactly. No, you’re right, you’re right.
486 00:41:16.550 ⇒ 00:41:17.470 Uttam Kumaran: Okay.
487 00:41:18.840 ⇒ 00:41:20.390 Uttam Kumaran: What else am I missing?
488 00:41:21.850 ⇒ 00:41:26.649 Uttam Kumaran: So these I feel good about. This one will be pretty easy, which we can run a query on the PDTs.
489 00:41:28.020 ⇒ 00:41:32.409 Uttam Kumaran: I’ll do a little bit of, like, a look-through on users.
490 00:41:32.670 ⇒ 00:41:35.180 Uttam Kumaran: I’ll propose a new structure for groups.
491 00:41:35.780 ⇒ 00:41:42.130 Uttam Kumaran: And then, I think probably the only thing, Emily, I may ask you for is, like, who needs access?
492 00:41:42.130 ⇒ 00:41:42.840 Emily Giant: Okay.
493 00:41:43.320 ⇒ 00:41:54.880 Uttam Kumaran: Basically, what I’ll also do is I’m just gonna pull a, full report of… Like, last used.
494 00:41:55.120 ⇒ 00:41:56.279 Uttam Kumaran: by user.
495 00:41:56.690 ⇒ 00:42:01.129 Uttam Kumaran: Did they use Dash, Explore, like, what exactly they did?
496 00:42:01.480 ⇒ 00:42:06.810 Uttam Kumaran: And then that’ll at least give us some… thing. I mean, again, Zach’s…
497 00:42:07.170 ⇒ 00:42:10.360 Uttam Kumaran: directive was, like, look, some people should just go straight to Shopify.
498 00:42:10.730 ⇒ 00:42:18.020 Uttam Kumaran: So, hopefully there’s some people that are like that, that can go direct, don’t need Looker, or they can share a login, we can facilitate that.
499 00:42:19.400 ⇒ 00:42:23.060 Uttam Kumaran: Okay, and then let’s talk about,
500 00:42:25.610 ⇒ 00:42:29.709 Uttam Kumaran: naming conventions, like, within the dbt… within the Looker project.
501 00:42:30.170 ⇒ 00:42:35.460 Uttam Kumaran: So this is, again, where we want to organize. Honestly, we want to organize this
502 00:42:35.610 ⇒ 00:42:38.840 Uttam Kumaran: varies… basically identically to dbt.
503 00:42:40.220 ⇒ 00:42:43.700 Uttam Kumaran: So, if there are no…
504 00:42:43.980 ⇒ 00:42:46.319 Uttam Kumaran: objections to that, then I think…
505 00:42:46.480 ⇒ 00:42:50.160 Uttam Kumaran: what I would propose, if we haven’t done already, is for, like.
506 00:42:50.910 ⇒ 00:42:57.230 Uttam Kumaran: we just rename this to Inventory Mart. We just actually just match the skee… the…
507 00:42:57.550 ⇒ 00:43:00.610 Uttam Kumaran: dbt folder name with this name.
508 00:43:00.930 ⇒ 00:43:02.940 Uttam Kumaran: That way, it reduces one decision.
509 00:43:03.330 ⇒ 00:43:07.470 Uttam Kumaran: So always the Looker folder should match the dbt folder, basically.
510 00:43:08.700 ⇒ 00:43:09.270 Emily Giant: Yeah.
511 00:43:10.750 ⇒ 00:43:15.940 Uttam Kumaran: So that’s something also that I want to put down, here, which is, like.
512 00:43:16.390 ⇒ 00:43:21.659 Uttam Kumaran: Looker code, so we want to match folders to smart folders.
513 00:43:21.980 ⇒ 00:43:26.039 Uttam Kumaran: Match view names to table view names.
514 00:43:28.630 ⇒ 00:43:36.059 Uttam Kumaran: Yeah, I can take a look at which models we want to remove, too.
515 00:43:38.410 ⇒ 00:43:43.519 Uttam Kumaran: and collapse as many views. I mean, the nice thing is this is, like, doesn’t… it doesn’t necessarily affect
516 00:43:44.230 ⇒ 00:43:48.939 Uttam Kumaran: Like, some of the stuff on the content side, so we can make a bunch of changes here pretty easily.
517 00:43:49.420 ⇒ 00:43:52.640 Uttam Kumaran: Like, let’s say if we were taking a look at,
518 00:43:55.960 ⇒ 00:44:02.610 Uttam Kumaran: Yeah, I mean, I’m not… like, now that we have the ability to use cursor, I feel better that we could do descriptions.
519 00:44:03.140 ⇒ 00:44:05.019 Uttam Kumaran: Like, more effectively.
520 00:44:05.460 ⇒ 00:44:09.890 Uttam Kumaran: You know, so that may be something that I’ll… I’ll look into if it’s possible.
521 00:44:13.870 ⇒ 00:44:19.699 Uttam Kumaran: But ideally, kind of, like, I want to be able to see that our, like, validation times go down.
522 00:44:20.330 ⇒ 00:44:24.139 Uttam Kumaran: I want to see that we have no content validation errors.
523 00:44:24.540 ⇒ 00:44:26.810 Uttam Kumaran: That’s gonna be really, like, what I’m looking for.
524 00:44:26.810 ⇒ 00:44:27.390 Emily Giant: Yeah.
525 00:44:27.870 ⇒ 00:44:36.169 Uttam Kumaran: There’s a lot, That will be, like, a one-by-one-by-one sort of deal, like a… take a couple today.
526 00:44:42.270 ⇒ 00:44:52.950 Uttam Kumaran: Yeah, and then the other thing is, like, for example, if we want some people to see a join versus not, we would put a user attribute or a group filter here.
527 00:44:53.160 ⇒ 00:44:56.190 Uttam Kumaran: And then they could see certain views or don’t see certain views.
528 00:44:56.810 ⇒ 00:45:02.889 Uttam Kumaran: yeah, and then stuff like this, we just want to, like, completely avoid.
529 00:45:03.620 ⇒ 00:45:04.230 Emily Giant: Yeah.
530 00:45:04.400 ⇒ 00:45:08.470 Uttam Kumaran: Okay.
531 00:45:09.160 ⇒ 00:45:14.830 Uttam Kumaran: So I feel like I have enough from our conversation now to… propose…
532 00:45:15.410 ⇒ 00:45:24.090 Uttam Kumaran: at least a few of the Explore, immediate explore deprecations. Once the Explorers are deprecated, I can isolate
533 00:45:24.310 ⇒ 00:45:26.490 Uttam Kumaran: views that no longer have an Explorer.
534 00:45:26.750 ⇒ 00:45:28.580 Uttam Kumaran: Ditch… start to ditch those.
535 00:45:29.040 ⇒ 00:45:34.189 Uttam Kumaran: If an explorer is… has been… if it… if…
536 00:45:34.660 ⇒ 00:45:41.020 Uttam Kumaran: If there’s an Explorer, Emily, that you mentioned that I noticed has a recent query, I’ll isolate for you what the
537 00:45:41.320 ⇒ 00:45:43.950 Uttam Kumaran: Dashboard title is, tile is, and we’ll sort of…
538 00:45:44.980 ⇒ 00:45:47.339 Uttam Kumaran: Kinda go one by one and clear those out.
539 00:45:47.760 ⇒ 00:45:48.650 Emily Giant: Yep.
540 00:45:48.650 ⇒ 00:45:51.749 Uttam Kumaran: Well, then once… once those are cleared, we’ll be in the clear, at least on…
541 00:45:51.910 ⇒ 00:45:56.480 Uttam Kumaran: Core Explorers, and then we can move on to…
542 00:45:56.760 ⇒ 00:45:59.269 Uttam Kumaran: Groups and roles and things like that, so…
543 00:45:59.390 ⇒ 00:46:12.930 Uttam Kumaran: That’ll be helpful. And then, ideally, at the end of this, also, we want to end up with the new Explorer. So once we end up with the cohort of explorers that we’re… that we know are still used, I want to map the ones that we want to migrate over.
544 00:46:12.930 ⇒ 00:46:14.649 Emily Giant: So that migration…
545 00:46:14.950 ⇒ 00:46:19.590 Uttam Kumaran: like… The thing to avoid here is if we create a new explorer.
546 00:46:19.710 ⇒ 00:46:22.050 Uttam Kumaran: We have to create all that new content again.
547 00:46:22.290 ⇒ 00:46:27.170 Uttam Kumaran: So my question is… In what situations is that worth it?
548 00:46:27.310 ⇒ 00:46:33.080 Uttam Kumaran: like… Are there dashboards that you just want to rewrite entirely?
549 00:46:33.500 ⇒ 00:46:37.100 Uttam Kumaran: Because it’d be too complicated to go, like, column by column by column.
550 00:46:38.590 ⇒ 00:46:43.559 Uttam Kumaran: Are there… Things that, like, that we do actually just want to…
551 00:46:47.610 ⇒ 00:46:54.680 Emily Giant: I think we just need to rebuild them with the new one. I don’t see how else…
552 00:46:54.990 ⇒ 00:47:03.730 Emily Giant: I think that might honestly be the fastest way, is to just, like, side-by-side rebuild them. Whenever I try to use the content validator, it’s…
553 00:47:04.710 ⇒ 00:47:07.270 Emily Giant: It’s, like, more trouble than worth.
554 00:47:07.520 ⇒ 00:47:08.160 Uttam Kumaran: Okay.
555 00:47:08.310 ⇒ 00:47:10.339 Uttam Kumaran: Yeah, it just depends on,
556 00:47:10.820 ⇒ 00:47:18.749 Uttam Kumaran: how big some of the dashboards are. Yeah. But I agree, like, I would prefer to build it… so I would prefer to prefer to rebuild entirely.
557 00:47:18.750 ⇒ 00:47:20.669 Emily Giant: Me too.
558 00:47:20.990 ⇒ 00:47:34.899 Uttam Kumaran: Okay, so I can also start… so that’ll be helpful, again, like, once we kill the… once we kill a bunch of the explorers, kill… I’ll try to… we should remove, like, 50% of things. What we’re left with, we may have to go kind of one by one and make decisions.
559 00:47:35.090 ⇒ 00:47:39.149 Uttam Kumaran: And then we’ll have tickets for, like, recreate this dashboard, recreate this dashboard, things like that.
560 00:47:39.150 ⇒ 00:47:40.180 Emily Giant: Yeah.
561 00:47:40.500 ⇒ 00:47:43.880 Uttam Kumaran: Faster, should be easier to debug, things like that, so…
562 00:47:45.800 ⇒ 00:47:46.710 Emily Giant: Alright.
563 00:47:47.590 ⇒ 00:47:52.520 Uttam Kumaran: Okay, great. So let me write some of this up, and then, yeah, I may try to even just…
564 00:47:52.870 ⇒ 00:47:54.989 Uttam Kumaran: Get some of this explore work done this week.
565 00:47:55.350 ⇒ 00:47:55.920 Emily Giant: Okay?
566 00:47:56.780 ⇒ 00:47:57.860 Emily Giant: Yeah.
567 00:47:58.700 ⇒ 00:48:00.510 Uttam Kumaran: Anything else for today?
568 00:48:02.210 ⇒ 00:48:03.380 Emily Giant: I don’t think so.
569 00:48:06.800 ⇒ 00:48:09.799 Uttam Kumaran: Okay, and then this one, I’m just seeing what you sent in.
570 00:48:10.100 ⇒ 00:48:14.260 Emily Giant: That’s just the current Looker views… viewer access levels.
571 00:48:26.020 ⇒ 00:48:28.079 Uttam Kumaran: Nice, this is great.
572 00:48:39.460 ⇒ 00:48:44.509 Uttam Kumaran: Okay, perfect. Alright, that’s all I needed. I’ll just go do some damage.
573 00:48:44.970 ⇒ 00:48:45.900 Emily Giant: Yay!
574 00:48:46.490 ⇒ 00:48:49.210 Uttam Kumaran: Exactly.
575 00:48:49.860 ⇒ 00:48:51.560 Uttam Kumaran: Okay, alright, thank you.
576 00:48:51.560 ⇒ 00:48:52.860 Emily Giant: Have fun. Bye.
577 00:48:53.790 ⇒ 00:48:54.280 Demilade Agboola: Bye.