Open Data > 06: Open Data Journalism

1FS 2020

Vorlesung Open Data

Open Data Journalism

Termin 6, 26. März 2020

Dr. Matthias Stürmer

Dozentur Digitale NachhaltigkeitInstitut für WirtschaftsinformatikUniversität Bern

Open Data > 06: Open Data Journalism

2FS 2020

Terminübersicht Vorlesung

20. Februar 2020 Informationen zur Vorlesung, Einführung Open Data27. Februar 2020 Definition von OGD und Argumente dafür und dagegen5. März 2020 OGD Strategie Schweiz und das Impact Monitoring Framework12. März 2020 Entstehung und Anwendung des Öffentlichkeitsgesetz19. März 2020 Geistiges Eigentum und die Open-Bewegung26. März 2020 Open Data Journalism2. April 2020 Open Finance und Participatory Budgeting9. April 2020 Open Transport Data16. April 2020 Semesterferien23. April 2020 Open Geodata30. Mai 2020 Aid Transparency und Open Aid7. Mai 2020 Linked Data und Semantic Web14. Mai 2020 Open Corporate Data21. Mai 2020 Auffahrt28. Mai 2020 keine Vorlesung, am Nachmittag Abschlusspräsentationen Open Data Apps

Open Data > 06: Open Data Journalism

3FS 2020

1. Einführung und einige Daten-journalistische Beispiele

2. Data Journalism Handbook

3. Infografiken zur Darstellung von Daten

Heutiger Ablauf

Open Data > 06: Open Data Journalism

4FS 2020

Was ist Datenjournalismus?

«Datenjournalisten finden die Geschichte zwischen Zahlen und Statistiken. Sie suchen Zusammenhänge im Vergleich von Daten, zum Beispiel Wohnort der Waffenbesitzer in Deutschland versus Anzahl der Morde durch Schusswaffen. Datenjournalismus reicht von lokal zu global, von Print zum Online-Auftritt des Fernsehsenders.»

Open Data > 06: Open Data Journalism

5FS 2020

Process of Data-Driven Journalism (DDJ)

http://en.wikipedia.org/wiki/Data-driven_journalism

http://en.wikipedia.org/wiki/Data-driven_journalism

Open Data > 06: Open Data Journalism

6FS 2020

Datenjournalismus.net

http://datenjournalismus.net/faq/

http://datenjournalismus.net/faq/

Open Data > 06: Open Data Journalism

7FS 2020

COVID-19 Story in der Washington Post

https://www.washingtonpost.com/graphics/2020/world/corona-simulator/

https://www.washingtonpost.com/graphics/2020/world/corona-simulator/

Open Data > 06: Open Data Journalism

8FS 2020

COVID-19 Story im Tagesanzeiger, Bund etc.

https://interaktiv.tagesanzeiger.ch/2020/covid-19-ausbruch-im-vergleich/

https://interaktiv.tagesanzeiger.ch/2020/covid-19-ausbruch-im-vergleich/

Open Data > 06: Open Data Journalism

9FS 2020

COVID-19 Story in der NZZ

https://www.nzz.ch/panorama/die-wichtigsten-grafiken-zum-coronavirus-ld.1542774

https://www.nzz.ch/panorama/die-wichtigsten-grafiken-zum-coronavirus-ld.1542774

Open Data > 06: Open Data Journalism

10FS 2020

NZZ Visuals

https://www.nzz.ch/visuals/

https://www.nzz.ch/visuals/

Open Data > 06: Open Data Journalism

11FS 2020

Interaktiv bei Tagesanzeiger, Bund etc.

https://interaktiv.tagesanzeiger.ch

https://interaktiv.tagesanzeiger.ch/

Open Data > 06: Open Data Journalism

12FS 2020

SRF Data

https://srfdata.github.io/ https://github.com/srfdata

https://srfdata.github.io/https://github.com/srfdata

Open Data > 06: Open Data Journalism

13FS 2020

Katalog von Datenjournalismus-Stories

268 Data Driven Journalism (DDJ) Projekte bis Mai 2016:

