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,910 --> 00:00:05,880

how much do all these data tools cost?

3

00:00:05,880 --> 00:00:09,690

Because when you start adding up

Excel, Tableau, Python, AI tools,

4

00:00:09,930 --> 00:00:12,240

it starts to sound really expensive.

5

00:00:12,270 --> 00:00:15,120

But here's the big secret that

they don't want you to know.

6

00:00:15,240 --> 00:00:17,820

You can get all of these

tools for absolutely free.

7

00:00:18,260 --> 00:00:23,270

$0 and I'm going to tell you how

today, so we are covering the 10 most

8

00:00:23,270 --> 00:00:26,990

used data tools, and I'll show you

my exact setup for each and show you

9

00:00:26,990 --> 00:00:28,580

how you can replicate it on your own.

10

00:00:28,730 --> 00:00:33,350

We'll cover four categories, spreadsheets,

scripting, business intelligence, and ai.

11

00:00:33,500 --> 00:00:37,640

And I actually do pay for two of these

tools, so make sure you stick around to

12

00:00:37,640 --> 00:00:40,790

the end to figure out what tools they

are and why they're worth paying for.

13

00:00:40,820 --> 00:00:44,060

But let's get started with the

most in demand data tool, Excel.

14

00:00:44,085 --> 00:00:46,215

And everybody knows Excel.

15

00:00:46,305 --> 00:00:50,175

What most people don't know is that

you can use it for completely free.

16

00:00:50,415 --> 00:00:53,385

In fact, Microsoft doesn't want you

to know that you can use it for free.

17

00:00:53,385 --> 00:00:55,425

It's so unbelievably

hidden on their website.

18

00:00:55,425 --> 00:00:56,775

They don't ever talk about it at all.

19

00:00:56,925 --> 00:00:58,245

But don't worry, I have your back.

20

00:00:58,275 --> 00:01:01,485

I'll have an exact link that you can use

to get access to this free version of

21

00:01:01,485 --> 00:01:05,385

Excel, along with the other nine data

tools that we'll be covering today.

22

00:01:05,565 --> 00:01:06,825

It's in the description down below.

23

00:01:06,860 --> 00:01:07,760

So check it out.

24

00:01:07,760 --> 00:01:10,280

Welcome to Excel for free on the web.

25

00:01:10,280 --> 00:01:13,640

This is like the only place I've really

been able to find where it can link

26

00:01:13,640 --> 00:01:16,250

to, where you can get it for free

and you can just sign in with your

27

00:01:16,250 --> 00:01:17,750

Microsoft account or create your own.

28

00:01:17,990 --> 00:01:20,330

And then once you do,

it'll look like this.

29

00:01:20,330 --> 00:01:22,880

And sure enough, you can

create a a blank workbook.

30

00:01:23,120 --> 00:01:26,120

You can access all of your other

files that you've done previously.

31

00:01:26,120 --> 00:01:27,320

So you can see that I've used this.

32

00:01:27,330 --> 00:01:30,570

In the past, I'll go ahead and

press create blank workbook just to

33

00:01:30,570 --> 00:01:34,710

show you, but just like that you've

got Excel running in your browser.

34

00:01:34,710 --> 00:01:38,460

That is one of the biggest downsides to

the free version is it's only in your

35

00:01:38,460 --> 00:01:41,280

browser, but usually today that's okay.

36

00:01:41,280 --> 00:01:43,710

Like usually are only working

when there's internet.

37

00:01:44,220 --> 00:01:47,580

Um, there are some downfalls, like

file sizes in your browser can

38

00:01:47,580 --> 00:01:50,729

cause things to, to bog down and

be really slow or even not work.

39

00:01:51,030 --> 00:01:54,570

Um, but other than that, you get formulas,

you get charts, you get pivot tables.

40

00:01:54,800 --> 00:01:58,759

Um, you can even, you know, share

this with different people by copying

41

00:01:58,759 --> 00:02:00,560

the link or copy link to the sheet.

42

00:02:00,860 --> 00:02:03,380

Um, you can manage the access to this.

43

00:02:04,335 --> 00:02:07,455

You get five gigabytes of

storage basically, of OneDrive

44

00:02:07,455 --> 00:02:08,745

to store all your files.

45

00:02:08,985 --> 00:02:12,105

Now of course, you are missing other

things other than just being able to

46

00:02:12,165 --> 00:02:14,085

use it on your laptop or your desktop.

47

00:02:14,445 --> 00:02:16,935

Um, and there's a bunch of different

differences between the two.

48

00:02:16,935 --> 00:02:20,505

To be honest, I couldn't find any

real documented, like this is the

49

00:02:20,505 --> 00:02:21,885

free version versus the paid version.

50

00:02:21,885 --> 00:02:22,605

This is what you get.

51

00:02:22,875 --> 00:02:26,235

Um, so leave a comment down below if

you want me to do a full in depth.

52

00:02:26,300 --> 00:02:28,820

Free Microsoft Excel versus

paid Microsoft Excel.

53

00:02:29,120 --> 00:02:30,950

But like, the biggest thing

is you're not gonna be getting

54

00:02:30,950 --> 00:02:32,720

all of the functions up here.

55

00:02:32,720 --> 00:02:35,930

Like, uh, you don't have

power query and power pivot.

56

00:02:36,320 --> 00:02:39,770

Um, you're not gonna have like

VBA macros for automation.

57

00:02:40,010 --> 00:02:43,130

Uh, the solver and analysis

tool packs are unavailable.

58

00:02:43,310 --> 00:02:45,140

And of course, once again, you're

not gonna have offline access.

59

