 Let's see if this is working it takes a second for it to get over to my other screen, but hello How's it going? We're gonna be starting really really soon. I'm just making sure it's actually working. We're starting early If anyone was curious. Oh It's working great. It's really dark Wait, let me uh, I Give me a second. I have myself talking on this computer All right, perfect. We're good to go now. Hey everybody Starting a little early just because I want to there's no other reason Because we got a lot of stuff to cover. I know we have a lot of questions coming in already But I actually just refreshed my thing so I didn't catch any of those questions So if you want to ask a question that would be great go ahead and do that. I'll start looking at them soon I Got two computers here. I think I'm I think I'm sad. I think we're good I think we'll get started But hey everybody welcome to september's live stream. I do this monthly I do this for you guys because people have questions and I get Just hundreds of questions every single day from linkedin and twitter instagram Comments on youtube I actually I have a daily schedule in order to that I block out in order to answer those And now my wife is texting me Um, oh, she said she said to miss my live stream Oh That's okay, baby. I love you. Thanks for the support Uh, but I have I have blocked off time to do that But I can't get to everyone's questions And so this is kind of my time where I can do this live where I can start I can answer some questions and hopefully help you guys out There's already a ton of questions rolling in which is fantastic. Hey everybody. I see you guys Uh, we got ripper muhammad uh Anbu mani Monica anwar Everybody, uh Rushi m. How do you learn about etl? That's a great question. I'll get to that in a little bit Um, and then a bunch of other people Uh, eush rami What's going on everybody jasper? You guys are here. We're doing this thing. Um, so all the all literally if you've watched any of my other live streams This monthly live stream is just this where I answer questions Um, if you watch my like when I hit 500,000 subscribers or 250 like when I hit milestones I'll like play guitar and do like funny accents and it's more of a entertainment And then I do like giveaways and stuff That's more entertainment than what we're doing today. This is supposed to be more constructive I also do have a granola bar here and some water. So if you see me eating Uh, it's just because I'm getting I'm like low on sugar and I'm starting to crash um, so Let's get started because I'm just gonna go as long as I can go I usually can make it like an hour and a half So probably a little after because it's like 9 45 my time in the morning So hopefully I can get to like 11 15 that I think that'd be pretty good. I think that'd be all right I hope the audio sounds better I have this overhead mic up here and then I have uh this new mic right here It's just supposed to sound better. So that's why I got it. It doesn't look better because now it's like in the shot Um, and I'm not good with mics and all that stuff This one's out of the out of the shot, but I think this one's better quality. That's what I care about. I care about quality So with that being said now that we've introduced, uh, the live stream Let's start answering some questions Monica was from Atlanta Atlanta, Georgia. I was just there with my wife. We saw John Mayer in concert So, yeah, I love Atlanta Uh, Arushi M said how do you learn about etl? Well etl is a is A tiny tiny tiny piece of the what the actual overall what data analysts do in in essence etl is extract transform load at my old company. We used to do el t extract We'd load it and then we'd transform it. Um, and we'd keep those those raw tables. Now. How do you learn about it? I learned hands-on By far like I just in my job had to learn it for what I was doing with my work But if I was doing this independently, I wasn't Doing anything else. Um, I would try to set up some type of environment, right? So I have data in an excel spreadsheet And this happens all the time is a real world use case, but I have some data set in excel I want to create a process that Extracts that data into a mysql database into a post grace database into a python data frame or whatever it is Then you transform it And then you load it into wherever you need it. So whether that's tableau power bi could stay in python wherever you need that You can practice doing those things now it gets crazy complicated That is like the easiest version of it Then you'll have different data sources You need to merge these data sources in the database and you have to clean the data There's a lot of other things, but that's what I would do. I would start small Um, and then if you actually get a job doing that you're going to learn really fast It's it's pretty complicated Um, it's one of the more complicated processes that data analysts work on because you know, you work a lot with database developers data engineers on that stuff Um, but really interesting Um Let's see. I'm going to keep going down the questions Jesper says oh, I said jasper was jasper. Sorry jasper Jesper Yeah, jasper jensen said I have a question regarding data cleaning all those fields that has wrong or zero value What do you replace them with or delete them? That's super dependent on the data set because I've done every variation that you could imagine Um, if you absolutely know you're don't need the data and it's taking up a lot of space You have like 10 million rows and you don't want to say that in your database because it's going to cost money to save it Then you can just delete it and that's perfectly fine or what you can do is if you Can populate that in some way and it's useful to you you can try to populate it Populating data in and of itself is an art form. You have to know how why when to populate all those questions and so Uh, populating data is a very it can be extremely useful And it could also be really bad if you don't know how to do it So yeah replacing or deleting is totally fine. It's very dependent on that I can't tell you with the information you've given me on what to do because I've done it. I've done every variation But yeah, those are two very real options for null or blank data Malvika said ha alex. I've graduated from career foundry data analytics program I have applied to more than 80 companies and only gotten rejection emails. I'm sorry to hear that I know a little bit about career foundry because I've kind of partnered with them just a little bit If you're not getting a job work with their people and see if you can get a refund if you don't get a job Is that's part of their that's why I like them is because if you can't get a job you get a full refund It's not that bad But if you're not if you're getting rejection emails talk with you they have like people who help with that stuff It could be where you're applying. It could be your resume Um, if you're if you aren't even getting interviews, it's usually a resume issue or how you're applying for jobs Um Sally said hi from the uk. Thanks for your videos on tableau. You're welcome. Thanks for watching them I hope they're I hope they're really useful Um, let's see Aaron said hi my motivational data coach. Uh, hey, how's it going? I like I've been trying to get into like the um Not trying to get into it. I just like being like a really positive person So I like encouraging people and like sharing my story about like how I became a data analyst A lot of people have been resonating with that because they're like where I was I first started out which is like I was in a very Not a great job. I didn't like my boss. I was making no money um, and I kind of pulled myself up from my bootstraps with the help of my wife, of course and Um was able to switch careers and so a lot of people are in that exact same place And so I try to you know bring some encouragement to uh, linked in and twitter and and youtube and whatnot Um ripper the ghost cool name said can I get an entry level data analyst job with knowledge of power bi sequel in excel? Yes. Now here's why I say yes and why some people might disagree A lot of people think you need every skill to become a data analyst And I even teach a lot of these all those things I teach and I go beyond that um on my channel and You don't have to know all of them, but let's say you know sequel I'm going to count them. Uh, I'm just making sure sequel excel python power bi tableau Um, you can keep going so you could do azure looker Google sheets there's a bunch of other skills Let's say, you know eight skills, right? You know everything on one of those really well Well in your resume, you're gonna have all of those and so when you apply to a bunch of jobs The majority of those jobs are going to have one or many of those skills So you're setting it yourself up really well for the job hunt Now some of these jobs, let's say that was a hundred percent of the jobs have at least one of those in there Now you only know three of those skills. So now you're only Most likely going to be eligible for let's say 40 percent of those jobs So now you've really limited yourself. So the less skills, you know, the less, um, you know, you're probably applicable for in their candidate pool So if you just know those though, you're still good candidate for 40 percent of those jobs So it just limits you a little bit But here's what I will say is I've hired for jobs that I just needed someone to know service now I was working in it. I was an analytics manager. I was like, I just need someone who knows service now, which is another tool And if somebody knew it everything else is trainable. I just needed them to know that one tool That's very specific as a specific use case, but a lot of jobs out there like that We really need someone who knows power bi and we can train them on all of our other proprietary stuff that Isn't out there, you know, just for every for the general public It's a proprietary tool that we built or we use My answer to that is absolutely you can It's just a little bit tougher to find And I personally would just try to work with a recruiter and say, hey, here are the skills. I'm really good at You know, what are your clients looking for? They're like, oh, well, we don't use we use tableau We don't use power bi and you're like, well, I Learn tableau really quick or I know tableau And you can try to work with them So yes, you absolutely can get a data analyst job with just those skills It's just a little bit more narrow. It's a little bit tougher to find And a you should ask a very similar question learning python aws My sequel tableau excel is all enough to become a good data analyst. Absolutely. That's plenty Most companies and here's the here's the perception that a lot of people get when they try to become data analysts That's not my wife. That's chess I'm gonna I'm gonna keep it on in case my wife texts me the I try to Teach people this on my channel as well, but it is hard to It is hard to talk to really make people understand it because they if they don't have experience is that You can learn every single skill And you know that could take you a lot longer You could learn just a few skills and get really good at them take you the same amount of time Um, there's a hundred different paths to what you want to do what skills you want to learn You don't need to know everything and that's what a lot of people Make the mistake of they're like, I need to know every single skill. So you just named a lot Python aws my sequel tableaux excel just on your own trying to learn all of those things. It's gonna be tough aws alone is Very complex very complicated. There's so many things you can do in it I feel like I've used it. I used it for many years I feel like I still have just scratched the surface of what I can do with it Um, and so, you know, don't get too bogged down with learning every single skill It really is about learning something well and then finding A job that you wants to utilize that skill. That's what I found in my career too I really specialized in sequel for many years the first three years of my career I was like, man, I'm really good at sequel. I'm like really good at sequel Let me just see if there's other sequel jobs And there were people that were just like if you know sequel really well, that's all we care about We'll teach you all these other skills um, and so You know just some just some feedback Let's keep going. Uh, let's oh, oh boy. If you know me, uh, this happens all the time goes down um Thuong Thuan Duan, which is a sweet name if I pronounce that correctly. I'm impressed with myself. That's a sweet name Uh says sequel server or synapse for data warehousing um Data warehousing is made specifically for analytics synapse is great There's lots and lots and lots of tools out there But if I was going to choose one Probably synapse, but I'm more familiar. I've used sequel server longer And unless you're working with like really big data and you're trying to save money with like big data And I'm talking, you know, hundreds of millions of billions of rows. You don't really need Anything else You can store your data in a lot of places at small companies and it's going to be cheap Whether you store it in something like a data lake and you know how to model your data Or you're storing it in like a hot storage or is a cold storage depending on if you need it That's a really advanced data architecture um Data warehousing is meant for analytics, but you can do analytics with Anything that stores data So unless you're working with big data, that's all I'm trying to say unless you're working with big data you don't um You don't need To use something like data warehousing. That's an advanced that's for in my opinion and every company is different But in my opinion, you don't need to start using data warehousing until you have a pretty advanced or a ton of data and you have an advanced team that knows what they're doing and how to Maximize the cost effectiveness cost effectiveness and use case for that data warehouse. Otherwise, you're just wasting money um let's see Amen, mohammed. It's a great question. I get this one a lot. I'm 44 years old without any data analyst background Can I start? um My general advice to people like this and you kind of just gave your age My general advice to people like this is if you have Any transferable skills or domain knowledge in any other domain Then it could be relevant. For example, I've worked with a lot of doctors a lot of nurses nurse practitioners Who used to work in the field? But then moved over to the data side because they had an in-depth knowledge of how the healthcare industry worked And then they worked moved over to data And they were able to really really really do well So they like just they knew they knew it's so in depth. So then when they transferred that over They learned some data skills and they transferred that domain knowledge over they were making a ton of money Um, and I worked with a lot of them. I mean, I've worked with probably 20 to 30 people who did that exact same thing Um, not just in healthcare, but in it as well So they were working in like the it side of things and they moved over to data it Which is like now We're helping these it teams Develop dashboards and processes and procedures, but on the data side So if you can utilize previous Uh domain knowledge that is that's gold if you're starting from absolute scratch say you You know You literally didn't do anything after you for the past 20 some years You just sat on your couch did absolutely nothing. Could you do it? You'd have to work really hard Because domain when you reach when you get older there is an expectation that you know more And your value is derived off of that domain knowledge not always your technical skills like me right now My technical skills are really good But when I get hired because I own a consulting business When I get hired they're really wanting me for my domain knowledge for my experience for what I bring to the table rather than just technical skills Um, but you need technical skills to start. You can't just start with nothing So that's that's my general thoughts and advice on that Let's see Sully on a Solomon. I have a question. How do you think about taking an unpaid internship to land a job? Um, if you can afford it go for it I am in this economy by being honest in this economy I don't think you should be doing anything unpaid Uh, most people can't afford to do nothing. I could not afford to take an unpaid internship at this point in my life Um, excuse me Um So if you can afford it, maybe you live with your parents or a friend or something sure But you need to make it clear like hey, I'm taking this unpaid internship with the expectation that I want to work here Because I really like your company. I want to work here. So I'm willing to do this But I want, you know, if I if I hit my marks. I want a job here That would be something I would do And I'm more of a I become I've become In my career become a lot more straightforward with people because I'm like, I don't want to waste your time I don't want you to waste my time here. My expectations. Here's what I want And here's what you're gonna get for that. So hey, you're gonna get free labor Free work But that expectation comes with from my side that I'm gonna get a job here in three months Um Because goodness gracious it's expensive to live these days. It just is it's crazy Oh, this is a sea walkie. This is like a testimony a testimony all I guess Yay caught your live stream started learning sequel on python in 2021 To learn how to be a data analyst and your videos helped me a lot. So thank you And I just got my first data analyst job. Congratulations 2021 Two years ago, but hey, you did it That is fantastic. Great job Uh, let's keep going Carlos says hi, Alex. Cheers from brazil. Hey from the united states. What's going on? I'm I'm trying to get to these questions Got a lot of questions coming in Matthew quit doing that man. You're bra. You're braing me my uh, my windy's five five for five today I uh, I probably won't eat it today. I'll eat tomorrow. Uh, but Matthew said, hey, Alex Can you describe an architecture of both real-time dashboards, but also historical analytics currently eyeballing fabric for our company? Um, and Matthew and I we we go way back. So, um, you I know we've chatted about this a little bit I haven't Dived into fabric myself um, so real-time dashboards are a little bit tricky um, and You're also trying to do historical analytics so When you're trying to like stream data That usually involves something like aws or azure or some type of cloud compute right because you're getting a live stream of data And there are only there are only a there's there aren't a ton of use cases for it I mean it sounds like you need it But if you're looking at fabric that could be the way to go Um, I'm trying to think off the top of my head what because I know we used one in the I used one like four years ago It was in azure. I can't remember what it what it's called um Yeah, yeah, it messaged me on linkedin and then just remind me to look into this for you because I know it. I just can't sometimes when I'm like live. I can't think of things off the top of my head But just shoot me a message on linkedin and I'll I'll get back to you on that one The fabric could be really good. Um I'm I've been looking into fabric more ever since they came out with some of their announcements, which look really good So you might be educating me on this one so sorry to Waste that five for five If you're not from the us windies is like a restaurant that has A five five deal where you get a burger fries and a drink and chicken nuggets for five dollars and I love it I've been eating it since Since I was broke. I had no money and I still eat it today. It's like a comfort food for me. All right. Let's keep going Yeah, sorry Matthew. Just shoot me a message. I'll I'll give you a better answer um Let's see Let's see hussain ma food I said how power bi copilot will change the data analysis role and when is it going to be released great question? Actually, this is um a bigger topic that I've been diving really deep into is copilot just for windows Now if you don't know what copilot is windows is coming out with something called copilot And it's going to be across all of their systems. It's going to be for word powerpoint excel Um power bi just every product that you can imagine they're going to be implementing their ai essentially Now I've seen a ton of demos and I've seen a ton of people who's reviews. I haven't been able to get my hands on it Um, because I'm not cool enough But from everything that I've seen it It it and all the feedback that I've seen Um from people who are working on it and using it and getting beta testing it Uh, it's very lackluster. It's actually a lot worse than a lot of people are saying and that's what's actually really Concerning me right now is that It hasn't been super impressive and almost I haven't seen many positive reviews of people who have hands-on experience with it Now once I get hands-on experience, I'm going to be doing reviews So you guys can see exactly what I think I'll test it out with a bunch of different stuff That's something that I'm really looking forward to because I see that I see that as part of the future now If it gets really good Let's say because what people have been saying about copilot especially in excel is like it just doesn't select the right values It doesn't do the formula correctly. It actually causes more mistakes than it helps um, and when you try to like The way it is integrated with excel as you like do it and you're like, okay, put it onto this page And it doesn't work right and there's just a lot of bugs with it now. That's current version It's like beta version now. Let's say in a year. It's working really well. How is this looking? Now I imagine this is going to be something that you use quite a bit although not for everything it's for You know and you'll probably be talking to it in the future too. Is that what I imagine? um instead of Writing everything out right all that multi modal stuff that's been coming out Now, how will this change data analysis? um With actually writing code with building dashboards, which is definitely a part of the job, right? You have to know how to do those things. It's going to speed it up I Everything that I've seen and I've used in the past year um Has just been like it's like it's pretty good. It's pretty cool. It's it is helpful at times But I know it's not always going to get it right. Um, there is that expectation that it's supposed to be right every time It's just not going to be and so you'll still need to know the skills. You have to know these tools um Now in terms of How a data analyst does their work? Um You know actually writing the code and building the stuff is probably like Like 40 of the job. There's still 50 60 of the job that does not involve those things. Um talking with people You know understanding reviewing data architecture understanding how things pieces fit together Understand the business use case talking with stakeholders. I mean, you know, all those things are It's not going to help with any of that. Um, and it won't for a long long long time Technically speaking just on the technical skills, it'll speed it up. That's what it's going to do You still are going to need to know the skills. I can promise you that if you don't know the skills You'll be able to do like the bare minimum with these like ai tools automated stuff It's just not going to get you all the way there to everything you need to do. Whoops It won't get you all the way there That is just my that is my full wholehearted belief. Um, that is not going to be a perfect system You still need to know these skills quite well Carlos uh Comments that again say I changed my career path for about 1.5 years. No regrets dream job work in usa foreign company Nowadays I work as a data analyst any advice Um, if you have data data analysis experience, you already have a data analyst I've only worked with a few people in the who Have those specifications and actually one was from brazil too, which is um really wild But another one was from um the uk now they wanted to move to the us and they had some experience What did they do? I said This was my advice and worked out for both of them really well I don't know if this is applicable for everyone, but those two people here was my specific advice. I said You're from brazil find a brazilian company in the us Uh that that works with the us and try to work with them in brazil and then Work with them and try to transfer over to the united states that actually worked for both of them um and that took oh like That was back in Early 2021 so it's been like two and a half years since that happened But last year they made it so it's like it took him about a year and a half to do it So it's not like a short term plan the other thing and this is something that They want this is someone from Africa who was wanting to work for a us company. I said look at Accenture look at These like consulting companies that work with the united states companies So you can get that pay but work remote and you know, I The conversion rates for all the currency and everything, but they were paid very well And so they went that route which also worked really well But if you were trying to move to the us, I don't know how effective that is. I don't have personal experience That's just my advice See, let's see. Let's see Monica asks do you know slash recommend any companies that hire true entry level analysts? Like not looking for two three years experience or would it be better just to work with a recruiter? Thanks in advance Um, all right I'm gonna I'm gonna take a step back and kind of give you just like the general landscape of how hiring Works and data analysis because it is a little tricky. I promise you it is not straightforward. Everyone's really confused so I'm gonna kind of like Take back the curtain. This thing's actually getting my way. It's don't even know me I think I need to put it in front of me next time I'm not gonna do it now, but I'm gonna put it in front of me Because I'm a hand movement guy This is limiting my hand movements. Uh, yeah, I'm not doing that again. I'm gonna take it. I'm gonna I'm sit I'm sitting back a little bit All right, here we go All right, let me give you like a sorry. I just coughed on the mic. That's terrible all right guys I'm gonna give you kind of a breakdown of how hiring works and like teams If they're already an established organization Let's thank amazon tesla Microsoft These people have already a really established well structured organization And when you start building that Typically, they're not gonna hire as many juniors Except They do have initiatives where they want to hire people right out of college to get good Fresh Graduates on board at low cost Which is great Typically, those more stretch those big tech companies. That's how they do it So they're gonna hire for most roles mid-level senior level or lead technical lead managers That's just how they do it and then they hire on they kind of recruit from Colleges that is most of their hiring so most large tech companies don't hire true entry level Or if they do have like a post for an entry level or a job listing for an entry level They kind of already have it filled with like a college graduate or something like that And so if you're a college graduate, that's great because lots of opportunities that big tech companies in that area So like go talk to your college Excuse me try to try to like do that Entry level people a lot of times work with small to medium-sized companies or fortune 500 companies that Or and let me take a step back for example I worked on a team where I got hired as a junior data analyst at a fortune 10 company Now I already had a little bit of experience had one year of experience Would they've hired me without that? Maybe not this thing is falling. I'm getting annoyed at this mic already. I really should have set it up over there Maybe not So at these larger companies, they look for a little bit of experience don't have to have all the experience at Big tech companies much more experience. Then you go down the road Then you have startups Which startups sometimes hire entry level Um, and then you have small to medium-sized companies that are not in the fortune 500 just your typical Classic like company like that. You've never heard of it's not a big global company It's just a company Those are the people that hire the most entry level data analysts So if you're looking to try to break into tech into a big tech company with no experience, it's crazy hard Really really really hard. It just is and so my advice is don't Do that don't try to make that your goal to be like, I'm gonna do it because I'm gonna do it It's gonna be really really hard. Um, yes work with the recruiters But also go on linkedin and apply for these smaller jobs that are local My especially for entry level jobs first job if you can get try to apply local That'll separate you from the other 200 candidates who are all trying to work remote or want to like Move here from, you know, Canada to like New York or whatever try to be the local be that local person Hey, live right down the street. You have that connection with them That is my advice. So I knew I threw a lot at you But that's just how general hiring works in the data world It really does most people don't talk about they're like a lot of people will say Oh, you can get a job at amazon with no experience doing these things It just it's like one in a million. It's very rare Your highest percentage chances are at smaller companies to start once you have experience Then look at those bigger companies, but even then they're competitive. They're competitive Um Excuse me. What's the difference between sequel and no sequel? Uh ray rewall Asked this it has everything to do with how it stores the data and how you Uh Work with the data. I'm not going to go into it. Just go look at my video I have a whole video on sequel versus no sequel. Um pretty interesting But no, uh, I use no sequel for one year at a previous job Um Yeah, I'm not going to type too much into it It wasn't my favorite thing in the world syntax a little odd The way the data is stored is a little odd, but it can take different types of data. So like sequel can only use Structured data rows and columns or no sequel can take other types of data so Yep. Yep. Yep. Now. This is a great question this next one Suji Gopi Butchered that name and I apologize, but great question. Hey Alex How will data analyst jobs be going in 2024? Now for the past three months, it's been a Big no not even three months. Maybe like four to five months. It's been a kind of a downhill in hiring I'm very happy to say like september's been a great month for hiring I've had so many I've had more people in the past Like this month This has been the whole september more people this month reach out and be like, hey, I landed a job. Hey, you know, thanks for this Thanks for that. I was able to land a job more people this month in the past like two months two and a half months So picking just on that metric alone, which is kind of like my metric Just that alone hiring is definitely picked up. Um, but I'm going to go look in at the actual data for hiring After the month ends and they release that data to see how it was because september is known to be kind of a hiring month just because of how quarterly budgets and Yearly budgets and all the fiscal year budgets and all these things for companies. They need certain hiring They have certain budgets for hiring. They had it. So september is a good month for hiring So it's like january and then over the summer, but this summer was very odd and that it was not good Just because of all the uncertainty in the world right now the inflation that's happening in the world Wars ai all these things now that was not the question And I'm going to get to the question now the question was how will it be in 2024? I think it's going to be really Positive overall positive. I think it's going to be better than this year This year has been a very odd year with everything that's been going on in ai with everything that's been going on with A global conflict with inflation Hasn't been great now in 2024 my hope And kind of just talking with other people and I'm kind of connected to a lot of different companies Is they're looking to expand in 2024? A lot of companies are looking to expand their data teams with ai A lot of smaller smaller teams startups all these different companies They're like we have to grow our data teams a lot more. We need to hire on analysts data data architects data engineers And so I think overall it's going to be Hopefully better than this year because this year has been kind of a slump Just because all those factors. So I'm very positive that's going to be good. I genuinely am And if it wasn't I would tell you that wasn't positive Let's see Let's see. Let's see Sorry, I had to block someone so just he was just spamming the spamming it Someone said do you have any scholarship or free coupon in your courses? Now anwar is referring to analyst builder, which is going to be launching super soon Kasan if you're watching this which you may be He is literally finishing up. He's he's like We've been using this environment To build everything and test everything on the cheap so that we didn't cost a lot of money Now we're moving everything over to our production server for analyst builder Which is on aws And we're just transferring everything over once that is all transferred once everything set up on aws We're done. Um, everything is essentially done with the website. Um, and I'm not going to show it to you because I Well, I could But there's things on there. I don't want everyone to see yet. I mean, I have a whole video That's going to be releasing probably on tuesday upcoming tuesday Um, if you were a beta tester, you've already gone to analystbuilder.com You sign the waitlist you're a beta tester or you'll have access as a beta tester So you'll get 30 off all of my courses The the technical question stuff and that's just the beta Now scholarships. I want to do scholarships. I think I've always loved when people did that I want to do that as well. Once we fully launch I will be trying to do that in some capacity. Um, I either whether it's partnering with Companies that work like a nonprofit company that works with people to help them in tech or how I'm going to do that I'm not a hundred percent yet But yes, I definitely want to give out scholarships and and big discounts for people who need it because Um, I'm pricing everything to make it affordable for everyone I don't I'm not going to price everything like a hundred dollars a course. That'd be insane. I would Never forget myself. So Especially in this economy. So I'm trying to keep everything really affordable I do plan on doing scholarships and stuff in the future Um, phoenix vamp. Do you think the data industry is overcrowded and no jobs in the future? One, yes, it's it's it's always been overcrowded. Even when I was getting into it five or seven years ago now Two years ago when I was doing these live streams. I used to say five years ago But now it's been seven years, right? So seven years ago when I was getting into it It was still overcrowded. They were still every job I would apply for had tens hundreds depends on, you know Applicants then they would interview 10 people or more And then they'd offer me the job or wherever the job It's always been overcrowded. Um, ever since the tech boom back in like I mean early 2000s was a huge tech boom But then in like when data science started becoming really popular in like The mid 2010s and that took a boom. It's always been overcrowded. Let me just state that up front Um, but no jobs in the future. Absolutely not there There is going to be and there already is it's already happening. It's just we can't We don't have the day all the data for it. I think in five years We're going to look back and in five years you're going to be like I'm so glad I got in in 2023. Let's say at the end of the decade in 2030 You're going to look back and be like hiring was so much easier back in 2023 It's going to be even more overcrowded because ai With everything that's good about it It is going to need people It's going to need a lot of people in a lot of companies To actually make it work. It's good but I've already talked to a lot of companies who have hired me on and like, you know, I'm doing consulting now They're like, hey, we want to here's our current data infrastructure How is it? How can we set us up for ai now? Luckily? Because that's my job. I've been looking into all of these things. I'm like, okay ai is really big How how does this integrate with current tech stacks and all these things? So I come in and I'm like, I'm an advisor and I'm like, okay, here's what you currently have and here's what you need I'm like, and to do that you have this person, but you're going to need this person and this person to hire on And do this this work. That's what I do. That's A part of what I do and consulting is just advising And then they go and do that. I can already tell you that most companies are behind on their tech stacks So they're going to need to update and uh they're going to need to Upgrade their infrastructure quite a bit They're going to need to hire on people to QA all of these things Then they need people to come in and integrate ai and make sure that their Um schemas and tech stacks and everything are able to integrate with ai. It's a lot of work It's not jump plug and play the ai has been People on like twitter and stuff for example, I see this all the time They make this video and it looks really good. I'm like, wow, that's great. Then I'm like, okay Basically what they did was is they gave like some front end thing that connects to nothing on the back end But everything on the back end, that's where all the data analysts work is that's where the data engineering work Is that's where the data science work is that's where the complications come in with ai where ai is Not as straightforward and easy as it looks Um, so no jobs. No, I think it's going to be more jobs. I think there's going to be a lot more jobs um Probably in the next two to three years So getting in now getting some experience and then um Kind of riding that wave. It's just going to be a massive wave I I'm so confident you'll see in the next like seven years when we hit 2030 You're going to look back and remember this podcast or this live stream and be like Oh my goodness. He was totally right about that. I just have a feeling that's just my intuition That's just my intuition But yeah, there's going to be a lot of jobs and I think hiring is going to Especially in 2024. I think it's going to pick up quite a bit. I mean it's picked up now in september It's picked up quite a bit as well Kristen reed said yes Your story really resonates with me as a math teacher makes me see the possibility of a data analyst career as a reality Absolutely. I've actually helped some some teachers become data analysts. Um, I was doing mentoring I mentored over 200 people over two years and there was like eight teachers eight or nine of those were teachers and Yeah, absolutely teaching and being able to explain things Confidently being able to talk in front of people These are those soft skills that teachers have that really translate well Um to just the data world in general It translates really well when you're interviewing when you are really good at interviewing you're good at presentation skills Um, you're good at making eye contact and smiling like things that teachers are good at those soft skills go a long way I've been interviewing in the data world just in general, but then Uh, they were they knew all the tech skills as well. So learn the tech skills Adisha Says hey, alex, what are your thoughts on getting a job in the u.s as a foreigner? Do you recommend applying for a job first then migrate or the chance is great to migrate for a few months first This is not my area of expertise, but i'll tell you what one guy did um that I worked with His name was mohabad Great guy. Uh, he was working for 3 m if you know the company Mohamed, uh, did something a little bit unconventional and I told him to go for it and he went for it and he did it he was living in canada and he wanted to work in the united states and He got a job in minneapolis, minnesota, which I was born in minnesota And so, uh, I have a connection from up there and i'm like, oh, it's so cool So he wanted to live in the u.s make make more money lower costs of living all that good stuff So he learned all the skills and he was applying for jobs And I was like, he's like, I really want to move to minnesota. It's pretty close to the border I can come back and forth, you know, yada yada yada so I was like On the application he had to say where he lived And he's like, I don't live there yet But I know i'm in a move there. He's like and my friend has an address there And so I was like, hey, listen If you know you're gonna move there you already have a place to stay there Once you get the job, are you gonna be able to move right away? He's like, yeah I'll be able to go right away. They'll they would never know I I mean Listen, it's not a hundred percent ethical But I told him I said listen you could just put that you already live there and that you you know You have a place in the u.s. You have a place in uh, canada's not unheard of So just say you live there already so that you're local and that you have a better chance He got an interview. He got the job the next like two days after accepting the job offer He moved down there and he lived there and then he got the job um From that story take what you will Because in my opinion already living here is going to give you a big leg up Trying to work with companies through their visa process and all that stuff is complicated um And I have done it a previous hire of mine We had to work through the visa process and I now and I understand it better than I did before It's takes a long time to get all the paperwork signed He was living in india and we wanted to hire him on full time and all the paperwork all the waiting It took months took a long time. He was he was it was not a Like a random interview. He was already working for us through a consulting company. I really like them I was like, let me hire him on full time That takes a long time. Uh, it's not ideal. And so if you can already be here and kind of Get away from that. Whoops. What did I just do? Get away from that. Um It's better. It is better Um, excuse me, I'm gonna start eating a granola bar now. You may be able to hear my chewing But you're gonna have to ignore that because I'm I'm feeling myself get a headache And cranky alex is not the fun alex. You know what I mean? But while I'm taking this bite I am to be looking for more questions. Um This is random thing. I've never heard of this person. I'm gonna read it anyways So john says you seem like Andrew Leonard former irish cricketer and now comment commenter. Love you alex, sir I just thought that was a funny comment. I'm gonna take a bite now and I'll look for my next question That's delicious. Okay If you're curious, I go to Costco, uh, and I buy these soft Let's see if that I buy these Kirkland soft and chewy granola bars Uh, they are very sugary. They're not great for me But I love them and I have a whole stash of them right underneath that table Right there Just a little just a little insight into my life This is a good question though and says, uh, this is from Baibab judehav I'm currently following your boot camp. What should I do after completing it? so Genuinely, and I mean this with all sincerity If you can go through the entire boot camp and you can learn everything in there Get those projects done and everything You have enough skills to get a job You just do Now once you get into the job, you're still gonna have to do a lot of learning on the job You just you just are that's for any job anywhere always Because they'll have different tools. They'll have different, um Processes and procedures. It's just you gotta learn a lot. But if you go through the boot camp Genuinely, I wish I had that when I was first starting out if you go through it You have enough skills now. I don't go into everything crazy in depth. That's why I'm creating analyst builder So I can go into these skills really in depth and like teach you all the nuances and how to use it in like a real job So those will go more in depth But if you do that, you're ready to start applying You should start applying So that's it you create a great resume You start trying to connect with recruiters target some companies you want to apply for Target your area your niche start applying for jobs start reaching out to recruiters on linkedin start Sending your resume out just applying for jobs. You can start all that. It's a process It's a process, but that's what I would be doing Um calvin on the coast cool name Excel is so underrated in data analytics excel and sequel are so important. Yeah, that's why I Earlier when he said he knew power bi sequel and excel like that's enough most companies You'd be you would be shocked. They will hire data analysts for just excel work There are companies that hired just excel work because that's You have to think some of these companies are 40 50 100 years old They haven't moved with the times or they had no need to move at the times. They've been using excel They're like hey excel's been working for the last 15 years. No need to upgrade That was a company that I worked, uh, I consulted with not too long and on like guys Like you really need to upgrade. I was like it doesn't even cost that much I was like just hire on this person and this person get this these this tech stack I was like you would get all this work done that you do in a month. You could get done in like five days with some automation I was like you're really really doing a lot of manual work here and you're the way you're storing your data is abysmal So, uh, yeah, you you some companies will like that and you can get a you can go a long way with just sequel and excel You really can um Have I tried db have I tried dbt? Yes, I have will I make videos on it? Maybe maybe in the future not right now definitely not right now I have too many videos and too many other ideas that I think are more important Uh, you mesh. How can AI impact this data analyst field in the future? I kind of mentioned I talked about a little bit earlier, but I'll talk about it again Um, just because everyone's talking about AI all the time. Um, I've been I've been keeping up with AI like intensely I I Follow a ton of people I talked to a ton of people who are more Uh involved in it than I am I try out all the tools. Um, like like I've been using clawed barred chat dbt I'm really waiting on co-pilot because I'm going to be using that quite a bit to test it out get some videos out So you guys can see how it works and and if I think it's useful Currently data analysts are They are still very much needed There is no doubt in my mind that data analysis is Going to be something that AI absolutely helps with Um, same with data engineering And and here's the thing so like I've been what I follow so many people and on like experts in their areas Data engineering is going to be impacted. I would say almost the exact same As data analysis. So will data science in terms of technical skills because The data science or the machine learning models the data architecture with building these things I can create these pipelines are genuinely I've seen Exact examples of what data analysts with what AI can do with data analysis with data engineering and data science It's it's very similar. You don't hear people saying Data scientists aren't going to be needed anymore Data engineers aren't going to be needed anymore And I don't hear that a lot for data analysis anymore. Although maybe a little bit more The reason being is because AI can generate a lot of things But there still has to be someone there to Integrate it work on it do it reason with it Understand the outputs understand where it's making mistakes Understand the code Enough to know that's not the optimal way to do things And prompting it only gets you so far Um, I'll give you this is a fun example And it's something I actually talk about in my video in a little bit. You guys know I'm creating analyst builder And it's kind of like a leak code where you can practice technical questions We have easy medium hard and very hard the very hard questions Aren't in my opinion are not super super hard for real work Um, they're very hard for technical questions And that's what I tell you and that and you'll see it in the video when you watch it Is those those questions are more fun, but you probably won't get asked that in an interview but in real work Those technical questions Those very hard ones are ones that I've done that those are like easy ones to me It gets way further than that I tested those questions with chachi bouti and it can't it gets me like 70% of the way It cannot answer the questions Even if I prompt it I prompted it for like an hour Trying to get it to solve these really hard questions and it just can't Um Because there it's just too technical. It's just too complex. Uh, the logic and there's multiple layers of logic there It just wasn't getting it. It just couldn't figure it out I gave it every single point of information could possibly have needed I prompted it like 10 times. No do this do that just can't get there My genuine belief is that if that's how it's working with Very hard questions on analyst builder, which are still they're going to be really hard for you. I promise But those are like technical questions when you get into the actual workplace the actual workplace is way harder Like I remember some of the stuff that I was building. Um in my when I was like a data analyst, um Working at amerisource bergen. I was doing stuff that was like way more complicated than that And that just gives me it gives me pause to be like I know how complicated real work can get and chachi bouti is not even there It's not even close to being there, but it does help with a lot of like the simpler stuff It really does and so I I'm just I always am thinking about that. I'm like I always bring myself back can't do what I used to do and right now It's not there yet even remotely and especially not with a domain knowledge. Um Now I'm going to go on a small tangent after all that Is how can it impact data analysis in the future? What I predict and what I've already seen and like I predicted this Months ago and now I'm starting to see it a lot in twitter a lot on twitter is that companies especially like amazon aws Well with aws Microsoft are going to be creating Niche or very pinpointed models for different areas. For example healthcare or finance They're going to create llms or they're going to create these ai bots specifically trained on just that data like insane Like really in depth insanely knowledgeable in those areas Those are going to help a lot more with that gap of domain knowledge But again that is going to take quite a while And okay, let me take an even further step back now. I'm just going on a tangent. I'm just I'm just I'm going I took one bite of this granola bar and I'm back, baby uh You have to think about how technology progresses in companies um I've only seen One company that I've worked with and I've worked with probably 15 the past couple months That has even tried to integrate ai into their workflow Because it's very complex very complicated That's not my wife No need to worry because it's very complicated and They have not yet seen If it's going to be accurate if it's going to be ethical if it's going to be Something that compromises their data Um, or if it's even going to work So this fear that people are having right now Is something that is going to continue for like 15 years It's going to take companies years and years and years and years and years to catch up to this Especially companies that haven't been building their infrastructure, which is probably like 50 percent of them have not been keeping up with data infrastructure for the past You know 10 15 years So they have a lot to catch up on What all of this causes in my opinion all this causes is a huge influx of BOMO, which is fear of missing out on ai All these companies are going to need to hire A lot of data engineers and data analysts qa analysts um Technical people to make sure these systems are working right to test them ad nauseam And build out their data teams to then maintain those systems that they're going to be betting their entire companies on in the future It's so it's just going to Explode the data space And that's why I said in the next two to three years We'll see a huge uptake and hiring that's that's kind of my estimate for a lot of companies to start being like Oh These products and ai are coming out and they're actually useful We can't we can't verify it yet with co-pilot and all these other things We can't verify how useful they're going to be integrated into the systems yet And so in two to three years once they're tested once we started using them once I make youtube videos on them and everybody trusts it Um, then people will start being like, okay Let's take a break Let's revisit our plan for the next few years. Where do we want to be in the next few years with ai? How are we going to get there? We need to hire on people who are who know what they're doing Or to test these things And build out these things and and you know, it's a lot of work. It is so much work It's not plug-and-play and it won't be For very few companies it'll be plug-and-play. They big tech companies have been really keeping up like uber Uber could probably go into one department integrate ai and because their tech stacks are really developed It'll be ready That's like a big tech company. That's not going to happen with your mama pop shop Even most fortune 500 companies still run on excel. So Just trust me when I say I hope you can trust me and this is why I firmly firmly believe that Our field will change a little bit over time and I'll try to keep you guys as updated as I can Our field is going to change over time to incorporate more ai tools But their their tools they still are going to need you and you need to know the skill better than ai I promise you and I right now on a sequel level Uh can honestly say that I can do better than any chat gbt anything that I've seen so far Um, it just I have to go in and fix things and I'm like, that's not the best way to do it I know it's not like I know it because I know it. I've just been doing it So I'm like chat gbt. That's not the best way to do it do it this way and then they're like, oh, you're correct Let me fix that and then they don't do it Exactly correct again. I'm like, no you have to do it this way because of this then they try to do it. It doesn't work All that being said I'm going on a huge tangent about ai right now Is that My genuine belief is that there's going to be a big boom in the next two three years And learning these skills now become really good at them. Um, trying to find a job trying to land a job It will help you ride that wave with, um with ai Now I'm going to give you one last example Uh, it's like it's like buying and selling a home. Okay You buy and sell a home Back in 2020 or you you buy a home in 2020. You're going to ride the wave of buying and selling homes, right? So in 2023 home prices are crazy, but if you bought a home back in 2020 You can sell your home and buy another one because you made a lot of profit Then you have that home and then in five years and the prices are probably even a lot more than that You can buy sell a home. You've ridden that wave If you wait and you wait and you wait and you wait and you wait Now you're trying to buy a home. That's like $600,000 that used to be worth 300,000 It's it's it's just a symbol. You have to catch it while it's going instead of waiting and waiting and waiting Just a just a random analogy um Ahmed, what do you say about data camp? Career, I'm guessing career data analytics. I took some of it and it's pretty good and I do like data camp um But I didn't use them a ton personally like I I took a like one or two courses I always use you to me because it was a little bit cheaper so Take without what you will I'm taking another bite Let's find another question um It's Rick Rishnan Hey, Alex. I have a question for you. If I learn some basic knowledge on etl and ssis Will it be good for business intelligence as a fresher? uh, yes Yes, you can but there's also a lot of other tools for um, oh geez ssis stands for Give me a second. Maybe I need to google it. I forgot what it stood for uh It's like statistical software Let's see server integration services. Um Yeah, yeah, so that's etl so I used ssis. I always forget There's another one like ssrs, which is some statistical. I can't remember all these. There's too many acronyms in my life Don't hold me down either ssis was really good. I used it for some automation stuff or building etl pipelines back in the day um for business intelligence, uh like a bi Uh, I would actually look not as a bi analyst bi developer business intelligence developer is going to work more with etl and ssis But yes, you can You can that's a good one. Um Yeah, there's a bunch out there now that do that and there's uh just for like There's a bunch. I can't I actually I'm thinking of too many off the top of my head that I'm like I don't even want to go down that path. There's a lot That you can um look at these days Or etl processing and there's so many companies that do it now that I a lot of them that I Work with Let's see Oh, it skipped down. I just skipped a bunch of questions. Sorry guys Matthew said he asked to leave he asked very politely. He said please behave and I agree Don't make me don't make me do anything else If you guys didn't know Matthew is uh, he's a moderator on the channel Love the guy. He moderates so like he comes in and he makes sure people don't spam things and he gets rid of them Um, and so I always appreciate when he's here. So thank you, Matthew. You may not see this, but thank you um Alex analytics, which is a great name. That's what my company is. It's alex analytics LLC Um, he says can I please intern with you? I believe it will change my life Um, as of right now, I'm not taking on any employees. It's just me with the company in the future I want to expand my company because I do I turned down a lot of work Here's the issue with this though, and this is what a lot of people Maybe don't understand or or you know or get mad at me about I turned down a ton of work right and I probably 99 of what gets sent to me an email saying halex. Can you do this? Can you do this? Can you do this? I say no Because I don't have the time or I don't want to do it And then people like will hire on an intern or hire on somebody And they can do that work. They can make money and then you can You know make money out as well the issue with that the biggest issue with that is They want me That's one of the biggest issues. They want alex the analyst Because they they know my domain knowledge. They know what I know And they like my personality and they hire me for that The second thing is quality of work If I hire somebody on and they do a bad job or they do not do live up to the expectations I am responsible for that and so if I hire on an intern if I hire on another employee Um And they don't do a as good a job as I would have wanted that's on me. That's my fault. I hired that person That's on me. It just is and so that's a lot of responsibility and I just have right now I have too much on my plate. I do youtube. I have three kids I have a wife. I have my analytics consulting business. I have analyst builder that I've been building for the last year We're just gonna launch like Next week or the week after Literally that's almost done. So I just I have too much on my plate. I can't I can't manage one person right even one person. I just can't Unfortunately can't so those are the reasons why no, I'm not taking on an intern right now I'm not hiring people for alex analytics. Even though I have a surplus of work. I just I don't have time to do that. So I'm sorry. I just that's just my That's my overarching response to anyone who asked that question The housing market is broken. Uh, yes, it definitely is the housing market is broken for sure. I mean I have some friends who are on like the law side of um The law side of real estate and You know They're saying it could there could be a big crash I don't know. I don't know enough about real estate if I'm being honest Let's see Sai chapiti said hi alex It seems like the data analyst job market is really tough right now in the us What do you think of other data related roles such as data engineering? I should think it's if you're starting from scratch. Let's say you're starting from scratch from both data analysts and data engineering I think it's far more difficult to get a data engineering job than a data analyst job like 100 harder I think it is much more difficult data engineering is Really complex. Um, you have to know a lot more tools a lot more in depth a lot more technical and Most companies are not going to hire you on if you just know the basics They need someone who can come in because data engineers are expensive More expensive than data analysts They need someone who can come in and start building and start completing tasks because they have very specific things data analysis is can be a little bit different because Data analysis, whatever tool you're using can be somewhat transferable if you're using You know power bi you might know tableau if you're using this skill You should be able to pick up this skill pretty quick or it's it's easier to train on a little bit They're needing someone who can be client facing who can Interact with the clients and get requirements and then translate that to business impact and then build the dashboard whereas data engineers More than not Aren't interacting with people as much. They're doing a lot more technical work And so I actually think it's a lot more difficult to get a data engineer job right now and it is a data analyst job It's just as saturated as data analysis, but data analysis um has a little bit Different it's just a different way that you work within the business Let me see thrill ox shimmy TD said hi, alex. I'm a seasoned healthcare professional. I'm now transitioning to data analytics and AI in healthcare A lot of healthcare companies still use sass a lot. Will that change the next few years if they're using sass? Let me just say I just went to a sass conference. Uh, I learned a lot about sass But here's one thing here's one thing about just like companies in general if they've been using it They're gonna keep using it If it's working it's working That's what and sass is still you know, they're still upgrading and they're still keeping Pretty present. So most likely no, uh, they're not and healthcare is like the sass is really integrated with a lot of healthcare companies I'm finding And so probably not It's just probably isn't sass will probably be very relevant in healthcare for a long time to come Yeah, equal integration services. Yeah, thanks for yeah, I I didn't see it, but thank you I see it now um Oh geez it skipped to the bottom again guys Why company not hire freshers? um companies do companies do hire people with zero experience but most Most people look at big tech companies when they look at that and which is true They don't hire a lot of freshers or entry-level people Because they're a big tech company they can choose whoever they want So if they want to choose someone who has two three years experience and pay them at a lower rate people are willing to do that now There are HR rules and regulations on you know, they have like tiers for hiring But in general they want people who are experienced who know what they're doing who aren't going to break anything And they're going to come in and make a business impact pretty immediately So that's why they don't hire a lot of people But if they do hire freshers or right out of college or entry-level people It's because uh, they can get them for cheaper. They get they can get them from good schools Um, that's usually why they do it now the ones that do Uh get hired on as entry level or freshers are people who um look at Typically who are looking at smaller to medium-sized companies Who knows technical skills, but also know some of that domain So, you know, they did an internship or at a healthcare company now They work for a healthcare analytics company or that's kind of similar to what happened to me I had some healthcare background I transferred in um To work in healthcare analytics And so I mean everybody has a different path Um, but yeah, freshers are still being hired for sure And there's a lot of people that message me and say that exact same thing. They're like Hey, I I just am out of college. I was able to land a job You know really appreciate your youtube channel something like that some along those lines And so I see it all the time. So yeah, people are still definitely People are still definitely getting hired Um any programs for apple to follow your boot camp? Yes Uh mac does not play well with um Microsoft sequel server or power bi Or excel for some small things You can get a microsoft laptop hp laptop Or you can work through docker On mac or you can work through something like a virtual machine that has a microsoft Um that has microsoft where you can use it. So those are options And I have people reach out to me saying they use docker and it worked well But uh, there is my sequel as well. There's other tools besides power bi like tableau So all that being said Is vba and macros required for data analyst? Uh, no, I still don't use them that much. I like them If there are use cases for them, I'll use them But no, I don't use them a ton, but some companies do so if you know them great. If not, that's no big deal It's me. So uh with a lot of sad sad emoji faces. So I have to do this one Hi, Alex. Can you show some of your works done in company? So we'll give us a clear view on it. I think so, please Uh, my answer is no, I can't because I signed contracts and non disclosure agreements. Um So I can't share anything from any company. I can give you high level information about what I do with these companies um because I've been branching out from just working as a company man as a manager or a data analyst at a company to Write my own consulting business, which is very different Very very different than a typical nine to five job Now I get a pick and choose who I work with the jobs I take on the clients I work with Um any very so sometimes they hire me on they're like, hey, Alex You know the data analyst market, you know what they like what they don't like come in and help us with marketing So then I come in with product fit. Who should you be targeting for your product? Oh, you were trying to target, you know data analysts. I'm like, no, that's not no That's not that you want to target managers of here or do you want to do director level or sea level? So I help them understand that and help, you know, use my experience with that Another part is I actually come in and do data analysis work So they're like, hey, Alex, we're really having trouble with automating this data pipeline Um and it's in microsoft sql server and we can't get this to work and I come in and I actually just solve the issue They're just having a one-off issue or a larger Um issue and I'm like, well, let me come in and see what I can do And then I charge for that Or they come in and they're like, hey, you know how to use Azure really well, how would you integrate? How can we move from on-prem servers to the cloud? That is literally something that I just did with my last company I took us from on all on-prem or you know, we had like one thing in the cloud to completely on the cloud and no on-prem On-prem is just like you have your own servers at your company versus In the cloud where you're storing everything in the cloud, which has its ups and downs Um, and so I can walk through that with them help them actually migrate their data and tell them who to hire how to do it All stuff I have experience with And then I do like some brand deals or public speaking and that's totally different But that is something that I I offer and I do So those are some of the things I do But I cannot no I can't disclose actually the work that I've worked on or that come I actually I probably could do the companies Um, but just to be safe. I'm not going to because I'm not 100% sure about that All right. I'm looking at questions looking at questions This is a good this is a good one. This is for people working on resumes says, uh, this is from Rahul Kaj Kajanchi I didn't say that right Hey, Alex if we include our portfolio link in the resume, wouldn't it make sense? But wouldn't it make same as adding project names in the resume? Okay So I have I have a whole video on how to make a resume and I talk about that so go check that out But here's what I will say Some people aren't going to click on your portfolio website link or they just don't want to they don't care about it Some won't I think if you're doing really cool projects or if you're working on personal projects, you should add them You just say the name of the project You have when you did it you say the tools that you use to build it and then what you did in the outcome of that project Here's what we here. Here was the outcome of this Um, and it's just like a two liner really short really simple and to the point you you can get the free resume template on that video um The reason for that and then you can even hyperlink That like your title of it you you highlight over it you copy from your portfolio that link So if they want to they can click on that they that project said oh, that's interesting project Let me see how they did that they click on the name of the project. It brings them to your portfolio website So you can have it more than one that's what I would do and that's what I oh I recommend everybody do the reason for it is because sometimes these projects really catch your eye Um, there have been times where I've looked at a project. I'm like that's really interesting Time is it? 11 o'clock. Okay Okay, I can tell I'm still doing pretty good No, I'm like that's a really interesting project. It's not like your run-of-the-mill kind of just generic project This is like one that they did like personally with some personal data Or for like Excuse me some niche Won't you real quick? I need this Can you hear that? I'm sorry. I just wanted to do that All the people who hate chewing they're going to be really mad at me. I hate actually chewing doesn't really bother me that much I know it does bother some people That's my answer to that scrolling through questions Very interesting. This is an interesting question. Meg Hi, Alex. I'm a career librarian who recently accidentally fell into legal tech Any advice on which programs I can focus on to boost my skills for this industry? I know nothing about legal legal tech or legal analysis or anything like that I have a lot of friends who are lawyers Um, but legal tech I I don't know anything about Um, if you can in the chat just put what skills, you know that they're currently using at your place And then if I recognize any of them or I've used any of them, I'll tell you where you can learn it Reading questions now trying to find more There's a lot Oh, this is a this is a good question Dat data dork sweet name. Uh, are there any new exciting skills recruiters slash hiring managers are focusing on or looking for? Very good question Um I have There haven't been any like emerging that are like crazy need to have even AI on a resume is Like chat gpt AI, which I think if you have been using it and you've been integrating it with your workflow put it on your resume It's good. Um Because you know, some companies might be like, oh, we don't use AI, but this guy knows AI so we should hire him all that being said It's still still the basics one thing and one thing alone Has been popping up more and more All the basics are still there sequel excel python tablo power be all these things one thing and one thing alone has been Coming up more than normal and that's cloud not just Azure aws now they're looking at more specific tools like data bricks starburst all these like kind of smaller tools They're starting to put these on resume applications and people are being asked about them more I call I didn't I hate to say I called this but I said this back in 2022 when I did my how to become a data analyst in 2022 video And my video on how to become a data analyst in 2023 I reiterate it with even more emphasis and you go back and watch it because it's there the records the record show is I said Knowing a cloud platform like azure native aws is going to become more of a standard Especially in five to ten years You're going to they're just going to expect that you know it because nobody's going to be using almost Actually, that's not true. There are some companies that want on-prem for security reasons and other reasons, but The majority of companies are moving to cloud and they want people who already know how to use the cloud how it works all these things Even if you don't know Azure super well, you've used aws or you use this or you use that or you use google cloud platform Who are for people who actually use that? Whatever it is Uh, I have seen that increase dramatically and the people who have even told me but not just that just in uh If you look at more jobs, you'll notice that a lot of them have cloud platforms on there now Oh, we use google cloud platform someone who knows that would be great someone who knows azure, etc So that is the one skill that in the past year has become much much higher They're focusing on and asking about more Let me keep going All right guys, we got about let's say 10 more minutes And then we shall Wrap it up for this month's livestream I'm still getting through questions See a lot of questions in here Victor so this is just interesting. I'm gonna kind of walk this in my head. He said alex I built two excel projects two sequel projects. I put them on linkedin for one month no offer even for internship Well, were you applying? Were you reaching out to recruiters? Did you make a great resume and use my resume template? I need more information victor I need more information Because you can put things anywhere and people aren't gonna reach out to you You got to put in the hard work my friend. So tell me more. Tell me more victor. I'll be reading About how you've been applying Uh in your resume and all these things and you just and you also said wait, where was it? It's only been a month And I say this in the kindest way one month is like not that long It took me like six months to get my first day to know this job And I'm not saying that from like well, I spent six months. I see people takes me a year That's a long time. Some people takes three months I don't know of anybody who's no, that's not true. I know I actually do know a few people have done it in like a month After starting to do apply, but that's really early He takes months You got to put in got to put in the extra effort Unless you did already which then tell me in the comments below and I'll read it In a streamlit web app. It is way more involved than tableau Uh to bias. Yes streamlit is not A stream you're like coding it And I built streamlit streamlit apps before They're really fun. I really like building them. They're really, uh, it's really neat You should go check out streamlit if you haven't Again another tool There's hundreds of tools you would not believe Usually when I see a job Like any job any job on the on the market for data analysis It's like sequel excel And then you'll see three or four other tools that you've never heard of or you've never used before for any job and there's because there's Literally tens of thousands of tools out there. And so streamlets another tool Really cool tool as well Let's see I can't seem to bring myself to stay focused that and Absolutely, his name is lost or their name is lost. I can't seem to bring myself to stay focused It was it it could be hard to focus. Um, not only just due to Like maybe you have add or adhd or something like that. It's hard to focus It could also be environmental things you have a family to take care of you have Dogs running through the house kids running through the house. You have a job that calls you all the time. So it's hard to stay focused But for me what I used to do and this worked really well Is I had all those things I had kids a job dogs I personally just I waited till everyone went to sleep. I sacrificed a little bit of sleep Maybe two to three hours a night Yeah, ish And I just Used that to stay focused I I would turn and I actually had a whole podcast on how I how I had to do this because I realized that I got really distracted easily I would put on netflix in the background. I get distracted all the time by it He's going youtube and all these things I had to cut everything out I literally logged off of netflix so that we I couldn't log in I Stopped watching youtube. I don't remember what I did for that. I don't know if I blocked it or what I did But I like I had to remove those distractions so I could focus on the stuff I knew would pay off in the end. So, you know, there's lots of tools and Ideas on how to do that. You just got to find something that works for you. That's what worked for me Look at them. Look at them. Look at them Anima Goyal Goyal says how to cover a career gap and interviews have two years of gap. I'm a covid batch student didn't get placed from CLG, I don't know if that mean call college Please suggest anything worked in another domain for a year now applying data analysis again um I don't know about all these placements and stuff that doesn't really happen where I'm from um, but Uh, I guess my biggest advice is you got to start that you got to start that train again Right when you're in college and you're learning and you're you're in it and then you start trying to get jobs after college You're like in this Rhythm the system and you're like you have people to help you and you're like going there's a flow to it And then you land a job when you get out of that for like two years and you have to like Geez, I got to start applying again. You have to like start that train up again You have to start reaching out to recruiters again. You have to start connecting with people again You have to start it's it's tough. You have to start the engine again Um, that's my only advice. I don't really know too much about that. Unfortunately. I'm sorry but It's kind of my general general advice Uh, edu mail said I work with amazon as an investigation specialist. I work with a lot of data I have enterprise expertise in sequel etl and excel Can you suggest me if I should stay in amazon or move to some other company? If you already work at amazon and they they can hire you internally do that I've worked with a lot of people who were already working at a company They liked they just wanted to work in a different department. You have to make it known. You have to Talk to um hr talk to your your manager and be like hey listen. I really like working here Oh, it's I've been learning these skills. I really have a passion for it You know, I would love in the future Maybe like a year or two to transition into this type of career. How can you help me get there? You know, I've had people who I was aren't we're on my team do that You know, it happens so That's what I would recommend But you also have amazon on your resume which looks good So you can use that to your advantage to work at another company If that's the way you want to do it, you can probably get a pay bump as well But it's up to you skip down Rick and Morty, do you play any computer games? Not anymore When I was in college I used to I was on a league of legends gaming team So we would play against other schools. I was on my school's team And we would play all the schools in our area would come and we do some big land tournament And we were pretty good. I mean I played league of legends. I played a little bit of dota Um And but yeah, I haven't in the past like seven years So I used to love gaming, but then I got a family. I got kids. I got a job Um, and I do youtube and youtube is like my gaming man. I get a high off of uh, of doing youtube stuff, man It just it I get like I get fueled by it It fueled by it's crazy Let's see What's the difference between a business analyst and a data analyst? I just released a video on that go watch it No, I did not play csgo I played a lot of halo though. In fact when halo three came out me my friend me and Three my friends were of the first 100 people in the world to complete legendary um On their campaign On co-op grow we were one of the first and boy was that difficult Growing sports analytics world. Uh, it's growing. It genuinely is. Um, the thing is that sports is really niche Sports is a really small niche, right? Let's think just nfl. You want to be an nfl sports analyst? um, that looks at the data Every team might have what one Two it's like a hundred and there's only like What 50 teams 60 teams the nfl That's not a lot Maybe college football will have a little bit more, but I mean well, they definitely will have more but goodness gracious It's it's a small niche. That's hard to get into and stay into then you have different sports You have golf and cricket and all these other sports soccer, of course so Is a dupe useful and data analysis, uh, that would not be a skill that I would personally be learning No You don't I mean I've worked with a dupe But it's not like I'm like, well, you need to go out there and learn some hadoop. That is a really in-demand skill Uh, no not for data analysis Who's talking about halo halo doesn't get enough flowers I don't know what that means Maybe that's an inside joke that I should know um Let's see I'm just uh, how many minutes we got? Well, geez. We got like one minute left. I'll answer like one or two more questions and then That'll be good to go I'm just looking for more questions. Um A lot of the questions that I'm seeing are like ones that I've kind of answered already This is this is from camille washington. Hey, alex I work for a company who's building an analytics team And don't plan on moving me into a data analysis role for at least a year Did I hold out to hope? Um, if you like the company, here's what I would do It does not hurt to apply to other companies because In a year, they may have it in a year. They may not that's not a sure thing Now if it was a hundred percent a sure thing I would still be applying because maybe you find something better out there Or you can say you have a counter offer you can say hey I have an offer on my current company to become a data analyst But I'm looking to move external for xyz reason or money better vacation. It doesn't matter That would be my advice is even when I was happy in my current company I still was applying um after about a year just because I was like Hey, listen You don't know what's gonna happen That is my advice. Let me see if there's any more All right. This is my last question of the day ryan. You lucky dog you ryan Dirijlal, I don't know how to pronounce that. I apologize about to start my first day as a data analyst on monday Congratulations. Do you have any tips to avoid feeling imposter syndrome? I'm afraid I'll get started and not know what to do on the job. Let me tell you my friend Everybody gets imposter syndrome about everything It just it just 100 percent happens Imposter syndrome isn't that feeling like everyone knows more than you that you're not as good as everyone else And you feel like i'm the only one who shouldn't be here. Everyone else knows what they're doing That's in general what a imposter syndrome is Now I had imposter syndrome quite a bit as well. So just know that one it's normal. Okay Two, how do you actually get over imposter syndrome? my biggest advice and You know, you have to take this with a grain of salt because everybody's different Is that when I got into a company and I or a new position or whatever is I would try to learn as fast as I could And then take on projects once I started feeling like I was contributing to the team my imposter syndrome went away I was like, hey I'm getting projects done. I'm doing this. I'm doing that and I'm going to do it faster in the future Like I'm contributing now Those first several weeks you're just there to learn for the most part You're there to understand their databases understand their data understand their clientele Understand your part of the team what you're hired to do You're just learning and so you feel like you're doing nothing while everyone else is doing something Well, those people started one day and they didn't know what they were doing either But they've been there for a while now So just know that everyone's been in your shoes. Um, ask a lot of questions Because they there is an expectation that since you're new you don't know anything So don't be afraid to ask questions to look intelligent the worst thing you can do is act like you know everything and then People are like, hey, do you have any questions? You're like, no, I got it But then you actually don't know anything And then you can't get your work done and then you look really stupid It I've seen it. It looks really dumb But if you're just like, yeah, I don't understand how we're getting this to there Is there what process are we doing? Or are we just ingesting the data that way ask questions? It makes you look smarter It's like opposite of what you think Because once you start asking good questions people are like, oh, that's a good question Well, here's how it actually works and you learn So that's my biggest advice learn learn learn learn learn learn learn learn learn learn learn learn Then start producing output start picking up projects start Getting work done That impostor syndrome will we'll go away All right guys That is it for this month's live stream. Thank you guys so much for coming Uh, we had a lot of we had like 270 people concurrently probably a couple thousand people filter in and out Um really appreciated. I love when you guys come to these things and just ask questions and we hang out and we chat. You guys listening to me eat granola bars. Oh, it's a good time. It's a really good time. So if you have any other questions, shoot me an email or a LinkedIn message. My email is like, I had gotten down to like 200 emails. It's back up to like 500 again. So I'm really backlogged on emails. LinkedIn is probably the better way to get to me or maybe Instagram, like the social medias. So if you have like a question that you really need answered, I can try to answer it, but no guarantees. I get way too many messages, which I love, but I just can't answer them all. It's impossible. That's why I do this, right? All that being said, really enjoyed this one. There's lots of good questions. I went on a few tangents. What can I say? Went on a few tangents about AI. Definitely has a special place in my heart. I'll be talking about it more, doing more stuff on it in the future, especially when co-pilot comes out. But ChatGBT, I wasn't really impressed with code interpreter as much as I thought I was going to be. So I didn't even make a video on it. It was kind of lackluster in my opinion. And, you know, so, and it's really limited and I don't, don't get me talking on this stuff. Okay guys, you gotta stop it. All that being said is I'll do more stuff on AI in the future when the time presents itself. I'm not making a video on it. I don't, I don't know what to say. Like code interpreter wasn't a big thing for me. All that being said, as I appreciate you guys. I'm gonna click the stop streaming button in just a second but I appreciate you guys coming. I really do. Have a good day. It's Thursday, skip Friday. Don't go to work on Friday. You don't need it. Tell them I told you you didn't have to. Don't sue me if you get fired. And then have a good weekend. Just have a great weekend, guys. All right, I'm stopping the stream. I love you guys. I care about you. Send me a message if you need to and I'll try to help you out. Sign up for Analyst Builder, The Waitlist, AnalystBuilder.com. Anything else? I'm gonna finish my granola bar and some water. I need to, you know, rust this head of mine. Didn't eat enough.