Ok, this is not the prettiest visualisation, but it is really useful, hence my posting it on visual.ly. We needed a way to visualize our web design school’s yearly pedagogic calendar in a digestible, visual manner for our second and third year bachelors. It had to be easily changed by several persons. The solution i came up with was to use Google Spreadsheets, a tool often used by our teachers (no learning curve – great!), to encode the events (conferences, seminars, holidays), and feed the data in json format to a custom script sitting on our LAMP server using the Google Docs API via the Zend GData open source php package. The script produces an interactive data visualization in Canvas, built using the awesome kinetic.js library.