 Hello. Hello. Oh Geez that got really bright. Can you guys see me? Hey everybody? Can you guys hear me? I'm going live. This is happening I don't know if you guys can hear me Perfect Seattle data guy you responded to me, and I appreciate that This broom is here for one reason and one reason only I Will be trimming this This beauty. I'll give it some type of Some type of monologue. I am sure because It's really been here for me these past couple weeks that I've been growing it and so Yeah, it's gonna be missed not by me it's kind of a hassle to eat with drink water with Just It's always goes like this and gets over my face and my lips and so I've got to go like this all the time Super annoying But my wife likes it and so I Told her I'd do it and I'm doing it So what are we gonna be doing tonight? first off we're celebrating the 100k That's super exciting I'll talk a little bit more about the Benoed rye That I probably butchered that but he said hello congrats on your promotion I'll be talking a little bit more about my new job, which I start next Monday, which is really exciting I do need a gellin hat absolutely agree. I mean I live in Texas. I live in Dallas, Texas. I Probably should have thought that through a little bit better So we'll I'll be answering questions Nothing super data analytics for analytics focused. I'm not gonna be answering like top skills stuff like that This is more like chill personal You know Not super heavy stuff But we'll be doing that. I'm gonna be trimming my beard. I have my clippers right here Who's this bullet? I think I got these at Walmart. I had that for like three years So that's what's kept this this thing in check And I will be announcing the winners. I already haven't pulled up Let me go check make sure you haven't pulled up. I haven't pulled up. I have all the names I got people from Saudi Arabia. The winners are from Saudi Arabia Turkey Canada, India Washington DC in the United States Colorado Springs in the United States India Pakistan and South Africa. So I mean Pretty much from everywhere in the world, which is really cool Or at least from like a lot of different sections. Hey, I see a lot of people Joining and saying hello. What's going on everybody? Hey Damon. What's going on? Cool cool cool. Yeah, I'm just reading through the child a little bit So it's gonna be a say I mean, this is gonna be super chill We're in my we're in my like this is where I actually record videos But what a lot of you guys don't know is this is like in my kitchen and so It's gonna be right over there. That's my kitchen. That's my living room right over there Back here is where like right over behind this door is where the garage is. Oh, this isn't focusing on me There it goes. Um, is where my garage is and then right around the corner over here is our laundry room and so it's pretty an exciting place, but This is where all the magic happens. I got my light over here super chill So let's get started with something because I'm just rambling at this point I'm gonna start with the winners of the giveaway and we already got like 60 people here I don't want to wait if they aren't here. That's okay because I will send them emails So if you are a winner fantastic, if you're not, thank you for for trying I had about I think it was like 800 people sign up for the giveaway and What were the prizes if you're curious eight people are gonna get free a free course from you to me they are I'm not sponsoring this live stream, but they're giving away stuff So I'm gonna give them a shout out Udemy's awesome. Go check them out So I'm gonna email those people who won the Who won the Udemy's? Course and Amy any course you want that's data analytics I have a whole page of data analyst courses and so they get to pick from that and choose anyone they want Two people will be winning a free one-on-one with me. I Do one-on-one mentorships. There's some people in the chat that I see that that you know a part of that and usually they have to pay for that because I help you know mentor and kind of You know review the resumes their portfolio projects all that stuff and You know, we're just gonna have a one-time session if you want me to review your resume We can do that your LinkedIn profile or just chat and and enjoy each other's company I feel like I should be looking up here, but I'm not I'm looking at myself So I feel bad about that, but it is what it is Um so With that being said because I hit the 100,000 mark already. I ended the I Ended the giveaway right so you can't answer it anymore. I'm sorry. I said there's people in here You know asking how to enter I already chose them. I already have a list of people and so I apologize if you didn't see that You know You got to check out my community posts more often because that is where it went so Let's get to the people who won. I am gonna pull it up Well, I'm not not like that not like that. I'm pulling it up on my screen Should have done this before I did not prep for this at all as you can tell Okay Okay, perfect. Here we go If I butcher these names I am not held liable in any way because I am terrible pronouncing Everyone's name and everyone gets my name wrong people think it's Alex Freberg It is not it's freeberg. It's just not The phonics or is that what it's called? It's not phonetically how it's supposed to sound, but it's freeberg and everyone thinks it's Freberg So I don't feel bad. I'm gonna butcher some names. So Here are the winners. I'm not gonna say what you won. I'll email you and tell you what you won You won something so that's exciting. The first person is Mohammed. I'll rabbi Dallara Fertina Chris can event caviar Rasu henir salvem Carson a KO Lisa that one. I know I didn't get right Dustin B. Odrynsky. That's a cool name Bavia Hansa Leah Suleiman Salim Abinand It's just no last name. Just Abinand and then John Jequose Smith I would say I didn't get any of those correct But I did my best, okay So if you heard your name Fantastic, you are a winner. I will send you an email telling you what you want and how to get that if it's the course I'll tell you how to get it for free. You're just gonna tell me what Course you want and then I'm gonna contact my person over at you to me Who's gonna send me the things that you can get free if it is the one-on-one. We will set up a time to talk I'm going back to the Chat real quick Yes, I'm sorry, I did close I did close it those are the winners Yes, if you're a winner, I will I will post the complete list of courses Albert yeah, Freyberg. It's sad. Nobody nobody does it correctly. Hey, Melody. How's it going? Love seeing you here Varsha Thank you That and she said hey Alex Congrats on the new job Real quick before Before this bad boy goes away Which I mean I get I got to the point where I can like really curl it I had some I had some beard wax not beard wax. It's not even it's like beard. I'm saying oil And I kind of just put it in here. It makes it smell good And I can get some I can get some curly queues going and that's how I know it's gone too far to be honest Real quick same last time I doing today I was actually doing amazing the day before and yesterday and then today I felt like garbage and So I'm still not 100% I I'm just like going in waves of feeling good feeling bad But I'm pushing through for you guys. I definitely would have been in bed asleep already if if I had the choice, but I am too I'm too dedicated I'm sorry. I'm just too dedicated. So real quick. I want to tell you about this new job I got Because a lot of people have been messaging me asking me about it, you know saying congrats, which I really appreciate and So what this new job is is I currently and still am I start next Monday? I still am a data analyst on my data acquisition team We had a job internally posted for a manager of operational analytics and intelligence and You know, I just applied. I My I think my wife was like hey just apply see what happens and I'm a big believer in that anyways I like to push myself, you know, try to You know shoot for the stars kind of thing if it happens it happens if not, it's no big deal and so, you know, they got me an interview and You know the position what they were looking for is someone who's good leader knows cloud Because they don't use that right now and This job is now in it. So it's on the it operation side of things So you can think about it's data like Tickets so people have issues they write a ticket online that gets The art IT support does that so they want to track, you know new Like a lot of new things they want to use have a lot of new data be able to track You know what tickets what issues are coming up the most? How quickly are they resolved? They want to they want to track a lot of new data And they want someone to lead that team to basically build that out and potentially migrate all of their data and all of their their KPIs and their visualizations all to Microsoft You know in the cloud and so That's what I'm gonna be doing. I think this is gonna be a long long long project It's gonna probably take Years two three years to get this all set up and that is that is the expectations. That's gonna be a long journey But it all starts here and on Monday. I hit the ground running. I've already got a meeting to talk about How we are going to determine whether we need to migrate to the cloud or not And so we'll start putting that on the place that starts Monday. So I'm really really excited It's a huge step forward for me It's all new everything new data. I have a whole team. I got to meet them. They're fantastic If they're watching right now, I already you know, you guys are great. I can already tell And so I'm super super excited. It's will be my first manager position in analytics And again, this is what I I mean I've been talking about this for years on the channel like this is where I've wanted to go This is what I wanted to do. I just You know, I thought I would take another maybe two years is kind of what I was expecting hopefully get a senior level position and then from a senior to to To this this position But you know, I was what they were looking for and they said they were interviewing other people which I don't know Sometimes I'm like were they or did they you know, just settle for me. I don't know But I like to think that you know, it was a good choice for the position. So that is the new job And yeah, we'll see how it goes. I'll be making I'm sure I'll update you guys on salary and You know Benefits of that position the kind of work that I do. I'll try to make another you know day in the life of An analytics manager kind of video. We'll see Okay, let me Let me Check the checks. I have I've just been talking to myself like I can see myself right now right here And so I've just been talking to myself But yeah, very cool stuff Good morning in India. Hey, good morning people in India. I didn't know it was the morning in India because it's nighttime. I get some 845 At night where I am excuse me Do I have next steps in mind after this Bruno great question. No, I don't But I do know that if I am really good at what I do and I like it that I could be a senior manager a Director CIO CEO, you know, that's only a few years away from you guys. I can feel it I'll be telling I'll be making videos in four or five years You know day in the life of a CEO at a fortune-telling company. We'll see Let's see Yeah, yep. Yep. Yeah. Congratulations. Thank you. I appreciate it. Okay Now is that I think this is the time to break out this bad boy This is emotional. It's very very emotional. I mean, I'm crying on the inside. I won't cry on the outside This mustache has been there for me for weeks Not very long, but the time that it has been there for me. It's It's really been there for me guys And I just wanted to say that this is not easy for me. This is like a friend. It's like cutting a friend It's like killing your best friend Like your puppy That got infected In iam legend. I mean, this is what it's like and it's gonna be really tough but we can do this together and Yeah, that's all I gotta say All right Now one one other thing I'm gonna need to use my phone for this. I don't have I again poor planning Um, I didn't I didn't put a mirror. Um, I didn't I should have had like one of those like poor old mirrors here I'm just gonna like, you know Just do that like really quick with the guard on Then I'm gonna take that off and do a little bit closer trimming. Um, and I'm gonna use my camera To be able to see myself This could go horribly wrong. I mean This might be something that's like in the blooper reel at the end of the year or something like that I really don't know. I've never done this before so All right Someone asked what's the giveaway? I already announced the winners like 10 minutes ago The winners were I already announced the names, but I'm gonna send them emails. So if yeah, it was you fantastic The winners will eight people win one free course from you to me from the page that I have That I've created that has all the courses that I recommend Then two people one are going to win Um, a one time session with me for one hour. We're gonna go over resume or LinkedIn profile um, or you know, um You know, we can just chat about life Um, okay. Let me kind of clear this area a little bit Because this is happening I said I do it. I'm gonna do it. I have the broom here to clean it up Jeez, I'm kind of close to this. Um, all right. Let's start. I'm gonna you actually actually I can use this I have a mirror right here. What am I doing? I don't even come Um, all right. Let's let's get this going All right, let's do this a little bit different This is much shorter. Oh my gosh That's a good look I don't um often publicly humiliate myself um But for the you know, 75 people or so people who are here. This is one of those moments Um, all right, let's go on because I don't want to look like this long I don't want people to take screenshots and post this on uh, my discord So Not bad. All right now So I have the guard on If you don't know what that does it kind of makes it a little longer. Oh geez. I look completely different You can you can see my mouth again um How do I look guys come on how do I look keep the middle part guys come on This is a family friendly show How do I like leave half of it? I'm Looking good. Thank you. Yeah, that's good. Perfect. I'm not leaving half of it. That'd be insane um Still looks great. That's what I need to know now Let me see if I can get close Now there's still these like right here This is I'm telling you this is uh, we're getting up close in person all day When I do that there's still these hairs right here that I'm gonna try to do with a mirror that I or Like on my screen right here. I can see myself I'm gonna try to get that This is the dangerous part. We'll see Geez What is that? Okay, I still look all right other side. I'm willing to do I don't want to go any closer I need a I need if I'm gonna do any more. I'm gonna need uh, like a mirror or something I think that's it. Um, I'll clean that up later I'll clean that up now. I don't want my wife to come down here and be like Why is there hair everywhere? Um, how does it look guys like be genuine? I feel I feel like a different person. Um, like you can see my smile again Uh, I feel I just feel feel good And honestly the mustache wasn't that bad, but I had to move it every time I ate Anytime I drank water Excuse me. I really needed that anytime I drank water Anytime I did like almost anything just wait. I'm gonna push some of this hair on the ground Because I'm gonna sweep it up in just a second. Um Five years younger. Thank you No shaving until 200k Carter, um, that is not gonna happen. I would have a Full beard um, which actually That's actually not a bad idea now that I think about it. Uh Hey, my mom's here. Hey mom I love you. Thanks for the support. I saw your post on uh, facebook means a lot That you're not too embarrassed at me. Okay. Um Yeah What's really really funny is I met with my my new team that I started with next week. I met with them early Uh in one of them said that they went back to their husband and said that I had a really nice mustache And her husband has a nice mustache. So, you know, we were joking about that I was like I was like now I feel bad Because I'm literally shaving it tomorrow. Um, and so If you're here and you're watching, uh, I'm supposed to do traumatizing But I will not look the same next week I just won't I'm gonna look like this It's not too bad It's I think it's funny that my mom's on here right now. It's like 10 o'clock your time mom You gotta get you gotta get to bed All right, let me clean this up really quick. Let me see if you can see much from my pants. Okay good You can't see them too much there. I mean, they're like joggers So I'm like not looking good right now All right, you gotta get off the seat off the table It's just one of those little, you know, one of these brooms Nothing fancy. Uh, we've got to get it all because um, oh my gosh There is a lot All right, well, let me move this chair a little bit actually I'm working hard here people. This is the high quality content that comes with a hundred thousand subscribers I mean, does it get better than this? Uh, me sweeping up my mustache hair. Can you hear me? I don't even know if you guys can hear me. Uh, I don't think that, um, I don't think it gets better than this I mean Kenji look look let me let me go around about Kenji real quick He had like 150k Livestream the other day. I joined it. It was okay. It wasn't this good. I'll tell you that much It was decent It was all right It was not that good. Oh, sorry guys wait Oh, jeez That's I shouldn't I should not have showed you that And that's it It's all done So it's me again. Um, I feel 10 years younger I feel better about myself. Um, my self esteem has risen A lot since since like two minutes five minutes ago um Let me go back to the to the jacks again. I get I get uh, I get very distracted Let me see Yeah, it's a ta classic. Yeah. Yeah, you know, I've been riding that that mustache train to to the 100k mark um And honestly that may this may be this may backfire a big time. I don't know if a lot of people knew All these new, you know 20,000 subscribers that we had since I started this mustache Even knew that I didn't that wasn't normal And so I feel like once they see that I don't have it anymore. I might lose a lot of people That's a genuine concern of mine You shouldn't have trimmed row hit row it row hit I apologize. I gotta be honest though. It It was annoying. Um I didn't I I can't eat with it without getting something on my mustache. I had an ice cream cone the other night You know, there's just those like cone freezer ones you have And I ate the whole thing and they were the mini ones. All right I'm not getting carried away over here. They were just like the mini ones and I ate it in like Like 10 minutes later, my daughter's like, hey, you know, you have some like ice cream right here and I didn't Um, and I felt like a fool so I Look like the guy from community. Yeah, I like that show. So that's pretty funny Oh, hey Ken. What's up, buddy? I love your live stream the other day. It was really really good Look while you're here though, man, I'm gonna be honest You guys if you're not doing this level of stuff on your live streams like I'm not coming anymore It was uh, it was okay 6 out of 10 Anyways, I kid You guys hear that Both my cats and my dog are over here I see like an intrusion or something right here Uh, look Ken when you get to 150k Sometimes you get a little bit complacent. I won't that is not something that I do But some people do and don't feel ashamed. I don't want you to feel ashamed about yourself. I'm just not what I'm trying to do I promise you But some people would feel ashamed You may I don't know Anyways, where's max uh max is under here over Let me see if I can get him over here max. Come here Come here max Come here Ah, he doesn't want to come over here He's well. He's a kenji fan. Um, I think he's a little bit upset All right, whatever he's not coming He's gotten really big by the way I don't know if I don't remember the last time I showed him on in a video or In a stream or anything like that But he's full grown now. Um He's getting very wiry like his hair is wild. It's like I don't even know how to explain it. It's a very unique look. He's a very very unique looking dog. He's supposedly a a Doxon poodle mix He kind of has like the longness of a doxon, but his hair is not like a poodle at all Um, benjamin I see your comment because you donated some money. Thank you very much. I really appreciate that Uh, I will answer your question because you did that Um, is vba experience useful jr. D data analyst jobs caggle Sure vba can definitely be useful. Um depends on the job like if it's in some if it's in a job description, of course I don't see the ton You know, again, I was just applying for jobs the past two three months. I didn't see it a bunch But it definitely is not a bad skill to have. Um, caggle. Yeah, go on caggle. Um You can learn a ton from there. Although I don't think a lot of the machine learning stuff is going to be extremely useful to you but You know, I think caggle is a great place to learn. In fact, they have a really really really good free data analytics Like a course in there and it is it's kind of difficult. I did it I did that like two years ago. So maybe they updated it But it was really cool and I learned a lot of uh, I believe it was python is what I was using in there so, um I would highly recommend going on caggle and checking out that course. Um, I might make like a video on that It was really good. Um, really difficult at the time for me because I didn't know python that well Now that I know python, I should go back to it and see if I actually think it's um Think it's hard anymore. Um Selectron mustache from face rest in peace um Let's see Benjamin, thanks buddy Glad you're feeling better. Hey, thank you. I appreciate it and I was saying at the beginning For the like the past two days I've been feeling amazing like like top of the world. In fact, I should have been I should have taken some medicine late. Um, and then just today I'm feeling like garbage again. Um, but this one's more of like a stomach bug kind of thing This isn't what I had earlier. So I'm just catching everything that's going through um Everything that's going through my house Uh now, okay, so look I've accomplished everything I was going to accomplish on this stream now We're just going to go to the chat um and hang out and chill for a little bit But I announced the winners. So if you have if you joined after that, I announced the winners I will send everyone who won emails of what you want and how to redeem it I trim my mustache if you can tell Geez, I feel so weird doing this It is gone. Um It's I think it's a better look honestly I did I I enjoyed it though a lot of people commented it on commented on it In my videos and so I might bring it back just for the fact that um You know Just pulls the people in It's a crowd favorite. I don't know what to say um No, it was not in our the Kaggle stuff was not in our I don't believe in our Uh, and then so I see some more Uh more questions. Let me skin through them Hey Alex, I just want to say thank you for all your fantastic content You put out I went through your sequel tutorials and then a project series before applying for jobs I think that's fantastic. Um The the sequel stuff that I put out is I think a really good place to start then the projects I think are um genuinely just a really good place to have some basic To intermediate level projects to put on your portfolio. I think you should go above and beyond that Um, you know, but that's like that's like a really good place to start I think um, and I went back and watched them since I made them like, you know, a couple months ago And I was like man, these are this is an excellent quality. I would absolutely subscribe Um I just landed my first job in data analytics. Hey Congratulations, that's fantastic. Um, you're able to show your covet dashboard during the technical interview That's amazing. That's I mean, that's huge Um, love your channel. Thank you wait. Is there an alexa analyst website? No, there's no website. Um, I have um I have a partnership with you to me who Is giving away free courses in this giveaway I have a partnership with you to me and I have a whole page of all the courses that I recommend that I have taken I really like and I recommend just this page of lots of courses Which you know Courses are fantastic. Don't take too many of them. Don't take everyone on my list. Don't do that Uh, I was the guinea pig. I I did the trial and error to learn what to learn and what not to learn And and where to spend your time. So and if you haven't watched that video, it's you know, stop taking courses or something like that You know, there's a reason why You know, you should take courses and there's also a reason why you should stop taking courses So look into that Kenji says eyebrows are next. Um, no That won't be happening At all The mustache was sick evan. Hey evan, is that you? You just messaged me, uh, not too long ago Uh, the mustache was sick. It was It is gone. I appreciate you joining Yeah, one of my good friends for a long time ago Um, it does look better this way. I agree. You can see my smile. Um, that's an award-winning smile That's what my mom says. Um, and so and if you guys if you guys just joined my mom was on here earlier That's why I'm saying that not because that's something I normally say I feel I felt weird after I said that so I needed to justify it. Um, what was the name of the Kaggle course? I don't remember It's like advanced analytics Kaggle course if you go on Kaggle and you go to their courses section You will see the data analyst, um, course on there and it's free. It's really great Um, to hoon bob bake so congrats 100k man. Thank you. I appreciate you coming to say that It's really nice of you. Um, I'm graduating with a degree in econ. Okay. So jar education 98 says I'm I'm graduating with a Degree in economics next spring. I want to create analytics. Do you think that an economics degree can be good? Yes, absolutely much better than my degree. Um, much better I mean by a lot I would say that, um An economics degree can be really good in like finance or like banking or things like that an economics degree is Is good. Um much better than a lot of other degrees like mine. Um, and so yeah, I think it is a good one Uh, what would I what advice would I give is, you know, do projects on economics and then find a job that's economics focused You know, use that domain knowledge and that degree that you have to your abilities I mean mine's in rec therapy, but it's in health care And so I focused on health care and I'm still in health care. Um, my company's still health care So, you know, I use that's my advantage even though I had no experience in it So that's what I would do python or are python all the way. Come on guys watch the channel um, let's see something about Humble brag james I james andrew wait a second. Are you the james andrew my james andrew? Because if you are thank you for joining man, and if you're some other james andrew that I don't actually know in real life, uh You remind me of a guy that I know in real life who's super cool um, and so You may not be that that guy, but there's a james andrew that I know who's a cool guy Um, congrats on the trim the 100k. Thank you. I appreciate it Um, I'm skimming. I'm skimming. I'm skimming Uh, it says are you familiar with the toronto job market? No I don't know the canada job market at all. I know it's not as I believe it's not as good as the united states job market That's just what I I have heard Um, hey alex I landed my first data analyst job today. Thanks to you and can't why Why you couldn't show us a ken in my my live stream? All right. Well, I'm serious. Congrats though. That's really exciting. Um, but I think I to be honest, I Um It's kind of gone because I want to stop. I want to stop. Um I want to stop hazing him or making fun of him. I'm not hazing him. That's that's a bit much Uh, but anyways, uh past my bedtime here on the east coast. Congrats seen the way Thank you. Thanks for coming huge support. Love you, man. Take it easy. Get some good rest sweet dreams. Um I got asked in a Bruno said I got asked in an interview. What's the first thing you do when analyzing data? How'd to answer this one? That's a really good question What's the first thing that I do? Um, I typically do some Export well, okay. Let's start from like the very beginning. Where is this data coming from? How are they collecting that data? Um, you know, that's super super important. A lot of people don't take that into consideration like where is this data coming from? Is it is it good data? Is it you know? Data that you need After that though, which you know, you may or may not need to be asking those questions Um, I do for my job the So this cat is obsessed with me. Um Like legitimately follows me around all the time This is charlie by the way or charlotte by color charlie Um, I'll get to more questions in just a second, but this cat follows me around everywhere I sit down for two seconds and she will be on my lap. Um Not Yeah, you have a good night. Um But then I look at I started doing just some Exploration like what's the what does the data consist of is there patient data? What are the patient identifiers as there is their consumer? You know, are there prices, you know, how are the prices calculated, you know I do a lot of exploratory data analysis is what I would say just kind of diving into the data Running counts. So, you know basic stuff Um power bi or tableau, which one do you prefer? I prefer tableau, but I like both Um, that's that's just honest. Um jahoon bob bake I recognize that name now because he was chatting earlier in here. He donated a little bit of money I will read out his, uh Chat to all of you. He said congrats 100k senior data analysts here. Wow, that's awesome Uh, I would say no one describes the job better than you. Good luck and congrats once again Thank you so much. That means a lot. Um, and congrats on your success. I mean senior data analysts. That's fantastic Um Link on why you should not take any course. You just go to my youtube channel. You'll find it. I promise. Um Let's see was your 2020 resume video similar in style to the resumes in your new job Really good question. Um Very similar. Um, I still like the style and the format and everything that I had in my resume Back in that video that caught me in my job that I have done currently in not the one that I started on monday that I'm currently in And I updated it updated the language updated the job descriptions and everything But I kept the exact same format. I like that format. I like how it looks Um, my mom's still here. I don't remember what I said mom, but um You said do I I don't remember what I said. I apologize. Just text me Um, because I don't remember what I said to be honest Amy said, uh, your videos have helped guide me in transition from teaching into data analytics over the past year That's fantastic. I hope we got that data analyst job Gotta keep mom happy steven. You know, you know what that? Um, yeah, and that's That's a very true. That's very true What about an unfinished degree or no degree jad ozzy? I got a little burrowing nose you guys I'm really sorry. I feel like I've been touching my nose a lot Um, congrats. Oh, uh unfinished degree or no degree. It's very similar to if you have a degree Except you just don't have a degree Which is uh, it is a benefit. Absolutely. But can people become data analysts without a degree 100% Um, I'm I just work with somebody who only has And you know who you are. I've been working mentoring somebody who only has their high school diploma Just got a data analyst job and then been in the job for like three months. So it's 100% possible. I promise uh Oh So my mom texted me and said I tell you you have a winning smile. Uh I guess maybe she doesn't I thought you did mom Uh, that was That was soul crushing because I don't I think what she's implying is that she doesn't say that so That was tough. That was really tough. Um, but it's the same thing. Um, you know, I have a video on how do you become a data analyst with No experience. That is the exact advice that I would give you. So I would check out that video Congratulations promotion to management. William. Thank you very much. Um, another alex Let's see see what this this alex uh wants to know What are your thoughts on it people transitioning to data science? Would data engineering be a good feel? um For sure data engineering is um, I would say Excuse me very geared towards what data Scientists do like a data scientist is somewhere in between a data analyst data engineer Somewhere in there, right? because data engineering is is doing a lot of back end database stuff creating, you know, etl pipelines creating schemas for databases um automating things Pulling data from from places and that's really good to know when you're a data scientist. So I definitely think it is Um, so I'm gonna go maybe 10 more minutes. I have a lot of questions. I'm falling behind I'm gonna start skimming them. I'm not gonna read every single one. So if I just give them yours, I'm sorry um Let's see. Let me see. Let me see. Let me see So my friend Evan, he said it's me buddy. I was telling my wife tonight You were going to make me want to start a youtube channel. Hey do it. I absolutely think you should do it You have a good personality for it as well. Um So I would recommend it Uh, and it took me like, you know, a lot of people ask me how you know How long does it take to really do it? You know this at the end of this year I think I was at like 25 or 30,000 it took me about a year to get to 30,000 and then it took me Eight months to get to a hundred thousand. Uh, and so I'm by the end of the year I'm hoping to maybe even hit 150 That would be insane, but it takes a long time. It's a lot of dedication It's a lot of consistency, especially when I really first started out It took me six months to get like a thousand subscribers. Uh, it took me a long time Um, and so it's it's a hustle man. It is a hustle, but it's a fun. It's if you enjoy, it's really fun Um Okay, I'm just skimming skimming questions again keep keep chatting them keep posting them I'll get to it. I promise I got about 10 more minutes or so You know, I don't want to go too long but hours hours plenty of time to watch me trim my mustache and answer questions Um Okay, so roby it sounds like you reached out personally and I gave you some uh, some good insights I'm glad to hear that. Uh, I I'm sure if I Went through my email. I remember you I promise I I recognize the name. I just don't remember what advice I gave you To be honest and Ken said still here ahead of the bed now Thanks for coming man. You're an inspiration Uh, not mine, but you are an inspiration to some I really appreciate you coming out Bruno. Oh, yeah the cat. I'm just catching up to that on the video. Yeah, I have two cats That's charlie. She's very she's not shy at all. She's she's obsessed with me My other cat's name is Cindy And she is like will avoid everybody like the plague very very very to herself Until she wants your love and affection and then she'll do that and you guys know max Well max wanted to blanket. He wasn't where I just left him Um, what am I doing in my new job? I'm going to be a manager of operational analytics and intelligence. What does that mean? Um, I I went through it earlier, but I'll quickly it's you know, I'm going to be building out um, maybe helping um build out a new potentially a new system in the cloud to collect data Drive new kpis for our it and operation side of things So I'm no longer on the healthcare focused as much. I'm more in it operations now But I start that next monday Um, let's see Redo questions Bum bum bum I'm still reading Tiffany said hi, alex. Do you offer a consulting service and mentoring appointments that I could invest in? I do um, and here's the thing about it is because I have a full-time job I do youtube and I do Mentoring um, which I you can find in the description of almost any of my videos. It's called patreon Um, I offer that and I think I think I like to think it's at a quite a low cost I know other people who do something similar who charge three or four times what I charge The issue with it is is that I have a very low Band width right now to accept people so I'm working with maybe like eight people um, but I have a wait list of like 40 people um or 50 people and a lot of people You know, they don't want to wait. It could be months Honestly, I work with some people For for for months until they get a job or even after they've gotten a job that when I've worked with them They still just want to be on just to you know chat and talk about their job and and kind of follow up And so I mean there have been times where I someone at the top of the list has waited like three extra months And so a lot of people don't have the time for that In the future, I'm hoping that I can expand that And take on more people. Um, I'm you know, maybe like 15 people a month But again, it's it's very it's time consuming. Um, I you know, so Take that into consideration, but send me an email. I'll put you on the waiting list. I promise I just you know, I don't like wasting people's time and I don't want to give you false hope that I can sign you up right now My mom said good night, honey. Love you. Don't stay up too late. I love you too, mom You're the best and I won't I will not do that. I will not stay up too late um Let's see Where I just lost I just love. Oh, okay. There we go Never mind link is not working. Oh Sorry about that. I don't know what link you're talking about that. Um and Evan I'm glad you I'm glad just I'm glad you're staying up staying up late for this one I know you're I think you're on the east coast so it's probably like 10 15 for you But you said we need david on a video one of these days. He's the man Absolutely agree. Um, he was on a video Asking my family like what I do for a living Um, but he was only there in voice and I put his picture like down at the bottom So he did make an appearance in a video, but he wasn't like a live video But I I can bring him on I'll bring him on one of these days When I'm like when I'm like with him in person. I keep losing my place. Where am I? um Mr. Pseudo macho cool name What's your opinion on self study hours if you had unlimited time? How many per day per week on one topic or many? Um, I've gone over that a quite a bit, but I'll I'll do it a little just Briefly on that is I think that if you can make that is your full-time job And you do not currently have a job and that is what you were doing Do it five hours a day, right? You know five six seven however many you can handle Focus on one skill for like a week do some projects at the end of that week move on to the next skill I don't know why I did that noise, but um, you know I used to do four hours a night on sequel And that took me like three months to learn it should not take anybody three months to learn if you take my tutorials They that will teach you how to do it in a couple days or a week. Um, Yeah, I just I didn't know what I was doing. Um, and so I try to teach you faster um, let's see Any cool place to learn tableau quick. I mean just go to tableau.com They have a lot of free resources. You can also go on youtube. I learned a lot of stuff from youtube I plan on making my own tableau courses coming up very soon. I'm gonna do an intermediate Or beginner intermediate advanced just like I did sequel. This will be a much shorter Um tutorials because I there aren't as many things to go in Uh in in tableau, but I will be making my own but I would just recommend youtube Um, how do how do I have a keep a work life balance? Really good question. Um, I've been really really really busy lately Um, the youtube stuff has been you know, taking off and my work has been getting more Um, and you know, I have a family. I have three kids. I have a wife How do I balance it? Um, I'm a really good schedule. I have a really supportive wife and you know, I I I think my time management skills And just stretching myself in terms of the hours and doing what I'm awake I've really had to stretch myself. So like, you know, I stay up. I'll probably stay up until 11 12 tonight Working after this because I still have a job until friday and then I started a new job on monday. I mean Um, excuse me. It's You know, you just got to really make use of every time all the time. I don't sit down much and just relax Um, I do every so often not much though. Um, I I have a lot of things in my head and I'm like, I gotta do this I gotta do this I gotta do this when the kids taking out. I know what things I'm gonna get done Um, so it's really just utilizing as much time as you can. That's what I do at least Have you ever worked with alterex? What are your thoughts? Um, I don't even know if I'm supposed to share this This might be I don't know if this is private information or not. I am partnering up with alterex. Um, yes, I have used them. Yes, I know them Fantastic fantastic company. I'm gonna be leading. Um, they're a webinar Interviewing like I'm gonna be the host of the the webinar. I'm gonna be Bringing in three or four analysts. Um, just from different backgrounds and interviewing them Uh, and so Yeah, I love alterex. I think they're they're awesome. You guys should check them out I think that I genuinely think they are really big. I mean, they're already here, but they're an up and coming company They're not as big as like, you know Tableau or or some of these other big companies that are already really established But they are a big company and they're growing a lot And definitely a skill that I have started to recommend to people to learn Um, hi, Alex, one of the videos you're playing for next month You had mentioned about the web scraping project and the visualizations ones. Yes the web scraping project I'm almost done with I have a pull-up right here. I'm not gonna show it to you I don't know how to show it to you to be honest But it is almost done. Um, I the reason why it's taking longer is because I I finished the first way to To scrape the data from amazon and then I was like wait Here's another way that people might also want to see so then I had to research it because it's kind of a different Different way than I've done before so then I I I'm doing it in two ways So in the video, I'll show you two ways how to scrape data from amazon And get that and have that as a data set to use for projects and stuff And so it's just taking longer because I Invested more time in it than I originally had intended And I was sick and so I just Didn't get to work on it as much as I wanted How do I deal with imposter syndrome? Oh man I mean, I'm about to start a manager position You know Imposter syndrome is still there I really is and I know my skill level. I know what my strengths are and I know why they hired me I really do because I Made sure when I was in that interview I said look these are the areas that I I lack in This was one of those The interview the interview for this management job was one of the most unique Interviews I've ever had in my life I will I'm going to make a whole video on it because it was just so unique But they basically were like we want you because we know who you are You're really good at what you do, you know, we we we know you are an internal candidate We want you and I almost was like, whoa, are you sure you know me? Like do you really really know me? Because you know, here are some areas that I lack and they're like we know that it's okay We want you for these skills these leadership skills these these technical skills your cloud your cloud skills That's what we want you for and I was like, all right Yeah, you're sure You know, so I was almost they were almost like they were they were convincing me to take the job kind of thing It was really weird But I still have that imposter syndrome Especially now more than ever not now more than ever But I have that a little bit right now because This is a big step up In terms of responsibility. I'll be leading. I'm going to be leading a team which I've never done before I know myself well enough to know that I'm going to work As hard as I possibly can to be the best I possibly can be and I think they know that So, you know, how do you get rid of it though is just to go out there and work really hard I'm going to spend lots of times researching new these new things that I'm going to be working on I'm going to spend countless hours just Making sure I know everything I need to know That's how I get over it at least Tiffany Gave two dollars. Thank you. I appreciate it She asks, hi Alex. Do you offer mentor services? How yes, I do offer mentoring services If you click the link, I believe in the description even of this one It should be called patreon You can go there if you just want to Donate money and say, hey, thanks for all the hard work But if you go to the top tier, I think it's like the director of data analytics That is my mentoring level or like tier whatever you want to call it It's currently full and if you want to be on that send me an email I think I have my email like my about section if you go to my like youtube page go to the about section I think I have my email there just message me say you want to be on the waitlist and I will put you on the waitlist I know message you when a spot is available What happened to the mustache? You missed it Tiger pinch of the poor Pange of banned poor What happened to mustache? It's gone. I just trimmed it With this bad boy about 30 minutes ago. No, jeez. It was almost an hour ago We got five minutes left guys five minutes and then I'm I got some work to do But it is gone. So Yeah Yeah, yeah, yeah, are you guys using docker? No, we don't use docker Congratulations on your new job. Thank you Uh, cool. Cool. Congrats your new job. How much statistics in data analytics do you do compared to a statistician? I don't do as much Statistics as a statistician that is a tongue to a show. Oh my gosh. I work with a few statisticians you know on our data science team and They do a lot more math than I do I do math we do calculations and you know formulas and all that good stuff But not as much as a statistician Um free code camp is a good source. Yes, it is. I would agree Um, how good should your sequel be to be an upper-level analyst? I mean, I would no start procedures or at least have it write basic ones or be able to debug them. No Window functions. Um, all the joins that's pretty basic. Um You know stuff like that. That's what I know. Okay. I'm starting to catch up. I'm almost there I'm trying to skim some I'm trying to catch up. We got five minutes left. I'm not I'm not the I'm not the end Um, can we expect you to ever make your own Udemy course? Yeah, maybe I Yes, and no, I definitely plan on doing it at some point, but I want to make all the free ones first I want to make the tableau power di python excel courses on my youtube channel first because I want everyone to be able to access them for free first Um, and then maybe after that I'll do um a paid course on like something I enjoy um I'm catching up. I'm kind of seeing if there's any other questions A lot of talking um out of curiosity curiosity what team is the pwc role that you turned down I'm currently working at pwc as a senior analyst myself in data analytics. This is on their pharmaceutical team um, and so I met with a senior manager a senior manager and then I believe those two directors that I met that I interviewed with um, and You know again, there's a lot it was going to be a little bit more traveling than I would have preferred and uh, I've heard the work life balances and is good and this position that I got now is better It just is um for me at least it is just better and I'll go into that in separate videos. I promise Um, yes winners have already been selected emails will go out. I appreciate it if you um Tried to try to win you entered and everything. I really appreciate that You've been leading 100k plus people alex. You can do 100 percent. Is it the quality or Trim the stash Is it the quality? I are did you trim the stash? Yes. I trim my stash and thank you. I mean, hey a hundred thousand people That's that's not in the scot. That's a lot of people. Um, but I'm trying. I mean let's take this to a million guys I mean doesn't have to be any time soon, but it'd be great um Up with a three month old. Oh, yeah Yeah, my friend Evan again. He's saying up with a three month old. I'll be up for quite a while Well, I wish I'd I wish I could stay up with you. I am absolutely going not gonna stay up with you My my kids are now two and a half and one and a half And they sleep much much much better now So I'm just checking my phone. They sleep much better now. I mean the other night They didn't wake up at all and it was the best feeling in the world. So no, I don't I don't miss that three month phase Not in the slightest. I feel bad for you But, you know It's all part of going through that, you know, it's going through you got to you got to do what you got to do with kids So um sequel versus pandas both at both have their place I know both I use both. Um, I don't think one is better than the other um How to practice sequel joins and sub queries go check out my videos I have videos on both of those you can practice them in those videos David enjoyed the live stream. Thank you. Get well soon. Alex. Thank you. Damon. I appreciate you. I will talk with you soon I am sure of it um Valentines said hey, Alex. I just wanted to say you seem like a really good guy. I'm okay. I have my good days I'm at bad days mostly good though. I like to think Uh, great live stream all the best. Yes, I got like one minute guys and then I'm headed out I got worked to these nights. So um Hey, Alex. I sent an email a few months ago and thanks for applying. I got a database job this week. Thanks Thank you to you. That is fantastic, Mitchell. Congratulations. I don't know what I said I don't know what I don't know if I made any impact. But if I did, um, that's fantastic. I'm really proud of you um I celebrate with my wife when our kids are able to sleep through the night too awesome. Best yet. It's a really awesome feeling Um, really really good feeling All right guys, um, I see people are still In the chat, but um, I am about to sign off You guys are fantastic. I mean, I would not be here doing this And doing, you know, what I genuinely love I I Is become a passion of mine to make videos and to chat with you and to You know do all these cool things that I get to do and and have Literally a hundred thousand people Have access to watch it and want to watch it. Oh, it blows my mind I never ever thought they would get this big and so You know, I'm gonna end this on a sentimental A sentimental note, which is You know, I just I wouldn't be here without you guys. I really wouldn't and it means a lot It just means it means a ton. I I really never imagined That this would happen and it's changed my life. Like you guys don't even know You know, it's just changed my life completely and it's hard to describe because it's just Changed a lot of things But you know, thank you Thank you to everybody And I know there have been hundreds of people who have flowed through here throughout the video And so, you know, I appreciate you guys and I appreciate Everything that you guys have done for me. I I know you guys always tell me that, you know, I've helped you But I promise you you guys have helped me just as much And so thank you. I probably have a little bit more cleaning to do so I'm gonna do that I'm gonna rearrange all the all this stuff out here But you guys are fantastic melody. Thank you for the for the donation. That was really really nice. You So with that being said, I am out of here You guys have a good night or good morning in india. Apparently it's morning in india But I have work to do and then I'm going to sleep So thank you guys. Have a good night or morning And I will see you in the next video probably next tuesday. All right. Bye everybody