Institutional Research manages institutional data and information through coordination with data stewards of source systems and appropriate IT resources to ensure that data is accurate, consistent, and secure.
The AU Data Warehouse is an important part of our analytics toolkit. Founded in 2006, this database is the product of close collaboration between IR, data stewards, and the ITS University Analytics team.
We regularly extract data from a variety of authoritative systems – including Banner, InfoEd, and PeopleSoft HR and Financials -- to populate the warehouse database. Unlike those data sources, the data warehouse is optimized for reporting trends and summaries across multiple institutional data domains. Data are structured for fast retrieval. Calculations and other derived data elements are defined consistently and adhere to institutional reporting standards.
Data warehouses are never “finished”. They evolve through iterative development to address changing institutional needs. IR leads the data warehouse change process. We evaluate and prioritize efforts, collaborate with data stewards to ensure proper definitions and sourcing, and coordinate with ITS to validate accuracy and performance. A typical change request follows the cycle illustrated here.