Develop a map based tool displaying multiple analytics around English clinical commissioning groups (CCGs) reflecting prevalence, treatment rates and outcomes for a major respiratory disease.
This tool was developed for a major international pharmaceutical company, to assist in identifying geographic and commissioning patterns across the country to guide discussions with commissioners.
Information is plotted geographically, with size and colour of each circle providing information about local population size and relative status.
The tool also allows users to click on a specific area, to “drill in” to further information on another screen. This tool was developed in Excel using visual basic.