00:02:45,140 --> 00:02:47,240

So there's gonna be some things

that you can't do with the

60

00:02:47,240 --> 00:02:48,350

free version of Excel, but.

61

00:02:48,550 --> 00:02:51,579

When you're just trying to learn on

your own, you're building your skills,

62

00:02:51,579 --> 00:02:55,060

you're practicing formulas, then like

literally everything you need is in here.

63

00:02:55,060 --> 00:02:58,900

The pivot tables, formulas, vlookup,

all the good stuff you need is going

64

00:02:58,900 --> 00:03:00,550

to be available in the free version.

65

00:03:00,820 --> 00:03:03,700

And even if it's not, like this

is a really good way to get

66

00:03:03,700 --> 00:03:04,840

started without having to pay.

67

00:03:04,840 --> 00:03:07,540

And then once you need to learn

the stuff that's not in the free

68

00:03:07,540 --> 00:03:11,320

version, maybe you start paying

$7 a month for the paid version.

69

00:03:11,565 --> 00:03:13,185

So who knew Excel is free.

70

00:03:13,334 --> 00:03:17,475

Our next tool is the other big spreadsheet

software, which is Google Sheets.

71

00:03:17,505 --> 00:03:19,095

And this one's really simple.

72

00:03:19,125 --> 00:03:21,584

Google Sheets is a hundred percent free.

73

00:03:21,795 --> 00:03:24,465

Seriously, all you need to

do is go to sheets.google.com

74

00:03:24,465 --> 00:03:27,734

and sign in and boom,

you're basically done.

75

00:03:27,734 --> 00:03:29,385

It's all available for you.

76

00:03:29,415 --> 00:03:32,595

You basically get a full

fledged spreadsheet for $0.

77

00:03:32,595 --> 00:03:34,364

It has real time collaboration.

78

00:03:34,364 --> 00:03:36,555

It has 15 gigs of data and storage.

79

00:03:36,825 --> 00:03:38,505

It has so many different functions.

80

00:03:38,800 --> 00:03:40,630

Graphs that you can

make up here at the top.

81

00:03:40,630 --> 00:03:43,390

Different formulas, and it even

has something called Google App

82

00:03:43,390 --> 00:03:46,780

Scripts if you wanna write custom

code inside of your spreadsheet.

83

00:03:46,870 --> 00:03:49,840

Now there is a paid version,

kind of, it's Google Workspace.

84

00:03:49,840 --> 00:03:53,020

And Google Workspace basically includes

the premium version of all the Google

85

00:03:53,020 --> 00:03:56,860

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

a month depending on what plan you're on.

86

00:03:57,070 --> 00:03:59,110

But mostly that's for businesses.

87

00:03:59,110 --> 00:04:01,810

It adds things like custom email

domains to your Gmail and more

88

00:04:01,810 --> 00:04:03,310

storage and more admin controls.

89

00:04:03,700 --> 00:04:05,440

For the spreadsheet functionality, it's.

90

00:04:05,495 --> 00:04:07,265

Pretty much nearly identical.

91

00:04:07,325 --> 00:04:09,935

So for an aspiring data analyst,

Google Sheets is one of the best free

92

00:04:09,935 --> 00:04:12,425

tools out there, especially if you're

collaborating with other people or

93

00:04:12,425 --> 00:04:13,985

you wanna do like more automations.

94

00:04:14,225 --> 00:04:18,515

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

opinion, but I will give you one caveat.

95

00:04:18,875 --> 00:04:23,675

Although Google Sheets is very similar to

Excel, there are some slight differences.

96

00:04:23,675 --> 00:04:26,195

Once again, I have to make a whole

separate episode about what the

97

00:04:26,195 --> 00:04:28,595

differences between Excel and

Google Sheet are, but just know that

98

00:04:28,595 --> 00:04:30,035

there is quite a few differences.

99

00:04:30,055 --> 00:04:34,555

Google Sheets is pretty much like 25

times more in demand than Google Sheets

100

00:04:34,555 --> 00:04:36,415

is in terms of like corporate industries.

101

00:04:36,685 --> 00:04:39,955

And Excel absolutely dominates Google

Sheets when it comes to actually

102

00:04:39,955 --> 00:04:41,395

being written in job descriptions.

103

00:04:41,665 --> 00:04:44,005

So I highly recommend focusing

on Excel instead of Google

104

00:04:44,005 --> 00:04:45,055

Sheets because that's what's.

105

00:04:45,105 --> 00:04:49,665

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

what's going to be used at the companies.

106

00:04:49,725 --> 00:04:52,875

And hey, by the way, if you want

me to send you cool data tool

107

00:04:52,875 --> 00:04:55,755

comparisons like this, make sure

you subscribe to my newsletter.

108

00:04:55,995 --> 00:04:59,835

I include graphs like this all the

time that are designed to help you

109

00:04:59,925 --> 00:05:02,775

actually know what you need to be

focusing on on your data journey.

110

00:05:03,015 --> 00:05:05,085

So make sure you sign up

in the link down below.

111

00:05:05,285 --> 00:05:06,815

Also 100% free.

112

00:05:06,845 --> 00:05:09,455

And that's the end of category

one, the spreadsheets.

113

00:05:09,485 --> 00:05:12,995

Moving onto category two scripting,

and honestly, this is where a lot of

114

00:05:12,995 --> 00:05:16,835

people get intimidated because it is

programming, but I promise you this stuff

115

00:05:16,835 --> 00:05:20,885

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

can set all of this up with exactly $0.

116

00:05:20,945 --> 00:05:25,085

All right, let's start with Python,

which is probably the coolest, most sexy

