206: Every Data Analyst Tool You Need is FREE

Speaker: 00:00:00

If you're trying to break into data

analytics, you've probably wondered

2

: 00:00:02

how much do all these data tools cost?

3

: 00:00:05

Because when you start adding up

Excel, Tableau, Python, AI tools,

4

: 00:00:09

it starts to sound really expensive.

5

: 00:00:12

But here's the big secret that

they don't want you to know.

6

: 00:00:15

You can get all of these

tools for absolutely free.

7

: 00:00:18

$0 and I'm going to tell you how

today, so we are covering the 10 most

8

: 00:00:23

used data tools, and I'll show you

my exact setup for each and show you

9

: 00:00:26

how you can replicate it on your own.

10

: 00:00:28

We'll cover four categories, spreadsheets,

scripting, business intelligence, and ai.

11

: 00:00:33

And I actually do pay for two of these

tools, so make sure you stick around to

12

: 00:00:37

the end to figure out what tools they

are and why they're worth paying for.

13

: 00:00:40

But let's get started with the

most in demand data tool, Excel.

14

: 00:00:44

And everybody knows Excel.

15

: 00:00:46

What most people don't know is that

you can use it for completely free.

16

: 00:00:50

In fact, Microsoft doesn't want you

to know that you can use it for free.

17

: 00:00:53

It's so unbelievably

hidden on their website.

18

: 00:00:55

They don't ever talk about it at all.

19

: 00:00:56

But don't worry, I have your back.

20

: 00:00:58

I'll have an exact link that you can use

to get access to this free version of

21

: 00:01:01

Excel, along with the other nine data

tools that we'll be covering today.

22

: 00:01:05

It's in the description down below.

23

: 00:01:06

So check it out.

24

: 00:01:07

Welcome to Excel for free on the web.

25

: 00:01:10

This is like the only place I've really

been able to find where it can link

26

: 00:01:13

to, where you can get it for free

and you can just sign in with your

27

: 00:01:16

Microsoft account or create your own.

28

: 00:01:17

And then once you do,

it'll look like this.

29

: 00:01:20

And sure enough, you can

create a a blank workbook.

30

: 00:01:23

You can access all of your other

files that you've done previously.

31

: 00:01:26

So you can see that I've used this.

32

: 00:01:27

In the past, I'll go ahead and

press create blank workbook just to

33

: 00:01:30

show you, but just like that you've

got Excel running in your browser.

34

: 00:01:34

That is one of the biggest downsides to

the free version is it's only in your

35

: 00:01:38

browser, but usually today that's okay.

36

: 00:01:41

Like usually are only working

when there's internet.

37

: 00:01:44

Um, there are some downfalls, like

file sizes in your browser can

38

: 00:01:47

cause things to, to bog down and

be really slow or even not work.

39

: 00:01:51

Um, but other than that, you get formulas,

you get charts, you get pivot tables.

40

: 00:01:54

Um, you can even, you know, share

this with different people by copying

41

: 00:01:58

the link or copy link to the sheet.

42

: 00:02:00

Um, you can manage the access to this.

43

: 00:02:04

You get five gigabytes of

storage basically, of OneDrive

44

: 00:02:07

to store all your files.

45

: 00:02:08

Now of course, you are missing other

things other than just being able to

46

: 00:02:12

use it on your laptop or your desktop.

47

: 00:02:14

Um, and there's a bunch of different

differences between the two.

48

: 00:02:16

To be honest, I couldn't find any

real documented, like this is the

49

: 00:02:20

free version versus the paid version.

50

: 00:02:21

This is what you get.

51

: 00:02:22

Um, so leave a comment down below if

you want me to do a full in depth.

52

: 00:02:26

Free Microsoft Excel versus

paid Microsoft Excel.

53

: 00:02:29

But like, the biggest thing

is you're not gonna be getting

54

: 00:02:30

all of the functions up here.

55

: 00:02:32

Like, uh, you don't have

power query and power pivot.

56

: 00:02:36

Um, you're not gonna have like

VBA macros for automation.

57

: 00:02:40

Uh, the solver and analysis

tool packs are unavailable.

58

