Please provide your email address so we can keep you informed of any updates to these resources.
Each year, the Data Integration, Systems, and Quality (DISQ) Team reports back to ADAPs on the medication data they have uploaded on their annual ADR. Using Microsoft Power BI that is included as part of most Microsoft licensing, the DISQ team has created an ADR Medication Dashboard that enables you to do this analysis at any time during the year to check the accuracy of your medication data.
The dashboard uses a unique client ID (which can be any arbitrary number assigned to each client) and four ADR data elements:
- Medication ID (data element ID 26), the d-code for the dispense
- Medication start date (data element ID 27), the day of the dispense
- Medication days (data element ID 28), the days supply of the dispense
- Medication cost (data element ID 29), the total cost paid for the dispense.
The template used to populate the ADR Medication Dashboard is the same structure as the TRAX medication CSV (AdrClientReportMedication), but must be saved in Excel format. A structured CSV file is included in the download package for you to fill in with your data.
PDF file: This instructional document outlines how to download Power BI (the application you will need to run the ADR Medication Dashboard), how to upload your medication data to the tool, and how to interpret what the tool shows you. If you have additional questions about how to use the ADR Medication Dashboard, contact the DISQ Team.
XLSX file: Your data will need to be in this template file in order to populate the ADR Medication Dashboard. If you are a TRAX user, the template will look familiar as it is the same structure as the TRAX medication CSV. If you are not a TRAX user, you can generate a report from your data system and paste the data into the provided template. If you are unsure how to do this, contact your data system vendor or the DISQ Team.
BPIX file: This is the Medication Dashboard tool which will need to be opened in Microsoft Power BI. While Power BI is included in most Microsoft licensing, you may need to work with your IT staff to download the software before you can open this file.