How to: create a bubble chart from a Google Spreadsheet using D3.js

Earlier in this series I discussed how to get data out of a Google Spreadsheet in JSON format using an API call, and how to convert the JSON data into an array. Now I’m going to talk about how to … Continue reading

Posted in Data modelling and migration | 1 Comment

How to: convert Google Spreadsheet JSON data into a simple two-dimensional array

In a previous post I explained how to extract JSON data from a Google Spreadsheet via an API call. However, when you actually get the data, the JSON isn’t really in the kind of structure you would imagine. Instead of … Continue reading

Posted in Data modelling and migration | Leave a comment

How to: get data out of a Google spreadsheet using JSONP

Google Drive spreadsheets are a great way to collect data using their handy forms, but the visualisation tools sometimes aren’t sufficient. What if you wanted to do a visualisation using d3.js for example? Google has an API for obtaining the … Continue reading

Posted in Data modelling and migration | 10 Comments

Research at Risk: Report from the Jisc Co-Design Workshop

On the 22nd of September, I was invited to a Jisc Co-Design event on “Research at Risk”, with participants from organisations such as UCISA, RLUK, RUGIT, DCC, and of course some universities, including yours truly representing both the University of … Continue reading

Posted in News | 2 Comments