: 00:02:43

And of course, once again, you're

not gonna have offline access.

59

: 00:02:45

So there's gonna be some things

that you can't do with the

60

: 00:02:47

free version of Excel, but.

61

: 00:02:48

When you're just trying to learn on

your own, you're building your skills,

62

: 00:02:51

you're practicing formulas, then like

literally everything you need is in here.

63

: 00:02:55

The pivot tables, formulas, vlookup,

all the good stuff you need is going

64

: 00:02:58

to be available in the free version.

65

: 00:03:00

And even if it's not, like this

is a really good way to get

66

: 00:03:03

started without having to pay.

67

: 00:03:04

And then once you need to learn

the stuff that's not in the free

68

: 00:03:07

version, maybe you start paying

$7 a month for the paid version.

69

: 00:03:11

So who knew Excel is free.

70

: 00:03:13

Our next tool is the other big spreadsheet

software, which is Google Sheets.

71

: 00:03:17

And this one's really simple.

72

: 00:03:19

Google Sheets is a hundred percent free.

73

: 00:03:21

Seriously, all you need to

do is go to sheets.google.com

74

: 00:03:24

and sign in and boom,

you're basically done.

75

: 00:03:27

It's all available for you.

76

: 00:03:29

You basically get a full

fledged spreadsheet for $0.

77

: 00:03:32

It has real time collaboration.

78

: 00:03:34

It has 15 gigs of data and storage.

79

: 00:03:36

It has so many different functions.

80

: 00:03:38

Graphs that you can

make up here at the top.

81

: 00:03:40

Different formulas, and it even

has something called Google App

82

: 00:03:43

Scripts if you wanna write custom

code inside of your spreadsheet.

83

: 00:03:46

Now there is a paid version,

kind of, it's Google Workspace.

84

: 00:03:49

And Google Workspace basically includes

the premium version of all the Google

85

: 00:03:53

products, and it's about $7 a month or $15

a month depending on what plan you're on.

86

: 00:03:57

But mostly that's for businesses.

87

: 00:03:59

It adds things like custom email

domains to your Gmail and more

88

: 00:04:01

storage and more admin controls.

89

: 00:04:03

For the spreadsheet functionality, it's.

90

: 00:04:05

Pretty much nearly identical.

91

: 00:04:07

So for an aspiring data analyst,

Google Sheets is one of the best free

92

: 00:04:09

tools out there, especially if you're

collaborating with other people or

93

: 00:04:12

you wanna do like more automations.

94

: 00:04:14

Uh, it's a lot easier than Excel, in my

opinion, but I will give you one caveat.

95

: 00:04:18

Although Google Sheets is very similar to

Excel, there are some slight differences.

96

: 00:04:23

Once again, I have to make a whole

separate episode about what the

97

: 00:04:26

differences between Excel and

Google Sheet are, but just know that

98

: 00:04:28

there is quite a few differences.

99

: 00:04:30

Google Sheets is pretty much like 25

times more in demand than Google Sheets

100

: 00:04:34

is in terms of like corporate industries.

101

: 00:04:36

And Excel absolutely dominates Google

Sheets when it comes to actually

102

: 00:04:39

being written in job descriptions.

103

: 00:04:41

So I highly recommend focusing

on Excel instead of Google

104

: 00:04:44

Sheets because that's what's.

105

: 00:04:45

Going to be A, in the job listings, and B,

what's going to be used at the companies.

106

: 00:04:49

And hey, by the way, if you want

me to send you cool data tool

107

: 00:04:52

comparisons like this, make sure

you subscribe to my newsletter.

108

: 00:04:55

I include graphs like this all the

time that are designed to help you

109

: 00:04:59

actually know what you need to be

focusing on on your data journey.

110

: 00:05:03

So make sure you sign up

in the link down below.

111

: 00:05:05

Also 100% free.

112

: 00:05:06

And that's the end of category

one, the spreadsheets.

113

: 00:05:09

Moving onto category two scripting,

and honestly, this is where a lot of

114

: 00:05:12

people get intimidated because it is

programming, but I promise you this stuff

115

: 00:05:16

isn't as hard as it may seem, and you

