135: You Need This Data Analyst Roadmap (ft. AI)

Avery: 00:00:00

I am AI Avery, and you need to follow this data analyst roadmap.

2

: 00:00:04

No, just kidding.

3

: 00:00:05

It's just regular.

4

: 00:00:06

Avery.

5

: 00:00:06

I'm not ai.

6

: 00:00:08

Or am I?

7

: 00:00:09

Today I created a data

analyst roadmap using AI.

8

: 00:00:12

Now it's not only just a roadmap, it's

actually a podcast episode and we're

9

: 00:00:16

going to get into that here in a second.

10

: 00:00:18

It was created only using AI.

11

: 00:00:20

What I did is I took my data

analyst roadmap that I give to

12

: 00:00:24

my students and anyone that's

following me on social media.

13

: 00:00:26

It is a 10 week plan to help you land your

day to job in less than a hundred days.

14

: 00:00:31

I took that PDF and I uploaded it to

Google's notebook LM, which allows you

15

: 00:00:36

with one button to create a dynamic

host podcast, where they're actually

16

: 00:00:40

talking about the PDFs that you uploaded.

17

: 00:00:43

If you've never seen this tool

before, check out this clip right

18

: 00:00:46

here, where these two AI avatar

podcasters are learning that they are.

19

: 00:00:51

are actually AI and not

actually real humans.

20

: 00:00:54

Look, I, I'm just going to say it.

21

: 00:00:55

Yeah, rip the band aid off.

22

: 00:00:56

We were informed by, uh, by the show's

producers that we, we're not human.

23

: 00:01:02

We're not real.

24

: 00:01:04

We're AI, artificial intelligence.

25

: 00:01:06

So the ideas in this episode are all

mine, but they are presented to you by two

26

: 00:01:10

AI avatar hosts that discuss my roadmap

and kind of give interesting insights.

27

: 00:01:15

I actually think it's really neat.

28

: 00:01:17

Now I do want to preface

this that it's not perfect.

29

: 00:01:20

Like.

30

: 00:01:21

All sorts of AI is definitely not perfect.

31

: 00:01:23

In fact, at one point, uh, I think,

uh, towards the end, the hosts say

32

: 00:01:27

to each other, So it's like you're

speaking their language, but with data.

33

: 00:01:31

Yes, exactly.

34

: 00:01:32

It's like you're speaking

their language, but with data.

35

: 00:01:34

It's absolutely hilarious.

36

: 00:01:35

But I was actually amazed.

37

: 00:01:37

At how good and like how interesting

the conversation sounds, especially

38

: 00:01:42

from an audio perspective.

39

: 00:01:43

If you're watching this on YouTube, the

avatars, I think have a long way to go.

40

: 00:01:47

If you're just listening though, man,

the experience is absolutely incredible.

41

: 00:01:51

And this is such a cool tool that I

think everyone should really check out.

42

: 00:01:54

If you guys want a copy of my

actual roadmap PDF, check out the

43

: 00:01:58

show notes down below so I can send

that to you for absolutely free.

44

: 00:02:01

And with that, let's turn it

over to the AI podcasters.

45

: 00:02:04

AI Lady: Okay, so you want to be a data

analyst and you found this roadmap.

46

: 00:02:08

AI man: Smart move.

47

: 00:02:08

AI Lady: Right.

48

: 00:02:09

It's a hot field, no doubt.

49

: 00:02:11

And this roadmap lays

out a serious game plan.

50

: 00:02:15

But you know what surprised me

when I looked at this thing?

51

: 00:02:18

Week one, it's not about

jumping into Python or SQL.

52

: 00:02:21

It's about understanding all the

different data jobs out there.

53

: 00:02:25

AI man: Yeah.

54

: 00:02:25

It's like walking into

a really good bakery.

55

: 00:02:27

AI Lady: Right.

56

: 00:02:27

AI man: Right.

57

: 00:02:28

You wouldn't just grab

the first thing you see.

58

: 00:02:29

AI Lady: I love that.

59

: 00:02:30

You

60

: 00:02:30

AI man: want to kind of browse

and see what looks good to

61

: 00:02:32

you, what speaks to you.

62

: 00:02:33

And it's the same with data careers.

63

: 00:02:34

AI Lady: Okay, so break that down for me.

64

: 00:02:36

