Introducing PrescQIPP Visual Analytics
Find out more about our Visual Analytics here
We’re delighted to launch the PrescQIPP Visual Analytics platform, offering a range of exciting new reports for commissioners. This is a big development for us and we’ve got really exciting plans to coalesce our clinical content with activity data. 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.
Our first plan will be to create visual versions of all the excel reports, eventually removing the Microsoft Excel practice level reports (we'll keep the commissioner level ones). This will allow us to focus attention on some really exciting new developments in 2017.
How to find the Visual Reports?
There are two key ways you'll be able to access these reports - firstly as popups (illustrated below) which is our favourite way or alternatively within their own pages (see list of direct links further below):
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.
Bulletin Data Packs
Visual Data Packs (from 2017)As our march towards snazzier, more interactive data presentation continues we are now pleased to upgrade these reports to include all of the best elements of the previous Data Packs but with a whole new range of goodies including:
- Interactive Maps and tables
- Closest commissioners based on CfV indiciators
- Scatterplots, and other useful charts
- Practice level data (if you subscribe to this extra)
Please see the reports that we've done so far below:
Older (2016) Bulletin Data Packs in PDF and ExcelWith each and every bulletin we release, we have produced a data pack covering all of our subscribers (where we have data). This provides a ready reckoner for prescribing teams, to identify where their organisation sits, and whether the project is a priority. Within a typical data pack, you will expect to find:
A table covering all organisations within the partnership, grouped by area team, showing activity, total spend and per 1,000 patients. If the project is a financially oriented project this will also include cost avoidance to target and 'best' (the highest performing commissioning area).
Charts illustrating activity and cost - often totalled and per 1,000 patients, compared to National.
An Atlas of Variation style map showing activity within the partnership.
Once published, these data packs will be updated every six months to include new members and re-inform decision making.
Bulletin Data Packs
Financial Activity, Growth and Change Reports
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:
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.
Watch a short introduction to financial growth reports
In this five minute video, Rachel gives a brief introduction to the reports and what's included.
Category M Growth ReportOffering a presentation (scenario) to help anticipate the impact of category M price changes within the FY.
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 those who utilise our practice level support, and there's a template for you to include your practice information if you don't.
Budget Setting Tool - Practice Level Data (if you subscribe to PL support)
Budget Setting Tool - CCG Level Data (if you don't)
Controlled Drugs MonitoringDesigned to support monitoring of the different schedules of controlled drugs at a local level, and offer comparisons at a national level. The schedules have been split into schedule 2, schedule 2 injectables then schedules 3, 4 and 5. There is the functionality within the report to review prescribing at a product level.
Watch a short introduction to controlled drugs monitoring
In this five minute video, Rachel gives a brief introduction to the report and how to use it.
NCSO Price Concessions Cost Pressure ReportSupports the monitoring of drugs designated as NCSO and identifies the cost pressure each month relating to these products. This is not a forecasting tool, but a tool to highlight the actual cost pressure associated with these drugs.
Watch a short introduction to the NCSO Price Concessions Cost Pressure report
In this five minute video, Rachel introduces the report and some useful functionality.
Drug Tariff Watch ToolsWe 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.
Out of stock bulletin - Alliance HealthcareAlliance healthcare have agreed to share their weekly out of stocks bulletin with PrescQIPP. They have also agreed to us publishing it online, please follow the link below to view the latest live bulletin. Out of stock bulletin - Alliance Healthcare
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.
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 16/17 (file download)
PrescQIPP Priorities Report (folder)
Watch a short introduction to the priorities report
In this one and half minute minute video, Rachel gives a brief introduction to the report and how to use it.
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 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.
The Self Care Scorecard (Excel)Our latest scorecard focusing on items and products that may fit into a local self care campaign, in line with PrescQIPP's self care materials.
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.
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.
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
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.
Primary Care Rebates Administration System
Primary Care Rebates Administration System
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:
These can also be viewed in your web browser here
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
Antimicrobial Stewardship (AMS) in collaboration with NHS E
Antimicrobial Stewardship (AMS) Data on behalf of NHS E and NHS IThe Antibiotic QP prescribing report for 2014/15 are available here as part of our collaboration with NHS England to support CCG Quality Premium activity. This work has been led by Elizabeth Beech, Healthcare Acquired Infection and Antimicrobial Resistance Project Lead, Patient Safety Domain, NHS Improvement, and piloted with a number of CCGs, and then produced by PrescQIPP's Rachel. This is available to the public.