Tipsheets

Browse more 5,000 tipsheets from our national conferences and Watchdog Workshops on how to cover specific beats, conduct a great interview and learn countless tips on where to find the information you need.

Logged-in members can download any tipsheet, for free. Contact the Resource Center 573-882-3364 or rescntr@ire.org for questions.

Search results for "tables" ...

  • Interviewing your data with SQL

    If you flip over pivot tables, but wish you had more data tools, this tipsheet is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables.

    Tags: SQL; data analysis; data journalism; data reporting; computer-assisted reporting; Structured Query Language; programming;

    By Meghan Hoyer and Troy Thibodeaux

    2019

  • Beyond 1M rows: Using and joining large datasets in Excel

    The old restriction of 1 million rows in Excel no longer applies. Get and Transform in Office 2016 allows you to connect to large data sources, query them and even merge tables straight from your spreadsheet. This data and files help you look at visualizing this data in Excel with Pivot Charts. https://www.dropbox.com/s/r68wwih83o27suk/Microsoft%20session%20files.zip?dl=0

    Tags: datasets; joining; excel

    By Leo Zhao; Callie Neylan; Joseph Chirilov

    2018

  • Searchable, interactive data tables in an hour or less Github repo

    Learn how to go from a simple Excel/Google spreadsheet to a searchable, interactive data table using the popular jQuery library datatables. This is good for: Anyone who has been frustrated with trying to put their data online in a usable format.Some basic HTML experience is helpful but not required. https://github.com/ssdatar/datatables-nicar2018

    Tags: searchable; interactive; data; spreadsheet

    By Saurabh Datar

    2018

  • Maps Made Easy

    At DataMade, a civic technology company in Chicago, we love building, thinking about and learning from digital maps. In this session, we’ll share some of our favorite tools for mapping data, giving emphasis to Derek Eder’s Fusion Tables Searchable Map Template. Open source and easy-to-use, the Fusion Tables Template facilitates the creation of a searchable, filterable map from any spreadsheet or shapefile. We will give a step-by-step overview of the template and demonstrate some of its key features: address search, geolocation, the ability to easily add additional search filters, and hover and popover interactivity for point details.

    Tags: maps; datamade; digital; searchable

    By Regina Compton

    2018

  • ​Transparency​ ​by​ ​Design

    The​ ​problem:​ ​Some agencies say their software won’t export data. Others charge tons of money for data, saying it’s complicated to extract. We can fight them by showing that it’s not that complicated. We ask for the agency’s data dictionary or record layout, which is a document describing the table names, field names and field formats in a database, and then we ask for just the tables and fields we care about. But many agencies say the software vendor won’t let them disclose a data dictionary because it’s a trade secret. The​ ​solution​: Prohibit agencies from putting themselves in such predicaments. Transparency by Design says that any new government technology must offer the ability for an agency to deliver both data and data documentation without restriction.

    Tags: government; foi; documents; data; agency

    By Steve Suo

    2017

  • Getting Data Into Microsoft Access tipsheet

    Microsoft Access is a database management system (dbms), often shortened to “database” or “database software.” A database is a collection of related tables, and a database management system is the interface. Learn the basics of using it with this tipsheet.

    Tags: access; database; management; software

    By Tracy Greer

    2017

  • Google Fusion Tables (beginner)

    Welcome to Google Fusion Tables. With this introduction to the free online tool you'll learn how to import and combine data, do simple analysis and easily turn that into an online map.

    Tags: google; fusion; tables; analysis; data; import

    By Tommy Kaas

    2017

  • QGIS II: Manipulating, editing and analyzing geographic data

    Dive even deeper into data mapping in this continuation of QGIS I. This guide will cover joining data tables to maps, aggregating point data for easier analysis and preparing geographic data for display online. http://akanik.github.io/mapping-2017/

    Tags: data; qgis; tables; maps; analysis; geographic

    By Alexandra Kanik

    2017

  • Rolling Your Own Data: Nuisance Abatement

    Sometimes there's a government database to FOIA. But often the best data for a story doesn't exist in database format. It's a collection of documents, or statistical tables trapped in PDF files. This tipsheet will show you examples of stories that were powered by data created from scratch, and provide tips for how to go about such a project.

    Tags: data; rolling; databases; scratch

    By Sarah Ryley

    2016

  • Rolling your own data presentation

    Sometimes there's a government database to FOIA. But often the best data for a story doesn't exist in database format. It's a collection of documents, or statistical tables trapped in PDF files. This presentation will show you examples of stories that were powered by data created from scratch, and provide tips for how to go about such a project.

    Tags: data; rolling; databases; scratch

    By Robert Gebeloff, Sarah Ryley, Jennifer LaFleur

    2016