Accessing Data for QI

As adoption of EHRs has increased, so have the concerns about ability to access the data needed to drill down into quality improvement efforts or even reporting requirements. Depending on the type of system being used, data may be cloud based, on a remote server, or on a local server. Further, data may be accessible through preprogrammed, ad hoc, or custom reports, but there may be greater challenges to accessing raw data or data that can be analyzed for quality improvement purposes. Resources in this section address these challenges and provide actionable information for accessing the data needed.

Accessing your Data

Annual UDS Clinical Measure Data Dashboard

Excel Tool for Data Monitoring

This Excel file dashboard was shared by an existing health center and is used to depict performance on UDS measures over time. It was recently updated 2018 reporting requirements and clinical measures.

Download the Excel file below, and follow these steps to get started:

  • Begin by updating information as necessary. For example:
    • If measures have changed or you would like to track a slightly different measure, then reflect that change in the numerator and denominator description on the relevant clinical measure's tab
    • Update column headers on each clinical measures tab with the dates you will be monitoring, as needed
      • i.e., monthly, quarterly, etc.
    • Remove extra rows as necessary
      • i.e., if your organization has three sites, then you would leave Goal, Clinics A through C, and Organization, and delete the other rows.  Alternatively, you can use them for other stratifications (care teams, different subpopulations of patients, etc.) and you would just change the labels
  • Pull data for patients seen in the last 12 months or some other predetermined time period (which is key to ensure that data each month will be comparable) in accordance with the appropriate definitions for each measure, by site and for the whole organization.
  • Plug the data into the each clinical measure tab of Excel file
  • Add data in subsequent time periods as desired
  • Then check the Charts tab of this Excel file for your monitoring charts!

This can be used to communicate with staff or monitor performance on UDS measures, and can be tweaked to use for other measures. There is also a tab with some real world advice on creating and using basic data monitoring dashboards included on the first tab.

Download the dashboard tool below!

Intended AudienceHealth Centers Staff, Quality Improvement Staff

Documents to download

Theme picker


This resource collection was compiled by the HITEQ Center staff with guidance from HITEQ Advisory Committee members and collaborators of the HITEQ Center.

Search HITEQ Content
Need Assistance?
Would you like more assistance regarding Health IT Enabled QI strategies or support in using any of the included resource sets?

  Request Support


The Quadruple Aim
Quadruple Aim

A Conceptual Framework

Improving the U.S. health care system requires four aims: improving the experience of care, improving the health of populations, reducing per capita costs and improving care team well-being. HITEQ Center resources seek to provide content and direction aligned with the goals of the Quadruple Aim

Learn More >