U.S. Department of Housing & Urban Development

HUD allows programs to attest to their assurances and representations using a single questionnaire that has transformed annual program data collection process into an automated and connected eco-system of Microsoft powered tools. This transformation removes time-intensive steps and enhances the analysis of program SOAs and MRLs. SharePoint lists allows the questionnaire to exist on a live shared platform and enables integration with other Microsoft Applications. Microsoft Power Apps applications facilitate both the interim and year-end questionnaire submission and provides automated PDF creation abilities. Finally, a Power BI dashboard enables real-time reporting, comparison, and analysis of program SOAs and MRLs.