Intermediate

Reporting with Pinpoint

Learn how to probe through millions of documents, including audio, video, PDFs and more, to find patterns or that proverbial needle in a haystack. You’ll see case studies of how Gannett journalists have used this software to break big investigative stories.

Skill:

Level:

  • Backgrounding a business

    How to search for proxies and tools for covering business, non-profits and the economy overall.

    Skill:

    Level:

  • CSV Match and other fuzzy-matching tools

    Finds matches between two files rather than within one.

    Skill:

    Level:

  • Analyzing batches of PDFs

    Learn tools and techniques for working with data buried in PDF files.

    Skill:

    Level:

  • What do you mean, it’s “statistically significant?”

    Advanced math for journalists.

    Skill:

    Level:

  • The best data about inequality

    What are the best datasets out there and what stories can they tell?

    Skill:

    Level:

  • Unlocking the power of Excel pivot tables

    Slice and dice data to to organize your reporting, find patterns and reveal better stories.

    Skill:

    Level:

  • Data visualization introduction

    Visualizations can help make a complex story simpler. Play with simple data visualization tools, learn how to automatically import data into a map, and explore the elegant templates of Flourish.

    Skill:

    Level:

  • Introduction to using data in your reporting

    An overview of the key data analysis tools and techniques used to produce investigative stories, with examples of stories that were made possible with these tools.

    Skill:

    Level:

  • Backgrounding like a boss: Reporting on people and companies with free tools

    Even great reporters can get tricked by fake names or sketchy backgrounds. We’ll walk through some websites and strategies you can use to create a routine and spot potential red flags before you get burned.

    Skill:

    Level:

  • Advanced backgrounding of people and companies

    From Investigative Reporters and Editors, here’s how to build a deep well of background to inform your reporting and writing.

    Skill:

    Level:

  • Creating data visualizations

    In this quick clip, Maggie Farley discusses how to build visualizations that will engage and build trust with your audience. She demonstrates different tools to build quick data visualizations and animations.

    Skill:

    Level:

  • Reporting on farm bankruptcies in your own backyard

    Using a database created by Sky Chadde, the Gannett Agriculture Data Fellow at the Midwest Center for Investigative Reporting, you’ll be able to localize the impact of these bankruptcies and identify trends in your community.

    Skill:

    Level:

  • Google: Geo and mapping

    Maggie Farley, a former Los Angeles Times foreign correspondent who now works with Google News Initiative, covers Geo and Mapping.

    Skill:

    Level: