Enterprise Information Management - Kennesaw State University

The growth of African American graduates at KSU was eight times higher than the national growth rate over the past decade.

Data Management

The Office of Data Management and Information Architecture is an interrelated unit of EIM that utilizes sophisticated technology and systems that promote data and information consistency, integrity, accessibility, and usefulness. This office is responsible for data quality and data warehousing initiatives at Kennesaw State University (KSU).

General

Data Committees at KSU
Outlines the various unofficial committees and teams at KSU for data security and data management.

Reporting Relationships
A diagram representing the various BOR and KSU reporting relationships between ERP data sources and various data marts

Business Processes

Data Work Flow
A diagram representing a generalized template as to how data flows into, through, and out of KSU's ERP data sources and data marts.

Freezing Source Data in Banner
The concept for freezing source data in Banner during the ADM Census/Mid Term Due Date and End Term Due Date.

Banner Grade Point Averages
Discusses how the different types of GPA's in Banner at KSU.

Banner Cohort Definitions for STVCHRT
Contains information related to defining cohorts consistently in Banner.

Banner Address Entry
Contains information related to defining cohorts consistently in Banner.

Banner Address Maintenance
Contains information related to defining cohorts consistently in Banner.

Fact Book Work Flow (May 2007)
A diagram of the EIM Fact Book workflow.

Virtual Information Center Work Flow (May 2007)
A diagram of the proposed workflow for replacing the existing Fact Book.

Academic Data Mart (ADM)

ADM Processing Steps
Outlines how data is extracted, loaded, and editted from KSU to the BOR/OIIT ADM.

Academic Data Mart DED and File Layouts (May 2005)
OIIT supplied data element dictionary.

OIIT Component Documentation, EXTRACTION, ADM VERSION 2.7 (January 2006)

OIIT Component Documentation, EXTRACTION, ADM VERSION 3.1 (February 2008)

ADM Data Element Dictionary (December 2007)

The following are ER diagrams of the ADM:

STUDENT_PROFILE
Diagram containing the dimensions for the student profile fact table.

STUDENT_COURSE_ENROLLMENT
Diagram containing the dimensions for the student course enrollment fact table.