This resource page features course content from the Knight Center for Journalism in the America's massive open online course (MOOC) titled "Data Journalism and Visualization with Free Tools." The six-week course took place from October 14 to November 24, 2019. We are now making the content free and available to students who took the course and anyone else who's interested in interested in data journalism and visualization.
The course, which was powered by Google News Initiative, was taught by Alberto Cairo, Simon Rogers, and a great team of instructors. They created and curated the content for the course, which includes video classes, readings, exercises, and more.
The course materials are broken up into seven modules:
As you review this resource page, we encourage you to watch the videos, review the readings, and complete the exercises as time allows. The course materials build off each other, but the videos and readings also act as standalone resources that you can return to over time.
We hope you enjoy the materials. If you have any questions, please contact us at journalismcourses@austin.utexas.edu.
Alberto Cairo s the Knight Chair in Visual Journalism at the University of Miami. He’s also the director of the visualization program at UM’s Center for Computational Science. Cairo has been a director of infographics and multimedia at news publications in Spain (El Mundo, 2000-2005) and Brazil (Editora Globo, 2010-2012,) and a professor at the University of North Carolina-Chapel Hill. Besides teaching at UM, he works as a freelancer and permanent consultant for companies like Google. He’s the author of the books "The Functional Art: An Introduction to Information Graphics and Visualization" (2012) and "The Truthful Art: Data, Charts, and Maps for Communication."
Simon Rogers is an award-winning data journalist, writer and speaker. Author of "Facts are Sacred," published by Faber & Faber in the UK, China and South Korea. He has also written a range of infographics for children books from Candlewick. Data editor on the News Lab team at Google, based in San Francisco, he is director of the Data Journalism Awards and teaches Data Journalism at Medill-Northwestern University in San Francisco and has taught at U Cal Berkeley Journalism school.
Marco Túlio Pires is the Google News Lab Lead for Brazil. Before joining Google in 2017, Marco was School of Data’s program manager, a global network of organizations and trainers that help journalists and NGOs how to use data with maximum impact. Marco cofounded in 2015 the first data journalism agency in Brazil, journalismo++, part of the international j++ network of data-driven agencies. He also worked as a production coordinator at TV Globo, as a science news reporter at VEJA, and as an innovation, transparency and technology officer at the Social Development Office in the government of São Paulo. Marco holds a Bachelor’s Degree in Journalism from Universidade Federal de Minas Gerais, and he also studied Electrical Engineering at the Universidade Católica de Minas Gerais; Computer Science, Management for Social Impact and Information Visualization at the University of Michigan and Georgetown University. Today he supports publishers, journalists and media entrepreneurs in Brazil and Latin America with the best Google can offer so that they can build the future of media and tell the best stories of our time.
Jan Diehm is a journalist-engineer with The Pudding, where she uses data to craft visual stories. Before joining The Pudding, she had stops at CNN, The Guardian US, ABC News, HuffPost, the Baltimore Sun, and the Hartford Courant. She appreciates the finer things in life: LEGO sets, southern delicacies like pimento cheese, fried green tomatoes and good bourbon, and vintage Britney Spears. She lives in San Antonio with her wife and two cats.
Minhaz Kazi is a Developer Advocate at Google, focusing on Google Data Studio. A business intelligence veteran, Minhaz is always exploring new ways for developers to collect, analyze, and visualize data. He is available for long discussions on circular reference errors, benefits of pie charts, SQL commas, and the design of everyday things.
Dale Markowitz is an Applied AI Developer at Google Cloud. She works to help software engineers understand machine learning and serves as a technical advisor to the Google News Lab. Previously she worked in natural language processing for Google Research and at the online dating site OkCupid.
Duncan Clark is Co-founder of Flourish, a platform for data visualization and interactive storytelling. Flourish grew out of the award-winning work that Duncan and his co-founder Robin Houston produced through their data studio Kiln for clients such as Google, the Guardian, LSE and the UK government. Duncan was previously a data journalist, publisher and author. He worked as a consultant editor at the Guardian, as an executive editor at Penguin Books and Profile. His book, "The Burning Question" – coauthored with Mike Berners-Lee and written as as honorary researcher at University College London – is a data-driven look at global energy use and climate change.
Katherine Riley writes blogs and creates visualizations to showcase new Flourish features and templates, in addition to supporting newsroom users. She was previously a Google News Fellow at the Financial Times and an Editorial Fellow at The Atlantic.
Debra Anderson is a data executive, entrepreneur, speaker and educator recognized for innovative approaches to data storytelling. As Co-Founder and Chief Strategy Officer of Datavized Technologies, she developed free and open-source data tools for journalists and newsrooms with the support of Google News Initiative and the Online News Association and built immersive data visualization software using WebXR. She has led workshops at the Craig Newmark Graduate School of Journalism at the City University of New York, Massachusetts Institute of Technology, Harvard WeCode Conference and the United Nations. In 2018 Fast Company named Debra a top business executive and she was a jury member and speaker at the 26th Malofiej Awards and Infographic World Summit. She lives in Brooklyn with her husband.
Introduction
Materials
1. Diving into data journalism: Strategies for getting started or going deeper by Samantha Sunne [American Press Institute]
2. How charts lie: Introduction by Alberto Cairo
3. (Optional) The Data Journalism Handbook, 2nd edition [European Journalism Centre]
In this module you will learn to:
Video Classes
1. Why data journalism isn't magic
Watch Video Transcript Dataset Dataset Dataset
2. Examples of the data stories you'll learn about in this MOOC
3. Finding & Getting Data - Advanced Search with Google
4. Finding & Getting Data - Google Dataset Search
5. Finding & Getting Data - Google Public Data Explorer
6. Finding & Getting Data - Google Sheet's import HTML
Watch Video Transcript Dataset
7. Finding & Getting Data - Web Scraper
Readings
1. On the ethics of web scraping and data journalism by Nael Shiab [GIJN]
2. Data scraping for stories (Data Journalism Handbook) [Datajournalism.com]
3. Google search advanced operators by Daniel M. Russell
In this module you will learn to:
Video Classes
1. Introduction to the Module: Getting Your Data Ready
2. Preparing Data - Data Integrity
3. Preparing Data - Cleaning data with Google Sheets
Watch Video Transcript Dataset
4. Preparing Data - Cleaning with Google Cloud Dataprep
Watch Video Transcript Dataset
5. Preparing Data - Cleaning Data with OpenRefine
Readings
1. Putting data back into context by Catherine D'Ignazio
2. Google Sheets function list [Google]
Optional Resources
1. Tidy Data by Hadley Wickham [Journal of Statistical Software]
In this module you will learn to:
Video Classes
1. Introduction to the Module: Extracting Insights from Data
2. Anyone can be a data journalist
3. Introduction to Data Studio
4. Getting started with Data Studio
5. How does Data Studio work?
6. Create a report in Data Studio
Watch Video Transcript Dataset
7. Adding visualizations and charts to your Data Studio Report
8. Embedding external content with Data Studio
9. Sharing your Data Studio Report
10. Final thoughts with Minhaz Kazi
Readings
1. Quick start guide for Data Studio [Google]
2. Dimensions and metrics in Data Studio [Google]
3. Data Studio Explorer [Google]
Optional Resources
1. Visualizing BigQuery data using Data Studio [Google]
In this module you will learn to:
Video Classes
1. Introduction to the Module: Machine Learning to Shape Data Stories
2. Machine Learning for Data Journalism
3. Understanding Machine Learning
4. ML in the Newsroom
5. When to Use Machine Learning
6. ML Toolbox
Readings
1. We Trained A Computer To Search For Hidden Spy Planes. This Is What It Found. [Buzzfeed]
2. How you’re feeling when machine learning might help by Jeremy B. Merrill [Quartz AI Studio]
Optional Resources
1. LAPD misclassified nearly 1,200 violent crimes as minor offenses LA Times: How We Reported This Article [Times Investigation]
2. How The New York Times Uses Software To Recognize Members of Congress [Medium]
3. What Does AI See When It Watches A Week Of Television News? [Forbes]
4. Global Fishing Watch: Protecting global fisheries [Google]
5. Classifying congressional bills with machine learning [Medium]
In this module you will learn to:
Video Classes
1. Overview of Module 5
2. Anybody can learn visualization
3. Defining visualizations
4. Visualization is going mainstream
5. The elements of a visualization
6. Identifying encodings
7. The annotation layer
8. The “me” layer
9. How visualizations can lie
10. Reading too much into a visualization
11. How to choose the right encodings
12. The visual vocabulary
13. The big picture vs. the details
14. Using multiple encodings
15. Summary of the module
16. Intro to Flourish
17. Flourish Basics: The Data Table, Importing Data, and Column Settings
18. The Line, Bar and Pie Charts Template
19. The Scatter Template
20. The Table Template
21. Maps! Mapping Templates Overview and the Projection Map Template
22. The Survey Template and Layout Options
23. Annotations and Colors
Readings
1. The first 40 pages of 'The Truthful Art' ***Pre-publication draft by Alberto Cairo
Optional Resources
1. TwoTone and Morph Introduction with TwoTone Demo
2. TwoTone Documentation
3. TwoTone: Advanced Features
4. TwoTone: Narration Audio
5. TwoTone: Single or Multiple Instruments
6. Morph: Pie Chart Demo
7. Morph: Radial Area Demo
8. Morph: Scatter Plot Demo
9. The Data Journalism Handbook, chapter 7 - Delivering Data [DataJournalism.com]
10. How charts lie: Introduction by Alberto Cairo
In this module you will learn to:
Video Classes
1. From data to stories: an introduction to the module
2. What is data storytelling?
3. The past and present of data storytelling
Watch Video Transcript Field of vision - Concussion protocol (Full Video)
4. How to get from idea to execution
5. How to make your data stories shine
6. A look at The Pudding's successes, experiments, and failures
7. Popups and Making Flourish Visualisations Mobile-Friendly
8. Exporting & Publishing and One-Slide Stories
9. Intro to Flourish Stories
10. Template-Specific Story Tips: Map Stories and Survey Stories
11. Other Story Features: Basic Slide and Audio/Autoplay
Readings
1. What questions to ask when creating charts [Datawrapper]
2. How to make dope shit part 1: Working with data [The Pudding]
3. How to make dope shit part 2: Design [The Pudding]
Optional Resources
1. The Little of Visualization Design by Andy Kirk
2. In Defense of Interactive Graphics by Gregor Aisch