- 6 hours ago
Breaking into data analytics takes more than learning a few tools—it takes a practical plan. In this CareerFoundry webinar, Alex the Analyst shares a step-by-step guide to building job-ready skills, creating projects, and moving toward your first data analyst role.
Explore why SQL, Excel, and a visualization tool such as Tableau or Power BI make a strong foundation, how to present projects in a portfolio and resume, and why networking with recruiters can complement online applications. The discussion also covers realistic timelines, career changes, and how to approach AI tools after learning the fundamentals. A useful data analytics career guide for aspiring analysts, beginners, and professionals planning a transition into tech.
Explore why SQL, Excel, and a visualization tool such as Tableau or Power BI make a strong foundation, how to present projects in a portfolio and resume, and why networking with recruiters can complement online applications. The discussion also covers realistic timelines, career changes, and how to approach AI tools after learning the fundamentals. A useful data analytics career guide for aspiring analysts, beginners, and professionals planning a transition into tech.
Category
📚
LearningTranscript
00:00:00Welcome to another Career Foundry event this evening with Alex Breberg, the ultimate data
00:00:04analytics career plan for 2023. Now I know we've got a big crowd tonight. For anyone joining on
00:00:09Big Marker, it's lovely to see where you're joining from. So just drop your name in the
00:00:14right-hand side, you know, why you're interested in data analytics and, you know, why you're
00:00:19interested in, yeah, data analytics and a career change into data analytics. We'd love to see all
00:00:23the comments. And for those watching on YouTube and Alex's crowd, we've done quite a few of these
00:00:28before. So welcome everybody. We always love your energy and engagement and do check out Alex's
00:00:34YouTube channel, Alex the Analyst. For anybody who doesn't know it, anyone watching from Career
00:00:39Foundry, let me just introduce myself. I'm William, events and communications lead here at Career
00:00:44Foundry and Career Foundry is the online school for your career change into tech. So we guide you from
00:00:49complete beginner to job ready professional in data analytics and help you land your first job in the
00:00:54field. We're not any old school. Our programs are so flexible. You don't need to quit your day job to
00:00:59change your career. You get regular one-to-one mentorship, not one, but two industry experts.
00:01:05That's a mentor and a tutor. And if you don't land a job in 180 days of graduation, we refund
00:01:12your
00:01:12tuition in full. That's our job guarantee. For anybody who's watching in YouTube and is interested
00:01:18in the Career Foundry program, just click in the description below and there is a link to book a call.
00:01:23If you want to book a call with a program advisor and ask questions about our curriculum or anything
00:01:27that we offer, I recommend doing that. Just a couple of house rules this evening. We will be
00:01:32doing a live Q&A at the end. So if anyone's got any questions for Alex, it's your time to
00:01:37get those
00:01:37questions answered. Just drop them on Big Marker or YouTube or LinkedIn. We are streaming across
00:01:43numerous platforms this evening and we'd love to get your questions answered. Alex, I think that's
00:01:49everything Senegal. It's a super international crowd and I'm going to hand it over to you. Alex,
00:01:55thanks so much for joining us again. Thank you. Thank you. I saw somebody from North Carolina,
00:01:59Jermaine. I just want to give that person a shout out. That's where I grew up. So I grew up
00:02:03in North
00:02:04Carolina. I love seeing when people put where they're from because it's like, it's pretty wild.
00:02:09I mean, we got people from Guatemala, London, Bromwich in the UK. Just amazing. Thank you guys so much
00:02:15for joining. Thank you guys for hosting this. Career Foundry, huge shout out. I love this topic.
00:02:23It really has a special place in my heart because I remember six years ago. Let me see. Yeah, six
00:02:30years ago now. Wow. In 2017, when I was trying to make this transition into becoming a data analyst,
00:02:37I had absolutely no idea what I was doing. There are now a lot of resources online, on YouTube and
00:02:44like, you know, posts and blogs and whatnot centered around how to break into analytics and TikToks and
00:02:49things like that, that I don't do. But there's a lot of resources now. And when I was first starting
00:02:54out, there was like, there was not many resources, which, you know, as, as a lot of you guys know,
00:02:58that's kind of why I started my channel. And so we're going to talk all about breaking into data
00:03:04analytics. I have a kind of a step-by-step playbook on what we're going to be doing. And we
00:03:09have a lot to
00:03:10cover. I always like doing the Q&A at the end. So I'm going to try to, you know, not,
00:03:15I could talk
00:03:15for hours. I, if you guys know me, I could literally talk for like three or four hours on
00:03:19this, but I'll try to keep it succinct. And we'll make sure we cover every step. Let me see what
00:03:24this
00:03:24next one is. Oh yeah, that's me. We don't need to read this, but I like data analytics. So let's
00:03:31jump
00:03:31right into it. So we're going to start about, we're going to just start with kind of creating a career
00:03:37plan because you have to start somewhere. You kind of have to create a plan. What I like to do
00:03:43with people, cause I do, I had a mentorship program for a long time before I started my analytics
00:03:47consulting company. And what I would always tell people, I'm like, you can be any step in this
00:03:53process. You can be anywhere. You could be at the very beginning and have never even heard about what
00:03:59data analytics is. And you're trying to, you know, you want to join this path, or you could have
00:04:03already learned all the hard skills and now you're trying to get a job. So you can really apply
00:04:07this anywhere. So I kind of am going to start from the very beginning, but you know, realize
00:04:12where you're at and what you need to do. Hopefully that's really helpful to you. So yeah, here's
00:04:19what we're going to do. Identify where you're at in the process, create an action plan. And then at the
00:04:23very end, I'll talk about timeframes on how long you should try to, or how long it might take you
00:04:28for
00:04:29each of these steps. So let's go on over to the first one. The very first thing that I always
00:04:34recommend people doing is learning the skills. It's really, really hard to become a data analyst
00:04:40if you don't have the data analytics skills. It's really tough. These are the skills that I
00:04:47recommend people starting with. Now, as you're reading through it, as you're looking at it,
00:04:52you don't have to learn all of them. That is not a requirement. And in fact, I don't recommend you
00:04:57try
00:04:57to learn all of them because that just would take forever. Really what I would start with,
00:05:02I would really recommend starting with SQL. I just think it's so fundamental. It's where data is going
00:05:07to be stored. It's in some type of database and you can query the data. Always recommend you start
00:05:11with SQL. Learn things like Excel and a Power BI tool as well, like Power BI or Tableau. So these
00:05:19BI
00:05:20tools are meant to just visualize the data. So with SQL, Excel, and something like a BI tool, you can
00:05:27go a
00:05:27long, long way. In fact, when I got my very first job as a data analyst, I only knew SQL.
00:05:33That's
00:05:33really all I knew. I learned on the job a lot of the stuff I know in Excel now, a
00:05:40lot of the Tableau
00:05:40that I know. And then in my next job, I learned cloud platforms like Azure and I learned Python.
00:05:47So I didn't learn all these things at the beginning. I kind of taught myself over the years
00:05:51as they became more relevant in my job. The last thing on this list is chat, GBT, and AI tools.
00:05:58And I want to take a quick second just to highlight this one because, you know, these AI tools aren't
00:06:03going away. They're speeding up a lot of these things. They're making them a lot faster to use.
00:06:08So take, for example, something like Tableau. Tableau just had a conference. They announced that
00:06:14they're going to be integrating AI into Tableau. And this is going to be a huge part of analytics in
00:06:21the future. Just having these AI tools integrated into these different types of systems. Here's what
00:06:28I will say. I don't recommend diving right into AI immediately. Although it's on this list, I highly
00:06:35recommend learning the basics first. Learn the basics of SQL. Learn the basis of Tableau, Power BI,
00:06:41Excel. Learn the basics because what's going to happen is these AI tools are going to go from zero to
00:06:45100 really quick, right? And if you don't know what you're doing, if you don't know what it's telling you,
00:06:51it's going to be really hard to actually put everything together and do what a data analyst does.
00:06:55So you want to learn the basics first, then start using the AI tools. And you can even use some
00:07:00of
00:07:00these AI tools to teach you. Like ChatGPT can be a really good mentor. So that's the first thing that
00:07:07you should be doing, learning the skills. The next thing, learn these skills. Because I can just say go
00:07:13learn the skills, but, you know, it doesn't really help if I don't tell you where to go. So let's
00:07:17take a
00:07:18look at this. The first one is self-learning. So you can do this on a lot of different platforms.
00:07:23Ones like YouTube, or I teach data analytics. You can learn from ChatGPT, Khan Academy,
00:07:29and a few others. You can do paid courses. So typically what I talk about is places like Udemy
00:07:35or Coursera, where you can go and buy a course or buy a subscription. And you can actually take it
00:07:41as
00:07:41you go. You can kind of self-pace within a customized course. Then there's like boot camps
00:07:48and online schools. Now, this is where something like Career Foundry falls into place, where you're
00:07:54going to pay for a boot camp. And what I always tell people on this is I always recommend somebody
00:08:00finding one that has a job guarantee, like Career Foundry. I, you know, I don't take sponsors
00:08:07very easily. I have a very specific process that I go through. Career Foundry is one of the very few
00:08:13that I like just because it's a good price and, you know, they also have a job guarantee. So some
00:08:18of these other ones look into them, but there's a lot of boot camps, a lot of online schools that
00:08:23you can look at, but just make sure that they have good mentors because that's really what you're
00:08:28paying for and that they have a job guarantee. That's something you need to look for. And then the
00:08:32next thing is getting a university degree. Now, this one is by far the biggest investment in
00:08:36both time and money, but can have a big payoff because you're getting more accredited. You know,
00:08:44you're taking a long time to get your education. But here's what I will say. And I kind of been
00:08:50thinking about this a lot over the past several months, you know, in three, four, five years,
00:08:55will university degrees be caught up with a lot of these new AI tools and advancements that are
00:09:01happening in analytics right now? Probably not. And you may get a degree and you may
00:09:06not be as job ready as some of these other ones. Like if you took self-learning or a paid
00:09:12course or a
00:09:13bootcamp, that's kind of has newer information. You really need to look into those things because
00:09:17that is a problem with the higher education as a whole at the moment is they kind of tend to
00:09:23fall
00:09:23behind. So those are your options for where to learn. After you, and this one, I'm going to preface
00:09:33why. Um, and building projects is so important. Now, what does it mean to actually build a project?
00:09:40Building a project just means, you know, as a data analyst, you work with data, but you have to make
00:09:45insights out of it. You have to make it actionable. So you're taking this data and then you're saying to
00:09:50a stakeholder or an employee or your boss or whatever, you're saying, Hey, here's what you should
00:09:54do based off the data. And that's what building projects is. It's basically giving you, um, some
00:10:02experience without actually having experience. So you're, you're practicing these data analytics
00:10:08skills that you just learned. And now you're building projects. Now, why do you need to build
00:10:12a project? There's three different reasons. Uh, first you'll just get better at the scale. You
00:10:17troubleshoot things, you run into issues and you figure it out. And then you work through it and
00:10:21you're like, man, I am better because I, you know, built this project. The next one is to
00:10:26showcase your skills to potential employers. Now this number two and number three, because if you
00:10:32look at number three, it says you'll have something to talk about during your interviews. So it has two
00:10:37different pieces. One projects are really great to place on your resume to help you get into an
00:10:42interview because it can show that you're working on these things. You can show the tools that you're
00:10:46using. Um, and it honestly, I've seen a lot of, uh, resumes in my day back when I was an
00:10:52analytics
00:10:53manager where I was like, man, this is a really interesting project. And I went onto their portfolio
00:10:58website and I checked it out. I'm like, this is really good. The next thing is, is especially if
00:11:02you don't have any experience, what's going to happen when you get asked something like, uh, you know,
00:11:07tell us how, you know, SQL, that's a tough question to answer. Um, when you're first starting out,
00:11:12it was tough for me. Uh, so, you know, I would, I would be like, well, you know, I've,
00:11:16been practicing and I took a course and, um, you know, I think I'm, I think I'm good enough in
00:11:21SQL. And they're like, that's a terrible answer. Um, and it was, but what I learned is when I
00:11:27started building these projects, I could say, you know, they'll ask me the same question,
00:11:31you know, how, what do you know about SQL? And I'll say, well, I, you know, I, I know how
00:11:35to do
00:11:35joins and window functions and all these things. And I just built a project taking this data set.
00:11:39Um, and I built this project and I can walk through and I can point to that as some experience
00:11:44as I built
00:11:46it from data, uh, using real data. And I built this project. So that's the kind of the three
00:11:50reasons why I recommend somebody build a project and then put it into a website, uh, which is really
00:11:56good as well. So this is the, uh, portfolio website that I was talking about. So once you built a
00:12:04project, that's fantastic, but it doesn't help if you don't put it somewhere. So what you need to do
00:12:10is you need to take projects multiple and you need to place them somewhere. You can do that for
00:12:16free on a lot of different places. I have a whole video on how you can put it up on
00:12:19GitHub. So you
00:12:20can do that. You can put it up on Wix, on Kaggle, Medium, LinkedIn. These are all places you can
00:12:25place
00:12:25your projects. And LinkedIn even has a place where you can go onto your homepage and you can add projects
00:12:31to your profile. So when a potential employer or a recruiter goes onto your LinkedIn, they can see
00:12:37those projects really, really great. Uh, and I'm a huge fan of LinkedIn. So, um, I definitely recommend
00:12:43that. The next thing you need to do is build a resume. Now, um, building a resume is always difficult
00:12:52and give me one second while I take a sip. I woke up with a sore throat, so I apologize.
00:13:00Uh, building a resume is always difficult. I have found it probably one of the most, uh, frustrating
00:13:05things about just work in general is you have to apply to a job and you have to have a
00:13:09resume.
00:13:10Um, and resumes are extremely tough when you have no experience because then you have like half a
00:13:17page filled up and you're like, I can't send this like this, this looks bad. So you need to kind
00:13:23of
00:13:23fill that out and you also need to make it a data analyst focused resume. Now, how do you do
00:13:28that?
00:13:29Um, the first thing that you need to do is highlight your skills. So highlighting your skills means
00:13:35you want to put SQL, Excel, Tableau, Python, whatever skills you have on your resume a lot.
00:13:42And you want that up at the top, especially if you don't have any experience. Like I have a degree
00:13:47in recreational therapy, so I don't want to put my recreational therapy degree at the top
00:13:51because then they're going to see that and they're going to be like, this degree is worthless,
00:13:56which for this field, it kind of is. Um, so I put that at the very bottom and I just
00:14:01call it a
00:14:01bachelor's of science. I don't even say that it's a recreational therapy. It's just kind of a
00:14:05healthcare degree. Um, but I put my skills at the top and then I have, um, if you have experience,
00:14:11you put experience, then you put, um, at the next level, you can put your projects. So this is
00:14:16another place where your projects are going to come in handy. So you can have your projects in two
00:14:21different areas. And I want to just highlight this because I'm a big, big, big believer in it.
00:14:25Your projects can be an actual section where you say, here's what I did. And then underneath it,
00:14:30you have bullet points of here's the tools I used and here's the analysis that, uh, or the insights
00:14:35that I got out of it. You can also put in your header, a link to your portfolio website. Highly
00:14:41recommend this because then an employer can go and look at your actual code that you're writing or
00:14:46your visualizations that you're creating. They can go and actually look at it. So it's pretty
00:14:49awesome. Um, so those are two different ways. Um, another thing that I want to mention is if
00:14:55you're coming from a different field, so let's say you're a nurse or you're an accountant or
00:14:59it could be anything, a teacher is really helpful. If you're able to repurpose your, uh, experience
00:15:08to be more data analytics focused. Now, what do I mean by this? Uh, I've worked with a lot of,
00:15:14cause I came from healthcare. So I worked in healthcare for a long time. Then I became a data
00:15:18analyst. So what I did when I was first starting out and I kind of learned this over the years
00:15:23is
00:15:23that I actually, that's actually valuable experience. I didn't know it at first. I thought
00:15:28it was pretty useless. Um, but that was actually really valuable. And so what I started doing was,
00:15:33is, you know, I've worked with, um, what are those called? HRI? No, uh, healthcare database systems.
00:15:40Uh, they're called something as I can't think of it off the top of my head, but I would say
00:15:44I have
00:15:44experience with these databases on the, you know, healthcare side. So then when I come in and I'm
00:15:50working as a data analyst on the backend, I can say, I already have experience with those systems.
00:15:54I know how to use them. And that's really, really, uh, useful information. So you can do that with a
00:15:59lot of different things. You usually have to sit down and think, how is this relevant data analytics?
00:16:05And then try to use that. It can be tough for some jobs legitimately. Um, but a lot of jobs,
00:16:10you, there is some trends now let's go on to the next one, which is certifications. Um,
00:16:16I'm going to mention certifications and I put this as an optional one here, and I just want to touch
00:16:21on
00:16:21it. I personally, uh, I have no certifications, uh, or no certifications that I talk about because
00:16:28I don't think they're 100% relevant or I've ever helped me land a job. So I've taken, uh, the
00:16:34Microsoft power BI data analyst certification. That's one that I actually took when I was in my job,
00:16:40my job paid for that certification. I don't put it on my resume, uh, because I don't think it's,
00:16:46it was that helpful back three years ago when I was, um, just like a data analyst. I didn't think
00:16:51it was that exceptionally helpful in helping me find a job, but some of you guys may really want
00:16:56certifications. It helps, uh, could potentially help build a little bit of credibility. Uh, you have
00:17:01an actual certification. I just, I'm not a huge proponent of it. So if you like it, go for it.
00:17:07You can get
00:17:07that certification. If not, you know, it's not, um, a big one, but these are three of the ones that
00:17:12I
00:17:12think are actually useful or actually worth getting. Although there are thousands of certifications
00:17:17out there, they're just not all really that great. Um, so, you know, take it with, uh, take it with
00:17:24a
00:17:25grain of salt. The next one, uh, step number five is to start applying. And this is a very difficult
00:17:31part. Um, when I first started, when I was, when I was trying to get my very first data analyst
00:17:37job,
00:17:37I can't remember the exact number, but it was over a thousand jobs I applied for.
00:17:41Um, and I was doing that mostly on zip recruiter. I'm trying to zip recruiter and LinkedIn, I think
00:17:48is mostly where I applied. Um, and I applied to over a thousand jobs. I think it was like 1200
00:17:53and I got callbacks for 20 of them and I got offered a job on one of them. Um, and
00:18:00that was
00:18:02a process. I had a whole spreadsheet. It was, um, it was a very dark time in my life. Very,
00:18:08just very disappointing. If I might say, because it took months and months and months to get there.
00:18:13Now there's a better way to do this. Uh, don't be like younger me who did it the worst way
00:18:19possible.
00:18:20And I'm sure a lot of, that's what a lot of people do because it's very inefficient. Um,
00:18:24most of these job, uh, websites where you're just applying and applying and applying,
00:18:29they get thousands of entries. Some, they don't even look at it. Some, they just automatically
00:18:32scan your resume and you're like, no, don't have the experience. They get tossed out.
00:18:36So it's very, very tough to get a job with no experience or, you know, um, if you're transitioning
00:18:42from a different career, very tough. Here's how I would do it. If I were you, um, the first thing
00:18:47that I
00:18:48would do is always work with a recruiter. Now recruiters are interesting because most of the
00:18:55time they're working in metropolitan areas. They're not going to be working a lot in these
00:19:00rural areas or it's like farm country, uh, which is, you know, kind of where I grew up in Minnesota,
00:19:06like near the, in the middle of nowhere, you know, you're not going to find a lot of jobs there.
00:19:10Um, you can now find remote jobs, which is great, but even then a lot of these jobs want you
00:19:17to be,
00:19:18you know, somewhere near a metropolitan area. So if you don't want to do that, uh, or if you don't,
00:19:24um, if you want to stay where you are, you can look for remote jobs. And there's a lot of
00:19:29companies
00:19:29out there that you can look for online. Just search, you know, remote recruiters for tech.
00:19:34And what you need to do is you need to get on their radar. You need to talk with them.
00:19:39You need to
00:19:39hunt them down and you need to find them. Now I'm going to tell you what I did. Uh, when
00:19:43I first
00:19:44found this life hack, which is called recruiters, um, I went and worked with every recruiter who would
00:19:50work with me at the peak of working with recruiters. Um, after my first job, I had a year experience
00:19:55after that first job, I was working with about seven or eight recruiters and all of them. I was
00:20:00messaging every single week, every single one of them. I was calling once a week just to see if there
00:20:05were any open jobs. I was a bit relentless, um, because I knew they weren't going to do it for
00:20:12me. I had to do it myself. I couldn't rely on them to just message me out of the blue
00:20:16with a job offer.
00:20:17It's just doesn't happen. So I took it upon myself that you don't have to be like me. Although I
00:20:22kind
00:20:22of think that's, it's a very efficient way to be on people's radar consistently and get new job
00:20:30updates when a new job is available. So, um, and if you don't know what a recruiter is, I'm going
00:20:36to
00:20:36break it down super quick. A recruiter is usually somebody who's paid for by a company. So let me
00:20:41see where I am on my camera. So here's the company. They pay this recruiter to go find an applicant.
00:20:46Now this recruiter just works with the company. They usually don't work or they're not inside of
00:20:51the company. They're not part of that company. They're just a third party, um, a third party.
00:20:55Now they're going to come to you and they're going to say, Hey, we have this job at this company
00:20:59for an entry-level data analyst position. Uh, would you be interested? And you're like,
00:21:03yes, of course I'd be interested. So you go and apply and they pay you, let's say $50,000.
00:21:08The recruiter is not going to take any of your money. The company is going to pay the recruiter,
00:21:12let's say 10% or 5% of your salary. It's just a lump sum saying, Hey, thanks for getting
00:21:17us,
00:21:17uh, an employee that we needed. We don't have to do that. Uh, and that's what a recruiter is.
00:21:22You can cold email and you can cold call as many recruiters as you possibly can.
00:21:28I recommend doing that. I think that's even more efficient than just blindly applying on LinkedIn
00:21:34and zip recruiter. Um, another thing you can do, and this is kind of that second life hack that I
00:21:40found later on, uh, maybe like two to three years ago, which is using LinkedIn. LinkedIn has been like,
00:21:48it is one of the best tools for job searchers. Uh, is that the right word? Job searches people who
00:21:54are
00:21:54searching for jobs. It is one of the best tools because you can go and you can find recruiters
00:21:59through LinkedIn by just searching for recruiters at this company. Um, and I actually have a whole
00:22:03video on how to do that. It's, it is amazing because you can search any company. I can go
00:22:07on Amazon right now and I can find 10 recruiters who work at Amazon. I could send them a personal
00:22:12message with my resume attached. I can say, Hey, I saw this specific job and you put the job in
00:22:18there,
00:22:18say, Hey, I found this job. I think I'm a really good fit. Here's my resume. You know, let me
00:22:23know.
00:22:23Um, and you can do that with hundreds of recruiters online. It's, it is incredible. The access that you
00:22:29have to recruiters. So all of those things are what I would be doing supplementing, also applying
00:22:36on LinkedIn and zip recruiter and those other websites. I just would not only be doing that
00:22:40because it's, it's, it's a tough path to go down. All right, let's go to the next step.
00:22:46Uh, now we're going to look at timeframes and give me one more second.
00:22:55So timeframes are really important because you don't want to be doing this process. All the
00:22:59things that we just discussed for the next two years, that's a really long time. Most of the time
00:23:04you're looking, you're hoping to do this within three to six months. Um, and that sounds like a
00:23:08long time, but if you really think about it, you know, I've been in this field for six years now
00:23:14and
00:23:14it has paid off really well. Like it's just taken me into a lot of places even before the YouTube
00:23:19stuff. Um, and so, you know, long-term you got to think six months of my life, you know, really
00:23:25doing these things to get to where I want to be for the rest of my life. So there's, there's,
00:23:29you know, a big, it's a big payoff. The first thing is learning the skills. I think it's going
00:23:34to take the longest, um, or most likely will take the longest for most people. Um, if you just focus
00:23:40on the ones that we talked about, like SQL, Excel, and a visualization tool, and you're
00:23:44starting from absolute scratch, like, you know, nothing, um, which I've been there. It's tough.
00:23:49That can take you about two to three months. It's a really good, a good handle on it. There's lots
00:23:54of courses and practice, uh, websites that you can use. You know, those are great places to look
00:24:00and to go, um, use and utilize. If you're trying to learn all of those skills that can take you
00:24:04like
00:24:05six months. Uh, if you're trying to learn Python or, um, or if you're trying to, you know,
00:24:09really learn how to use chat GPT or some like an AI tool, those things can take you all to
00:24:13really
00:24:14get good at. Um, so, you know, be easy on yourself, but right around three months or so to learn
00:24:19all
00:24:20the skills, um, and start applying. The next thing is building projects. I don't think you need to
00:24:26spend two, three months building projects. Most people can do a project a week. I usually recommend
00:24:31at least having three projects. Five is perfect. So if you can do one project a week, um, and they
00:24:38don't have to be, when you're first starting out, they don't have to be complex. Keep it simple.
00:24:42I have lots of guided projects on, on my channel. You can just watch a guided project and put that
00:24:47on. Um, it doesn't have to be like a senior level analyst worthy project. It just doesn't.
00:24:54Um, so keep it simple, keep it, um, you know, keep it small and then you can build from there.
00:24:59So, you know, that should take about three to six weeks, one week for three to five projects,
00:25:03about three to six weeks. Next, we have building a portfolio. And really what I mean by that is just
00:25:09taking all your projects, getting into one place, making it look really nice, having a website.
00:25:14Um, if you've never done it before, it's, it can be tough. So, you know, just find a tutorial,
00:25:19find somewhere where you can build that and then build that out. It should take about one to two
00:25:23weeks. Then the next thing we have is building a resume. Hopefully this won't take too long.
00:25:28You don't have to start from scratch. Just take your current resume and kind of revamp it,
00:25:32rework it for data analytics. You should be able to get that done in about a week, but two weeks
00:25:37kind of at the most, if you know, resumes are not your thing. The last piece is job hunting and
00:25:43job hunting is like a huge variable. It could, I've seen people, uh, and I've worked with people
00:25:48who have literally gotten a job within the first month. Um, you know, they learned, they did all
00:25:52the things that I, that I told them to do. And then they started applying and within a month,
00:25:56they got a job. It happens, but it's not super, it doesn't happen all the time. That's super,
00:26:00um, common. Usually I'm seeing about three months to land a job. Now I put one to six months because
00:26:07sometimes it takes people six months, sometimes even longer, depends on where you are. If you're
00:26:11in the middle of nowhere and you're looking at very specific jobs, um, only remote, you know,
00:26:17has to be, uh, within this pay range, you know, very specific, uh, jobs that you're applying for.
00:26:22It's going to take longer, but if you're open to relocating, if you're open, uh, to taking positions
00:26:28that don't pay as much right away to get some experience, um, which sometimes you may have
00:26:33to do, you know, you can get a job a lot faster. So, you know, there's a lot of different
00:26:37variables.
00:26:38And sometimes like I lived in Dallas, which was really beneficial for me getting some of
00:26:42my first jobs because there's a huge hub of companies and, and need for data professionals
00:26:48there. So I was in a good location to be able to get that job. If I was in the
00:26:54middle of nowhere
00:26:54today, I think it'd be a quite a bit more difficult to land that first job.
00:27:00All right, let's go to the next one. Uh, and that's actually it. Um, so I'm going to get,
00:27:05uh, will back in here, uh, in just a second and I'm sure he's coming, but, um, I know that
00:27:12I just
00:27:12kind of, I went through that quick, but you guys can ask me any questions that you possibly could
00:27:16think of and want to know. And I will at least have some answer may not be a good one,
00:27:20but I'll have
00:27:21an answer. Thanks Alex so much for presenting, um, this evening. Let's just clear back to this slide.
00:27:29Um, yeah, I think just to start it off, I know a lot of people watching this evening are thinking
00:27:34about taking their first steps in the, uh, in the industry, uh, you know, junior, uh, data analyst
00:27:39positions. Um, you know, how do you think that the industry has changed in the past six years since
00:27:44you've been working in the industry? That's a good question. You know, I'd like to start it off
00:27:51with a, you know, one of the meteor questions. Yeah, that's, um, that's a great question. This
00:27:56changed a lot. Uh, you know, I started, uh, six, seven years ago. It was very different. Um, it wasn't
00:28:04as remote focused. Um, I think it was a somewhat lower, uh, barrier of entry right now, um, is a
00:28:13really
00:28:13interesting time to be getting in because, um, you know, we've seen some layoffs, um, at big tech
00:28:19companies, but what I will say, um, is that as a whole overall, the job hiring hasn't slowed down
00:28:28that much except that some of these big tech companies, which is not where most data analysts
00:28:33work. Um, most data analysts work at a lot of fortune 500 companies, midsize companies, even small
00:28:38companies. That's where I started. Um, and that's where 90% of data analysts work. They don't work at the
00:28:43big tech companies. Um, so the, I think, uh, for a lot of junior people, if they're starting out now,
00:28:50the difference between when I started and now is that it's just more competitive. There's more
00:28:54remote people trying to get jobs. Um, whereas back when I first started, there wasn't as
00:28:59big of push for remote work. And so, um, there's just a little bit more competition at the entry level
00:29:05because of every, a lot of people just want to work remote. Um, and so if you are in person,
00:29:11if you are in those metropolitan areas, I think you even have a bigger leg up, um, and getting
00:29:15those jobs cause you're in person and where, or you could work remote. So you have that flexibility.
00:29:20So you can really work, um, you know, where they need you, which a lot of companies like.
00:29:26Awesome. And I want to also go back to the portfolio. One more question from my side,
00:29:30um, talk about portfolios. Um, if, if a portfolio lands on your table for junior position,
00:29:35what excites you most when you see that portfolio land on your table? What do you like to see?
00:29:40Yeah. So I, I've worked with, um, a lot of entry level people, like I was a analytics manager.
00:29:45So like when, um, we were hiring, um, and I had a lot of consultants and a few full-time
00:29:50employees,
00:29:50but, um, when I would see one, I look at their portfolio, not a ton had it on there. Um,
00:29:57which
00:29:58I prefer them. Some people don't care. Some people really care. Um, I just prefer them. I,
00:30:03I would hope they have them. Um, I remember specifically, there were a few that came across,
00:30:08uh, uh, you know, my table where I'm like, this is a really interesting project. I go on their
00:30:13website. I look at this project. I'm like, I have never seen a project like this before.
00:30:18Like it's just really unique on some niche topic. I thought those were super interesting
00:30:22because it showed passion. Um, it showed like a curiosity for just diving into data. Um,
00:30:28and so, you know, I would see ones on like fantasy football and like this, I remember this guy
00:30:32specifically because we ended up hiring him. He had a, this really in-depth portfolio on fantasy
00:30:37football stats. Um, and like part of his, um, process, it was all in Python. So part of his
00:30:44process was also determining the best position for fantasy football drafts, um, which positions to take
00:30:49first based off different factors, all, you know, data analysts, uh, uh, using data analyst tools and
00:30:55stuff. It was just really interesting. I love that. I thought it was super cool.
00:30:59It's actually interesting. You said that because we also, um, in previous career foundry events,
00:31:03we've had it in the past where a student has taken a career foundry project and actually
00:31:07changed it and done their own thing. And then they've landed a job from that. So I think that's
00:31:11great advice too. Um, this is the time to get your questions answered for those watching on Big
00:31:16Marker, LinkedIn, YouTube. I'm going to jump in. Apologies if I pronounce anyone's names wrong.
00:31:21That's not intentional. I think Mia's got a great question over in Big Marker. Um, Alex,
00:31:25any insight into how AI might affect this industry in the next few years?
00:31:31Yes. Um, I just, so I'm a lot of what I'm going to say, I have a, I just released
00:31:37a video yesterday.
00:31:38That's like an hour and 15 minutes on this exact topic. Um, and it goes really in depth, but here's,
00:31:43I'm going to give you the cliff notes of it. I think that AI has a massive potential somewhat,
00:31:50not unlimited, but a massive potential to transform the analytics and just data industry in general.
00:31:56Um, for job seekers, like you and I, who are working as data analysts who want to get into data
00:32:03analytics, some of the potential concerns that I've seen are things like it's really good at automating
00:32:10things. It can work at a really fast pace, like a thousand times faster than a data analyst. And it's
00:32:16very cheap. Those are three things that I'm, I think I'm most concerned about. Here's what I'm
00:32:25not concerned about. Here are the things that I think are positive for people like you and I trying to
00:32:29get a job. Um, I think that AI still makes a lot of mistakes. It's getting better. Um, but those
00:32:36hallucinations are very real and you, I wouldn't cause I've been a manager myself, right? So I'm putting
00:32:44myself in like a business mindset. I would not want to blindly trust anything that AI is telling me
00:32:51ever. I am almost never going to blindly trust it. I'm going to need somebody to dig into the data,
00:32:57make sure that what they're giving me is correct. Go back, look at the code, make sure the code is
00:33:01correct. The data cleaning process, you know, the whole spectrum. That is a, that's a, one of the bigger
00:33:07pieces that I would say is, um, makes data analysts extremely useful and very relevant is that as a
00:33:14business owner, I don't, I, I could not put multimillion dollar projects, which is what I
00:33:19would work. I work on a million or $2 million project. I'm not trusting AI to do that. Not
00:33:24right now. Um, and probably not for the foreseeable future. The next thing, um, that I think is,
00:33:31am I, am I talking too much or I need to stop? No, it's great. I think this is great.
00:33:35I think
00:33:35because I mean, AI is the buzzword at the moment. So I think please elaborate on this, this topic.
00:33:40All right. I talked about it for an hour and 15 before I could, I could talk longer than that.
00:33:44I, so I don't want to, um, I'm going to try to, I'll try to keep it more concise than
00:33:48I
00:33:49think I was going to be. Um, the other piece is that you have to think about most businesses
00:33:53and companies integrating AI into their, into their, uh, world. Um, when I was managing a team of six,
00:34:02seven people and you know, I'm, I'm thinking about AI, how I would have integrated it. Cause it really
00:34:08wasn't a big thing when I was a manager. I, I would take a lot of precautions because you know,
00:34:14I,
00:34:15we had a lot of important data that made important decisions. And so I would be very careful with
00:34:21implementing it. Um, and that could be a year long plus process. So I think just in terms of
00:34:27actually getting it into a lot of workplaces at a, at a company level is going to take a long
00:34:32time.
00:34:32I think chat GPT has done a pretty good job of integrating at a personal level to speed up
00:34:38workflows, but integrating these AI tools into an actual business is I think going to be a lot more
00:34:44complicated than I think people understand. Um, especially if you're not a data person, right?
00:34:50If you don't understand how these tools work, how the data flows, the data infrastructure, um,
00:34:55all the nuances of the data, and you just try to plug and play, like, I don't see it working,
00:35:00uh, well.
00:35:00Um, and so I think those are all, those are some of the bigger things that I think, um, is
00:35:06going to
00:35:06keep a lot of data analysts very busy. Some of my predictions for the future of AI, I think
00:35:13freelancing in AI, uh, freelancing as a data analyst is going to become really big. Um, and I, I said
00:35:20that,
00:35:20and then a day later, Tina Huang, if you know her, she's a data scientist, YouTuber made almost the
00:35:25exact same prediction. I messaged her. I said, Hey, you just made like the same prediction. I did.
00:35:29She's like, I recorded that video a week ago. We had no idea, but we had the exact same prediction,
00:35:34which is a lot of smaller companies are going to need to start using these AI tools. And they
00:35:41do not have the data infrastructure built up. They do not know how to use AI tools. There's
00:35:45some Joe Schmo in a business and they're like, I need to use this to stay afloat. So I think
00:35:49freelancing as a data analyst and knowing how to use these AI tools is going to be a huge business.
00:35:54You'll see a lot of things like Fiverr and Upwork or small little niche businesses like mine pop up
00:36:01and people are just going to, you know, start their own businesses. So I think freelancing is
00:36:05going to be a big thing. Um, because a lot of small companies that have never used this stuff
00:36:10are going to want to use it. I'm a lot like hundreds of thousands of companies, um, you know,
00:36:16around the world are going to start having to use these to keep up with the pace. So that's one
00:36:21of
00:36:21my predictions. Um, another one of my predictions and, uh, let me look at this real quick because
00:36:27I have it pulled up in front of me real quick. Um, so data freelancing, I think, um, this was
00:36:34another interesting one that I had thought about, um, that I don't, I don't know if anyone else is
00:36:39talking about it, but I think it's cool. Um, I think that as AI tools get into different
00:36:46departments within a company, you'll see more nuanced data professionals, something that a
00:36:52data analyst would do, except now it's nuanced into that specific department, whereas they
00:36:57wouldn't have had that before. So something like I, I wrote this down. I, you know,
00:37:02sounds kind of weird, but it's something like, uh, an HR AI analyst or an HR AI specialist,
00:37:09something that may not even have the word analyst in it, but it does that similar work where you're
00:37:13taking HR data and you're finding insights where they may never have done that before,
00:37:17but now they feel like, you know, we need to get into this. Um, so you'll see,
00:37:21I think you'll see a lot of that popping up in within companies, a lot more data centric AI
00:37:28people. So, um, that's, that's one of my predictions is that the data analyst title is going to change
00:37:35over the next five years. Um, it's going, you're going to see more AI analyst. You're going to see more
00:37:41data analyst using AI. You're going to see people like, um, like AI professional or AI, um,
00:37:49AI data. I wrote it down the other day, but you're going to see a change in the job titles
00:37:53as these tools get integrated. Um, and I think they'll come slowly. I actually don't think it's
00:37:59going to happen like super quick. You'll see like one or two pop up every so often, but I think
00:38:03in
00:38:03five years, it'll be a pretty good mix of just a data analyst, business analyst, you know,
00:38:09a marketing analyst, and then like data AI analyst too. You need to know how to use this AI tool
00:38:14or,
00:38:15or know how to use these types of AI tools to work at that position.
00:38:20I'm just predicting AI, Alex, the analyst popping up on the YouTube as a
00:38:25we'll see, but there was one interesting point I think you made there on the, having the expertise
00:38:31before. And this is something which has come up in some skills workshops that we've done too,
00:38:35is that for instance, I could write something in chat GPT, you know, what is nuclear fusion?
00:38:39What is this? What is that? And you know, with, for me with no experience, it does look, it looks
00:38:45right, but you need to have the expertise in the field to be able to reflect on actually what the
00:38:49answer is and you know, what's, what's the truth and what's not the truth. So I think, I think you
00:38:54pulled up a really important point there is that actually need to be a little bit of a level ahead
00:38:58to see what's wrong and what's right. Let me touch on that actually. Because what's really
00:39:05interesting is right now you see people like developers who are using chat GPT to build products.
00:39:11It's super interesting. I've been seeing it everywhere. Everyone's like, I could be a dev
00:39:15tomorrow. And they're not that wrong. And here's why. Because you can ask chat GPT to build something,
00:39:21you can plug it in to whatever ID you're using. And you just need some base knowledge of how to
00:39:26use that.
00:39:26And it can, you can visually see that your product is working. Now, if you want to go further and
00:39:32you
00:39:32want to make alterations and get, you know, at a backend database and do all these other things,
00:39:36you have to know what you're doing. Right. But at an entry level or not even entry level,
00:39:41but at a very base level, a lot of people can plug and play and build something like a dev.
00:39:47But once
00:39:49you start getting to the more complex stuff, chat GPT can only kind of recommend things. It can only help
00:39:54you. It can't build that database for you and connect it to your, um, to your front end and
00:40:00build all the UI and it just can't do that stuff yet. Um, maybe it will in the future. Analytics
00:40:05is
00:40:05going to be very similar, uh, in the fact that you can build something, but something that's different
00:40:11than even dev work is that devs can see it. They can visually see this is correct. It is working.
00:40:17Analytics is very, in my opinion, is a little bit more nuanced because, um, there's a lot of
00:40:22different business use cases. So we're going to see people will be able to generate a lot of stuff,
00:40:27but is it right? That's when you need somebody who knows how to dig into the data, be able to
00:40:32use chat GPT and these different tools to validate that these things are actually working and are
00:40:37correct. And they're not just giving me some random information that makes no sense and doesn't
00:40:41help the business at all. So, um, yeah, there's, there's going to be a lot of that going on. It's,
00:40:46um, but yes, knowing the base tools, how they work, how analytics works, um, understanding that process
00:40:54is going to still going to be extremely important to know how to do. And especially at the mid-level,
00:40:59senior level, it's going to be, you have to know those things. You can't just rely on chat GPT
00:41:03or an AI tool. And if that's not inspiration to, to learn, uh, data analytics, I don't know
00:41:09what is. Um, so Alex, um, you're fully in belief that, um, it's a future-proof career then.
00:41:15Um, I don't want to, uh, you know, I don't want to make that claim. I don't think it's future
00:41:19-proof
00:41:19in, in very nuanced areas. I think that there are some data analyst jobs out there
00:41:25that should have been automated a long time ago, um, that are just super simple. They didn't
00:41:30need to be a data analyst job in the first place. There's tools that 10, 5, 10 years ago that
00:41:34could
00:41:34have automated that away. Um, so I think in the broad spectrum of data analyst jobs, very realistically,
00:41:42I would say there's probably 5 to 10% that have a high likelihood of, um, being automated in like
00:41:4810
00:41:49years, um, where an AI tool will do most of it. They'll just need somebody to kind of maintain it.
00:41:55I think that 80%, 90% plus is still going to require data analysts to be hands-on, um, doing
00:42:04this work just because there's so, I, I, I just, with my domain knowledge and my industry knowledge
00:42:10that I've worked for the past seven years, uh, hands-on, I could not imagine any business like
00:42:17my, my old company is called AmerisourceBergen. My old company, if they tried to implement AI right now
00:42:22and do that, it would be an absolute disaster. I could only imagine how much money we would lose
00:42:29from all this business that we were, we were working with using AI and making a mistake and
00:42:35letting and trusting it. Like I just, it would be, it would be a horrible move. So integrating those
00:42:41tools and then knowing how, learning how to use them, scaling that up is going to be multi, multi,
00:42:45multi-year process. And there's gonna be a lot of jobs that come up. So those five to 10%
00:42:49of jobs that
00:42:50do go away, I think will actually be highly, uh, uh, will be overly repurposed into different jobs in
00:42:59the future. So that five to 10 that goes away, I think it'll be about 20% upswing with all
00:43:03these
00:43:03smaller businesses, freelance jobs and everything in the future. So, um, I don't want to just say
00:43:09it's foolproof. I just think you need to know the skills, know the tools and know your audience and
00:43:15your market so that you correctly align with that. So you do have a job and a place to work
00:43:19in the future. Excellent answer. And I also think, um, just harking back to the AI, um,
00:43:25conversation that we were having earlier for anyone who is learning data analytics,
00:43:28it is worthwhile just keeping up to date with everything that is changing in the industry,
00:43:32you know, reading blogs, um, like the career foundry blog, just a shameless blog there. Um,
00:43:37but also, um, you know, just keeping up and seeing AI as a kind of, you know, something to work
00:43:42with as opposed to something to just ignore, um, because it's, it's not going away. So it's,
00:43:48it's good to start. And for anyone who is, um, who has been inspired this evening to start their,
00:43:52um, their own journey in data analytics, I am going to post a link to the career
00:43:56foundry short course, um, on big marker. If you are thinking about taking those first steps,
00:44:01it's a free five to six day short course, which will take you on those first steps.
00:44:06Uh, going back to the questions, there was a great question here from Alan over on big marker.
00:44:10Um, for those without a technical background, what do you think are some of the most important
00:44:16transferable skills that lead to a success as a data analyst?
00:44:22Um, so I worked, um, uh, uh, sorry, I was blanking on the name for a second.
00:44:30I worked with a guy named Sergio. Um, and if you follow me on LinkedIn, you may have seen Sergio
00:44:36Ramos.
00:44:36Um, love the guy I worked with him. He was my mentor. He worked in a warehouse, um, using like
00:44:43forklifts and stuff like that. And he was like, I really want to be a data analyst. I was like,
00:44:47let's do it. So he became a, my, my very first mentee that I ever had. And now he works
00:44:52at PayPal
00:44:52as a data analyst. Um, here's what I, and I, and I, I say that because it's very much a
00:45:00similar story.
00:45:02And here's what I recommend with him. Here's what I did with him. I said, first and foremost,
00:45:05you have to learn the skills. So he's like, all right. So he, he busted his butt just trying to
00:45:10learn those skills, learn the skills really well. I was really impressed. I was like, Hey,
00:45:12you learn, you learn this really well in like two, three months. Great job. I was like, all right,
00:45:16build projects. So he hustled, he built those projects. Then I was like, apply. This is where he
00:45:21really stood out. He did exactly what I told him to do and what I wish I had would have
00:45:26done. And what I
00:45:30was like, reach out to as many recruiters as you can bug them until they help you find a job.
00:45:33And
00:45:33just, you have to be kind of like a little bit shameless. And he did that. And he literally was
00:45:38like every, every, every week, he'd be like, Hey, just messaged all my recruiters, just messaged all
00:45:43my, um, uh, or just called all my recruiters and, and, and whatnot. And he, and eventually he got his
00:45:48first job at, um, as just a, um, a consulting job. Then he, at six months after that job, he
00:45:56applied for
00:45:57another job, got another six months, got a year, and then applied to PayPal, got a PayPal job all
00:46:01using recruiters. So if I were you, if I were just starting out, you don't have any relevant technical
00:46:07experience. And he literally had none. He didn't even have a college degree. He literally just had
00:46:10got out of high school, started working in a warehouse. Um, is that your passion and your drive
00:46:16and you're just your ability to keep going and work through these steps is really important. Um, so he
00:46:24just had a really positive outlook on it. He didn't let it get defeated. He just kept pushing.
00:46:29And when he landed that first job, I mean, he just worked and worked. He was a hustler. Like
00:46:32I call Sergio, he's a hustler because he just kept hustling. Um, and so I think part of his like,
00:46:39just, um, you know, I think learning the skills, good resume and working with recruiters,
00:46:44super important. The other thing I will say is a good personality, somebody who is good at
00:46:49interviewing or practice, you can practice interviewing, have a good personality.
00:46:53That goes a long, long way, especially with recruiters when you're working with them to
00:46:58make sure they don't, you know, blacklist you, um, or getting interviews and like talking with
00:47:02a hiring manager, your personality goes a really long way. So those are the things that I think
00:47:08are most important. Those are the things that I did and I, that Sergio did that made him really,
00:47:13uh, really successful, even with almost no qualifications.
00:47:18It wasn't the same Sergio Ramos who used to play for Real Madrid, was it?
00:47:21No, no, no, definitely. Sean's got a great question over on Big Marker. If you're looking
00:47:27into becoming a data scientist, would being a data analyst be a good starting point?
00:47:34Yeah, I get asked this a lot. Um, I think that it definitely can be. And in fact, um, my
00:47:41third
00:47:41year as a data analyst, I was working at Amerisource Bergen. They're a fortune. They're like the fortune
00:47:46five on the fortune 500 list. They're a huge company. And I was working in this data analytics
00:47:51team, uh, or I was a data analyst on a data science team. And I was really good at what
00:47:55I did.
00:47:56And I started working with the data science team. And after about a year there, they asked
00:48:00me if I wanted to transition to become a data scientist. Um, and so it absolutely is possible.
00:48:06Now I turned that down because I saw the work they were doing and it just didn't interest me.
00:48:10I was like, I don't want to do this for the rest of my life. Um, and it wasn't my
00:48:14thing,
00:48:15but a lot of people love data science. And so, um, I, I know for a fact, you definitely can
00:48:20do it.
00:48:21Um, you kind of have to, I won't, I don't know if I want to say upskill, but you have
00:48:25to change
00:48:26your skill sets as you go. So like analytics is very focused on, you know, the data collection
00:48:32on the data cleaning, um, pre-processing, uh, and then visualization as well. Whereas data scientists,
00:48:39they do some of the data collection and pre-processing for their stuff, but they also
00:48:43need to know some of the machine learning models. So you have to skill up in different areas. Um,
00:48:48but it absolutely can be a, definitely a good stepping stone. I've seen a lot of people do
00:48:52it and message me and say, Hey, I was a data analyst, became a data scientist after two years.
00:48:56And I was like, that's awesome. You know, if that's what you want to do, go for it. Um,
00:48:59and there's some people who become data analysts for life. Like me, I don't see myself, um, changing.
00:49:05I thought about becoming a data engineer because I was working closely with data engineers
00:49:09and database developers and really loved, um, building pipelines, but you know, just wasn't
00:49:15something that I was in as interested in that, in that moment. So there are, you can definitely
00:49:20start with analytics and go from there. There are people who have been data scientists and become
00:49:25data analysts, you know, it kind of is a different, it's just different highways. You get on and off
00:49:29and you can kind of choose what you want and what skills you want to learn. Awesome. Just reading
00:49:35some of the comments on YouTube. Uh, hi everyone watching on YouTube. Also Alex's audience. We
00:49:40love to see you always bring great energy. Mandy said that she just saw a chat bot data analyst role.
00:49:46So it just goes to show that there's lots of, there's lots of rules. It's already happening.
00:49:52Um, a great question, I think, um, here from Salma, um, and it harks back to the recruiters
00:49:58of questions that you are answering earlier. Um, how do you actually find good recruiters?
00:50:05So recruiters are, um, I'm going to give you a story real quick, really quick story. And then
00:50:11I'm going to answer that question. When I first was becoming a data analyst, I, somebody told me
00:50:17to work with a recruiter, never heard of a recruiter. Didn't know what that was. I was very,
00:50:21very like perplexed. I was like, what on earth is this? So a guy tells me he has a job
00:50:26offer for
00:50:27or a job interview for me. I'm like, it's a data analyst job. I was like, all right, cool.
00:50:31I like, this is the pays pretty good. I was like, and he says, meet me at this garage that's
00:50:37next to
00:50:37the building. And I'm like, oh my gosh, I'm going to get murdered. Uh, and I told my wife where
00:50:42I was
00:50:43going, what time I was going. And if she didn't hear from me in an hour from that time to
00:50:47call the
00:50:47police, that is actually what happened. I look back and it was really funny. Um, but I didn't know
00:50:53anything about recruiters. They were very scary to me. It was very like just a different world.
00:50:57I wasn't in a tech world. I was in healthcare. So just a different world. Right? So you have to
00:51:03understand that you need to be cautious with recruiters. There are some, you need to make sure
00:51:08they're legit, but recruiters, they can be anywhere. I find a lot of recruiters. I found a lot of recruiters
00:51:14on LinkedIn. So there's a lot of recruiters on LinkedIn. Um, like I was saying before, you can go
00:51:21online, look at a company and search for LinkedIn or search for recruiters in LinkedIn, find them and
00:51:26message them. So if you find a job, um, uh, job posting that you really like, and you're like,
00:51:33oh, this would be my dream job. Don't just apply. You apply. Then you find the company,
00:51:39you reach out to the recruiter and say, Hey, I just applied for this. Attach your resume. I think
00:51:43it'd be a really good fit. I'd love to chat about this. If you have time, um, just a quick
00:51:47note,
00:51:47and that can put you on their radar, right? They're going to have 50 other people who apply.
00:51:52You might be on their radar and no one else is. Um, another thing that I did, and you can
00:51:57also do
00:51:57is search for your area. So I lived in Dallas. So I just Googled data analyst, uh, recruiters in
00:52:05Dallas. Now I quickly found out that sometimes they're called different things. They're called
00:52:09like technical recruiters. They're called, um, uh, there was another term for it. Um, but a lot of,
00:52:15there was called technical recruiters for, for the Dallas area is what I found. Um, and then I
00:52:20started reaching out to them and that's that, that works as well. And you can email, you can call
00:52:25them. Um, and so LinkedIn and cold calling and cold email are the best ones now kind of a, this
00:52:32is
00:52:32something that somebody else did. I am not supporting this. Will don't get mad at me. If somebody gets
00:52:38mad at you, all right. For this webinar, but here's what someone else did. He was living up in Canada
00:52:43and he wanted to move to Minnesota, which Canada to the United States, the job that he had required
00:52:49that he live in the United States. So when he was talking to the recruiter, uh, he, what he did
00:52:55was
00:52:55he went online, searched for in Minneapolis, recruiters that live in Minneapolis, where he
00:53:00wanted to go. Then he reached out to a bunch of them and said, Hey, I live in Minneapolis. I
00:53:04want a
00:53:04job. He got a remote job from Minneapolis and then he moved. So he just went ahead and said,
00:53:11I already live there. I want, I'm going to be there. And he applied and talked to recruiters
00:53:15as if he lived there. So, you know, I'm not saying you should do that, but it did work for
00:53:20him. That's what I'll say. Awesome. Awesome. Um, also for anyone's watching and considering
00:53:27a career foundry data analytics program, um, you're not on the program alone. You do get
00:53:31the full support. As I said, at the beginning of a mentor and a tutor, that's our dual mentorship
00:53:36model. And we also have a team of career specialists and a job preparation course, um, all behind
00:53:42you, um, uh, to prepare you for getting that dream job, um, in tech. So you're not on your
00:53:47own on the career foundry data analytics program. I'm just going to pick up on one comment over
00:53:51on YouTube, which I think is lovely from Hania. I just want to thank you, Alex. I got my first
00:53:57job and your videos helped me a lot. Um, we love that positivity, uh, and congrats Hania
00:54:02on landing that job. Um, now I know a lot of people watching this evening are considering,
00:54:07um, jumping into data analytics or taking their first steps. I think this is a very, very good
00:54:11question from, uh, Sering. Um, is it necessary to be good at maths in order to be successful
00:54:19at data analytics and math math? Yeah. Yeah. Yeah. You guys say maths, which always like throws
00:54:26my mouth. I say you guys, but that's a lot of people. They say maths. Um, so, uh, here's what
00:54:34I'll say. I was pretty good at math, um, in high school and I took like the algebra in college.
00:54:41Here's what I found. And I'm trying to be like super realistic. If you know a lot of basic math,
00:54:48or you know, um, you know, and you'll learn a lot of it as you try to, you learn the
00:54:52skills to
00:54:53become a data analyst. If you know, basic math, you know, you can understand a lot of
00:54:58percentiles. You can understand, you know, division, multiplication, PEMDOTs, the basic
00:55:03stuff for an entry-level role. That's usually enough. Um, usually you don't need to know a
00:55:09lot of, you won't need to know things like linear regression or, um, you know, just some
00:55:13other more advanced stuff typically. Now in the financial world, if you're looking at banking,
00:55:20um, or, or other institutions within the, like fintech, they usually rely more heavily
00:55:27on math, but I worked in healthcare. Um, so my math that I had in high school, college
00:55:34was enough for me. I haven't really gone way above that except for some personal use cases.
00:55:40Um, so I think if, if you know the basics, you'll learn a lot of functions within Excel,
00:55:47within SQL, within Tableau, those are, if you know those, you're going to, you'll either
00:55:54learn it or you will know it. It's not, I wouldn't say it's crazy tough. Um, understanding
00:56:00data is not always about math. Um, understanding data is sometimes a lot more about like the
00:56:05context, the domain understanding of how the data flows. Um, and then usually the end
00:56:12math that you're using is not crazy, crazy complex. Um, or if it is, there's other people
00:56:18there to help you make sure it's correct. So I wouldn't be, you don't have to go and
00:56:23get a degree in like statistics in order to be a data analyst at a lot of places. Although,
00:56:28like I said, there's a lot of quants, which is like, um, extreme to the nth degree with,
00:56:35with needing to know math. And there's a lot of FinTech, uh, finance data analysts that
00:56:40do need to know that level of, of, of math. So, but it's not, it's definitely not the majority.
00:56:47Awesome. Um, we've got someone on YouTube, Joseph, who's doing his algebra homework and
00:56:52wants to, no, I'm just kidding. Um, there's a great question. There's a great question here.
00:56:56Um, from a circuit. Why does a company hire a data analyst instead of a statistician?
00:57:03Um, you know, you can do it. I've worked with statisticians. So, um, I worked with two
00:57:09statisticians. They were working in our data science team and they were extremely knowledgeable
00:57:15in, in creating machine learning models, statistics. I mean, way above my head in some
00:57:22cases, they taught me a lot of stuff. Um, but for a lot of the other work, they would just
00:57:29be
00:57:29overkill. I mean, and in fact, I'll statisticians, at least from, cause I've worked with statisticians
00:57:34at my job. And then I, there was a company that I consulted with not too long ago that had
00:57:37a
00:57:38statistician. They are just very specific to, at least from what I found to making sure of fine
00:57:45tuning, creating hyper parameters for these models, fine tuning parameters, um,
00:57:52creating new equations that'll help with. So it's very math heavy. Um, not, that's not always,
00:57:58but a lot of statisticians don't have the base level data knowledge or maybe industry knowledge
00:58:03that you might have with just a regular data analyst like me who really knows healthcare
00:58:08extremely well. And then I became a data analyst, whereas they know numbers really well. And then
00:58:13they kind of work with the healthcare data. So they're just coming from a different side
00:58:17and wherever that job aligns, they would align that. If it's a very math heavy job where they
00:58:23need, they might hire a statistician. If they need somebody to know data cleaning and the domain
00:58:28knowledge, they'd hire a data analyst. Thanks, Alex. Um, another interesting question that we do get
00:58:34through and from Steven, um, I had 33 years in it and want to come out of retirement. I did
00:58:41some
00:58:41analytics for 15 years of my career. Can a senior citizen 69 have a reasonable chance of landing a
00:58:47job? Yeah, it's, that's really, that's a really interesting question. I just had this talk with
00:58:55my father-in-law. Um, so I'm going to tiny tangent. I'm going to come back. I'm going to, it's
00:58:59going to
00:59:00be on point though. My father-in-law is 67 years old. And for most of his career, he worked
00:59:06with
00:59:06logistics. So, um, he worked in, um, just a few different companies working with transportation
00:59:15logistics, super smart guy. Um, his experience allowed him later in life when he was 65 to work
00:59:22for two years consulting with, uh, you know, I think it was like, uh, PWC or Bain or one of
00:59:27those big,
00:59:27um, consulting companies. He had a lot of really good experience. And so they hired him when he was 65
00:59:34years old and they wanted him to keep working for like the next 10 years. Um, I say that because
00:59:39I
00:59:40could see somebody like you potentially being in a similar position. If you have a really, really
00:59:45in-depth knowledge in it and data analytics, you really know what you're doing. There are going to
00:59:51be people who value that experience. Um, it's even like in consulting companies, uh, who really just
00:59:57want somebody who knows the ins, the outs, how, how systems should work. Um, things that new people
01:00:05coming into the field, even senior analysts wouldn't know how to do at end as in-depth as you
01:00:10would know. So maybe you don't even go for like just a regular data analyst job. Maybe you go for
01:00:15like a chief data officer job at a small company, um, or some higher level manager position at a smaller
01:00:21company where you're more managing than hands-on. That seems to be where you would fit in.
01:00:25I think more, um, that'd be kind of my very quick analysis of, of, of your situation.
01:00:35Awesome. For those of you also watching on Big Mark, I'm just going to post a link to, um,
01:00:40career foundries, um, diversity, equity, and inclusion report. And you can have a look if I
01:00:46can post it on Big Mark. Here we go. Send doesn't seem to be sending
01:00:52because I posted in the wrong channel. Here we go. This one. Um, yeah, you can, um, in the report,
01:00:56you can see, um, the breakdown of our student body. Uh, I do recommend checking it out for anyone
01:01:02who's interested, uh, in doing a career foundry program. Um, uh, just posted a link over in Big
01:01:07Marker. So do check that out. Um, I'm just going to jump into the questions again on Big Marker. Let
01:01:13me go
01:01:13down. Um, let's have a look. So what, um, so my mom is asking what career planning advice do you
01:01:24have
01:01:24for someone who was at the beginning of their career in their first data analyst job? I suppose
01:01:28this is a kind of like a pathway question. Yeah. If you, if you just got at your first data
01:01:33analyst
01:01:34job, first off, congratulations. Cause that's super exciting. Um, you know, looking back, I think
01:01:41I stumbled upon a good formula. Um, I didn't know what I was doing. I just, it just happened,
01:01:47but if you could actually plan it out, that'd be better. Um, here's what I would probably try to do.
01:01:51Um, it's, it depends on what you're trying to optimize for. Are you trying to optimize for
01:01:56salary? Do you want to make as much money as you can within a short time? Do you want to
01:01:59optimize
01:02:00for comfort? Do you want to work remote? Um, really I would be jotting down what's most important
01:02:06to you in the beginning of my career. It was all about money because I was broke. So I
01:02:11like really needed to optimize for money. But then after about three years, I needed to optimize for
01:02:15remote work because of COVID and I had three kids. Um, so knowing what's important to you is really
01:02:21important, but really what you can do is after about a year of working as an entry-level data
01:02:28analyst at one year, you can then start trying to apply, um, for mid-level roles. Now, excuse me,
01:02:37drink too much water. Uh, what a lot of people think is, or kind of the old school way of
01:02:43thinking
01:02:43is, oh, I need to work at a place three, four, five years in about five years. I'm a mid
01:02:48-level
01:02:48analyst. This doesn't really how it works in at least this field or hasn't for probably the past
01:02:5210 years. Things move really fast and you learn a lot on the job and your, your, your skills become
01:02:59a lot more valuable to an employer when you have actual hands-on experience at a company. So once you
01:03:05get a year experience, you can then start job hopping. If that's what you want to do, you can
01:03:09go to another company, get a year there and a different field or the same field job hop and
01:03:13get probably 20% to 40% pay bumps. Um, if you do it right, that's what I was looking
01:03:19at, uh, with
01:03:20mine, I was doing about, about 20 to 40% for each pay bump. So if you're optimizing for money,
01:03:27that's a
01:03:27great way to do it. Um, but you should really be writing down, like, what do you want to do
01:03:32in
01:03:32two, three years? Cause it's a short lifespan, not a short lifespan, a short, um, transition to the
01:03:39next stages of a data analyst, mid-level, senior level, you can get to mid-level, you know, one
01:03:44to five years, somewhere in that range, senior level four to eight years. So you need to start
01:03:49planning, like, what do you want to optimize for? And then try to, try to follow that. That's what
01:03:53I'd recommend.
01:03:55For those people who are studying a data analytics and that they want the highest salary possible
01:03:59after learning data analytics, what would be the, what would be the avenue to go down? If you wanted
01:04:03to, to hit the highest salaries, what would you specialize in? Yeah, this, this, this would be,
01:04:10I don't want to say controversial. I think other people have different opinions. That's what I'll say.
01:04:15My opinion is that I would optimize for an industry. I think industry knowledge, especially in the coming
01:04:22years, five, 10 years, it is going to be more important to know domain knowledge than ever before
01:04:26because of AI and, and knowing these tools. I think domain knowledge is just going to be
01:04:33probably one of the more important things, technical skills in your domain knowledge, for sure.
01:04:37I would be specializing in a domain, whether it's finance, construction, agriculture, whatever it is,
01:04:45become really, really good at it. I think, I think that will lead to more money in the long run.
01:04:54Now,
01:04:56if you, you know, if you want to make the really big bucks, you're looking at potentially things
01:05:00like consulting, working at big tech companies, or really focusing in on that domain knowledge. So
01:05:07you, you have different avenues. But I think the most, the quickest way to get there, as well as
01:05:14probably the easiest way to get there is specializing in a domain. If you try to go get an Amazon,
01:05:20go to Amazon right away to get a big salary, it's going to be really tough to break in because
01:05:23it's
01:05:23just a lot of people who work there or a lot of competition. So that's what I would do. I
01:05:28would
01:05:29recommend finding an industry that you like, becoming really good at it. I think that's going
01:05:33to be really important in the next several years. Awesome. A quick question also, when you're a data
01:05:40analyst and how much does kind of strategy come into play? So you've got the company data, you see
01:05:45that there's some problems, you, you, you visualize it, you present it to the company. Do you also stand
01:05:51there in the boardroom or in the meeting and say, look, this is what's going on with the data from
01:05:54the company, and these are potential solutions? Or are you just delivering the message?
01:06:00Yeah. So I have different experiences at different companies in different positions.
01:06:05At my first job, I was a data analyst at a very small, if under 50 people, healthcare analytics
01:06:12company. With that job, I mostly reported to the clients. And then I mostly reported to my boss.
01:06:19So my boss was, he was the director of like analytics, right? So I mostly reported to him.
01:06:26When I worked at the fortune 500 company, when I was just a data analyst, I had just broken
01:06:32in, I, we worked at a larger team. So at the small company, I was just reporting to like one
01:06:37guy at the, at the Amerisaurus Bergen, I was working as a team of about like 12 people.
01:06:44So our team would come together and I usually present to the whole team because we were a part
01:06:48of a long process of the data collection process, the data cleaning process, transforming it,
01:06:54doing all that stuff, creating the visualizations. We had a person for everything. Database engineers,
01:06:59database developers, visualization specialists. We had the whole gambit. Data scientists. And we would
01:07:05then report up to the program manager who then would report, we would present that to them first.
01:07:10Then we would present that to either my manager or my manager's manager, who was the senior director
01:07:18of data science. And after that, we never went higher than that. Now, in my last job, I was an
01:07:25analytics manager. I reported directly up to the CIO and the senior vice president of IT. So I think it
01:07:36depends, just as a data analyst, you're typically at a small companies reporting higher. At smaller
01:07:41companies, you're reporting like one or maybe two levels above. And then as a manager, I was reporting
01:07:47up to the highest and then everyone in between because of just how my role was. So I was reporting
01:07:52to really everybody or presented to really everybody. Awesome. Thanks, Alex. Just going back quickly to
01:08:00the career foundry data analytics program, because some people are asking about the length. If you can
01:08:04devote 30 to 40 hours a week, you can complete the course, the program four months. And if you can
01:08:10devote 15 to 20 hours, you can complete it in eight months. Just to clarify for anybody who wanted to
01:08:17know that. Alex, thank you so much for hosting another fantastic presentation this evening. Also,
01:08:23thanks so much to Alex's crowd. And I would also just like to say quickly to anybody who's watching
01:08:29from Career Foundry, do subscribe to Alex's YouTube channel over. It's Alex, the analyst.
01:08:35It's currently at 470,000 subscribers, and we want to get it to 500. So do go over there and
01:08:41subscribe.
01:08:42We've got to get to 500 by the end of 2023. It's a combined goal. But yes, thank you so
01:08:48much for all
01:08:49the great questions, all the engagement this evening. For anybody who's watching and is interested in data
01:08:54analytics, I would also recommend checking out the Career Foundry blog. I'm just posting a link over
01:08:59on Big Marker. There are some very specific topics on tools, salaries, but there's also some more
01:09:05general topics there on soft skills, transferable skills, and jobs in your locality, that kind of
01:09:11thing. So do check it out. We've got a great team of editors working at Career Foundry, writing these
01:09:15articles, and they would love for those to be read. Also, do check out the Career Foundry YouTube
01:09:20channel. You can see previous live events that we've done over there, but you can also see members
01:09:25of the team who've been interviewed and people that we've interviewed, alumni. Do check that out.
01:09:30There are some familiar faces, especially in the data analytics section. So I would recommend going
01:09:34over there, especially checking out the videos from Tom Gadsby, who is the senior data scientist here
01:09:40at Career Foundry. He's got some great introductory YouTube videos, so do check that out. And last but not
01:09:46least, if anyone is considering a career change and is thinking about Career Foundry, we are currently
01:09:51offering career change scholarships worth up to $1,125 or 1,125 euros off the full price of the
01:09:58program. To get that or to apply for that, just book a call with a program advisor. If you're on
01:10:04YouTube, click the link below in the description, or if you're on Big Marker, click the sticky note
01:10:09and speak to one of our program advisors. They're lovely. I know them all personally, and they can also
01:10:13answer any questions that you might have about the dual mentorship model, the curriculum,
01:10:17job guarantee, all those kind of things. And they're waiting on the calls now. Alex, thank you
01:10:23so much. Are we going to see you again this year? Probably. I hope so. I hope you'll have me
01:10:27back.
01:10:28I love doing these webinars. I hope so. We're going to find a topic. We're going to find a really
01:10:32juicy
01:10:32topic. So we're going to get you back on the channel. But thank you so much for spending your time
01:10:36this evening. And that was a great presentation. Thanks to everybody who joined us from all over the
01:10:40globe, a great international crowd and a great evening. So thank you everyone and see you next time.