 All right guys I've completely reconfigured my whole streaming setup And hopefully it sounds good. Hopefully it looks good, too. I'm literally watching myself on my screen right now Sounds better Sounds better I'll go away. I'm muting myself. All right, so Just to make sure everything's good. I got my water. I have got my phone in case my wife texts me I do not have the baby monitor So That's already got got that going for me. We're starting early tonight now Why start early? Because I thought about it. It wasn't really fair to my wife if I'm being completely honest Normally I start these at like 8 30 and then I tell my wife it's gonna last an hour Then it gets to 9 30 and then I just I'm what we're rolling got like a couple hundred people And I'm like, all right I'm gonna keep going I go to like 9 45 sometimes even like 10 o'clock And I feel really guilty because my wife goes to sleep or likes to have like like just her like peace time before she goes to sleep and And so I always feel really guilty about doing that. So I thought if I start earlier Then I can end actually at like 9 30 ish And I don't know just made sense. I feel like that would be better. I see people joining Welcome. We haven't started anything yet But let me just read the chat real quick see what's going on And Rebet what's going on Christopher, how's it going? Jazz hey, I got a whole new I'm working with a whole new setup over here. I got new lights I got a new microphone. I have a new stream setup So hopefully this actually sounds and looks better because my past some of my past live streams have Have not been good So if this sounds better if it looks better, I need feedback legitimately Because I have been working like I spent hours like reconfiguring settings just today to make sure this is good So if it sounds good, please let me know But Drew, how's it going? Matias? Hey from Argentina. Hey from the United States David I already see you you're asking questions. That's great I'll get to the sick the questions in just a little bit. I promise. I just like to say hi to people before we get rocking and rolling Let's see Valentine Sunshine, Elizabeth Anna Ali Beautiful hit beautiful date and also low Desert sounds sounds good bit tinny at all. I don't know what that means I'm glad it sounds good. I genuinely I genuinely do that feedback. I really did I Mr. Number six has the wine sabotage your previous streams. Hope this will be a clean session No wine tonight. No wine tonight. I'm when we hit 300k in like two three weeks I will be doing a wine live stream. I plan on inviting my wife But she hasn't confirmed that she'll do it But I will be drinking and that will be a good time because towards the end of that last live stream I definitely was like I don't drink a lot so like It was feeling it But we'll do that for the 300k live stream Which would be in like two weeks and then we'll also have a an October live stream So I have two live streams next month. It'll be a lot of fun D Robinson. Hey from Minnesota. Hey, I was born in Minnesota. I was born in Benson, Minnesota Great great state love it miss it love the Love the cold weather up there. I really do I miss it But just so you guys know I am okay I know some people were asking how I was doing because I live right near Charleston, South Carolina I live in Charleston and When the when the hurricane, let me see if maybe it's this direction when the hurricane went through Florida I kind of regrouped turned into a hurricane category one and then hit Charleston directly It got pretty windy lots of rain But We're okay. It's past us now It was I was safe for like two or three hours. It was pretty strong. I was pretty sure something was gonna Like break off the house or something, but I checked and I think everything's okay. So we're safe But yeah, I see a bunch of people coming in super great to see all you guys Michael Natty Natty Natty Mia Martins Amani a little from Dublin cool man. What's going on in Dublin? Hey from the United States Achille ready from Maryland Northeast love it Nigeria very cool. Awesome. Awesome Yes, believe it or not on my last stream. I had a glass of wine. I don't drink a lot. So for me, that's like I I Yeah, I can feel it. So towards the end of that stream. I was feeling it so But anyways, we're starting early today, I know I said 8 30 People expected 8 30. So I'm just starting early again Just so that my wife gave it to sleep a little earlier because with the hurricane and everything, you know Both her and I have been a little bit stressed about, you know, we had like go bags in case we needed to like leave Or if our power went out or something, which as you can tell my power was not out I'm super super happy about that but the whole point of this live stream and You know doing stuff like this is to answer your guys's questions. I get Believe it or not literally about a hundred Messages LinkedIn messages Twitter messages Instagram messages emails comments every single day And sometimes around like a hundred and fifty. I try to answer as many as I can but sometimes I can't So these live streams are more like an interactive way so I can answer to where I can answer your questions Without you kind of like typing and hoping I respond because I just I mean sometimes I can't get to everybody So hopefully I can answer everybody's questions during this this live stream I usually get a ton and just prefacing all this I usually get a ton in this the chat, which I love that you guys have a ton of questions but I start to fall behind because Sometimes I just have really lengthy answers And so I sometimes fall behind but I'm gonna do my best and if I don't answer your question Just put it in the chat again so I can like Catch it again But oh, yeah and discord. I Appreciate yeah, thank you for reminding me discord as well. So I get questions through discord as well I'll have to say this is that's why I do stuff like this I really really really love doing this because I don't know. I just like I like the interactivity part of it But also you guys usually have like really good questions as well And so that's what this is. Let me get a sip of water real quick. I break this bad boy out This is where I went to college. I still drink out of this. It's been like It's been a while I think I bought this like 10 years ago I still use it to this day but I Want to start getting your questions kind of know we got a lot So if you guys want to start putting questions in the chat, it can be about anything it can be about courses skills paths job market You know how to negotiate salaries. It could be about personal stuff Whatever you want to ask as long as it's appropriate. Keep it PG. No PG 13. No, let's keep it PG I'm just kidding. All right, so I'm gonna start I'm gonna start reading some of these But hey, I still see people joining was seem was him smoky Orlando, Florida. Hey glad you're doing okay, man Florida got hit really hard. I mean, I've seen it everywhere. They got hit really hard. I'm glad you're doing okay I think Orlando wasn't in wasn't isn't near Tampa. I believe so it's like the opposite side. I Think so my geography is not great if I'm being honest. So hopefully you did. Hopefully you're doing all right Elbaro says I just got my first job as a report developer. Thanks to your videos and website and video. Just wanted to thank you Hey, awesome, man If you don't have it so he or you're asking somebody else, I'll let that person answer all of that person answer Yeah, I do have a discord Find it somewhere The discord is something I don't I don't go I I get on there almost every day, but I don't interact a lot It's mostly for you guys to have a community of people who are data analysts who can like chat and ask each other Questions there's a lot of good people on there Who like will post their resumes their projects? Questions and it's a good place. I check it out. I'm almost every single day. I just don't talk a lot because it's mostly for you guys anyways Back to the questions Sayek say it Said hey, I'm an I'm a student in Germany and I'm finding it extremely hard to convert applications into interviews Do you know anything about an analyst market in Germany and how to land an entry-level role? I don't really know the Germany Market that well, I really don't but here's one thing that That I'll say in general and I have a lot of people who will say this exact same thing saying I'm applying I'm applying I'm applying and I'm not getting any interviews nine times out of ten from from somebody who fields a lot of resumes and is a hiring manager Most of the time it's just a bad resume Like if I see a good resume resume, they have the right skills nine times out of ten I'm bringing them in so if you if it if your inner if your resume is getting in front of the eyes of hiring managers And you're not getting a callback. It's your resume And that's not to say that it's because you don't have experience Because sometimes the experience isn't I mean it's important, but that's not the reason why you're not getting interviews It's because it's not well formatted. It's not clear and concise. You don't have it laid out Well, it's more like you just don't have a good resume That that is what I have found to be the case for most people who aren't getting interviews at all If you're getting interviews and you're not getting the job That's a whole different ballgame But you know, I would really look at the resume. I have a I have a older video I need to make a newer one, but it still applies a lot of that stuff still applies Where I walked through how to create a resume and there's some templates on there I like I still like those I went and checked that out like a month ago And I was like, I still still applies So, you know Something to think about Let's keep going Because I went way back way way high Accident Zandeep says hi Alex your legend. Thank you. I learned a quite a lot from your videos Please keep doing more sessions. We'll do man. We'll do. Thanks for being here Ali says I don't think our ally ale says I don't think this is a water ghost said How old are you? I am 27 years old and Up until recently, I didn't like to talk too much about it I've had this channel for three years when I started this channel was 24 years old. So, you know, I was I've I'd only been in the The career landscape you could say for like three years two of them in analytics, but I'm just I'm just I'm extremely passionate about what I do. I love Making videos interacting with people and I love data analytics and that's why I started it I didn't start it because I was the best Data analysts in the world or knew everything I started it just because I have a passion for like teaching people I love mentoring people and doing stuff like this. So, yeah, I I don't know. I feel like Whenever I tell people I've done that I've said it on a few different live streams. Hey, I'm 27 people like First off you look 35 and I'm like, yeah, I get it The second thing is a lot of people think I'm really young and I agree. I am pretty young But that's all my own commentary. I don't even think you guys have started commenting on that yet but Let's keep going Again, if I miss I it's hard to keep up all the questions. So if I miss it, I apologize How do you start up from hosting project? How do you? Daniel said how do you start up with hosting projects on GitHub? You do GitHub pages. That's what I use for mine or you could just use a GitHub and people go on there and look at that There's another one somebody just did a video on this somebody else Geez it's like GitHub Dot IO or something Look into that, but it's it's just a way to show your GitHub I mean, it's all about creating, you know creating your portfolio on there adding different projects, you know Having a good read me something that points to your resume. It's just like any other. It's like a landing page for your resume really and Projects, but I like GitHub pages because it looks better and it's completely free Sia, okay, Alex kind of the link to the discord Yeah, let me put the link to the I give me a second. I'm gonna get the link to the discord So that people can have that I'll just put in the chat give me one second I wasn't prepared for this. This could take a little bit invite people Okay, okay, all right, I'm gonna do this one although it expires in seven days be warned It expires in seven days. That's the link right there. I just posted it Expires in seven days. I could have you know made it forever, but I Don't want to take too much time. Anyways Mmm Chief of Nades, that's a cool name. I don't know what that means, but sounds cool. Uh, Unless it's not cool All right Keep me honest. Hey Alex. I was told by a company director to send my resume. Most of their jobs are more specialized Should I tailor my resume to specific jobs or stay broad? Here's what here. That's a fantastic question first off. I Taylor my resume when I have a very specific job I'm applying for so if I'm applying for okay So one of one of the main competitors of my company and I applied to them And got many interviews with few different parts of their team. I know that company really well It's called McKesson McKesson's a pharmaceutical distribution company. They're our top competitor. I know what they're looking for So I changed my resume just for that application or those those applications But in general if you're just applying broadly and you're not specifically targeting companies you're not at that level yet Then I would keep it more broad and I You just need to have a lot of the keywords that you think they'll be looking for a lot of the skills a lot of those like Phrases that the jobs that you're applying for looking for them. So just some general advice. That's what I would do Patech says how was the job market for business analysts versus a data analyst? I think they're both saying they're both doing well there's going to I mean given right now we're in this like really weird climate with really we're the we're just in a really weird space with the Economy with the job market with layoffs of hiring freezes Most companies are not going through hiring freezes and layoffs despite what you see online Most companies aren't that's a small fraction of the mostly the large major tech companies because they just went hiring like crazy during the pandemic or During like the past year or two. They just went they just went insane Which was great for all the data analysts trying to get jobs But it also sucks because now they're out we're on this economic downturn and stuff but for most Small to medium even fortune 500 companies most are still hiring as normal. So it's still good But they're very similar markets pretty much across the board Tina Happy face says I'm proficient in Excel power query and started learning it Python and Power BI What is the right time to get a job in data analytics my current job is more administrative? You know, there's always that question of when should I start applying my I have always said this Which is apply before you feel ready because when you feel ready. It's already you're already like You're way far ahead more ahead than you need to be I think oftentimes if you have Good Excel skills like you've been practicing or a good Excel good sequel And just some power BI some tabloids where you can at least show that in like a project like some of my projects and stuff Excuse me. I Would start it I would start there you have the skills You know what you're doing create those projects and then reformat that resume and apply the reason I say do that is because When you start applying and you start either getting rejected by every single person you're gonna know or You start getting interviews and they're like, yeah, we don't really care if you have this what we really care about is this and you'll start learning So it's almost every single time. It's a learning move when you first start applying and the chances of getting a job right away are extremely low, but Applying is a great thing to learn from that's where I learned a ton from because I got rejected so many times. I you know I Learned a ton from my failures So it's worth just going for it. If you have the free time and you're not, you know You have that ability to switch jobs at the moment Christian Richard is it getting harder to break into the analytics space without the background now and a recruiter I see most jobs on LinkedIn 500 plus job applicants now Richard or Christian that is true. Okay, so take go back five years when I first started getting into analytics it was easier there has been You know, there's been a big shift in people trying to move towards tech, especially due to the pandemic I have seen on my channel, which is, you know, slightly indicative that a lot of people are trying to go into the analytics space My channel has has like doubled the views and the subscribers every single month for almost a year now And during the pandemic that was a huge shift where people wanted to work remote people wanted to get into data In tech and this is a really great way to do that, which I'm sure why a lot of people Watching this are trying to do that because it's just a great field. It really it's fantastic And so yeah, it's getting more difficult with that being said I'll a lot of the advice that I talk about on my channel are things that if I were to start over today Are the exact things that I would do and are things that I see every single day working with mentees and things like that Because a lot of these people don't have any experience. They're a teacher or they're a nurse or there's something else Leveraging your background whatever your background is whether it's healthcare construction finance anything leveraging that background And then using that and working with a recruiter especially because they can really help you Leveraging that background creating a really good resume learning those skills. That is what is going to get you a job You know, I I still I still to this day Don't think you need a degree. I have thought about it and I'm gonna take a small tangent. I apologize But I I had really considered for like several years to go back and get a master's degree Because I was like, how am I ever gonna move up? Like how am I ever going to excel in this field and like become a manager and a director like The farther I got into it the more the more entrenched I became into it and the better I got at the skills and everything the more I realized that does not matter it's Having I have a bachelor's in recreational therapy So I do have a bachelor's of a minimum but it has nothing to do with this field. So I Still don't fully think I Don't fully think that you need That level of education. I don't think if you don't have it Like if I were to start over today And you said you could go to school for a year and get a bachelor's or whatever Or a year and get or two years and get a master's or whatever Or just start off today and start learning the skills and then applying I would start learning the skills and applying because the the resources online are fantastic You can learn those skills and then you can get a job. Anyways, I'm going off on a huge tangent. I apologize I'm not getting to anybody's questions. Let me give me a second Seraj Singh her sing Says how much mathematics is required to become a data analyst? I always tell people to get into data analytics just basic statistics basic Basic stuff, right? Understand how aggregations work some mean median count distinct count things like that though that I think that is Going to be what you use the majority of the time and as you get further into it, which is what happened to me I just learned the very basics as you get into it. You learn more and more advanced things So now like where I'm at I know a lot more advanced things, but you don't need to know that that is not a requirement to get into it Although some people will say it is it's not David from Nigeria, what's going on man? What's the name of that site that was just mentioned discord? Talking about discord Tina I'm gonna say discord discord is just like this a group a place where people can chat Sandeep said any chances you can make a session or make a session on data warehouse I'll probably make a video dedicated to data warehouses because data warehouses are pretty cool But probably not like a live stream But yeah data warehouse. I'm I'll go more into like data lakes data warehouses in future videos But not no not on like a session like this Katarina Jen Gen Tilly hi Alex Do you think theoretical statistics background is necessary for a solid data analytics career? Whoa? theoretical statistics No, no, I don't I think that's I mean you don't need it, right? Statistics mathematics statistics physics engineering all those degrees are pretty applicable You'll you'll get a lot of statistics with those backgrounds. Is it needed? No, it's not necessary for a solid data analyst career Absolutely not What's the difference between solo bees said what's the difference between a data analyst and a data architect a data architect is building the framework so think about Think about somebody who's Designing how the database is going to look when the data is ingested and you need to You need to efficiently and as optimized as you possibly can Design these data warehouses like we were just mentioning these data lakes and Build these models to where they're connected in the most efficient way to save your company money and to have these for your process Your automated processes go smoothly. That's what data architects do. It is very very technical they work with um, you know a lot of sequel they work with a lot of could be Hadoop or You know things like MongoDB no sequel stuff like that Whereas a data analyst, we're not gonna be designing data warehouses or anything. That's not that's not what we do This is not what you should be doing if you are doing it. You should get a different job title Edgar said what do you see as highlights for these kind of resumes to consider greetings from Mexico? Hey, hey Mexico Greetings from the US. What are the highlights of these kind of resumes? Okay, super high level the top of your resume should be a contact section next should be a skills section You can put a summary section. I'm not a huge fan. I don't have one of mine But a skill section that highlights your skills Then either a projects if you don't have any experience as a data analyst or if you have experience your experience should be next Here is my logic behind just that in general When somebody when a hiring manager looks at your resume you do not want the first thing that their eyes go to is something not related or Showing that you don't have experience that is the last thing you want to do So if you put your experience at the top and you don't have any experience your last job is that subway Love subway, but that's not gonna help you get a data analyst job. That's the first thing they see They're gonna toss it you want to show SQL Tableau Python. They're like, okay, great. They go to projects SQL Python Tableau Okay, great Then they go to your experience and you don't have much experience like that sucks. They don't experience They have all the skills we're looking for Let's give them a shot That's my logic and I have always Said that I've always done that myself. I just think it's a good way to do it Oh jeez. Oh boy. I just skipped to the bottom. Okay. I'm coming back. Oh boy. Oh jeez. Oh My gosh, I'm so far behind guys. I'm about to miss some questions. I am Let's see Here we go. Here's some questions Would it be possible you start making some videos on analyzing clickstream data? I don't what do you mean clickstream? I don't know what clickstream data means If you put a link in the chat or tell me what that is Maybe I will but I have a bunch of like I'm do we're about to start our Python series in a few weeks Next week is like a fun video that Luke and I made Then I have a few interviews that I did with some people and then I'm starting the Python tutorial series So I have a bunch of projects in that so I've and I've already made them So, you know, just let me know what it is. I'll look into it. Maybe I will Um Ember said hi Alex, I want to know what your interest field when you're starting out making Projects have flash portfolios. Okay, so If you're making a portfolio and you want it to be something that looks good to Somebody who's you know, hiring you or they look let's say they like actually go in and look at your code or look at your data. I Always like at least one or maybe two projects to be Specific Tina's that Tina Hwang Tina Wang is messaging me Tina. Is that you in the chat? Oh, jeez. Give me a second guys I apologize Tina's distracting me. If that's her then I'm gonna be Feel stupid because like I should I I'm confused. I don't know. Anyway, she's messaging me. I don't know why Maybe she's in the chat. That's why anyways Oh Geez, no, she's not. I'm so confused. She messaged me at the weirdest time. So Where was I oh Projects I like to have one or two projects that are industry specific. I apologize for that tangent that happens all the time I'm alive. All right. I have other things going on So for me healthcare For me when I was creating projects, I was thinking what is relevant to health care Claims data is super relevant and something that every almost everybody every company does In some capacity so I did a claims data project, right? But I also did some other ones that were more unique. So I like I tracked What was that first project that I did? I was tracking um Was it my gas mileage that was a project that I did I was tracking my own gas mileage Inputting like my odometer readings. I did one where I was tracking Cal no workout or calories or something like that. That's a long time. It was like five six years ago But something that you enjoy I have seen people do ones on like Yu-Gi-Oh cards or Pokemon cards or I you know watch prices as one that I did like web scraping on You know just something that you enjoy. I think it's something fun That's how I come up with mine, but I try to make something that's kind of like Relevant to the industry and then one that's kind of fun Let's see Bum bum bum. Oh man, what did I do? Yeah Okay, I'm looking at more questions. I'm just I'm reading through them scrolling through them Taro said I'm gonna have interview with a couple of companies in the US and Canada Oh from Canada. Do you have any advice? I worked recently with with somebody like six months ago who is who lived in Canada wanted to move to the US for Daniel's job He got a job doing super well my advice would set be just to tell them that you're willing to relocate even if Even if you're not even if it's gonna be a remote job Just tell them you're gonna be willing to relocate nine times out of ten They are not gonna ask you to do that and if they do do that, you know just at the end say hey Something's come up. I want to work remote. Is it a lie a little bit a little bit But nine times out of ten you're not gonna get called out on it and that's what they want to hear They just want to hear that you're willing to do it now that you're actually gonna have to do it Not my not my most ethical piece of advice, but it's it's That's what I would say my other advice is just have a really positive attitude be really excited about it You know, I that's something that I always really appreciate in Interviews, it's just I'm like, okay. This person actually wants to work This person actually wants to work for this company and stay here So an enthusiasm for the company or just working in general is That's a skill Himani said I'm studying masters in data analytics awesome I have a thesis this semester. Can you help me suggesting some topics for my master's thesis, please? I've never done a master's thesis. I don't know what good topics. I don't know what topics would be good If I'm being completely honest, I really don't I have no suggestions. I don't even know what it would be a good thesis Xenophone 2006 said I know I need to eventually find a niche inside of data analytics I agree Would being a tax specialist be a reasonable niche to get into along with data analytics I'm studying to become an enrolled agent. I am not gonna lie to you I don't know what a tax specialist Data analyst is I like I don't I don't know that niche taxes. I pay taxes, but I don't I don't know that niche It really could be you know look on like discord or or go on Go on reddit and ask that question because if somebody who may be knowledgeable on area could could tell you I don't know. I'm sorry Um Have you thought about creating a startup related to data analytics ale alley? Yes, I have I Definitely have considered it Frederico in you know as time progresses, I'm sure I will update more on that but no update as of now Frederick Federico said Do you understand Databricks? I don't quite get it. Yes. I use Databricks Databricks for many years I Don't want to go into a history of what Databricks Databricks is but we use Databricks I used it with PySpark. So we used it a lot with our Massive amount of data that we were getting in and we used it a lot with Azure Azure data Lake And something else, but we used it for a lot of our What's it called semi-structured data? So a lot of our JSON files that we were getting that's what we used a lot for But all to say I don't want to go into the history of what Databricks is. But yes, I do understand Databricks I do plan on making full tutorials slash videos on Databricks Azure AWS And like tools like that because that stuff is I think that's like the next progression of what data analysts are gonna start Needing to know so like probably within the next year I'll be making tutorials and videos on how to do all that Because that stuff is that stuff is kind of important to know Let me see just looking I'm just looking I'd like cybersecurity and data analysts is there somewhere in between Viv um, I I In my position now we work as a cybersecurity team There are cybersecurity Analysts, but they are much more on the cybersecurity Technical side, but they analyze cybersecurity threats and things like that So no I wouldn't say that that I know of a huge crossover Although I'm sure that there is something out there. I just I myself don't know it. I apologize Okay, what seems says which particular soft skill do you think is the most crucial for data analytics? What do you say is critical thinking inquisitiveness or some other soft skill? I'll give you a couple, but the number one I would say is communication which is super generic And you know, I actually did make a video on this I don't remember what it was called though, but I talked about it because communication is just If you can't communicate, it's really hard to get your job done. It's like super important But other than that I would say problem-solving and and to kind of get in the mind of like why I would say that is Communication I would say is just number one because you can do your job and you can be amazing data analysts But if you don't communicate that well with your team like people are gonna look at you like you're an idiot I've seen it. I've semi done it a little bit or I'm like I don't really know what I'm saying or how to communicate this and it comes off bad I look bad It just doesn't bode well you just need to be able to communicate well the next thing is problem-solving because I Mean when you're working with this this data and it's gets complex And it's a lot of industry knowledge and you have to research things and you have to figure things out You have to be able to problem-solve if you have to be and so yeah problems problem-solving I don't know if that's a soft skill though. Yeah, I guess it's a soft skill But critical thinking is a good one Hey B says what do you think of data consulting the data consulting is great, you know in the past Year or two, especially since this channel has grown. I've been doing more consulting And so my my opinion has changed when I started this I knew nothing about consulting And so I know I always told people to go to His name David Arienson I think that's his name David Arienson I want to say I feel like I'm saying his last name wrong but He is a data analytics guy He has like another YouTube channel called how to get a data analyst job or how to get a job It is a data analyst or something like that and I always used to send people to him now that I'm in consulting myself. I've been doing it a lot I'm just in my in my free time in my tons of free time that I have I do consulting. I really like it I think it's great. You can set your own prices. You can get your own clients And you can keep retain those clients from multiple projects and you can offer discounts and you get to do everything It's like running your own little consulting business. It's fun. I like it a lot Let's see Fmym I'm sure that stands for something. I don't know what though. I apologize. Hi, Alex Do you have any tips on how to build a portfolio? Yes, I do but you also said I've created several Google Data Studio dashboards where should I put my work? Yeah, there's a few different places. GitHub is always a fantastic place to put that Or to put that but you can also create a website like Wix and you can create a free website as although you won't be able to like customize your URL Unfortunately, but if you use the free ones perfectly fine, you can put these projects on there take screenshots take clips Use a narrative approach to it. We can use GitHub, which is more of like a More of a code forward approach where it's not as much narrative You don't do a lot of talking. You just let the code speak for itself. You do GitHub pages You can become a web dev and create your own website using HTML or JavaScript There's a lot of different options a lot of different options But create building a portfolio check out my portfolio series here on YouTube I there's like 10 of them now on tons of different skills and That's how you go about doing it, you know find resources to do them first and then try to build them yourself Let's see Kenny Kenny said Kenny Cheng Kenny Cheng said how well versed with sequel do you have to be for an entry-level data analyst job entry-level data analyst job? And I'm not I am not messing with you. This is what I genuinely believe You need to be able to use select From where group by and order by That is all you need now. You need to know those well. You need to be all sorry joins on as well You need to know those those are like the minimum that is like I was just barely there when I first started but today Landscapes changed you need to know how to do that But genuinely I mean usually if you know need if you know how to use aggregate functions You know how to select data, you know how to do some filtering using the where statement You can group things and perform aggregations on it and you can join different tables You're good. I have you know in my series I have like, you know case statements So just you should learn that but sub queries and temp tables and and all you don't even know that you don't you'll learn When you get a job, but focus really hard on those initial stuff. That's what I use 95% of the time. It really is Taro look, I see you post in the chat man, but it's not a I I think I already answered that was for somebody else. So, you know, we gotta stop we gotta stop posting that I apologize. Oh Geez Guys, who's spamming the chats? Do I need some moderators in here? Where are my mods? They're not in here today, but that's okay Sorry, I just got around to the comment that said no, I'm a different Tina Tina Wang who's a big youtuber in data science was just messaging me and I thought she was I thought she was the Tina was like that doesn't look like Tina's I'm Tina's account. Okay. Let's get back to the questions And Nilsa, what's your total experience as a data analyst? I got that I could take that in a few different ways Give me a second. I have I've been doing data analytics for about five years. I started off as a Data collection specialist analyst at a nonprofit then I went to a health care company because I have a background in health care Given my degree as a as a recreational therapist Then I got so I got a day an actual data analyst job at this company I usually mostly use sequel Tableau Excel. That's it Then I got the job at the current company I work in and I've been here for over three years As a junior data analyst I took a title decrease with a pay increase I was making 76,000 but I was being paid hourly so like 35 an hour Then I joined they gave me I did really good as a contract to hire I did really good during that thing. They gave me a to pay bump to a data analyst to Then and I was using azure sequel python Excel power bi Then I got the job the job. I'm currently and again That's like years during that that's like four years for that that and then I'm in the job now Which I've been in for a year as a manager of data analytics And I manage a team of analysts and developers. So that's where I'm at. That's my experience That's my background if you're looking for just curiosity sake But I have a whole a couple of videos on literally how I made those transitions how much money I was making You know my skills all that stuff um, let's see Ali said hi Alex long time no see you. Yeah I I haven't I don't do a lot of live streams. I've been working out. I hope this is like my best live stream ever genuinely I've my past live streams. I've used like a webcam because I don't know what I'm doing I have put in hours of research to make this better. I really hope it like actually shows. We'll see Uh, oh, here's a one. That's interesting. Oh wait, let me see if I skipped any good ones I made a data analytics boot camp. So I ever use excel in the workforce. You'll use excel every day um, here's a good one, uh Jam really cohen. I don't know how to say that. I apologize. Are you experiencing icd 9 slash 10 medical coding? Yes, I've used that for years. Nobody's ever asked me. I may have like one person asked me that before but that's super interesting. Yeah I've used I used icd 9 codes. Um, I obviously icd 9 codes aren't being used anymore At least they should not be used anymore for claims and all that stuff. You need to be using icd 10 because icd 9 are the old ones um, but yeah, super familiar icd 9 icd 10s. I did that for years and um Super interesting data to work with we use we um, I worked with a lot of hospitals like the doctors as well as Like the CEOs of hospitals we'd work with them on their icd 9 and 10 Um, uh codes. I did a lot of MIPS if you know what MIPS is um for Payments and we were with a lot of claims data, but yeah. Yeah. Yeah. I love icd 9 codes link hicks pics cbt codes Man, I know them all I know them all um Magnus said hey, Alex. I think I currently have solid skills in sequel python and tabloid But I feel stuck because I can't come up with a project that integrates these skills any advice Um, my advice is just start small Don't try to incorporate all the skills right away Don't try to do Something that extracts use python to web scrape and imports it into sequel and then sequel connect to tabloid It just starts really small just do a python project. Look it up You can find a hundred of them online just type google python projects find one and do it Um and build from there right because as you learn more you'll be like, oh, I have this idea That's what at least that's what always happens with me I start with like a guided project and I do it And I do like more advanced projects now where I'm like trying to do like pagination Through web scraping and stuff like that. That's like more advanced And I get this idea and I'm like, oh, I could do this using this other website and then try to do this And then I go and try to do it. That's that's like where I get inspiration. It's just through other people's projects How many jobs you need to apply until you get a yes Wallace west That's the golden question, man. If I knew that I would be I would be people would be paying me the big bucks. Uh, but I don't know It can range. I mean some people can get it in their first hundred Um, which is fantastic It but it all it really depends on how you're applying some people can get in far less if they're working efficiently And working with recruiters or they have good connections and they know people who can get them good referrals That goes a long way It's hard to get it when you're first starting out because you aren't in the industry But like me now I have like 10 different people I could reach out to and be like, hey, do you have any openings? And if I did I think I could get an interview fairly easily But that's what happens with getting connections. It helps you get in like get in easier Um, but it could be I mean for me it was like Uh, I did it the worst most efficient way possible. I applied to over a thousand jobs Um before I got my first real data analyst job And I don't want to go into the pain and the horror that that was um, because it's emotionally scarring But genuinely I applied to over a thousand. It was just because I went on monster.com linkedin.com Indeed.com and just blasted my resume every which way applying to machine learning jobs and and like I didn't know what I was doing I didn't Now I would never never do that, but that is what I did Audrey honey cut said thank you for your guided projects And they were to publish my first dashboard on linkedin. Awesome. Great work. Um linkedin tip retan retan kumar said linkedin tips for freshers. That's a really good one. Um linkedin is a It's a fantastic social media place if you're trying to find a job it really is it's Um, it's really great and anybody can make it on there anybody can do well make connections and all this stuff It's really great Tips optimize your linkedin profile. You need a good picture Put a good make a good summary list all your skills on there because recruiters can reach out to you based off those skills Um, get the badges just because you can you don't need them, but why not? Um, so that's always good but Share your knowledge as you learn share It it hurts because you'll get like one like On your project and you worked your butt off for it and you're like I You're super proud of yourself and you'll get one like but listen As you continue to progress as they get better as you post more you will get more people who who's come to support you And to like your stuff and share it and you know That's almost like a portfolio in an essence like you're creating this online presence This online portfolio. You don't have to have a thousand ten thousand a hundred thousand followers You just have to Show that you're on there. You're working. It's like a github repo Like if you show how much you how much stuff you've been putting in your github over the past year That means something it shows commitment There's some general tips, but also post you know to get out there do do stuff out of out of walla m said thank you for those portfolio projects bro fist bump Uh, you're most welcome. Hey, I'm glad you appreciate them. Glad you glad you like them Muhammad al-Biyadi said how much python do I need to learn? Stuff like linked list heaps trees, etc. Are showing up and I find them difficult So do I need to learn all of those? No, um, at least for a data analyst now python goes very far i've In myself have looked into these things. Um, but as a data analyst 99 of people who use python as a data analyst will not do that There's one percent out there who's going to be like dude. Yeah, I totally use it for my job The other 99% aren't most of the time they're going to be doing stuff like Pandas web scraping I use I genuinely use pandas and web scraping all the time Uh, that's one that I and I know a lot of other people do but that's from me from my perspective I use those all the time and those are ones that I tell people to learn. Um, and then You know just knowing how to use do for loops or Process files like things like that. That's what you'll use More in python Uh afrodilla afrodilla, I don't know if I'm pronouncing that right. I apologize. I'm just about to start from scratch Where should I learn from one? Genuinely, and I'm not just saying this because it's me but watch my videos Um, I I always tell people this and I genuinely mean it when I was first starting out. I I had nobody There were no YouTubers who did what I do right now Um, there was like one or two, but they weren't good. Um, at least I didn't really learn much from them I have a lot of videos. I made them specifically for people who are just starting out because That's where I was and I wanted to help you out So watch my video on how to become a data analyst in 2022 That video is like high level breaks down what I think you should focus on Then check out my tutorials, you know, check that stuff out. That's where I would start Then I would build up to once you because you can learn a lot of the basics A lot of like the core skills. I think you need to learn on my channel Then you go take like, um So like a tableau certification or a course on Coursera go to you to me and take a course But do the free stuff first Learn what you kind of need to know then venture out and pay money to to learn. That's what I would do I I was so against Spending money when I first started out. I was broke. Good night um Edama Ayo Koonle, do you think data analysts are needed in the oil industry? Have you heard about that before struggling to find my niche? Yes, there is definitely a niche in the oil industry I know people who um work in what they call big oil um But it's not as common, but I want I know for a fact Although I have heard that it's more statistics in the oil industry. So I I believe you just need to know a little bit more statistics than You know other industries Let's see I'm kind of skipping some of the ones that I've already answered Although I may repeat because I know there's a bunch of new people and some you know people filtering it out Sinister hi, Alex I master excel and just done about an hour ago with your sequel advanced tutorial and about to learn Power BI But I always have this question When I get I don't know what should I do from Get from this data. Okay. I I I get what you're saying. You're basically saying how When I get a data set What what should I be looking for? What should I be trying to look for now? For me since I've been doing this for many years and I've worked at so many different data sets I instinctively know when I see a data set within like the first 10 seconds I'm like I can already tell you what I'm looking for because it's like muscle memory It's just I've done so many of them. I know But as somebody who's never done it you don't have that muscle memory built up, right? So what you need to do is you need to find someone who can walk you through it Who can walk you through a data set doesn't have to be your data set But find projects find tutorials who walk through data sets and explain Here's what I'm thinking about when I do I do those I know other youtubers who do those for for free And you can just listen to them So when I see something like a date column The first thing I'm thinking of do I need to clean it up? Do I need this date column? Do I need am I going to make some type of time series based off of this? Or is this you know has nothing to do with the data set or their codes? Is there customer information like you know, these are things you just pick up on and you know what to do with them You know what information It is so my advice to you is just Instead of trying to do it all on your own the whole time Is find somebody Google it search for it look on youtube find someone who has Done this before and you can listen to and learn from because it's kind of like having your own little mentor, right? Maybe not exactly for your data set, but you can learn their thought process and that's that's very important Um colman parks a dog where we get hurricane and data set. I just joined stream colman Uh, I am guaranteeing that there will be a hurricane in data set probably on Kaggle within the next like week Um, that's that's where I'll be checking. I might check that one out myself because that's pretty that's pretty good Um Okay, I'll leave ftw. Hey, oh, I'm a senior. I'm guessing in college Maybe in high school. I followed your tips and videos and landed a as a data intern at a bank. Hey, congratulations That's awesome, man. Been doing it three months. I want to get a full-time position once I graduate next year any tips you have set yourself up already for a Very good career You're working at a bank. You have an internship. You're a data analyst. You're about to graduate. I mean you are You are where I wish I was Seven years ago You are exactly where I wish because you were primed to just like take off in the next four or five years Become a senior data analyst. I mean, I leave. I don't know who you are, but I believe in you What I will say is what you need to do right now is try to secure a job where you're working Go to the go to your boss and just say hey I even if you don't unless you really hate this job Let me preface this But just say hey, I have learned a ton and I now know a lot about this bank in particular I understand your data. I understand your needs and I want to stay So that I can use that experience and help you and grow with your company Could I come on as a junior data analyst and just leave it at that? He'll say hey, we don't have a position right now, but you know, this other team has a position Most of the time They'll at least consider it right That is a good place to be That's what I'd be doing and then start applying if you don't start applying David Yolchiev Yolchiev Uh said I couldn't answer a few industry specific questions for a senior analyst role. Is that okay? I showcased my sequel python tableau and communication skills. I'm getting parched I apologize Here's what I'll say about senior analyst positions And It's a really big almost catch 22 And I I'm gonna answer your question directly and then I'm gonna go off on a tangent Okay, I'm just warning you When you get to a senior level role nine times out of 10, it's not it Not nine times out of 10 Six times out of 10. I'm gonna lower that six times out of 10 They really just want someone who really knows their industry Senior level to me usually says I know this industry extremely well That's where they're a lot of their value is derived Their technical skills are obviously important Sometimes you can get a job just off of technical skills, but from my experience the industry Knowledge of the domain knowledge becomes way more important as you become senior level manager lead Director you you need industry knowledge. That is what becomes most important. So is it okay? Um, if as long as it wasn't every single question Yes, I think it's okay. It's natural to not get be perfect um But you know You study up on those questions, uh, whatever they asked you, you know, really think about that If you get a similar interview try to try to answer those because domain knowledge becomes much more important the higher level you get Oops, I went the wrong way Can I free? Excuse me Water is getting to me guys Excuse me Can I work? Oh, and I was going to go on a tangent So I'm going to go on a teeny tangent Um, I worked with a mentee recently. He's uh, he's now two years in Um as a data analyst I I just stopped working with him like three months ago, but I worked with him for like a year and a half He had his first first job contract contract contract now full-time And he said do I need a specific do I need to go into a specific industry because he's kind of a generalist He's done a bunch of random jobs I said hey, listen, you know, let's say you have 10 years experience jumping around And now you're like I have 10 years experience as a data analyst, but you have no Singular experience in the industry. You don't have a lot of industry knowledge 10 years looks like a lot and you're like Hey, I deserve to be a senior when you go try to be a senior data analyst or or even higher a manager They're gonna expect that that level so You're gonna kind of handicap yourself in terms of salary because you're gonna expect to pay that's up here But your domain knowledge is keeping you down Versus let's say someone like me who specialized in health care or whatever industry you want to specialize in but I I specialized in health care My really deep knowledge of health care allowed me to propel a lot faster and get a lot more money Because I have that domain knowledge and that's what they're paying for. I have the technical skills But they're paying for that domain knowledge um you know 10 years of experience in one industry versus 10 years of just general experience that the Person with the experience is going a single experience Is going to get a job 10 times faster every time They just are they know the industry. They know what the market looks like. They know how to talk. They know the verbiage They know everything That is that is what makes you valuable in my opinion Take it leave it Um, can I work in freelancing as a data analyst without working in companies? Absolutely Um, you know, you can do consulting start a little consulting company You could do freelancing in terms of like Fiverr Upwork those other platforms. I can't remember what they're called. You absolutely can do that Or talk to your local company. Ask if they need help reach out call um Let me okay. Let me see. This one's an interesting one. Theo Phyllis Woreco I found myself in a situation where I'm trying to get into a data analyst niche But I'm in a startup where there's no one to mentor me What do you think will help me? Um, that's really tough, you know, because when I got my first job I had him when I well not my first one as a data collection specialist an analyst About my first real data analyst job at the healthcare and legs company. I had a fantastic mentor who taught me so much It's soup. I really think that's like where I learned the most is just from mentors Um, kind of guiding me and working me helping me problem solve if you don't have a mentor It can be tough, right? There are people like myself who do mentorships I don't have any availability. I apologize, but you can find them you can search on linkedin find someone else in this industry or You know in your realm Who you can talk about go to the discord, uh, you know go to my discord and see if there's other people Who are in a similar place and just try to talk with them um, but a mentor's mentor is not um Not having a mentor is tough You you know, it's it's hard to figure things out if you don't have someone who already knows and can kind of guide you My my recommendation is just be to Reach out and try to find somebody Oh, jeez. It just skipped to the very bottom Just skip a ton of stuff um Geez, let me go back. Geez. Oh my gosh Oh boy Uh, I I didn't go as far back So now I'm near the front if I missed your question. You really want me to answer it got posted again. I'm super sorry Um, the kick 32. What's your editor of choice for python and sequel? I use notepad plus plus for python I know I need to commit to a better tool and for sequel. I prefer d beaver uh, let's see For python, I mostly use visual studio code. I've used adam. I've used pie charm I like visual studio code. I just for me. It makes the most sense I like for for some things for when I do tutorials and stuff. I love jupyter notebooks Um, so jupyter notebooks is another good one if you want to kind of like It's just a different format. It's a different way that you can think about things So I like jupyter notebooks as well for sequel I really prefer my sequel and I prefer microsoft sequel server. This is the one that I like Um, Diego Torres says hey, Alex. I started watching your videos before getting a job in data Now I've been a data analyst for almost two years hoping to move into data science soon. Thanks for the great content. Awesome, man Congratulations. That's that's fantastic um Let's see Just reading through Sinister says man someone ask you if getting data analyst job will make him get a beautiful wife Uh, no, no, no Getting my beautiful wife had nothing to do with me being a data analyst I actually got my first data analyst job partially because of my wife So no, my my wife was what made me my my job did not get my wife I'll tell you that much and I think she may be watching she took If you were there wife If you were out there watching which you said you were going to your downstairs watching I believe in you. I I care about you if you were downstairs watching Just put something in the chat Just anything whatever whatever comes to your heart Um, this is a good one gobble gobble gobble turkey over here How many callbacks did you get from applying to a thousand jobs? Um I I don't remember the numbers. I think it was like I got callbacks from like 75 or something um And I actually got a job offer believe this or not. I got a job offer as a data scientist Who was going to be working at a title title loans? And if anybody knows what a title loan is it's a really scammy Crummy company and I had no idea I was like, but they were going to hire me on at like 75 000 And I looked at my wife. I was like, that's not like a great job But I started looking at a company. I was like, this would be you know, what a great title to have But the company had like one rating Everybody said they were quitting within the first couple months And I was like, I didn't want to leave my current job Because my my family was dependent on my income, right? We needed my income So I didn't want to go to my company my job that paid decent and go to This job that I thought I was going to get fired within the first three months and then have no job So yeah, I didn't get many Uh, I think it was only one But then I started being smarter. I started working with recruiters and once I started working with recruiters I got a lot more job offers a lot more actual interviews or second round interviews much much much better um um All right, yeah ember I have the discord link above. I don't know. I can't go grab it at the moment But yeah, if anyone has it share it Excuse me the bisso mc mcgwa mcgwa Pain I can't pronounce. I apologize last year of masters and astrophysics But I cannot seem to even get an interview any advice. Well, if you're still in your masters, maybe that's why um, but if you're not getting interviews It is your resume 99 of the time Or it's your public profile if you have a bad LinkedIn profile and you're not posting stuff you should be Or you they find you on twitter or facebook or instagram and you you don't have a good social profile That also can hurt you but it's most likely your resume Um, I have a video on resumes if you want to look into that Oh, jeez it skipped to the bottom again. I'm not doing this Somebody somebody call youtube. Good night It's just like it's like going to the bottom Um, I don't see it and I will say I don't see I don't see a mess. I don't see a comment from my wife She's not watching No, I'll survive but she's I'm gonna tell her I'm because this is what this is what always happens She watches the first 30 45 minutes Then she stops watching and then that's right when she logs off. That's when I call her out So everyone in here knows my wife ain't watching. She didn't support me. I'm just messing Um, what tips would you get for a health analyst that intend to start posting on linkedin? Especially regards to issues of confidentiality Tend to start posting on linkedin especially regards. I wouldn't post anything that's going to get you fired I wouldn't do that if it has anything any confidential information. Don't post it Um people people have asked me and I'm like at the at a minimum You one you just should not be posting any confidential information If you're gonna create like a data set that has like any confidential information You need to de-identify that so it has no personal information No social security numbers. No nothing. You cannot have any that's like hip You're just gonna you're gonna get sued. You're gonna go to jail. You're going to prison for life That's not true. Um But genuinely I wouldn't be posting anything on linkedin like that. I don't know Sinister said man that I don't send it. Sinister's coming out with a I'm learning all of his comments. I don't know why Uh He's just he's his name's popping out to me said man. Thank you so much for these beautiful videos You're a legend if one day I become famous due to data analysts. I'll make sure I make sure to all people know and give you all credit That's what's up, man become a famous data analyst do it Um, what's your opinion on data analytics and politics? Uh, I personally love I okay Let me take a step back Politics is extremely interesting. They have a ton of analysts a ton during like um During political season during the election seasons in the united states They hire a ton of them, but it's mostly people who know politics people have like The domain knowledge ton of them. Um, my opinion on it is It's not It's one of those industries that kind of ebbs and flows during the political seasons to me. It's not as Constant but it's gonna it could be good for you. I like politics. I like I'm interested in politics I don't Like all the crappy stuff that happens in politics, but I like politics. I think it's interesting Hmm, let's keep going. I'm skipping back past a few Do you think data analysts will still be into high demand in five years? You I think it's in high demand now. I don't see it going down and here's what I'll say Is 10 years ago and I wasn't in data analytics at that time, but 10 years ago there was a fairly large shortage of data analysts. They just weren't As easily accessible to to come by and so they were getting paid more um Now it's more accessible more people can get into it There is always going to be a man demand for data analysts in some capacity and Honestly, if you think about it the The analytics space hasn't changed a ton has changed but hasn't changed a ton even the past five years that I've been in I have seen I've used new tools. I've I've learned new things, but there hasn't been a ton of change um, which tells you that a lot of companies A lot the majority of companies are going to keep their current tech stack for more than five years They'll start upgrading that you know, they go through cycles The current stuff that I tell people to learn are still things that are going to be necessary in five years And it'll still be a demand. I promise somebody Make a note for five years ask me Um Just reading through just reading through Let's see solo b or or so akg said my sequel or jupiter sequel I don't know jupiter sequel you're talking about um sequel light You do you sequel light? That's a python like sequel light is like um A python sequel framework um If I'm remembering that unless I'm thinking of a different one. I think that's right Uh, but sure. Yeah, I like my sequel like sequel is great Solo b says your projects are great Are they a good start to add to your resume or developing your own is the way to go post these projects only resemble our skill okay I get asked this every single day Every every single day I'd probably for the past over a year Here's my what I will say my projects won Genuinely my projects are what I would consider a tier beginner projects And I don't say that to pat myself on the back When I was making projects when I started out my projects sucked Um and compared to the ones now like the ones that I'm putting out that you guys can do for free I mean these are way better like 10 times better They are a fantastic place to start. I highly recommend everybody who's trying to get a data analyst job do those projects because they will help With that being said put them on your resume do the work then claim them as your own I am okay with that. I have no problem with that, but I want you to go further Don't just stop where I stop, right? I always tell you in those projects. Hey, I'm doing this. This is like entry level Continue with it take it on your own do a different analysis do different visualizations do something different But use that as inspiration. I was saying earlier if you if you guys weren't here I was saying earlier, you know, they were uh, I was basically I don't know if anyone even asked me sometimes I just talk Um, I was saying, you know, even today. I don't know how to do everything But I'll go and do like a guided project on more advanced things like I referenced pagination through like websites in python That was something that I didn't know how to do, you know a year ago And now I do it a lot But I got I understood how to do it. I learned how to do it and then I applied it to my own projects Um, because I needed to go through multiple pages on websites So I somebody walked me through it. I learned from that I applied it to then my own website that I need to do it on learn learn learn learn learn learn and figure it out That's what I want you to do I want you to take these projects learn as much as you possibly can and then run with it and do your own thing I think it's I it's invaluable. It really like that's how I learned at least um, I learned really well by doing these projects and then Doing my own thing and trying to recreate it and be like, okay What's the difference because it's not working here, but it's working here. Oh And I do like a deep dive and I it's like it's just a puzzle It's a it's just a massive puzzle they have to solve which I find fascinating And so that's what I that's how I would take it Uh, that's how I would do it um Oh geez it skipped to the bottom again. What is happening? Okay, I think I found my spot Gabe stumbled onto this live stream. Love you, Alex. Oh, well Gabe. I'm a married man. Uh, I'm flattered Um, glad you're up and running right now. Yeah, almost got taken out by the storm Can I get a job opportunity from just sequel and excel or do I need more skills? I The landscape changed when I first started out. I only knew sequel and not even that much sequel But a lot of what I got was mostly from my enthusiasm a good spirit my good attitude my um Domain knowledge as well. But yes sequel is like a power skill. I always tell people learn at first. It's it's Fantastic highly recommended. All right. We're coming. Just so you know, just so you guys know I started at like 8 15. I'm not gonna go that part far past 9 30 which is when I told my wife. I would stop. Uh, all right next one. Let me see. I'm sorry I'm skipping some questions on purpose. I apologize um Let's see mica I'm in my mid 40s I'm planning to migrate to the usa and change career into data analytics is the data analytics course a good place to start Please advise I genuinely and I I promise you I'm not just saying this because I have a video on it Or Coursera is like a sponsor the channel. I generally say this because I like the google data analyst Series it does not go crazy in depth. No and people point that out and I'm like, I'm aware of that Doesn't go crazy into depth But what it does do is it gives you a pretty good framework to walk forward with confidence. That's what That's the psychological aspect that most people don't consider which I do So if you don't like the google whatever I like it because it really takes you step by step Here's what a data analyst does. Here's why you need to learn sequel. Here's why you need to learn excel Here is how data analysts work and do their stuff. These are all questions that Some people don't learn until they actually start it and they're like, oh, I didn't know that It's a really good place to start You can build pro they have projects in there that you can build and it's excuse me Is just It's it's a good place to start That's all I have to say. It's a good place to start But yes, I do recommend it from people, especially if they're just starting out. Really good place to start Let's see. Let's see Taco dumpling. I haven't read this whole question. I'm only read the first Sentence so we'll see what else it says breaching out to recruiters should you approach them with the tone of With the tone of I want to learn more about you and your company or the tone of I have xx skills and xx experience I think I'm a good fit the ladder If that means the the last one Definitely with the tone of skills experience I think I'm a good fit And I'll give you an example There's a job and I'm gonna I always reference healthcare. There's a job with healthcare And they work with claims data. You could say Hey, I'm alex. I I really like your company You know, can I get an interview? Can we chat more about a position Or you could say hey, you guys work on claims data I've worked with claims data for two years. I use seql and excel with claims data with hospitals And in this again, I have experience so maybe a little different and I'm really interested in this specific position And I think it'd be a really good fit for You speak specifically to why you'll be a good fit and they're more likely to to interview you. That's my experience. That's what I would do Again, if you have no experience, you can just say hey, I know about you know, this type of work I have experience in this and this I really think I'd be a great fit for this. That's kind of what I would say Anonymous will a five months job experience and in Only affect my job hunt in the future because I feel like my current job I'm doing is not what I'm expecting and having second thoughts doing my masters in data science I literally just Coached so I'm mentoring this person just coached this person through this exact situation and I told them switch If you're six months in especially if it's a contract Contracting work you can sometimes only three months six months nine months a year contracts And then you're out and on your resume. That's not going to look bad on you It's going to show you it's a contract if it's a full-time job You can easily rationalize that By saying it wasn't a challenge for me I got in there is mostly excel work and a little bit of sequel And I have these skill sets and I really want to utilize them because I know that they're really useful and powerful So no, I wouldn't feel bad about jumping ship start applying while you have a job start applying Um, you know just explain that to them and most of the time they're understanding people they get they usually will get it um Let's see Again getting close to end I can't answer them all we'll see shines Shine skines skides Thanks for coming man. I appreciate it um Hot like fire. Yo, I've been in my brand new day to job for one month couldn't have done it without you alex Congratulations, man. I love to hear that. I like reading those out I'm just kidding. I like reading them out because I get hype when I hear people who get like jobs Um, and they just start like a that hypes me up. I love it Um, lisha. Hi alex. Is it important to learn python for a data analyst role? um you know There are some industries like finance that use python more than other industries now I learned python like three years ago and I became obsessed with it and I like I use it all the time just because I like it um But you don't need it. I don't think it's a need. I do think it becomes a very useful tool though Like when I first started my my junior data analyst job at the company. I currently currently work for We didn't use python on my team at all Nobody except there the developers used it. No analyst. I worked on like three or four analysts um, nobody used it I was like Hey boss, I kind of want to use it to organize these finals and and do all this Some automation here and she's like go ahead try it. I did it and they still use it to this day I talked to her like six months ago Um, no not that long ago like five months ago. They still use it Um, so, you know, it can be useful, but I don't think it's a necessity That's my opinion um, but um An interesting one. I have a mentor who's christine Chipala said I have a mentor who's really amazing She recently linked me up with someone who hopes of landing a job at their company Problem is I freeze when I speak with my connection any advice for networking I freeze when I speak with my connection like you freeze up. You don't know what to say Uh, I thought I thought that was going in a different direction. I apologize. I Yeah, I don't know. I don't know how to answer that. I apologize. Maybe if you word it in a different way I'd understand that one better um Let's see We only got we only got a few minutes people Don't ask me questions. Stop stop putting in the stop typing in the chat Uh, because I probably won't get to it. I apologize. Um, let's see Um, how do you work with recruiters? Should I hire one in order to get a job? No, don't hire a recruiter if you're at least if you're in the united states Recruiters are abundant. There are a million of them. They're a dime a dozen As you are so you need to work with many when I got when I was actively looking for data analyst jobs Um, I had my I was trying to get that first real job. I was working with eight recruiters at a time Um, it was like a full-time job on top of my full-time job to juggle that and not get fired for my first job Because that's on so many calls with recruiters Yeah, just How do you work with recruiters reach out cold call cold email keep emailing keep cold calling reach out on linkedin I mean It's you have to be a bit shameless You have to be a little bit shameless with recruiters like you can't assume that they've seen it You assume they didn't see it unless they've responded to you So you email them 20 times until they were so I mean it's it's a shameless. I mean it really is a shameless Um, but you you got to do what you got to do you have to look out for you first You don't know that recruiter and they don't know you but if you get in front of them You have a chance of getting a job and if you don't you don't so Um, it's tough. It's brutal. Let's see. It can be brutal out there but That's that's the game. You know, it's kind of a It's just what you got to do Um, all right. I'm gonna do Three more questions and then I am out of here. I don't want my wife to be angry at me I hope you guys can understand. I love my wife I don't want her to be mad at me. Uh, even though she didn't come to the live stream. Maybe she did Maybe she didn't Louis Eduardo Costa you are late. I just saw your message. I'm sorry man And you're like you're a super fan speaking of you guys want to support the channel I've only a few minutes left. You guys want to support the channel Um become a super fan become a member of the channel just helps me do stuff like this Um, and so the people in here who are you know, who have joined to be a member of the channel Thank you guys so much. You're the reason why we're putting this on it was going to be member only But I didn't like putting up like that paywall. So I hope you understand. I'm still going to do this You'll still be here. I still super super super appreciate you guys, but um Yeah, please do if you if you um if you want to. Um, all right three more questions Then i'm out of here I thought my wife was coming in Um, let's see I'm picking I got to pick good ones. All right. Uh, so I don't pick yours. I'm sorry. It wasn't good Uh, let's see Um boom See now there's no no questions that I want to answer because now I only have three left. I have to be selective um Oh, geez Let's see. I already talked about freelancing. I already did Okay Div yashere P. Hey, alex or hi alex When you are applying for entry level data analyst jobs choosing particular domain is important. Um, I am I am somewhat on the fence about this um because I did it and it really worked out well for me But I don't think everybody else has not everyone that's most people want I think you should try to Do something you have some knowledge in Right, don't go in purely blind like don't and try to find more general areas don't try to go into like video game analytics or Forensics analytics like with police like that stuff's really niche Crazy niche and really hard So if you have a specific skill set do it because it helps you a lot I promise you that domain knowledge helps you a lot But I think it's more than okay to kind of spread a broad net And just see what you what you get caught backs for. Um, That's my opinion. I think you should should You don't have to choose select the domain right away But within the first I say three to five years You should try to select a domain to stay with if you want to advance more and make more money Um, Marcello, Abadi. Hey, Alex or hello, Alex. I'm late here. I know I'm sorry. I started at 815 It's almost 9 30 here at least Um, I wish I could stay on longer for you guys, but I told my wife I'd be done it three minutes ago I still have two questions to go. So we'll see um But louisa, did you ever used Pentaho Did you ever use no, I've never used that before I don't know what that is Um ghost said be a man. Put your foot down. That's not a question But I what I will say is uh, no, I won't be doing that and I I I am still a man I'm still a man Let me see let me see because now I'm at the bottom I'm now I'm at the bottom I ask like a few more questions because I skipped a bunch of questions thinking there'd be more questions and now There's no questions. Jesus. What am I doing? What have I done? I've bottlenecked myself here Now I'm relying purely on you. Maybe I'm just do one more question I uh, all right, let me see. Um Yeah, I just talked about the google analytics certificate course. So if you missed it, uh, yeah, I'll I'll let them I'll let that speak for itself if you want to rewatch it. What do you think of the job market now? Job market right now is in a small downturn not massive as you may perceive it, um, but it's not massive The ones the the the big tech companies that overextended themselves The large companies that overextended themselves make up a small portion of the data analysts that are being hired So, you know, tesla's not hiring. You'll see facebook's not hiring. Um, These are small downturns, right? That does not mean that it's crazy crazy crazy tough what is crazy tough is It's just there's more people playing so and that's how it's been for many years. It's nothing new Stand out reach out to recruiters Work on your linkedin make a really good resume. That is crazy important and most people they don't have a great resume I've looked at a lot of really bad resumes Um, so the job market right now is still good. It's still good for people in the data world. It really is. Um And it's still competitive and there's still demand There's it hasn't changed Um that much Um, okay, okay. We got some questions. We got this is our last question of the night Last question of the night. Let me see Who who's who's the lucky last question of the night? I don't know uh, ali All right, alj here 128 said glad I came in don't don't piss off your wife Um, yeah, I won't I'm not I don't plan. I actually I'm gonna text her saying I'll be I I'm gonna text my wife. Give me a second I'm just gonna say done in a few one second Done in a few Bam. All right. It's it's set in stone Uh, let's see Oh geez what's happening Okay, last question. All right. Let me let me see. I don't want to answer that one. No offense. I don't want to answer it I only have one question left Yeah, I'm not this isn't my last question But I I do mentorship. I have like eight people that I'm working with right now I don't have any availability to do more. I don't um, and it's just as it comes as there's availability I don't have a wait list anymore. I had like 500 people on the wait list at one point. I was like It would take me like 10 years. No, no, sorry. Not 500 100. I think 100 people on the wait list I was like I will never get through this So I had to stop the wait list. It's just first come first serve. All right All Ola De Pupo Masoli Let's say he's Italian Um, this isn't our last question. I just doing it because he made a donation But he said please how important is power bi and data analyst career if you work with a data stack that's power bi It's really good to know. Um, but is it a must-know skill? I don't think it's a must-know, but you could learn tableau looker. Um, all these other Uh, uh, click view you can learn all these other visualizations and they could do just as well But power bi has a good one to learn Um All right. All right, you wore me down Parvez this is our last one of the night Shake shake Where can we practice real life projects for data analysis? I One I'm gonna my my channel and I'm not just saying this I genuinely believe it My channel has some of the best data analyst portfolio projects out there and they're all Guided projects those are fantastic I just did a video on Coursera projects on Coursera if you already use Coursera It comes with your subscription But they have a guided project section and they have like hundreds of ones. Um, and I I pointed that out in a video because One I never I didn't know that existed until like a couple months ago To I can't make every project out there. So if you're looking for something specific, they may have it and it's a really good place Next place I look is um, github So, you know, you may not think of github as like something like that But I found a lot of great resources and inspiration. So you can type in just github data analyst projects And see what comes up and go and look in people's repos and see what you can find Because they may have all the code there for you and then you can use that code and like learn from it Just good ways to find projects and you know Kaggle is a good place to look as well because they have you know, people can submit code on there too That you can see um, although that's more Machine learning focused you will see data analyst projects on there as well So that's what um That's what I would say That's what I would say now Listen, I genuinely I would stay on here for another two hours with you guys I I really would I love doing this I got family I need to sleep I thought I heard okay, maybe not I got to sleep. You guys got to sleep. Um, so we're gonna call it quits. Uh, but thank you guys for joining I had a blast. Um, you know, we're we're sitting at like, you know 100 plus people every you know, probably a thousand people who filtered through here And for those people who joined that that's a lot. It really did I I absolutely love hanging out with you guys doing all this um It means it generally means a lot to me that you guys are Motivated and curious and have good questions and you're trying to advance your careers I mean, I I wish you all the best. I hope that you know, you guys are doing well You guys are studying you guys are advancing your your careers in this direction Because it's done. It's done a lot of people a lot of good. And so I'm hoping that You know, this data analyst field Will be good to you as well so With that being said I see people saying bye in the chat Bye guys I appreciate it I may be doing monthly live streams from here on out if you want to support the channel You guys can become a member of the channel. You'll get little Memes or emojis that you can use of my face and you get a star next to your name, which is super cool Um, so, you know support the channel if you want to do that Thank you guys. I will see you guys probably like two weeks. I'm gonna be doing a 300k live stream I'll be doing some giveaways And then I'll be doing another October live stream at the end of october So I plan on doing more live streams. And again, I hope this one has been good Because I like plan on doing more live streams. Uh, so just hoping that this one actually sounded good with my new mic Um, as well as figuring out this whole like Streaming thing because it's it's somewhat new to me All that being said I see everyone saying goodbye It makes me sad. I don't want to say goodbye It's my wife. All right. My wife is making me do this. I'm just kidding. I love my wife. Don't don't tell her I said that um But huge shout out to louise and marcello who are uh members who joined You guys are making this happen. I appreciate you guys. Um, all right Take it easy. Have a good night I'm just dragging on All right, that's it. No for real. All right, let me go over here. Wait, how do I how do I stop this? Oh jeez I don't know how to stop the stream. No, I do. I just gotta go over here. Wait, do I know how to stop the stream? Uh, give me a second Oh jeez. Oh I found it. All right for real though. All right. Goodbye everybody. I appreciate it. Have a good night