No fluff, no jargon; just the essentials to kick-start your data analyst career in 2025 with a strategy built for success.
💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training
👩💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com//interviewsimulator
⌚ TIMESTAMPS
00:16 Understanding Different Data Roles
01:48 Essential Data Skills and Tools
04:36 Building Projects to Showcase Skills
08:13 Creating a Portfolio for Your Projects
09:06 Optimizing LinkedIn and Resume
10:46 Applying for Jobs and Networking
12:38 Preparing for Interviews
14:25 Conclusion and Final Tips
Join the Bootcamp: Data Career Jumpstart
Browse Data Jobs: Find a Data Job
Must-Learn Skills for Aspiring Analysts: Watch on YouTube
Find Free Datasets for Practice: Watch on YouTube
Stratascratch for SQL Practice: Visit Stratascratch
Prepare for Interviews: Interview Simulator
🔗 CONNECT WITH AVERY
🎵 TikTok
💻 Website
Mentioned in this episode:
💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly
If you enjoy this podcast, you're going to LOVE my newsletter. Every week, I send you 1 email jam-packed with tips, tricks, and resources. Don't miss it!
Here's how I would become a data analyst if I had to
2
:start all over again in 2025.
3
:Now, I'm lazy and I'm impatient,
so this method that I'm going to
4
:be choosing, the SPN method, is the
fastest and it's the lowest amount
5
:of work to actually land a data job.
6
:But it still is a lot of work.
7
:Step one is I'd understand the different
data roles available in the data world.
8
:There are so many different data
roles, and it's not just data analysts.
9
:There are so many other roles, That
are just like data analysts, but
10
:have slightly different names and
slightly different responsibilities.
11
:For example, business intelligence
analyst, business intelligence
12
:engineer, technical data analyst,
business analyst, healthcare
13
:analyst, risk analyst, price analyst.
14
:There are so many, literally
so many different options that
15
:you could possibly choose from.
16
:And they're all pretty similar for
the most part, but some things are
17
:going to be slightly different.
18
:So for example, a healthcare analyst,
you're going to be a data analyst.
19
:But specializing and
looking at healthcare data.
20
:Financial analysts, same thing.
21
:You'd be looking at financial data.
22
:A BI analyst, like a business
intelligence analyst, and a data
23
:analyst, really a lot of the time are
going to be doing the exact same thing.
24
:So it's important to be looking for
all these roles, understand what these
25
:roles do and what their slight nuances
are, because there's a chance that
26
:your previous experience is actually
valuable and would help you get a leg
27
:up in applying for these different jobs.
28
:So for example, If you have a business
degree and you're trying to transfer
29
:into business analytics, becoming a
business analyst makes a lot of sense or
30
:a financial analyst makes a lot of sense.
31
:If you've worked previously as
a nurse or like a CNA, maybe
32
:you become a healthcare analyst.
33
:Whatever you've done previously,
there's probably a good chance
34
:that that experience is valuable in
the data world to a specific role.
35
:So even like I have a lot of
truck drivers in my business.
36
:Bootcamp.
37
:Those truck drivers can be logistics
analysts, they can be operations
38
:analysts, they can be supply chain
analysts, because their previous
39
:experience is actually valuable.
40
:The second thing that I would do
is figure out what is actually
41
:required, because here's the truth.
42
:There is actually thousands
of data skills and tools.
43
:and programming languages out there,
but if you try to master all of them,
44
:you're going to be like 150 before you
feel prepared to start applying to jobs.
45
:You're going to be dead.
46
:It is impossible to learn.
47
:It's impossible to master
all the different data tools
48
:and skills and languages.
49
:So by default, have to choose a few.
50
:Now you have a decision to make
is which ones do you choose?
51
:And I, like I said, I am lazy and I want
to do the least amount of work possible.
52
:So I believe in the low hanging best.
53
:Tasting fruit analogy.
54
:If you can imagine that there's
a tree that has some sort of like
55
:a peach or an apple on it, right?
56
:The easiest fruit to grab is
always going to be the closest,
57
:so it's the lowest hanging fruit.
58
:But not only do you want the
lowest hanging fruit, you want
59
:the tastiest fruit, right?
60
:So this is stuff that is not only easy
to learn, but is extremely useful.
61
:Those are the things you want to focus on.
62
:Out of the thousands of data skills, those
are the ones you'll want to focus on.
63
:You can do the research on your own,
if you'd like, by looking at job
64
:descriptions and writing down what
is actually required, but that's a
65
:lot of work and you can take it from
someone like me, who's been in this
66
:space for about a decade now, looked at
literally thousands of job descriptions.
67
:I even have my own data job board.
68
:Findadatajob.
69
:com.
70
:And I look at it all the time
to see what is being required.
71
:So I've done this research for you
already, and I will have a link to
72
:my conclusions in the show notes
down below, but basically what you
73
:need to know in terms of low hanging
fruit, it's Excel, Tableau, and SQL.
74
:That is it.
75
:Those are the top three skills that you
should be learning as a data analyst
76
:when you're just trying to get started.
77
:And if that is too hard to remember, you
can remember every turtle swims, right?
78
:That's easy.
79
:Excel.
80
:Tableau and SQL.
81
:That is where I'd start and I
wouldn't really veer off of that
82
:until I've landed my first data job.
83
:Now you might have noticed that I
didn't say Python and that might
84
:come as a surprise to many of you
because you hear so much about
85
:Python and how cool it is and how
popular it is and it is really cool.
86
:It can do so many different things.
87
:It's so powerful and it's actually my
favorite data tool but it's actually only
88
:required on 30 percent of data analyst
roles and it's really hard to learn.
89
:It takes a long time to learn
Python because Python is hard,
90
:but also all programming is hard.
91
:And if you don't have a programming
background, it's going to take a
92
:long time to just kind of even get
your foot in the door in the Python
93
:world and understand what's going on.
94
:What's a variable?
95
:What's a loop?
96
:What's a function?
97
:Those types of things just, they take
time and so if you only need it for
98
:30 percent of the jobs, that means 70
percent of the jobs don't require it.
99
:And once again, I am all about doing
the least amount of work possible
100
:and doing it as quickly as possible.
101
:So I say save Python for after your
first day at a job because it's really
102
:just not needed to land that first one.
103
:Once again, I have a free video that
kind of explains what skills you
104
:should learn and in what order and why.
105
:I'll have that in the
show notes down below.
106
:The third thing that I would do if I was
trying to become a data analyst is try
107
:to figure out how I'm going to convince
a hiring manager or recruiter to hire me,
108
:even though I have no prior experience.
109
:There's this thing called the cycle of
doom, which basically says I can't land a
110
:data job because I don't have experience
because I can't land a data job.
111
:And it's this never ending cycle
of, well, you're never going to get
112
:a job unless you have experience.
113
:You can never get experience
unless you get a job.
114
:It's kind of like the
chicken or the egg, you know?
115
:So you have to figure out, how am
I going to beat the cycle of doom?
116
:And how am I going to convince
someone that, yeah, I am a data
117
:analyst and you should hire me.
118
:How would I do it, personally?
119
:I'd build projects.
120
:Projects are a great way that
you can demonstrate your skills.
121
:It's basically the tangible evidence
for people to know that you can do
122
:what your resume says you can do.
123
:If you're unfamiliar with projects,
It's like almost doing pretend work
124
:where you're pretending that you're
working for a certain company.
125
:You take a data set and you analyze
it and publish your results.
126
:We'll talk about where to publish them
here in a second, but basically it's
127
:allowing you to learn with realistic data
with realistic problems, but also you're
128
:creating some sort of evidence, like
literally physical evidence that you can
129
:show to hiring managers, recruiters, and
be like, Hey, look, I can do these things.
130
:I can be a data analyst.
131
:I can use Excel.
132
:I can use SQL.
133
:I can create a data
visualization in Tableau.
134
:Once I understand those three
things, the fourth thing that I would
135
:personally do is start learning.
136
:And I want to emphasize
this is not the first thing.
137
:This is not the second thing.
138
:This is not the third thing.
139
:It's the fourth thing that I
would do is start learning.
140
:And I would start learning Excel,
Tableau, SQL, every turtle swims, right?
141
:And I would do that by building projects,
because I think building projects
142
:is the most realistic way to learn.
143
:I'll think it's It's the funnest
way to learn because just doing like
144
:pointless exercises on like these
like interactive online learning
145
:things, this is not realistic.
146
:Like in real life, you're going
to be having real data sets.
147
:You're not going to be in some
like controlled environment.
148
:You're actually going to have to be
analyzing real data that's messy,
149
:that has issues that has flaws
and you have to figure it out.
150
:And so building projects is the
best way to learn because you're
151
:also creating this tangible evidence
that you're going to be able to show
152
:to hiring managers and recruiters.
153
:You might be thinking, well,
where do I get started?
154
:Well, you need to figure out
where you can find datasets.
155
:You have to have a good dataset.
156
:I just did an episode on this
recently, and I'll have the link
157
:to the show notes down below.
158
:But the simple answer, the
one word answer is Kaggle.
159
:Kaggle is the best
place to find a dataset.
160
:It's not the only place, and there's
other great resources, but if
161
:you're only looking for one, Kaggle
is usually the place I would go.
162
:And I'd personally build projects based
off of what you want to do ultimately.
163
:So go back to step one and think about it.
164
:Like if you have a business degree, let's
say you want to become a business analyst,
165
:I would try to build projects that are
relevant to, to business analytics.
166
:Maybe data on sales or marketing
or operations, anything
167
:that's business related.
168
:Those are the projects
I would try to seek out.
169
:Or if you're not sure, like if you want
to be a business analyst or a healthcare
170
:analyst, or maybe you don't even care.
171
:You'll just take whatever you've got.
172
:I would suggest doing projects
on lots of different industries.
173
:Maybe dip into healthcare analytics.
174
:Maybe do some people and HR analytics.
175
:Maybe do a project on
manufacturing and engineering data.
176
:That way you're getting exposed
to multiple different industries,
177
:so you can kind of figure out
maybe what you're interested in.
178
:You're creating a robust portfolio
that will be attractive to every
179
:industry and multiple companies, right?
180
:Because if you just focus on creating,
you know, business projects, but
181
:let's say you want to become a
healthcare analyst, it's like, oh,
182
:those projects don't really match up.
183
:So.
184
:That way you have a project for whatever
role you might be interested in.
185
:So that's particularly
what I suggest doing.
186
:And it's what we do inside of
my bootcamp, the Data Analytics
187
:Accelerator is we learn Excel, SQL,
and Tableau by building projects.
188
:And we built multiple projects
in different industries.
189
:So that way we're very robust as can.
190
:The fifth thing I would do if I was
trying to become a data analyst.
191
:is create a home for my projects.
192
:And this is actually
what's called a portfolio.
193
:You know, projects are something that
we do but if you just do them and you
194
:don't publish them and you don't share
them, they don't actually do much good.
195
:You need to create a portfolio
to home these projects.
196
:And the portfolio platform you'll
hear the most about is GitHub.
197
:And I have a controversial
take that I'm not a fan of it.
198
:I don't think GitHub is
meant to be a portfolio.
199
:Now that's me being a little bit picky,
but I just don't think it's the best
200
:option if you're choosing from scratch.
201
:What you need to do is make sure
that your readmes are really good,
202
:because if you have a good readme
on your GitHub, then it can work.
203
:But if you're starting from scratch,
I recommend doing something like
204
:LinkedIn, using the featured section.
205
:Or choose GitHub Pages, which is from
GitHub, but kind of a separate product,
206
:and it's their portfolio solution.
207
:It's actually what GitHub
recommends as a portfolio.
208
:Or I really like Card, C A R R D.
209
:It's just a simple website builder,
be really great options inside the
210
:accelerator, my bootcamp, so any of
those three would work just fine.
211
:The sixth thing I would do is make
sure that my LinkedIn and resume
212
:are up to date and optimized.
213
:And I would do this early, even
before I've actually mastered Excel
214
:or I've, you know, tackled Tableau.
215
:The earlier you do this,
the better, because.
216
:Your LinkedIn is your professional
business card to the world.
217
:One of the really cool things is LinkedIn
has a feature called Open to Work.
218
:There's two different settings on it.
219
:We can talk about it later, but
basically you can have Open to Work
220
:for the entire world or you can just
have Open to Work for recruiters.
221
:And either way, if you set up
your LinkedIn correctly, your
222
:LinkedIn can start to work for you.
223
:And instead of you going out and
applying for jobs, recruiters
224
:and hiring managers are actually
applying to you for specific jobs.
225
:They'll reach out to you and be like, Hey,
I think you're a good fit for this job.
226
:So having an optimized
LinkedIn is, is really key.
227
:And then of course, having an
optimized resume is a must because
228
:once you start applying for jobs.
229
:If your resume isn't optimized, you're
probably not going to get many interviews.
230
:And the reason is there's so many
candidates trying to get into data
231
:analytics roles, especially the
entry level ones, that recruiters
232
:and hiring managers have to use
what's called the ATS, which is
233
:the Applicant Tracking System.
234
:And basically it's, it's computer, it's
AI, it's It's actually not even really
235
:that complicated, but there are certain
things you need to do on your resume to
236
:have it be optimized and ATS friendly, so
you can get past the computer screening
237
:and actually have a human being look at
your resume, because it's so frustrating
238
:when you get rejection after rejection
after rejection that you don't even know
239
:if a human's looking at your resume.
240
:A lot of the times you're just getting
rejected by the ATS, and so you need to
241
:make sure you have an optimized resume.
242
:So, in terms of having an optimized
resume, it would basically look like
243
:not having any columns on your resume,
or any tables on your resume, and
244
:then using really key words that match
the job descriptions, so that way you
245
:appear as a good applicant to the ATS.
246
:The seventh step that I would take
is to start applying, and I think
247
:this is obvious, but a lot of people
don't ever start applying for jobs.
248
:And I get it, because it's scary.
249
:How do you know if you're
ready to land a data job?
250
:It's hard to know, and you probably
will never feel ready, so I suggest
251
:just start applying anyways.
252
:And when you start applying,
don't only apply on LinkedIn jobs.
253
:LinkedIn jobs is where everyone applies,
and there's going to be hundreds of
254
:candidates in a matter of a few days
on those platforms, the majority of the
255
:time, because everyone's doing that.
256
:So you might want to try something
new, like going to company websites or
257
:checking out my job board, findadatajob.
258
:com or some other combination
of other job websites.
259
:The point here is you need to
be looking at multiple places
260
:and actually start applying.
261
:I know it's scary, but just do it scared.
262
:The next step I would do in this process
is I would really try to be networking.
263
:And I, I would try to be networking
the entire time, like even in step one.
264
:But this is where I fit on
today's roadmap is step eight.
265
:So it's way easier to get
hired when you know someone.
266
:In fact, my brother was just recently
looking for a job and having a
267
:hard time and he ended up Getting
an interview and landing that job
268
:because his wife's friend works there.
269
:And like, I can't tell you how
often that actually happens.
270
:So networking doesn't have to be hard.
271
:You can do it on LinkedIn by
posting and commenting on LinkedIn.
272
:I think that's really important to do, but
I understand that's hard and a scary step.
273
:One thing that's really a lot easier is
just to talk to your friends and family.
274
:Just say, Hey, I'm trying
to become a data analyst.
275
:Do you know anyone who's a data analyst?
276
:Does your company hire data
analysts and have a conversation?
277
:You're not even really
asking them anything.
278
:You're just opening a conversation.
279
:I know this is hard and I know it's
uncomfortable and I know it's not fun.
280
:Like it's much more fun to learn data
skills than it is to network, but
281
:honestly, networking gets you the same,
if not better results than upscaling
282
:and actually learning new data things.
283
:So you can't be ignoring this.
284
:Couldn't be ignoring this.
285
:I have to be networking,
no matter how hard it is.
286
:Now, if all is going well, and I'm doing
all the previous eight things that I've
287
:talked about, I think at this point
I'd probably start to land interviews.
288
:There's two parts to an interview,
the technical and the behavioral.
289
:The technical interview is when
they're going to be asking you
290
:questions about data skills.
291
:It might be like, Excel questions or data
visualization questions or oftentimes
292
:sequel questions and I'll ask you to
write certain sequel queries This can
293
:be really scary and intimidating and
honestly, they can be really hard The
294
:cool part is they don't always occur
or or if they occur they occur very
295
:easily Sometimes they're very hard.
296
:Sometimes they're very easy.
297
:It really just depends and to prepare
for the technical resources There's
298
:a lot of things that I could do.
299
:There's a lot of resources out
there that would help me prepare.
300
:Um, there's something called Scrata
Scratch that I'll have a link in the show
301
:notes down below that you guys can check.
302
:There's Data Lemur.
303
:There's a bunch of tools that
will help you prepare for
304
:these technical interviews.
305
:Behavioral interview is going to be
more like them trying to feel for
306
:who you are and what you've done
previously and like how you would
307
:act as a human being, as an employee.
308
:And that is a little bit harder to
prepare for because it's more of like,
309
:instead of answering technical questions,
it's answering like personal questions.
310
:There's not a whole lot
of resources out there.
311
:One of the things you would want
to do is use the STAR method.
312
:You want to answer every question by
saying, this is the situation I was
313
:in, this is the task I was given, this
was the action I took, and this is the
314
:results that came from that action.
315
:And if you answer using that method,
most of the time you'll be good.
316
:It can be scary, and there's not a whole
lot of resources out there for this.
317
:So do you want to check
out one that I made?
318
:It's called interview simulator.
319
:io, and it basically helps you
practice these questions where
320
:I'll ask you the question via video
and you will respond via video.
321
:And then we'll actually grade your
answer and tell you what you did
322
:well and where you could improve.
323
:It's a pretty cool software.
324
:I'll link for that in the
show notes down below as well.
325
:Wow, lots of links in the show
notes, so be sure to check those out.
326
:So those are the nine steps that I
would take if I had to start from
327
:scratch and land a day job in 2025.
328
:And remember, I'm lazy, I'm trying
to do this the easiest way possible.
329
:This is This is what
I call the SPN method.
330
:You need to learn the right skills, not
all the skills, but the right skills.
331
:You need to build projects
and put them on a portfolio.
332
:That's the P part.
333
:And then you need to be
networking, updating your
334
:LinkedIn and updating your resume.
335
:That's the N part.
336
:And it's the easiest
way to land a data job.
337
:Now you can do all this stuff that
I told you on your own and you'd
338
:be 100 percent okay, but it's a lot
more fun to do it in community and
339
:it's a lot easier to do with a coach.
340
:Once again, I'm all about doing it
fast, And it's much easier to do
341
:that with a given curriculum where
you don't have to be questioning.
342
:Am I doing this right?
343
:How do I actually do this?
344
:So on and so forth.
345
:And so that's why I created the data
analytics accelerator program, which
346
:is basically a 10 week bootcamp to
help you land your first day at a job.
347
:We'll go over all of these nine steps.
348
:Hand by hand, step by step together, and
make sure you're ready to land a data job.
349
:If you want to check that out,
you can go to datacareerjumpstart.
350
:com slash D A A D A A standing
for Data Analytics Accelerator.
351
:And of course, I'll have a link to
that in the show notes down below.
352
:Let me know what I missed
and what questions you have.
353
:I'll try to respond to everyone in
the comments down below if you're
354
:watching on YouTube or on Spotify.
355
:And I wish you the best of luck in 2025.