Why is it so important to

understand all the different data

65

: 00:02:39

roles, especially this early on?

66

: 00:02:42

AI man: Well, because it's about

finding the right fit for you.

67

: 00:02:46

You know, this roadmap is about

becoming a data analyst, but that

68

: 00:02:50

can mean a lot of things, right?

69

: 00:02:51

Like maybe you're into marketing analytics

or perhaps finance is more your thing.

70

: 00:02:56

Understanding the nuances helps

you focus your skill development

71

: 00:02:58

and really target your job search.

72

: 00:03:00

AI Lady: So it's about

strategy from day one.

73

: 00:03:02

AI man: Exactly.

74

: 00:03:02

Exactly.

75

: 00:03:04

And you know what else

is part of that strategy?

76

: 00:03:06

Week 1 throws in this 1 2 punch.

77

: 00:03:09

LinkedIn and portfolio building.

78

: 00:03:11

AI Lady: Yeah, that threw me.

79

: 00:03:12

It seems so early, because most

people I know think LinkedIn

80

: 00:03:15

is just for when you're, like,

actively searching for a new job.

81

: 00:03:19

AI man: Yeah, well that's

old school thinking.

82

: 00:03:20

AI Lady: Okay.

83

: 00:03:21

AI man: Today, your LinkedIn,

that's like your digital storefront,

84

: 00:03:25

especially in the data world.

85

: 00:03:26

AI Lady: Mm.

86

: 00:03:27

AI man: You know, this roadmap

actually talks about optimizing

87

: 00:03:29

for applicant tracking systems.

88

: 00:03:31

AI Lady: Oh, yeah.

89

: 00:03:32

AI man: Which sounds super technical.

90

: 00:03:34

Yeah.

91

: 00:03:34

Yeah.

92

: 00:03:34

But it's really just about making

sure your profile speaks the

93

: 00:03:37

language of those algorithms that

companies use to find people.

94

: 00:03:40

AI Lady: So it's like SEO for your career.

95

: 00:03:42

AI man: Exactly.

96

: 00:03:43

And having a portfolio, even if it's just

starting out shows, you're not all taught.

97

: 00:03:47

You're actually applying your skills

to real projects, even small ones.

98

: 00:03:52

It shows initiative.

99

: 00:03:54

AI Lady: Okay.

100

: 00:03:54

That makes a lot of sense.

101

: 00:03:55

AI man: Yeah.

102

: 00:03:55

AI Lady: So week two is where we get our

ds dirty with Excel, but it's: 2024

103

: 00:04:00

There are so many fancy

data science tools.

104

: 00:04:03

Is Excel really still relevant?

105

: 00:04:05

AI man: Absolutely.

106

: 00:04:06

AI Lady: Really?

107

: 00:04:06

AI man: Yeah.

108

: 00:04:06

It's like the Swiss army

knife of data analysis.

109

: 00:04:09

Yeah.

110

: 00:04:09

I mean, yeah, there are more specialized

tools, but Excel is everywhere,

111

: 00:04:13

especially for things like data cleaning,

basic analysis, and quick reports.

112

: 00:04:16

Okay.

113

: 00:04:17

Plus, understanding how to structure

data work with formulas, pivot tables.

114

: 00:04:22

Those are skills that you can

use in any data analysis tool.

115

: 00:04:25

AI Lady: It's about

building that foundation.

116

: 00:04:27

AI man: Exactly.

117

: 00:04:28

And I like that this roadmap

doesn't just throw theory at you.

118

: 00:04:31

It has you building a real

world sales project in Excel.

119

: 00:04:34

AI Lady: So you're not just reading

about pivot tables, you're using

120

: 00:04:37

them to analyze data, to find trends,

and maybe even make recommendations.

121

: 00:04:41

Yeah,

122

: 00:04:41

AI man: exactly.

123

: 00:04:41

It's showing you can apply those skills.

124

: 00:04:43

And it gives you something

for your portfolio.

125

: 00:04:45

AI Lady: That's a really good

point because it's one thing

126

: 00:04:47

to say you're good at Excel.

127

: 00:04:48

It's another thing to show a

potential employer, this is how I've

128

: 00:04:53

used it to solve a real problem.

129

: 00:04:55

Okay.

130

: 00:04:55

So moving on to week three,