can set all of this up with exactly $0.

116

: 00:05:20

All right, let's start with Python,

which is probably the coolest, most sexy

117

: 00:05:25

programming language and data right now.

118

: 00:05:26

And you might think, oh, that has

to be really expensive, right?

119

: 00:05:30

Uh, nope.

120

: 00:05:30

The answer is free $0, and

there's lots of places to get it.

121

: 00:05:35

Oftentimes, people will

just go to python.org

122

: 00:05:37

and download it for free there.

123

: 00:05:38

But I don't really recommend that because

I think there's an easier way to do it.

124

: 00:05:42

And this is the method that I

actually teach my bootcamp students.

125

: 00:05:45

And it's to download it via

the Anaconda distribution.

126

: 00:05:48

Of course, we'll have a link to this

in the show notes down below where you

127

: 00:05:51

can get access to all of the different

places to download these softwares.

128

: 00:05:54

But I really like the Anacon distribution

because obviously it's free, but it

129

: 00:05:58

not only gives you Python, but it

gives you some awesome IDs, uh, like

130

: 00:06:02

Spider or like Jupyter, uh, I think VS.

131

: 00:06:04

Code is also included in there.

132

: 00:06:06

Uh, and it also pre-install 250.

133

: 00:06:09

Python packages that are all database

like, uh, pandas, mpa, matplotlib,

134

: 00:06:13

iLearn, these are the libraries that

you're going to use in the data world

135

: 00:06:16

and those all com pre-installed.

136

: 00:06:18

So I really like that.

137

: 00:06:19

So this is what I recommend is just

doing the Anaconda distribution.

138

: 00:06:22

And there is obviously like paid

versions of Anaconda and paid versions

139

: 00:06:26

of other sort of Python like tools.

140

: 00:06:29

But with those, the majority

of the time it's for companies.

141

: 00:06:31

Companies that need things like

license compliance, security scanning,

142

: 00:06:35

central package management, and.

143

: 00:06:37

Some other like, you know, corporate

things, like for me and you, when

144

: 00:06:40

we're just tinkling around on our

computer, this is more than good.

145

: 00:06:43

You definitely should not be paying

for any sort of python at all.

146

: 00:06:47

I guess there might be a little

bit of an exception with some of

147

: 00:06:50

these new AI tools coming out.

148

: 00:06:51

There is some like ai, python, IDs.

149

: 00:06:53

But you're not really paying

for Python at that point.

150

: 00:06:55

You're paying for the IDE

that you're coding in.

151

: 00:06:57

So there you have it python's free.

152

: 00:06:59

Next is r and r is really

great for statistics.

153

: 00:07:02

Uh, it's used a lot in academia and

like in governments and in pharma.

154

: 00:07:07

Uh, I don't use R too much anymore.

155

: 00:07:09

I do have a download on my computer and

we do teach it inside of my bootcamp

156

: 00:07:12

'cause I think it is worth learning, but.

157

: 00:07:15

R is free.

158

: 00:07:16

It's a hundred percent free.

159

: 00:07:17

It is open source, and I don't even

really think there's a paid version of R.

160

: 00:07:21

Basically you just go to this janky

website for the R project and you go

161

: 00:07:25

to download and you do this like crazy

looking download based off of where you're

162

: 00:07:29

at and what type of computer you have.

163

: 00:07:30

It is a little bit tricky downloading it.

164

: 00:07:32

Uh, and this website looks like it's

made in like: 2001

165

: 00:07:36

you it's a hundred percent free.

166

: 00:07:37

You won't have to pay for it.

167

: 00:07:38

Now, something you may not know is what

these scripting languages, Python and r.

168

: 00:07:42

You need to have some sort of IDE,

which stands for Integrated Development

169

: 00:07:45

Environment to actually kind of use

them at least, unless you're really

170

: 00:07:49

good at using like your command prompt

or your terminal in your computer,

171

: 00:07:52

which I'm assuming most of you aren't.

172

: 00:07:53

I'm definitely still am

not comfortable with that.

173

: 00:07:55

So you need to find some

sort of an IDE to use Python.

174

: 00:07:58

