195: If I Wanted To Become a Data Analyst in 2026, This Is What I'd Do

Speaker 2: 00:00:00

If I wanted to become a data analyst in 2026,

2

00:00:03,240 --> 00:00:04,980

here's exactly what I would do.

3

00:00:05,100 --> 00:00:07,290

I'd break it down into two separate parts.

4

00:00:07,320 --> 00:00:11,970

Number one is the, what do I actually

need to know to become a data analyst?

5

00:00:12,180 --> 00:00:16,020

The skills, and number two is

how do I actually stand out

6

00:00:16,200 --> 00:00:17,940

first, what do you need to learn?

7

00:00:18,270 --> 00:00:19,140

Where should you learn it?

8

00:00:19,320 --> 00:00:23,070

The biggest thing when it comes to

becoming a data analyst is actually

9

00:00:23,070 --> 00:00:25,620

knowing the tools to analyze the data.

10

00:00:25,935 --> 00:00:30,225

Not only knowing the tools, but also

having the mindset of a data analyst.

11

00:00:30,315 --> 00:00:34,545

And in my opinion, those are actually

both learned best through doing

12

00:00:34,605 --> 00:00:36,885

projects and real life examples.

13

00:00:36,945 --> 00:00:40,365

A project is basically like a use

case or an actual like real world

14

00:00:40,365 --> 00:00:42,465

example of you analyzing data.

15

00:00:42,615 --> 00:00:47,745

I'm not a really big fan of like all of

these silly online tutorials and all these

16

00:00:47,745 --> 00:00:50,144

silly like, oh yeah, like step-by-step.

17

00:00:50,144 --> 00:00:52,215

This is this little sandbox

and this is how you do this

18

00:00:52,215 --> 00:00:52,905

and this is how you do that.

19

00:00:52,995 --> 00:00:54,975

I just don't feel like

it's super realistic.

20

00:00:55,004 --> 00:00:55,635

I personally.

21

00:00:55,695 --> 00:00:58,545

Learn best by doing

hands-on real practice.

22

00:00:58,575 --> 00:01:00,135

And so I think why not

just start with that?

23

00:01:00,315 --> 00:01:03,405

I also wouldn't learn everything

because there's so many different

24

00:01:03,405 --> 00:01:06,705

things you could be learning, and my

old philosophy is we need to get your

25

00:01:06,705 --> 00:01:10,545

foot in the door as quickly as possible

so that way you can start to get paid.

26

00:01:10,830 --> 00:01:12,149

To learn on the job.

27

00:01:12,240 --> 00:01:14,789

Like if you're going to try to

learn everything before you feel

28

00:01:14,789 --> 00:01:18,030

ready to apply to data analyst jobs,

you're gonna be like 89 years old

29

00:01:18,030 --> 00:01:19,350

before you start applying for jobs.

30

00:01:19,350 --> 00:01:22,560

And, uh, I don't know about you, but

I don't wanna be working when I'm 89.

31

00:01:22,560 --> 00:01:25,860

So you first need to shrink the amount

of things that you're going to learn.

32

00:01:25,890 --> 00:01:28,590

So in my opinion, the first thing that you

should learn is excel, just 'cause it's

33

00:01:28,590 --> 00:01:30,360

really easy and it's really in demand.

34

00:01:30,509 --> 00:01:34,560

Second thing you should learn is Tableau

or Power bi, because they are also very

35

00:01:34,560 --> 00:01:35,970

in demand and pretty easy to learn.

36

00:01:35,970 --> 00:01:38,759

And the third thing you should learn

is sql, because once again, pretty

37

00:01:38,759 --> 00:01:40,590

easy to learn and pretty in demand.

38

00:01:40,670 --> 00:01:43,640

I think you should put R

and Python on the shelf.

39

00:01:43,640 --> 00:01:46,610

And honestly, anything, any other

tool really on the shelf right

40

00:01:46,610 --> 00:01:50,479

now, just start with those big

three, uh, BI tool, Excel and sql.

41

00:01:50,479 --> 00:01:54,560

Ignore everything else because it's just

gonna keep you in the study tutorial.

42

00:01:54,560 --> 00:01:56,360

Hell, for a long time.

43

00:01:56,509 --> 00:01:59,660

Not only would I be learning those

