Hot on the heels of my last blog post, I attended the show and tell at the end of the trade data hack event that took place in London this weekend. In partnership with Rewired State, so a couple of familiar faces there, and held in the Centre for Creative Collaboration. It was much easier for me to reach than RLabs (30 minutes on a high speed train rather than an 11 hour flight….), but the energy and creative space was similar. Superficial instant comparison – the ratio of Apple products was completely opposite – only 3 I think in the whole of RLabs, and possibly only one or two non-Apple in London!

However, the approach and solutions to the data challenge set were actually similar in many ways. The teams in London focused on making it simpler for people to understand the data, and tried to find ways to make it fun, so people would actually want to participate. Many added clever visualisations and made working through the data into a game – all had excellent ideas as to how they would expand their idea and prototype into a working thing.

I hope the prototypes will all be available online  (will add links if and when I find out) – as some are very hard to describe, but here goes:

First up, Canada Calculator, a simple one to start with, it lets a consumer see how changing different economic indicators affect the price of commodities in their shopping basket.

The same team evolved their visualisation to produce Global trade challenge: a game which lets people see how changing different economic variables affect the prices of good in different countries. A players initial goal is simply to make the highest profit – but ideas for development included other goals, which might be developing production in your country.

CPIA geochart used a set of World Bank ratings as a basic data set, and mapped them on to a world map. Just seeing the data in this way raised a whole host of questions, not least the scales used – is it good or bad to score highly against an indicator like “transparency, accountability and corruption in the public sector”? Very corrupt but also very transparent about it?! Next steps for this visualisation could be to map trends, and see how countries develop over time – this would be more meaningful than the absolute numbers.

Next up was Surplus/deficit – a 3D visualisation of World Bank data that really has to be seen to be understood!

Surplus/deficit - 3D data visualisation

Surplus/deficit – 3D data visualisation

I absolutely loved this product, and can imagine all sorts of ways it could be extended to include more data. All data is taken from a spreadsheet, and a basic function is that it would help to spot anomalies in the data. Future enhancements could include dials and sliders, so you could see how the visualisation would change over time, or as different filters were applied. One irony, the hack as it stands is a virtual map – by which I mean that all the data points are mapped to capital cities, so if you know the world well, you can guess/work out where the hot spots are. To make it truly functional, a real map outline should be added, but this will take away some of its abstract beauty!

Where the money goes is another simple visualisation that used the basic commodity data provided for the five sample countries.

Where the money goes - data visualisation

Where the money goes – data visualisation

More data could illustrate more elements, at the moment there is just one ‘stripe’ showing tariffs, and the rest of the currency symbol shows ‘the rest’ of the price.

Trademize is a fascinating hack – a solution with 3 aims:  to inform and educate, to engage and to connect. The presenter talked through the information home page, which contains lots of clear explanations and illustrations of trade data, then the engagement element, the part of which I most liked was the idea of a quiz. In this, visitors would select a commodity and then how much of it you consumed (eg Tea, and how many cups a day you drink), then it would calculate how much this cost you a year, then let you know how much you would save if there was a change in one of the tariffs. The ‘connect’ element was that you would then be invited to share the final information in the form of a tweet. Deeper connection was in the form of a contact form where visitors could ask questions of experts. The behind-the-scenes management of this community was interesting, and something to investigate further. The developer used the PODIO task management system and Zapier.  The latter looked for tweets which used a particular hashtag and then created a task which could be assigned to someone to investigate. At least I think thats how it worked…. as I said, one that looked intriguing, to be investigated!

Next up was another tool which visualised World Bank data: Exporty relativiserator. This was highly graphical (true geeks in the room were impressed as apparently this was done on some HD laptop?) but unfortunately it didn’t initially display as the developers had intended. Changing the settings made the countries on the map white, but I think I got the gist – when you select a country, the tool showed  the top 4 regions it exported to, linked by lines, and the thickness of the line indicated the volume of exports. Plans for this included more data, which would show imports and exports, and show the split between goods and services.

Reach for the Pie was the first app designed to work on a mobile – and it was demo’d on an iPhone.

Reach for the Pie - data visualisation

