The PowerBI clinical dashboards are designed to give you clinically useful information that will help you to improve the care of your patients.
Our clinical dashboard programme aims to provide focussed data visualisations of your own practice information. The dashboards will give you practical outcomes for individual patients and populations, and in particular support pro-equity activity.
Each designed around a set topic with easy to navigate filters, these dashboards should assist with case finding, thinking about quality and identifying patients who may need your care.
Flu eligibility is a Power BI app, which allows identification of patients eligible for Influenza vaccination as well as tracking who has been vaccinated. This will allow practices to identify a list of their eligible patients and view a heatmap of their addresses. Patient lists can be prioritised by eligibility group, ethnicity, and deprivation quintile.
Currently (05.04.23), these lists of patients will still include those patients whose vaccination events have been completed by other providers and only been entered into CIR or AIR. We expect to be able to provide further updates on this in the next few weeks.
The Measles dashboard is accessible via PowerBi with data pulled from both your PMS and NIR. The PMS data is updated nightly and the NIR data updated every Monday evening.
Access via your usual PowerBi login and search 'Measles dashboard' in the search box on the top right of the landing page. Please use the filters on the right of the screen to build a patient list of those who have an incomplete or no history of MMR immunisation.
We suggest using filters to compile a list that is prioritised with Māori, Pacific peoples, and higher deprivation quintile (e.g quintile 5).
Some children may have received MMR0 aged 6-11 months, these children still require a further 2 doses of MMR vaccine at ages 12 months and 15 months. Please ensure you have MMR stock and capacity to immunise those you recall.
If there are discrepancies between your immunisation PMS record and NIR please review how the immunisation was entered in your PMS (e.g all data fields completed, and indications correct). Do not count MMR0 as a valid dose as immune response and long-term protection from measles is less, see the Immunisation Handbook for further information.
Please contact nursing@pinnacle.health.nz if you have any further queries.
In the diabetes clinical dashboard you will find a patient report that will allow you to identify the NHI numbers of the patients who, for example, could be benefiting from Metformin, Empagliflozin or Dulaglutide, those who may need insulin added to their regime, and those without diabetes who meet recommended screening guidelines.
This dashboard helps practices understand the disease burden their population brings, their CVRA assessment rates, and whether people who have a known past CVD event are on appropriate medication. This will allow practices to specifically identify people most at risk of CVD and to consider ways to lower their risks. In addition to presenting key clinical metrics for your CVD patients, you will also be able to compare your performance against a benchmark group.
The COVID-19 clinical dashboard allows practices to see how many of their patients have been tested for COVID-19 and when, a detailed breakdown of COVID-19 vaccination – including the ability to map out where patients live, and more.
You can filter your patients by, for example, test results, ethnicity, and vaccination status. A map is provided so you can also clearly see any clusters of patients meeting the criteria you define.
Please note if the map function doesn’t load it could be a browser extension such as LastPass preventing correct operation, please try disabling such extensions.
Therapeutics: a recent update means this dashboard can now provide practices with a list of patients eligible for Paxlovid / Remdesevir or Budesonide should they get COVID-19.
For example, it shows there are 1,225 people in Waikato who would be eligible for consideration of Paxlovid if they got COVID-19, but only 267 of those have not had their booster vaccination and only 37 of those are Māori or Pacific people.
The therapeutics feature includes a patient list, like that on the "Detail" page, that allows you to filter by preset clinical criteria. This will give you a list of those patients who are eligible for Paxlovid, Remdesivir or Budesonide if they are COVID-19 positive.
Not all of these patients will be suitable, nor will all of them accept treatment, but we encourage practices to use these lists to proactively reach out to patients and inform them that if they become symptomatic an early diagnosis is recommended and potentially treatment is available.
Note this list does NOT exclude patients with contraindications, dose needs to be adjusted with even mild renal impairment and the list of drug contraindications is significant and includes commonly prescribed medications like colchicine, simvastatin, diazepam, clozapine, carbamazepine, phenytoin, and St Johns wort amongst others.
He Ako Hiringa has useful drug interaction checking references on their website.
For more information about therapeutics in COVID-19 see our therapeutics resource page, which includes an education session recording featuring Dr Kate Grimwade in BOP.
The COVID-19 community management feature allows practices to identify COVID-19 positive patients and help them prioritise which patients require follow up. We have flagged patients who are 'high risk' using criteria for the original vaccine roll-out. This encompasses a range of chronic disease, as well as uncontrolled hypertension, pregnancy (where coded) and much more.
All practices will receive a file of patients, daily at approximately 9am (this relies on incoming data from BPAC so unfortunately we cannot do it earlier). This will show details of any patients having a positive test (PCR or RAT) in the previous two days. For each patient we also include contact information where we have it. Each patient is flagged as 'High risk? = Yes’ where they meet the group 3 eligibility criteria.
Practices already accessing the Covid Clinical Dashboard can obtain the same data following the below steps.
See this One Point Lesson for more information.
The data can also be exported to excel if you prefer.
Medtech practices only: The data in this report is drawn from the BPAC extract. Should the practice BPAC extract not be received, the information contained is this report will not be updated. Please ensure your BPAC extract runs routinely and contact your IT provider if it does not.
Booster dose data is available, including the ability to filter by booster eligibility and booster status at a patient level on the "Detail" page and booster coverage tracking on the "Covid Vaccine Tracking" page and "Vaccine coverage by practice" page. Note that two definitions of booster coverage are used across the app: "Population booster coverage" shows the percentage of the total population (aged 12+) who have received a booster dose, while "eligible booster coverage" (currently displayed only on the "Vaccine coverage by practice" page) shows the percentage of the population who are eligible to receive a booster who have received a booster dose.
The Community Planning page has been added to provide general practice with indicative numbers around the prevalence and case management of COVID-19 in the community. This report is based on the “C-SIQ General Practice and Urgent Care working group predicting COVID-19 disease severity” document prepared by Dr Gary Jackson (Director of Population Health, Counties Manukau Health).
More clinical dashboards are on the way with a focus on cancer and respiratory disease outcomes.
If you have ideas for future dashboards that will be useful, questions, or would like a demonstration personalised for your practice please get in touch.
Because the new dashboards now also contain identifiable patient information, we need to make sure we can audit access of this data. Access will therefore only be given to named users in your practice.
Pinnacle will cover Power BI licence costs for one named user and one nurse lead per practice, and you can purchase others as required at a rate of $4.90 per user per month. We recommend you begin with access for the clinical lead within your practice.
To arrange access for your named user please Contact Samrithy Yean.
Please note that these dashboards are only available for practices using Indici, Medtech 32 or Medtech Evolution.
For further support please contact:
Jo Scott-Jones, Clinical Director
drjo@pinnacle.health.nz
027 475 0488
We are proud to announce the data team at Pinnacle Ventures has achieved AWS Select Partner status.
Read moreThe Waikato Medical Research Foundation exists to support and encourage research within the Waikato region and to assist in the publication of the results of this research. The Foundation awards grants that contribute to the overall costs of the research project but do not fund overheads nor profit. Grant applications of up to $30,000 are welcomed. Applications close 30 April 2023.
Read moreA quick reference guide to severe mental illness recommended READ and SNOMED codes.