http://katalog.datenjournalismus.net/

http://katalog.datenjournalismus.net/

Open Data > 06: Open Data Journalism

14FS 2020

1. Einführung und einige Daten-journalistische Beispiele

2. Data Journalism Handbook

3. Infografiken zur Darstellung von Daten

Heutiger Ablauf

Open Data > 06: Open Data Journalism

15FS 2020

Data Journalism Handbook 2

> www.datajournalismhandbook.org

> Edited by Jonathan Gray and Liliana Bounegru

> Produced by European Journalism Centre and Google News Initiative

> Typical steps of a data story:1. Getting Data Collecting and preparing the data2. Understanding data Finding insights3. Delivering Data Visualization und story telling

http://www.datajournalismhandbook.org/

Open Data > 06: Open Data Journalism

16FS 2020 16https://datajournalism.com/read/handbook/one/front-matter/the-handbook-at-a-glance

https://datajournalism.com/read/handbook/one/front-matter/the-handbook-at-a-glance

Open Data > 06: Open Data Journalism

17FS 2020

1. Getting Data (and Preparing it)

> Information Freedom Request— Request to government agencies

> Open data portals— CH: http://opendata.swiss— EU: http://ec.europa.eu/eurostat— UN: http://data.un.org— IMF: http://data.imf.org— Worldbank: http://data.worldbank.org— List of Data Portals: http://dataportals.org

> Connecting, Crawling and Scraping— from APIs, websites, databases, Linked Data endpoints etc.

> Search on Google— Spreadsheets: filetype:XLS filetype:CSV— PDFs: filetype:pdf

> Preparing it data transformation!https://datajournalism.com/read/handbook/one/getting-data/

http://opendata.swiss/http://ec.europa.eu/eurostathttp://data.un.org/http://data.imf.org/http://data.worldbank.org/http://dataportals.org/https://datajournalism.com/read/handbook/one/getting-data/

Open Data > 06: Open Data Journalism

18FS 2020

Data transformation: XML, CSV to JSON etc.

https://www.csvjson.com https://www.convertcsv.com

https://www.csvjson.com/https://www.convertcsv.com/

Open Data > 06: Open Data Journalism

19FS 2020

Data transformation tool: OpenRefine

http://openrefine.org

http://openrefine.org/

Open Data > 06: Open Data Journalism

20FS 2020

Data transformation tool: Datawrangler

http://vis.stanford.edu/wrangler/app

http://vis.stanford.edu/wrangler/app

Open Data > 06: Open Data Journalism

21FS 2020

2. Understanding data

> Understand basic statistics: mean vs. median,correlation vs. causality, frequencies vs. Percentages etc.

> Tips for Working with Numbers in the News: (Michael Blastland) — «Don’t confuse skepticism about data with cynicism.»— «If you believe in data, try to let it speak before you slap on your own

mood, beliefs or expectations.»— «Uncertainty is ok.»

> Basic Steps in Working with Data: (Steve Doig)— Data requests should begin with a list of questions you want to answer.— Data often is messy and needs to be cleaned.— Data may have undocumented features. (Does this make sense?)

> Start With the Data, Finish With a Story.

https://datajournalism.com/read/handbook/one/understanding-data/

https://datajournalism.com/read/handbook/one/understanding-data/

Open Data > 06: Open Data Journalism

22FS 2020

Using visualization to Discover Insights

http://datajournalismhandbook.org/1.0/en/understanding_data_7.html

http://datajournalismhandbook.org/1.0/en/understanding_data_7.html

Open Data > 06: Open Data Journalism

23FS 2020

3. Delivering Data

> Visualizations can:— Help you identify themes and questions for the rest of your reporting— Identify outliers: good stories, or perhaps errors, in your data— Help you find typical examples— Show you holes in your reporting

> Using visualizations to tell stories

> Engaging People Around Your Data

https://datajournalism.com/read/handbook/one/delivering-data/

https://datajournalism.com/read/handbook/one/delivering-data/

Open Data > 06: Open Data Journalism