Reach for the Pie – data visualisation

Users choose a country, then sector, then product, then the tool gives you a pie chart which illustrates how the price of that commodity (in the example above – apples from Chile (we think)) is made up – tariffs, transport costs etc.

The same team had also found time to create a ‘physical’ hack – they invented a board game: Trade Aid game.

Trade Aid board game

Trade Aid board game

Working along the lines of snakes and ladders, it took the player on the route from producer to market. The ‘snake’ hazards are things like: delays at border, miss 2 goes, while a ladder might be: receive training to meet EU standards, advance 2 squares.

The next hack was presented by an extremely energetic and enthusiastic presenter, who described the approach they had taken in developing a way of presenting trade data in a way that anyone could understand. Pictotrade used pictographs to represent complex concepts, using consistent colours to represent trade topics (export, import, services etc)

Pictotrade - pictorial trade data explorer

Pictotrade – pictorial trade data explorer

The team aimed not to overwhelm – their app starts with a blank canvas that the user gradually fills by selecting countries, and commodities, and the focus is not on absolute numbers, but on relative relationships – eg a small image shows not much activity, while a big one shows large scale success.

One idea was that schools could make use of this, working through particular examples to create an illustration that could be printed off as a poster – to raise awareness of a particular issue or country’s trade position.

This group also wins the prize for the ‘additional extra’ which I don’t claim to understand at all – but somehow the tool they used to create their ‘stretching’ icons could also be used to show ‘stretching’ cats……. dont ask! [thanks for the link @shish2k ]

Into the finishing stretch, the next presenter showed a role playing game: Trade War. Imagine you are Minister of Trade for India, your task is to work through a series of years making changes to the volume of products and the amount of tariffs you place on trade, with the aim of keeping consumers, producers and exporters happy.

Trade War - role playing game based on trade data

Trade War – role playing game based on trade data

You change your plans each year, and the country you are trading with – in the presentation this was China – responds. Each year your three different communities are graded as to their reaction – pleased, thrilled, grumbling or angry.  When asked if he had learned anything from creating this game, the developer  responded with the unsurprising “you can’t please everyone!”

The last two hacks came from the same team. First up was Tariff bot – a fascinating idea, which as it says in its own profile “tries his best to chip into relevant conversations with data from the World Bank”.

The team correctly identified the challenge that no matter how fantastic your creation, too often it sits on a server somewhere and after the initial flurry of interest, no one uses it. So they wanted to create something that would go out and find people who were having conversations anyway about trade topics. Tariffbot currently uses the twitter search API to find people talking about topics (using certain terms – it currently loves countries and questions) then tweets a link to a data graph of relevant information. Thus  someone saying “I wish I knew more about trade tariffs in Japan” would received a helpful tweet in reply. It isn’t programmed to ‘@’ reply people – the developers wanted to avoid being accused of spamming people, so I’m not completely clear how the questioner would see the helpful answer – but I’m sure with more development this could turn into something really interesting!

The last in show app was a cheeky one, which exploited the fact that there is a google chrome extension that allows you to inject your data into a site (lots of unlikely caveats here – like people accepting unauthorised apps – but it made a nice point…..) Tariffic is a neat idea that for example when a shopper was using the online store of a wellknown mainstream supermarket, and for example chose a packet of coffee, the app would insert a pie chart which told you how much of that price went to the producer, how much went in tariffs etc. It would only work if the supermarket had included the country of origin in the product entry – but nevertheless – an intriguing idea.

In all, a hack that was on the surface, different in many ways from the first DFID sponsored trade data hack, in Cape Town, but actually showed lots of similarities of approach. The developers’ products were further advanced, and many of the graphics more sophisticated, but the energy and enthusiasm that went into making complex issues clear and engaging to people was consistent throughout. I look forward to hearing from colleagues about what was produced at the trade data hack in CCHubs, Lagos.

NB – I didn’t capture anyone’s names, and may well have misunderstood some of the more complicated work. If I have misrepresented your hack, or if you would like me to assign correct credit for your work, please contact me via the comments field, or on twitter @juliac2

UPDATE: Hacks now live on Rewired State: