Following my last post on creating a database for the LMI for All project, I am now beginning to explore what you can find out from the database.

One of the main sources for labour market data in the UK is the quarterly Labour Force Survey. Data on employment is collected under two main categories, the Standard Industrial Classification (SIC) about the industries in which people work, and the Standard Occupational Classification (SOC) about their occupation. Using our database API we can query the two classification systems against each other to find out how many people in a particular occupation work in which industries. We did this query on Friday for Computer Programmers. This gave us a long spreadsheet which was not particularly easy to understand. I cleaned the data and uploaded it to the IBM ManyEyes site and used the bubble visualisation which gives the graphic above. OK it is not perfect. The industry titles are too long for the index box. And maybe it provide too much data (I will look at what we get using a 3 figure SIC classification, rather than the present 4 figure SIC).

However I think it show potential. And there is no reason why we could not provide longitudinal and comparative data with a  bit of work.