ADR In Focus: How to Use the ADAP Data Report (ADR) Medication Dashboard

Data Integration, Systems and Quality (DISQ) Team

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

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.

Part of Collection

We'd like your feedback

Was this page helpful?
I found this page helpful because the content on the page:
Check all that apply
I did not find this page helpful because the content on the page:
Check all that apply
Please include an email address if you would like a response
Please include an email address if you would like a response