things, I would just be trying to learn

44

00:01:59,660 --> 00:02:02,510

to think as a data analyst, so when I

get a data set, you know, what does it

45

00:02:02,510 --> 00:02:04,130

actually mean to clean the data set?

46

00:02:04,130 --> 00:02:05,360

What things should I be looking for?

47

00:02:05,365 --> 00:02:08,424

Or in the data set that might

make it dirty or hard to analyze.

48

00:02:08,574 --> 00:02:11,755

Then I, based on the data set I

have, I would start to already think

49

00:02:11,755 --> 00:02:14,515

through what are the different things

that I can do with this data set.

50

00:02:14,515 --> 00:02:18,415

So, for example, if you have a date

column, you automatically know, hey, this

51

00:02:18,415 --> 00:02:19,915

is some sort of a time series data set.

52

00:02:20,005 --> 00:02:23,545

I can do some sort of a time series

analysis, like create a line chart or

53

00:02:23,545 --> 00:02:26,875

do some sort of predictive modeling

like arima to predict, you know, how

54

00:02:26,875 --> 00:02:28,704

this trend will continue down the road.

55

00:02:28,704 --> 00:02:30,265

You know, five Decembers from now.

56

00:02:30,265 --> 00:02:32,454

Like what is their numbers

actually going to look like.

57

00:02:32,635 --> 00:02:35,365

If you have categories,

you can say, okay, like.

58

00:02:35,605 --> 00:02:38,845

What was this quantitative

variable, like some sort of a

59

00:02:38,845 --> 00:02:41,125

price or some sort of a number?

60

00:02:41,185 --> 00:02:43,945

How does that number change

the different categories?

61

00:02:43,945 --> 00:02:47,725

So like if you have like a blue

product and a red product, like

62

00:02:47,725 --> 00:02:50,275

did the blue product sell more

or did the red product sell more?

63

00:02:50,305 --> 00:02:52,704

You know, what were the different

margins on each of those?

64

00:02:52,704 --> 00:02:55,435

Like those are the different

things that you can start to try

65

00:02:55,435 --> 00:02:57,145

to learn to think as an analyst.

66

00:02:57,480 --> 00:03:01,530

In my opinion, it's actually really

hard to learn to think of an analyst.

67

00:03:01,590 --> 00:03:05,430

Learning the skills is not

easy, but it's a lot easier than

68

00:03:05,430 --> 00:03:06,690

learning to think like an analyst.

69

00:03:06,750 --> 00:03:09,540

The only way I really try to teach

other people to think as an analyst

70

00:03:09,600 --> 00:03:12,870

is one, give them realistic examples

where they can actually go through

71

00:03:12,870 --> 00:03:15,540

the process step by step of like,

oh, okay, I kind of get this.

72

00:03:15,540 --> 00:03:16,230

I kind of get this.

73

00:03:16,260 --> 00:03:19,470

And the other one is what I call project

hacking, which is basically you see

74

00:03:19,470 --> 00:03:22,710

someone else's analysis and read through

what they did, and you think, oh, okay.

75

00:03:22,800 --> 00:03:23,610

And you do that enough.

76

00:03:23,610 --> 00:03:26,160

Eventually you start to think like

an analyst, like there's no magic

77

00:03:26,160 --> 00:03:27,030

bullet, there's no framework.

78

00:03:27,329 --> 00:03:30,240

I can give you right now that's

gonna help you think like an analyst.

79

00:03:30,300 --> 00:03:31,680

It just comes with experience.

80

00:03:31,740 --> 00:03:35,220

And experience is just the amount

of time that you, uh, have hands-on

81

00:03:35,220 --> 00:03:39,210

analyzing data or hands-on reading

someone else analyzing data.

82

00:03:39,270 --> 00:03:41,610

I think those are like the

only two ways that you can

83

00:03:41,610 --> 00:03:42,615

start to think like an analyst.

84

00:03:43,195 --> 00:03:46,464

Now, I'm not a big fan of

certificates because I actually

85

00:03:46,464 --> 00:03:47,725

don't have any certificates.

86

00:03:47,725 --> 00:03:50,065

Like I don't have the Google

Data Analytics certificate.

87

00:03:50,214 --> 00:03:53,575

I don't have any like Comier,

TIA certificates, I can't

