data-driven enterprise off your beat - steve doig - seattle newstrain - 11.11.17
TRANSCRIPT
![Page 1: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/1.jpg)
DATA-DRIVEN
ENTERPRISE
OFF YOUR BEATSteve Doig
Cronkite School of Journalism
Arizona State University
@sdoig
![Page 2: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/2.jpg)
WHY DEVELOP
DATA SKILLS?
![Page 3: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/3.jpg)
![Page 4: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/4.jpg)
Your resume
![Page 5: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/5.jpg)
Your resume
![Page 6: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/6.jpg)
What have you done with data?
![Page 7: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/7.jpg)
Our agenda today
How to:
• Identify the skills you need
• Find data on your beat
• Develop your data story idea
• Get started with Excel
• Pick your next data story
and get going!
![Page 8: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/8.jpg)
WHAT SKILLS DO
YOU NEED?
![Page 9: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/9.jpg)
![Page 10: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/10.jpg)
![Page 11: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/11.jpg)
![Page 12: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/12.jpg)
Brain tools – math and statistics
![Page 13: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/13.jpg)
Brain tools – math and statistics
![Page 14: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/14.jpg)
![Page 15: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/15.jpg)
FINDING DATA
FOR YOUR BEAT
![Page 16: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/16.jpg)
![Page 17: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/17.jpg)
Finding data story ideas
![Page 18: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/18.jpg)
Data sources on your beat
• Local bureaucracy
• Whistleblowers
• Regulators
• Licensing bodies
• Lawmakers
• Federal agencies
• Academics
![Page 19: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/19.jpg)
Recognize data when you see it
![Page 20: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/20.jpg)
Recognize data when you see it
![Page 21: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/21.jpg)
• Police corruption
• Campaign finance
• Vote fraud
• Slum lords
• Environmental problems
• Kickbacks to public officials
• Shady business practices
• Dangerous medical devices
• Racial discrimination
• Abusive teachers
Data-heavy
investigations
![Page 22: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/22.jpg)
![Page 23: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/23.jpg)
![Page 24: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/24.jpg)
DEVELOPING YOUR
DATA STORY IDEA
![Page 25: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/25.jpg)
Work backwards from your idea!
• What statements do you want to make?
• What variables are needed to make those
statements?
• Who would collect data with those
variables?
• How will you get the data from the collector?
![Page 26: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/26.jpg)
1. Statements?
• Lede = your hypothesis
• Bullet points = your
statements
![Page 27: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/27.jpg)
• Examples for a crime and courts story:
• “Crime has increased/decreased X %
since...”
• “The X per 100,000 violent crime rate of Y
City is the worst ...”
• “An average of X drivers are arrested every
day for DWI...”
1. Statements?
![Page 28: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/28.jpg)
• Examples for a crime and courts story:
• “Robberies peak between X and Y o’clock
on Z day...”
• “Only X % of reported crimes result in
arrests...”
• “One out of every X vehicles registered in
Y City gets stolen ...”
• “The average sentence from Judge X for
robbery is Y years...”
1. Statements?
![Page 29: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/29.jpg)
2. Variables needed?Columns are the variables.
![Page 30: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/30.jpg)
2. Variables needed?Rows are records
![Page 31: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/31.jpg)
2. Variables needed?• Two main kinds of variables:
• Categorical: Sex, city, postal code, type of
crime, hospital, type, etc...
![Page 32: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/32.jpg)
2. Variables needed?• Two main kinds of variables:
• Numeric: Age, cost, population, weight,
arrests, revenue, income, etc...
• ...
![Page 33: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/33.jpg)
• Example: variables for crime and courts story
• Type of crime
• Population
• Date, time
• Location
• Number of victims
• Arrest made?
• Disposition, judge, sentence...
2. Variables needed?
![Page 34: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/34.jpg)
3. Who collects those variables?
![Page 35: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/35.jpg)
4. Get the data!
![Page 36: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/36.jpg)
Public records tools
![Page 37: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/37.jpg)
Data formats?
![Page 38: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/38.jpg)
EXCEL EXERCISES
![Page 39: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/39.jpg)
Excel tools
•Sort
•Filter
•Functions
•Pivot tables
![Page 40: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/40.jpg)
![Page 41: Data-driven enterprise off your beat - Steve Doig - Seattle NewsTrain - 11.11.17](https://reader031.vdocuments.us/reader031/viewer/2022030318/5a6499d97f8b9a27568b7421/html5/thumbnails/41.jpg)