Projects

We work on many ‘Project X’s’ for our clients, transforming confidential data into meaningful insights to improve targeting, sales and profitability

Visual Numbers provides expert data insights for the medical and pharmaceutical industries

UK 4 nations prescription data and other NHS Open Data sourced for you - Vnumbers service

We have combined our data and Pharmaceutical expertise to develop our  ‘Vnumbers’ service enabling us to provide you Government Open NHS prescription data. Please contact us for more information. 

England, Northern Ireland, Scotland and Wales prescriptions

  • Accessed under Open Government Licence v 3
  • Full list price medicines costs across 25,000 medicines
  • Codes matched across the 4 nations
  • Latest 13 months data at a national level
  • More granular levels of data available – ICB, PCO, PCN and GP Practice and also NHS Trusts in England

We provide our clients with interactive maps and reports which help visualise data and offer actionable insight, specific detail and measurable ROI

Mapping information can lead to valuable data insights by helping you visualise data in new ways

Mapping layers of data

We are constantly exploring new ways of overlaying different datasets utilising the latest features in Tableau. This example combines Primary Care data with Secondary Care Hospital information to investigate links between prescribing influences. 

We use mapping to restructure sales territories, identify geographic hot spots, unravel high potential areas and much more. 

Let us take the hard work out of visualising data for your business

A treemap of UK CCGs and HBs to provide valuable data insights

Market snapshots to help you quickly see the big picture

We are always looking for creative solutions to visualise large amounts of data to show you the big picture, but we also identify high, low, growth and other interesting measures in the data to help you take focused actions

Let us combine our creativity and BI expertise to cost-effectively reveal actionable insights

Dashboards are a great way to visualise data in an easy to understand format

Combine different measures to reveal effort result patterns

We are experts in combining multiple data sets into single dashboards to reveal illustrative patterns in sales, market share, growth, activity, etc 

Augment your business intelligence by combining multiple data sets

Latest project - Looker Studio (formerly Google Data Studio) reports

The Clinical Commissioning Groups (CCGs) in England have now been renamed as Sub-ICBs (Integrated Care Boards) following the creation of the new 42 ICBs across England. More information can be found at https://www.england.nhs.uk/publication/integrated-care-boards-in-england/ 

As an example, we have arbitrarily selected 2 products and the report below shows open prescription data for Freestyle Libre Sensor and Freestyle Libre Sensor 2 prescriptions by UK Nation; Integrated Care Board (ICB – England); Local Commissioning Group (LCG – N Ireland); Health Board (HB – Scotland) and University Health Board (UHB – Wales)

This is a Looker Studio (formerly known as Google Data Studio) report which enables one to filter by Nation; ICB/LCG/HB/UHB and also by product. The 12 month and latest 6 month prescription values for £NIC (Net Ingredient Cost – green border); Quantity (blue border) and Items prescribed (orange border) can be seen in the second row along with the latest 6 months growth figures as +/- percentages

The first report (1) is for England only and then the second report (2) shows all 4 UK nations’ data together

The table shows the ICB prefix and the Sub-ICB suffix and also shows the respective outgoing CCG name or LCG/HB/UHB respective to each of the 4 UK nations. The NIC, Quantity and Items information is also displayed

The bottom chart shows the NIC, Quantity or Items line charts for the Freestyle Libre Sensor and Freestyle Libre Sensor 2 prescriptions

To discuss your specific data insight project challenges, please contact us for a FREE no obligation phone consultation