Data management tools

Data management tools

How data is arranged is a big factor in the ability to use it successfully. This section profiles some tools that can be used to collect, store, analyse and clean-up data.

a tool that helps you to make sense of time-based data through the use of timelines and chronologies.

An example of the timeline option on the topic of natural disasters
It can only be used offline downloaded as a desktop application or stored on a thumb drive.

it helps you understand relationships between events over time and to keep track of temporal information in as much textual detail as required. It also allows you to enter, edit and delete data directly in the tool itself. 

an online tool that can be used to reformat, clean up and organise your dataset.

Reformating your dataset by using the 'Fill' function
It can only be used online as it is a browser-based web application

it leaves you with more time to analyse and visualise your data rather than potentially wasting hours rearranging your dataset into a useable format.

a tool for organising data and information in tables, and making charts out of it.

Desktop installation

it's a simple, non-technical way to put a structure on the information you have, do a little analysis on it, and keep updating it.

NEW WORKTHROUGH showing how we used Open Refine to find and correct errors in data.

Google Refine
Desktop installation

it automates tasks that would take a long time to do manually, such as finding typos and data that might be out of place.

an online spreadsheet with useful data collection and visualisation features.

google-spreadsheet.png
Online

you can add existing spreadsheets to Google Spreadsheets, share them online and collaborate with others.

an online database for creating big online datasets from different sources and then making online maps from it.

Google Fusion Tables as used by The Guardian to visualise data about poverty and the homes of those accused of rioting in 2011.
Online

it's quite straightforward to make a visualisation out of a big and properly formatted dataset.

Syndicate content