88

00:03:53,575 --> 00:03:54,445

even say the name, right.

89

00:03:54,595 --> 00:03:56,125

I don't have an IBM certificate.

90

00:03:56,125 --> 00:03:57,265

I don't have a meta certificate.

91

00:03:57,415 --> 00:04:02,065

I literally have zero certificates, landed

all of my data jobs in my corporate.

92

00:04:02,340 --> 00:04:03,990

Career without a certificate.

93

00:04:04,170 --> 00:04:08,519

And I don't think certificates are really

built to teach you the best because I

94

00:04:08,519 --> 00:04:11,640

don't feel like they're very hands-on

project DI feel like they're kind of

95

00:04:11,640 --> 00:04:14,190

unrealistic, kind of handholding baby.

96

00:04:14,430 --> 00:04:17,760

Uh, and I just think people

like are like, oh, like I need a

97

00:04:17,760 --> 00:04:19,110

certificate to be a data analyst.

98

00:04:19,110 --> 00:04:19,529

No, you don't.

99

00:04:19,875 --> 00:04:23,445

You literally don't, and if you think

that having a certificate is gonna make

100

00:04:23,445 --> 00:04:26,565

a difference, I don't think it is because

it's never made a difference in my career.

101

00:04:26,655 --> 00:04:29,265

I've talked to a lot of hiring managers

and recruiters, they don't really care.

102

00:04:29,265 --> 00:04:32,235

There's no like standardized certificates

to have in data analytics field.

103

00:04:32,235 --> 00:04:36,284

So personally, I think doing hands-on

projects is infinitely better than

104

00:04:36,344 --> 00:04:37,695

doing these silly certificates.

105

00:04:38,219 --> 00:04:42,090

That actually leads me into the second

half, which is okay, let's say you learn

106

00:04:42,090 --> 00:04:44,880

Excel, you learn sql, you learn Tableau.

107

00:04:45,060 --> 00:04:45,480

Great.

108

00:04:45,810 --> 00:04:47,400

But how do you actually stand out now?

109

00:04:47,400 --> 00:04:51,270

Because the data analyst job market is

very competitive, especially kind of at

110

00:04:51,270 --> 00:04:53,610

that entry level junior data analyst role.

111

00:04:53,610 --> 00:04:55,140

Like how do you actually stand out?

112

00:04:55,170 --> 00:04:56,760

And I think there's a

couple different keys here.

113

00:04:56,820 --> 00:05:00,599

I think one of them is to

actually broaden your job search.

114

00:05:00,675 --> 00:05:04,185

Because literally you guys, everyone

is looking to become a data analyst,

115

00:05:04,275 --> 00:05:07,755

but there's like literally 20 different

titles that you could be searching

116

00:05:07,755 --> 00:05:11,745

for that aren't exactly data analysts,

but basically they're a fancy title

117

00:05:11,745 --> 00:05:13,155

to say that you're a data analyst.

118

00:05:13,215 --> 00:05:16,155

I can't list them all right here, but

business intelligence engineer, financial

119

00:05:16,155 --> 00:05:19,305

analyst, product analyst, pricing analyst,

a lot of things that have the word analyst

120

00:05:19,305 --> 00:05:21,105

in it are going to be good for you.

121

00:05:21,255 --> 00:05:23,160

Um, because a lot of the

times it's just like, hey.

122

00:05:23,495 --> 00:05:27,125

Data analyst role plus domain

smash together, get a new title.

123

00:05:27,155 --> 00:05:29,435

And a lot of people aren't

looking for those roles.

124

00:05:29,645 --> 00:05:33,245

So they're less competitive, but they're

literally the jobs you're looking for.

125

00:05:33,395 --> 00:05:36,695

Now I have proof of this because

I actually run a data job board.

126

00:05:36,695 --> 00:05:38,284

It's called Find a Data job.com.

127

00:05:38,284 --> 00:05:40,595

We post about 30 data jobs a day.

128

00:05:40,715 --> 00:05:44,615

Um, we try to include a lot of these like

kind of alternative data analyst roles.

129

00:05:44,695 --> 00:05:47,724

And I actually have all the data, all

the click data of you guys going to

130

00:05:47,724 --> 00:05:49,075

that website and what do you click on?

131

