Higher Ed Administration Data Warehouse Solution

Situation Assessment
Since 1993, this Risetime client had been using a legacy system application to help manage daily operations related to student registration and enrollment, college administration, financial aid, and other important institution functions.  As a result, a significant amount of data and information were stored in the legacy system's history files. 

While this system was providing an appropriate level of functionality for their institution, it had limited on-line data analytic capabilities and did not allow effective and timely executive management reporting.  This resulted in less than ideal efficiency for many personnel, as well as limited decision making abilities - all at a time when many institutions and businesses were being challenged to do “more with less”.

Consequently, Risetime was engaged to help remedy these inefficiencies and to further support the activities and needs of the Registrar’s office.

Solution Overview
Risetime began by completing a comprehensive organizational assessment, coupled with a requirements & needs gathering process specific to the Registrar’s office.  Risetime then constructed a high-level general design of the solution needed to address the Registrar’s office high priority needs.

To address these needs and ultimately, to provide extended functionality to more effectively analyze the significant amount of data from the legacy systems, Risetime developed and implemented a Data Warehouse solution.  The Data Warehouse focused on supporting the accounting and finance office, specifically by developing a budget and financial Business Intelligence model.

Value Measurement
The Business Intelligence model implemented by Risetime not only generated monetary benefits, but it also provided improved customer service for both staff and students alike. In addition to more rapid response time, extended benefits include:

  • Standardization of the course-scheduling process
  • More effective budgeting
  • Improved strategic planning
  • Centralized, consistent data across the Institution
  • Reduced need for IT support

While easy access to information has transformed more of their staff into "knowledge workers", the college continues to successfully focus on providing individualized attention to their staff and students.

To find out more on how Risetime can provide similar high-quality results to your business, contact us.

 Client Profile

This higher education institution is committed to preparing students to be contributing members of society. The college is committed to teaching both inside and outside the classroom, with curriculum that emphasizes academic inquiry, critical and creative thinking, and recognition of diverse views.


Technology
Microsoft SQL Server – Analysis Services
ProClarity Analytics