Data Quality Improvement Case Study at Major University

This case study details the collaboration between a major university in the USA and Datagaps, focusing on the implementation of data validation tools during the university's migration to a new ETL tool and their data warehouse transition to Snowflake. The university developed 1500 use cases to validate the accuracy of the new ETL processes, ensuring that discrepancies were addressed promptly. The success of the ETL validation led to the adoption of data quality scoring capabilities to assess the quality of student census data and other data analytics processes. The university's Data Governance team utilized these tools to identify and correct data errors before deadlines, thereby enhancing the accuracy and reliability of published data. Additionally, the case study highlights the reduction of resources required for data validation by 66%, resulting in significant cost savings and improved data quality, which positively impacted the university's reputation and stakeholder trust.