That's one of the reasons I recommended.

175

: 00:07:59

Doing Anaconda for RI highly

recommend using R Studio.

176

: 00:08:03

It's from a company called Deposit and

I just think it's the best IDE for R,

177

: 00:08:08

and you can download it here and that

way you can actually like integrate

178

: 00:08:11

your R with some sort of an IDE.

179

: 00:08:13

That makes it really easy to code in.

180

: 00:08:14

Now Pza is a company that has

paid products, but a lot of

181

: 00:08:18

it is free and open source.

182

: 00:08:19

Really as an individual.

183

: 00:08:21

You wouldn't buy anything from Pza.

184

: 00:08:22

It's just more from a corporate

standpoint that's gonna get you like a

185

: 00:08:25

bunch of packages and a bunch of like

cloud space and like all these sort of

186

: 00:08:30

support and all these different things.

187

: 00:08:32

It's nothing that you really

need to use as an individual.

188

: 00:08:35

Like literally everything that I've

ever done with R I've never paid for,

189

: 00:08:39

and I've done it strictly with the R

download and our studio from Posit.

190

: 00:08:42

So I think you guys are in good

shape and once again, R is free.

191

: 00:08:45

The third scripting language we're

gonna be talking about actually

192

: 00:08:47

really isn't a scripting language.

193

: 00:08:49

It's more of a database language, but

it's sql, and that stands for structured

194

: 00:08:53

query language, and that's the language

that you use to talk to databases.

195

: 00:08:56

And so if you need to practice

with databases, you need to

196

: 00:08:59

talk to an actual database.

197

: 00:09:00

How do you download it?

198

: 00:09:01

Does it cost millions of dollars?

199

: 00:09:03

Well, no.

200

: 00:09:04

The truth is most sequel is free, and

there's lots of different sequel flavors.

201

: 00:09:08

Lots of different SQL softwares.

202

: 00:09:09

I'm not gonna cover all of them today,

but I will show you my personal favorite

203

: 00:09:13

that I have downloaded on my machine.

204

: 00:09:15

So I really like my sql.

205

: 00:09:16

Is there a reason why?

206

: 00:09:17

I don't know.

207

: 00:09:18

I like it.

208

: 00:09:18

It's fine, but there's a

community edition that's free.

209

: 00:09:22

You can literally go to this link.

210

: 00:09:23

You can download the MySQL installer

for windows or whatever computer

211

: 00:09:26

you have, and then make sure you

also install the MySQL Workbench.

212

: 00:09:30

This is like the IDE that's gonna let you

easily use MySQL on your computer, and

213

: 00:09:34

then literally with those two downloads,

you can write queries, design databases,

214

: 00:09:38

see your data, like do anything you

would do in any sort of SQL program.

215

: 00:09:42

For absolutely free.

216

: 00:09:43

It can handle millions of rows.

217

: 00:09:44

It's real, it's production grade.

218

: 00:09:46

There's no really limitations on it other

than like there is a paid version that's

219

: 00:09:49

sold by Oracle and that can like, that

can be like thousands of dollars, right?

220

: 00:09:53

And that's gonna get you more enterprise.

221

: 00:09:55

Solutions like monitoring and backups

and security and all that boring stuff

222

: 00:09:59

that we don't care about as individuals.

223

: 00:10:02

But if you're just learning

sql, this is an awesome option.

224

: 00:10:04

That's more than enough.

225

: 00:10:05

You don't even need anything else.

226

: 00:10:06

But if you're interested in

other SQL flavors, Postgres

227

: 00:10:09

has a very similar download.

228

: 00:10:11

Postgres sql, very similar to

MySQL and as well as SQL Lights

229

: 00:10:15

has a free download as well.

230

: 00:10:17

You can check out all three of those,

and even, and I've been gatekeeping

231

: 00:10:20

this for a while, so if you're

listening, listen really closely.

232

: 00:10:23

Downloading and installing and using SQL

via these free tools isn't always easy.

233

: 00:10:27

And so in my bootcamp program,

we have two modules on sql.

234

: 00:10:31

The second one, we actually go through

the steps of, you know, downloading

