In late Summer 2011 I carried out a survey of webteams in local authorities in the UK. This survey looked, amongst other things, at the size and composition of the webteam, their location, how big the organisation is, the size of the local population and how many visits the sites get each year.

I posted the survey on one of the Communities of Practice (COP) run by the IDEA and The Improvement Service in Scotland. The survey was taken up and promoted by SOCITM.

The reason for my running the survey was to benchmark Aberdeen City Council’s web team with those of other authorities. I promised all participants that they get a copy of the data and analysis when I finished.

SOCITM thought that there was merit in what I did and invited me to present at the Website Takeup and Improvement workshop in Birmingham. When I gave my presentation I used both MS Powerpoint and a set of webpages which I’d created using the Protivis javascript framework.

I posted both my MS Powerpoint Presentation and the Excel spreadsheet of original data back on the COP. I promised to share the graphs via my own blog.

When making the promise I hadn’t foreseen the difficulty in getting Protivis to work with WordPress. I’ve now solved that by using the Protovis Loader Plug-in for WordPress.

Once I did that I had to save the Javascript for each graph to a separate JS file and load that to a site directory. Lastly I had to move each of the three graphs to a separate page to get the mouse-over functions to work. If I’d had time I would have worked out a JS function to add commas to the numeric text that loads beneath each graph – but I might return to this later.

In each of the three scatterplot diagrams that I’ve created the council webteam (circle) is plotted against the local population size (y-axis) and the size of the council measured in FTEs (x-axis). The colour of the bubble represents the council type, and the size of the bubble represents the web team size.

The first example below shows the data collected for all councils. Mouseover the bubbles to show which council is which. The data loads below the graph.

[pvis src=”” ] Webteam Survey 2011 – all councils [/pvis]

If you go to the next page you can see the same data replotted with Essex’s data removed. This makes visualising it slightly easier with the outlier removed.

Webteam Survey 2011 The Graphs Part 1 of 3
Tagged on: