How I Would Become a Data Analyst if I had to Start Over in 2024 | 6 Month Plan

What's going on? Everyone, welcome back to another video. Today we are going to talk about how I

would

become

a

data

analyst

again if I had to

start

from scratch. I've been thinking about this a lot lately because things have changed since I became a

data

analyst

. Six or seven years ago, the job market is different, TCH Stacks are different, and a lot of people ask me every day, hey, how can I

become

a data analyst? That's why I want to give a good perspective from today if I had to. Starting over exactly how you

would

do it again now in this scenario is almost like having amnesia.

I completely forgot everything I know. The only thing that stuck in my memory is that I really want to be a data analyst. That's all I have left. So my only purpose right now is to get a job in data analysis and I'm

start

ing from scratch. Nobody knows who I am. Nobody knows who Alex Freeberg or Alex the analyst is. I'm just a person who wants to be a data expert. analyst and I'm going to tell you how I would do that as quickly as possible so let's start from the beginning, Amnesia reminds. Alex doesn't remember anything except that he wants to become a data analyst, he doesn't even remember that.

I know what a data analyst does, so the first thing I would do, the first step, is just research what a data analyst does and this part only takes a couple of days. You're just figuring out what they do and what kinds of things they might be interested in and then determining what kind of data analyst I want to be. I want to focus on healthcare because healthcare uses different tools than a financial analyst or a marketing analyst or just a broad general data analyst who would learn the type of tools that I usually talk about on the channel, so I would try figure it out and then I would try to research what skills to learn exactly for that position, but for this example for this scenario I'm just trying to become a general data analyst where I can get hired at any company, so that's the first thing I would do, the second thing I would do.

What I would do is start learning the skills because you can't become a data analyst without any of the data analyst skills that is. It's just not possible now. I've talked a lot on my channel about the skills you need to learn SQL Excel Tableau powerbi python, then there are many others you could do with R AWS Azure looker and many others, but Amnesia Alex wants to get a job as quickly as possible, so no I'm going to recommend that you learn all those skills. I'm going to recommend that he only learn three, which will be SQL, Excel, and Tableau.

Now, why do I recommend those three skills in particular? those are the ones most likely to be in a job description, so SQL is sure to be in about 75% of job descriptions for data analyst. Excel should probably be at around 100% and then Tableau is just a bi tool. So if you know Tableau, you know Powerbi or you know Looker for the most part, like you know 80% of the others, so if you learn one tool, you usually know the others, so by just learning one tool you can change Tableau by powerbi or many other tools, but I recommend Tableau simply because it is a popular tool that many companies use and those three skills will open probably 40% of the jobs for a data analyst that exist now, of course, the more skills that You know, the more jobs you can apply for if you keep adding skills to your skill sets, then of course you'll be able to apply for 50 60 75% of the jobs out there, but if I were starting over, I'd just like to give myself the best chance at get a job very quickly, so I would focus on those three skills at first.

Now where would I learn these skills? I'm pretending Amnesia Alex doesn't remember that he's married. He doesn't remember that he has money in his bank, he is completely broke, so if he has absolutely no money, I would recommend that he go on YouTube and learn all the free things that he can find on YouTube. It is basically a university. A YouTube University. there where you can find anything and I myself have a whole channel dedicated to dating analysis and you can probably learn 90% of what you need to learn on my channel alone but there are plenty of other great channels available if you want to dive into different things now yeah You're not Amnesia Alex and you have some money and you remember who you are and you want to delve into some of these skills a little more in depth than what YouTube has to offer, there are a few platforms that I recommend.

I've been using Udem for a long time. I've also been using o Sarah for a long time. I've even created my own learning platform for data analysis called Analyst Builder in Analyst Builder. I have my own complete platform. courses that are much more in depth than the ones I have on YouTube, we also have a questions page where you can practice for technical interviews and we will get into technical interviews in a moment when we talk about how to get interviews, so leave links in the description if you want to check it out , but learning the skills is very important, so that's the next step I would take and honestly, I think I can learn SQL Excel and Tableau in two

month

s, so it's like a guess. that I don't have a job Amnesia Alex doesn't have any work to do, he's just dedicating himself to those skills.

I think two

month

s is enough time to really know those skills well enough to get an entry level job now if As Amnesia Alex would start applying for jobs right now my entire resume would have Excel Tableau and SQL which is one of the worst resumes I've ever seen, so what amnesia Alex is going to do or what I'm going to do is what I'm going to do. to build projects and create a portfolio when you're learning the skills, you should build projects with them so that you really solidify those skills, so that the projects are like complementary to learning the skills and then you can put those projects on your resume. at least that's what I would do now, instead of just those three skills at the top, we have three skills and we have several projects underneath.

