Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Democratizing Data

Democratizing Data

Charles Guthrie, data visualization engineer, talk about making The New York Times more data-driven by expanding access to internal data through simple visualization tools.

(Presented at the Data Visualization Innovation Summit)

More Decks by The New York Times Developers

Other Decks in Design

Transcript

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

    View full-size slide

  2. Making Data Useful
    Making Data Useful
    Answering Questions

    View full-size slide

  3. Analyst Stakeholder
    Database

    View full-size slide

  4. How are we
    doing?
    From: Advertising
    To: Analysts
    select
    date,
    revenue
    from revenue_table
    where date>2015-01-01
    and dateWhat are people
    reading?
    From: Newsroom
    To: Analysts
    select
    article,
    current_page_views
    from streaming_event_tracker
    group by article

    View full-size slide

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

    View full-size slide

  6. Numbers need
    Numbers need
    context
    context

    View full-size slide

  7. 328 homicides
    328 homicides in
    in
    NYC in 2014
    NYC in 2014

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  10. "Email Guilt"
    "Email Guilt"

    View full-size slide

  11. 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

    View full-size slide

  12. Pull
    Pull
    Easy
    Answer
    Machine

    View full-size slide

  13. Building the
    Building the Easy
    Answer
    Machine

    View full-size slide

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

    View full-size slide

  15. Identify and
    Identify and
    answer the main
    answer the main
    question first
    question first

    View full-size slide

  16. 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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  20. Matching the chart
    Matching the chart
    to the question
    to the question

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  23. (Fake Data)
    Comparing values with historical context

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  32. 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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  37. Data, Democratized
    Data, Democratized
    Results

    View full-size slide

  38. 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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  42. Data Awareness
    Data Awareness
    Data-Driven Decisions
    Data-Driven Decisions

    View full-size slide

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

    View full-size slide