00:05:49,135 --> 00:05:52,344

And it's actually unproportional

data analyst roles.

132

00:05:52,375 --> 00:05:56,094

Like if it literally says data

analysts, those get like, I think two

133

00:05:56,094 --> 00:05:59,034

to three times more clicks than like

a financial analyst or a business

134

00:05:59,034 --> 00:06:01,675

analyst or a marketing analyst or a

pricing analyst or something like that.

135

00:06:01,735 --> 00:06:04,195

And literally, the job

description could be the same.

136

00:06:04,225 --> 00:06:08,275

It's just everyone loves the title data

analyst and that's what they're used to.

137

00:06:08,275 --> 00:06:09,685

And we just love what we're used to.

138

00:06:09,685 --> 00:06:10,645

So I would say.

139

00:06:11,115 --> 00:06:14,715

Try to apply less to like data

analyst roles and more of these like

140

00:06:14,715 --> 00:06:18,825

niche terms that basically mean data

analysts but aren't data analysts.

141

00:06:19,005 --> 00:06:20,985

The other thing you're gonna have to

figure out is like how do you convince

142

00:06:20,985 --> 00:06:25,245

the hiring manager or recruiter that

you can do what a job description says

143

00:06:25,305 --> 00:06:28,485

that, that you need to do because you

don't have prior experience, right?

144

00:06:28,485 --> 00:06:29,925

So it's like the cycle of doom, right?

145

00:06:29,925 --> 00:06:32,685

I can't get a data job because

I don't have data experience.

146

00:06:32,685 --> 00:06:34,065

Well, why can't you get data experience?

147

00:06:34,065 --> 00:06:35,925

It's like, oh, it's 'cause

I don't have a data job.

148

00:06:35,925 --> 00:06:39,284

So you're in this never ending

cycle and it's like you need

149

00:06:39,284 --> 00:06:40,695

someone to take a chance on you.

150

00:06:40,780 --> 00:06:44,619

But in order for someone to take a

chance on you, you actually need trust.

151

00:06:44,770 --> 00:06:48,940

And trust is hard to get, especially

when you don't know someone, right?

152

00:06:49,000 --> 00:06:52,239

We trust people that we know, and

you're going to be applying to

153

00:06:52,299 --> 00:06:54,729

recruiters and hiring managers

who don't even know you at all.

154

00:06:54,729 --> 00:06:55,599

They don't even know your face.

155

00:06:55,659 --> 00:06:56,619

They hardly know your name.

156

00:06:56,619 --> 00:06:59,440

They just know A PDF that you

gave them with some stuff on it.

157

00:06:59,469 --> 00:07:00,190

So that's where like.

158

00:07:00,365 --> 00:07:03,425

Really doing a good job on your

resume, really doing a good job on your

159

00:07:03,425 --> 00:07:07,115

LinkedIn, maybe trying to send cold

messages and actually networking, right?

160

00:07:07,115 --> 00:07:10,505

Like if you can get a cold message

to a recruit hiring manager that they

161

00:07:10,505 --> 00:07:14,525

actually like, that puts you so much

far against all the other competitors.

162

00:07:14,585 --> 00:07:18,305

If you can have like a friend or a

family member kind of refer you, then

163

00:07:18,305 --> 00:07:19,775

all of a sudden you're more trusted.

164

00:07:19,775 --> 00:07:21,275

'cause they probably

already trust that person.

165

00:07:21,275 --> 00:07:24,515

So like you need to come up with a

game plan to actually get trusted

166

00:07:24,515 --> 00:07:26,105

by a recruiter or a hiring manager.

167

00:07:26,105 --> 00:07:28,295

And that is hard to do, like I said.

168

00:07:28,350 --> 00:07:30,930

Updating your resume, making

it really good, making sure

169

00:07:30,930 --> 00:07:32,040

your LinkedIn is really good.

170

00:07:32,070 --> 00:07:34,110

And then the last thing I

think is creating a portfolio.

171

00:07:34,110 --> 00:07:36,390

So remember we talked about those

projects earlier, how it's the best way

172

00:07:36,390 --> 00:07:40,680

to learn, creating those projects and

then putting 'em on a online portfolio

173

00:07:40,710 --> 00:07:44,730

where it's like, Hey, this is literally

tangible evidence that I can do the

