Version 1.0 of the HMIS CSV Data Quality Tool Now Available for Local Use
Homeless Management Information System (HMIS) has become a significant data source to better understand homelessness in the U.S. Good quality data is foundational to reporting to funders, stakeholders, and communities for better policymaking and improved funding opportunities. The HMIS CSV Data Quality (DQ) Tool was developed to help Continuums of Care (CoCs) and is not required by HUD. It applies a series of logical checks to HMIS CSV Exports and provides detailed information to the CoC about potential issues found in their data.
In the future, communities utilizing their HMIS to track Coordinated Entry (CE) events and assessments will have access to an interactive CE System-Wide dashboard. This Excel workbook will pre-process HMIS CSV Exports and prepare a CE System-Wide dashboard with your local data, which is currently under development.
Accessing the DQ Tool and User Support
Version 1.0 of the DQ tool is publicly available on the website Bitbucket. Version 1.0 incorporates feedback that communities provided on the Beta version of the DQ tool, which was initially released on November 15, 2021. The DQ Tool and User Guide are available on the downloads page of the Bitbucket site.
If a community experiences an issue with the tool, they can log an issue on the Bitbucket issues page through the end of January 2022. To submit an issue and receive updates on the DQ Tool, sign up for a free Bitbucket account. Starting in February 2022, questions about the DQ tool will need to be submitted to the Ask A Question portal on the HUD Exchange. In Step 2 of the question submission process, select “HMIS: Homelessness Management Information Systems” from the “My question is related to” drop down list.
Please note that Version 1.0 of the DQ Tool is supported on Windows and Windows Excel versions 2003 and later. Excel for Mac is not supported currently.
Disclaimer: This resource is prepared by technical assistance providers and intended only to provide guidance. The contents of this document, except when based on statutory or regulatory authority or law, do not have the force and effect of law and are not meant to bind the public in any way. This document is intended only to provide clarity to the public regarding existing requirements under the law or agency policies.
SNAPS Mailing List Subscription
Stay up to date on HUD’s Special Needs Assistance Programs (SNAPS) news and updates for grantees and interested stakeholders:
- Sign up for SNAPS Competition Information through HUD.gov
- Sign up for SNAPS Program Information through HUD.gov
- Sign up for SNAPS Technical Assistance Information through HUD Exchange