Collaborative Strategies to Support Institutional Data Integrity

Session Abstract: With the constant demands of information and analytics on institutional researchers, timely, accurate, and relevant data sources are essential. Leveraging ETL processes required to ensure state and federal reporting compliance, we will demonstrate the evolution of data integrity workflows that identify key data errors in our information systems, deliver automated alerts to data stewards, and assist the IR staff with triaging and collaborating across the institution, resulting in our official census files. We will discuss lessons learned, feedback from our collaborators, and opportunities for future development. We will use the remaining time to open the floor to discussion and knowledge-sharing related to data governance practices at attendees' institutions. After attending this session, attendees will have the knowledge and tools to determine the applicability of implementing similar processes at their institutions.

Keywords: data governance, data cleansing, IPEDS, CHEMIS, SAS, Cognos, Teams, SharePoint, ETL, PowerShell