117

00:05:25,085 --> 00:05:26,885

programming language and data right now.

118

00:05:26,945 --> 00:05:29,375

And you might think, oh, that has

to be really expensive, right?

119

00:05:30,045 --> 00:05:30,945

Uh, nope.

120

00:05:30,975 --> 00:05:34,965

The answer is free $0, and

there's lots of places to get it.

121

00:05:35,055 --> 00:05:37,335

Oftentimes, people will

just go to python.org

122

00:05:37,365 --> 00:05:38,805

and download it for free there.

123

00:05:38,805 --> 00:05:42,645

But I don't really recommend that because

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

124

00:05:42,645 --> 00:05:44,950

And this is the method that I

actually teach my bootcamp students.

125

00:05:45,385 --> 00:05:48,085

And it's to download it via

the Anaconda distribution.

126

00:05:48,355 --> 00:05:51,235

Of course, we'll have a link to this

in the show notes down below where you

127

00:05:51,235 --> 00:05:53,965

can get access to all of the different

places to download these softwares.

128

00:05:54,295 --> 00:05:58,135

But I really like the Anacon distribution

because obviously it's free, but it

129

00:05:58,135 --> 00:06:02,395

not only gives you Python, but it

gives you some awesome IDs, uh, like

130

00:06:02,395 --> 00:06:04,615

Spider or like Jupyter, uh, I think VS.

131

00:06:04,615 --> 00:06:05,875

Code is also included in there.

132

00:06:06,205 --> 00:06:08,425

Uh, and it also pre-install 250.

133

00:06:09,135 --> 00:06:13,125

Python packages that are all database

like, uh, pandas, mpa, matplotlib,

134

00:06:13,335 --> 00:06:16,905

iLearn, these are the libraries that

you're going to use in the data world

135

00:06:16,935 --> 00:06:18,285

and those all com pre-installed.

136

00:06:18,285 --> 00:06:19,485

So I really like that.

137

00:06:19,545 --> 00:06:22,155

So this is what I recommend is just

doing the Anaconda distribution.

138

00:06:22,365 --> 00:06:26,295

And there is obviously like paid

versions of Anaconda and paid versions

139

00:06:26,295 --> 00:06:29,025

of other sort of Python like tools.

140

00:06:29,265 --> 00:06:31,605

But with those, the majority

of the time it's for companies.

141

00:06:31,605 --> 00:06:35,325

Companies that need things like

license compliance, security scanning,

142

00:06:35,534 --> 00:06:37,485

central package management, and.

143

00:06:37,645 --> 00:06:40,525

Some other like, you know, corporate

things, like for me and you, when

144

00:06:40,525 --> 00:06:43,854

we're just tinkling around on our

computer, this is more than good.

145

00:06:43,854 --> 00:06:47,724

You definitely should not be paying

for any sort of python at all.

146

00:06:47,905 --> 00:06:50,365

I guess there might be a little

bit of an exception with some of

147

00:06:50,365 --> 00:06:51,594

these new AI tools coming out.

148

00:06:51,835 --> 00:06:53,335

There is some like ai, python, IDs.

149

00:06:53,705 --> 00:06:55,474

But you're not really paying

for Python at that point.

150

00:06:55,474 --> 00:06:57,484

You're paying for the IDE

that you're coding in.

151

00:06:57,635 --> 00:06:58,984

So there you have it python's free.

152

00:06:59,135 --> 00:07:02,405

Next is r and r is really

great for statistics.

153

00:07:02,435 --> 00:07:06,995

Uh, it's used a lot in academia and

like in governments and in pharma.

154

00:07:07,325 --> 00:07:09,245

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

155

00:07:09,245 --> 00:07:12,544

I do have a download on my computer and

we do teach it inside of my bootcamp

156

00:07:12,544 --> 00:07:14,825

'cause I think it is worth learning, but.

157

00:07:15,065 --> 00:07:16,385

R is free.

158

00:07:16,385 --> 00:07:17,344

It's a hundred percent free.

159

00:07:17,344 --> 00:07:21,455

It is open source, and I don't even

really think there's a paid version of R.

160

00:07:21,545 --> 00:07:25,685

Basically you just go to this janky

website for the R project and you go

161

00:07:25,685 --> 00:07:29,165

to download and you do this like crazy

looking download based off of where you're

162

00:07:29,165 --> 00:07:30,515

at and what type of computer you have.

163

00:07:30,725 --> 00:07:32,435

It is a little bit tricky downloading it.

164

00:07:32,675 --> 00:07:36,515

Uh, and this website looks like it's

made in like 2001, but I promise

165

00:07:36,515 --> 00:07:37,445

you it's a hundred percent free.

166

00:07:37,445 --> 00:07:38,465

You won't have to pay for it.

167

00:07:38,675 --> 00:07:42,335

Now, something you may not know is what

these scripting languages, Python and r.

168

00:07:42,659 --> 00:07:45,900

You need to have some sort of IDE,

which stands for Integrated Development

169

00:07:45,900 --> 00:07:49,080

Environment to actually kind of use

them at least, unless you're really

170

00:07:49,080 --> 00:07:52,289

good at using like your command prompt

or your terminal in your computer,

171

00:07:52,289 --> 00:07:53,669

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

172

00:07:53,669 --> 00:07:55,650

I'm definitely still am

not comfortable with that.

173

00:07:55,950 --> 00:07:58,650

So you need to find some

sort of an IDE to use Python.

174

00:07:58,650 --> 00:07:59,669

That's one of the reasons I recommended.

175

00:07:59,885 --> 00:08:03,695

Doing Anaconda for RI highly

