Ensuring Data Model Integrity and Accuracy

A Structured Data Testing Tool for Large-Scale Surveys

Image of portfolio item

In support of our suite of dashboards and reports for U.S. EPA’s Office of Water, Crow Insight developed a structured data testing tool in R Shiny. Due to the complex stratified sample design of the National Aquatic Resource Surveys, accurate and efficient data testing was essential in ensuring the integrity of data presented in dashboards, reports, and infographics. Our tool verified data model shape and accuracy, and displayed flagged issues in a flexible format that allowed our EPA partners to identify and address errors in the data.