Information Services

The Charge

Current business intelligence tools no longer meet the evolving business needs of the University. Thus, the University has decided to move from the current data warehouse solution to Ellucian software products ODS (Operational Data Store) and EDW (Enterprise Data Warehouse). In addition, Cognos, an IBM reporting tool, will be installed and implemented. BRM (Banner Relationship Management), RAP (Recruiting and Admissions Performance) and SRP (Student Retention Performance) will also be implemented.

Ultimately, Information Services shall implement the new products to ensure our customers have access to consistent, timely data for analysis and reporting. The existing Data Warehouse solution will continue to be supported for the next several years until the transition is complete.

Alignments With the OSU Strategic Plan

• RAP & SRP will assist with target goals of increasing First-Year Rentention and Six Year graduation rate by identifying students not meeting their goals
• RAP & SRP will assist with target goals of recruiting high achieving students and minority students by identifying and targeting these studen ts for recruitment
• ODS/EDW/Cognos will assist with improving the information infrastructure to support the University

The Process

Project managers and developers began by gathering requirements from stakeholders. Requirements gathering for Student & Financial Aid are completed. Requirements gathering continues for Finance (to be completed early 2013) and HR (to be completed Spring 2013).

Next Steps

• Report authors will receive in-house training (by invitation only) as follows:
  • Student & Financial Aid modules, training between October and December, 2012
  • Finance & HR modules, training between January and May, 2013
• Query Authors and Report Consumers will receive in-house training (by invitation only) as follows:
  • Student & Financial Aid modules, training between January and March, 2013
  • Finance & HR modules, training later in 2013
• A preview of the ODS metadata can be viewed at adminfo.ucsadm.oregonstate.edu:8872/metadata/ODS_index.html

Steering Committee

Information Services shall ensure that a broad array of stakeholders across our many colleges and campuses shall be represented by the Steering Committee. A complete list of members shall be published when the committee makeup has been determined.