recommend using R Studio.

176

00:08:03,695 --> 00:08:08,284

It's from a company called Deposit and

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

177

00:08:08,465 --> 00:08:11,705

and you can download it here and that

way you can actually like integrate

178

00:08:11,705 --> 00:08:13,385

your R with some sort of an IDE.

179

00:08:13,385 --> 00:08:14,570

That makes it really easy to code in.

180

00:08:14,945 --> 00:08:18,395

Now Pza is a company that has

paid products, but a lot of

181

00:08:18,395 --> 00:08:19,775

it is free and open source.

182

00:08:19,835 --> 00:08:21,305

Really as an individual.

183

00:08:21,305 --> 00:08:22,625

You wouldn't buy anything from Pza.

184

00:08:22,625 --> 00:08:25,415

It's just more from a corporate

standpoint that's gonna get you like a

185

00:08:25,415 --> 00:08:30,365

bunch of packages and a bunch of like

cloud space and like all these sort of

186

00:08:30,365 --> 00:08:32,465

support and all these different things.

187

00:08:32,465 --> 00:08:35,554

It's nothing that you really

need to use as an individual.

188

00:08:35,735 --> 00:08:39,183

Like literally everything that I've

ever done with R I've never paid for,

189

00:08:39,335 --> 00:08:42,005

and I've done it strictly with the R

download and our studio from Posit.

190

00:08:42,005 --> 00:08:44,705

So I think you guys are in good

shape and once again, R is free.

191

00:08:45,060 --> 00:08:47,850

The third scripting language we're

gonna be talking about actually

192

00:08:47,850 --> 00:08:49,620

really isn't a scripting language.

193

00:08:49,620 --> 00:08:53,250

It's more of a database language, but

it's sql, and that stands for structured

194

00:08:53,250 --> 00:08:56,910

query language, and that's the language

that you use to talk to databases.

195

00:08:56,910 --> 00:08:59,310

And so if you need to practice

with databases, you need to

196

00:08:59,310 --> 00:09:00,570

talk to an actual database.

197

00:09:00,720 --> 00:09:01,650

How do you download it?

198

00:09:01,650 --> 00:09:02,910

Does it cost millions of dollars?

199

00:09:03,180 --> 00:09:04,020

Well, no.

200

00:09:04,020 --> 00:09:08,100

The truth is most sequel is free, and

there's lots of different sequel flavors.

201

00:09:08,445 --> 00:09:09,735

Lots of different SQL softwares.

202

00:09:09,765 --> 00:09:13,515

I'm not gonna cover all of them today,

but I will show you my personal favorite

203

00:09:13,515 --> 00:09:14,865

that I have downloaded on my machine.

204

00:09:15,045 --> 00:09:16,755

So I really like my sql.

205

00:09:16,755 --> 00:09:17,835

Is there a reason why?

206

00:09:17,835 --> 00:09:18,435

I don't know.

207

00:09:18,435 --> 00:09:18,945

I like it.

208

00:09:18,945 --> 00:09:21,795

It's fine, but there's a

community edition that's free.

209

00:09:22,005 --> 00:09:22,800

You can literally go to this link.

210

00:09:23,439 --> 00:09:26,680

You can download the MySQL installer

for windows or whatever computer

211

00:09:26,680 --> 00:09:29,890

you have, and then make sure you

also install the MySQL Workbench.

212

00:09:30,160 --> 00:09:34,630

This is like the IDE that's gonna let you

easily use MySQL on your computer, and

213

00:09:34,630 --> 00:09:38,079

then literally with those two downloads,

you can write queries, design databases,

214

00:09:38,079 --> 00:09:41,920

see your data, like do anything you

would do in any sort of SQL program.

215

00:09:42,100 --> 00:09:43,000

For absolutely free.

216

00:09:43,090 --> 00:09:44,500

It can handle millions of rows.

217

00:09:44,500 --> 00:09:46,090

It's real, it's production grade.

218

00:09:46,090 --> 00:09:49,960

There's no really limitations on it other

than like there is a paid version that's

219

00:09:49,960 --> 00:09:53,950

sold by Oracle and that can like, that

can be like thousands of dollars, right?

220

00:09:53,950 --> 00:09:55,065

And that's gonna get you more enterprise.

221

00:09:55,410 --> 00:09:59,760

Solutions like monitoring and backups

and security and all that boring stuff

222

00:09:59,760 --> 00:10:01,980

that we don't care about as individuals.

223

00:10:02,010 --> 00:10:04,530

But if you're just learning

sql, this is an awesome option.

224

00:10:04,560 --> 00:10:05,520

That's more than enough.

225

00:10:05,550 --> 00:10:06,780

You don't even need anything else.

226

00:10:06,810 --> 00:10:09,510

But if you're interested in

other SQL flavors, Postgres

227

00:10:09,540 --> 00:10:10,920

has a very similar download.

228

00:10:11,219 --> 00:10:15,120

Postgres sql, very similar to

MySQL and as well as SQL Lights

229

00:10:15,120 --> 00:10:16,770

has a free download as well.

230

00:10:17,069 --> 00:10:20,490

You can check out all three of those,

and even, and I've been gatekeeping

231

00:10:20,490 --> 00:10:22,980

this for a while, so if you're

listening, listen really closely.

232

00:10:23,040 --> 00:10:27,449

Downloading and installing and using SQL

via these free tools isn't always easy.

233

00:10:27,449 --> 00:10:30,780

And so in my bootcamp program,

we have two modules on sql.

234

00:10:31,050 --> 00:10:34,500

The second one, we actually go through

the steps of, you know, downloading

235

