Posts Tagged ‘design’

Branded Mug Design

// May 5th, 2010 // No Comments » // Creative

One of the hardest aspects of managing fast paced growth in a startup company such as mine is coping with the influx of employees.

One of the principles of interaction design I was taught, based on research done by the psychologist George Miller, is that most people’s cognitive capacity is 7 +/- 2 – in effect, the average individual can remember seven items of information reasonably well, but struggle as soon as they have to remember more.

This becomes a stark problem when the number of employees required to complete a round of tea heads above this – compounded by the fact that each person likes their tea differently, and some odd people even seem to like coffee.  When we reached the point that people would come in early to get the chipped mug, just to have a way of identifying themselves, I figured something had to be done.

Step forward YourDesign, who have the best mug design service I could find in 5 minutes of Googling.  Just knock up a quick design like this, pay £8, and you have a personalised mug:

Masabi mug - template design

Within 2 days I had my prototype back, and within a week the whole company were kitted out with branded mugs.  We’re even considering getting them for regular customers who drop by for design and development iteration meetings…

Slight warning: the print quality is a bit fuzzy, but with a nice bold design it works pretty nicely, and I no longer have to order mugs alphabeitcally whilst they brew, run round the office reminding myself who wanted what, then accidentally pour milk into the wrong mug and have to start again.

NB: shooting white against white on a white background in a lightbox that is slightly too small – harder than it looks :)

Data Visualisation – Global Gender Balance

// February 18th, 2010 // No Comments » // Creative

I’ve spent a few hours playing with Tableau Public, a free version of the rather expensive Tableau data visualisation app, and it’s pretty good. After a random discussion of how Estonia has, according to the Economist world stats book, 84 guys to every 100 girls, I prepared this map in a couple of hours as an exercise in understanding how Tableau works:

Click to see full size - global male:female ratios, scaled by population size

The map shows the male:female ratio of every country as coloured crosses, from red (more women) to blue (more men); the size of the cross is proportional to the country’s population.

Quick Caveats

Tableau Public is a cut-down version of commercial software, with no ability to save files locally. In theory you can publish your diagrams to the web on their site, but that feature was a bit broken when I tried it.

This means that you have to retrieve your diagrams using screenshots, and I have no idea what the legal implications of doing that are if you intend to use them for anything but personal interest and satisfaction! It does constrain the quality a little, too.

Source Data

Being lazy, I didn’t want to type in all of the raw data from the Economist book, so I pulled it from Wikipedia: population data came from here and sex ratio from here. Copying the tables directly into Excel brought a load of unwanted links and images, so I copied into Notepad++ – where it appears as tab separated values – and reloaded as a TSV file via disk.
The country names had a few extra spaces and other characters in them – I pulled these out with the LEFT, MID, LEN etc functions.

Tableau theoretically understands full country names, but I had mixed success getting this to work, so I imported a lookup table of two letter ISO 3166-2 codes, which are also supported and are unambiguous.

I then used VLOOKUP to pull together all this information into a single Excel sheet (remember to turn range lookup – the fourth, optional argument – off); as the data came from diffferent sources, there was a little messing round standardising country names. The finished spreadsheet is here if you want to play with it.

Visualizing in Tableau

It really helps to look at this tutorial video before starting anything – Tableau starts with quite a blank slate!

Open up the XLS in Tableau, and it’ll make a first stab at identifying what is what from the Excel column formats. You’ll see the fields seperated into text and numeric lists down the left hand side.
If you don’t see a globe next to the Country Code field, right click, go to the Geographic Role submenu, and select Country (ISO 3166-2). Tableau can now map this to a geographical location automatically. Also ensure all numeric columns are recognised as numeric with the Change Data Type submenu.

To recreate the map visualisation,  follow these (approximate!) steps:

  1. Select the Country Code and Total fields, and click on the Show Me! button.
  2. Select the map diagram type (near the bottopm of the list). You should see some dots across a map.
  3. Drag the Population column over to the Size box, right click and select Dimension to scale the dots by population.
  4. Drag the Total column to the Colour box and they should become shades of green; further down is a green graduation which you can click on to change, and adjust to a red-blue graduation. Click on Advanced and set the midpoint to 1.0, to make the middle grey represent a 1:1 ratio.

Your left hand panels should look a little like this now:

This is really just a very high speed starter and I’ve barely dipped below the surface – I’ve got some quite complex business plan data that I’ll be dropping in later to experiment further.

Cameron says “you’re all tw*ts”

// July 29th, 2009 // No Comments » // Creative

David Cameron, leader of the UK Conservative party and future British Prime Minister (bar any serious upsets), tickled my fancy today by declaring (live on radio) that there’s a danger that Twitter users may end up being twats.  Inspired for possibly the first time by Tory policy, I kicked out this t-shirt design:

David Cameron MP says 'you're alltwats' to Twitter users

If you’re not sure what a twat is, the Times says it is a “vulgar synonym for the human vagina”.  Conservative central office’s PR bunnies claim it is technically not a swear word, which is nice. Twats.

I’m in the process of kicking Neil @ Ninja Zoo so I can actually make it available as a t-shirt – sadly his sign-up script appears to have got a bit messed up…