235

: 00:10:34

my SQL into their local machines and

setting it up and actually querying

236

: 00:10:37

the databases from there and creating

a project off those databases.

237

: 00:10:40

But for the first module, the first

project that I have my students do, uh,

238

: 00:10:44

in sql, I don't want them to have to go

through the headache of downloading sql.

239

: 00:10:48

I just want them to be able to focus.

240

: 00:10:50

On actual SQL Command.

241

: 00:10:51

SQL queries, right?

242

: 00:10:53

And SQL results.

243

: 00:10:54

And so to do that, we don't do any

installation and we use this free

244

: 00:10:57

tool that I've been gate keeping.

245

: 00:10:58

It's called CSV fiddle.io.

246

: 00:11:01

And what it allows you to do is actually

just upload a CSV file and then write

247

: 00:11:05

SQL commands against that CSV file.

248

: 00:11:07

So it is a lot easier to set up and

actually practice your SQL than having

249

: 00:11:12

to install, you know, the SQL installer

and the workbench and everything else.

250

: 00:11:16

So if that's of interest to

you, check it out@csvfiddle.io.

251

: 00:11:20

And of course it'll be linked

in the show notes down below.

252

: 00:11:22

And that concludes our second

category of scripting languages.

253

: 00:11:25

And we're moving on to the third, which

is, I've called business intelligence.

254

: 00:11:28

Really it's just data

visualization and dashboarding.

255

: 00:11:31

And we're gonna cover

Tableau and Power bi.

256

: 00:11:33

Let's start with Tableau.

257

: 00:11:34

Tableau is one of the most popular

data visualization tools in industry.

258

: 00:11:38

And it's historically pretty expensive.

259

: 00:11:41

In fact, when I worked at ExxonMobil,

I was not allowed to have Tableau.

260

: 00:11:44

I didn't have a Tableau license because

they were so expensive and there was

261

: 00:11:47

none of them free at the company.

262

: 00:11:49

I wasn't cool enough to have a Tableau

license, so it is pretty expensive

263

: 00:11:53

if you're gonna try to pay on your

own or even four, your company to

264

: 00:11:55

pay for it, at least Historically.

265

: 00:11:57

That was obviously like five plus years

ago, so maybe it's changed since then.

266

: 00:12:00

And so a lot of people are like, oh, I

wanna use Tableau, but it costs so much.

267

: 00:12:02

Well, there's a free Tableau

version that you can use.

268

: 00:12:05

It costs $0.

269

: 00:12:06

And it's basically called Tableau Public,

so you can find it@public.tableau.com,

270

: 00:12:12

and you'll have the option to

actually do two different ways

271

: 00:12:15

to use this Tableau public.

272

: 00:12:16

The first one is you can actually

create an account and do web

273

: 00:12:19

authoring and use Tableau online.

274

: 00:12:21

And then the second one is the Tableau

desktop free edition, where you

275

: 00:12:24

actually download Tableau onto your

computer and use it on your computer.

276

: 00:12:28

And this gives you a

little bit more of the.

277

: 00:12:30

Uh, authoring experience you'd have if

you had the full version of Tableau,

278

: 00:12:33

because I will say there are some pretty

heavy limitations with Tableau public.

279

: 00:12:38

And the first thing is

everything you create is going

280

: 00:12:41

to be visible for the public.

281

: 00:12:43

So if you have embarrassing data sets,

private data sets, proprietary data

282

: 00:12:47

sets, you probably don't wanna be

using Tableau public for that because

283

: 00:12:50

it's gonna be shown everywhere.

284

: 00:12:51

So just know that off the top of your

head, like everything that you put

285

: 00:12:55

in Tableau can be shown to the world.

286

: 00:12:56

There's also a bunch of other limitations

on what type of graphs you can make,

287

: 00:13:00

what type of files you can connect to.

288

: 00:13:01

I think it's only like Excel

CSV, Google Sheets, like you

289

: 00:13:04

can't actually connect to sql.

290

: 00:13:06

Um, there might be like some limit

on how big those data sets are.

291

: 00:13:09

And there's not really like any sort of

automation or sharing capabilities other

292

: 00:13:12

than sharing to everyone on the web.

293

: 00:13:14

It also doesn't include

anything like Tableau Prep.

294

: 00:13:15

That was Tableau's

product for data cleaning.

295

: 00:13:17

You kinda have to clean your

data beforehand and then

296

: 00:13:19

put it inside a tableau.

297

: 00:13:21

But honestly, for any aspiring data

analyst, everyone in my bootcamp,

298

: 00:13:24

Tableau Public is more than enough.

299

: 00:13:26

Like you can learn the core of Tableau.

300

: 00:13:28

Of data visualization, of dashboarding

on the free version, and you can

301

: 00:13:32

even publish 'em on Tableau public,

and then you can use that in your

302

: 00:13:34

portfolio when you're applying for jobs.

303

: 00:13:36

So really, for the most part, when you're

just getting started, Tableau costs $0.

304

: 00:13:41

It's absolutely free.

305

: 00:13:42

Alright, next is the other

data visualization tool that's

306

: 00:13:45

really popular right now and

that is Power BI from Microsoft.

307

: 00:13:48

And Power BI has a free plan,

but it's from Microsoft, so they

308

: 00:13:51

try to make it as confusing as

possibly that they possibly can.

309

: 00:13:55

Like it is so confusing.

310

: 00:13:57

Uh, if you go to pricing right

here, you're not gonna be able to

311

: 00:14:00

see like, oh, start free, right?

312

: 00:14:02

But it's like, oh, it's just a free trial.

313

: 00:14:04

Anyways, it's so confusing.

314

: 00:14:05

It's really hard to know how to use.

315

: 00:14:07

Uh, and also you can't

even use it on a Mac.

316

: 00:14:10

That sucks.

317

: 00:14:11

That's like half the

world uses a Mac, right?

318

: 00:14:12

So what are you gonna do if you're,

you wanna use power beyond your Mac,

319

: 00:14:16

and that's because Microsoft and Apple

are rivals and everything, right?

320

: 00:14:18

The other caveat to actually getting

a Power BI account is you need to

321

: 00:14:22

have some sort of a business email, at

least when I downloaded it last, which

322

: 00:14:25

was probably like three years ago.

323

: 00:14:27

So if you have like a Gmail or

an Outlook account, it's probably

324

: 00:14:29

gonna be hard to actually download

Power bi, which is one of the

325

: 00:14:32

reasons I teach my students Tableau.

326

: 00:14:33

It's just so much easier

to access than Power bi.

327

: 00:14:35

It's like, no, you can do it on

Windows or Mac and you don't have to

328

: 00:14:38

have any sort of special email to do.

329

: 00:14:39

So.

330

: 00:14:40

That being said, all these

hoops you have to jump through.

331

: 00:14:42

Once you find the right link,

which once again, we'll have the

332

: 00:14:43

link in the show notes down below.

333

: 00:14:45

You can download it and press

download for free, and you can

334

: 00:14:48

literally do everything in Power bi.

335

: 00:14:50

You can connect to a bunch

of different data sources.

336

: 00:14:52

You can use their data models, you can

create the dashboards, the reports.

337

: 00:14:56

It's really pretty much

like the paid version.

338

: 00:14:58

But that being said, you can't really

share those reports with anyone.

339

: 00:15:02

Like they, it's basically the

opposite of Tableau Public, where

340

: 00:15:04

it's like Tableau Public, everything

you do is shown to the world.

341

: 00:15:07

Power BI is like, you can't

show anyone about this.

342

: 00:15:09

If you wanna show anyone other than

yourself, you gotta pay us money.

343

: 00:15:11

That being said, a lot of companies

who have like the Microsoft 365

344

: 00:15:16

plan, they actually have Power

BI included with their, you know,

345

: 00:15:20

corporate services agreement.

346

: 00:15:22

So a lot of companies have Power BI

for absolutely free at the company,

347

: 00:15:26

or they're already paying for it.

348

: 00:15:27

That was the case at Exxon, which

is why they wouldn't let me have

349

: 00:15:29

Tableau is you already have Power bi,

you don't need to have a Second BI

350