00:10:34,500 --> 00:10:37,199

my SQL into their local machines and

setting it up and actually querying

236

00:10:37,199 --> 00:10:40,530

the databases from there and creating

a project off those databases.

237

00:10:40,800 --> 00:10:44,880

But for the first module, the first

project that I have my students do, uh,

238

00:10:44,880 --> 00:10:48,689

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

through the headache of downloading sql.

239

00:10:48,689 --> 00:10:50,069

I just want them to be able to focus.

240

00:10:50,564 --> 00:10:51,974

On actual SQL Command.

241

00:10:51,974 --> 00:10:53,055

SQL queries, right?

242

00:10:53,055 --> 00:10:53,985

And SQL results.

243

00:10:54,224 --> 00:10:57,255

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

installation and we use this free

244

00:10:57,255 --> 00:10:58,724

tool that I've been gate keeping.

245

00:10:58,964 --> 00:11:01,515

It's called CSV fiddle.io.

246

00:11:01,755 --> 00:11:05,655

And what it allows you to do is actually

just upload a CSV file and then write

247

00:11:05,655 --> 00:11:07,785

SQL commands against that CSV file.

248

00:11:07,995 --> 00:11:12,045

So it is a lot easier to set up and

actually practice your SQL than having

249

00:11:12,045 --> 00:11:16,245

to install, you know, the SQL installer

and the workbench and everything else.

250

00:11:16,245 --> 00:11:19,574

So if that's of interest to

you, check it [email protected].

251

00:11:20,105 --> 00:11:21,790

And of course it'll be linked

in the show notes down below.

252

00:11:22,185 --> 00:11:25,245

And that concludes our second

category of scripting languages.

253

00:11:25,245 --> 00:11:28,515

And we're moving on to the third, which

is, I've called business intelligence.

254

00:11:28,515 --> 00:11:30,885

Really it's just data

visualization and dashboarding.

255

00:11:31,185 --> 00:11:33,375

And we're gonna cover

Tableau and Power bi.

256

00:11:33,405 --> 00:11:34,425

Let's start with Tableau.

257

00:11:34,725 --> 00:11:37,660

Tableau is one of the most popular

data visualization tools in industry.

258

00:11:38,395 --> 00:11:41,095

And it's historically pretty expensive.

259

00:11:41,095 --> 00:11:44,665

In fact, when I worked at ExxonMobil,

I was not allowed to have Tableau.

260

00:11:44,875 --> 00:11:47,905

I didn't have a Tableau license because

they were so expensive and there was

261

00:11:47,905 --> 00:11:49,435

none of them free at the company.

262

00:11:49,435 --> 00:11:53,095

I wasn't cool enough to have a Tableau

license, so it is pretty expensive

263

00:11:53,095 --> 00:11:55,795

if you're gonna try to pay on your

own or even four, your company to

264

00:11:55,795 --> 00:11:57,085

pay for it, at least Historically.

265

00:11:57,085 --> 00:11:59,935

That was obviously like five plus years

ago, so maybe it's changed since then.

266

00:12:00,055 --> 00:12:02,875

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

wanna use Tableau, but it costs so much.

267

00:12:02,905 --> 00:12:05,545

Well, there's a free Tableau

version that you can use.

268

00:12:05,545 --> 00:12:06,775

It costs $0.

269

00:12:06,959 --> 00:12:11,970

And it's basically called Tableau Public,

so you can find [email protected],

270

00:12:12,390 --> 00:12:15,390

and you'll have the option to

actually do two different ways

271

00:12:15,390 --> 00:12:16,530

to use this Tableau public.

272

00:12:16,650 --> 00:12:19,020

The first one is you can actually

create an account and do web

273

00:12:19,020 --> 00:12:21,180

authoring and use Tableau online.

274

00:12:21,180 --> 00:12:24,510

And then the second one is the Tableau

desktop free edition, where you

275

00:12:24,510 --> 00:12:28,140

actually download Tableau onto your

computer and use it on your computer.

276

00:12:28,140 --> 00:12:29,730

And this gives you a

little bit more of the.

277

00:12:30,010 --> 00:12:33,670

Uh, authoring experience you'd have if

you had the full version of Tableau,

278

00:12:33,910 --> 00:12:38,140

because I will say there are some pretty

heavy limitations with Tableau public.

279

00:12:38,140 --> 00:12:41,199

And the first thing is

everything you create is going

280

00:12:41,199 --> 00:12:42,729

to be visible for the public.

281

00:12:43,110 --> 00:12:47,160

So if you have embarrassing data sets,

private data sets, proprietary data

282

00:12:47,160 --> 00:12:50,459

sets, you probably don't wanna be

using Tableau public for that because

283

00:12:50,760 --> 00:12:51,990

it's gonna be shown everywhere.

284

00:12:51,990 --> 00:12:55,020

So just know that off the top of your

head, like everything that you put

285

00:12:55,020 --> 00:12:56,850

in Tableau can be shown to the world.

286

00:12:56,970 --> 00:13:00,300

There's also a bunch of other limitations

on what type of graphs you can make,

287

00:13:00,329 --> 00:13:01,680

what type of files you can connect to.

288

00:13:01,680 --> 00:13:04,380

I think it's only like Excel

CSV, Google Sheets, like you

289

00:13:04,380 --> 00:13:05,880

can't actually connect to sql.

290

00:13:06,030 --> 00:13:08,819

Um, there might be like some limit

on how big those data sets are.

291

00:13:09,085 --> 00:13:12,295

And there's not really like any sort of

automation or sharing capabilities other

292

00:13:12,295 --> 00:13:13,885

