Investigative reporting certificate BETA

This will be the blurb for the Investigative reporting certificate.

  • Foundations of data journalism – Scraping

    Foundations of data journalism – Scraping

    Data scraping web pages with Google sheets, scraping PDFs with Tabula and PDFtoExcel. Build graphics with Flourish Studio. We’ll also explore how to scrape data from a photograph using Excel.


  • Business tools and investigating companies

    Business tools and investigating companies

    Learn how to scrape real-time and historical stock data from Google Finance into a Google Sheet and track it. It’s useful for anyone covering a specific industry or company.


  • Reporting with Pinpoint

    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.


  • Using specialized search engines to find sources, data and fact-checks

    Using specialized search engines to find sources, data and fact-checks

    Execute deeper, more precise, more sophisticated web searches by harnessing specialized search engines. Diversity your stories, angles, sources and readers.


  • Backgrounding a business

    Backgrounding a business

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


  • Secure communications with sources and tipsters

    Tips and traps: Tools such as Signal app, Freedome and VPNs to keep you, your data and your sources safe.


  • CSV Match and other fuzzy-matching tools

    Finds matches between two files rather than within one.