Expert

Microsoft Excel 04 — Pivot tables

Pivot table are the simple solution for some, and a rare kind of magic to others. In this session, we’ll demystify pivot tables and show you how you can use them to simplify your analysis and give you more options than ever in how you extract your story.

Skill:

Level:

    • Data visualization: Datawrapper 301

    A deep dive on building choropleth and location maps. In 75 minutes we will build three maps, based on both US and global data. We will work on a more advanced chart and focus more on adding tooltips and footnotes in the charts.

    Skill:

    Level:

    • Build your own reporting robot

    How to use the automation function of Github, a tool for programmers, to create a web scraping bot to automatically gather information and data from the web. Our example will be using it to automate a tedious beat check. No prior coding knowledge needed.

    Skill:

    Level:

    • 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:

    • Advanced search techniques for reporters

    Google Advanced Search, search operators, deep searching a government website with a lousy search tool, Google Dataset Search, Google Scholar. Data sources

    Skill:

    Level:

    • Google Earth Suite

    We explore three free tools that will help you visualize stories in a whole new way.

    Skill:

    Level:

    • Hands-on with fast.ai

    Automatically sort text or images with machine-learning. Got too much text to read, or too many images to dig through? Make the computer do it, by teaching by example.

    Skill:

    Level:

    • Google Earth Engine Timelapse

    Google Earth Engine Timelapse features 37 years (1984-2020) of satellite imagery over a given area on Earth.

    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 Search: Power tools for search, research and analysis

    See what users in your area are searching and discover story ideas on Google Trends. Explore Backlight, an AI tool for parsing massive amounts of documents.

    Skill:

    Level:

    • Safely reporting from protests and other tense events

    These are stressful times. Being out in the world as a journalist carries an element of risk. But a world without engaged journalists watching over it is risky, too. Our aim is to identify as many risks as we can and take steps to reduce them, prepare for them, and neutralize them if they do arise.

    Skill:

    Level:

    • Developing an evergreen plan

    What is evergreen, and why should you care? This webinar answers questions on how to develop an evergreen content strategy for your newspaper, and why.

    Skill:

    Level:

    • SEO for editors

    Discover what SEO expert David Stone is seeing in Google, and how you can drive your newsroom to produce more SEO-friendly content.

    Skill:

    Level:

    • Advanced search techniques

    This primer on Google search includes tips for effective image searches.

    Skill:

    Level:

    • Black women, politics, culture, society, trauma and healing

    Nichelle Smith, Dr. Aisha Lowe and Kimberly Melton joined LIVE with Dr. AMC & Friends for a thoughtful roundtable discussion.

    Skill:

    Level:

    • 50 tools for writing well with Roy Peter Clark

    Organized into four sections, “Nuts and Bolts,” “Special Effects,” “Blueprints for Stories,” and “Useful Habits,” this series is infused with more than 200 examples from journalism and literature.

    Skill:

    Level:

    • Tips for grant-writing and partnerships

    Wondering what you can do to receive newsroom grants or work with ProPublica and other nonprofits? We have tips from people who’ve been successful and those who’ve worked on the receiving end of the process.

    Skill:

    Level: