Artwork for podcast Data Career Podcast: Helping You Land a Data Analyst Job FAST
134: The Greatest Data Analyst of All Time (John Snow)
Episode 1345th November 2024 • Data Career Podcast: Helping You Land a Data Analyst Job FAST • Avery Smith - Data Career Coach
00:00:00 00:06:21

Share Episode

Shownotes

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!

Travel back to 1854 London and see how data visualization saved lives. John Snow’s use of data analytics to fight cholera is a groundbreaking story that still inspires analysts today.

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com//interviewsimulator

⌚ TIMESTAMPS

00:24 The Cholera Outbreak in London

01:04 John Snow's Revolutionary Hypothesis

02:58 Lessons for Modern Data Analysts

🔗 CONNECT WITH AVERY

🔗 CONNECT WITH AVERY

🎥 YouTube Channel

🤝 LinkedIn

📸 Instagram

🎵 TikTok

💻 Website

Mentioned in this episode:

⭐ Enjoy the show? Leave a rating

We are 57 reviews away from becoming the #1 data podcast in the world! If you haven't already, please take 30 seconds and leave us a rating!

Transcripts

Avery:

Today I'm going to tell you the story of one of the earliest and one of

2

:

the greatest data analysts of all time.

3

:

It's a story that had such a big

impact on my life that I actually

4

:

named my consulting company, Snow

Data Science, after this guy.

5

:

His name is John Snow.

6

:

And no, not the guy from Game of

Thrones, but an English physician

7

:

from the mid 1800s who saved a

country from a deadly outbreak of

8

:

cholera using only data analytics.

9

:

London, 1854, and there's a terrifying

disease sweeping the streets.

10

:

Cholera.

11

:

People are dropping like flies

and no one really knows why.

12

:

In fact, over 500 people had died in

this small area in the last 10 days.

13

:

At the time, most people believed that

cholera was spread through the air via

14

:

bad smells and what's called bad air.

15

:

Some people even believed that cholera

was really only coming out of the

16

:

cemeteries from people who had already

previously passed of the disease.

17

:

Basically, no one knew what was

going on in the disease world.

18

:

No one knew how people were getting

sick, They just knew that people were

19

:

getting sick at an alarming rate.

20

:

And with that knowledge, 75 percent of

that part of the city, Soho, fled due

21

:

to fear of contracting the disease.

22

:

Dr.

23

:

Jon Snow was determined to

figure out why these people were

24

:

getting sick and how to fix it.

25

:

You see, Jon was a doctor, and

he had this crazy idea that maybe

26

:

cholera wasn't spread through the

air, but rather through water.

27

:

And to us, that sounds pretty simple.

28

:

But at the time, it was

a revolutionary idea.

29

:

But no one would believe him.

30

:

So he knew he needed data to prove it.

31

:

So John hit the streets.

32

:

He started talking to people

who had gotten sick and asked

33

:

them a series of questions.

34

:

One of which was crucially,

Where are you getting your water?

35

:

And after interviewing dozens

of folks, he looked at his notes

36

:

and realized many had mentioned

getting water from the same well.

37

:

Which was the pump down on Broad Street.

38

:

A curious note, but nothing concrete.

39

:

John realized he needed more.

40

:

And here's where Snow did

something revolutionary and

41

:

thought like a data analyst.

42

:

He created a map of the streets of London

and plotted every cholera case on it.

43

:

Each water pump was highlighted

with a simple black circle, and each

44

:

case of cholera was indicated by a

simple black line stacked on top of

45

:

the other one to represent multiple

contractions at the same residence.

46

:

After constructing the graph, he found

that most of the deaths clustered around

47

:

one pump, the pump on Broad Street.

48

:

This gave him the data driven evidence

that maybe the disease was indeed in

49

:

the water, specifically at that pump.

50

:

This wasn't just a cool visualization that

he made, it was data analytics in action.

51

:

Armed with his data evidence,

he headed to the local officials

52

:

and presented his theory.

53

:

He showed them his map and asked them to

remove the handle of the pump which would

54

:

literally shut water down to that area.

55

:

The government obliged

and shut the pump down.

56

:

And guess what?

57

:

The cholera outbreak

slowed nearly immediately.

58

:

People stopped getting sick.

59

:

People stopped dying.

60

:

And the population of

London returned to the city.

61

:

This analysis didn't only save

lives, it actually changed

62

:

public health care forever.

63

:

Jon Snow's work is considered

one of the earliest examples

64

:

of data analytics in the UK.

65

:

and is still referred to

in pandemics or outbreaks.

66

:

Here are three simple ways that you and

I can be great analysts like Jon Snow.

67

:

Number one, visualize our data.

68

:

We as humans are not very

good at remembering numbers.

69

:

We can only really take a

look at 10 numbers at a time.

70

:

If you don't believe me, try to memorize a

telephone number in less than 10 seconds,

71

:

and if you can, you're above average.

72

:

If you don't believe me,

just try to remember this.

73

:

Number 8 0 1 5 7 2 2 7 7 8 4 3 2 1 7.

74

:

Go ahead and try to repeat that

in the comments down below.

75

:

If you get it, you're above average.

76

:

We as humans are just not good

at dealing with numbers, but

77

:

we are good at visualizing.

78

:

Our eyes are extremely powerful, and

so instead of trying to just understand

79

:

data inside of a notebook or instead

of a spreadsheet, when we visualize

80

:

data, that helps us understand it

better, and that was the key to success.

81

:

To John, figuring out what

was causing this disease.

82

:

Number two, we can storytell with data.

83

:

Notice that John didn't go to the

government and just, you know, show them

84

:

the map or just tell them the theory.

85

:

He combined the two.

86

:

He told a story.

87

:

In fact, they actually asked, well,

what is happening with this green

88

:

area right here and this green

area right here that you see on

89

:

the map, they're not getting sick.

90

:

Why are they not getting sick?

91

:

Even though they're really close

to this well, and he actually

92

:

went and interviewed those people

and found out that one was a bar.

93

:

And they said, quote, no

one drinks water here.

94

:

So those people were actually saved

from cholera by only drinking beer.

95

:

And the second one was actually

a prison where they actually have

96

:

their own well inside of the prison.

97

:

So he was able to illustrate the

full story with the data that was

98

:

able to convince the government

that this was the cause, even though

99

:

everyone thought it was in the air,

that it was actually in the water.

100

:

And number three, another

thing that Jon Snow did very

101

:

well is explain the outliers.

102

:

If you look at the map, you'll

notice that towards the bottom

103

:

and even some other places.

104

:

There are outliers.

105

:

There are people who contracted

cholera that were not close to

106

:

this pump and not using this pump.

107

:

This would actually hurt his

hypothesis, and he knew that.

108

:

So he actually went to those areas to talk

with those people and found out that many

109

:

of them had relatives or they had recently

visited that pump just a couple days ago.

110

:

So the outliers did not

hurt his case, they actually

111

:

ended up supporting his case.

112

:

If you want to be a great analyst

like Jon Snow, go ahead and hit

113

:

subscribe to get future episodes

that will help you get there.

Follow

Links

Chapters

Video

More from YouTube