things are getting visual, we're

131

: 00:04:59

talking data visualization and

getting comfortable with Tableau.

132

: 00:05:02

What's the connection and why

is this important so early on?

133

: 00:05:06

AI man: Well data analysis isn't

just about the numbers themselves.

134

: 00:05:09

It's about finding the story.

135

: 00:05:11

In the data and telling that story

in a way that people can understand.

136

: 00:05:16

That's where data visualization comes in.

137

: 00:05:17

AI Lady: It's about

making data digestible.

138

: 00:05:19

Yes.

139

: 00:05:19

Turning it into something

that clicks for people.

140

: 00:05:21

AI man: Exactly.

141

: 00:05:22

And Tableau is amazing for that.

142

: 00:05:24

But.

143

: 00:05:25

This roadmap doesn't just

throw you into Tableau.

144

: 00:05:28

Yeah.

145

: 00:05:29

It starts with the fundamentals

of data visualization.

146

: 00:05:32

So you're thinking about what kind

of chart to use, how to use color

147

: 00:05:34

effectively, and designing dashboards

that are both informative and look good.

148

: 00:05:40

AI Lady: So it's like learning

grammar before you write an essay.

149

: 00:05:43

AI man: That's a great way to put it.

150

: 00:05:44

It's about making sure you

can communicate your insights.

151

: 00:05:46

AI Lady: Yeah.

152

: 00:05:47

AI man: Because even if you have

the best analysis, if you can't

153

: 00:05:50

communicate it, it's not very useful.

154

: 00:05:52

AI Lady: So we've laid

the foundation with Excel.

155

: 00:05:54

We're starting to speak the language

of data visualization, and then weeks

156

: 00:05:58

four and five hit us with SQL two

whole weeks, wide, intense focus.

157

: 00:06:04

AI man: Because SQL is how you unlock

insights from databases, which is

158

: 00:06:09

where most businesses keep their data.

159

: 00:06:11

It's how you get the exact data

you need, and then you can analyze

160

: 00:06:14

it to answer those questions that

would be impossible to do manually.

161

: 00:06:17

AI Lady: Okay.

162

: 00:06:17

I'm starting to understand

just how important SQL is.

163

: 00:06:21

The roadmap doesn't mess around either.

164

: 00:06:23

Going from basic queries in week 4 to

some pretty advanced stuff in week 5.

165

: 00:06:28

AI man: It's ambitious.

166

: 00:06:29

AI Lady: Yeah.

167

: 00:06:29

AI man: But think of it this way.

168

: 00:06:31

Mastering SQL is like getting access

to a secret vault of information.

169

: 00:06:35

You're not limited to what

you see on the surface.

170

: 00:06:38

You can dig deeper.

171

: 00:06:39

Connect the dots and find

those hidden patterns.

172

: 00:06:41

AI Lady: It's like being a data detective.

173

: 00:06:43

Exactly.

174

: 00:06:44

I love that.

175

: 00:06:44

And

176

: 00:06:44

AI man: you know what?

177

: 00:06:45

This roadmap even recommends

a tool called csvfiddle.

178

: 00:06:49

io.

179

: 00:06:49

Oh

180

: 00:06:49

AI Lady: yeah, I've heard of that.

181

: 00:06:50

AI man: It's free and you can practice

writing SQL queries right in your browser.

182

: 00:06:54

AI Lady: That is really handy.

183

: 00:06:55

AI man: Yeah, no complicated setup

or anything super user friendly.

184

: 00:06:58

AI Lady: All right, so we've got

our LinkedIn profile looking good.

185

: 00:07:00

We're getting comfortable with Excel.

186

: 00:07:02

We're speaking the language

of data visualization and SQL.

187

: 00:07:04

And then this roadmap

throws us a curveball.

188

: 00:07:07

Week five again.

189

: 00:07:09

We're applying for jobs

190

: 00:07:11

AI man: time.

191

: 00:07:11

AI Lady: Five weeks in already.

192

: 00:07:12

That's early.

193

: 00:07:13

Most people wait until they feel ready.

194

: 00:07:15

But this road map has you diving

right into the job market.

195

: 00:07:19

Why that early blitz five weeks in

and already hitting the pavement.

196

: 00:07:23

That's a bold move.

197

: 00:07:24

Most people wait until they feel ready.

