Slide 1

Slide 1 text

Democratizing Data Democratizing Data Making data accessible at the New York Times

Slide 2

Slide 2 text

Making Data Useful Making Data Useful Answering Questions

Slide 3

Slide 3 text

Analyst Stakeholder Database

Slide 4

Slide 4 text

How are we doing? From: Advertising To: Analysts select date, revenue from revenue_table where date>2015-01-01 and date

Slide 5

Slide 5 text

(Fake Data) Re: How are we doing? From: Analysts To: Advertising

Slide 6

Slide 6 text

Numbers need Numbers need context context

Slide 7

Slide 7 text

328 homicides 328 homicides in in NYC in 2014 NYC in 2014

Slide 8

Slide 8 text

source: http://en.wikipedia.org/wiki/Crime_in_New_York_City#cite_note-one-177

Slide 9

Slide 9 text

(Fake Data) Re: How are we doing? From: Advertising To: Analysts

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

"Email Guilt" "Email Guilt"

Slide 12

Slide 12 text

Meeting Agenda Meeting Agenda "Get on same page" Read every bullet on slides out loud Review stuff we already know Tangential conversation with one person

Slide 13

Slide 13 text

Push Push

Slide 14

Slide 14 text

Pull Pull Easy Answer Machine

Slide 15

Slide 15 text

Building the Building the Easy Answer Machine

Slide 16

Slide 16 text

Requirements Requirements Easy to use Visual Answer questions Up-to-date

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

Identify and Identify and answer the main answer the main question first question first

Slide 19

Slide 19 text

Who's winning the election? Who's winning the election? http://elections.nytimes.com/2014/results/senate?utm_source=top_nav&utm_medium=web&utm_campaign=election-2014

Slide 20

Slide 20 text

Re: What are people reading? From: Newsroom To: Analysts tutorial at: http://bl.ocks.org/charlesdguthrie/11356441

Slide 21

Slide 21 text

How are we doing? From: Advertising To: Analysts Do I need to be worried? How are we doing?

Slide 22

Slide 22 text

Re: How are we doing? From: Advertising To: Analysts

Slide 23

Slide 23 text

Matching the chart Matching the chart to the question to the question

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

relationships between two variables trends and changes; historical context simple comparisons comparisons with historical context Multi-Line Chart Multi-Line Chart

Slide 26

Slide 26 text

Comparing values with historical context source: http://www.nytimes.com/interactive/2009/11/06/business/economy/unemployment-lines.html

Slide 27

Slide 27 text

(Fake Data) Comparing values with historical context

Slide 28

Slide 28 text

Answering Answering questions questions without without charts... charts...

Slide 29

Slide 29 text

Re: How are we doing? From: Advertising To: Analysts

Slide 30

Slide 30 text

Re: How are we doing? From: Advertising To: Analysts (Fake Data)

Slide 31

Slide 31 text

Answering Answering questions questions without without charts... charts... ...or with nothing at all ...or with nothing at all

Slide 32

Slide 32 text

Nothing to tell Nothing to tell Do I need to be worried? From: Advertising To: Analysts

Slide 33

Slide 33 text

Alert! Revenue dropped by 27% From: Dash To: Advertising

Slide 34

Slide 34 text

"OK, why?" "OK, why?" Follow-up Questions

Slide 35

Slide 35 text

Overview first, Overview first, zoom and filter, zoom and filter, then details-on-demand then details-on-demand - Ben Shneiderman - Ben Shneiderman

Slide 36

Slide 36 text

Election: How close is it? Election: How close is it? http://elections.nytimes.com/2014/results/senate?utm_source=top_nav&utm_medium=web&utm_campaign=election-2014

Slide 37

Slide 37 text

Re: What are people reading? From: Newsroom To: Analysts How do people reach our articles?

Slide 38

Slide 38 text

(Fake Data)

Slide 39

Slide 39 text

WHY HAS REVENUE DROPPED BY 25%?!? From: Advertising To: Analysts (Fake Data) Re: How are we doing

Slide 40

Slide 40 text

Why is revenue down? Why is revenue down? Zoom Filter Filter Details on Demand

Slide 41

Slide 41 text

Demo Demo http://localhost:3274/#/site-activities

Slide 42

Slide 42 text

Data, Democratized Data, Democratized Results

Slide 43

Slide 43 text

Data, Democratized Data, Democratized Page Views Visitors Homepage stats Products Video Subscriptions Crosswords Advertising Personalization A/B Tests Data Governance URLs Opinion Top Articles Etc. 18 Teams Over 100 charts Crosswords

Slide 44

Slide 44 text

No content

Slide 45

Slide 45 text

Freed up for more advanced problems Building out more tools Use data rather than intuition More insightful questions Analysts Stakeholders

Slide 46

Slide 46 text

Meeting Agenda Meeting Agenda (now that everyone is informed) discuss analytics insights make informed decisions

Slide 47

Slide 47 text

Things we Learned Things we Learned Answer the main question first Pick the right chart - or no chart Zoom and filter for followup questions

Slide 48

Slide 48 text

Data Awareness Data Awareness Data-Driven Decisions Data-Driven Decisions

Slide 49

Slide 49 text

charlieguthrie.net @charlieguthrie linkedin.com/in/guthriecharlie Thank you Thank you