Introducing PrescQIPP Visual Analytics
Find out more about our Visual Analytics here
From little data to big analysis
The world of data is changing: there's so much of it and it's more than traditional desktop systems can handle alone. Across the NHS, and all other sectors, organisations are utilising business intelligence and visualisation systems to handle big data and make it meaningful. We believe that our community deserves nothing less, as managing and commissioning medicines use requires solid intelligence and analysis.
In 2016 we launched the PrescQIPP Visual Analytics platform, based on Tableau, offering a range of exciting new reports for commissioners. We’ve got really exciting plans for this system, building upon the many visual reports we've created so far. All reports will be integrated into the data hub, but also into relevent clinical pages, such as the webkits, so you can follow the route that best fits you, and create meaning from your own prescribing activity data.
How to find the Visual Reports?
The visual reports will be carefully threaded into our site, always signified by the turqioise slider / accordian. Some will be embedded into pages, and some will have their own pages. Please find below a list of direct links to some of our key reports:
Is there any training or support to help me get to grips with this?
There certainly is! A range of interactive videos and live examples to play on can be found by going to the PrescQIPP Visual Analytics training page.
In this collection you'll find reports that focus on financial activities relating to all or key parts of the monitoring that medicines teams do.
Financial Summary and Deep Dive Growth Reports (now with Visual Analytics)
An area we have been supporting and monitoring for number of years, the financial reports offer loads of information in multiple formats. This is also one of the first areas to get the PrescQIPP Visual Analytics treatment at both commissioner and practice level. Commissioner level reports are also available in Excel below:
Financial Growth Visual Reports
Financial Reports in Excel
Summary Growth Report
Detailing the year on year changes in both item, spend for all of our subscribers. Also includes a range of charts at commissioner and AT (old, not sub region) level.
Deep Dive Growth Report
Allowing you to select your commissioning area, and view the following at either full 12 months or year-to-date:
- Level 1 - BNF Chapter Level changes in spend and items.
- Level 2 - Going down to section & chemical level within the selected BNF chapter.
- Top 100 - Showing the Top 100 chemicals in terms of Actual Growth in cost, and compared to national.
Financial Inputs (incl. Cat M and Price Concessions and NCSO report)
The Financial Input reports brings together all the different elements that affect prescribing costs, such as Category-M, concessions and NCSO. Along with forecasting and actuals it brings together the entire data set at both Commissioner & Practice level.
This is also available in Excel (but only covers commissioner level)
Budget Setting ToolsTo support the annual activity of local budget setting we have created a tool that pulls together a range of datasets that could be used to help you plan for the year ahead. The report supports planning at practice level for all our subscribers.
Drug Tariff Watch Tools (kindly shared)We are grateful to be able to share two pieces of work to support monitoring of the changing Drug Tariff.
Tariff Watch reporting module
Tariffwatch is a document produced by prescribing advisers Mark Dasgupta and Andrew Martin (both working within the NHS), for the use and benefit of prescribing advisers also working within the NHS. Mark and Andrew have given permission for this work to be hosted on the PrescQIPP website for NHS users. It may be circulated freely within the NHS. More information can be found inside the document, linked below:
Pan Mersey APC Tariff Watch
Pan Mersey Area Prescribing Committee produces a report highlighting the top 100 price reductions and 100 price increases over the last 12 months. We think this a really useful piece of work.
Strategic activity reports
In this collection you'll find reports that focus on strategic activities relating to all or key parts of the monitoring that medicines teams do.
Low Value Medicines Support Tools
As part of the NHS England consultation document on “low value medicines” a set of anonymised graphs have been included for each of the 19 products in the appendix to demonstrate the variation in prescribing across all the England CCGs.
We thought it would be helpful to produce a corresponding set with CCG names so subscribers can identify themselves and other CCGs. These have been done as “top and bottom” to allow room for the CCG names. Please note that this data is aligned to the figures within the consultation, which is January 2016 to December 2016 and so may not reflect recent work and progress.
There are two sets of graphs: Cost per 1,000 patients; Total Cost. For more detailed analysis relating to most of these items please see the PrescQIPP Visual Scorecards
Conditions for which over the counter (OTC) medicines should not routinely be prescribed
NHS England have now published the guidance “Conditions for which over the counter items should not routinely be prescribed in primary care” https://www.england.nhs.uk/publication/conditions-for-which-over-the-counter-items-should-not-routinely-be-prescribed-in-primary-care-guidance-for-ccgs/
Visual Report - OTC Self Care Medicines Monitoring
Visual FP10 High cost drugs and high risk drugs prescribing reportThis report has been designed to allow the identification of inappropriate prescribing of both high cost drugs excluded from the National Tariff, and drugs which are associated with a high risk and therefore may not be suitable for prescribing in primary care. The report has been run on all high cost drugs excluded from the National Tariff and cytotoxic agents from sections 8.1 and 8.2 of the BNF. Now including practice level data!
Please note the following:
- The report only includes products that have at some time been prescribed on FP10 (e.g. if an excluded high cost drug does not appear on the report even as a zero cost, this is because it has never been prescribed on an FP10 and therefore does not appear on ePACT).
- The report shows the last 12 months available prescribing data and will be run monthly.
- Some prescribing may be appropriate e.g. via shared care arrangements, or through claw back arrangements for NHSE commissioned treatments, or may be due to an ePACT error.
- Inappropriate prescribing should be investigated locally.
Please email Jo Lowe email@example.com with any comments or suggestions for additions/changes to the report.
High Risk Drugs FP10 Prescribing Report (Excel - commissioner level only)
Generic Savings Report
This generic savings report is a visualisation of the generic savings available on both the BSA ISP and ePACT2 (we have removed Asacol MR and Concerta as it would be inappropriate to prescribe these products generically). The different visualisations allow you to view the missed opportunity, cost, items, volume and cost per 1000 patients across commissioners and the list of drugs.
The missed opportunity is based switching 100% of prescribing to the generic products identified on both systems (as shown in the full tag listing on the last page), if any of these products are on the price concession list for any particular month then this is also shown on the tag listing on the final page fo the view.
Out of stock bulletins and intelligence
- Alliance healthcare have agreed to share their most recent version of the out of stocks bulletin with PrescQIPP, you can download the latest bulletin below.
- The DH will also be sharing monthly intelligence on supply issues which are relevant to primary care. They are also seeking intelligence from the ground on anything that is becoming an issue. This surveymony link https://www.surveymonkey.co.uk/r/pqstockfeedback can be used to record any issues you are having locally with stocks and supply. We will create a report once a month to feed back up to DH.
Primary Care Rebates Administration System
Supporting the scoping and administration of schemes we have assessed and published.
PrescQIPP is the country's largest provider of NHS governance around Primary Care Rebates, and was amongst the very first. Whilst we neither support nor endorse the uptake or existence of Primary Care Rebate Schemes, but have long held the view that whilst activity occurs locally that good governance and transparency should exist. For more information on our Rebates work please visit the Primary Care Rebates Webkit.
To support this activity we have produced a Rebates Administration System to assist commissioners in monitoring the possible financial returns from any rebate scheme you may seek to sign up to. You will only get the benefits if you sign up to the scheme yourself. Every month we take the NHSBSA ISP full data download and apply the working of the scheme to the relevant data set. This gives a theoretical rebate amount so commissioners don't have to work it out themselves or solely rely on data from pharmaceutical companies.
Historically we had a range of Excel reports, but have now incorporated these into one all-singing-all-dancing system, linked below:
The traditional Excel reports will be available for the remainder of the 2016/17 financial year, and will then be retired.Rebates Monitoring System Downloads
In these reports you'll find comprehensive indicators and monitoring of projects relating to PrescQIPP work, including opportunity and achievement.
An introduction to our ScorecardsWhilst we do many kinds of data, or scorecards are the reports that we really hang our hat on at PrescQIPP, and what really differentiates us in terms of delivering intelligence to the NHS. Why? Because the wide range of indicators that make up these reports are derived from the evidence based bulletins and resources that we produce.
Effectively these indicators allow you, the commissioner, to underline your ambitions - and then progress - on an array of projects, considering variation, similar commissioners, opportunity and savings, and much more.
In reverse, these reports allow you to see where you're an outlier, or have significant opportunity, knowing that many clinical are available to support improvement projects locally.
The scorecards come in a range of Visual and Excel Reports at commissioner (CCG/HB) level, or practice level if you commission this extra support.
Visual Scorecard collection - all scorecards in one place
All of our scorecards together in one visualisation, with bags of new functionality for subscribers.
PrescQIPP Priorities Report (Excel)
The Priorities Report brings together headline information from across our three scorecards (primary, DROP-List and quality) in a simple and accessible format. The report will allow filtering of projects to support reporting within your commissioning area (s). This can all be found at: PrescQIPP Priorities Report (file download)
PrescQIPP Priorities Report (folder)
The Primary Care Scorecard (Excel)
The PrescQIPP Primary Care Scorecard is the nerve centre for all of our strategic prescribing projects, and is constantly growing in both use and functionality. The scorecard is directly aligned to our projects, and monitors changing activity at a commissioner level, as we update it each month. This resource is the first place to go before delving deeper into our data. Below is an outline of the scorecard's key features:
Summary Report - offering key information from all of the following tabs in one place for your area. As is the case throughout the document you can filter by YTD, last 3m or individual months within the FY.
Achievement - Compares commissioners across our community, grouped by Area Team (previous, not sub-region), against all of our 50+ project indicators.
Monthly Progress - Mapping your commissioning area's monthly progress against the project indicators. See what's improving and what's not in your patch.
Ranking - Looks at how you compare, and rank, against the England and Wales, your 10 'cluster' comparators (most like you as defined by NHS E), and within the PrescQIPP Community. We also provide the Range within these groups.
Avoidance (to Target & 100%) - The cost avoidance each subscriber could achieve within a 12 month period. Custom parameters to reflect recent activity.
Missed Opportunity (to Target & 100%) - The cost avoidance you could have achieved if the switch had been made - useful information for business cases.
Supporting info - including ePACT tags & tag listing and methodology - updated monthly, so you can replicate these projects at a practice level.
The Quality Scorecard (Excel)
The quality scorecard brings together prescribing indicators which focus on appropriate prescribing, medicines safety and medicines optimisation issues. national prescribing indicators have been included and there are a few new indicators which we thought would be useful. There are no savings calculations on the quality scorecard and as with the primary care scorecard RAG ratings are based on top 10% or top quartile nationally (Q4 14/15). This document is new, and currently in consultation - your feedback would be very welcome.
The DROP-List Drugs Scorecard and DROP-List Devices Scorecard (Excel)
The PrescQIPP Drugs to Review for Optimised Prescribing is one of our most popular project areas. We have traditionally produced a snapshot for this area, however following the release of the NEW DROP-List, we have now updated the monitoring to a whole new level of utility - akin to our other scorecards. For more information about the DROP-List please visit the DROP-List page.
Tools that explain what's in the data (metadata) and provide backgroundIn addition to the work that we're doing to produce data, we are also building a repository of tools, widgets and guides to help you understand our data, replicate at a practice level and support your own initiatives.
Practice Level Scorecard VA to Excel temple – A template to convert data extracted from the practice level visual scorecards to the old Excel format with conditional formatting applied.
Closest CCG Finder – A tool that helps you identify and understand how closest CCGs included across the data range have been calculated - by NHS England's Commissioning for Value not us:
Data Change Log – Always current, a log which details changes, enhancements and changes made to the data.
Full BNF Lookup – an extremely useful tool that lists all BNF codes linked to all BNF levels.
Scorecard Support Calculations – Shows the meaning of the methodology used across the scorecards along with calculation methods applied.
Scorecard Support Tag Methodology – An up to date version of both summary and full listing of our tags. Includes shared tag epact name along with full nutrition and dressings categorisations.
Scorecard Support Tag Methodology New Products – Updated monthly after release of the data, this will keep you up to date with new products added and if/where they apply to our tag listings and/or categorisations.
These can all be found together at:Support Tools
Watch a short introduction to the support tools
In this five minute video, Rachel gives a brief introduction to the intelligence support tools.
Watch a video with an in depth explanation of wound care categorisation
The Scorecard Support Tag Methodology now includes the comprehensive wound care categorisation. To introduce this categorisation and also provide some introduction and training, please watch the video below.
Visually reporting on a range clinical or therapeutic areas, often including categorisations of often complex areas.
Snapshots - an introduction
A Snapshot is a report that providing categorisation and activity within a key area of prescribing, but does not go as far as a Scorecard. The reports may not be specifically linked to a set of our ‘projects’. They are, however, still packed with loads of useful information, down to practice level and are often very popular reports with our subscribers.
We produce Snapshots covering the following categories:
- Controlled Drugs
- Oral Nutrition
- Wound care
A range of visual reports are available to subscribers after logging in.
Quick visual Snapshot maps
Continence Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Continence Visual Snapshot. Please click the below to popup and play:
Dermatology Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Dermatology Visual Snapshot. Please click the below to popup and play:
Diabetes Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Diabetes Visual Snapshot. Please click the below to popup and play:
Oral Nutrition Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Oral Nutrition Visual Snapshot. Please click the below to popup and play:
Pain Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Pain Visual Snapshot. Please click the below to popup and play:
Specials Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Specials Visual Snapshot. Please click the below to popup and play:
Specials Tariff WatchThe quarterly specials tariff watch is designed to help prescribers navigate the changes in Part VIIIB of the drug tariff to facilitate cost-effective prescribing. It also includes the top ten list of potential highest savings. The document is based on, and replaces, work by Anne Fowler of NHS Lancashire (with thanks!). Specials Tariff Watch
This supporting document to the Specials Tariff Watch, shows the supporting data by CCG where opportunity lays, by specific drug and quantity.
Stoma Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Stoma Visual Snapshot. Please click the below to popup and play:
Woundcare Snapshot Reports and Visual Analytics
As part of the new PrescQIPP Visual Analytics platform, integrated into this website, we're delighted to launch the new Woundcare Visual Snapshot. Please click the below to popup and play:
Health System Profiling
A selection of reports to profile your health system in a changing NHS.
Deprivation and Ethnicity Mapping
We've now released a new visual report to help subscribers provide different perspectives around health and social needs in their local areas. In this report we have mapped the most recent cencus data at lower super output area (LSOA) which is linked to commissioner, covering the various social indices of deprivation. A second view covers ethnicity at commissioner level.
Whilst deprivation rankings are applied to LSOAs, PrescQIPP has sought to produce a set of experimental 'Practice deprivation rankings' based on the indices of deprivation at LSOA level. Please note that this is an indicative measure that has been calculated by deriving the proportion of the practice population in each LSOA area. Methodology is provided within the visual report.