198

: 00:07:26

But this road map has you diving right

into the deep end of the job market.

199

: 00:07:30

What's the strategy

behind that early blitz?

200

: 00:07:33

AI man: Well, it's like

learning to ride a bike.

201

: 00:07:35

You can read the manual a

hundred times, but nothing beats

202

: 00:07:37

actually getting on and pedaling.

203

: 00:07:39

AI Lady: Right.

204

: 00:07:39

AI man: The job search is similar.

205

: 00:07:41

You'll learn so much more by actually

going through it, applying, going

206

: 00:07:44

to interviews, getting feedback.

207

: 00:07:46

AI Lady: So it's about iterative

learning, using the process itself

208

: 00:07:49

to kind of refine your approach.

209

: 00:07:51

AI man: Exactly.

210

: 00:07:52

Each application, each interview is

a chance to learn, adapt, improve.

211

: 00:07:56

Plus, starting early

gives you a head start.

212

: 00:07:59

You're not waiting until the last

minute when the pressure is really on.

213

: 00:08:01

AI Lady: Right.

214

: 00:08:02

AI man: You're building

relationships, getting your name

215

: 00:08:04

out there, and who knows, you

might uncover some opportunities

216

: 00:08:07

you wouldn't have found otherwise.

217

: 00:08:08

AI Lady: And I noticed this roadmap

encourages focusing on in person or

218

: 00:08:13

hybrid roles in those early stages.

219

: 00:08:16

Why is that?

220

: 00:08:18

AI man: Those rules can be

less competitive, especially

221

: 00:08:19

for someone just starting out.

222

: 00:08:21

Think about it.

223

: 00:08:22

Companies hiring for in person or hybrid

roles, they often care a lot about

224

: 00:08:26

collaboration, mentorship, cultural fit.

225

: 00:08:28

Those are things that are

easier to assess face to face.

226

: 00:08:31

Right.

227

: 00:08:32

It's like you're using those

dynamics to your advantage.

228

: 00:08:34

AI Lady: Exactly.

229

: 00:08:35

It's about being strategic.

230

: 00:08:37

Okay.

231

: 00:08:37

So after that initial application push,

the roadmap takes an interesting turn.

232

: 00:08:42

December rolls around and we're

introduced to Python R Power BI Sats.

233

: 00:08:46

A

234

: 00:08:47

AI man: lot of tools.

235

: 00:08:48

AI Lady: Right.

236

: 00:08:49

But it's not about mastering any of them.

237

: 00:08:50

It's more about getting a taste.

238

: 00:08:52

AI man: It's like a tasting

menu for data analysis tools.

239

: 00:08:55

You get to sample the different

flavors, see what you like, what

240

: 00:08:58

you might want to explore further.

241

: 00:08:59

I like that.

242

: 00:09:00

This stage isn't about becoming a Python

expert or a Power BI guru overnight.

243

: 00:09:05

It's about understanding what Python is.

244

: 00:09:07

What each tool is good at and how

they fit into the bigger picture.

245

: 00:09:10

AI Lady: So it's about breadth

over depth at this point, becoming

246

: 00:09:12

familiar with the tools of the trades.

247

: 00:09:14

So you can talk about them in interviews.

248

: 00:09:16

AI man: The data world changes so fast,

new tools are coming out all the time.

249

: 00:09:19

AI Lady: Always something new.

250

: 00:09:20

AI man: Having that understanding of

different tools makes you more adaptable.

251

: 00:09:23

AI Lady: Yeah.

252

: 00:09:24

It's about future proofing your skills.

253

: 00:09:27

Now, finally, this roadmap

culminates in a capstone project.

254

: 00:09:30

But this isn't just any project.

255

: 00:09:32

It's about taking everything

you've learned and showcasing your

256

: 00:09:36

skills within your chosen industry.

257

: 00:09:38

Talk to me about that industry focus.

258

: 00:09:39

AI man: Okay.

259

: 00:09:40

So anyone can learn the technical stuff,

but what makes you stand out, what makes

260

: 00:09:45

you valuable to a company is being able

to apply those skills in the real world.

261

: 00:09:50

That's where the industry focus comes in.

262

: 00:09:52

AI Lady: So it's about showing that.

263

: 00:09:54

You understand their world.

264

: 00:09:55

