SQL Server Data Marts
The SQL Server data marts have been instrumental in meeting the university's data requirements for several years. Comprising the following components:
Student Data Mart
Financial Aid Data Mart
HR Data Mart
Financials Data Mart
Each data mart primarily comprises star schemas sourced from the university's primary Enterprise Resource Planning (ERP) systems: KSIS (Kansas State University Student Information System), HRIS (Human Resources Information System), and FIS (Financial Information System). The structures within the data marts are updated nightly.
Access
Access to the data marts is currently restricted to a limited audience. To request access to the K-State Analytics data warehouse system, please visit the IT Service Portal using the link below.
Request Identity and Access Management Service