Skip to main content
2026 AIR Forum Main banner
Icon Legend
This session is not in your schedule.
This session is in your schedule. Click again to remove it.
Back

Technology & Tools

Speaker Session

The Maturation of Data Workflows for Compulsory State Reporting

Wednesday, May 27, 2026
2:45 PM - 3:30 PM East Coast USA Time
Location: Cherry Blossom Room (Mezzanine)
Institution Type: 4-year institutions

Target Audience: Any
Session Abstract: Time is finite and preciously valuable, so finding ways to squeeze in more work into the same amount of time is a challenge that resonates with all. While some projects may ultimately be optional, compulsory reporting is certainly not one of them. These responsibilities continue to evolve and typically grow over time, so finding ways to complete required submissions with more efficiency is usually a task worthy of investment. In this presentation, we will discuss the evolutionary and maturation of our data collection, cleaning, and reporting processes for the recurring state fillings. We will discuss lessons learned, challenges experienced, stories of success, and areas we still wish to improve. By sharing our experience, we hope to inspire others to fine-tune their own compulsory reporting processes to aid in bringing increased work efficiencies to their own offices and departments.

Keywords: Reporting, Data Quality, SAS, ETL, SQR