than sharing to everyone on the web.

293

00:13:14,065 --> 00:13:15,895

It also doesn't include

anything like Tableau Prep.

294

00:13:15,895 --> 00:13:17,935

That was Tableau's

product for data cleaning.

295

00:13:17,935 --> 00:13:19,825

You kinda have to clean your

data beforehand and then

296

00:13:19,825 --> 00:13:20,965

put it inside a tableau.

297

00:13:21,175 --> 00:13:24,595

But honestly, for any aspiring data

analyst, everyone in my bootcamp,

298

00:13:24,655 --> 00:13:26,365

Tableau Public is more than enough.

299

00:13:26,365 --> 00:13:28,075

Like you can learn the core of Tableau.

300

00:13:28,510 --> 00:13:32,170

Of data visualization, of dashboarding

on the free version, and you can

301

00:13:32,170 --> 00:13:34,870

even publish 'em on Tableau public,

and then you can use that in your

302

00:13:34,870 --> 00:13:36,550

portfolio when you're applying for jobs.

303

00:13:36,550 --> 00:13:41,050

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

just getting started, Tableau costs $0.

304

00:13:41,050 --> 00:13:41,680

It's absolutely free.

305

00:13:42,060 --> 00:13:45,480

Alright, next is the other

data visualization tool that's

306

00:13:45,480 --> 00:13:48,300

really popular right now and

that is Power BI from Microsoft.

307

00:13:48,600 --> 00:13:51,960

And Power BI has a free plan,

but it's from Microsoft, so they

308

00:13:51,960 --> 00:13:55,740

try to make it as confusing as

possibly that they possibly can.

309

00:13:55,740 --> 00:13:56,970

Like it is so confusing.

310

00:13:57,420 --> 00:14:00,270

Uh, if you go to pricing right

here, you're not gonna be able to

311

00:14:00,300 --> 00:14:02,310

see like, oh, start free, right?

312

00:14:02,310 --> 00:14:04,050

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

313

00:14:04,350 --> 00:14:05,820

Anyways, it's so confusing.

314

00:14:05,850 --> 00:14:07,530

It's really hard to know how to use.

315

00:14:07,905 --> 00:14:10,365

Uh, and also you can't

even use it on a Mac.

316

00:14:10,455 --> 00:14:11,115

That sucks.

317

00:14:11,115 --> 00:14:12,885

That's like half the

world uses a Mac, right?

318

00:14:12,885 --> 00:14:16,155

So what are you gonna do if you're,

you wanna use power beyond your Mac,

319

00:14:16,395 --> 00:14:18,915

and that's because Microsoft and Apple

are rivals and everything, right?

320

00:14:18,975 --> 00:14:22,365

The other caveat to actually getting

a Power BI account is you need to

321

00:14:22,365 --> 00:14:25,485

have some sort of a business email, at

least when I downloaded it last, which

322

00:14:25,485 --> 00:14:26,420

was probably like three years ago.

323

00:14:27,180 --> 00:14:29,580

So if you have like a Gmail or

an Outlook account, it's probably

324

00:14:29,580 --> 00:14:32,100

gonna be hard to actually download

Power bi, which is one of the

325

00:14:32,100 --> 00:14:33,810

reasons I teach my students Tableau.

326

00:14:33,810 --> 00:14:35,970

It's just so much easier

to access than Power bi.

327

00:14:35,970 --> 00:14:38,670

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

Windows or Mac and you don't have to

328

00:14:38,670 --> 00:14:39,840

have any sort of special email to do.

329

00:14:39,840 --> 00:14:40,080

So.

330

00:14:40,110 --> 00:14:42,060

That being said, all these

hoops you have to jump through.

331

00:14:42,060 --> 00:14:43,860

Once you find the right link,

which once again, we'll have the

332

00:14:43,860 --> 00:14:45,060

link in the show notes down below.

333

00:14:45,345 --> 00:14:48,135

You can download it and press

download for free, and you can

334

00:14:48,135 --> 00:14:50,025

literally do everything in Power bi.

335

00:14:50,055 --> 00:14:52,485

You can connect to a bunch

of different data sources.

336

00:14:52,755 --> 00:14:56,265

You can use their data models, you can

create the dashboards, the reports.

337

00:14:56,265 --> 00:14:58,575

It's really pretty much

like the paid version.

338

00:14:58,605 --> 00:15:02,235

But that being said, you can't really

share those reports with anyone.

339

00:15:02,475 --> 00:15:04,575

Like they, it's basically the

opposite of Tableau Public, where

340

00:15:04,575 --> 00:15:07,335

it's like Tableau Public, everything

you do is shown to the world.

341

00:15:07,575 --> 00:15:09,615

Power BI is like, you can't

show anyone about this.

342

00:15:09,615 --> 00:15:11,715

If you wanna show anyone other than

yourself, you gotta pay us money.

343

00:15:11,920 --> 00:15:16,120

That being said, a lot of companies

who have like the Microsoft 365

344

00:15:16,120 --> 00:15:20,380

plan, they actually have Power

BI included with their, you know,

345

00:15:20,380 --> 00:15:22,270

corporate services agreement.

346

00:15:22,270 --> 00:15:26,079

So a lot of companies have Power BI

for absolutely free at the company,

347

00:15:26,079 --> 00:15:27,010

or they're already paying for it.

348

00:15:27,219 --> 00:15:29,319

That was the case at Exxon, which

is why they wouldn't let me have

349

00:15:29,319 --> 00:15:32,709

Tableau is you already have Power bi,

you don't need to have a Second BI

350

00:15:32,709 --> 00:15:34,420

