How to...animate a map to see changes over time using CartoDB

2 Comments

How to...animate a map to see changes over time using CartoDB

Sometimes we have data that have chronological information associated with them. The DFID travel dataset is one example of that. There are lots of ways to visualise that information, but one way would be do display all the places DFID have travelled each day of the year. This can be done using an online mapping software called CartoDB and its 'Torque' function.

2 Comments

How to merge and tidy data with Excel

Comment

How to merge and tidy data with Excel

The VLOOKUP function is a straightforward way to merge data in Excel. I use it daily to combine two different dataset when a simply copy and paste just won't do. The most common reason for that is different numbers of rows (entries) between the two datasets we're working to combine. For example one dataset might be a list of people and their job title, the other might be a list of phone calls, with the same person dialled more than once. In that case we could use VLOOKUP to append the list of phone calls with the job title of everyone who is called.

Comment

How to... capture and structure data from websites using Import.io

Comment

How to... capture and structure data from websites using Import.io

This is our second ttdatavis how to focusing on new methods for data capture and collection. We will be exploring one aspect of Import.io, which is a massively powerful free piece of software that can help to scrape information from websites.

Specifically, this posts walks through how to create an 'API from URL (Extractor)' using an example of the recently launch myNHS website from the UK Government, which looks at hospital care and quality.

Comment

How to... Import live data with Google Drive Spreadsheets

3 Comments

How to... Import live data with Google Drive Spreadsheets

As part of the 2014-15 On Think Tanks Data Visualisation Competition, we're producing a number of 'how tos' to better support think tanks to develop their visualisations. As part of our how to series section on data collection, in this post we look at how to use Google Drive Spreadsheets to import live data from the web.

3 Comments

How to... tell stories with data

Comment

How to... tell stories with data

On 14 October, Nika Aleksejeva from Infogram hosted a webinar that not only introduced Infogram as a tool for creating data visualisations, but also looked at how to tell stories with data.

It's best to watch the recording of the webinar below, which lasts just over 30 minutes, to catch all the details and nuance. But this blog also rounds up some of Nika's key points.

Comment

Vine in 60 seconds: An introduction of Twitter's video app for think tanks

Comment

Vine in 60 seconds: An introduction of Twitter's video app for think tanks

Today I'm giving a short presentation at IDS on Vine -- a short video sharing service for Twitter -- to our Digital Communications Peer Group. And while I hope it's useful to others working here, I thought it might also be of interest to others working in other think tanks too. I figured that the only way to present on vines was to actually create some -- so below you can find my presentation: Vine in 60 seconds.

Comment