Taming Messy and Dirty Data: Tips to Cleaning and Structuring Data

If you are struggling with messy data and don’t know how to make sense of them, this two-hour session will provide tools, tips and tricks to transform your data into a clean, structured, and useful spreadsheet to accomplish your journalism goals! DataSketch CEO Juan Pablo Marín and CCIJ Data Editor Hassel Fallas will share their data wrangling secrets with you. Attendees will receive a tool kit handout after the session.


Thursday, November 11, 2021
10 AM - 12 PM Central Time (2 hours)


Virtual via Zoom



Juan Pablo is a Data Scientist and Founder of Datasketch. His work with software evolved to create data driven solutions for journalists. He enjoys using data to improve fact based decision making and to tackle different issues, including corruption, inequality and human rights violations.

Hassel is a Costa Rican data analyst and editor. Her passion is helping journalists extract valuable information from numbers and turn it into public interest reports, with effective and creative data visualization and storytelling that enhances the content’s quality.

She is a professor in Data Analytics and Data Visualization in the Master’s in Digital Journalism program at the University of Guadalajara, in Jalisco, Mexico. She is also a trainer at the International Center for Journalists (ICFJ) and an advisor in independent media and civil society organizations in Latin America.