Gemma GatticchiinMedia HackOur grocery basket comparison is a simple data project. And a huge hit with readers.In 2022 South Africans were feeling the economic pinch. We collected price points from local shops to find out just how much it hurt.Mar 16, 2023Mar 16, 2023
Gemma GatticchiinMedia HackData is at the core of health journalism.At South Africa’s Bhekisisa Centre for Health Journalism collecting, analysing , fact-checking and visualising data is a team sportMar 2, 2023Mar 2, 2023
Gemma GatticchiinMedia HackFive (more) simple spreadsheet functions every journalist needs to knowIn October we gave you five basic spreadsheet functions that you need to know to be Google Sheets literate. Here’s part two!Dec 9, 2022Dec 9, 2022
Gemma GatticchiinMedia HackDigging data at the 2022 African Investigative Journalism ConferenceWhat do journalists think about data? We spoke to some attendees of the African Investigative Journalism Conference to find out.Nov 10, 20221Nov 10, 20221
Gemma GatticchiinMedia HackFive essential — and super simple — spreadsheet formulas every journalist needs to knowLearning these five basic formulas will start you on your way to spreadsheet bliss.Oct 27, 2022Oct 27, 2022
Gemma GatticchiinMedia HackMaking bar charts with DatawrapperDatawrapper is a one-stop solution for all things maps, charts and tables. Here’s our simple bar chart cheatsheet.Oct 7, 2022Oct 7, 2022
Gemma GatticchiinMedia HackFive reasons Google Sheets is better than Microsoft ExcelFree. More collaboration features. Live chat. History function. Multiple device access. Any questions?Sep 1, 2022Sep 1, 2022
Gemma GatticchiinMedia HackA simple guide to scraping data from PDFsTime to get those PDFs and poorly scanned documents into a workable format. Here’s how to do it.Jun 30, 2022Jun 30, 2022
Gemma GatticchiinMedia HackGetting started with Flourish & Figma to create beautiful custom chartsWe often combine two of our favourite data visualisation tools, Flourish and Figma, to customise our static charts. Here’s how we do it.May 20, 20221May 20, 20221
Gemma GatticchiinMedia Hack5 Reasons to switch to OpenRefine (and never look back)I know this article is about OpenRefine (previously Google Refine), but in order to get there, I need to start with Google Sheets.Apr 29, 2022Apr 29, 2022
