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://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: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:

Join the February Cohort

Join the bootcamp that lands people data jobs! February Cohort starts on February 9th with a live kickoff call. Join today and save big and get my mock interview software as a bonus!

https://www.datacareerjumpstart.com/daa

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

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.