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.
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.
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.
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.