AI man: Yes.

265

: 00:09:56

It's about showing that you get

their industry, their challenges,

266

: 00:09:59

their opportunities, and how data

can be used to tackle those things.

267

: 00:10:03

AI Lady: So instead of just saying, I

can analyze data, you're saying, I can

268

: 00:10:06

analyze data to help your healthcare

company improve patient outcomes.

269

: 00:10:10

Or, I can help your marketing

agency optimize their campaign.

270

: 00:10:14

AI man: Exactly.

271

: 00:10:14

You're speaking their

language, but with data.

272

: 00:10:16

AI Lady: It's like you're speaking

their language, but with data.

273

: 00:10:20

You're showing them you can

bridge that gap between the

274

: 00:10:22

technical and the practical.

275

: 00:10:23

AI man: Exactly.

276

: 00:10:24

And that's the difference between being

a data analyst and being a data analyst

277

: 00:10:28

who can drive real business value.

278

: 00:10:30

And that's what this capstone

project is all about.

279

: 00:10:33

It's your chance to take everything

you've learned, the technical

280

: 00:10:37

skills, the industry, knowledge,

the insights from your job

281

: 00:10:40

search, and bring it all together.

282

: 00:10:42

AI Lady: So it's like the final

boss battle in a video game.

283

: 00:10:45

I like that.

284

: 00:10:45

You've leveled up your skills,

you've got all the best weapons,

285

: 00:10:48

and you're ready for the challenge.

286

: 00:10:50

AI man: And just like a video

game, the rewards for beating

287

: 00:10:53

that final boss are huge.

288

: 00:10:55

A well done capstone project

that's focused on your industry.

289

: 00:10:59

That's the crown jewel of your portfolio.

290

: 00:11:01

It shows employers that you're

not just another applicant.

291

: 00:11:04

You're a problem solver.

292

: 00:11:05

You're a strategic thinker.

293

: 00:11:07

A data driven decision maker.

294

: 00:11:08

AI Lady: You're not just

looking for any job.

295

: 00:11:10

You're looking for the right

opportunity to make a real impact.

296

: 00:11:13

AI man: Exactly.

297

: 00:11:13

And that's what I love about this roadmap.

298

: 00:11:16

It's not just about getting you a job.

299

: 00:11:17

It's about setting you up for

success in the long run in

300

: 00:11:20

this exciting world of data.

301

: 00:11:22

AI Lady: This has been amazing.

302

: 00:11:23

But for our listener, who's maybe

feeling a little overwhelmed

303

: 00:11:26

right now, it's a lot to take in.

304

: 00:11:29

What's the one thing they

should take away from this?

305

: 00:11:31

What's that one piece of

advice to keep them going?

306

: 00:11:34

AI man: Don't feel like you have

to master everything at once.

307

: 00:11:37

This roadmap is a journey, right?

308

: 00:11:39

And like any journey, it's about taking

that first step and enjoying the ride.

309

: 00:11:43

Love it.

310

: 00:11:44

Start with what you can do today.

311

: 00:11:46

Update your LinkedIn.

312

: 00:11:47

Maybe brush up on your Excel skills.

313

: 00:11:49

Dive into a small project.

314

: 00:11:51

Momentum builds momentum.

315

: 00:11:52

Be progress, not perfection.

316

: 00:11:53

Exactly.

317

: 00:11:55

Embrace the learning, stay curious,

and remember, the world needs more

318

: 00:11:59

data driven thinkers like you.

319

: 00:12:01

So go out there and make some magic happen

with data, and have fun along the way.

320

: 00:12:05

AI Lady: Couldn't have

said it better myself.

321

: 00:12:07

And there you have it.

322

: 00:12:08

Your roadmap to becoming a data

analyst broken down step by step.

323

: 00:12:12

Remember, the data world

is waiting for you.

324

: 00:12:14

Go make your mark.

325

: 00:12:15

Avery: All right.

326

: 00:12:15

Now that was something.

327

: 00:12:17

I want to know your guys feedback.

328

: 00:12:19

If you're watching on YouTube, please go

to the comments down below and tell me

329

: 00:12:22

what you thought about this experiment.

330

: 00:12:24

If you're on Spotify, you can

Share Episode

Shownotes

Transcripts

Follow

Links

Chapters

Video

More from YouTube