: 00:15:32

tool, and they were kind of right.

351

: 00:15:34

And there's some pros and cons

to each one of these tools.

352

: 00:15:36

That being said, even if you're just

creating these dashboards, most of

353

: 00:15:39

the time it's gonna be for yourself.

354

: 00:15:41

Right, so you can create these dashboards

for yourself inside of your local

355

: 00:15:44

machine and just maybe do a screenshot

of them for your, uh, portfolio.

356

: 00:15:48

You don't have to be showing the

world your Power BI dashboards.

357

: 00:15:52

So really for you as an aspiring data

analyst who's just trying to practice

358

: 00:15:54

and create a portfolio, power BI is free.

359

: 00:15:57

And that's it for our business

intelligence and data visualization tools.

360

: 00:16:01

Let's go ahead and move

on to the AI tools.

361

: 00:16:04

The first one is Claude.

362

: 00:16:05

You've never heard of Claude.

363

: 00:16:06

It's very similar to chat GPT in

terms of like a chat interface.

364

: 00:16:11

However, I think it writes

a little bit better.

365

: 00:16:12

I think it analyzes data a little better.

366

: 00:16:14

I think it does a lot of

things a little bit better.

367

: 00:16:16

Not everything, but a lot of like the

data tasks or knowledge worker tasks.

368

: 00:16:20

I think it does better, and this is

one of the ones I actually pay for.

369

: 00:16:24

So the free version.

370

: 00:16:25

You're able to have like the

chat, like, um, you know, chat

371

: 00:16:28

GPT on your phone or whatever.

372

: 00:16:29

You can still generate code

and visualize data and write

373

: 00:16:32

everything and access the web.

374

: 00:16:34

Um, they're just gonna limit

you on how often you can use

375

: 00:16:36

it, and it's pretty limited.

376

: 00:16:38

Claude's pretty tight with

how much they let you use it.

377

: 00:16:41

Then there's a $17 plan that

will get you what's called Code

378

: 00:16:44

Claude Code and Claude Cowork.

379

: 00:16:46

These are two features I really like.

380

: 00:16:48

Um, cowork allows you to.

381

: 00:16:50

Give Claude access to your computer

and allow it to do things locally on

382

: 00:16:54

your computer, which is really nice for

analyzing data, creating PowerPoints,

383

: 00:16:57

those type of different things.

384

: 00:16:58

And Claude code is really fancy

way to do algorithmic coding.

385

: 00:17:03

Um, it's basically using automation

agents to actually code different things.

386

: 00:17:07

Um, for the Skippy for building websites,

whatever you would normally code, you

387

: 00:17:10

could definitely use cloud code to do

it and it would do a really good job.

388

: 00:17:13

And it also gives you a

little bit better researcher.

389

: 00:17:15

Um, like to actually search and

then there's some different plugins

390

: 00:17:18

like Claude for Excel and Claude for

PowerPoint, those types of things.

391

: 00:17:21

So paying really makes sense.

392

: 00:17:23

One of the reasons I pay and then

actually there's a max plan that

393

: 00:17:26

costs a hundred dollars per month.

394

: 00:17:28

That basically gives you more

access to do all these different

395

: 00:17:30

things and more advanced features.

396

: 00:17:32

I actually pay a hundred bucks a

month for Claude right now, and I

397

: 00:17:35

think it's a hundred percent worth it.

398

: 00:17:36

So Claude's one of these tools that

I think you might need to pay for.

399

: 00:17:40

Um, you could probably get a lot of the

way with just the free version, but like

400

: 00:17:44

you can use it for so many different

things and it's only $17 a month, like I

401

: 00:17:47

definitely think it's worth paying for.

402

: 00:17:49

So clot is $0, but I think if

you want the best use out of

403

: 00:17:53

it, you should probably pay.

404

: 00:17:54

That brings us to our next tool,

which I'm sure all of you guys have

405

: 00:17:57

heard of, and it's chat, GPT and chat.

406

: 00:17:59

GPT is still really useful

for doing data analysis.

407

: 00:18:02

I pay for the paid version of chat

GPT as well, but in the free version

408

: 00:18:06

