Projects
TRUST US TO TRANSFORM YOUR UNIQUE DATA
We work on many ‘Project X’s’ for our clients, transforming confidential data into meaningful insights to improve targeting, sales and profitability
UK 4 nations prescription data and other NHS Open Data sourced for you
We have combined our data and Pharmaceutical expertise to develop our 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 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
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
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
