Distributed Reporting: A Cost-Effective Alternative to Data Warehousing

Presented at: National Human Services Data Consortium (NHSDC) Presented on: 10/13/2011

Legal issues can prevent data warehousing from being a viable option for creating high quality reports outside of a HMIS vendor's software.  The distributed reporting model (DRM) has been developed to address this issue.  Instead of sending confidential client data to a warehouse the reporting logic is sent to the data.  HUD embraced this innovative new approach with the licensing of the APR Generation Tool from Simtech Solutions.  This reporting tool is being used by grantees around the US to produce the Annual Performance Reports (APRs) that must be submitted every year in order for these programs which assist the homeless and at risk of homeless to maintain Federal funding.  This same tool was also successfully used by several states and regions to meet an aggressive deadline to report back to HUD and to Congress on the measurable outcomes from the $1.5 billion dollar Homeless Prevention and Rapid Re-Housing Program (HPRP).  

The presentation covers the approach used to create the APR Generation Tool, and other DRM reports, and highlights the advantages and disadvantages of DRM when compared to data warehousing or reporting directly from a HMIS vendor's software.  

Click here to Download