174

00:07:44,790 --> 00:07:46,020

what the job description's asking.

175

00:07:46,020 --> 00:07:49,140

Like the job description right here,

like look at here is a project.

176

00:07:49,205 --> 00:07:51,935

That I did that basically nears

what the job description is.

177

00:07:52,175 --> 00:07:54,844

And that way you're making yourself

a little bit of less of a risk.

178

00:07:54,844 --> 00:07:57,335

It's like, Hey, look, hiring

manager, you're worried about me.

179

00:07:57,335 --> 00:07:59,615

I've already done this

before and here's the proof.

180

00:07:59,615 --> 00:08:02,135

So like, go ahead and take a

look at the proof right here

181

00:08:02,224 --> 00:08:04,175

and uh, trust me I can do this.

182

00:08:04,234 --> 00:08:07,835

And creating portfolio is

very good for those use cases.

183

00:08:07,835 --> 00:08:11,735

So I think creating portfolio and

networking really come in clutch here.

184

00:08:11,985 --> 00:08:15,285

Unfortunately, I think most people

when they try to become a data analyst,

185

00:08:15,315 --> 00:08:19,215

they do one of these certificates where

they learn some skills in some sort of

186

00:08:19,215 --> 00:08:23,055

like lame tutorial, or they get like

their certificate at the end you're

187

00:08:23,055 --> 00:08:24,735

like, yay, I'm all certified now.

188

00:08:24,735 --> 00:08:28,275

Or they do something like data camp

or something like that, and I just

189

00:08:28,275 --> 00:08:29,925

think you're missing out on projects.

190

00:08:29,955 --> 00:08:31,365

I think you're missing out on portfolios.

191

00:08:31,455 --> 00:08:33,345

I think you're not spending enough time.

192

00:08:33,585 --> 00:08:37,515

Emphasizing your LinkedIn, your,

uh, resume and your networking

193

00:08:37,515 --> 00:08:38,715

and your cold messaging skills.

194

00:08:38,715 --> 00:08:41,505

'cause like those things are really

important because everyone knows

195

00:08:41,505 --> 00:08:43,815

at this point, everyone knows

how to analyze data in Excel.

196

00:08:43,815 --> 00:08:48,075

Everyone knows how to analyze data in

Tableau, like what makes you different.

197

00:08:48,075 --> 00:08:51,015

And that's really what's gonna make

you stand out is having a portfolio,

198

00:08:51,015 --> 00:08:53,505

a good LinkedIn and a good resume.

199

00:08:53,595 --> 00:08:56,745

So personally, that's kind of what I

would focus on instead of what most

200

00:08:56,745 --> 00:09:01,215

people are focusing on right now in

this 2026 era of where it's really

201

00:09:01,215 --> 00:09:02,865

competitive to actually land a data job.

202

00:09:03,275 --> 00:09:06,694

If this resonated with you and you're

like, yes, I want to actually do this.

203

00:09:06,725 --> 00:09:08,375

I'm interested in creating a portfolio.

204

00:09:08,435 --> 00:09:11,795

I'm interested in only learning some

of the skills and then learning on

205

00:09:11,795 --> 00:09:12,964

the job and getting paid to learn.

206

00:09:12,964 --> 00:09:16,834

I actually run a bootcamp where I teach

people exactly how to do this from

207

00:09:16,834 --> 00:09:18,515

zero to landing their first shaded job.

208

00:09:18,545 --> 00:09:19,895

We'll create a bunch of projects together.

209

00:09:19,895 --> 00:09:20,915

We'll put 'em on a portfolio.

210

00:09:20,915 --> 00:09:23,885

We'll update your LinkedIn, we'll update

your resume, give you templates for both

211

00:09:23,885 --> 00:09:27,245

of those, and help you network in cold

message recruiters and hiring managers

212

00:09:27,245 --> 00:09:29,855

to actually land that first data job.

213

00:09:29,910 --> 00:09:32,130

If you're interested in learning

with me, you can check it out

214

00:09:32,130 --> 00:09:34,620

at data crew drums sot.com/daa,

215

00:09:35,130 --> 00:09:37,755

or you can go to the show notes

down below and click to learn more.

Share Episode

Shownotes

Transcripts

Follow

Links

Chapters

Video

More from YouTube