tool, and they were kind of right.

351

00:15:34,420 --> 00:15:36,520

And there's some pros and cons

to each one of these tools.

352

00:15:36,849 --> 00:15:39,910

That being said, even if you're just

creating these dashboards, most of

353

00:15:39,910 --> 00:15:41,140

the time it's gonna be for yourself.

354

00:15:41,459 --> 00:15:44,850

Right, so you can create these dashboards

for yourself inside of your local

355

00:15:44,850 --> 00:15:48,810

machine and just maybe do a screenshot

of them for your, uh, portfolio.

356

00:15:48,810 --> 00:15:51,719

You don't have to be showing the

world your Power BI dashboards.

357

00:15:52,020 --> 00:15:54,839

So really for you as an aspiring data

analyst who's just trying to practice

358

00:15:54,839 --> 00:15:56,725

and create a portfolio, power BI is free.

359

00:15:57,310 --> 00:16:01,330

And that's it for our business

intelligence and data visualization tools.

360

00:16:01,330 --> 00:16:04,360

Let's go ahead and move

on to the AI tools.

361

00:16:04,480 --> 00:16:05,770

The first one is Claude.

362

00:16:05,770 --> 00:16:06,640

You've never heard of Claude.

363

00:16:06,640 --> 00:16:10,870

It's very similar to chat GPT in

terms of like a chat interface.

364

00:16:11,140 --> 00:16:12,970

However, I think it writes

a little bit better.

365

00:16:12,970 --> 00:16:14,500

I think it analyzes data a little better.

366

00:16:14,500 --> 00:16:16,689

I think it does a lot of

things a little bit better.

367

00:16:16,689 --> 00:16:20,800

Not everything, but a lot of like the

data tasks or knowledge worker tasks.

368

00:16:20,800 --> 00:16:24,370

I think it does better, and this is

one of the ones I actually pay for.

369

00:16:24,370 --> 00:16:25,630

So the free version.

370

00:16:25,820 --> 00:16:28,430

You're able to have like the

chat, like, um, you know, chat

371

00:16:28,430 --> 00:16:29,750

GPT on your phone or whatever.

372

00:16:29,750 --> 00:16:32,030

You can still generate code

and visualize data and write

373

00:16:32,030 --> 00:16:33,950

everything and access the web.

374

00:16:34,220 --> 00:16:36,740

Um, they're just gonna limit

you on how often you can use

375

00:16:36,740 --> 00:16:38,540

it, and it's pretty limited.

376

00:16:38,750 --> 00:16:40,970

Claude's pretty tight with

how much they let you use it.

377

00:16:41,390 --> 00:16:44,720

Then there's a $17 plan that

will get you what's called Code

378

00:16:44,720 --> 00:16:46,190

Claude Code and Claude Cowork.

379

00:16:46,490 --> 00:16:48,200

These are two features I really like.

380

00:16:48,530 --> 00:16:50,025

Um, cowork allows you to.

381

00:16:50,700 --> 00:16:54,210

Give Claude access to your computer

and allow it to do things locally on

382

00:16:54,210 --> 00:16:57,480

your computer, which is really nice for

analyzing data, creating PowerPoints,

383

00:16:57,480 --> 00:16:58,380

those type of different things.

384

00:16:58,740 --> 00:17:02,760

And Claude code is really fancy

way to do algorithmic coding.

385

00:17:03,060 --> 00:17:07,140

Um, it's basically using automation

agents to actually code different things.

386

00:17:07,500 --> 00:17:10,108

Um, for the Skippy for building websites,

whatever you would normally code, you

387

00:17:10,108 --> 00:17:12,450

could definitely use cloud code to do

it and it would do a really good job.

388

00:17:13,050 --> 00:17:15,420

And it also gives you a

little bit better researcher.

389

00:17:15,780 --> 00:17:18,540

Um, like to actually search and

then there's some different plugins

390

00:17:18,540 --> 00:17:21,780

like Claude for Excel and Claude for

PowerPoint, those types of things.

391

00:17:21,780 --> 00:17:23,250

So paying really makes sense.

392

00:17:23,250 --> 00:17:26,609

One of the reasons I pay and then

actually there's a max plan that

393

00:17:26,609 --> 00:17:27,780

costs a hundred dollars per month.

394

00:17:28,140 --> 00:17:30,660

That basically gives you more

access to do all these different

395

00:17:30,660 --> 00:17:32,370

things and more advanced features.

396

00:17:32,610 --> 00:17:35,430

I actually pay a hundred bucks a

month for Claude right now, and I

397

00:17:35,460 --> 00:17:36,750

think it's a hundred percent worth it.

398

00:17:36,750 --> 00:17:40,560

So Claude's one of these tools that

I think you might need to pay for.

399

00:17:40,889 --> 00:17:44,669

Um, you could probably get a lot of the

way with just the free version, but like

400

00:17:44,699 --> 00:17:47,760

you can use it for so many different

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

401

00:17:47,760 --> 00:17:49,080

definitely think it's worth paying for.

402

00:17:49,425 --> 00:17:53,055

So clot is $0, but I think if

you want the best use out of

403

00:17:53,055 --> 00:17:54,075

it, you should probably pay.

404

00:17:54,285 --> 00:17:57,465

That brings us to our next tool,

which I'm sure all of you guys have

405

00:17:57,465 --> 00:17:59,355

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

406

00:17:59,355 --> 00:18:02,475

GPT is still really useful

for doing data analysis.

407

00:18:02,475 --> 00:18:06,405

I pay for the paid version of chat

GPT as well, but in the free version

408

00:18:06,405 --> 00:18:09,165

