 Hello, hello. Let's see if this is working. I always it takes a little bit of time from this actually start But I'm starting early today. It's February 29th Let me turn this down so it doesn't like to start echoing like crazy I just want to make sure it's working, but it's February 29th, which is a very special day I think it happens every four years. It's like part of the leap year thing, right? Really really neat Let's make sure this is working There we go. All right, we're working. We're we're we're cooking I see people already here. I appreciate you joining This is gonna be a fun one. We're just doing Q&A today. Nothing crazy. Nothing wild. This isn't one of my You know milestone ones where I'm gonna be playing guitar doing voices or singing for you guys or anything I'm just answering questions That's it Let me move some stuff real quick because I need to pull this laptop over That's I can see the questions all the I'm gonna tell you exactly how it's gonna go. I am just gonna be in the chat reading the chat That is Essentially all we're gonna be doing here. Let me make sure this chat's working. Let me make sure Computers being weird Not showing the chat over here. Let me go to this other one. Actually. No, let me go To this other thing give me one sec because I need to be able to see the comments or the questions Just give me one second. I do apologize But how's everybody doing? I'm the February tiny night. What a special day But let's come over here. Let's go to live I'm right here That's that'll do it. Oh There it is. Okay, perfect. All right. We got everything we need. I See people joining. That's great. Really appreciate you guys being here Is it doing this? It's really messing with me today. This thing is actually messing with me Because now I can't see it again This is very very odd. Let me go to live Put in this one. There we go All right, I see people. All right. Sorry. Sorry for the confusion. Um, but we're rocking and rolling now Let's get going. Um, like I was saying before this is just Q&A time You can ask me anything. You can genuinely ask me anything. It doesn't mean I'll answer it But you can ask anything you'd like Um, and then there you go. We'll we'll start answering questions. We'll start talking I see a bunch of questions already I don't sometimes I miss questions But don't spam the comments because some people do that and it it just You know, I can't I can't see other questions. It's not fun So Let's get going Um Okay, he won't be awake. That's all right discount code for the website. Um, if you're talking about Analyst builder, I'll put one in the I'll put it in the Um, I'll put it in the chat real quick in the spirit of coupon code. This is, uh, a b Money off If you use that code real quick You get 20% off everything. Um about to be releasing my full tablet course over there. That's not what this is This far is just that guy was talking about it. Um, so Um, all right, let's keep going. What happened to the live the live is happening Oh, here's an actual question. How is the job market currently for data analysts with one year of work experience? Uh, the job market isn't very great right now. It's uh, I mean usually layoffs a lot of places. I still know people who are getting hired. I still know companies are hiring but You absolutely are um You're seeing a lot more layoffs. You're seeing a little bit slowdown and hiring All of this stems back if you go and talk to most people it all stems back from that huge surge that they had of hiring Back in like 2000 to 2000, uh, or not 2000 20 20 to 2022. There was a huge huge huge surge. Um, and Employees were like a commodity. They were just like hoarding employees because that was like that at that time And so now they're slowly starting to You know reduce their work staff in certain areas and that's not super shocking And if you go back and you really look at like the psychist the cyclical pattern of hiring in tech And just like for people in this kind of field. It is very there's a lot of patterns to it Right now. We're kind of on this slightly downhill wave But there was a lot more hiring than there has been firing in the past several years just because that huge surge So, um, right now it's not great if i'm being honest. It's not great even for a little bit of work experience There's just a lot of people out there. Um biggest recommendation is try to get referrals try to you know Use your network work with recruiters. Um, if you already have experience, that's really helpful. It's just um You know something to think about. Um Joining all the way from south sudan awesome in africa and i'm using your videos to study is it possible to mentor someone I I used to have a mentorship program. I I've worked with over like 200 people one-on-one, but um as My channel grew and as I got started getting promoted in my actual work Um, I just didn't have the time anymore and and at one point I had like 10 mentees at a time And then when one mentee would drop off I'd take on another one Um, and I loved it. I absolutely loved it. Um, but I just could not keep up and you know It does take a lot to run that kind of thing. So I don't do that anymore Um, what I did was I created analyst builder because people were paying me for those mentorships Um, I did about like I think it was 75 dollars a session for an hour I thought that was very affordable But some people were doing it for six months a year and I was helping them with everything all their questions And some people got jobs and then still wanted to work with me But that's why I created analyst builder was so that I could mentor everybody and a lot more in depth And have like everything in one place and so yeah, that's why I created analyst builder And not uh, and I just don't do the individual mentorships right now, but I will I do want to get back to that in the future Um Let's see. It's awesome. It's an awesome leap your day. Yeah, it's a leap your day, which is really neat It's February 29th. It only comes around once every four years. So it's really neat Um, this question. I just I just skipped a bunch of people. I'm sorry. Hey, Alex would Going for a data analyst job still be a good decision when AI is likely to steal our jobs. That's a genuine question. Um I think that as long as there are businesses As long as there is data as long as there are decisions being made with that data Data analysts are here to stay. Um, even with the help of AI. I mean AI is a great tool But as most people in the past year have seen there's a lot of limitations to it and what you can do Now over the next several years things will improve things will get better But if you've looked at like microsoft co-pilot, um chat gp, uh, yeah, open ai's chat gbt data analyst thing There's a lot of limitations and a lot of things that it doesn't do super well And so there's still a hundred percent need for data analysts in the foreseeable future Um in with everything everything in the tech world We're going to need to adapt to changing technologies to changing, um, You know workflows and tech stacks and all these different things. So I really see You know data analysis Transforming over the next several years. You just kind of got to ride that wave Learn what you need to learn learn the basics and as AI and as cloud platforms and all these different systems improve and change You change with it. That is my what I genuinely believe Um, what's the difference between a data analyst and data scientists? Both roles look kind of similar um The roles are somewhat similar. I have a few videos you can watch on the differences. Um the biggest difference is that typically data analysts are working with Ask data look at previous trends Most data analysts are working with like ad hoc analysis where you're you're looking at stuff from from the past There's a lot of ad hoc analysis data sciences are usually trying to Project forward. So using previous data to project forward Data analysts typically don't do a ton of projection some roles you might but not typically you're doing a lot of reporting on Here's what our finances looked like this year last compared to last year year over year month over month Change etc Whereas data sciences aren't working with a lot of that the overlap is the lot a lot of them Will you sequel python excel? That's pretty standard Each of them will do data cleaning But then what they use the data for data scientists are going to do a lot more data modeling Um, and they're going to have to do a lot more data transformation than what data analysts are going to do So it's a little bit more technical. Um in that sense But similar but typically data scientists do you get paid a little bit more for that actual technical? Um Experience the next question is from syed or syed mohamed. Thank you so much for the donation You did not have to do that Just appreciate it though. He says hi Do do have a job but always looking uh, he does have a oh it says I do This says hi, I do have a job at always looking for a better job You lived in dallas. Can you suggest some best places for in-person networking events in dallas? I did live in dallas. Uh, good catch. Um, yeah, I lived in dallas for five years That's where I got my start in data I highly recommend metropolitan areas if you're trying to like break into tech Because the online marketplace With all the remote jobs are very competitive because everyone can apply for them anywhere in the world in person or location based jobs are somewhat easier to get because you're there and other people can apply for them. Um Networking I didn't really do much networking. Um, Unfortunately, I really didn't although there were meetups in dallas that I became aware of after I just I never ever went So unfortunately, I don't have any info on that Um, I'm trying to think of what might be helpful The dallas scene is really good though for tech workers like You know, I was working at amerisource bergen, uh, which they just changed their name to something else But if you look them up, you'll see their name But there's a lot of car manufacturers like toyota And honda and volvo and a bunch of big Car companies that hire a lot of data analysts out there and then banking is huge in dallas So, um, if you look at usa a city Um chase they all have big data analysts people who are working with their business analytics and a ton of other people Who I know have gotten hired over there So I wish I could be a more helpful. I I actually don't know much meetup stuff out there Um, is python a react a must to learn to become a data analyst? No, neither of them are necessities Um React I definitely don't think so if you're talking about the react that I'm thinking of that's like a framework for Front uh for back end for like websites Maybe I need to look that up or um, uh, let me look react Like I'm gonna google this real quick Um Yeah, it's for web applications like python flask and react. Um to build web applications. No, you don't you definitely don't need that You definitely don't but could be useful to learn. Um They go back Go back could be useful to learn but python is not even a must. Um, I I The market has changed a little bit. Sorry. I got some things down here The the market has changed a little bit. You need to be more solid in certain skills But I started out only knowing excel in my first first first data analyst job at like the nonprofit Um, but then sequel and excel were what really drove a lot of my career forward and it's still super relevant today Um, but then I really do recommend knowing some cloud applications. I really recommend knowing specifically Uh aws and azure google cloud platform is used at some companies, but I hate google cloud I don't like it as much Sorry google. Um, I don't like it as much. I don't recommend learning that one I think azure since it's microsoft a lot of companies or microsoft shop learn those Those three things and then tabular power bi you learn those things. Um, Um, excuse me, you're gonna do you're gonna do uh have a really good foundation Let's see I'll learn english to crack interview or ace in normal communication If you don't know english or if it's not your first language Uh, just learning english is really tough because english is a really difficult language. Um, honestly um, but I I think my biggest recommendation would be to Talk to people or even do mock interviews with friends or people that you may know Um, but go into interviews like actually try to get an interview and see if you can do that Because you might fail It's a high possibility if your english isn't like super strong and you're applying for an english job You may fail. Um, another thing is and this is just uh, I have a course on interviewing in my sequel interviewing in So like for sequel interviews and then a course for interviewing in python Both of those are I mean all in english because I made them and so those might be helpful for you as well Hi, Alex just completed your data annals bootcamp. Whoo. Uh, a few days ago and it was really helpful for clearing many of my doubts I'm so happy to hear that awesome awesome resource. Um, for sure really recommend it. Um Let's see Okon g says please you said stuff is free and it's not free. Well, all of my youtube stuff is free this Uh q and a is free. Um, I do have a platform where it's all of my full length courses And it has like a questions page to prepare for talking to interviews. That is not free Although there is a free section in the questions. There's free questions on there So you can go and try out the free questions. That is free. But no, I have there's a ton of hosting fees um, uh Cloud fee because we use aws cloud platform fees. I have a whole team who helps me run analyst builder I can't make it free. Unfortunately. It is actually quite expensive to run month to month. Um Let's see one sec How do you recommend for new analysts to be valued for skills at a job projects? Um, at least to get the job like you need projects to really showcase that you know How to do things and it really challenges you because you have to build things and when you actually start building things You figure out you work through issues Which is really important genuinely. Um, so really really important But when you're actually on the job When you're first starting out, you're not going to be super valuable You're going to take a while to really understand their business use cases for their data Their clients their stakeholders understanding all their tables and databases and data sources because it could be sitting not in a database But um in a ton of other areas So you you're not going to be super valuable right away. It just takes time um Let's see. I'm just looking in here for questions I'm slightly backed up and not much like in my nose. I have like a little bit of congestion. And so Uh, that's all right Brian said I'm trying to find my first job as a data analyst. However I see some offers that require three or more years of experience. How can I find my first job? now that That happens everywhere in the world. Unfortunately some places. It's worse. I've heard a lot of anecdotal stories where they're like Um in india, it's much worse and that may be true. I don't know the india market as much Um, but then in places like europe um in canada in the united states It's still not great because that happens a lot, but um, my recommendation is is those years of experience is a guideline As with the whole job description if you have a majority of what they're looking for apply Um, you know your resume It needs to be able to get through that first step You need to be good at communication and you need to build projects to kind of show that experience But if you get into an interview and you really talk well, uh, and you interview well And you cannot I don't want to say convince them that you're you're a good employee But just really show like hey, I don't have three years of experience But I know I can do this job if you really convey that then a lot of times A lot of companies will be willing to take a chance if they you know got a good vibe from you Um, so I would just apply anyways. That's what I would say Um, this one says this is from heather. I recently graduated from Coursera data analytics and I'm searching for entry level What suggestions you have to overcame overcome the lack of jobs available versus the experience level That's a great question. A lot of people they start out with Your courses and then they gravitate to projects and then they are like, okay I'm ready to apply get that first job to start getting some excuse me actual experience and that's how it should be Sorry, I thought my wife texted me. That's how it should be. Um Unless you you know went straight from like Bachelors or masters program and then you're graduating into getting a job Here's what I recommend. Um One create a great resume start reaching out to connections who work at companies doesn't matter what company it is Well, it does but if they're working at a bank Reach out to them if they're working at a construction place Reach out to them because a lot of these places have some type of analytics or data departments It may not be called a data analyst, but it could be really relevant. So that's like the first step Next thing is work with as many recruiters as you can. Um, if you have a good resume, you should be I kid you not even back in the day when I started in 2017 Which is over seven years ago now It was still not an easy job market, right? It was better than it is now much better But I had no experience and I was like I had to fight. I had to like Grind it out. I was working with like seven or eight recruiters at a time And and a lot of them wouldn't talk to me or get back to me or they would ignore my emails and my calls but I you just got to be Kind of shameless. You just have to reach out time and time again and especially in this market I mean, you got you have to do what you have to do Um Precious said hello, Alex. I just made my portfolio website using your video. Awesome. Uh, thank you so much I tagged you on linkedin. That's super cool. If I see it. I'll be sure to like it or make some comments on it That's really awesome. Um Yeah, the the using github pages for Your it's it's a free website. It's super smart Most people are like paying for wicks or using the free wicks and it doesn't look as good Um, it's easier to make because you're not having to deal with the code of html and You know hosting it on github pages But just it's awesome Do you recommend a comp to a data certificate? No, I don't Um, Rodrigo asked oh wait, sorry soon. They'll ask a previous question What's the difference between data models and merge query options in power vi? um I need to go look exactly The differences, but if you're talking about just like data modeling and generating general That's usually referring to how the data is all tied together Um, and then how it represents it when you start using it in the power bi visualizations Um, and then you have the merge query options in power bi. I'm sure I know what that is I'm just I thought my head. I can't remember the Difference between that and the data models Because obviously merge queries talking about merging data together and different tables together I'm sure maybe they they work hand in hand. I on the top of my head. I don't remember I haven't used power bi professionally for like two years um And so I really need to dig back into power bi because they've made some upgrades and some changes But I've been using more tableau And looker than than power bi recently at least in the past like year and a half Um Rodrigo asked a question. I'm from argentina. I'm wondering if it exists a chance to get a job of data analysts overseas remotely So if you're wanting to stay in your country or wherever you are in this I've worked with a lot of people from all over the world for this exact You know exact question Which is I'm living in x I want to work for a company in let's say america, but I want to stay where I am. I just want to work remote One it's very possible. Um, I've I worked with people had zero experience and we're able to get jobs Um, but here's what they did and here's how they were successful and kind of what I've found to be the most successful One is you can do freelancing Freelancing is just where you go on job boards and you kind of position yourself for a certain niche You say hey, I'm really good at sequel. I'm willing to do sequel write sequel queries clean up sequel code Um, you know, it could even be as simple as something like Um excel pivot tables or whatever whatever you're good at you can market yourself on these websites like fiver and up work and other ones Um, then there is the better option And this is a little bit tougher to do of course because you have to interview for it But there are companies like Accenture. There are companies like um TCS which is taught of consulting services These are companies that hire people from other parts of the world They get them as consultants and then they hire them out to companies all over the world But um, we used to hire my old company on my team. We had I had a team of about seven people Um, four of those people were through Accenture We eventually switched to TCS and then we switched to another one. That wasn't my decision That was just a company-wide uh or department-wide decision But we would hire people and so we had people from Lithuania. We had people in, um, Australia. We had people in one guy in India Two two guys from India And that was the and I think we had to fire one guy and hire another guy But I can't remember where we hired him from but we hired from all over the world through these consulting companies Um, and they pay really well and so I do recommend looking into those I see So this question says how to clear round for data analyst role for my on-campus was oh wait My on-campus was coming soon. I am b-tech third year artificial intelligence data science for tech ground. I have to learn I have to learn a specific programming language. I think what he's saying is is, you know, how do you get past those technical interview rounds? um I have been through a lot And I've conducted a lot because I was on the hiring team for like three years Then I was a hiring manager and I conducted technical interviews the whole time. That was my part to play on the hiring team So past the interviews Really It's not as difficult as for most companies as you make it out to be um For most companies if you're hiring for entry or mid-level You're doing some type of sequel technical interview, which is a whiteboarding where they're going to give you a database or You know some simulated sandbox database or they're just going to give you a query with like and just have you walk through it like in your head Um, and they say hey, here's what we're needing you to write the only reason they do that is to make sure you know your You know what you're talking about. You're not some newbie with uh sequel and they need someone with three years experience because it's complex stuff They're working with um, so to pass that you should practice That is a big portion of my Platform analyst builder.com which is you can go and practice. There's a whole questions page to practice for these technical interviews whiteboarding There is another piece to these technical interview though is the general technical interviews This is a I would ice. I will say is more difficult Um, and this is the piece that most people fail at Um, you don't want to fail at the whiteboarding. You need to be able to pass that that's a bad sign if you can't pass that That's kind of like the first roadblock The second piece is the general technical interviews now um Not everybody conducts these in the exact same way, but they're going to give you some type of hypothetical scenario or some type of question surrounding Uh, the technical piece of your job. For example, if it's sequel I keep referencing sequel because that's the biggest one that you're going to get for data analysis Um is is technical questions in sequel. So they're going to ask you they're going to say Hey, what do you do when you have database in this sequel? A sequel database over here and you have a database and a sequel database over here. How are you going to combine that data? Well, in almost every language, it's not that hard to do You just need to specify when you're joining it together. Oh my thing went off. I thought it was I thought it stopped working There's an easy way to combine it and you need to walk through how to do that um And so it takes a little bit of almost like experience to know that it's not that hard to do And if you're like, oh, I don't think you can do that. Well, then they're going to be like, okay This guy's never used real production data before Um, or they're going to ask you about, you know, let's say you have really dirty data. What's your process for cleaning it? Um, again, I have a whole course. It's called the interview crash Sequel interview crash course on analysts builder made specifically for that has general technical interview questions I'm not here to promote it. I'm just saying it's helpful. So if you are if you think that would be useful to you I think you should take it um The questions mind facts said hi, alex. How are you love from india love back from the united states really appreciate you watching um maria yak Said hi, this is hue. Hey hue um tablo or power bi for data scientists, which one should be learned first Um, either one is perfectly fine. I'm gonna give you my anecdotal experience is my experience I've used both tablo and power bi um In production environments at different companies. I personally think Power bi is a little bit better um just for various purposes of How they it's just it's just how they do things and how it connects to a lot of different systems I think it's better. I mean, I'm not going to dive into all that because I could talk about that a lot I think though that tablo is easier to learn as a beginner Because the ui is just a little bit more user friendly um And things just just flow a little bit easier In tablo. That's just my opinion But I've used both. I think for data scientists I think That either is fine. Um, and there are some visualization differences in both So it depends on I guess what you're trying to visualize as a data scientist But again, I worked with data scientists a lot and they use power bi and they get a lot of use out of it I've worked a little bit with data scientists with power bi uh with tablo and it seemed fine as well So honestly either I just prefer power bi on myself Um, but I recommend people learn tablo first because I think it's easier for people to really get into and understand better um And then you transfer to power bi and it's like not it's not that hard to to do that Let me see I forgot to get water. I may have to run and get some water at some point My mom's texting me. Let me see I have a reflection on my glasses. My mom's texting me. Why is she my mom's in here somewhere Hey, mom My mom's next to me. I have a good reflection. Okay, it's not like a bad reflection. That's good What do I think about quarto? Um, oh jeez. I'm pretty sure I've Seen this before um open source for publishing Book slides supports python rda. Uh, I don't know much about it Uh, I know I know I've um Out there in the wild before but I don't remember Sorry, do you need domain knowledge to be a data analyst or is it isn't it necessary? All right, I love domain knowledge questions because I'm very passionate about domain knowledge um You could go your entire career knowing the basics of domain knowledge skipping around from different domains to different domains You're in healthcare this month this year next year. You're in finance next year. You're in Um, you know, you're doing consulting for marketing. Who doesn't matter Um, you're gonna get pieces bits and pieces of domain knowledge wherever you're working. You will find domain knowledge The biggest thing I will say is if you want to go farther in your career If you want to make it to the senior level you want to become uh, um, you want to become a manager You know a senior manager of vp or whatever Oh Thanks, baby My wife was watching she got me some water. Thanks, baby I'll be um, that's really sweet of her I didn't know she was watching this Shout out to the wife. Um So if you want to get to those next levels domain knowledge becomes Increasingly important now your skill level has to match you have to increase your skill level be able to do really more technical things as you go but If you don't know the ins and out of whatever domain you're in your skill level isn't going to be crazy helpful Because understanding the data how it comes in the usefulness of it how it's used in your products How it's using your visualizations becomes more and more and more and more important So, um, you can get far you can even get up to the senior level with none of it But it's hard to get past that until you really know some type of domain. So, um, that's just my take on it I could talk about that. I could talk about I actually have a few videos on that I think Okay, let's keep going Taha, nephal said hi Alex. I got blessed. I found a job as a performance analyst before two before two months Thanks to you and your videos. I'm so happy to hear that. Congrats awesome work Um, let's see. Do we need to know machine learning for data analyst job? No no, I think um I think data science is Getting more automated. It's it's funny because I actually thought data science was going to be more important as AI got bigger But AI is actually simplifying some of the AI uh data science stuff with all the models and stuff It it is simplifying things for data analysts too, but um machine learning specifically AI is handling some of those things And so it's making a little bit easier to run concurrent models and test a lot of different models at the same time Um, and it's making a little bit easier. So no, I don't think machine learning is crazy. It's super important to learn at the moment um I'm just going through can I can I tell you how AI works? I don't think Anybody can tell you how AI works man. It's just a black box Um, no, there is some there's a lot of videos out there on how AI works I've watched a lot of them, but I'm not an expert in AI So I'm not gonna stand here and try to walk you through something. I'm like I kind of understand um But AI is super fascinating AI Oh, somebody just made a donation. You don't have to do that. Uh football fanatic Hey, Alex laid off from a company with two years experience really started to hear that Um, I want to switch to data analytics. I have the required skills. So how can I approach things to get a job? Thanks for your awesome content. Um, yeah, you're really, uh, really happy to hear it's been helpful But I'm really starting to hear you lost your job. Um, I get it So a lot of people have been in your shoes and it sounds like you came from a different domain as my guess Um, so I'm gonna use the experience that I'm just super familiar with but it's applicable to a bunch of other areas Um, I worked with a lot of doctors nurses nurse techs all all the different people in healthcare Who have the domain knowledge after two or three years are like man, I don't like doing this Or I've been in this for five years and it's not what I want to do. I like the data side of things I want to transition Use that experience. Um, use your two years of experience or whatever domain you have and find jobs or companies that would value that experience For example, when I was applying for data analyst jobs, I had worked in hospital. I had interned in hospitals I had, you know, uh, a degree healthcare related And I use that to apply to healthcare analytics companies And then that healthcare background really set me apart from other people because I understood the data And so if you understand how things work in the real world when you get on the data side, it's super helpful And that's very valuable So my recommendation was take your resume And see how you can showcase your knowledge of the data of the data of the experience that you do have I've seen it and people Once they changed their resume to be more like that It's done wonders for people. I've worked with people who are in pharmaceuticals I've worked or people who are pharmacists. I've worked people who are doctors who are nurses in my mentorship program That I had like two years ago and all of them were able to get jobs every single one. I don't think there was ever one that didn't Um, we're able to get a job as a data analyst because of that experience. So you want to use it That's my biggest recommendation um There's reading through questions Which industry is best for a data analyst? There's a lot of great industries I would say the biggest ones Um that you're gonna have the best chance of landing a job in are things like health care, which is never going away Banking which is never going away. Um Yeah, I would like finance finance is a great one big tech is a good one and there's a lot of jobs in it But it's hard to get so like amazon. So those consumer type companies. So amazon That's the little walmart target. They hire a lot of data analysts. They can just be a little bit more difficult to get into Um, that's my my experience. Do you use chat gbt in your daily work? Um Yes and no, um, I use I use a i pretty often Um for actual data analysis and then also I got co-pilot now and I've tried it out I had not I'm actually not a huge fan of co-pilot. I made a video on that. Um, It just I it wasn't super helpful to me It'll be like that some ai things are like helpful for like the layman who don't know what they're doing But it was super slow and so for me it was like slowing down my workflow a lot chat gbt speeds up my workflow in certain areas Um, and so yes, I definitely use it. Um, maybe not every day, but several times a week. I'm using it um for different projects or different research or Um different code that I'm writing and so very very helpful Oh, I'm starting to catch up on questions. I don't think I skipped a bunch good. Um, hi, Alex Do you prefer a boring job or a fancy high paying job? I mean, is the fancy high paying job not boring because I'll go with that one. Um, I I definitely would take that one. Um, oh, yeah, I think I skipped a bunch of questions by accident I hate when that happens. I'm really sorry guys. Um But Jalego said when I prefer a boring job or a fancy high paying job the high paying job Uh, even if it's more difficult Yeah It's boring jobs are boring. I can't I can't work on a boring job. Let me scroll back up. I skipped a bunch of questions This is an interesting question. It said, uh, this from og Gamers Hey, Alex, should I leave a job and search for a data analyst role or stay here half dedicated? I would stay in your current role. Don't just Quit and you know financially ruin yourself Keep your current job, but while you're in that job Start applying start, you know, building your resume building your portfolio Um, we're trying to reach out to recruiters like you need money's important. This economy is not easy So, you know, don't don't just quit your job. I don't recommend it um Horry asks, uh, I have an opportunity to work as a requirement gathering in construct power As requirement gathering and construct power bi dashboard I don't think that's a job title. I think it's like what they're going to be doing But I'm not aware about it. Could you give insights and throw some light on it at our company? We had power bi developers. That's literally what their job title was I would work them all the time to take our data and visualize it so At my last company, uh, give me one sec at my last company Uh, where I was a data analyst and then a manager of analytics is we had power bi developers who once we Did all of our work did all of our analysis cleaned all the data did all that top stuff Then we would work with the developers to visualize it and they would work with the on the pipelines Um and stuff like that. So if you can work on stuff like that highly recommend it because it is not easy It's not as easy as it looks um And so if you can work with uh requirement gathering and then building power bi dashboards and that's your full job Do it. That's like that's a great gig highly recommend it Someone said yes come through wipe Absolutely, absolutely Um, how's a bi analyst different from a business analyst bi stands for business intelligence and then data data analysts, uh For the data analysts. So it's just bi analysts versus the data analysts. Um, very company dependent I've seen it where bi analysts are basically data analysts business analysts tend to be our Business intelligence analysts tend to be more on the visualization side Um, or sometimes they're more like a business analyst. It's a very depends on the company I've seen a lot of different variations to this and so uh Look at the job description because if it's more working with Uh client facing stuff or gathering gathering requirements and then working with the team That's a that's a business analyst. It's not as much digging into the data working with sequel and all that stuff If it's a true kind of a business intelligence analyst, you're gonna be doing a lot of visualization um at most companies Oh my god a donation. Thank you so much. You did not I don't you guys don't have to do that I'll answer your question. Um says sir, what will be the future of AI and data science? Is the threat for data analysts? um as of right now genuinely it's it's not a threat to data analysts, um and I made a full video on that if you want to go watch a full video breaking down exactly what I think is going to change Exactly what I think the future is of it As of right now where everything is with AI even up till today Data analysis has a long future. Um, the reason being is Is any any any company in the world has data and you can use AI on that data. It's not crazy hard Getting good insights is hard and understanding the data is hard Um in the future data analysts will still be here. A lot of it Will be working with AI. I'm sure five years down the road for sure because we're working on a lot of integrations Or a lot of people are working on integrations with AI So you're going to be working with AI that's there's no doubt about it, but It's not going to replace The data analysts what it's going to do is there's going to be some basic insights that people can ask But they're going to get that basic insight and they're going to be like You know, that doesn't seem right and they're going to ask it certain questions follow-up questions And then they're going to be like, okay, I need to bring this to someone who knows what they're doing That's where the data analyst is going to be and they're going to be like, okay Here's what it's saying. Let's dig into the data and uncover and figure out what they're doing because AI is not going to be able to do It's not going to be able to do everything and The average person isn't going to be able to get the insights that they want as deep as they want In the real world now with the sample data set AI can do a great job. That's just like That's like caggle data. Um, it's curated. It's simple. It's easy in the real world It's a hundred times more difficult and so I don't see it as a big threat I mean Let me replace this Well, let me rephrase it Certain jobs will be changed over time data analysts data scientists data engineers database developers Everything it's going to change over time If you are, you know, you stick with it. You learn the the basics how to How to use all these tools that are really common. Python, Tableau, SQL, Excel You're going to be using those things with AI in the future. I'm just positive about it But the biggest difference is understanding the data really well understanding the business issues that your business is facing Um, understanding what the clients need and using AI to help you with that and there's going to be a limitation to AI always It's not just going to be like a black box where it's going to give you everything you need So there's always going to be human intervention needed Um And like I said, it's pretty easy Even years ago before AI just to like get simple insights with different tools different aggregation tools or you know, um things like that and You know, that's those have been around for a lot longer than AI has been in the public sphere And so I think as things go along, we'll just it things are going to change, but they're not going to be gone Um, I the the rise of an AI analyst, you'll see that in the future for sure. I've already seen job titles like that um, let's see Learning domain knowledge seems like one of the perks of data analysis you I mean you have to learn domain knowledge as you are a data analyst because um it's just You're working so closely with the data and if you're inquisitive if you're really interested in your actual job You're it's going to lead to a thousand more questions Because you find this little issue this discrepancy and you're like, okay How did this get here? Then you follow the rabbit hole back to another table. Okay Well that data pipeline did this transformation But it shouldn't have and then the reason it shouldn't have done that is from a different pipeline Where you ingest the data from this and this view and it's it's like you're like a detective genuinely There are times where I felt like a detective in in my job where I'm like, man, this is really tough really complex and I love it. It's just uh Super super interesting Is pandas alone sufficient for data analysis or we need to focus on other libraries like numpy mat plot lib, etc Uh pandas is not enough. It's like It's like only knowing sequel Um sequel alone can I don't think sequel alone is enough um Pandas is great for using the python language to manipulate large data sets Um, and I've used it at my actual work in my job for many years and it was awesome. I love it Especially for certain use cases But I don't know if that's enough just by itself. Maybe it's Some jobs in the world. It'll be enough But it's just most likely not going to be the only tool you use So no, I wouldn't recommend just learning pandas. Although I have a great pandas course on analyst builder um Let's see All right. I'm scrolling back down because I went back to actually skip forward Um, what's the job market look like right now for data? Not amazing Um, no e-barrientos. It's not amazing. There's still a lot of companies hiring Um, and I would say look local if you can if you're in like a place where there are local jobs Any major metropolitan area in the world is going to have a market for it Um, try to find local recruiters That's a big advantage to living like near a metropolitan area If you're applying online right now online jobs are crazy I've seen like within 24 hours some jobs get like 2000 applications Now a lot of those are like really bad applicants who don't have a portfolio their resume is junk And all just to give you also a little bit of insight on linkedin If somebody clicks the apply button that counts as an application in linkedin It doesn't mean the person actually went onto the website applied So there could be 2000 people clicked on it, but only 150 people actually applied Just a little tidbit of information for you Um, that may be helpful for some of you when you're seeing those numbers because it is like shocking um Let's see Okay, I saw a question on them. I think skip down. I apologize. All right. Give me a sec people are spamming My mod my mods aren't here today Gotta put people in timeouts You hate to see it when people start spamming you hate to see it um Which career is going to be more safe in an AI world data analyst or data engineer? I think they're actually both going to be safe. Um For different reasons data engineers are really important for getting the data from one place to another You need domain knowledge, but believe it or not, um data analysts work a lot with data Sorry data engineers work a lot with data analysts to do a lot of data validation Um, that's what I worked on for many years. I was on a data collection team at that fortune 500 company um We worked on data collection. I worked with data engineers database developers and my role is Very useful. Um, I know for a fact that those data engineers did not want to do what I did And I didn't really want to do a hundred percent of what they did. Um, and so there is this There's this balance between no one person wants to do that person's job. That's why they're separate jobs Um, and so I think both are actually going to be they're going to be needed I I just I the market for data is going to increase exponentially over the next 10 years Um, you'll see every company in the world is going to have to use data with AI in some way Or most and so you're going to see a lot of new jobs and new companies coming up and popping up And transforming they're like, hey, we need a data analyst to use AI because now we're an AI focused company We need someone who knows AI and who knows how to analyze data Opportunities are going to be there. I promise. I promise How is how azure data breaks plays a major role for a data analyst? Um, data breaks is awesome Let me just look up because I use data breaks for a year. I'm just going to look up what the textbook definition of data breaks is for you. Um Um There's not a definition let me say uh Let me look this up because I I I'll tell you how I used it I says data breaks is a cloud data platform that helps to store large amounts of data Structured and unstructured data in a way that makes it easy to get insights. All right, that wasn't helpful I was going to say that too Um, all right. So here's how I use data breaks. Um, we when we were using I used it for about two years in a production environment where um, and just a uh, Take a tiny sidestep data breaks is um Can be used with a lot of different platforms. You don't have to use it in azure But it's because it's kind of its own standalone thing, but data breaks is great. Um Uh for working with a large amount of data now what I use for that is something called pie spark Which is a pyth uh, you can use to retrieve the data different languages But I liked pie spark because it was python like but for spark Um, and so you can work with massive amounts of data that sit in a data lake And it could be structured or unstructured like it said Which means the data doesn't have to be sitting in columns and rows It could be sitting in a json file and you can go and you can retrieve that data and work with that data Really really fast. Um for huge amounts of data And so sometimes it's not always cost effective to store all of your data in something like a database or even a data warehouse sometimes you just want to collect files and drop them in and store them in Uh, it depends like cold storage where you're not going to be using it a lot Or if you're using it for a lot of different procedures and jobs and you keep it in like a hot storage or not even in hot or cold But all I have to say is that's what data breaks is good for. Um, and we used a lot with json files Um, hml files. What is it? What's that file type? I can't remember Um, but really great in conjunction with our azure because we had a data lake that we would drop a lot of data into for different Data that we were collecting and so you don't want to have to repurpose it Put it in store it in a database because that's going to be a lot more expensive And when I say expensive, I mean you're you're using a cloud based platform So you're paying for storage The difference in cost is dramatic It's it's astonishing how much it would cost to convert that. Let's just say json files. Let's say we had You know A billion rows worth of data that could be in a database But it was in a json file It could be the difference between a monthly cost of like a hundred dollars just for that data in a database versus like a dollar In sitting in like a data lake in certain types of storage. So it's dramatic It is dramatic. Um, and so that's why things like data bricks exist But there's a lot more you can do with data bricks. Um, there's a lot more you can do with data bricks That's just um for a data analysis. That's most likely what you'd be using it for us to access data Connect to data All right, let's scroll down. Let me see This is a good question. Will the demand for data scientists increase instead of decrease as data analysts? Two in the market is the easier find a job that pays more in europe or united states. All right number two I know for a fact United states pays more than any other country in the world Um, or the average, I mean maybe canada, but it's hard to find a job in canada It's just more expensive. So they have higher prices in canada But united states is going to pay the best almost all around typically Uh, and it's easier to find a job there typically Will the demand for data scientists increase or decrease? really hard, uh, I don't think It's hard to say in terms of increase decrease. I just think things are going to change. Um data scientists. I think is actually Their job might change more than a data analyst because their job is more related to the things that ai Is doing under the hood, which is a lot of the machine learning neural networks Um, ai that's kind of that data science realm while analytics is not 100 under that thing But data sciences are going to be necessary. They're just going to I think do the work differently You know what I mean, but there's definitely going to be a demand for it. Um, so I would probably say increase I just don't the data science market is not my What I know the most of Um, just for pun. What stuff do I need to learn so that I can predict trends for a certain market? Um, predict predictions are super interesting. I like, um I like predicting out based off things the thing about predictions. Let's let's just take, um, a visualization software, for example Let's do tableau tableau Takes the data set and it uses machine learning models and it says, okay, historically. Here's what's happened It's gone up down up down up down And then it says project forward. Well, you know what it's going to project forward based off historical trends and and seasonal trends Basically the exact same thing What you have to do in order to change that is you have to introduce Data that you believe is going to uh influence the markets in the future So how do you do that? You have to take into account a lot of outside factors that are not part of your data set Because you're projecting forward into a data set that you don't have So you have to take into account Economic policies you have to take it depending on whatever data, but the the economy um economic policies wars around the world. Um You know Andemics these are things that these models can't predict. They're never going to predict covid Uh, so 2020 Or 2019 of june therefore casting out next year looks totally normal But then of course covid hit and it changed everything So you have to really know in depth a lot of the outside factors or variables that are going to impact your data That aren't accounted for in the data itself Right, and that's tough to do it is really tough to do. So you have to really know your domain well Um, that's where that domain knowledge is crazy important. That's why people who aren't as technical We'll get promoted higher because they're like They just know the industry so well and so in depth that their technical knowledge isn't like what they're Really used for their their value is from knowing all the variables and how they're going to impact their business And how to account for them So predicting doing predictions it can be quite difficult Um, accurately Let's see Um web words way this is an interesting question. I don't know much about indexing I index some of the important columns a couple months ago and the total data was 100k Now it's about 150k. Should I re-index the table? So indexing um in database refers to um Optimizing the query performance based off of a specific Um Sorry, my wife texted a group chat. Sorry wife. If you're listening, I can't answer right now indexing refers to optimizing a certain column or columns For queering purposes. Um, I cover in uh, uh indexing in my mysql advanced course on analyst builder and walks through all of it And really what it does is is just for an example. Let's say you have a you have 100,000 or 150,000 rows If it's a wide table and a lot of rows if you're trying to query all of it, um, and that's not that's not a That's not a I guess depends what you're doing with it Actually, 100,000 can be a lot if you're processing it cleaning it doing other processes and so Let's say you have a query that cleans the data What you can do is you can create indexes on that data specific to that data cleaning process And it can speed it up dramatically You usually create indexes for certain scenarios. So for that data cleaning, let's say you're cleaning one column of data So really in-depth cleaning and so you have to multiple processes and it takes a long time You can index on it and it will Process it on the back end before and it'll use that index in the query And and usually they have index optimizers built in to a lot of most database managers Management systems and so it'll choose which query which index is going to perform best with that query and it'll help It'll help Speed up that data clean process dramatically. Sometimes it can take it from like an hour to like five minutes That's the difference an index can make and so If you have data and then you have new data, do you need to re-index? Um, most of the time. Yes, uh, when you have new data sets You want to re-index it if you want to do that whole process on that new data Now you won't yeah depends and it depends on how you're transforming the data. So if you're um Putting all the data into one then you're cleaning it you want that index on that data But if you're just doing it on the subsection of data and then appending that data or putting it into the already Clean data, you probably don't it just depends on your process. There's so many variables To how you index and what you need to index on um Oh, earnest earnest. I appreciate your comment. He just said Hey, Alex earnest here. Just want to say i'm learning a lot from your channel. Keep up the great work Thanks, man. I'm really glad. I hope you really are learning a lot um, let's see I have a grimy said I have a synthetic data generated But after more random dent data to it with some requirement I see that the data isn't well correlated. Is there a solution for that, please? Um yeah, synthetic data generation is is pretty new Um, I've only used it a handful of times. So I'm not really familiar with that exact scenario if I'm being honest um but You know the synthetic data is like You could even say like chat gbt creates synthetic data. Um, you just ask it to here's a columns Here's how many rows I want generate some data and it generates some synthetic data And there are companies out there now that you can pay or that have it integrated into their systems where you can um Say, hey, here's my current data set. I want you to create a projection for the future based off of a scenario Let's say if the housing market crashes and then the stock market crashes Predict create synthetic data that would replicate what might happen to x y z in that scenario and then it It's supposed to create it. Uh, I just don't know that scenario. So I can't help with that a lot. I'm sorry Um, oh, let's skip down again When is my tableau course coming it's with my editor right now. He said it should be done in about three weeks So in about three weeks, I'll release that on Analystbuilder.com. It goes like a hundred percent more in depth than my free Tableau core or series on youtube. Um with awesome projects that I literally is like Exactly what I did in my job using tableau Um And power vi like the real scenarios. That's gonna be a really good course Is cloud the future of data analytics and data engineering are cloud certifications like aws and azure or sales force going to enhance the resume of a data analyst Uh, it's a few different questions in there. But in general, yes, um The future of data analytics and a lot of it's in the cloud now. I just did a webinar with, um Career foundry like a month or two ago Something that I've seen I I do a lot of consulting now So something that I've seen a lot of companies doing now is actually taking their data off prem The reason for that is they're they have a huge dependency on aws or azure or google cloud If one of those goes down and they have They've seen these issues Then their services no longer work. They are processes. They're products. They don't work I have a dependency on aws. Analystbuilder sits on top of aws if aws goes down I have a dependency on that I can't though I can't afford To buy my own servers and run everything off of it. Nor do I want to really maintain that myself There's an ease ability with cloud platforms that a lot of companies like and a lot of startups. It's it's cheaper upfront cost um And so a lot of companies get into that ecosystem and then they just stay there because it's easier not because it's cheaper or better um With on prem servers, there is a lot of people going on prem servers where they have to then maintain the servers. They have to um Know how to use the servers like at one of my previous jobs We had on prem servers and we had a guy Who was our dba or database administrator? He maintained those those actual servers our physical servers and so You know there's a kind of a divide growing and a lot of people going both ways But cloud is here to stay for as long and prices are going to increase. That's another thing with um The cloud is prices are ever increasing your bill is never going to go down most likely Um on prem servers, you pay an upfront cost, which is hefty, but then over time it dramatically is less um, so a lot of companies are hedging their bets in a way other certifications, yeah certifications for things like aws and azure are actually pretty good Um, and I think they will be more useful in future years. So like data analysts aws and azure certifications are They are real things. They're good. I took the azure one myself. They my company paid for it Um, and it was really good. I learned a lot and that was A four years ago. Um, it was really good. I really enjoyed I learned a lot from it How programming polyglot I believe means you speak many languages. So that's a neat name. Um, how important is domain knowledge for the first job? Is it advantageous? Wait, what time is it? 11 30 it's um, I'll go until maybe noon. Um, but I was gonna stop at 11 30 Is it as advantageous as a data analyst to be well versed in finance and accounting if you plan on working in that sector? Absolutely. Um, domain knowledge Domain knowledge actually is harder to learn than I would say like something like sequel um, because Domain knowledge is just there's a lot to it. You can learn the basics and then to really know a domain not Learn a domain. It's like it takes a many years Whereas sequel you can pick up the basics of sequel in like a couple weeks or But then to learn the advanced stuff in sequel could take many many months or even years And so I think domain knowledge is extremely extremely important and extremely advantageous now if you have knowledge in accounting or finance beforehand Absolutely, but it's only Useful to companies that value that skill So you don't want to go to healthcare a healthcare or data analyst job and be like, hey, I worked in finance You know, I have domain knowledge. It's not useful Not useful Um, how to analyze complex report to write sequel statement how to analyze a complex report you mean like A report that's coming from sequel like a job. That's like an automated job. I'm gonna assume. That's what you mean I I'm not 100% How to analyze a complex report. Oh, do you mean maybe it means ingesting the data Into sequel and then analyzing it hard to say I'm gonna go off on a tangent if that's not the case Because this is an interesting topic which is generating reports with sequel and super awesome thing to know how to do You can create automated processes where you're spitting out files and dropping them places and ingesting files It's a whole thing. Um, very complex but extremely useful And so what I used to work on with my data collection team is we would have a creative process Usually the data engineer would do most of it create the process for ingesting the data I would come in for a lot of the transformation pieces a lot of the data cleaning Um, a lot of the filtering that you know filtering out data We didn't need getting like our core data that we're gonna then Use and then we would write all these different queries aggregations Use a lot of window functions. And then we would we get that final view I'll call it a view because sometimes we would put it in a view Here's the final view after we join all these different tables together do all these different things We have an interview and that data they want as like a weekly output So then we automate a job that says take that data after it's done refreshing We have a process where it refreshes all the data updates that view Then we take the view or that data put it into a csv we put into an sftp Which is a secured file That's some secure file. I can't remember the acronym Um, and they could then and go and pick it up Right, that's the process that would happen for all these different things that we were working on Um, and so I don't know if that's what you're asking, but that's what you can do a sequel. It's extremely powerful Why why should we use power bi after? Wait, wait Why we use power bi after cleaning and visualizing data? I don't understand that question. I'm sorry Oh boy, that's someone spamming I gotta Gotta hide you. Sorry My mods aren't here. So I'm doing it today feels really personal feels really personal right now um When are you doing training on cloud aws azure? Great question I'm going to be doing a free series on my youtube channel Um covering the basics of using aws and azure. I have extensive experience with both Especially as a data analyst, so I'll talk Uh A really good free series on my youtube channel for people to start with I'm going to be making a full Course that's my next course that I'm making. So I'm starting it like next week Um, it'll hopefully be ready in like two months, but I have it all planned out already. I just gotta you know do it um A full course on the basics intermediate a little bit more of the advanced stuff In azure first and then aws. It's all one course, but I'm just gonna organize it like that So that'll be ready. Um, that series both of those things will be ready Probably in like two months a month and a half two months, but it's gonna be awesome It's gonna be a really good Extremely useful especially because I found that people struggle with using cloud platforms They are a little bit more difficult than using like a database management system like my sql Microsoft sql server. They're a little bit more complex. There's a lot of Several other things that aren't people aren't used to and so I'll go into all that stuff It'll be really helpful. Um, Jalego said hey, Alex I think it's how you pronounce it. I don't I don't know. Hey, Alex I would like to work in the u.s. After your graduate my graduate program Which majors would you recommend computer science or statistics? Uh, either are great I think computer science is a great if I could go back. All right Alex beginning of college didn't go for You know nursing or becoming a doctor then switching over to physical therapy and then switching To recreational therapy and then now I have a degree in recreational therapy if I could go back I would choose computer science 100 percent. That's what I would choose Um, claudia said thank you for the great content. Alex. Is it possible to work as a data analyst remotely for the u.s I live in argentina. Thanks. Yes, it is possible Earlier I was talking about how you can do freelancing on things like five or up work or other platforms like that Um, that is a good way to kind of get some experience Um, and you kind of can place bids for different jobs You have to be pretty active on on the website The other thing is working for consulting companies like Accenture TCS and there are a bunch of other consulting companies as well They hire from usually uh companies that are a little bit cheaper and then they market so that let's say they pay You know someone let's say argentina. I don't know the conversion rates over there But you know, they'll pay you $20 an hour in usd, but they're charging the client $85 an hour and so there's a larger margin. Whereas if you were a consultant in america Um, you know, they charge $50 an hour and then 85 to the client or 90 to the client They make a lot less profit margin So in in other countries, they do that a lot with consulting companies And that's what I did when I was a hiring manager We had a team of seven three of them were full-time employees in the united states Four of them were consultants through Accenture and then TCS and then one other consulting company Um All around the world Lithuania India Australia In they say India already And so that's how I would recommend Oh, that's a good question. How can someone transition from data analyst role to a data architecture role now The reason I think is interesting is I worked with a data art several data architects back in the day and I found their job fascinating. It's very challenging it's it's somewhat You know It's different than data engineering But it's similar technical abilities and data architecture is actually really important and often that gets lumped in with Data engineering is they're like, hey build out these schemas build out our data architecture for how our database is going to sit um And so sometimes those positions are combined or interchangeable But if you have a dedicated data architect, which I used to work with, um They are working with building out databases for scale It's easy for you and I to get sample data sets put it into my sql database and it's free. It's running on your computer. It's super simple When you start working with millions or billions of rows of data The data architecture if it's good or bad could be the difference between things taking hours to run or minutes to run It could be this between a huge bill um for your cloud service or whatever service you're using or a small one or things breaking all the time and Customers being really upset or not breaking all the time very important job. So you really know I would say partner up with a data engineer um A database developer a data architect to understand what their role does and then go try to replicate it is It's pretty complex. It's pretty pretty neat job. All right guys. I'm going to do this for about maybe 10 more minutes Let me 15 more minutes And then believe it or not I gotta I gotta do some of my actual work But I like hanging out with you guys. This is always fun to me um I uh M Tiaz said hello, Alex. I'm from Indonesia. Your video really helps me in teaching my students I'm so happy to hear that. I love hearing that. That's one of my favorite things is when people use my videos to help other people There was a guy who reached out to me said he was um Teaching a group of kids at his local library Coding like python coding and he was using my lessons for their for their lessons. Um, and I just really heartwarming So if you're out there Hey, really appreciate it But he's like they were building like they were doing my calculator video So building a calculator with python like things that kids would be able to do Um or understand like the concept of a calculator. And so it's really really neat really really neat All right, let me see Which python course for data analyst do you recommend? Um, there's a lot of great ones out there on you to me Jose Portilla has a really good one I I have my own now. So if you like how I teach um, you go on analystbuilder.com I have two courses python for beginners, which teaches you from Beginner to like intermediate slightly advanced stuff like web scraping regular expression It's going to teach you everything you need to know about python. Then I have a pandas for data analysis course That's everything you need to know about using pandas in the actual workplace for data analysis So I would recommend. I mean if I'm being uh, you know Not to promote myself here, but it's a great course Probably one of the better ones out there. And so I do recommend that one There's a link. I think I put in the description Yeah, analystbuilder.com. There you go um Let me see Let me see. I'm just reading through questions. Some of these have already answered. So I have to like filter through Um, this is a quite a good question. He said hi, alex Which courses do you recommend? Corsa Corsair or you to me and if Corsair for example google or ibm So here's what I'll say. There's a lot of resources out there um, and The google data analyst certificate is really a lot more You know, I I took that one myself It doesn't go as in depth as I was as I would hope to go for the technical side Although you learn a lot about what data analysts do then they have the advanced course, which is just the python essentially Um, ibm's one is actually quite good. It's very python focused Um, and so if you're looking for an all-in-one I have my free data analyst bootcamp on youtube, which I would say is better than both of those um And then but you to me if you're looking for individual skills at a cheap price You to me is fantastic. Like if you're wanting to learn power bi you can go get a power bi course Um, I have my own platform now with all my own courses. So if you want to go check those out Those are on analystbuilder.com And one thing I will say And I'm not going to toot my own horn here. Uh, I actually am is analystbuilder has a built-in integrated coding platform So as you're taking the course as you're learning python, you get to practice python in the course The all these other courses on Coursera, um, and and you to me It's not as easy to use on Coursera, but then on you to me, they don't have that at all And so, um, just I think it's a better learning experience You learn a lot easier and it's more fun because it's me teaching just more fun. I'm more fun That's what I'm trying to say Um, let's keep going Hi, Alex. I'm a musician And would like to apply for music data analyst. I've never heard of that. I'm just starting to learn data Can you recommend music topics shareholders companies would be interested to see is that like for like a music company like a record label? Because I don't know anything about that domain. I'm sorry. I don't really that's super interesting I've never heard of a music data analyst That's really neat. I'll have to look that up um Ramanuj left laxman said what about microsoft excel for data analysis is important for data analysts as aspirants To focus on yes I think that's like a default like you need to know it like if you don't know it. It's suspicious you know, it's like How do you not know excel? I have a full excel course Out there on data analysts and I have a free excel on everything I I have full courses for things and I do recommend people Looking at those because it goes a lot more in depth. But on my youtube channel I have a free playlist Go check out the playlist goes over, you know formatting and pivot tables and functions and all sorts of stuff Highly recommend taking the free one. Um, but the you know, the full course goes a lot more in depth Claudia you're most welcome. She said thanks. I'm guessing it's girl But uh says thanks for your answer. Alex. I really appreciate it. You're most welcome uh Laryl Laryl. Hi, Alex. Can we expect some discount sale on your course's bundle during this year? Yes. Yeah, I I usually do It you know, the platform's only been out for about five months. Um, and we've done Two sales three sales, um And so yeah, we definitely will but you can you can even use, um code a b 20 off For analyst builder.com. I'm not trying to be like huge promotion people are just asking But I'm that's a 20% off any purchase form analyst builder um Let's see Oh boy, don't start don't start spamming the lad I'm putting you in a timeout, but I'll answer your question. I'm not happy about it He was just asking working get sources for data I actually have a whole video on best places for to get data sets I have a whole video on it. So go check that out But Kaggle is a good one for when you're first starting out for simple data sets Then I recommend going for like local government data sets because that stuff is messy. Um, it's more accurate to To real life data And so it's really challenging and so you go to like data.gov, which is the united states Government website on data I pulled data from there that I'm like really interested in and I look at it I'm just like man the government has such bad data. It's so good so good for all this dirty data Um, that sounds that sounds wrong how I'm saying it, but it's like in a good way I feel like I said that weird. Um Let's see Uh, this is a good question. Karam Shaza Shazaad said for beginners Do you recommend that they learn on their own or enroll in course led by industry professionals so they can act as mentors? Um, I don't fully recommend most like if you're looking at like a boot camp boot camps are super expensive They're gonna be like five ten thousand us dollars It if you have the money and the time then do it because it could be really helpful But um in general, I think most people can self-learn. Um, that's why I created the data analyst boot camp on youtube Is because I people can self-learn for free. I literally had hundreds of thousands of people take that um, and I really do think it's just a great way to learn and you need to be able to self-learn a little bit As a data analyst as anyone working in tech like you need to be able to research things learn things on your own Because you're not always going to find a perfect resource for it or have a mentor to explain it to you. Um So yeah, I think most people should start out with free resources like on youtube Or other free places to get stuff then kind of graduate towards some more advanced courses and then try to build your own projects Um, that's where you really stretch yourself. But you need to know the core concepts before you start building things Louis Said hey, Alex love your content Just a quick question. I'm currently undecided between entering the workforce for the science or head into grad school immediately after undergrad any advice um It's a super that's a super personal question really really depends on what you want to do but Um, if you're my son Louis right now, you're my son and you're looking at me And i'm looking into your eyes and i'm gonna i'm gonna highly recommend i'm gonna say In four in two years Is two years of a master's degree you're gonna be worth two years in the field My answer is no It is not now Maybe down the line if you want to get like a vp of data science role Maybe your education might come into play, but even then things are times are changing. I have I had a degree in recreational therapy I'm thinking over here getting promoted to operational analytics manager in charge of seven people in a whole department and you know, they had plans for my future I mean, uh, no none of that had anything to do with my degree It had to do with my domain knowledge of my experience and and I was good at my job and so I think that two years in a job if you could get a job right away two years in a job is You know, you're gonna learn two three four times as much Um in that time and you'll have a real experience to get your next job I have I if you were my son Louis Or louis That's how you say it. That's exactly what I would say. Let me see um This is an interesting question Vashu verma said. Hi, Alex. I'm a developer. I want to learn data analysts Is the right time to learn due to the recession not getting any growth as a develop developer Uh, what should I do experience in dev but want analysts? What kind of uh, you like a What kind of developer because the developer is very broad It'll say it could be a database developer a web developer. I'm just like there's different types of developer I'm just gonna say you're technical. You're pretty technical with programming languages then um That's a really good Wait to transition to it's actually quite easy or easier to make that transition because you have In-depth programming knowledge and there are some jobs that really require good at programming Um, but I would just learn. I mean usually when you're a developer, you know, you know a lot about um You don't know as much about the Lytics piece, but you know the coding piece. So it's it's getting into the mind of an analyst and how you look at data Um, so taking courses, I would just start with taking courses talk to some data analyst with your As a developer you most likely have worked with several companies who have data analysts at them I you know, you can always reach out to them say, hey, you know, I'm transitioning into analytics Do you guys have any openings for that? Um, so if you have experience and especially in the tech world, that's what I would do Hi, Alex. What is etl and where can I learn more this from ya? Yaboa good question. Um etl stands for extract transform load So it's a process where you're extracting data from a data source Transforming it and then you're loading it into your database. It's also, uh, uh There's a lot of different processes, but another popular one is it extract Uh load so you extract it loaded into the database and then you transfer it after So elt versus etl um, but Really what that is is it's just Creating automated systems or called data pipelines from a data source Let's say a client has a database over here every day every month Every whenever you're you're extracting the data You're cleaning it formatting it how it needs to be formatted before or you know or after but then for the elt you're you're Um or elt you're loading and then transforming it, but uh, we did a lot of etl So you transform the data to make it what you need it and then you load it into your system and so Um, that's really all it is It's you it can be done in a lot of different programs. There's a lot of companies that do only elt etl stuff Um, or you can do it all yourself and write the code for it in like sequel python Um spark There's a lot of different stuff you can do So swarupa yadav said hi, alex just curious questions. How is your journey building analyst builder platform? Let me see. I don't this I don't want this to be my last question because again I'm not trying to make this an analyst builder focus, but it's an interesting question. Um Analyst builder was an idea that I had about A year and a half two years ago Um, and my initial concept was is I think I'm good at what I do I like you know leak code and I like courses and I wanted to combine that into one platform So I went to some other platforms that I thought would really want to partner with me and kind of help You know, I could promote their company. They would make money. Uh, I may I could make money. Um, and it would just be a really novel idea And they turned me down and they were like, no, that's not what we want for our company And I was like totally get it totally understand really appreciate it. Uh, you guys are great at what you do So then I was like, I was like, heck, I'm just going to build it myself Um, so I got a team. Um, I work with an amazing team. Um, who are a bunch of database developers web developers Um, the uh They're called front end engineers back end engineers. They're Just amazing and we created the whole platform from scratch essentially. Um, and we hosted an aws We use vimeo for hosting but in authentication we use some authentication stuff Everything else is pure code. Um And so we use a lot of github aws But I I'm telling you right now I because again when you build things you just learn I've learned more about software engineering Then I ever knew about it. I feel like I could become a software engineer. Um, if my my friend cassoon Took me under his wing. I could become a software and uh, uh developer software engineer Um, so it's it was awesome, but it it took all over a year to make it Um, and at the beginning it was a little rocky We had some issues with logging in and that was our beta phase and some courses weren't working exactly right or You know, the output wasn't working right But we had our beta testers do it and now it's in an amazing place. We have like we have like 10,000 monthly active users who are using it every single month and we have like 200 300 people signing up every day Um, and so people are really learning it and using it and liking it. Um, so it's It's very awesome. I love it. It's awesome How important is it to get good at sequel and python nowadays with chat gpt? Um, one that's a great great great question. Um, here's what I'll say from my experiences I've been using chat gpt almost all last year and I use it for a lot of work As someone who has a lot of experience Using sequel and using python at work. Um for my job I will say that It gets a lot of things wrong or does a lot of things Inefficiently and if you don't know it you are gonna have to trust it because you don't know And then you're gonna try to implement it. It's not gonna work Then you have to go back try to fix it ask it questions and do things. Um It also has limitations It doesn't you can feed it every single piece of information that you want it to know And even then it's gonna get things wrong Um, and I've seen it a hundred times myself as well as a lot of other people have said the same thing It is pretty amazing what it can do Especially with the simpler stuff Or like code that is out there on the internet It can really use it and make it custom for what you're doing. So it helps a lot but um I've used it enough and worked with it enough to know that even In the future It's going to have some limitations and if you don't know it well You don't already know it you're gonna be bought your limitation will be AI Whereas I'm going to use AI as a tool my limitation is my own knowledge of the the skill Um in the domain knowledge, which again AI may not know perfectly, right? And so I still think it is extremely extremely valuable to know those things and Companies are still going to do technical interviews. They're not going to stop doing those So if you're going to get interviews for a data analyst or data science or data engineering or whatever You're going to get technical interviews and so you need to be able to pass those All right guys, I got like like one or two more questions in me Then I got to do something. I got to do my actual work because I'm just doing this Someone said I like your enthusiasm for dirty data That's funny. That's funny. That was good Let me see I'm just looking for like one or two more questions. That was Amanda who wrote that. That was funny. That made me laugh um This isn't a question. He said oh happened to be on youtube during the live. Don't tell my boss I'm not saying anything. You can be on here as much as you want Put the volume on low I used to do that when I had a previous job. It wasn't a tech related job I was working in a nonprofit and I was like a caretaker and so I would go on youtube all the time And I just kept the volume low and when people would walk in I'd exit out or something, you know You got it. It was just a boring job. I didn't have anything to do I'm looking for some good questions at the end Vincent said hi, Alex. What are your thoughts on georgie tech's o m s a program for someone with no data science and analytics background You know, I almost enrolled in this myself. I was at my previous job And it's an online masters for data analytics, basically um, but it was it my company had a tuition reimbursement program where they would reimburse me Uh for the tuition I paid for a company or for my education And so I almost enrolled in that one and then I got the uh, and then I got a promotion somewhere. I was like in a second I don't I don't need an education to be successful. Um, you know in classic Me me fashion. Um, it was like, I don't need I don't education isn't gonna do it for me Um, so I personally didn't get it. I didn't do it Um, I do think though for a lot of people that it is a good program. It's cheap Um, it's with a reputable company what I will say though is I've heard that's very difficult They have a high dropout rate because it's pretty advanced Um, you need some hands-on experiences what a lot of people said and which I had at the time so I thought I could take it Um, but just be warned it did I the reviews that I saw was very very challenging All right. I got like one more question There's cassoon. He's in here I didn't know he was watching this. Hey cassoon. What time is it there? Oh, it's like nine o'clock his time Yeah, he's watching. I was talking about him earlier. He's my uh, he's he's the I would say head of he's the cto. He's the uh technology guy the genius behind analyst builder I was talking about him earlier. I didn't know he was in here I should have talked more kindly about him. I'm just kidding All right, let's see Got one more question than me Oh, we got spammers. I gotta block them must block. I don't have my tea. I don't have my uh, usual, um people in here today Oh, it's 1024. Yeah Yeah, it's getting late there I appreciate you joining Um, will you add new bundles dante cosmos? This isn't the last question. Um, the answer is yes, we're actually adding roadmaps That's like we're um working on roadmaps right now because right now I just have all my courses But what I want to do is like take this course this course these questions this course this course these questions And really challenge you and have like kind of a guide kind of like the data analyst boot camp on youtube Kind of walks you through exactly what I would learn. I will have that on the platform. Um It's in a couple months. Hopefully Let me see. Let me see I'm looking for questions I answered that question You don't know what question I'm talking about, but I asked it um Okay, here's my last question. Hey, I know inock. I get it. I get it. I can't block them all I blocked someone He was talking about the spammers. Um last question. This is from shady Shady asks alex. How can I describe the project? I worked with you in my cv Let's say you go into my um You go into my data analyst boot camp you take use those projects or you go into analyst builds Are you you take those projects or courses in projects? How and I I have a full video on youtube on how to create a data analyst resume Highly recommend going and watching that because it does talk about this Which is if you don't have any experience you you work at subway And you know You have no experience, but you really want to transition in here's what I would do You put your skills at the top and underneath that you have a project section The project section is going to state the project name Maybe when you did it But in the description, you're going to describe Here's Here is the issue and here's how I accomplished it and here's what I used for it. So for example, um Let's say you did some analysis on the covet data project right on youtube You can say, you know, analyze wanted to see trends over time for um Infection rates and vaccines that were taken in different countries So you describe the problem then you say use sequel to clean process and transform whatever you want to say the data um And then aggregate and analyze these different things and then maybe a quick synopsis of here's what I found um There was a 75 increase in vaccinations after this date or whatever you found in the data That can be really interesting to somebody. Um, and of course you want to have a hyperlink on that resume If it's a digital resume have a hyperlink on your thing So it takes them to the project that you should have a portfolio and again, I have a video on how to make a free portfolio um You should have a link to that project where they can go and see it And then you should have a good outline of your code what you found etc So that's what I would do. Um, and then underneath it you have your experience and your education Which aren't as important. You want the ones that are useful to them at the top So that's how I recommend putting it on your resume With that being said That was the last question unless there's a crazy big question I don't have time Dark I need it on this screen. It's brighter and then on youtube. It's not as bright. I apologize for that I need to make it brighter in here I just need I just need to open a window looks so much better With having said I am out of here Thank you to my wife for the water um I got to get some work done. I got uh, I got clients and analyst builder stuff and other things like that Um, if you haven't already check out analyst builder has all my courses on it Um, and you can code on it do tag note questions prepare for those technical interviews. Um, all that good stuff And then just shout out to you guys really appreciate you guys being here um, it's Midday where I am and I'm just taking time out to spend some time with you guys answer some questions So if you have any other questions hit me up on linkedin. Um, that's the best place to reach me I think genuinely I get I have like I'm behind like I caught up to like 500 emails And now I'm back down to like 2000 emails. I haven't answered Um, it's it's bad. It's bad. I need an assistant, but I'm not paying for an assistant But I need like an assistant to like go through there and like give some generic advice, you know what? AI and I'm just going to use AI to do that. No, I'm not going to do that guys Um, but I'm I work through my email. I'll eventually get back to you if you email me But linkedin I usually get back pretty quick, especially if it's a shorter question So, um, hit me up with a question over there if you need to reach me, but I really appreciate you guys Thanks for joining. Thanks for coming. Um, I'll do more of these. I try to do these once a month But sometimes I just get so busy. Um, I just don't have time And so I do apologize for that, but I I made it happen in february the very last day of february 29th, thank goodness for the leap year. Otherwise, it would have been march 1st Um, but really appreciate you guys joining and taking your time With that being said, I am out of here Bye Oh wait, I gotta push this