SQL Server Data Marts
The SQL Server data marts have been used to serve the university data needs for a few years. The data marts consist of:
- Student data mart
- Financial aid data mart
- Human Resources data mart and
- Financials data mart.
Each data mart consists of mainly star schemas with the source of data being the primary ERP systems: KSIS, HRIS, and FIS. The structures in the data marts are updated via nightly load.
The student data mart contains data from application to graduation. It has application data from KSIS, Slate and CollegeNet; it includes enrollment, the program/plan stack and census day reporting; it has degrees and retention analysis.
The human resources data mart includes human resource transaction, and payroll information including payroll funding. We have begun to bring in budget data to report against payroll funding and to be able to project fiscal year expenditures.
The financial aid data mart contains financial aid disbursement information and student financial transactions.
Direct access to the data marts is currently limited, and specific data are available upon request via DAIR website.