One of the strengths of using a programme like Tableau Public is that it can pull various visualisations together into a single interactive dashboard. This how to will explain how that can work, using our DFID 2011 flight data.
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.
In a previous how to video, we learned how to clean and tidy data in Excel using functions like VLOOKUP. In this how to, we will look at how to summarise that data to answer specific questions using the PivotTable utility in 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.
In our previous how to, we explained how to capture live data from the web using Import.io. In this how to we wanted to show you what we can actually do with that data.
We decided to make an interactive map with different coloured pins. Using Care Quality Commission data on hospital performance in England, we create a map of which hospitals the staff who work there actually recommend attending.
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.
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.
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.
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.