you're gonna be able to get a lot

of the stuff done that you need to.

409

00:18:09,465 --> 00:18:11,655

If you've never heard of chat

GPT before, it's basically like

410

00:18:11,865 --> 00:18:13,245

what you used to use Google for.

411

00:18:13,245 --> 00:18:16,755

You can use chat GPT for and a lot more,

and I'm pretty sure everyone listening

412

00:18:16,755 --> 00:18:18,495

has heard of chat GPT at this point.

413

00:18:18,710 --> 00:18:21,320

In terms of pricing, they do have

a free plan where basically you're

414

00:18:21,320 --> 00:18:25,100

not gonna get as good of access or

as much access to their good models.

415

00:18:25,399 --> 00:18:27,110

They're gonna limit you on

everything, and I think they're even

416

00:18:27,110 --> 00:18:28,520

gonna give you ads at this point.

417

00:18:28,520 --> 00:18:30,230

I don't know if they've

actually integrated that or not.

418

00:18:30,320 --> 00:18:34,610

I actually pay for plus at this point,

but I think I'm going to be canceling

419

00:18:34,610 --> 00:18:37,760

it probably 'cause I mostly use Claude

and I pay a lot for Claude right now.

420

00:18:37,780 --> 00:18:41,110

And the last tool I wanna tell

you about that is totally free as

421

00:18:41,110 --> 00:18:42,970

a data analyst is called GitHub.

422

00:18:43,210 --> 00:18:46,750

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

but that's the only place that really

423

00:18:46,750 --> 00:18:48,760

felt like it belonged in a category.

424

00:18:48,850 --> 00:18:53,470

And the reason why is, I think this

will become more important with ai.

425

00:18:53,770 --> 00:18:55,180

GitHub has really become like.

426

00:18:55,620 --> 00:18:58,890

The middleman for a lot of AI

things, and I think it's only

427

00:18:58,890 --> 00:19:00,630

gonna get more and more use.

428

00:19:00,780 --> 00:19:02,940

And so I think it's important that

I start talking about it a little

429

00:19:02,940 --> 00:19:04,080

bit more than I have historically.

430

00:19:04,260 --> 00:19:06,750

Historically, I haven't talked about

it that much because it is a little

431

00:19:06,750 --> 00:19:08,160

bit complicated to get started.

432

00:19:08,460 --> 00:19:11,490

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

really use it at my jobs all that

433

00:19:11,490 --> 00:19:13,410

much that often, like it doesn't.

434

00:19:13,510 --> 00:19:15,970

It only integrates really

with code and with writing,

435

00:19:15,970 --> 00:19:17,020

kind of, but it's mostly code.

436

00:19:17,260 --> 00:19:20,920

So if I was using Power BI, like I was

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

437

00:19:20,920 --> 00:19:23,379

make sense to be using GitHub as much.

438

00:19:23,379 --> 00:19:25,450

But if you're coding Python,

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

439

00:19:25,450 --> 00:19:27,879

or any other coding, it makes a

lot of sense to be using GitHub.

440

00:19:28,030 --> 00:19:31,000

And I think in the future this

is going to be more important

441

00:19:31,000 --> 00:19:32,860

and it costs $0 for, for you.

442

00:19:32,860 --> 00:19:35,140

What GitHub does, if you're not

familiar with it, is think of

443

00:19:35,140 --> 00:19:37,060

it as like Google Docs for code.

444

00:19:37,390 --> 00:19:38,410

It allows you to.

445

00:19:38,834 --> 00:19:41,774

Uh, put your code online, have

it be stored somewhere and like

446

00:19:41,834 --> 00:19:42,915

share it with someone else.

447

00:19:43,155 --> 00:19:45,375

So for example, I could share any of

my code I've ever written with you

448

00:19:45,375 --> 00:19:48,584

guys through a GitHub link and you

could click on it and download all

449

00:19:48,584 --> 00:19:50,834

of the different, uh, coding files.

450

00:19:50,865 --> 00:19:53,834

And I think it's gonna be

really important in the future.

451

00:19:53,834 --> 00:19:56,625

So I just wanted to mention it as a

really good resource and it costs you $0.

452

00:19:56,865 --> 00:19:59,774

Of course, there are paid versions of it,

and that's the most important thing I need

453

00:19:59,774 --> 00:20:01,455

to tell you is that once you land a job.

454

00:20:01,860 --> 00:20:03,420

You're not gonna be paying for any tools.

455

00:20:03,600 --> 00:20:05,760

The company's gonna be

paying for all of your tools.

456

00:20:06,030 --> 00:20:09,540

So really in the beginning, you can get

away as an aspiring data analyst using

457

00:20:09,540 --> 00:20:12,960

all these tools for free, or paying for a

little bit of them, maybe here and there.

458

00:20:13,110 --> 00:20:14,850

But then once you're on the job,

you're not gonna have to pay

459

00:20:14,850 --> 00:20:17,640

for all any of these different

tools that you're gonna be using.

460

00:20:17,910 --> 00:20:19,380

The company's going to be paying for them.

461

00:20:19,530 --> 00:20:21,810

So I know I kind of blew through

those and did those really quickly.

462

00:20:21,810 --> 00:20:24,630

But that link, the description down

below will have instructions on how

463

00:20:24,630 --> 00:20:28,200

to get all these different tools for

free and what you're actually missing

464

00:20:28,200 --> 00:20:29,880

by not doing the paid versions.

465

00:20:30,220 --> 00:20:32,695

So make sure you click on that link down

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

Share Episode

Shownotes

Transcripts

Follow

Links

Chapters

Video

More from YouTube