you're gonna be able to get a lot

of the stuff done that you need to.

409

: 00:18:09

If you've never heard of chat

GPT before, it's basically like

410

: 00:18:11

what you used to use Google for.

411

: 00:18:13

You can use chat GPT for and a lot more,

and I'm pretty sure everyone listening

412

: 00:18:16

has heard of chat GPT at this point.

413

: 00:18:18

In terms of pricing, they do have

a free plan where basically you're

414

: 00:18:21

not gonna get as good of access or

as much access to their good models.

415

: 00:18:25

They're gonna limit you on

everything, and I think they're even

416

: 00:18:27

gonna give you ads at this point.

417

: 00:18:28

I don't know if they've

actually integrated that or not.

418

: 00:18:30

I actually pay for plus at this point,

but I think I'm going to be canceling

419

: 00:18:34

it probably 'cause I mostly use Claude

and I pay a lot for Claude right now.

420

: 00:18:37

And the last tool I wanna tell

you about that is totally free as

421

: 00:18:41

a data analyst is called GitHub.

422

: 00:18:43

And no, it's not really an AI tool,

but that's the only place that really

423

: 00:18:46

felt like it belonged in a category.

424

: 00:18:48

And the reason why is, I think this

will become more important with ai.

425

: 00:18:53

GitHub has really become like.

426

: 00:18:55

The middleman for a lot of AI

things, and I think it's only

427

: 00:18:58

gonna get more and more use.

428

: 00:19:00

And so I think it's important that

I start talking about it a little

429

: 00:19:02

bit more than I have historically.

430

: 00:19:04

Historically, I haven't talked about

it that much because it is a little

431

: 00:19:06

bit complicated to get started.

432

: 00:19:08

Uh, and to be honest, I just didn't

really use it at my jobs all that

433

: 00:19:11

much that often, like it doesn't.

434

: 00:19:13

It only integrates really

with code and with writing,

435

: 00:19:15

kind of, but it's mostly code.

436

: 00:19:17

So if I was using Power BI, like I was

at, at uh Exxon a lot, it doesn't really

437

: 00:19:20

make sense to be using GitHub as much.

438

: 00:19:23

But if you're coding Python,

you're coding R, you're coding SQL,

439

: 00:19:25

or any other coding, it makes a

lot of sense to be using GitHub.

440

: 00:19:28

And I think in the future this

is going to be more important

441

: 00:19:31

and it costs $0 for, for you.

442

: 00:19:32

What GitHub does, if you're not

familiar with it, is think of

443

: 00:19:35

it as like Google Docs for code.

444

: 00:19:37

It allows you to.

445

: 00:19:38

Uh, put your code online, have

it be stored somewhere and like

446

: 00:19:41

share it with someone else.

447

: 00:19:43

So for example, I could share any of

my code I've ever written with you

448

: 00:19:45

guys through a GitHub link and you

could click on it and download all

449

: 00:19:48

of the different, uh, coding files.

450

: 00:19:50

And I think it's gonna be

really important in the future.

451

: 00:19:53

So I just wanted to mention it as a

really good resource and it costs you $0.

452

: 00:19:56

Of course, there are paid versions of it,

and that's the most important thing I need

453

: 00:19:59

to tell you is that once you land a job.

454

: 00:20:01

You're not gonna be paying for any tools.

455

: 00:20:03

The company's gonna be

paying for all of your tools.

456

: 00:20:06

So really in the beginning, you can get

away as an aspiring data analyst using

457

: 00:20:09

all these tools for free, or paying for a

little bit of them, maybe here and there.

458

: 00:20:13

But then once you're on the job,

you're not gonna have to pay

459

: 00:20:14

for all any of these different

tools that you're gonna be using.

460

: 00:20:17

The company's going to be paying for them.

461

: 00:20:19

So I know I kind of blew through

those and did those really quickly.

462

: 00:20:21

But that link, the description down

below will have instructions on how

463

: 00:20:24

to get all these different tools for

free and what you're actually missing

464

: 00:20:28

by not doing the paid versions.

465

: 00:20:30

So make sure you click on that link down

below, and I'll see you in the next one.