 Hello, hello, hello, hello Give me a second. I had some trouble with my equipment this morning. So I'm just making sure Everything's working Let's see Looks like it's working. It's a little dark. Let me um Let me open up like a window or something. I don't know that helps a little bit Maybe open up this one to getting all the natural light in here today. That never happens Let me see This is wild. This is wild. I never have these windows open. I'm only doing it for you guys. In fact, I don't actually like Get open that much We'll deal with it. We'll deal with it. Oh, we're gonna get started in just a second. Wow, this is really bright It's a little too bright. I'm closing in a little bit let a little bit of the light in I don't want to get crazy All right, this is good We're gonna stay right here Let me go over Here Let's see what questions we got coming in That light was the light issues been bothering me. So I'm sorry Let's take a look at what questions we got. Hey, everybody. I see everybody coming in. I haven't looked at anything Let me let me like Figure out what I'm actually doing really quick Let's see From Salish Sea. What's going on? I'm down down south. I'm down in South Carolina So, hey, I'm from the United States. I don't know. I don't know where Salish Sea is. I'll have to look that one up Yet you did make a live. Hey everybody. I'm noticing some faces. I recognize already. Hey, everybody From Nigeria Egypt, let's see See Iraq very cool India awesome Now if you haven't been one of my live streams typically all I do is I just answer questions We just chat we just talk we hang out I'll answer just about any any question that you guys have We just see how it goes usually I go like an hour hour and a half fully dependent on how many questions we have we have about Almost 200 people right now at the beginning sometimes it gets a little more and then It's hard to keep up with questions. So I'm gonna do my best But let's get started with the question. So I don't fall behind too too far Um before I even started the live stream a Many manure asked a good question and I think it's a question that a lot of people have With not just the skill but other skills and the question is is it in a job interview? How can I show that I'm confident with my skills in power BI even though I don't have experience working with it? This is super common one and this is one that I had trouble showing when I first started, right? It's like how do I show I have sequel skills? How do I show I have XYZ skills that you're confident in it? The answer to that is a few different things The first thing is just really working in it a lot to understand the terminology Understand how it actually works so that when they're like, hey, how how do you use power BI? You can talk specifically about things that only someone who would have experience would actually you know talk about Experience being you've built things in power BI for you specifically. So for me What I would do is I would build out a project and I we talk a lot about projects in Around my channel in these live streams because a lot of people don't do them They don't see the value in them. I am a big big big believer in projects If you've done my data analyst boot camp, there's a bunch of projects in every skill So I'm a huge believer in it. So when you build that project, there's somebody in an interview asks you, you know How do you how much have you used power BI? You say, yeah, you know, I'm really good I've been using it for let's say six months a year however long I built this project I use these types of visualizations and here's how I transform the data in power BI And you can walk through the steps because you've done the steps because you've built a project That's what I would do Let's see Druski I like that name. That's a cool. That's a cool name It says I've read many articles that always say to focus on one tool. Would you agree with this? I want to expand my knowledge in Excel power BI tableau and Python. Would this be a bad thing to learn all of them? I'm very thirsty today. I don't know why so I'm gonna be drinking a lot of water. It's not a bad thing But that's what I do when I first started I started trying to learn Everything or I was trying to like a learn a little bit of Python Tableau, etc And I got really confused because I didn't have any one thing understood understood Why is Wendy's texting me? They want me to try the new ghost pepper chicken Sorry, I got distracted But that's what I did. I got very I got very I didn't become an expert or even like baseline level good at any of these things So, yeah, you can go check out my data in a spooking about how I liked I prefer people learn it is learn all of sequel sequel is a great fundamental skill you learn about how data sits in tables and rows And columns you see how you can transform the data That's very applicable to things like Tableau and Excel and power BI is you're gonna see similar Formatted data and everything now Python is very different much more programming heavy But I don't think in my opinion. I would try to learn everything at once I would try to learn one thing practice it get good at it so specifically sequel and then transfer into other skills That's what I would do Can a high school graduate be accepted as a data analyst with no experience but already knows how to be a data analyst Who just learned in a boot camp? Yeah, for sure. It's very possible. It's more compared. It's it's more difficult 100% you're not gonna sugarcoat it is definitely more difficult. That's almost in any area in Tech if you don't have a degree in it if you don't even have a bachelor's degree It's it's much more difficult because most job requirements require a minimum of a bachelor's degree Even when I was working as a manager, I had my team or even out before that when I was just a data analyst I was on a hiring team You know, we had to for the company's requirements We had to have a minimum of a bachelor's. We really weren't allowed to really hire That's like a fortune seven companies called a marriage source Bergen So that company really didn't allow us for these skill technical positions to hire if they didn't have a bachelor's degree That was just a requirement. So it does become more competitive you do limit yourself in terms of what jobs you can get but You know, it's definitely possible. I always say the exact same example, but I have other examples But probably my best example One of my first mentees that I ever worked with During my mentorship program He was a warehouse worker. His name is Sergio Ramos. You can look him up on LinkedIn Highly recommend following him because he doesn't have a bachelor's degree. He was a warehouse worker out of high school I did that for several years and was like, I just need a change So I helped him and he followed basically what I put into the data analyst bootcamp. That's why I keep referencing it I basically told him to do that and I helped walk him through that before I built it and He now works at PayPal as a data analyst just got hired on full-time a couple months ago I was just talking to him like two days ago. So it's absolutely possible. You just have to like really hustle You really have to hustle So yeah, it's definitely possible Next one is from Brandon Schultz says, how do you know when you're proficient with SQL? What makes you proficient? Are these are their standard guidelines and Also, what are the most essential skills that stick out as the most important skills? Okay. Um, SQL is my bread and butter I've made a career. I could have probably not learned Python. I probably could have not learned Either Tableau or Power BI just like if I just knew SQL Excel and maybe like Tableau I could have made I could have gotten almost to where I am now In terms of like data analyst career-wise SQL is my bread and butter. I highly recommend you take Learn SQL if you're watching this right now, and you're like should I learn SQL? Alex is it worth it? Yes, even with all this AI stuff coming out I I am so confident it's still gonna be an exceptionally important skill to learn With that being said What are the guidelines? There aren't really any guidelines Typically what you're looking at for like an entry-level position You really need to know how to filter data for the most part and join data Those are two of the more important things and then group by and aggregations. You can stop there Um, I of course in you know my tutorials that I have I go a lot higher than that into Windows functions and start procedures And all these other things you can stop you can stop you just need to be proficient in those things Knowing how to use the where statement knowing how to group by simple aggregations like min max average And then knowing how to join data together If you can get proficient at those you can do a lot of what you know an entry-level data analyst is gonna do And then when you get an entry-level data analyst job, you'll start learning things like start procedures You know jobs or what do they call them in my SQL? Well, my mind's my mind's blanking triggers And so in scheduling so you can like learn these more advanced things when you're on the job But typically for an entry-level analyst, you just need to know those things. That's what I will say In order to stick out, I mean you can start learning like Windows functions. You can create like You can create reports In SQL to automatically like send reports. That's some more advanced stuff things I didn't really do till I was like three years into using SQL But that's not could make you stick out for sure Oh Geez, I'm way behind way behind on questions. I'll get there. I'll catch up Dixia Singh said hello, Alex. I was waiting for this live stream for a long time Wait, no further. It is here Let's see Do you provide career guidance services and data analytics? I used to have a mentorship program I stopped doing that last December. I did it for over two years So I did for a long time and saw like almost a hundred people I worked with But I don't do it anymore because I started I quit my full-time job to do my data analytics consulting Um, which is called Alex analytics So I started doing that and now I work with startups and some I I've worked with some tech companies But not like some of the biggest ones like I haven't worked with like Google. Um, and then I work with um Brands and stuff to help them know how to like market their products and stuff like that So I do a lot of a lot of different stuff, but um, no I don't really do a lot of career guidance these days just because I've been doing my business and it's a that's a probably more than a full-time job um What are the skills required to become a data engineer? I don't know. I mean I do know But that's not my area of expertise um Go follow and let me um Let me give you the specific name for data engineering. There's one guy His name is Ben, but I want to get his full name for you Um Here it is It's benjamin regodian Um, he is fantastic and he has a youtube channel as well. So if you're into data engineering Let's see if I can find his um, what's his Oh, here it is the seattle data guy always forget. I always I I've I've met him in real life Like I I like I know him, but I just keep forgetting what his channel is called seattle data guy ben regodian Go check him out. He's great. I'm really really good Let's see Why are you uh manish? Wally I know this comes off. I feel like this is aggressive. Let's uh That's my opinion. You take it how you want. Why are you not making more project videos such as airbnb amazon uber any social media company? Just been doing any other things I mean, I just created um, we just finished our pandas series Which was great We are about to go into web scraping and regular expression with python And then we're going to my sequel series and I have projects for those Well, what do you want from me? Like I'm trying Uh, no, really. It's I mean, I I do plan on doing that. Oh my father-in-law is calling me Let me text her real quick And the father-in-law calls you um He had a text back He's not gonna like this I'm in the doghouse for this one. No, I'm just kidding All right, I texted the father-in-law back. Um No, that's the only reason why I plan on doing more I want to do some um, twitter ones. Uh, if I can if it's possible Call me again. Um, or Um, what was the other one I was thinking about doing the other day? I can't I I I've ever written down somewhere. I'll do more. I promise Let me see. Let me see I'm skimming through some questions keep asking the questions. I'll hopefully catch up. Um Hope we get to hear news about microsoft fabric. You can just go check out my video There's not a ton of news. They have like a preview So I've already got I have an account. I have gotten into fabric. I've been able to mess around with it That's how I got some of the information Um where I made the video But you know, it's not fully built out yet. It doesn't have co-pilot. It doesn't have everything Done, right? It's not a full-fledged product. Um, which is interesting because I mean, it's not unheard of for microsoft They tend to announce things then give it to you like six months a year later But microsoft fabrics seem to be more of a full-fledged product They already have a preview I can go in and do it but they don't have like certain pieces to it that are ready yet Um, so I can't really do like a full hands-on review importing data Messing around with it seeing how it actually works Which I will do in the future In a date. Oh, jeez If you guys it skipped down to the bottom again guys, I was about to answer a cool question Then I lost it just a thousand questions here. Good night. I'm way behind. I'm gonna have to Really, I'm not the I'm not to shorten my answers. We got too many questions to get through Let's switch this way. Well, I don't know why that was a weird one like this Don't mind me. Um Hey from Sri Lanka. Hey, how's it going? Hey from canada Mike What's going on Let's see Uh akasha kumar Give me a super chat. Thank you so much. You didn't have to do that, but I'll answer your question real quick I've been prepping for data analysts. No luck with any job. Should I look into volunteering my analyst services? Uh, you don't have to do this and this is actually a really interesting question I've I've encouraged people to do this and I still encourage if you want to do that to do that I did it when I was first starting out. Uh, there was a local nonprofit that, um I was just on their website one day. I my family we donate some money to a charity every single month And so, uh, we were looking at charities and I found this one. I was like, oh jeez Um, you know, I've just started learning data analytics and I'm looking at this and this is just a bad way to display the data Like, you know, I it was something I cared about and I was like, I wish They could like redo this or make this better And I was like, wait, I could do that. So I just reached out to them. Um, sent him an email I was like, hey, you know, I I'm data analyst. I was don't think I was at the time or maybe I just got my first job I was like, I saw your your website. I really love your cause I feel like I could make this better and people would really be able to see the impact that you guys are having on the community Which I really care about Um, and so they let me come in and I went in person and like met them and and redid that stuff for them And so it it helps and then I put that on my resume too. So it wasn't just like I gave back and that was really important to me, but then I also used that to put that on my resume as like a project Um, so yeah, I think volunteering is is very good. You can also um, You know ask like friends and family for like businesses and stuff It doesn't have to be volunteering. You can also try to like work Uh for somebody, you know, it's it's It's just hard to say, but yeah volunteering. I think um is is definitely something everybody can do Or try to do Let's see Arvind Nadar said hi, Alex. Thanks for all the help My question is what should be the next steps after completing the google data analytics certificate Um, so the certificate is is really good. Uh, if you were just starting this is who I recommend that for by the way You're just starting out. You really don't know much about data analytics. You don't really know exactly what they do It's kind of like an intro course Um, and it's it covers a lot of good topics some some stuff that I don't like like the theory behind data analytics a lot of the Um terminology which I eventually I I'm gonna try to do um to just make them obsolete in my opinion but um The next steps after you do that. So you learn a little bit of sequel tableau excel or is it in google sheets? I remember um You learn a little bit of that about that stuff What I would do after that is I would try to dive more into those skills You really just learn the base level you get an intro to it I would dive into those skills more and start building out more projects. That's what I would be doing Uh, what's my opinion on google looker? I've used looker I used in my past job and we eventually transitioned away from it the only reason we transitioned away It was actually pretty easy for people to use which I liked What we didn't like is we couldn't customize the visualizations as much as we wanted That was the reason we so it's not it's a great tool to learn I'll in a lot of companies will put that in like job descriptions. They want like looker. So you know It can be good So it says hi, I'm trying to land a fresher data analyst job If you don't know what that is outside of the united states It's just an entry-level data analyst job like your first one of your first jobs Will your guided projects be enough for a good portfolio in my opinion? It's way better than anything I had If you go way back in the in the video history books, uh That's not the right terminology But if you go way back on my channel look at some of the first videos I made I talked about how I got my first job as a data analyst. I even shared my portfolio It was literally an attachment of sequel scripts that I had written On the back of my resume That helped me land my first job The projects that I have made for you guys and then you guys go and do and make better and you learn a lot from Those projects are 10 times better than anything I had when I was first starting out. Um Nobody was doing these pro nobody was creating these projects like I do so Yes, these projects are definitely good to create a portfolio I also have a video on how to create a portfolio website Which then you can create the web is all free you can create the website put it in your um your resume on your linked in Um all that stuff highly recommend it 100 percent Let's see Read through more questions I've completed the analytics certificate but not getting a job. Okay, uh in I won't answer many more questions about the google data analyst certificate just because There's a hundred things you can find that resources on this a lot a lot of places, but here's my take on it It's an entry level certification in certifications don't mean as much in Data analytics doesn't mean much in data science Data visualization those certifications aren't as important as things like it cyber security You know stuff like that. So certifications in our field aren't as important So it's a certification, but it's more just like hey, I learned some of the basic skills You need to go above and beyond that And you really need to build projects and you build a great resume which I have videos on all these things Um, you just you need to go a lot quite a bit further into it That's my opinion Are you still not recommending any sequel certifications? No, there are none In fact, there used to be one that I recommended. It was the microsoft sequel server certification They scrapped that And combined a bunch of different microsoft certifications into the microsoft data analyst certification So, um, it's part of that now. So that is one that I kind of recommend Um, there's a better one though. It's the microsoft rbi certification. I just think that one is more specific and better But there are very few if you go on alextheanalyst.com or you just look at some of my videos where I talk about it I specifically highlight some of the certifications that I actually think are worth it But they are not required by any means. I don't think so What's my opinion on the pharma industry, uh, as it works to data data analysis Well, you're asking the right guy because that's the industry I worked in Um, I worked, uh at a company called amerisource bergen We do a lot of logistics. That's a large part of the business is like sending medication to different places, but I worked in the department where we worked with like clinical trials pharma hematology oncology, so blood cancer data um Data in pharma is huge. Um, it's massive like our team was We were a smaller team. We were a data science team within a much larger Department and there were other departments that did similar stuff with different products and whatnot. Um, but they're huge pharma is huge With data so data analysis and pharma is super important Can we follow your boot camp for a data analyst job? I would say and I'm not just saying this I've just I've I've been adding to it and I've gotten it's gotten better I would say that if you follow my boot camp, it's probably better than most Paid courses or even some boot camps out there. You just don't get a mentorship with it, right? It's all self-paced, but sorry. I got it. She knows Um, but it has some of the best content like if I had something like that when I was first starting out I would be I would have done much better Or known the skills a lot better I just kind of cobbled together a bunch of courses and stuff like that But now I've made my own for free and I feel like it's really good I honestly think if you learn that you can get an entry-level data analyst job with just that Just following the boot camp. That's my opinion Is it important to study models and machine learning for our first data analyst job? No No, it's not Um, you won't use for any the entry-level data analyst job You should not be using any machine learning that would just they would be lying. That's a data science role Um models are modeling the data. I think it's a little bit more advanced. Um, it's a it's a It's a more challenging concept I started doing data modeling went by about three years ago Um when I was actually working more with like the data engineering side of things So in the data science team, I worked with in our data collection team. So I would help collect the data Um and create the pipelines transform the data then we'd work with you know clients and all that stuff, but Um data modeling is important, but it's it's a little bit more challenging in my opinion a little bit more technical So I wouldn't start with those things now Sorry, my nose is itching again. Just don't look don't look right here I'm reading more questions Uh, catarina gentilly said feels good to listen to alex's live whilst working on my dashboard because I'm finally employed as a data analyst Whoo Congratulations. I love hearing that. That's awesome What is the impact of co-pilot? Okay. So I just I I had a conversation with uh, luke barouse the other day Um around this exact thing My wife is about to hop on a plane. She's just texting me. So I don't want to ignore Apparently microsoft is having a little bit of trouble with their co-pilot to get it to do what they want it to do um consistently Um, and he found some reddit threads where they're like microsoft employees talking about the issues They were having as well some like articles. So we were talking about this the other day So luke if you're on here, uh, thanks for sending me that and talking to me about that Um, but basically co-pilot is gonna be really good once they have it figured out It's gonna be really good. It'll be able to connect to things like your excel rbi or yeah power bi um, you're like sequel Um interface where you'll be able to write help you write code A lot of the issues that they seem to be having is for it to generate what's supposed to do Especially in things like excel. So like it's like hey create a table and then it's like, you know, it's not creating a table It's just like inserting some random values. It's just not working properly. I think they're gonna get it figured out They're close. I'm pretty confident. I think it has a long way to go They're having a lot of trouble with it and we're early on I'm fully aware of that But things like get hub co-pilot if you ever use get hub co-pilot are is really great Um, and if you've used it it speeds up your work a lot But it still makes a lot of mistakes and I've used get hub co-pilot for many years so um The impact impact is it's not gonna really negatively impact us at all. It's gonna improve our work That's that's for sure I just got promoted to manager of analytics Awesome job Hijama 10. I don't know how to pronounce that But hey, um, hi from hey from sudan. I'm way behind on questions guys. I'm so sorry. I'm getting to them Oh, we're up to the 350 people This is when it starts see when we when we hit like 300 people I start falling way behind in questions So I do apologize um, but yeah, someone else was Talking about co-pilot. That's why I take on co-pilot. It feels a long way to go. It's going to get a lot better over the years Um, but don't expect it to like solve. It's not going to like solve all your problems in You know six months a year or two years. This is like a long play for them. This is just like the entry beginning level of what co-pilot will be Um So someone's kind of asking about this recession. Um, and can I get a job following your bootcamp? Now here's what I'm going to say. I'm going to kind of go on a small tangent and then I'll get back to the questions um Bootcamp is great anytime highly recommend doing it just because it's super comprehensive It goes really in depth on really in depth for most skills Which most even paid courses or you won't get unless you do like a really expensive paid course or like a unimi course for each skill to do it yes, but um The recession so I do believe in the next like Now even a couple months ago six months ago Probably for the next year or two We're gonna see kind of a I don't I don't want to I don't know if it's a full on recession. I'm not an economist But from what I've seen are you know hiring is a little bit slower Larger tech companies are really the only ones who are laying people off But some larger companies are doing some hiring freezes. Um, but I would say still about 75 percent of companies are hiring is normal So we're having about 25 slowdown Let's say they're hiring 10,000 people a month for data analysts now. They're maybe hiring 7500 So there are still a ton of people getting hired still a lot of companies hiring for data analysts. Um, but I do think it could get a little bit worse in my opinion. I just see If everything that's happening with interest rates everything that's happening with, um Sorry somebody said I get distracted easily somebody, um some of the things that are happening with you know, uh logistics around the world with Supply chain and all these things with interest rates going up and especially in the united states specifically I do see it getting maybe a little bit worse I hope not but that's not just going to affect data analysts. That's just going to affect the economy as a whole, right? Um, and it becomes even more important to make it like a really great resume as an entry-level analyst, so um, you know all all that's all that to be said Recessions it happens. Um, we ebb and flow it it's it's just part of the cycle of hiring in the world. Unfortunately Um, confused capybara just sent me a super chat. Thank you so much. He said he or she Said love your content if you were hiring a data analyst Where are some key areas you would look at out in a portfolio project that makes it outstanding? Really great question. Um, I was a hiring manager and I was on a hiring team So like for like three years I was like in that hiring process Um, and I conducted the technical interviews for For those three years. That was my part of the team Um, so but you're talking specifically about like a portfolio project Uh, when we would get down to about 10 candidates, so we'd like filter it down We get down to about 10 candidates. That's when we really start looking at their resumes Um, to be honest, we would get like 50 resumes and it's just like nope Nope. Yes. Nope. Yes. And then you filter it down to like 10. Usually we did that off of like domain experience Um, you know, we were working in really heavy health care stuff So we really needed somebody who knew health care The technical skills actually um for that position that were one position I'm thinking of specifically for one of these positions We were like, okay as long as they have like the basics like they know how to do because this was sort of a business Analyst uh job But for that job it was like as long as they have the basics We really just needed somebody with a domain experience Um We would start really looking at these resumes and we were like, okay, let's really look at their health care experience What do they know in health care? Let's see if they've built any projects if they have a website if they have a linked in and we would I and then my boss we were the ones because we had four people on the hiring team We were the ones who would go and look at their profiles go and look at them And we would get on a call and go do that like at the same time. So we get on a call And we go and look at their linked in first is usually what we went to And then I was like, okay, this person right out. Nope Then we'd we'd narrow it down even after those 10 we narrow it down to like six five to six Then we would go look for like personal websites portfolios and then we would dive into those things So the resume was the most important thing just don't Portfolio projects is not the most important thing your resume for getting into is one of the more important things So you need a great resume But with that great resume then you have on top of that a portfolio. Now typically what we would do Is and I'm going really long on this answer. I just you know, this is this is our process um, we would Look at them. We look at the resume be like, okay We want to know a little bit more about they just have like Sequel on their resume. We want to know more about this and they talked a little bit about there in their job To screens we'd go to their portfolio. Here's what stood out. I I go I say all of that just because that's the process I say all of that to get to this part When I would go to a portfolio There were several things that kind of like caught my eye And I'm like, whoa, this person is definitely to the level we need And to be fair like in my opinion, I was really good at sequel even three years ago for a data analyst And if someone was matching that level like they were writing some of this more a lot more complex code Especially if they were doing with health care data or knowing how to transform the data I was like, well, okay, this person is really good. I could like just off the bat see it What made it really good typically the if they're because I would See a lot of sequel code. I don't see a lot of like tableau was very common But in sequel code specifically I would see their sequel code and I would know almost immediately if they were good or not um And it's become maybe a little bit different with the advent of chat gbt But back in the day if you were you creating your own store procedures for like data cleaning and you're creating They're called jobs in microsoft's equal server if you're creating jobs If you're using windows functions and you were using things like Cast and convert within windows functions and stuff like that like that stuff Doesn't just come naturally to people you definitely have to use it to understand that stuff So that stuff like was an immediate kind of the more the advanced stuff I didn't mind when I just saw more simple queries like aggregations and stuff I was like, okay. They know the basics. That was my genuine thinking but when they went to these more nuanced things that um Are more more complex. I immediately was like, oh, that's really good I know they know it and then I didn't really have to bug them too much in the interview because I was like You know sequel I can just tell but tell me more about like how you use it What data you've worked with that kind of stuff Long answer. I apologize or I don't apologize Oh, man. This is great Is it alexia or alisha alisha brown? I I can't tell it's al ex ia said hi, alex I was able to get a data analyst position from watching your videos I'm doing personal projects. I'm only five months in my master's program for data science analytics Congratulations. I love hearing that there's been so many people today putting that um in the chat like stuff like that I love I love seeing that So happy to hear that congratulations And congrats on the uh degree you're gonna be getting soon. Oh, I'm in yeah. Yeah, congrats on the degree. It's gonna be awesome Let's see Um, okay So somebody always asks some type of question like this is basically around age Is age a factor age is definitely a factor, but uh, let me get a little bit more into it I'll try to keep it short I'm getting long on these answers. I know there's a lot of questions is age important um Age is interesting You can be too young you can be too old You can get a job when you're young you can get a job when you're old The extremes are usually the more difficult part if you're like 18 19 you're trying to get an entry level job It'll be a little bit more difficult if you don't have a degree um If you're 50 or 60 and you're trying to get a job that can be more difficult because you're starting to You know start to age out towards retirement or at least like in the You know, that's what people are gonna start thinking when they see that Here's how you can get around those things being young You just got to build projects and you have to like really hustle and work super hard If you're older if you're in their fifth late forties fifties sixties for it's not crazy old I'm just like, you know, this this person said 55 If you're older hopefully Throughout your career or your jobs that you've had in the past you can use some of that experience For example, and this is the one I always use but you can transfer it to a lot of different jobs for example, I Worked with a lot of nurses who became data analysts or data scientists or Specialists that I work with within the data field They use that experience. They had been the judy who I worked as she was a nurse for like 25 years And I think she was like 50 or yeah I think she was 50 when she first got her first job as a she wasn't a Her title wasn't data analysts, but that's what she did. Um, it was like healthcare specialist Analysters I health health Analysts special. I can't remember but I have the word analyst in there She used her domain experience to leverage it to work at the healthcare company as it She's like, I've been working with these systems for 25 years. I really know them I understand the data and that experience is crazy important and super super valuable So companies are willing to hire even if you have no data Data analyst experience because your domain knowledge experience is so valuable to them like insanely valuable It really is and so she was making really good money. Um, just because She really knew the domain. So for you if you're 55 Um age is going to play a factor, but hopefully you can leverage your past experience and be like, okay I really know construction. I really know finance. I really know health care I really know one of these a field and I can leverage that into my work Hey from Uganda. Hey from United Kingdom. Hey, how's it going? Um, I found an entry level. So this is a robberino k I found an entry level job 80 000. They teach you sequel on tableau too good to be true Not too good to be true Maybe it's possible not too good to be true, but let me um, let me give you a hypothetical and this is not fully Hypothetical. This is somewhat true um Some companies there's a company out there and like Michigan and they are having trouble hiring somebody Believe it or not There are a lot of data analyst jobs that don't get applicants because they're either in a rural Like a rural michigan or you know, just a place where people don't want to live They want them on site or it's remote and it's just a really small niche and they can't Get people to apply for it that happens that actually genuinely happens every single day. I promise you um And what people will do to incentivize like hey We just need somebody because we really need somebody to come in and do this We just need somebody who has like a really good Attitude and a good work ethic and like kind of has an interest in this and we're willing to train you That is a very real thing. I've seen it a lot. Um, so yeah It could be too good to be true Or I could genuinely be real. You only know and That you like, you know, uh, explore that Oh another one rose happy wishes. I love that name. Uh with the news Hi, Alex. I got a job as a data entry analyst. Do you think it's relevant for my uh journey as a data analyst? Thank you. So data entry analysts Typically it's entering data. Well first off congrats on getting a job in the data world Um second off. Yeah, it you definitely can leverage it Here's what I would say most data entry analysts are usually Not super technical, right? They aren't doing a ton of Coding they're not even like filtering and querying data often. Sometimes they are What you can do and this is something that I've encouraged people to do and they've had success with it I was never in this position I've encouraged people to do this and they do and they say it helps Find kind of the things that you can try to automate in your job and entering data is Automatable some companies don't do it or it's difficult to do Figure out how you can try to automate that and try to write python for that automation and run it by your boss make sure you can do it or Try to um ask them if you can you know Do some work on visualizing the data or if you can put it into sql to do this process faster Try to find ways to speed up your work and your boss will most hopefully be Allow you to use some different tools that you can then say in this job. I was using sql I used python for automation. I did this you have to kind of push yourself and push what your job description might be But it's definitely relatable and because of the the title it definitely can help you transition into a more Uh data analyst heavy job Uh matthew alderman one of my mods Thanks for the super chat. You know, you know, you don't have to do that anymore, man You do it every time. I don't know why you do that, but you said hey, alex. I'm gonna send you a linkedin message I need your brain. Uh, yeah, I'll message you back. I got you, man Yeah, I don't know why you always do that always makes me laugh. I'm like, you know, just shoot just shoot me a message Let's see This is a good question. It's on um technical exams in an interview. So uh ryan, justin Ola I'm so bad at names. Please forgive me. I'll be graduating with a computer science course in by july We'd like to ask what are the usual technical exams in an interview? Um, that's a great question I actually I'm I have a course that's going to be coming out like a month or two That's going to cover this exactly. Um And it's just on technical interviews, uh, specifically with sql with that course, but all that being said Here's what you're typically looking at. You have three different things. You have a whiteboard you have the um Uh, Oh, what's it called general questions and then you have a take-home exams. Those are the three that you'll typically see for interviews Now take-home exams aren't as popular, but I'm it's kind of you said technical exam um take-home exams is they'll like have a pre-written script with some data or Some scenario and they'll give it to you and they're like, hey give us insights It could be super vague or they can be super specific and be like, hey give us, you know This type of output shows how you would write this code And then you do it and then you send it back typically takes an hour to four hours. Um to do and send back Then there's technical exams or whiteboarding exams in the interview So you're face-to-face with them and they say hey, here's some data show us how to do x y z and you have to do it um And then the last one is just general questions, uh, where they're going to be asking you things like um, you know, how have you used sequel super generic, but it could get much more specific How do you clean data? How does a data collection process work? Certain processes those can be much more difficult to answer So all those things they could ask you any of those things every company is different in what they're wanting and what they're looking for and how they ask it but Those are the three main ways. I'm looking at more questions I'm playing some music for you while I'm reading these Uh, this is like I'll answer this one super quick. Um, some some ruta borcar Said how to give descriptions of projects and resume. I usually keep the two bullet points. First bullet point is, um Here's what I did I built A dashboard using this data in tableau and excel Super simple. Then the next one is what insights I gained out of it. Um, discovered 62% of applicants had this deficiency in skill. Who knows whatever it whatever it is and then in the title of it I create I give the project a title and then, you know, maybe what skills I use next to it Something super simple. I have a whole resume video that'll show you how to do that stuff. So go check that one out. Um Oh, so this this is a Super common question in my audience. Um, I don't know if you guys knew this only like 20% of my audience is from the united states The vast majority of My audience is actually in europe and in asia india. That's actually where most of my audience is Um, so a lot of you know, a lot of people want to work for companies in the united states Usually just better pay or Work-life balance or stuff like that So they want to get remote jobs or even jobs where they Move to united states now. I'm not I'm not an expert in this area. I'm just gonna have the out that this is not my like I haven't done a ton of stuff in this but i'll give you what I know so In my last team we hired consultants mostly from, um, lithuania In india on my team. I had people from from there Um, and we hired mostly through consulting companies Accenture tcs um There was another one that we used for ever so slightly. It was like six months But eccentric tcs are super popular ones. You can look up other kind of global, um, consulting companies That's that's been my experience as the best way to kind of get your foot in the door of these companies Because then from those consulting companies, we would then try to get them to work for that with us full time um Because we really like their work or whatever but consulting was an easy way I think not easy. It's not easy to get to these consulting companies But it was an easier way for them to get into the united states these types of jobs Um, so very possible to do. I've also seen people I've heard of people who are doing like up work or fiverer and stuff like that and getting work And then when they start working with a company they the company likes them And then they get hired on full time and then they have a full time job. Um, so There's different ways. That's just been my experience Actually getting into the united states is like you have to the visa process is is tough I had to work with one of our, um Consultants who we hired on full time with the visa process. It's a process. It took a long time It took like eight months for us to on board him after all the papers or you know to get all the paperwork done Get it all signed off. It took a long time Um, so yeah, that's um, that's my thoughts on that Can we use spss for future predictions? Um, I've used spss a little bit. Um, and yeah, I believe you can um Use ssis more if I'm being honest Um, but I believe you can. Um, I just I don't have a ton of experience. I didn't use it for that long. I used it for like We used it for like six months and then we found a different tool. So not my, um Not my biggest area of expertise, although I think I could say yes to that What's your review on the advanced data analytics course from google on coursera? I'm not gonna go super and I have a whole video on that. My thoughts are I actually like it. Um, I I've been walking through it slowly I just gotta keep I have real work. And so like when I have free time. I try to take a little bit of it Um, but it goes it goes much more in depth into like python, which I really like Let's see. There's a lot of questions. I've already answered. I'm probably just really far behind on the new questions This question is interesting. I don't know if I'm gonna answer it correctly, but how do you handle advertising for an analytics company? Now the only reason I feel like I can answer this question is because I do a lot of consulting Um with startups. So a lot of startups in the data space Um, and that's what that's a lot not a lot of my work That's like 40 percent of my work 35 percent of my work has been that kind of work Um, they want me to come in so like they're a startup They're doing like an etl some etl tool or they're doing a data warehousing tool or they're doing an analytics tool They want my take on the tool itself So like hey, we want you to come in test the tool tell us where there's deficiencies or what we can improve Um, or they want me to come and help them market the market the product or kind of like consult on the product to make it more Likeable, I don't know how to sell to say it So when companies are like using when they have these tools, um And they're wanting to like advertise these these tools typically they're they're wanting to You know target their main consumer like who are they trying to target as an entry-level analyst Is it, you know, you know cc executives like what person in a company are they trying to target then they have to target the specific companies Again, I don't know if I'm answering this question, right, but You dig into the data behind what population fits This type of product and how can we get our product in their hands? Is it linkedin advertising? Is it reaching out directly? Is it joining some type of service that helps get directly in front of Um, you know these companies You know, there's a lot to that All right, Gregory. I'll do it I'll do it greg Hello, alex. Do you think with the rise of ai we should acquire domain knowledge in addition to just data analytics I didn't actually read that question all the way through because I thought I was going to say something else Um, yeah domain knowledge is always super super great to have if you can I didn't start out with well No, that's not true. I started with healthcare domain experience But then I transitioned to it and I do consulting on in a lot of different areas domain experience is super helpful like really really helpful Um, in fact at there is a tipping point where your your skills become an expectation and the domain knowledge becomes the most Important so you get to like a a place where you're like, okay I'm really good at sequel by not all you know all the tools or azure and all these different things That becomes more of like an expectation for like a mid-level senior level role. It's like, okay He has to know these just if if our company uses a microsoft tech stack and he Doesn't this you know write out if he has the microsoft tech stack. Okay, that's great. That's what we need But now we need the domain experience. So as you get more into your career three five three to five years is like where you should start developing more domain knowledge So if you can get it, absolutely With the rise of ai domain knowledge actually is beginning. I think is going to become more important Because ai I think is actually a lot better at the technical stuff I don't think it's that good at the domain stuff. I've asked it questions in my domain and I'm like, that's not right That's wrong. It's just wrong. It's just hallucinates random things. Um, and with coding it's very Not finite like you can get it to do a lot of things But there's rules, right? There's this then this then this then this then this with domain knowledge I mean that is In my opinion is a lot more complex as you get more advanced. It's like in healthcare There were things like I would have to research and study and like really understand and work with the the doctors at the hospitals crazy tough stuff in my opinion and If you go ask chat gpt, they're just I they're not gonna know and I've asked it some things and it just didn't get it right Even on the simpler stuff. So if I asked it really advanced stuff You know, it needs to be really trained on this stuff There will be ai tools That will and uh google talked about this about training it specifically on healthcare data specifically on finance data It'll get really good at that But it's gonna be it's gonna be a long time before that's like common In that each domain it's gonna take a long time So domain know domain knowledge. I think it's super important. It'll be it's just becomes more important as you go along in your career I'm looking at more questions Some a lot of these I've answered so I like to repeat questions Uh, I mean, hey, look I can take criticism and feedback barath along goes said I just finished sequel server in the boot camp It's very limiting in many ways I mean I can take the criticism. I just don't agree um because everything in there is like I mean, it's I give you the concepts. I'm not like Isn't like a full course. I'm just giving you the concepts. You have to go and practice yourself If you go and practice yourself, it won't be limiting All right, I don't take criticism. Well, I think you're wrong barath Uh, no, I get it sequels sequel sequel is tough. It's it's simple, but it's tough, right? It took me many months to get like even the basics down. It just it didn't come naturally to me So it maybe you're just having a tough time all those concepts that I talk I teach in the in the Sequel server are all like really important stuff. If you can learn all that stuff, you'll be golden You just have to practice with it. That's the tough part Um, so barath, you know, just go practice those things I was just joking with you Don't get mad at me Um, let's see. What other questions we got? Uh higher education. Okay. So we haven't talked about higher education today um, and in this question Okay, this question did not I can read I read between lines when I read questions. Sometimes I'll read you the question Then I'll go into you know, my own thing Mohammed Abbey ab ab Said any bachelor in is working or specific ones So basically bachelor's degree, which one should you take now? I'm going to talk about Sorry, just popped on my finger I'm going to talk about bachelor's degree master's degree Um higher education in general because I want to And this is my live stream. I can do what I want Um, first off bachelor's degrees, you know the typical ones if you see ones like if you, you know, um, there's data analytics degrees now There's uh statistics degrees mathematics degrees finance degrees are even pretty good because they do a lot of data modeling and working with data Just finance in general does um You can even go as far as like getting an MBA with a business analytics concentration or MBA with a data analytics concentration Um or data science degrees even those are good too So bachelor's and master's yeah, they they can definitely help Um, here's what I'll say and I've been thinking a lot about this I made a post about this on linkedin not too long ago. I think higher education is in trouble um in big trouble and I think the the value has been going down I mean the value has been going down over the years and the price has been going up Not a good trend for higher education With AI stepping in it's going to worsen both of those things potentially. Um, they're gonna have I think I think that Having a degree is going to become less important For a lot of areas where like you can't become a CPA You can't do accounting without a degree those degrees. You'll still need to get unfortunately. It's just regulatory government stuff Or for things like data analytics, um, you don't need a degree I genuinely don't I think I have thought about this a lot I'm like if I went back and write out a high school like Really pursue this and knew what I knew now, right? Of course that always is the kicker But if I knew like how things work and like the hiring world and and learning the skills like I knew How to learn I like wipe my brain, but I just knew how to learn and I did it back then I could get a job. I'm 100% sure I could get a job as a data analyst and be as far in my career If not further by my by my age without any degree like my degree. I don't think helped me in any way just didn't um That's my opinion. So I think I think More people are gonna stop going to college because you're gonna see it's a it's The value of it is just going down and the importance of it is going down Um, but there will always still be higher education. I just think it's gonna become less relevant Or less needed All right, let me look for more questions Islam Hamatou said alex can a data analyst become a data engineer if yes, what is the roadmap? I'm gonna cheat on this one. Um This is and I talked about him earlier in the live stream This is my friend Benjamin Rogogen. He has a data engineering youtube channel called um Data Seattle data guy go check him out He posted this and I'm just gonna read it I'm cheating a little bit But I commented on this and I said this is my comment It said I almost transitioned from analytics to data engineering back in 2020, which is true I was really I really had considered it. I had a guy who said he would bring me in. Um, but then I got my manager position and then I Before after knows before but then I wanted to go uh that that path And I said definitely agree with everything you said so everything I'm about to read read you. I support he's his post said A common path to becoming a data engineer is to start as a data analyst This gives you exposure to data sets and processes that data engineers build It'll expose you to working with data warehouses and data lakes sequel automating processes with python and vba and data Here's what you're asking. What is the next steps? Here's what he says Once you've and I'm gonna I'm gonna put this um in the chat. I'll put this link to this post in the chat You can read with me if you'd like I just posted it you can go check it out if you want. He said once you learn the baseline learn about data pipelines etl elts and workflows about distributed distributed systems practice data modeling for analytics and transaction systems like olap, um olap and Is it otap? I can't remember. I don't remember the term but olap is one of the one of the more popular ones um, read up on software design Ask your manager to take a small data engineering project to work Subscribe to his youtube channel. Hey, hey, then that's my job. They'll tell me they'll tell me what to say Um, so go check out that post. I put it in the chat for you He is really good. He runs his own consulting company much like I do now except for data engineering um, and He's very smart. I've met him in real life talked to them very very smart He knows what he's talking about. So go check out his channel If you're interested in data engineering and like he said a lot of people start out as data Analyst and then transition into data engineering. I was super close because I worked on the data Um collection team So we did data collection It was called data collection, but I ended up doing like the whole process So data collection is a lot of the creating pipelines etls working with data warehouses creating data models for that data Um, and I helped work with all of that and helped design it and I worked at database developers Data engineers data architects like data scientists. I those are the people I was working with So I got to know like I got to learn like some really technical stuff because I had to because I was working with them to like be able to talk and and like be able to work with them really And I loved it. I loved data engineering. I think it's great I really considered maybe it was like four years ago um to do data engineering because I really liked doing the etl processes the data cleaning and transforming the data Creating the data pipeline. I love I loved all that stuff. I still do um So yeah, there you go. And then someone else was asking, uh, matisha didia Uh, hey, uh, how should I transition the from data analyst data scientist? This is probably an easier leap actually Um, and it's funny because I in that same job when I was working with them I was working with data scientists the data science, uh Team within our data science team the data scientists were like, hey, we want you to become a data scientist I didn't want to I I had worked with them enough to know I that was like not what I loved and enjoyed So I decided not to do it but I as a data analyst, they wanted me to become a data scientist now how how and why um The reason they wanted me to is because I was working with them quite a bit as a data analyst And they saw that I really understood these things and I understood how those things worked And I had the domain knowledge that they were looking for which is hard to come by in the free market Like just posting a job It's hard to come by someone who had my experience and knowledge of the team And domain experience to then transition into that place and do really well Like they knew because they've hired people before that's really tough to come by. I know it's really tough to come by um And so they were like, oh it'd be so easy to bring over Alex as a data scientist because he already works in our systems He understands the data all that stuff. That's what I would do become a data analyst Learn the domain knowledge start applying it to if you work with data scientists start trying to work with them Ask to be on projects with them Ask to work alongside them Then you get experience working with them and you can transition to a data scientist That is probably the best way to do it in my opinion. You can also just be a data analyst for five six seven years and then Say hey, I want to become a data scientist now. I've been practicing these I built projects on these It's just It's harder. It's harder doing it that way It is so transitioning internally from a data analyst to a data scientist is more common From everything that I've seen and it's probably easier Ooh Well, I can get some water. I'm so I'm gonna drink this entire thing I'm gonna drink this. I'm almost done with it. I'm so thirsty. Maybe I'm sick. I don't know allergy or something. I don't know Uh, uh, we already talked about this a little bit earlier, but we have different people, you know people filter it out Said uh pl asked. Hello. How do you see fabric? I just did a whole video on fabric the other day. So you know go, uh Go check it out Uh fabric is really really cool um fabric is they called a unified data analytics platform And what it's meant to do is just make Using your data easier having it all in one place. It's going to be starting out stored in a parquet format Which has become really popular. Um, it was popular in certain areas For a while, but I think this is like probably one of the bigger platforms that's ever that's going to start using it more widely Yeah, I I could be misspeaking but that's from my from my knowledge at least What's really unique about it is The lack of data migration that you have to do data If you haven't worked with like in like a company A large company like you know or even medium-sized company You have data in all these silos, right? And you want to use all that data from all these places and you want to combine it and you want to You know do all these really great things you have great ideas and it's like, oh Well, we don't have access to that data Have access to this data or we can't get access to them both at the same time When we're not legally allowed to store it in a different location because of laws and regulations This would allow you to view the data without having to do data migration Which means literally taking a copy of the data and moving it over here And you're storing it and paying for it and all these things So you'll be able to view the data and use the data Without having to move the data. We used a product like this. It was called starburst Like the candy and it allowed you to do that. So I've worked with these types of tools before I've just never seen it done end to end like this, which is really unique And I maybe not really unique other companies have kind of done this Really unique for microsoft and i'm a microsoft guy myself So I love microsoft make sure i've never done this. Um, and so They're making sure you can access any of the data from from with any tool from any place any cloud platform at least as of now And be able to just view it and use it Totally different. Um, it makes That a lot easier now They they have they released a preview to it Um, and I already got my hands on I've looked at the preview. I kind of messed around with a little bit But It's not finished It's definitely not finished like I was getting in there messing with I'm like, oh, this is not finished But it looks really good and when they are done with it probably maybe towards the end of the year Early 2024 we'll see When they are finished with it, it's going to be really good. I just think it's going to take a while for companies to Changing to that kind of platform is not happening overnight. You don't just buy fabric Excuse me now. I got a stuffed up nose. I maybe I am sick You don't just go from using one product and switch over to fabric and all your problems are solved It takes a long time to transition to different products like that, especially at large companies So, um, it's going to take many years for that to become like a mainstream product in my opinion And I you know what it was I mowed the lawn this morning stinking grass Pants are on. Hey, how's it going? I'm sure you sent that message a long time ago. I'm just now getting down to it. I apologize um Mub Tassam rod charar. I finished your bootcamp. Should I learn more sequel? Yes Always learn more sequel. I'm still learning sequel um I love I love sequel I still I I feel like my skill level is like at an entry level data and Entry level the mid level data engineer That's my like sequel level. So I think my sequel level is like really good, but even I have a long way to go Um, there's still things that I'm learning when I use it for like clients and stuff I'm like, how can we do that? It's like, I think it's possible in sequel Well, let me research it and then I have to like really dig into it I love sequel sequel is the best sequel is not going away I promise you sequel is not even remote sequel is becoming Is it's like a staple. It's just not gonna go away Anytime soon. So learn more sequel. Yeah, sure Maynick Halder Halder for a senior level position in data analytics data science. What are the What are the business round company? Oh May ask during the interview so during the business round is that what you're asking during the business round of the interview Um, they're just gonna I mean, you know, typically they just want to know about how you've used tools How you know the domain experience how you work with people what your work style is Um, these are all important to companies. So they'll ask you a Very wide range of questions Let's see. I'm finally starting to somewhat catch up a lot of questions I think thank you everybody for joining Um, if you didn't know if you saw cancer on Uh, they said hello There's they're green and they have a star around their name or a star next to them They are a member of the channel which just helps support me and do these types of things I have like a hundred Members or something. Um, who just it's just, you know, they want to support the channel And so if you want to support the channel, you can do that too. It's not required I'm still gonna do these because I really appreciate you guys But thank you, um for the members who who, you know, help make these types of things, uh, possible for sure I'm scrolling down. Is our worth learning? Absolutely. I joke about not liking our I've used our my work. I used it for like a year. Um, and I got in it's, you know, really useful, but I just prefer python. I just I there's so many more uses for it. It's so You can just do so many more things with it as you can see through my tutorials. I've done web scraping regular expression um data analysis r is great for data analysis and equations and statistics And Is it's good. I just don't like it as much You can learn are in some companies. They only want you to know are so some companies If you know are you might be one of the few who did or not the few But one of the few people who has our unlike the resume who's like applying for it So yeah, why don't you just go for it? See How do you think ai will disrupt, uh, analytics workflow? That's a great question. Um So ai isn't I don't disrupt is not the right word Analytics is a much more complicated process than I think it's is easy to convey It is is able to convey in a video Um Even I have trouble conveying it sometimes the difficulties and the challenges that data analysts come by In the real world. It is tough. Um Is not just sitting down at a computer going into sequel looking at stuff and then um Getting your insights and delivering it to a client. It is that is like Probably 20 30 percent of what a data analyst does In the real world it is very complex and you're working with a lot of really unique teams Companies clients individuals within your company. It's an it's like an ecosystem So you have to a data analyst job is not just coding That's a small part of it And it's an important part. You have to know how to do it, right? It's very important But once you get into a role and you start learning all the dynamics of the team how they interact with clients It is a lot more than that and so From having that industry experience I could net I could not I could imagine some of the coding In the future being automated But even then there's so much that goes on outside of just the coding or writing or creating a presentation or whatever There's so much that goes on outside of it The human piece of it that connecting with your uh, not connecting but like working with your clients like So much I can't it's it's hard to It really is hard to verbalize and make even make a video on And I've tried and I've tried and I've done it in the past and it's just hard to do because every company is so different but I would say that ai is really all A lot of what they could automate is a lot of like the coding stuff in the future it could It could um, it could be automated like I could see that in like 15 20 years some of it Or even a lot of it could be automated, but you'll still need people to monitor it. Make sure the outputs are good Um, you'll still need to know these skills because you know when it gives you the code you'll have to use the code It would be very dangerous to trust it blindly and like In my experience at my last and this is like the last thing I'll say At my last company I was dealing with my budget Or just me Was like two million dollars. I had a two million dollar budget for my team for my software for everything Um, that was my budget That was a that we were a small team other companies other teams had much larger budgets but if my team We started and a lot of the the reason we had that two million dollar budget Was because we were really helpful to enable all the other teams to do really good work Streamline processes so whenever we would get You know, we would put in bids for an increased budget. We would almost always get it because We were enablers for other people to make a lot of money If we weren't there and they had to do all that themselves They would just have to grow their teams individually with data people It would increase their their stuff a lot the reason why I say that is These are not small budgets. We're talking about this isn't some small project with AI on the side, which is really fun to do It's really cool. It's really cool to see But when you start dealing with multi-million dollar budgets and mine was a small one You are not going to trust AI You're just not especially with what you know about with what I know about the mistakes I can make you know with the Illucinations I can have you just not going to fully trust and now you might trust parts of it Um and just have to double check things quickly and it could save a lot of time on work That's the real value of AI But knowing me and knowing who all all the people that I worked with I guarantee you Almost none of them are going to trust AI to the level where you'll see a decrease in the team sizes um Anytime soon it just wouldn't happen. Um, I can confidently say that Because we're dealing with so much money if you make some big mistakes In our cyber security team with which we worked out with a logistics team that we worked with you make mistakes in those areas you're we're talking like 100 million plus of potential loss if we have issues in those areas so I don't yeah, that's just other I spewed a lot of thoughts But it's just so much more complex the process of what how data works in companies It's not it's not people make it people on twitter man people on twitter go I'm gonna do on a tiny rant here and I said I said I was gonna stop on it. No, I'm not gonna do that What time is it? I'm 41. All right. We're gonna go for about 15 more minutes People on twitter on linkedin They make it seem like AI kid is like the one and one and done it's over like I don't know. I I mean it's just typical people wanting to get Flicks and they have some good information, but it really goes so surface level. It's like crazy surface level and so parts parts of what they're saying are true like coding and stuff in the future could get more automated but that's like only a small piece of the puzzle so Don't fully trust those things in my opinion. Don't fully trust those people who are like next year Data analysts data scientists data engineers software and software developers are all gonna not have jobs I could not agree less Dr. Poonit FPS Oh, thank you for the super chat. You didn't have to I really appreciate it. Uh, so I'm 32 years old now And I'm not satisfied with my current job. I like to switch into data analytics. Is it good for me? And also for the future? Um, I definitely think there's gonna be a huge market for analytics in the future I mean Things like Microsoft Fabric these are platforms where you need data analysts. You need data scientists data engineers data's data's not going away um, there's gonna be It's just so much so complex. It's not going away Software engineers data engineers these jobs aren't going away Um anytime soon At least that's from what I see Um, so yes, it's you're gonna have lots of opportunities in the future Is it good for you? It's really hard to say, you know, is it something you is something you really like Are you passionate about it? Um, do you have some domain experience at 32 years old? Do you have some domain experience that can help you transition into this job? Um, you know, do you want to work remote or in person like so you know just um Watch some of my videos on like how to become a data analyst with no experience How to become a data analyst in 2023 like those types of videos. Um, and it might help, you know Might help you a little bit Let's see nobody look at me while I'm while I'm um Drinking the water, you're not allowed Oh, Kyle Croucher. Okay, this is an interesting one. Um Do you have any recommendations for promoting my freelance career? I had a couple of projects finished already. What would you recommend? Upwork? Would you recommend Upwork? Um, first off, that's great. That's fantastic. That's real world experience The weather it's small big whatever you can put that on your resume use that as experience That is your job. You're making money Um Upwork fiver those types of um places are good to go. There's a lot of people on them Um, normally what I would do is first off you can put bids out To people put so I've used fiver for random stuff. So I know how like the process works I haven't used it for data analytics. Um, but you can put a bid you can say Hey, I have a project and you put it out there and people like you could then bid on that project Say, hey, I really know how to do this Um, I'll here's what my estimated cost for this project Or here's how much I charge per hour You can put bids out So you can do it that way or you can go on linkedin and you can try to network and market Or you can even do like some type of advertising, which I've never done myself. Um, so I wouldn't know how helpful that is Um, but also those past projects that you've done. I'd go back to them That's where that's where because I do consulting, right? I don't do freelance on those websites But I do consulting a lot of my work comes from repeat customers Um, I work with a customer a month ago. They love my work. They're like, hey great I was like, hey, if you guys ever need anything, let me know I was like, I'm here for you guys and I know your tech stack now and I I you know helped you with this Then a month later, I'll just reach out. I'm like, hey, just want to check in see how everything's going with You know the work that we did. Uh, see if there's anything else you guys need help on That's repeat work, right? That's repeat customer and they may say no and you're like no problem at all If they say no, you're like, no problem Just, you know, I'll check back in in a couple months But if you have anything just reach out You should do that with your past clients, you know Hey, just want to check in see how everything's going with the work Um, and see if you need anything else Simple as that. So that's my that's some of my tips Let's see. Let's see. Let's see Zeke and Abdul is learning r good for getting a job as a day analyst. Yeah There's lots of jobs that want um people who know r Or python or sequel there's some some jobs just want somebody who knows r It's not as many as some people who just want to know sequel or you know Have low or something like that, but r is a definitely a skill you can learn and get jobs from for sure See I'll read through here Some of the a lot of these questions if I'm being honest that I've answered already and that's why I'm skipping them Um, so this is an interesting kind of a different take on something I talked about earlier Muhammad ibrahim said after gpt and a lot of ai tools. What is required coding skill? What is required coding skills or problem solving skills as a student? I'm gonna be your science and interest in data So this is gonna be this is this is kind of like forward thinking like what is With the advent of chat gpt and ai tools, which will help with coding in the future. What is going to be really important? um One you're gonna need to know those skills really well and you'll learn it faster as you use things like chat gpt and ai Once you know the basics like it'll help you understand concepts and you can ask questions and it's great great for learning really is What's really gonna be Really important in the future Is understanding how all the puzzle pieces fit together. It's a puzzle. It really is a puzzle um People make it look so I mean I go back to what I said People make it look really easy like hey hey chat gpt write this code for me and it does it and that's a super simple query But then it's like okay, but what if the data isn't in here? How do we get that data then you as a data analyst need to figure out how to go to get that data Work data engineering the database developer to you know migrate that data or get a connection like Microsoft fabric Like we're talking about um Then you have to like Rework all that make sure the data is sitting in the in the tables well Well, then you're you're trying to join the tables and something's off So then you have to like you can talk to chat gpt be like okay now this isn't working You know, it's giving me this error. It's gonna spit out something. You're gonna try it. It's not gonna work You're gonna try it, you know, it's It you really need to understand how the puzzle pieces fit together and that just comes from real world experience, right? I didn't understand that stuff at all before I became a data analyst. I didn't I just it didn't I my mind never I couldn't have understood it until I just did it Honestly now that I've been doing it for like six plus years. I'm like, oh It's really complex all these puzzle pieces all these factors all these things so now I've used chat gpt with You know clients and and ai tools with clients that I've like for the past six months That's everybody is asking me about it and wants me to like Help bring ai into the startup. I'm like, that's not my area of expertise But let's let me bring in somebody else who knows that stuff and I can help, you know with that process And so I've used a lot of these different tools and they're great But you really need to know like how everything works Because now it's spitting out more advanced code Doing more advanced things But if you don't know how to implement it to get the output that you need or to do what you need to do No good. So that's that's kind of the future. I think of just coding in general is Understanding the puzzle pieces critical thinking problem solving like those things are gonna be really important And it does not come naturally to everybody Um, it just doesn't All right, let me keep going So a lot more people are asking about recession um Is it is is now a good time? I've talked about that quite a bit Uh, but yeah, we might be in this little recession. It could even get a little worse But we're still hiring. I think at around like 75 capacity last time I looked Um in data related jobs, which is lower, but in a recession type, you know, 75 isn't bad You're if you're talking a bad recession, you're looking at less than 50 percent hiring freezes Letting people go we're still like 75 which is really good Um, is my boot camp enough to get a entry-level data analyst job? Yes Yes, and it's free Go do that you just have to put in the extra work like You know build your own projects study the stuff a little more in-depth than maybe I went but it's all there for sure This is a this is a uh This is an interesting question. That's this is a good question actually Ahmad Rizal said hi Alex. Which of the following are correct? Cleaning data before conducting descriptive description analytic statistics or conducting descriptive analytics then cleaning the data So are you cleaning the data or analyzing the data is essentially what that question is? So Initially when you get data from a client or wherever wherever that source data is Usually you'll just try to bring it in as a raw data set That's initially what you do when you first get that source data in so you get that data set Then someone like me is gonna go in Figure it all out ask questions to the client figure out how to clean it Then we'll put into that and that's usually like a raw database and then you have like a staging database Then you have the production database and so you have different tables and yada yada yada Typically that first pass you're gonna try to clean that data as much as you can But how do you know what to clean? How do you know what questions ask? You're Doing analytics on it Sometimes they go hand in hand. Um, and I even say this in my projects I usually have like a data cleaning project and then I have um I have a project on exploratory data analysis Usually I have them separate, but honestly in real world You're doing them at the same time. You just need to know how to do them And as you're looking into the data and you're finding whatever Then it's like, oh wait This is a problem because of this Let me go back and figure out how to clean that and then you do more analytics And then you have to go back and clean it once you have figure out all your rules for cleaning All your business rules for cleaning it you can bring that to like the data developer or data engineer and say Hey, we want I want to implement these tools on our new incoming data So I don't have to do this process every time so then You have a raw table and um in how we did it at my company at least is we did more of an elt extract the data from the Um source load it then we transform it all within start procedures and stuff automatically, right? so that stuff is That stuff is Intermingled that's the real world. That's the kind of real world stuff that I'm talking about that like You know, it's hard for it's hard to like automate that kind of stuff Um, you have to dig in and do a lot of heavy lifting to then have it be automatable in the future Um, but even now, I mean even now I try to automate as much as I can and I can't I can't automate enough Uh, like when back when I was a data analyst for many years, I tried to automate as much as I could There's just you can't automate enough. There's so much to automate. I wish I could automate more So ai is going to help with a lot of that automation that I wish I could have done I was a data analyst again. I'm now a singing consultant I just don't get to work as hands-on with all these cool stuff anymore Which kind of bums me out Like that is one of the downsides like I do some of my clients. I'm working in like azure aws and data bricks And I get I get to use it, but I don't get used every day. That's what that's why I miss man or girl gal All right, let's see what other questions we have how much time do I got? All right I'm gonna do one more question I'm gonna answer one more question And this is always the toughest part. Oh, I mean it's the bottom There's always the toughest part because the last question I wanted to be a good question If I can't find a good one then uh, um Let's see last question. What do I got? I'm at the very bottom. I'm reading your I'm reading your question You're asking now still looking Still looking they look All right, this is a simple one I'm not saying you are a simple person, but the question is fairly simple Um hidden detailer asked how can I practice my data analytics skills? You're out there You're learning Um, and you want to know how can I practice these? The best thing to do and it's completely free the best thing to do is build projects Uh, I have a bunch of projects in my bootcamp or just on my channel in general The best way to learn it really really is. Um So that is the biggest thing. There are also company websites like strata scratch or data lemur Where you can go and practice like sequel and stuff like that Um, I'm going to give you guys the 282 people are here. I'm going to give you a little uh teaser Do you guys are going to be some of the first people to know I'm releasing a website In about a month or two. I've been working on it for over a year. That's going to be kind of a competitor to things like maven analytics strata scratch data lemur These other or sarah, you know I'm going to be releasing my own courses and I'm going to be releasing Booting questions like those platforms like scratch scratch But in my opinion it's going to be better. Um, and it's amazing. It's already amazing I cannot wait to show it to you guys There's going to be so many other things I have planned for the future like integrating ai into the website Um and do having projects on the website and and you know Some of this stuff is obviously you have to pay for It's just you know, it's going to be part of like the business but I'm going to be incorporating a lot of free stuff as well like like free projects and um Have a whole list. I can't name them all off the top of my head But it's going to be one of the best plot. Generally my opinion one of the best platforms to learn data analytics In once it launches So, you know be able to look out for that But those are some of the places that you can look those are some of the places that you can look But like you to me stuff like that you learn but then to actually apply it and actually practice Building your own project is probably one of the best things you can do It you just you get challenged in a lot of ways. You don't when you're just like following a course That's what I'll say so With that being said that's it That is the live stream. That's our may live stream. It's almost the end of may june Uh is my birthday month. So june 16th. Um, I'm going to be um Hopefully doing a live stream next month But it's crazy busy and then I'm taking like a week off for my birthday and some like family stuff So I'm gonna I am 100% gonna be trying to um Do a live stream next month, but we will see We will see With that being said Thank you guys so much. I really appreciate you guys coming. I love answering questions I love answering these questions. I I mean, I think they're you guys have really good questions I love giving back and and just like chatting with you guys and reading the the questions. It's super fun um I'll answer one question Uh, I'll answer two a couple questions. I'm gonna have a beta round I'm gonna have a beta launch and I'm gonna limit the amount of people who could actually join the beta launch I'm only gonna have because it's a I'm there are gonna be some things that we need to fix like so I'm gonna have a reduced rate with all the courses um, all of the Stuff most of the stuff is just gonna be you have to pay one time that you're done I don't I don't particularly like subscription models because I think more you guys pay more for it in the end Which I don't really like I feel scummy. Um, so Oh, hey, Sarah's birthday is june 1st. Hey, happy birthday. When it when is that two days? Two days early. Happy birthday. Happy birthday. Um but the the the platform itself is is It is gonna be a beta launch when I'm gonna reduce it to hopefully like under a thousand about a thousand people um, and At once like I don't know how exactly I'm doing it yet But like I have courses or bundles and stuff like that and after the thousand are sold I'm gonna cut off access To be able to buy it until we fix any bugs that we find with actual people getting in there because right now I've been beta testing or alpha testing it. Um, and then we're gonna launch it. It's gonna be amazing I'm crazy and I'm building more courses for it right now So like I I only I'm starting with four courses But I'm gonna have six within like another a month after it launches and then I have more than we'd be doing So I'm just like I'm pumping stuff out over here. Um, and they're it's really good quality super super good I can't I can't wait. It's gonna be an upgraded version of like my data analyst bootcamp It's gonna be going way more in depth into the skills and like the The thought process behind things and I love making it. Um, and no, there's no waiting list. Sorry It's just gonna be like a free-for-all. I apologize Um, but when that happens, you'll start seeing teasers on like linkedin YouTube uh instagram all that stuff because it's gonna be um I think it's gonna be awesome In my opinion because I've I've been working with it. It's one of the best platforms I've seen like It's really good and it's so and it's still and it's like MVP. This is like its simplest form But in the future, it's gonna even be better, which is just crazy Although being said, thank you guys so much for joining. I'm not gonna talk about it anymore I just want to give you guys like the sneak peek or like, you know, what's going on in the background Um, so thank you guys for joining. I really appreciate it. Um If you have any other questions, you know message me on linkedin shoot me an email actually Maybe don't show me an email because honestly, I'm like so far behind shoot me a message on linkedin I typically can keep up with those easier. Um, but uh, you know I I try to get back to you guys. It's just It can be tough It can be tough, but I try Uh, so thank you guys so much for watching. Thank you for asking good questions and you know providing good, uh, Good material for everybody because if you didn't ask questions, I wouldn't be able to answer anything All right guys, take it easy Be good learn Uh, and just do your best give back a community society All right