NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ851062
Record Type: Journal
Publication Date: 2009
Pages: 10
Abstractor: ERIC
ISSN: ISSN-0010-0889
Using Dimensional Data to Address Enrollment Management Questions in Higher Education
Duniway, Bob; Wiegand, Karl
College and University, v84 n4 p32-41 Spr 2009
Enrollment management is central to the success of a college or university. A school must enroll students into courses, completion of a series of which will lead to graduation. While all colleges and universities must manage the enrollment process at least operationally, it is challenging to keep track of all the related data that would allow for managing the process more strategically. Recent advances in business intelligence tools can help address the complex topic of enrollment management. Among the most promising advances are software for building dimensional data structures (often referred to as OLAP [on-line analytical Processing] cubes) and user-friendly tools for analyzing these structures. Progress in adopting these tools, however, has been slow because enrollment management raises questions that are difficult to organize in a dimensional schema. In this paper the authors propose a general framework for applying dimensional modeling to a set of enrollment management questions that are common to many colleges and universities. They begin with an articulation of some standard enrollment management questions grouped by focus. They then use these questions to build a dimensional model around a small set of fact tables. After explaining how the model is derived from these questions, the authors show how the model can be extended to address related subject areas or questions unique to a particular school. This paper confines itself to a logical model; implementation of the model depends on many factors, including performance considerations and technology choices. (Contains 2 figures.)
American Association of Collegiate Registrars and Admissions Officers (AACRAO). One Dupont Circle NW Suite 520, Washington, DC 20036. Tel: 202-293-9161; Fax: 202-872-8857; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Research
Education Level: Higher Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A