I'd probably do two in SQL, one in Excel and maybe one or two in Tableau, all of these would go into one website and I have a link on the actual resume, but then I would have my actual projects on my resume that would actually fill out my resume and They will do much better, which may take a week or two depending on how quickly you can do it. do those projects or how well you know those skills, but in two weeks you can have five projects or an entire portfolio created, so so far it's 2 and a half months of work, investing in learning and building projects, the next thing I would do What What I do is start creating a resume and this is going to be a really simple resume, it doesn't have to be anything crazy.

I've done a lot of videos on how to create the best resume for data analytics and I would really only highlight the things that are actually relevant and not include things other than Amnesia Alex has no work experience or education so for him he will only put the skills and projects and maybe also a summary section, but it won't be super super. Impressive, but you're going to have a lot of what they're looking for in a lot of job descriptions, so I'm going to make a really, really good resume because it's going to get past a lot of these automated systems that kind of check. resume first and when a hiring manager sees it, they'll see the skills they're looking for, they'll see projects that are interesting and relevant to that position, so hopefully I can get an interview, the next thing I would do is work with a recruiter and this It's one of those things where most people when they're first starting out don't do this, they just start applying for jobs and using LinkedIn, you know, one-click apply. they don't work and you get really frustrated and that's because you're applying to hundreds of jobs that thousands of other people are applying for but recruiters are really great because they have a connection to the company so I would work with one recruiter or So many recruiters as I could, believe it or not, there was a time when I had no experience and this was six or seven years ago and I was working with six or seven recruiters at a time just juggling them, I kept messaging them and asking them and sending them a email.

Hello, do you have anything? Sending them a message on LinkedIn. communicating with them. and then work with a recruiter. I would start by working with a recruiter. I also have a whole video on how to communicate with recruiters on LinkedIn by messaging them directly and then finding them, calling them, and cold emailing them, so if you're interested in knowing how to do that. I would watch that video now, after working with the recruiter. The last thing I have to do to get a job is complete the interview and get a job offer. That's all. An interview is generally made up of two parts, that is the general interview and that is the technical interview.

Now the general interview is one that you will get in almost any position, so they will ask you to tell us about yourself, to tell us about your work experience. Tell us why you want this position and what you know about the company, these types of things so you can prepare for them by researching any company, researching what they do and preparing for that interview, the next part is a technical interview and you will get this probably in more than 75% of the interviews I have, if it's a more technical role it's usually in SQL or Python, in general it's usually a sequel to 95% of the technical interviews I've had throughout my career has been in SQL, so you really want to nail that technical interview to show that you know the skill well and that's why we created Analyst Builder like I was talking about a moment ago, we have that whole section where it's just practiced for technical interviews. in Python, MySQL, postrace, SQL, Microsoft SQL Server, it's super awesome just for that, so I really want to prepare for my interview.

I just practice, you know, telling about myself, I practice for technical interviews, I would nail the interview and accept the job. Since now, that's usually the longest process: working with a recruiter and getting a job because all the learning until then is self-paced, you can do it yourself for free or for very little money and then work with a recruiter and then, in fact. Getting a job that can take anywhere from 3 months to a year and therefore in the shortest time possible, if I really simplified this and really worked hard to learn those skills, working with a recruiter non-stop, I like it.

If it's my job, I think it would be very possible to do it in 6 months. It's a really optimistic time frame because 6 months to completely change your career is pretty quick, but I definitely think it's possible if you know I'd start over today. I think I could do it, of course there are external factors like the job market, if hiring is very slow or where I live or things like that, but overall I definitely think I could do it within 6 months for some of you. It seems like a long time, but to put it in perspective, you'll have this job for the next 20, 30, 40, 50 years and you'll learn new skills, get promoted, and maybe transition into data. data science or data engineering or any number of other jobs related to data analysis, so that's the exact path Amnesia Alex would take to become a data analyst as quickly as possible now, if she had a little more time, I would.

I didn't need a job, I had more time to devote. I would definitely be learning something like a cloud platform and then learning some AI as well to work with those tools. Now I didn't mention AI as something I should know because even now even today, late 2023 or early

2024

depending on when I post this, even today those tools are not fully integrated, you don't need to know about them now, in the future in 2 3 4 5 years they may be more integrated into all of our software in all of the tools that we use so it would be more of a requirement to know those things so that's exactly what I would do if you haven't already be sure to check out Analyst Builder.

I'm incredibly proud of it. one of the best platforms out there to learn about data analysis. If you like this video, be sure to like and subscribe below. See you in the next video.