X
GO
Health IT Enabled QI Resource Sets

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!

Documents to download

Previous Article HITEQ Highlights: Using Health Information Technology to Enhance Opioid Use Disorder Treatment
Next Article HITEQ Highlights: Growing and Sustaining a Data Driven Culture
Print
19660
Intended AudienceHealth Centers Staff, Quality Improvement Staff

Acknowledgements

This resource collection was cultivated and developed by the HITEQ team with valuable contributions from Chris Espersen, Espersen & Associates and Past President of Midwest Clinicians Network, Dan Tutuer, former head of Colorado's HCCN, and Dr. Jerome Osheroff, TMIT Consulting, LLC, as well as HITEQ's Advisory Committee and many health centers who have graciously shared their experiences with HITEQ.

LookingForSomethingDifferent

Looking for something different or have something you think could assist?

HITEQ works to provide top quality resources, but know your needs can be specific. If you are just not finding the right resource or have a highly explicit need then please use the Request a Resource button below so that we can try to better understand your requirements.

If on the other hand you know of a great resource already or have one that you have developed then please get in touch with us by clicking on the Share a Resource button below. We are always on the hunt for tools that can better server Health Centers.

Request a Resource  Share a Resource
Search
Quick Feedback Request
Highlighted Resources & Events
Need Assistance?
Would you like more assistance regarding Health IT Enabled QI strategies or support in using any of the include resource sets?

  Request Support

 

Upcoming Events
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