Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Here is how I would approach becoming a data analyst in 2026 if I were starting over. Focusing on the right fundamentals early changes everything.
π Join 30k+ aspiring data analysts & get my tips in your inbox weekly π https://datacareerjumpstart.com/newsletter
π Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training π https://datacareerjumpstart.com/training
π©βπ» Want to land a data job in less than 90 days? π https://datacareerjumpstart.com/daa
π Ace The Interview with Confidence π https://datacareerjumpstart.com/interviewsimulator
β TIMESTAMPS
00:00 β How Iβd Become a Data Analyst in 2026
02:00 β Learning the Right Skills Through Projects
04:30 β Why Certificates Donβt Matter
06:30 β How to Stand Out and Build Trust With Hiring Managers
07:32 β Creating a Portfolio and Networking to Land the Job
π CONNECT WITH AVERY
π₯ YouTube Channel
π€ LinkedIn
πΈ Instagram
π΅ TikTok
π» Website
Mentioned in this episode:
May Cohort of the Data Analytics Accelerator β Now Open
π datacareerjumpstart.com/daa The May cohort of the Data Analytics Accelerator is officially open for enrollment. This is my comprehensive data analytics bootcamp that takes you from wherever you are to landing your first data job. Doesn't matter your background, your degree, or your experience level β we're going to help you get there. What you get: π Full curriculum covering Excel, SQL, Tableau, Python, and R π οΈ 9 real-world projects across different industries to build your portfolio πΌ LinkedIn, resume, and interview prep so you actually stand out to recruiters π€ Weekly office hours, coaching, and a community of 900+ aspiring analysts who are in it with you π Lifetime access β go at your pace, come back anytime May enrollment deal: π₯ 20% off when you enroll now π 6 free months of my unreleased Data Portfolio Builder tool β this isn't publicly available yet, and every May cohort member gets early access The live kickoff call is with yours truly on Monday, May 11th at 7:00 PM Eastern. Make sure you're enrolled before then so you don't miss it. π datacareerjumpstart.com/daa Or just click the link in the show notes down below. See you on May 11th.
If I wanted to become a data analyst in 2026,
2
:here's exactly what I would do.
3
:I'd break it down into two separate parts.
4
:Number one is the, what do I actually
need to know to become a data analyst?
5
:The skills, and number two is
how do I actually stand out
6
:first, what do you need to learn?
7
:Where should you learn it?
8
:The biggest thing when it comes to
becoming a data analyst is actually
9
:knowing the tools to analyze the data.
10
:Not only knowing the tools, but also
having the mindset of a data analyst.
11
:And in my opinion, those are actually
both learned best through doing
12
:projects and real life examples.
13
:A project is basically like a use
case or an actual like real world
14
:example of you analyzing data.
15
:I'm not a really big fan of like all of
these silly online tutorials and all these
16
:silly like, oh yeah, like step-by-step.
17
:This is this little sandbox
and this is how you do this
18
:and this is how you do that.
19
:I just don't feel like
it's super realistic.
20
:I personally.
21
:Learn best by doing
hands-on real practice.
22
:And so I think why not
just start with that?
23
:I also wouldn't learn everything
because there's so many different
24
:things you could be learning, and my
old philosophy is we need to get your
25
:foot in the door as quickly as possible
so that way you can start to get paid.
26
:To learn on the job.
27
:Like if you're going to try to
learn everything before you feel
28
:ready to apply to data analyst jobs,
you're gonna be like 89 years old
29
:before you start applying for jobs.
30
:And, uh, I don't know about you, but
I don't wanna be working when I'm 89.
31
:So you first need to shrink the amount
of things that you're going to learn.
32
:So in my opinion, the first thing that you
should learn is excel, just 'cause it's
33
:really easy and it's really in demand.
34
:Second thing you should learn is Tableau
or Power bi, because they are also very
35
:in demand and pretty easy to learn.
36
:And the third thing you should learn
is sql, because once again, pretty
37
:easy to learn and pretty in demand.
38
:I think you should put R
and Python on the shelf.
39
:And honestly, anything, any other
tool really on the shelf right
40
:now, just start with those big
three, uh, BI tool, Excel and sql.
41
:Ignore everything else because it's just
gonna keep you in the study tutorial.
42
:Hell, for a long time.
43
:Not only would I be learning those
things, I would just be trying to learn
44
:to think as a data analyst, so when I
get a data set, you know, what does it
45
:actually mean to clean the data set?
46
:What things should I be looking for?
47
:Or in the data set that might
make it dirty or hard to analyze.
48
:Then I, based on the data set I
have, I would start to already think
49
:through what are the different things
that I can do with this data set.
50
:So, for example, if you have a date
column, you automatically know, hey, this
51
:is some sort of a time series data set.
52
:I can do some sort of a time series
analysis, like create a line chart or
53
:do some sort of predictive modeling
like arima to predict, you know, how
54
:this trend will continue down the road.
55
:You know, five Decembers from now.
56
:Like what is their numbers
actually going to look like.
57
:If you have categories,
you can say, okay, like.
58
:What was this quantitative
variable, like some sort of a
59
:price or some sort of a number?
60
:How does that number change
the different categories?
61
:So like if you have like a blue
product and a red product, like
62
:did the blue product sell more
or did the red product sell more?
63
:You know, what were the different
margins on each of those?
64
:Like those are the different
things that you can start to try
65
:to learn to think as an analyst.
66
:In my opinion, it's actually really
hard to learn to think of an analyst.
67
:Learning the skills is not
easy, but it's a lot easier than
68
:learning to think like an analyst.
69
:The only way I really try to teach
other people to think as an analyst
70
:is one, give them realistic examples
where they can actually go through
71
:the process step by step of like,
oh, okay, I kind of get this.
72
:I kind of get this.
73
:And the other one is what I call project
hacking, which is basically you see
74
:someone else's analysis and read through
what they did, and you think, oh, okay.
75
:And you do that enough.
76
:Eventually you start to think like
an analyst, like there's no magic
77
:bullet, there's no framework.
78
:I can give you right now that's
gonna help you think like an analyst.
79
:It just comes with experience.
80
:And experience is just the amount
of time that you, uh, have hands-on
81
:analyzing data or hands-on reading
someone else analyzing data.
82
:I think those are like the
only two ways that you can
83
:start to think like an analyst.
84
:Now, I'm not a big fan of
certificates because I actually
85
:don't have any certificates.
86
:Like I don't have the Google
Data Analytics certificate.
87
:I don't have any like Comier,
TIA certificates, I can't
88
:even say the name, right.
89
:I don't have an IBM certificate.
90
:I don't have a meta certificate.
91
:I literally have zero certificates, landed
all of my data jobs in my corporate.
92
:Career without a certificate.
93
:And I don't think certificates are really
built to teach you the best because I
94
:don't feel like they're very hands-on
project DI feel like they're kind of
95
:unrealistic, kind of handholding baby.
96
:Uh, and I just think people
like are like, oh, like I need a
97
:certificate to be a data analyst.
98
:No, you don't.
99
:You literally don't, and if you think
that having a certificate is gonna make
100
:a difference, I don't think it is because
it's never made a difference in my career.
101
:I've talked to a lot of hiring managers
and recruiters, they don't really care.
102
:There's no like standardized certificates
to have in data analytics field.
103
:So personally, I think doing hands-on
projects is infinitely better than
104
:doing these silly certificates.
105
:That actually leads me into the second
half, which is okay, let's say you learn
106
:Excel, you learn sql, you learn Tableau.
107
:Great.
108
:But how do you actually stand out now?
109
:Because the data analyst job market is
very competitive, especially kind of at
110
:that entry level junior data analyst role.
111
:Like how do you actually stand out?
112
:And I think there's a
couple different keys here.
113
:I think one of them is to
actually broaden your job search.
114
:Because literally you guys, everyone
is looking to become a data analyst,
115
:but there's like literally 20 different
titles that you could be searching
116
:for that aren't exactly data analysts,
but basically they're a fancy title
117
:to say that you're a data analyst.
118
:I can't list them all right here, but
business intelligence engineer, financial
119
:analyst, product analyst, pricing analyst,
a lot of things that have the word analyst
120
:in it are going to be good for you.
121
:Um, because a lot of the
times it's just like, hey.
122
:Data analyst role plus domain
smash together, get a new title.
123
:And a lot of people aren't
looking for those roles.
124
:So they're less competitive, but they're
literally the jobs you're looking for.
125
:Now I have proof of this because
I actually run a data job board.
126
:It's called Find a Data job.com.
127
:We post about 30 data jobs a day.
128
:Um, we try to include a lot of these like
kind of alternative data analyst roles.
129
:And I actually have all the data, all
the click data of you guys going to
130
:that website and what do you click on?
131
:And it's actually unproportional
data analyst roles.
132
:Like if it literally says data
analysts, those get like, I think two
133
:to three times more clicks than like
a financial analyst or a business
134
:analyst or a marketing analyst or a
pricing analyst or something like that.
135
:And literally, the job
description could be the same.
136
:It's just everyone loves the title data
analyst and that's what they're used to.
137
:And we just love what we're used to.
138
:So I would say.
139
:Try to apply less to like data
analyst roles and more of these like
140
:niche terms that basically mean data
analysts but aren't data analysts.
141
:The other thing you're gonna have to
figure out is like how do you convince
142
:the hiring manager or recruiter that
you can do what a job description says
143
:that, that you need to do because you
don't have prior experience, right?
144
:So it's like the cycle of doom, right?
145
:I can't get a data job because
I don't have data experience.
146
:Well, why can't you get data experience?
147
:It's like, oh, it's 'cause
I don't have a data job.
148
:So you're in this never ending
cycle and it's like you need
149
:someone to take a chance on you.
150
:But in order for someone to take a
chance on you, you actually need trust.
151
:And trust is hard to get, especially
when you don't know someone, right?
152
:We trust people that we know, and
you're going to be applying to
153
:recruiters and hiring managers
who don't even know you at all.
154
:They don't even know your face.
155
:They hardly know your name.
156
:They just know A PDF that you
gave them with some stuff on it.
157
:So that's where like.
158
:Really doing a good job on your
resume, really doing a good job on your
159
:LinkedIn, maybe trying to send cold
messages and actually networking, right?
160
:Like if you can get a cold message
to a recruit hiring manager that they
161
:actually like, that puts you so much
far against all the other competitors.
162
:If you can have like a friend or a
family member kind of refer you, then
163
:all of a sudden you're more trusted.
164
:'cause they probably
already trust that person.
165
:So like you need to come up with a
game plan to actually get trusted
166
:by a recruiter or a hiring manager.
167
:And that is hard to do, like I said.
168
:Updating your resume, making
it really good, making sure
169
:your LinkedIn is really good.
170
:And then the last thing I
think is creating a portfolio.
171
:So remember we talked about those
projects earlier, how it's the best way
172
:to learn, creating those projects and
then putting 'em on a online portfolio
173
:where it's like, Hey, this is literally
tangible evidence that I can do the
174
:what the job description's asking.
175
:Like the job description right here,
like look at here is a project.
176
:That I did that basically nears
what the job description is.
177
:And that way you're making yourself
a little bit of less of a risk.
178
:It's like, Hey, look, hiring
manager, you're worried about me.
179
:I've already done this
before and here's the proof.
180
:So like, go ahead and take a
look at the proof right here
181
:and uh, trust me I can do this.
182
:And creating portfolio is
very good for those use cases.
183
:So I think creating portfolio and
networking really come in clutch here.
184
:Unfortunately, I think most people
when they try to become a data analyst,
185
:they do one of these certificates where
they learn some skills in some sort of
186
:like lame tutorial, or they get like
their certificate at the end you're
187
:like, yay, I'm all certified now.
188
:Or they do something like data camp
or something like that, and I just
189
:think you're missing out on projects.
190
:I think you're missing out on portfolios.
191
:I think you're not spending enough time.
192
:Emphasizing your LinkedIn, your,
uh, resume and your networking
193
:and your cold messaging skills.
194
:'cause like those things are really
important because everyone knows
195
:at this point, everyone knows
how to analyze data in Excel.
196
:Everyone knows how to analyze data in
Tableau, like what makes you different.
197
:And that's really what's gonna make
you stand out is having a portfolio,
198
:a good LinkedIn and a good resume.
199
:So personally, that's kind of what I
would focus on instead of what most
200
:people are focusing on right now in
this:
201
:competitive to actually land a data job.
202
:If this resonated with you and you're
like, yes, I want to actually do this.
203
:I'm interested in creating a portfolio.
204
:I'm interested in only learning some
of the skills and then learning on
205
:the job and getting paid to learn.
206
:I actually run a bootcamp where I teach
people exactly how to do this from
207
:zero to landing their first shaded job.
208
:We'll create a bunch of projects together.
209
:We'll put 'em on a portfolio.
210
:We'll update your LinkedIn, we'll update
your resume, give you templates for both
211
:of those, and help you network in cold
message recruiters and hiring managers
212
:to actually land that first data job.
213
:If you're interested in learning
with me, you can check it out
214
:at data crew drums sot.com/daa,
215
:or you can go to the show notes
down below and click to learn more.