Meeting Title: PP2G-Intro-for-Suraj Date: 2024-08-21 Meeting participants: Ryan Luke Daque, Suraj, Nicolas Sucari
WEBVTT
1 00:01:32.100 ⇒ 00:01:33.169 Nicolas Sucari: Hey sureash!
2 00:01:33.800 ⇒ 00:01:34.790 suraj: Hey, Nicholas.
3 00:01:36.360 ⇒ 00:01:37.269 Nicolas Sucari: How are you?
4 00:01:37.470 ⇒ 00:01:38.120 suraj: Doing, good.
5 00:01:38.120 ⇒ 00:01:38.720 Ryan Luke Daque: One!
6 00:01:39.770 ⇒ 00:01:40.380 Ryan Luke Daque: Hey! Roy!
7 00:01:40.380 ⇒ 00:01:41.030 Nicolas Sucari: I am
8 00:01:45.840 ⇒ 00:01:48.750 Nicolas Sucari: okay. How is everything going through ash?
9 00:01:49.703 ⇒ 00:01:54.186 suraj: Going good so I’m I’m looking at the the tools
10 00:01:54.670 ⇒ 00:01:59.799 suraj: and notion exploring the stuff, and even looking at the tables and views in Snowflake.
11 00:02:01.410 ⇒ 00:02:02.660 Nicolas Sucari: Nice. Okay?
12 00:02:02.970 ⇒ 00:02:09.330 Nicolas Sucari: 1st of all, I want to introduce you to Ryan Ryan. Been working. I don’t know for how long now, Ryan.
13 00:02:09.560 ⇒ 00:02:10.380 Nicolas Sucari: but
14 00:02:10.789 ⇒ 00:02:13.989 Nicolas Sucari: yeah, longer than me in Brainford.
15 00:02:15.080 ⇒ 00:02:22.139 Ryan Luke Daque: Yeah, I think I started last December. So how many months is that like 8 months? I guess.
16 00:02:22.140 ⇒ 00:02:24.642 Nicolas Sucari: Like, 8 months. Yeah, it’s a lot.
17 00:02:25.000 ⇒ 00:02:25.450 Ryan Luke Daque: Yeah.
18 00:02:25.450 ⇒ 00:02:27.270 suraj: Where are you based in Ryan?
19 00:02:27.270 ⇒ 00:02:29.450 Ryan Luke Daque: I’m in the Philippines at the moment, so.
20 00:02:29.450 ⇒ 00:02:32.589 suraj: Philippines. Oh, what time is it now?
21 00:02:32.910 ⇒ 00:02:33.805 Ryan Luke Daque: It’s
22 00:02:34.720 ⇒ 00:02:36.679 Ryan Luke Daque: 2 o’clock in the morning.
23 00:02:37.390 ⇒ 00:02:39.939 suraj: 2 o’clock in the morning. Oh, my God, okay.
24 00:02:40.210 ⇒ 00:02:43.349 suraj: Oh, we have all kind of time zones in the world.
25 00:02:43.350 ⇒ 00:02:44.840 Ryan Luke Daque: Yeah, we have all.
26 00:02:45.540 ⇒ 00:02:59.570 suraj: Yeah, I’m from India. I’m just, of course. Yeah, just beside Indonesians. I came to us almost 8 to 9 years ago. For my degree. So yeah, just working here.
27 00:03:01.270 ⇒ 00:03:01.910 Ryan Luke Daque: Cool.
28 00:03:01.910 ⇒ 00:03:02.650 Nicolas Sucari: Nice.
29 00:03:03.372 ⇒ 00:03:07.199 Nicolas Sucari: And yeah, we have every time zone on the team
30 00:03:08.860 ⇒ 00:03:10.500 Nicolas Sucari: these nights.
31 00:03:11.000 ⇒ 00:03:21.269 Nicolas Sucari: But yeah, Ryan is he handles all of the data modeling, or almost all of the data modeling that we are doing for pool parts. And
32 00:03:21.730 ⇒ 00:03:42.302 Nicolas Sucari: yeah. And I think right now, Ryan, you’re working also on some automation stuff working on some projects that we’re like more internally for a service like downloading email files into repos and getting all the information extracted from different sources into our snowflake data warehouse.
33 00:03:43.000 ⇒ 00:04:03.220 Nicolas Sucari: so yeah, I mean, he knows a lot of how these project on pull parts. How is how everything is handled, all of the different files and where to track data. And if we don’t know anything, we just go and try to dig everywhere to find a solution. So yeah, he’s here also to
34 00:04:04.590 ⇒ 00:04:14.809 Nicolas Sucari: answer any question that you have on the data that you will be looking on how things are handled, or any any stuff that you’d like to answer to
35 00:04:15.820 ⇒ 00:04:17.640 Nicolas Sucari: ideally today.
36 00:04:18.680 ⇒ 00:04:25.170 Nicolas Sucari: My! My idea was to walk through Github with you. I don’t know if you were able to create a user on Github.
37 00:04:26.500 ⇒ 00:04:28.000 suraj: Yes, I I did create.
38 00:04:29.120 ⇒ 00:04:35.280 Nicolas Sucari: Can you send me the username? Or did you create it under the brain forge email?
39 00:04:36.320 ⇒ 00:04:39.338 suraj: Yeah, I did create under Brentforce. Gmail.
40 00:04:39.940 ⇒ 00:04:42.899 suraj: it should be simple, sure.
41 00:04:44.590 ⇒ 00:04:47.320 Nicolas Sucari: Okay, I’m gonna try to invite you to the team.
42 00:04:48.400 ⇒ 00:04:50.320 suraj: Yeah, it is Suraj Gupta. That’s it.
43 00:04:53.140 ⇒ 00:04:54.610 Nicolas Sucari: Like, let me see
44 00:05:02.145 ⇒ 00:05:03.719 Nicolas Sucari: these devil factor.
45 00:05:04.962 ⇒ 00:05:06.499 Nicolas Sucari: Wait a minute.
46 00:05:20.890 ⇒ 00:05:23.940 Nicolas Sucari: and I’m gonna add you to the data team.
47 00:05:33.780 ⇒ 00:05:36.530 Nicolas Sucari: You should receive an invitation.
48 00:05:39.340 ⇒ 00:05:41.239 Nicolas Sucari: You can check your email.
49 00:05:44.050 ⇒ 00:05:45.530 suraj: Yeah, I just received.
50 00:05:46.980 ⇒ 00:05:47.610 Nicolas Sucari: Perfect.
51 00:05:57.800 ⇒ 00:06:02.569 Nicolas Sucari: So when you join you will see the bring for Ji Workspace.
52 00:06:06.000 ⇒ 00:06:06.370 suraj: Yeah.
53 00:06:06.370 ⇒ 00:06:07.560 Nicolas Sucari: Yeah, I wanna go.
54 00:06:07.850 ⇒ 00:06:09.300 suraj: Authenticator, app.
55 00:06:10.320 ⇒ 00:06:11.530 Nicolas Sucari: Yeah, you will need to.
56 00:06:11.620 ⇒ 00:06:14.180 Nicolas Sucari: Yeah, yeah, set your authenticator up.
57 00:06:18.490 ⇒ 00:06:19.180 suraj: Thank you.
58 00:06:31.260 ⇒ 00:06:33.120 Nicolas Sucari: And then I can share. And
59 00:06:34.600 ⇒ 00:06:36.120 Nicolas Sucari: so a little bit
60 00:06:36.150 ⇒ 00:06:38.149 Nicolas Sucari: how we are using the project
61 00:06:38.210 ⇒ 00:06:40.579 Nicolas Sucari: to track the issues and the tasks
62 00:06:40.950 ⇒ 00:06:42.760 Nicolas Sucari: and the Repos and everything.
63 00:07:00.980 ⇒ 00:07:01.690 suraj: Yep.
64 00:07:02.390 ⇒ 00:07:04.500 suraj: Okay. Recording.
65 00:07:07.110 ⇒ 00:07:08.490 Nicolas Sucari: Perfect. Yeah.
66 00:07:09.290 ⇒ 00:07:17.570 Nicolas Sucari: okay, so we have different repos. Probably the the main one that you’ll be using is full price to go.
67 00:07:18.200 ⇒ 00:07:26.619 Nicolas Sucari: This is where we have, like all of the code that we’re using, and also the code for the different visualization tools that we.
68 00:07:26.860 ⇒ 00:07:29.870 Nicolas Sucari: as we showed you yesterday, real and evident.
69 00:07:30.376 ⇒ 00:07:36.113 Nicolas Sucari: We didn’t show you evidence. We just show you real, I think. But yeah, we have like the folders here.
70 00:07:36.500 ⇒ 00:07:40.619 Nicolas Sucari: you’ll need to. Yeah, just to clone
71 00:07:40.650 ⇒ 00:07:49.710 Nicolas Sucari: the code onto your local environment. I think you can use this. I don’t know if you know how to do it or not. Not, we can go through it.
72 00:07:51.460 ⇒ 00:07:57.969 suraj: Yeah, i i i haven’t used Github much in the past. So I I’ll I’ll look into it today.
73 00:07:58.730 ⇒ 00:07:59.730 Nicolas Sucari: Okay, perfect.
74 00:08:00.180 ⇒ 00:08:07.350 Nicolas Sucari: Yeah, it’s not. It’s not that difficult. It’s just owning the code so that you can have it locally and run it with. I don’t know if you use this code or
75 00:08:07.380 ⇒ 00:08:15.820 Nicolas Sucari: any stuff like that. We use github desktop to to check the pull requests and preview what we are gonna commit. And that stuff.
76 00:08:17.580 ⇒ 00:08:19.159 Nicolas Sucari: and yeah, it’s just
77 00:08:19.860 ⇒ 00:08:28.320 Nicolas Sucari: normal stuff then, everything that you’ll see here is what in in it’s in the code we use 5 tran to
78 00:08:28.739 ⇒ 00:08:43.539 Nicolas Sucari: get data from different sources and extract and and extract and transform. We’re using Dbt, we get all of the data here into our code, and we use Snowflake to check everything as you will be
79 00:08:43.630 ⇒ 00:08:54.159 Nicolas Sucari: you. You already been watching Snowflake and trying to dig into the different tables. You see, kind of what is the information that we have? Do you have any question on anything about that?
80 00:08:54.913 ⇒ 00:09:03.110 suraj: Not on the snowflake part I’m I’m I have worked with the previous client about the snowflake and stuff so bit familiar with the thing.
81 00:09:03.140 ⇒ 00:09:09.380 suraj: So I’m I’ve already explored the views and the tables we are using. I think it’s the analytics data warehouse.
82 00:09:10.440 ⇒ 00:09:13.340 Nicolas Sucari: Yeah, yeah, exactly. They’re using analytics
83 00:09:13.764 ⇒ 00:09:22.740 Nicolas Sucari: for all of the analysis. Yeah. And if you go through here you’ll see everything under Mark. Probably you’ll see a lot of tables.
84 00:09:23.200 ⇒ 00:09:28.300 suraj: So the marty is the basically the all transactions from the pool part client.
85 00:09:30.080 ⇒ 00:09:34.069 Nicolas Sucari: Yeah, I think, like, we use all of these analytics tables to
86 00:09:34.680 ⇒ 00:09:42.479 Nicolas Sucari: figure out all of the information. Yeah, under mark, you’ll see all of what we are using for the different. Probably each of the different reports.
87 00:09:43.260 ⇒ 00:09:47.179 suraj: Got it. I I see. I think Mark Martin is a main schema here.
88 00:09:48.210 ⇒ 00:09:48.810 Nicolas Sucari: Yeah.
89 00:09:50.190 ⇒ 00:09:51.080 suraj: Yeah.
90 00:09:51.820 ⇒ 00:09:56.809 Ryan Luke Daque: Yeah, those are mostly the models that are being used in the dashboard. So
91 00:09:56.960 ⇒ 00:09:58.010 Ryan Luke Daque: yeah, yeah, okay.
92 00:09:59.380 ⇒ 00:10:01.550 Nicolas Sucari: Perfect. And then.
93 00:10:02.152 ⇒ 00:10:04.400 Nicolas Sucari: yeah, everything comes through
94 00:10:04.938 ⇒ 00:10:26.420 Nicolas Sucari: here. And then it gets everything in our in analytics. And we use this for creating all different dashboards. And what we need. So yeah, one, if if we need like new information here, if you’re not seeing a table or any information that you have that we need. It’s not here. We should yeah, talk to Ryan, probably, and see how we can get a new table or anything else.
95 00:10:26.420 ⇒ 00:10:26.850 suraj: Well.
96 00:10:27.166 ⇒ 00:10:30.330 Nicolas Sucari: Created from where we need that data from, okay.
97 00:10:30.330 ⇒ 00:10:36.979 suraj: Got it. So ran is our go go to Guy for everything related to data from scratch right?
98 00:10:37.670 ⇒ 00:10:41.249 Nicolas Sucari: I think. Well, it’s Patrick, too. Patrick handles.
99 00:10:41.250 ⇒ 00:10:41.590 suraj: Okay.
100 00:10:41.590 ⇒ 00:10:49.640 Nicolas Sucari: I think more of the integration with data sources. And then Ryan helps us on modeling and transforming the data. Right? Yeah.
101 00:10:50.290 ⇒ 00:10:51.270 suraj: So it’s good.
102 00:10:51.690 ⇒ 00:10:52.850 suraj: Yeah.
103 00:10:52.850 ⇒ 00:11:09.010 Nicolas Sucari: So, yeah, this is kind of what we have there on Github. And if we go back under the code, we have, like all of the different folders, all of how we are modeling the data. I think it’s here under DVD project, and you will see all of the models
104 00:11:09.348 ⇒ 00:11:16.839 Nicolas Sucari: we have under Mart. We have here all of the I don’t know. If you go to customers. We see all of the different files, and how we are
105 00:11:16.870 ⇒ 00:11:19.920 Nicolas Sucari: managing and transforming all of data.
106 00:11:21.980 ⇒ 00:11:32.299 Nicolas Sucari: and yeah, we use Github for creating all of the issues and creating all of the pull requests. So we have set up a project here. Project tracker.
107 00:11:32.993 ⇒ 00:11:34.319 Nicolas Sucari: Where we
108 00:11:34.810 ⇒ 00:11:40.569 Nicolas Sucari: I just filter by status, where we have, under the repository of all parts, all of the issues that
109 00:11:41.007 ⇒ 00:11:56.759 Nicolas Sucari: we are like, these are kind of the tasks that we need to work on. All of the tasks get get assigned to someone else. Team. And yeah, we move that task into different statuses. So that we know what status of each
110 00:11:57.110 ⇒ 00:12:01.890 Nicolas Sucari: task that everyone is working on. We have the triage status just to
111 00:12:02.080 ⇒ 00:12:24.100 Nicolas Sucari: create stuff there that needs to be worked on and that are not ready to be taken but by by anyone. Once. We have like more definition or more description of what the task is, it goes into backlog, and one that task is ready to be worked on it once it goes to ready this week. So here is where we we meet almost all Mondays and try to
112 00:12:24.200 ⇒ 00:12:31.980 Nicolas Sucari: add stuff into this status, so that everyone knows what are the tasks that we need to be working on this week.
113 00:12:33.020 ⇒ 00:12:50.629 Nicolas Sucari: And then it’s just kind of the simple process of moving into in progress. Blocked. If something we need to. Yeah, unblock from the client or anything else. When that task is finished and we create a pull request, it comes here to in review, and when it is reviewed and merged goes to done.
114 00:12:51.372 ⇒ 00:12:55.960 Nicolas Sucari: It kind. That’s kind of the simple process that we are following.
115 00:12:57.520 ⇒ 00:13:05.270 Nicolas Sucari: All of the tasks, as I said, have has an asking me once they get into this into this status.
116 00:13:05.290 ⇒ 00:13:14.700 Nicolas Sucari: and then we try to set some priorities test type is just to filter down if it is an analy analysis task as engineering or other modeling stuff.
117 00:13:15.181 ⇒ 00:13:29.450 Nicolas Sucari: And then we are trying to add due dates to all of the tasks. Now, so this is pretty important, because we are trying. We do tend to track all of the tasks that we are set setting each week and trying to see what we are
118 00:13:29.590 ⇒ 00:13:32.680 Nicolas Sucari: being able to accomplish. So yeah, we are.
119 00:13:33.660 ⇒ 00:13:35.110 suraj: To.
120 00:13:35.110 ⇒ 00:13:36.650 Nicolas Sucari: Had all of the due dates.
121 00:13:36.790 ⇒ 00:13:37.700 Nicolas Sucari: Yep.
122 00:13:38.160 ⇒ 00:13:43.160 suraj: Are? Are we assigning any points to the task like how how complex or easy.
123 00:13:43.160 ⇒ 00:13:43.910 Nicolas Sucari: Yeah.
124 00:13:44.360 ⇒ 00:13:46.400 Nicolas Sucari: so we have, we have these.
125 00:13:46.420 ⇒ 00:13:53.140 Nicolas Sucari: we have these field for estimations. But I think we’re gonna change this field of estimations and
126 00:13:53.270 ⇒ 00:13:56.150 Nicolas Sucari: created more kind of a small medium, large
127 00:13:56.220 ⇒ 00:14:00.640 Nicolas Sucari: kind of estimation. So that’s what we are gonna try to do. Okay.
128 00:14:00.740 ⇒ 00:14:21.030 Nicolas Sucari: the idea is to start, yeah, just to understand, if a task is small, task is medium, or it’s something real big try to group the task in those 3 different states and start measuring how many? I don’t know how many large or how many medium tasks can we achieve in a week or something like that?
129 00:14:22.090 ⇒ 00:14:22.770 Nicolas Sucari: Okay.
130 00:14:22.920 ⇒ 00:14:37.220 Nicolas Sucari: if you have other ideas, or if you prefer doing it differently, just let me know we can discuss it. Obviously, this is something that we already started. We started to adding due dates. And then, yeah, estimations. We need to start to add them to.
131 00:14:37.670 ⇒ 00:14:43.010 suraj: Got it. Yeah, sure, I I will take a look into this one or 2, and then come up with something.
132 00:14:43.690 ⇒ 00:14:48.179 Nicolas Sucari: Perfect. Then? Each of the tasks we try to
133 00:14:48.500 ⇒ 00:15:05.419 Nicolas Sucari: add some description. And and yeah, and and information on how on what is the the need of the task, and what? Where we need to to go and fix anything to change modeling, to create new tables? What are the fields.
134 00:15:05.450 ⇒ 00:15:15.450 Nicolas Sucari: etc, like all of the details, should be here on the description. And then we have comments to add comments, change stuff. If we need to discuss stuff we use that
135 00:15:15.500 ⇒ 00:15:24.749 Nicolas Sucari: everything is there on the, on the issue, so that we can track. For example, let me see the one that we are just working on Brian is.
136 00:15:25.080 ⇒ 00:15:25.900 Nicolas Sucari: or is it
137 00:15:26.870 ⇒ 00:15:54.559 Nicolas Sucari: okay? Here, this one just got close. But we were working on today. So we created one task. We added that we were be needing to add the customer acquisition cost. And then this change, and we change it to cost per conversion, and added some other stuff. So here we can see, like the comments we can add links to have more information. And each of these issues or these tasks, what they have is like they need to have a full request associated.
138 00:15:54.870 ⇒ 00:16:04.119 Nicolas Sucari: So in order to close one of these tasks, we need to create a pull, request, merge the code, and when that is merged it is automatically closed and sent to them. Okay.
139 00:16:04.630 ⇒ 00:16:05.909 suraj: Got it. Got it.
140 00:16:08.020 ⇒ 00:16:10.879 Nicolas Sucari: What else on github? I can show you.
141 00:16:12.350 ⇒ 00:16:13.760 Nicolas Sucari: Ryan, any ideas.
142 00:16:16.020 ⇒ 00:16:20.010 Ryan Luke Daque: Yeah, I think that’s most the the most important
143 00:16:20.080 ⇒ 00:16:23.849 Ryan Luke Daque: like thing in Github at the moment, because that’s where we track our
144 00:16:24.080 ⇒ 00:16:25.010 Ryan Luke Daque: tasks.
145 00:16:25.449 ⇒ 00:16:29.949 Ryan Luke Daque: But yeah, you can like you mentioned, you can look into like how you can.
146 00:16:31.940 ⇒ 00:16:32.550 Ryan Luke Daque: pool.
147 00:16:32.660 ⇒ 00:16:33.390 suraj: Yes.
148 00:16:33.390 ⇒ 00:16:39.689 Ryan Luke Daque: The the repositories to your local. So you can. You can check those out if you need to like.
149 00:16:39.850 ⇒ 00:16:44.660 Ryan Luke Daque: Look at the the Dbt models, for instance, or the sequel files.
150 00:16:44.780 ⇒ 00:16:46.280 Ryan Luke Daque: So, yeah, you can do that.
151 00:16:48.160 ⇒ 00:16:49.140 suraj: Sure, sure.
152 00:16:49.140 ⇒ 00:16:50.010 Nicolas Sucari: Yeah, exactly.
153 00:16:50.570 ⇒ 00:16:57.169 Nicolas Sucari: I can show you like, wait, let me show you my entire screen, so I can see. I can also show you the viscode
154 00:16:57.300 ⇒ 00:16:58.290 Nicolas Sucari: we knew.
155 00:17:00.980 ⇒ 00:17:06.249 Nicolas Sucari: But yeah, I mean, I just Github, we are using it to manage all of that pull requests.
156 00:17:06.770 ⇒ 00:17:07.800 Nicolas Sucari: And
157 00:17:08.680 ⇒ 00:17:11.879 Nicolas Sucari: yeah, and tracking of issues and and
158 00:17:11.940 ⇒ 00:17:20.149 Nicolas Sucari: and everything ideally, each task like when you when you start working on something, you can come here
159 00:17:20.160 ⇒ 00:17:21.700 Nicolas Sucari: and create
160 00:17:21.890 ⇒ 00:17:25.549 Nicolas Sucari: click here. Oh, this one is already created. But let’s see.
161 00:17:26.510 ⇒ 00:17:46.699 Nicolas Sucari: yeah, like, create a branch where it says, here on development, and you can create a new branch and start working on that branch for that issue, and once you already have, like new code, or in on, or something, you can commit the changes and then push this branch to the repo so that it can get reviewed, and then merge to the to the code right.
162 00:17:46.830 ⇒ 00:17:47.640 suraj: Got it.
163 00:17:48.790 ⇒ 00:17:53.819 Nicolas Sucari: Still, see here, let me go to issues. No sorry pull requests.
164 00:17:55.920 ⇒ 00:17:58.140 Nicolas Sucari: Yeah, pull requests.
165 00:17:58.690 ⇒ 00:18:02.559 Nicolas Sucari: So we have here for requests. This is one like
166 00:18:02.610 ⇒ 00:18:10.460 Nicolas Sucari: request that I created that is, creating a new dashboard. And now this is open. So if I go to the pull request, I can see that
167 00:18:10.560 ⇒ 00:18:12.149 Nicolas Sucari: there is a
168 00:18:12.540 ⇒ 00:18:14.470 Nicolas Sucari: okay. It was approved.
169 00:18:14.750 ⇒ 00:18:20.810 Nicolas Sucari: I don’t know who approved it. Utam already approved this, and I can merge this pull request. I can do it. Now, if you want.
170 00:18:21.290 ⇒ 00:18:27.079 Nicolas Sucari: I have to see the changes, we can go here to file change. And I can see, like I added, these 2 files.
171 00:18:28.080 ⇒ 00:18:33.149 Nicolas Sucari: This is like a new dashboard in in real that I’m adding. So let’s try
172 00:18:33.700 ⇒ 00:18:35.070 Nicolas Sucari: and merge this
173 00:18:36.070 ⇒ 00:18:37.610 Nicolas Sucari: multiple requests.
174 00:18:41.000 ⇒ 00:18:42.020 Nicolas Sucari: It’s nice.
175 00:18:42.887 ⇒ 00:18:46.269 Nicolas Sucari: And now we can go into real and see if these
176 00:18:47.270 ⇒ 00:18:48.389 Nicolas Sucari: got merged.
177 00:18:52.320 ⇒ 00:18:56.890 Nicolas Sucari: Okay, and it’s here. Return refunds, model model metrics.
178 00:18:58.145 ⇒ 00:19:05.830 Nicolas Sucari: This is the dashboard. And we just merged. People requested Merge included this dashboard. So yeah, we can see it here.
179 00:19:05.850 ⇒ 00:19:07.150 Nicolas Sucari: And this is production.
180 00:19:08.760 ⇒ 00:19:12.789 Nicolas Sucari: Something happened with this one Ryan. So we probably need to check.
181 00:19:13.690 ⇒ 00:19:14.220 Ryan Luke Daque: Yeah.
182 00:19:14.220 ⇒ 00:19:15.669 Nicolas Sucari: Hey? I don’t know.
183 00:19:16.780 ⇒ 00:19:20.579 Nicolas Sucari: Cpa is breaking. Which has we were working on this one before.
184 00:19:22.210 ⇒ 00:19:24.480 Nicolas Sucari: but yet yeah.
185 00:19:24.480 ⇒ 00:19:25.670 Ryan Luke Daque: Yeah, I’ll look into that.
186 00:19:26.670 ⇒ 00:19:27.340 Nicolas Sucari: Okay?
187 00:19:27.964 ⇒ 00:19:48.169 Nicolas Sucari: But yeah, I mean, then we have, like all other requests, we can see everything that’s open here. What are all the closed full requests, and when they get merged what else? All of the issues? We can go through the code here. But if you wanna like more details. We can go to this code.
188 00:19:48.180 ⇒ 00:19:49.810 Nicolas Sucari: And yeah, just
189 00:19:49.970 ⇒ 00:19:55.529 Nicolas Sucari: once you clone the repo, you will be able to see all of the folders, and you can go into each of the different
190 00:19:55.670 ⇒ 00:20:02.330 Nicolas Sucari: pies that we have there. And yeah, just understand a little bit more of what is being done on each of the different.
191 00:20:04.280 ⇒ 00:20:10.630 Nicolas Sucari: each of the different files and dashboards on what is in each of the code. Okay.
192 00:20:11.540 ⇒ 00:20:12.200 suraj: Listen.
193 00:20:16.040 ⇒ 00:20:22.870 Nicolas Sucari: Okay. What else I can show you on Github is, I think that’s like the main point you can.
194 00:20:23.140 ⇒ 00:20:27.129 Nicolas Sucari: Once you. I think you already accepted the invitation. Right?
195 00:20:27.530 ⇒ 00:20:27.880 suraj: Yup!
196 00:20:27.880 ⇒ 00:20:29.470 Nicolas Sucari: So if I go to
197 00:20:29.580 ⇒ 00:20:30.730 Nicolas Sucari: team.
198 00:20:31.880 ⇒ 00:20:33.430 Nicolas Sucari: go back to teams
199 00:20:37.710 ⇒ 00:20:38.800 Nicolas Sucari: people. So
200 00:20:39.010 ⇒ 00:20:42.959 Nicolas Sucari: yeah, rush, I patience.
201 00:20:43.060 ⇒ 00:20:43.630 suraj: Bye.
202 00:20:44.760 ⇒ 00:20:54.819 Nicolas Sucari: Once you accept the invitation, and you’re already here as a member. You will be able to see everything. And you just you just need to go to the pool parts to go repo
203 00:20:54.910 ⇒ 00:21:01.299 Nicolas Sucari: and clone it, and then you can start working on anything you want. There.
204 00:21:01.940 ⇒ 00:21:04.049 suraj: Okay. Okay.
205 00:21:04.930 ⇒ 00:21:08.130 Nicolas Sucari: Yeah, I mean, yeah, go ahead. Go ahead.
206 00:21:08.864 ⇒ 00:21:10.681 suraj: This real tool like
207 00:21:11.830 ⇒ 00:21:17.140 suraj: is it? We have to install on the like the laptop itself, or it’s a cloud based cloud based desktop.
208 00:21:18.750 ⇒ 00:21:31.469 Nicolas Sucari: It’s a cloud space. You just need to run one command to like, install the project here. And then, for example, I you you need to just run 3 commands, I think, or 4 commands, like I added a documentation here.
209 00:21:32.670 ⇒ 00:21:34.250 Nicolas Sucari: That we.
210 00:21:34.250 ⇒ 00:21:34.580 suraj: Yeah.
211 00:21:34.580 ⇒ 00:21:35.880 Nicolas Sucari: All these.
212 00:21:35.880 ⇒ 00:21:37.130 suraj: I saw somewhere.
213 00:21:40.150 ⇒ 00:21:41.440 Ryan Luke Daque: Yeah, that’s what they want.
214 00:21:42.200 ⇒ 00:21:45.580 Nicolas Sucari: No, but it’s not how to set up real.
215 00:21:45.980 ⇒ 00:21:49.510 Nicolas Sucari: So you need to run these on your terminal
216 00:21:49.690 ⇒ 00:21:51.900 Nicolas Sucari: and then navigate into
217 00:21:52.050 ⇒ 00:21:58.120 Nicolas Sucari: the real project but one. The only what we need to do is just you. You just need to run this one.
218 00:21:58.160 ⇒ 00:22:00.550 Nicolas Sucari: and then you will need to do.
219 00:22:00.950 ⇒ 00:22:05.259 Nicolas Sucari: Let’s go and do it. Wait. Let me change the branch.
220 00:22:06.240 ⇒ 00:22:07.820 Nicolas Sucari: Go to Main.
221 00:22:10.400 ⇒ 00:22:20.090 Nicolas Sucari: Okay, you just need to run to change the folder where you’re stepping. We need to go to pull parts of real. This is this folder that we have here in the code.
222 00:22:20.920 ⇒ 00:22:28.599 Nicolas Sucari: So once you are here, we just click after installing with the previous command, you just real start, and you can run it like locally.
223 00:22:31.370 ⇒ 00:22:33.849 Nicolas Sucari: And here you can see, like the
224 00:22:33.900 ⇒ 00:22:37.930 Nicolas Sucari: configuration for each of the different dashboards, models, and sources.
225 00:22:38.190 ⇒ 00:22:41.410 Nicolas Sucari: So, for example, where it’s
226 00:22:43.530 ⇒ 00:22:45.709 Nicolas Sucari: yeah, all of the models here.
227 00:22:46.400 ⇒ 00:22:47.719 Nicolas Sucari: And we can see everything.
228 00:22:50.610 ⇒ 00:22:51.370 Nicolas Sucari: See.
229 00:22:52.650 ⇒ 00:22:52.990 suraj: Yeah.
230 00:22:52.990 ⇒ 00:22:56.010 Nicolas Sucari: And if we we are, for example.
231 00:22:56.710 ⇒ 00:23:03.759 Nicolas Sucari: I don’t know in this, in this dashboard, and if we change something here, it will get changed also in it
232 00:23:04.280 ⇒ 00:23:05.860 Nicolas Sucari: embs code
233 00:23:09.330 ⇒ 00:23:10.510 Nicolas Sucari: like in queue
234 00:23:14.200 ⇒ 00:23:14.990 Nicolas Sucari: that
235 00:23:15.380 ⇒ 00:23:19.850 Nicolas Sucari: I changed this and I didn’t pull. I need to pull the changes because
236 00:23:21.700 ⇒ 00:23:24.500 Nicolas Sucari: I’m missing my new dashboard that we already merged.
237 00:23:25.540 ⇒ 00:23:32.510 suraj: Basically, I, I worked on several bi tools like tableau power bi all the things. But I never worked on this kind of tool
238 00:23:33.172 ⇒ 00:23:42.659 suraj: which is code based one. So, is there any? Yeah, is there any like learning documentation online? Somewhere? I can find or videos.
239 00:23:43.540 ⇒ 00:23:49.839 Ryan Luke Daque: Yeah, there should be a real documentation. They have a pretty fine documentation on that as well.
240 00:23:50.730 ⇒ 00:23:51.520 Nicolas Sucari: So
241 00:23:52.210 ⇒ 00:23:54.059 Nicolas Sucari: yeah, if you go to
242 00:23:54.080 ⇒ 00:23:55.260 Nicolas Sucari: real
243 00:23:55.600 ⇒ 00:23:59.540 Nicolas Sucari: documentation docs@raildata.com.
244 00:23:59.540 ⇒ 00:24:00.290 Ryan Luke Daque: Yeah, that.
245 00:24:01.205 ⇒ 00:24:02.979 Nicolas Sucari: I can send you this link.
246 00:24:06.530 ⇒ 00:24:08.310 Nicolas Sucari: I’ll send it through a chat here.
247 00:24:09.050 ⇒ 00:24:09.929 suraj: So these are.
248 00:24:11.180 ⇒ 00:24:16.129 suraj: But I don’t. I don’t think this is much customization option. There is no customization option, but.
249 00:24:16.130 ⇒ 00:24:17.100 Nicolas Sucari: Oh, yeah.
250 00:24:17.480 ⇒ 00:24:21.059 Nicolas Sucari: as we as we as we yesterday. Yeah, we
251 00:24:21.600 ⇒ 00:24:42.500 Nicolas Sucari: yeah, exactly. I mean, we we are. There is no such customization on the visual visual stuff. I mean, all of the dashboards are gonna look kind of the same. So this tool is more kind of for exploring data, for answering like quick questions for the client.
252 00:24:43.190 ⇒ 00:25:02.409 Nicolas Sucari: It’s it focuses more on how the model is created, and then just having the information there and the speed on filtering down on using different dimensions, on yeah, comparing with previous years or other time frames. That’s like kind of the main used
253 00:25:02.420 ⇒ 00:25:17.169 Nicolas Sucari: for for real. And then, if we want to create, like more of a nice report that we would like to stay there more kind of a dashboard. And for for the client we are using this other tool called.
254 00:25:17.410 ⇒ 00:25:18.449 Nicolas Sucari: have you dance.
255 00:25:22.100 ⇒ 00:25:25.579 suraj: Evidence is for what exactly is that for ad hoc reports.
256 00:25:26.330 ⇒ 00:25:31.000 Nicolas Sucari: Evidence. Yeah, we we are using it for adult reports. For example, we
257 00:25:31.050 ⇒ 00:25:46.890 Nicolas Sucari: we did a center of gravity analysis to understand where to place a new warehouse for the client in the Us. To ship to to reduce shipping costs for some for some places, so
258 00:25:46.950 ⇒ 00:26:09.380 Nicolas Sucari: like the final report of what we of what we did. We tried and added here, and this is kind of a tool which give us more flexibility on using different like components. For example, this map graph, where we can add some bullets, some information. And this is all customizable. I mean, we can change. For example, we have.
259 00:26:09.970 ⇒ 00:26:13.869 Nicolas Sucari: Okay, this one’s not working now. Warranty, either.
260 00:26:14.690 ⇒ 00:26:20.670 Nicolas Sucari: Okay, it’s not working now. But yeah, I mean, we can use this one as more of a
261 00:26:21.060 ⇒ 00:26:24.440 Nicolas Sucari: more kind of what you create on tableau or
262 00:26:25.068 ⇒ 00:26:30.739 Nicolas Sucari: power bi like just to have here, like another report to hand off to the
263 00:26:31.358 ⇒ 00:26:49.250 Nicolas Sucari: to the client. But the idea is to work on real, to have all the data there, all the data available for the client to go there and look into different measures and dimensions to answer all of the questions. And once we need to do some like adult reports and try to deliver like a nice
264 00:26:49.617 ⇒ 00:27:02.100 Nicolas Sucari: a nice report. With like these features, awesome app tables, different kind of graphs. We can create them here in evidence. And evidence is also code based. So if we go to Vs code.
265 00:27:02.980 ⇒ 00:27:15.959 Nicolas Sucari: we have, like another folder here called evidence, where we have sources. We have, then the queries that are kind of the models, and then we have the pages and the pages are each of these different reports that we are seeing
266 00:27:17.930 ⇒ 00:27:27.840 Nicolas Sucari: and also here, like you, you don’t need like to code everything you can use the the docs, the docs on evidence. They have, like, yeah, really nice
267 00:27:28.630 ⇒ 00:27:30.449 Nicolas Sucari: evidence talks.
268 00:27:33.315 ⇒ 00:27:34.040 Nicolas Sucari: Here
269 00:27:34.620 ⇒ 00:27:43.659 Nicolas Sucari: you’ll see that every like different component has its own page, and you can go and see if okay, if I want to create a bar chart.
270 00:27:44.100 ⇒ 00:27:49.440 Nicolas Sucari: Sorry we if you can create a bar chart. Okay, here you have, like the different
271 00:27:49.460 ⇒ 00:27:55.940 Nicolas Sucari: code structure that you need to use how to customize it. They give you examples. So yeah, it’s kind of
272 00:27:56.160 ⇒ 00:28:01.250 Nicolas Sucari: great. And you have, like a lot of different options of components. So this is kind of
273 00:28:02.070 ⇒ 00:28:11.719 Nicolas Sucari: we we only it. It takes more time to create one of these reports, but they are really nice. So we use them just for those adult reports in order to deliver to a client.
274 00:28:12.290 ⇒ 00:28:41.220 suraj: Okay, okay, got it. So all the work we do, for example, for the pool part to go all the work we do like for data, engineering data, modeling, etcetera. The end products is end product is the dashboards which they see in the front end. Right? They don’t data engineering nothing, the data, even. Just we get the data from them. And we provide the dashboards and the back end things we work on it. But the end product is these real and evidence dashboards.
275 00:28:41.900 ⇒ 00:28:45.979 Nicolas Sucari: Yeah, I mean, we, we create the real and evidence dashboards to
276 00:28:46.040 ⇒ 00:28:58.469 Nicolas Sucari: to show them the information, and then we help them to make the the right decision on some stuff, for example, the center of gravity stuff that we did that helped that to make the decision on where to place in your warehouse.
277 00:28:59.050 ⇒ 00:29:00.739 suraj: Oh, okay, okay.
278 00:29:01.320 ⇒ 00:29:02.240 suraj: Got it.
279 00:29:02.780 ⇒ 00:29:19.030 Nicolas Sucari: But yeah, I mean, what we deliver is the the real dashboard, with all of the information there we try to answer their questions, adding more models and more information, more data there and then, if we need to do some specific analysis on
280 00:29:19.070 ⇒ 00:29:31.420 Nicolas Sucari: something that they want, we use evidence to show, like the result of that analysis, and how and what is like our recommendation on what they need to to decide on right.
281 00:29:31.590 ⇒ 00:29:33.249 suraj: Got it, got it, got it.
282 00:29:33.390 ⇒ 00:29:43.219 suraj: So are we going to like collaborate with them? For, like all departments? Or is there any particular person or people where we only interact with these people. For from the client side.
283 00:29:44.000 ⇒ 00:29:47.062 Nicolas Sucari: So, for now we are interacting with
284 00:29:47.630 ⇒ 00:29:53.090 Nicolas Sucari: with 2 departments from them that is, shipping and marketing.
285 00:29:53.680 ⇒ 00:29:58.410 Nicolas Sucari: And then we we have for marketing. There is a girl called Kim
286 00:29:58.832 ⇒ 00:30:07.520 Nicolas Sucari: She is kind of the director of the area, and they are not so many. So yeah, like, she is the one that is
287 00:30:08.110 ⇒ 00:30:18.339 Nicolas Sucari: asking and requesting new information for for marketing dashboards and more visibility on campaigns, on revenue, on yeah, on cost, and all of that stuff.
288 00:30:18.775 ⇒ 00:30:22.790 Nicolas Sucari: So that’s came from marketing. And then we talked to Chuck
289 00:30:23.220 ⇒ 00:30:28.180 Nicolas Sucari: Jack Gross that he’s the responsible of all of the shipping area.
290 00:30:29.304 ⇒ 00:30:30.259 Nicolas Sucari: We
291 00:30:30.290 ⇒ 00:30:57.359 Nicolas Sucari: we? We talk to him on for example, this of the new warehouse we discussed with him. We showed all of the information we showed what were our costs our shipping costs, and how we can reduce that if we added a new, a new warehouse. And yeah, he helps us understand and track different orders. When there is an issue on how we are importing orders from shopify to one of the other platforms. We we manage everything with him. Okay?
292 00:30:57.640 ⇒ 00:31:18.160 Nicolas Sucari: And then we talk to the their executive or more business team. That is the CEO. And yeah, both founders that are then and done. And yeah, they have more kind of an executive requests. Kind of hey? I need this data to place place it into into some slides to then present to investors or other stuff.
293 00:31:18.160 ⇒ 00:31:18.680 suraj: Oh, okay.
294 00:31:18.995 ⇒ 00:31:34.470 Nicolas Sucari: So those are kind of our 3 points of contact. We have, like the executives. And then we have shipping and marketing. And yeah, for now we are not. I think there, I don’t know if there is like a lot of more people from from their side.
295 00:31:34.760 ⇒ 00:31:36.429 Nicolas Sucari: actually. But yeah.
296 00:31:37.240 ⇒ 00:31:42.490 suraj: Okay. And how? How does the data flow to our site from there from there? So like from scratch.
297 00:31:43.880 ⇒ 00:31:47.327 Nicolas Sucari: So probably that’s more a question for Ryan
298 00:31:47.880 ⇒ 00:31:52.439 Nicolas Sucari: or for Patrick. But yeah, right, do you? Do you want to explain.
299 00:31:52.720 ⇒ 00:32:02.270 Ryan Luke Daque: Yeah, sure. So currently, so that we have different sources of data from them. Let’s like for pool parts to go. For example, the orders are coming from shopify
300 00:32:02.813 ⇒ 00:32:11.160 Ryan Luke Daque: And like for ads, like marketing related stuff, we have Facebook ads, we have Google ads, we have Amazon ads and and stuff like that.
301 00:32:11.782 ⇒ 00:32:19.649 Ryan Luke Daque: So yeah, we are primarily using 5 tran to integrate the data from different sources into Snowflake.
302 00:32:19.950 ⇒ 00:32:26.400 Ryan Luke Daque: But aside from that, for those data sources that aren’t available in 5 grand, we do
303 00:32:26.520 ⇒ 00:32:41.089 Ryan Luke Daque: have custom data pipelines created by Patrick and the other data engineering team. So basically, Patrick is mostly doing the customization like one work that he’s doing right now is we are getting
304 00:32:41.230 ⇒ 00:32:43.690 Ryan Luke Daque: data coming through emails.
305 00:32:43.790 ⇒ 00:32:45.220 Ryan Luke Daque: And he
306 00:32:45.520 ⇒ 00:32:48.800 Ryan Luke Daque: was working on like a specific data integration
307 00:32:49.890 ⇒ 00:32:51.390 Ryan Luke Daque: tool custom.
308 00:32:52.190 ⇒ 00:32:55.529 Ryan Luke Daque: to make that work. But yeah, so, but yeah, most of
309 00:32:55.850 ⇒ 00:33:00.049 Ryan Luke Daque: this. So as you can see here. From Nicholas, he’s look, showing you the
310 00:33:00.210 ⇒ 00:33:02.710 Ryan Luke Daque: different data sources that we are using
311 00:33:03.150 ⇒ 00:33:04.120 Ryan Luke Daque: integrate
312 00:33:04.550 ⇒ 00:33:07.029 Ryan Luke Daque: into snowflake using 5 grand. So, yeah.
313 00:33:07.380 ⇒ 00:33:11.290 suraj: So the update happens every day, like we will receive everyday emails
314 00:33:12.920 ⇒ 00:33:13.430 suraj: or the.
315 00:33:13.430 ⇒ 00:33:15.859 Ryan Luke Daque: Emails. Yes, yeah, there are.
316 00:33:15.860 ⇒ 00:33:17.710 Nicolas Sucari: Emails, yeah.
317 00:33:18.275 ⇒ 00:33:18.840 Ryan Luke Daque: Yeah.
318 00:33:19.680 ⇒ 00:33:21.260 Ryan Luke Daque: Some are weekly.
319 00:33:23.220 ⇒ 00:33:28.350 suraj: So the last sync is the the the most refreshed data or.
320 00:33:28.350 ⇒ 00:33:34.430 Ryan Luke Daque: Yes, that’s correct. So is you can see there 30 min ago, roughly, for almost everything.
321 00:33:34.580 ⇒ 00:33:36.530 Ryan Luke Daque: Yeah, the others are like
322 00:33:36.800 ⇒ 00:33:42.889 Ryan Luke Daque: every 5 h. So it depends on the source, how how frequent we need the data from
323 00:33:43.340 ⇒ 00:33:45.110 Ryan Luke Daque: not to be updated. Basically.
324 00:33:45.760 ⇒ 00:33:47.369 suraj: Got it. Got it
325 00:33:47.830 ⇒ 00:33:52.699 suraj: so how how long it’s been, Nicholas, like that? We we started working with this client.
326 00:33:54.287 ⇒ 00:33:59.369 Nicolas Sucari: I’m not sure, because when I joined the the client was already here, so I.
327 00:33:59.370 ⇒ 00:34:01.649 Ryan Luke Daque: And I joined. It’s already there as well. So.
328 00:34:01.650 ⇒ 00:34:02.060 Nicolas Sucari: Yeah.
329 00:34:02.060 ⇒ 00:34:06.730 Ryan Luke Daque: Like Bhutan has been like working with this client for quite a while already.
330 00:34:09.030 ⇒ 00:34:17.089 Nicolas Sucari: I think it will. It’s almost a year now. Because 1st he started, Uton was like working directly with them, and then he started like 2
331 00:34:17.890 ⇒ 00:34:24.510 Nicolas Sucari: bring us in on trying to get other other clients. But yeah, I think it should be kind of a year now.
332 00:34:25.159 ⇒ 00:34:27.099 suraj: Got it? Got it? Got it?
333 00:34:27.620 ⇒ 00:34:28.250 Nicolas Sucari: Oh, I’m in each.
334 00:34:28.250 ⇒ 00:34:28.669 suraj: Some sort of.
335 00:34:29.111 ⇒ 00:34:31.318 Nicolas Sucari: Really, they are really nice.
336 00:34:32.514 ⇒ 00:34:50.359 Nicolas Sucari: they they don’t like push so much on the team. They have some requests they ask on some new stuff. Would they ask on new information integrations and that kind of stuff? But right now, like we’re trying to
337 00:34:50.360 ⇒ 00:35:19.580 Nicolas Sucari: deliver them more information, trying to work on more analysis stuff so that we can help them. As I said, for example, reduce some costs or understand where they need to go and expand their business or fees like, for example, which customers they need to target how to segment their customers and that kind of stuff. But they are really nice. I mean, they are really open. They they hear us. And yeah, they. They are like great clients for us. I think.
338 00:35:19.850 ⇒ 00:35:26.770 suraj: Got it, got it so, whom? Whom? No matter who the client is, we will end up using these tools only, or it depends on the.
339 00:35:26.770 ⇒ 00:35:27.160 Nicolas Sucari: Yeah.
340 00:35:27.160 ⇒ 00:35:28.270 suraj: Like, for example, Rick.
341 00:35:28.270 ⇒ 00:35:37.231 Nicolas Sucari: I I think obviously it will. It will depend on the clients. But we are trying to use real for all of them.
342 00:35:38.200 ⇒ 00:35:56.760 Nicolas Sucari: and and yeah, it will depend on the client, the other client that we have right now, as we are working with someone who provide us with the client, and he’s using the database as as visualization tool. But he’s managing everything on that one, and we just managing the modeling of data. So
343 00:35:56.850 ⇒ 00:36:06.369 Nicolas Sucari: we don’t care. But yeah, if we need to manage everything with clients, I think we will be working with real and evidence for now, yeah, yeah.
344 00:36:06.700 ⇒ 00:36:07.320 Ryan Luke Daque: Yeah, that that.
345 00:36:07.320 ⇒ 00:36:08.119 Nicolas Sucari: Well done is all the way.
346 00:36:08.120 ⇒ 00:36:09.320 Ryan Luke Daque: Future, though because.
347 00:36:09.320 ⇒ 00:36:10.120 Nicolas Sucari: Yeah, exactly.
348 00:36:10.120 ⇒ 00:36:19.130 Ryan Luke Daque: Yeah, cause he, like Utam, always wants to try out different things. So even like before, I’m not sure if, like Nicholas, you remember. But we were using light.
349 00:36:19.130 ⇒ 00:36:19.820 Nicolas Sucari: Dash.
350 00:36:20.546 ⇒ 00:36:24.510 Ryan Luke Daque: For the dashboarding tool before we use drill and evidence.
351 00:36:25.071 ⇒ 00:36:29.768 Ryan Luke Daque: So yeah, it it could change any time. Maybe if there’s a better
352 00:36:30.630 ⇒ 00:36:31.730 Ryan Luke Daque: Then we can always.
353 00:36:31.730 ⇒ 00:36:32.230 suraj: Yeah.
354 00:36:32.230 ⇒ 00:36:32.849 Ryan Luke Daque: Try it after.
355 00:36:32.850 ⇒ 00:36:35.990 suraj: Yeah, every day. There are so many coming into the market. Yeah.
356 00:36:35.990 ⇒ 00:36:36.750 Ryan Luke Daque: Exactly. Yeah.
357 00:36:36.750 ⇒ 00:36:37.470 Nicolas Sucari: Yeah.
358 00:36:37.610 ⇒ 00:36:38.130 suraj: Hmm.
359 00:36:38.130 ⇒ 00:36:49.960 Nicolas Sucari: Yeah. And and each of the different tools they have like different features. And they are used for different things. So really, it’s working now, I think, because it’s like, really fast on
360 00:36:50.502 ⇒ 00:37:11.769 Nicolas Sucari: on, on exploring data. And yeah, and and this client doesn’t need like so many like, really nice or cool dashboards to go and and look every day. So that’s why we’re not spending so much time in evidence, and we’re spending more time on real. But if another client needs like more visual stuff, we probably should be spending more time in in our tool. Yeah.
361 00:37:12.052 ⇒ 00:37:17.980 suraj: Exactly, I understand, because based on my experience, it depends on the domain of the industry, like the retail people.
362 00:37:17.980 ⇒ 00:37:18.255 Nicolas Sucari: Yeah.
363 00:37:18.530 ⇒ 00:37:38.390 suraj: About in the retail. This is also retail company, you would say, but they don’t want like a fancy dashboards to look at like the numbers, and there are so many executives to look at the numbers. But they just want the results like an answer for all of this all questions. So I think, yeah, it makes sense to use real for this client.
364 00:37:39.180 ⇒ 00:37:40.239 suraj: Yeah, true.
365 00:37:40.240 ⇒ 00:37:41.290 Nicolas Sucari: Yeah, exactly.
366 00:37:41.830 ⇒ 00:37:59.820 Nicolas Sucari: Exactly. I mean, maybe we can try developing more stuff or more nicer stuff in in evidence and try to see if they like to have. Like, yeah, kind of those dashboards. We’re more with more visual stuff but for now, like they were just requesting
367 00:38:00.176 ⇒ 00:38:24.770 Nicolas Sucari: information and answers on numbers and data. And yeah, and real for that, for that is, it works for us. So I think, for for now we were doing great with real. But yeah, we can try like developing better stuff on on evidence and see if they like it. If they prefer using that one. That more more evidence than real. And and and yeah, discuss with them.
368 00:38:25.570 ⇒ 00:38:39.979 suraj: So other than real like. For the from the reporting perspective for this client, they do. They have any other internal team where they develop these kind of dashboards or reports, or for the other teams like operations or sales team.
369 00:38:40.070 ⇒ 00:38:45.249 suraj: something like that. Or we are the only one working on the data side of things for them.
370 00:38:46.470 ⇒ 00:38:53.769 Nicolas Sucari: I’m not sure actually. But I think we are the only ones working as a data team for them.
371 00:38:54.220 ⇒ 00:38:56.299 suraj: Okay. Sounds. Good. Administrator.
372 00:38:56.300 ⇒ 00:39:02.399 Nicolas Sucari: I mean, they have, like all of the different reports from different tools that you’re using. For example, we were just
373 00:39:02.500 ⇒ 00:39:06.130 Nicolas Sucari: having a discussion on this one post pilot.
374 00:39:07.700 ⇒ 00:39:16.140 Nicolas Sucari: they use this one for direct mail campaigns, and they have here some reports. And, for example, we were just discussing on.
375 00:39:16.470 ⇒ 00:39:24.979 Nicolas Sucari: Yeah, we were just discussing on these conversions from the marketing campaigns. But they don’t have like dashboards. They just have like these lists.
376 00:39:25.150 ⇒ 00:39:34.839 Nicolas Sucari: And we get, we. We are using this list as a data source. And this is coming through an email from from us. And we are including this into our snowflake warehouse. So
377 00:39:35.339 ⇒ 00:39:38.389 Nicolas Sucari: yeah, I don’t know if they have like another.
378 00:39:38.840 ⇒ 00:39:40.319 Nicolas Sucari: our data team. Now.
379 00:39:40.580 ⇒ 00:39:43.319 suraj: Yeah, yeah. So it’s
380 00:39:45.112 ⇒ 00:39:54.930 suraj: yeah. So what I want to do is start with real installing it and explore those already built dashboards, the code inside it.
381 00:39:55.130 ⇒ 00:40:00.460 suraj: And what is the flow from? You know the pipelines to the tables, to the.
382 00:40:00.460 ⇒ 00:40:01.230 Nicolas Sucari: Perfect.
383 00:40:01.230 ⇒ 00:40:07.910 suraj: Dashboards. I I’ll start exploring that and try to maybe rebuild rebuild, which is already there and see how it is working.
384 00:40:08.000 ⇒ 00:40:20.660 suraj: Because I I started night. I was looking at like Youtube for the real videos, if to see. But there is nothing on online except the documentation you shared. So I’ll start using that actually.
385 00:40:21.650 ⇒ 00:40:22.580 Ryan Luke Daque: Yeah, I think realistically.
386 00:40:22.580 ⇒ 00:40:23.140 Nicolas Sucari: And.
387 00:40:23.140 ⇒ 00:40:27.974 Ryan Luke Daque: New tool as well. That’s probably why there’s no, there’s not a lot of
388 00:40:28.320 ⇒ 00:40:29.220 suraj: Yeah, yeah.
389 00:40:29.340 ⇒ 00:40:30.670 Ryan Luke Daque: Things in
390 00:40:30.940 ⇒ 00:40:32.089 Ryan Luke Daque: except the company.
391 00:40:32.090 ⇒ 00:40:34.860 suraj: Videos on Youtube. But there is nothing else.
392 00:40:35.303 ⇒ 00:40:38.840 suraj: I think this documentation may help me. So.
393 00:40:38.840 ⇒ 00:40:39.840 Nicolas Sucari: Yeah, you can.
394 00:40:39.840 ⇒ 00:40:41.302 suraj: Check this one,
395 00:40:42.250 ⇒ 00:40:42.990 suraj: yeah.
396 00:40:42.990 ⇒ 00:40:44.010 Nicolas Sucari: Yeah, there you go.
397 00:40:45.940 ⇒ 00:40:49.120 Nicolas Sucari: This one is a video that we recorded one.
398 00:40:49.200 ⇒ 00:40:56.530 Nicolas Sucari: Utam explained. Real to one of the clients, I think to Ben, at least from Paul parts.
399 00:40:56.660 ⇒ 00:40:58.770 Nicolas Sucari: I can’t remember if that’s
400 00:40:59.500 ⇒ 00:41:02.780 Nicolas Sucari: well, it was this meeting. Yeah. And this is the docs.
401 00:41:03.010 ⇒ 00:41:21.439 Nicolas Sucari: So yeah, you can check these recordings. And you can ask us, I’ve been learning yeah how to use it. I know how to run it locally, how to create a dashboard from a model we can use like AI to do it automatically. So that’s kind of nice. And then you just go and customize different measures.
402 00:41:21.895 ⇒ 00:41:23.140 Nicolas Sucari: On how that?
403 00:41:23.390 ⇒ 00:41:34.140 Nicolas Sucari: Yeah, it’s created. And and yeah, it’s just reading the docs, I think. And if you don’t find any information, we have a channel with
404 00:41:34.750 ⇒ 00:41:39.969 Nicolas Sucari: Real directly here on slack, and we can ask questions, and they are pretty fast to answer to.
405 00:41:40.210 ⇒ 00:41:42.209 suraj: Oh, nice, nice.
406 00:41:42.880 ⇒ 00:41:47.069 suraj: Okay. Where is a channel? It’s in the slack itself.
407 00:41:47.070 ⇒ 00:41:53.240 Nicolas Sucari: It’s it’s in slack I think if you search for vendor dash real.
408 00:41:53.290 ⇒ 00:41:54.810 Nicolas Sucari: you will find it.
409 00:41:54.810 ⇒ 00:41:55.840 suraj: Yeah, yeah.
410 00:41:56.443 ⇒ 00:42:04.250 Nicolas Sucari: But yeah, they they are. Yeah, we have like a lot of people from their team there. And if we have like an issue, or anything that we would like to ask.
411 00:42:04.584 ⇒ 00:42:14.249 Nicolas Sucari: We can ask them there. Probably almost everything is on the docs. But if you don’t find anything there, and we are. We’re running into an error. We can ask them directly. There.
412 00:42:14.690 ⇒ 00:42:17.820 suraj: Sure, sure. Sure I I have to explore.
413 00:42:17.980 ⇒ 00:42:19.010 suraj: really thinking.
414 00:42:19.010 ⇒ 00:42:19.860 Nicolas Sucari: Yeah.
415 00:42:21.149 ⇒ 00:42:25.069 Nicolas Sucari: and I don’t know what else we’re using
416 00:42:25.820 ⇒ 00:42:32.010 Nicolas Sucari: for our work process. I’m gonna add you to these stand up. Leave report that we have
417 00:42:32.100 ⇒ 00:42:37.260 Nicolas Sucari: standably is about. I think I already mentioned this yesterday. But
418 00:42:37.670 ⇒ 00:42:46.140 Nicolas Sucari: yeah, it will ask like a couple of questions, and you will see it here as an app. It will send some messages.
419 00:42:46.190 ⇒ 00:42:48.430 Nicolas Sucari: for example, today, like
420 00:42:48.460 ⇒ 00:42:59.799 Nicolas Sucari: at certain time of the day, it will send like it’s time for a daily stand up, and it will ask you some questions. And you just like answer writing, and this will create
421 00:43:01.366 ⇒ 00:43:02.699 Nicolas Sucari: entry here
422 00:43:02.980 ⇒ 00:43:07.679 Nicolas Sucari: on a standably thread with like our answers, so that we know.
423 00:43:08.191 ⇒ 00:43:13.500 Nicolas Sucari: what was that we were doing yesterday, and what we are gonna be working on today?
424 00:43:14.190 ⇒ 00:43:18.439 Nicolas Sucari: It’s just to. Yeah, it’s simple. It’s just to
425 00:43:19.201 ⇒ 00:43:31.520 Nicolas Sucari: replace, like the daily stand up meeting that we had. And I think it’s working. When when everyone answers, this one is pretty easy to understand what everyone is doing. So yeah, super useful.
426 00:43:31.820 ⇒ 00:43:34.179 suraj: Of course, same questions, yeah.
427 00:43:35.570 ⇒ 00:43:37.700 Nicolas Sucari: I can add you here, probably.
428 00:43:39.630 ⇒ 00:43:41.730 Nicolas Sucari: So rush, yeah, yeah.
429 00:43:45.020 ⇒ 00:43:47.639 Nicolas Sucari: okay. And I’m gonna remove Jacob, maybe.
430 00:43:51.075 ⇒ 00:43:51.720 Nicolas Sucari: Yeah.
431 00:43:52.360 ⇒ 00:43:52.980 suraj: Yeah.
432 00:43:57.467 ⇒ 00:43:59.152 Nicolas Sucari: You received it, I think.
433 00:44:00.897 ⇒ 00:44:12.439 Nicolas Sucari: Okay, I don’t know what other tool we’re using. Well, Uta mentioned one password. I think he already sent the invite on one password. You can
434 00:44:13.150 ⇒ 00:44:23.020 Nicolas Sucari: manage all of your usernames and and passwords for all of the different tools, and we have all our shared information there. So it’s kind of
435 00:44:24.215 ⇒ 00:44:29.740 Nicolas Sucari: interesting to go there and have it open. I use the chrome extension.
436 00:44:29.820 ⇒ 00:44:35.519 Nicolas Sucari: even though I’m not using chrome here, but it works so chrome. Extension is great, because.
437 00:44:35.520 ⇒ 00:44:35.960 suraj: Okay.
438 00:44:35.960 ⇒ 00:44:45.999 Nicolas Sucari: Once you have the chrome extension and you are logged in, you can just like you. You will see, like the helper on each of the logins that you need, and you can access directly
439 00:44:46.080 ⇒ 00:44:51.279 Nicolas Sucari: with different recommendations, and you can access the different platforms.
440 00:44:52.080 ⇒ 00:44:53.900 suraj: Got it? Got it? Yeah.
441 00:44:53.900 ⇒ 00:44:56.929 Nicolas Sucari: I can show you. Maybe if I do like this.
442 00:44:59.070 ⇒ 00:45:01.009 Nicolas Sucari: So if I log out.
443 00:45:03.790 ⇒ 00:45:07.739 Nicolas Sucari: okay, if I wanna sign in to this account, for example.
444 00:45:14.140 ⇒ 00:45:21.010 Nicolas Sucari: see, you will see we have here like this is one password, saying, maybe we have all of these shared
445 00:45:21.180 ⇒ 00:45:25.280 Nicolas Sucari: information, and I can just use each of them to log in.
446 00:45:25.900 ⇒ 00:45:27.150 Nicolas Sucari: I was in my
447 00:45:27.220 ⇒ 00:45:29.129 Nicolas Sucari: yeah, to factor that.
448 00:45:29.970 ⇒ 00:45:30.460 suraj: Yeah.
449 00:45:30.460 ⇒ 00:45:32.750 Nicolas Sucari: It’s kind of really, it’s it’s really useful.
450 00:45:33.210 ⇒ 00:45:34.150 suraj: Yeah, true.
451 00:45:41.650 ⇒ 00:45:44.480 Nicolas Sucari: And then I don’t know we use Claude.
452 00:45:46.076 ⇒ 00:45:49.970 Nicolas Sucari: Claudies, for an AI tool? We ask.
453 00:45:50.090 ⇒ 00:45:59.089 Nicolas Sucari: Yeah, we can give you a little bit of context, we have some projects created. So for example, if we wanna ask something about pool parts.
454 00:45:59.400 ⇒ 00:46:09.940 Nicolas Sucari: we have this project that’s called pool parts to go engineer that has like instructions to create a Github issue and a Dbt summary with most of the
455 00:46:10.327 ⇒ 00:46:20.989 Nicolas Sucari: modeling that we’re using or on on the project. So we can ask questions. And it has, like this context on how to answer. If I ask, for example.
456 00:46:21.430 ⇒ 00:46:23.830 Nicolas Sucari: create a new Github issue
457 00:46:24.660 ⇒ 00:46:28.370 Nicolas Sucari: to add a new dashboard to real
458 00:46:29.120 ⇒ 00:46:30.210 Nicolas Sucari: about
459 00:46:34.160 ⇒ 00:46:37.599 Nicolas Sucari: costs and warehouses
460 00:46:40.180 ⇒ 00:46:41.290 Nicolas Sucari: he dwell.
461 00:46:41.970 ⇒ 00:46:43.619 Nicolas Sucari: Help me create a new
462 00:46:43.730 ⇒ 00:46:44.900 Nicolas Sucari: did you have issue?
463 00:46:48.550 ⇒ 00:46:51.499 Nicolas Sucari: It’s kind of tragically, but our tool.
464 00:46:55.350 ⇒ 00:46:58.590 Nicolas Sucari: you see, and then I can copy this and just create a Github issue
465 00:46:58.650 ⇒ 00:47:00.109 Nicolas Sucari: for you or anyone else.
466 00:47:00.140 ⇒ 00:47:00.870 suraj: Okay.
467 00:47:00.870 ⇒ 00:47:01.730 Nicolas Sucari: Super simple.
468 00:47:03.510 ⇒ 00:47:04.165 Nicolas Sucari: Yep.
469 00:47:06.155 ⇒ 00:47:07.790 Nicolas Sucari: I don’t know
470 00:47:07.850 ⇒ 00:47:10.639 Nicolas Sucari: what else I can share, Ryan. Anything.
471 00:47:13.288 ⇒ 00:47:14.960 Ryan Luke Daque: Yeah, I think you
472 00:47:15.430 ⇒ 00:47:17.810 Ryan Luke Daque: covered everything.
473 00:47:18.260 ⇒ 00:47:20.510 Ryan Luke Daque: I don’t think there’s anything else.
474 00:47:21.870 ⇒ 00:47:22.779 suraj: Yeah, I, think I.
475 00:47:22.780 ⇒ 00:47:23.800 Ryan Luke Daque: Well, yeah.
476 00:47:23.800 ⇒ 00:47:26.160 suraj: I’m sure, while exploring, I I will have.
477 00:47:26.160 ⇒ 00:47:27.759 Ryan Luke Daque: Yeah. You’ll have a lot of questions.
478 00:47:27.760 ⇒ 00:47:28.330 suraj: He had to.
479 00:47:28.330 ⇒ 00:47:29.299 Nicolas Sucari: Yeah. All about the date.
480 00:47:29.300 ⇒ 00:47:35.339 Ryan Luke Daque: Or and stuff like that. So yeah, just hit us a message, we’re we’re always online in slack.
481 00:47:35.880 ⇒ 00:47:36.830 Ryan Luke Daque: So yeah.
482 00:47:36.830 ⇒ 00:47:37.550 Nicolas Sucari: Yeah.
483 00:47:37.890 ⇒ 00:47:45.049 Nicolas Sucari: And always, you’ll find someone, because, as we are in so different time zones, probably you will find always someone there
484 00:47:46.710 ⇒ 00:47:51.469 Ryan Luke Daque: I do work, however, mostly in this times like us time. So
485 00:47:52.438 ⇒ 00:47:58.701 Ryan Luke Daque: like Philippine mornings, or like maybe mornings in India, I will. I’ll I’ll be asleep so.
486 00:47:59.070 ⇒ 00:48:00.900 suraj: Got it? Got it? Yeah.
487 00:48:01.990 ⇒ 00:48:29.200 Nicolas Sucari: Yeah, and yeah, just I know there is a lot of information. There is like a lot of different tools and stuff to go and investigate a little bit. But, if you have any questions, don’t don’t wait for the meeting. Just shoot through slack, and we can go and help you out. And yeah, let us know how you’re how you’re doing with everything. If you need any help on the real stuff, on cloning the repo or anything. Just let us know. Okay.
488 00:48:32.580 ⇒ 00:48:36.393 Nicolas Sucari: I think we lost him or I. I. Oh, no, okay.
489 00:48:36.740 ⇒ 00:48:38.359 suraj: Thank you so much again for walking through.
490 00:48:39.510 ⇒ 00:48:40.160 Ryan Luke Daque: Sure.
491 00:48:41.170 ⇒ 00:48:42.149 Nicolas Sucari: Yeah, perfect.
492 00:48:47.290 ⇒ 00:48:47.720 Ryan Luke Daque: Yeah, I think.
493 00:48:47.720 ⇒ 00:48:48.690 Nicolas Sucari: Thank you for. Yeah.
494 00:48:48.690 ⇒ 00:48:52.620 Ryan Luke Daque: He’s he’s freezing. So Raj’s Internet probably is.
495 00:48:54.790 ⇒ 00:48:55.520 Nicolas Sucari: Yeah.
496 00:48:55.520 ⇒ 00:48:57.079 Ryan Luke Daque: Down or something. Okay.
497 00:48:57.470 ⇒ 00:48:58.180 Nicolas Sucari: Well.
498 00:48:58.290 ⇒ 00:48:59.150 Nicolas Sucari: perfect.
499 00:49:00.100 ⇒ 00:49:02.459 Nicolas Sucari: I don’t know if the Reggie is listening or not, but
500 00:49:02.480 ⇒ 00:49:07.169 Nicolas Sucari: I think we’re we’re okay for now let us know if you need anything else. And yeah.
501 00:49:08.170 ⇒ 00:49:09.969 Nicolas Sucari: we can. Yeah, okay.
502 00:49:11.170 ⇒ 00:49:12.710 Ryan Luke Daque: At least Internet.
503 00:49:13.759 ⇒ 00:49:15.409 Nicolas Sucari: Got this. Yeah, I’m gonna
504 00:49:15.980 ⇒ 00:49:29.900 Nicolas Sucari: I’m gonna go and send those email with the examples to post pilots and see how they can help us. It’s really strange. I mean, we have the conversions list, and we are receiving different stuff. And that postcard date is
505 00:49:29.970 ⇒ 00:49:32.400 Nicolas Sucari: I I couldn’t find it anywhere, you know.
506 00:49:32.400 ⇒ 00:49:32.960 Ryan Luke Daque: Yeah, that’s.
507 00:49:32.960 ⇒ 00:49:34.310 Nicolas Sucari: The in their tool.
508 00:49:34.890 ⇒ 00:49:36.749 Nicolas Sucari: I don’t, and and we
509 00:49:37.340 ⇒ 00:49:43.510 Nicolas Sucari: we never ask them for like filter by postcard date. Right? So.
510 00:49:43.510 ⇒ 00:49:44.850 Ryan Luke Daque: Exactly. That’s weird.
511 00:49:46.700 ⇒ 00:49:49.880 Nicolas Sucari: Yeah. Okay. Well, thanks, Ryan, for your time.
512 00:49:50.770 ⇒ 00:49:53.070 Ryan Luke Daque: No problem, thank you as well. Nicholas.
513 00:49:53.190 ⇒ 00:49:54.539 Ryan Luke Daque: have a nice rest of your day.
514 00:49:54.540 ⇒ 00:49:56.269 Nicolas Sucari: Bye, bye, you too.