Data Frosch logo

Data Frosch

Guides

Data Frosch frog mascot

Practical guides for data journalists

Not sure where to start with a dataset? Need a structured checklist to make sure you haven't missed anything? These guides give you frameworks and tools to work through data journalism challenges step by step.


  1. Finding Stories in Data — interrogate a new dataset and surface story angles. Covers source interrogation, descriptive statistics, rankings, rates, time & geographic patterns, outliers, missing data, verification, and the news test.
  2. Tidy Data — turn a messy spreadsheet into clean, analysis-ready data. Covers wide vs. long format, merged cells, inconsistent values, data types, and a final tidy check.
  3. Pivot Tables — build intuition for what pivot tables do, how to read them, and how to construct them from a question rather than a menu.

More free resources: tutorials and walkthroughs on the YouTube channel, and longer reads on the blog.