24FS 2020

Explaining the data

Open Data > 06: Open Data Journalism

25FS 2020

Simple visualizations: RAWGraphs

http://app.rawgraphs.io

http://app.rawgraphs.io/

Open Data > 06: Open Data Journalism

26FS 2020

1. Einführung und einige Daten-journalistische Beispiele

2. Data Journalism Handbook

3. Infografiken zur Darstellung von Daten

Heutiger Ablauf

Open Data > 06: Open Data Journalism

27FS 2020 27http://duelingdata.blogspot.com/2016/01/the-beatles.html

http://duelingdata.blogspot.com/2016/01/the-beatles.html

Open Data > 06: Open Data Journalism

28FS 2020 28https://popchart.co/products/the-magnificent-multitude-of-beer

https://popchart.co/products/the-magnificent-multitude-of-beer

Open Data > 06: Open Data Journalism

29FS 2020 29

Open Data > 06: Open Data Journalism

30FS 2020 30

Open Data > 06: Open Data Journalism

31FS 2020 31

Open Data > 06: Open Data Journalism

32FS 2020

What Makes a Good Infographic?

https://blog.dashburst.com/what-makes-a-good-infographic/

https://blog.dashburst.com/what-makes-a-good-infographic/

Open Data > 06: Open Data Journalism

33FS 2020

What Makes a Good Infographic?

1. Data— Reliable— Timely— Content

https://blog.dashburst.com/what-makes-a-good-infographic/

https://blog.dashburst.com/what-makes-a-good-infographic/

Open Data > 06: Open Data Journalism

34FS 2020

What Makes a Good Infographic?

2. Story— State the Problem or Issue— Time Frame— Deliver Message— Solution

https://blog.dashburst.com/what-makes-a-good-infographic/

https://blog.dashburst.com/what-makes-a-good-infographic/

Open Data > 06: Open Data Journalism

35FS 2020

What Makes a Good Infographic?

3. Design— Color theme and structure— Fonts— Graphics— Appearance

https://blog.dashburst.com/what-makes-a-good-infographic/

https://blog.dashburst.com/what-makes-a-good-infographic/

Open Data > 06: Open Data Journalism

36FS 2020

What Makes a Good Infographic?

4. Shareability— Relevance— Interestingness— Web optimization and SEO— Social media

https://blog.dashburst.com/what-makes-a-good-infographic/

https://blog.dashburst.com/what-makes-a-good-infographic/

Open Data > 06: Open Data Journalism

37FS 2020

Zwei Icon-Sammlungen

https://streamlineicons.com

https://icons.getbootstrap.com

https://streamlineicons.com/https://icons.getbootstrap.com/

Open Data > 06: Open Data Journalism

38FS 2020

Coronavirus-Hackathon nächste Woche

https://www.versusvirus.ch

https://www.versusvirus.ch/

Vorlesung Open Data��Open Data JournalismTerminübersicht VorlesungHeutiger AblaufWas ist Datenjournalismus?Process of Data-Driven Journalism (DDJ)Datenjournalismus.netCOVID-19 Story in der Washington PostCOVID-19 Story im Tagesanzeiger, Bund etc.COVID-19 Story in der NZZNZZ VisualsInteraktiv bei Tagesanzeiger, Bund etc.SRF DataKatalog von Datenjournalismus-StoriesHeutiger AblaufData Journalism Handbook 2Slide Number 161. Getting Data (and Preparing it)Data transformation: XML, CSV to JSON etc.Data transformation tool: OpenRefineData transformation tool: Datawrangler2. Understanding dataUsing visualization to Discover Insights3. Delivering DataExplaining the dataSimple visualizations: RAWGraphsHeutiger AblaufSlide Number 27Slide Number 28Slide Number 29Slide Number 30Slide Number 31What Makes a �Good Infographic?What Makes a Good Infographic?What Makes a Good Infographic?What Makes a Good Infographic?What Makes a Good Infographic?Zwei Icon-SammlungenCoronavirus-Hackathon nächste Woche