Data warehouse work

While the UNI data warehouse has data from nearly all UNI systems and much of this is based on code written by UNI for UNI, the original student warehouse is vended. The student warehouse was purchased along with the original student system. Oracle is discontinuing support for it, and encouraging UNI to move to a newer product. Rather than experience additional cost and effort to implement their new solution, we have chosen to take full ownership of the original system and drop support.  We are over halfway through this effort, and hope to have all development complete by the end the summer of 2018 with implementation to occur before the end of 2018 if not sooner.

While we are converting the foundation of the warehouse, we continue to work to develop new warehouse reporting solutions for the campus community.  In the past year we developed new solutions using maps, financial reports which show trends over multiple  years as well as academic department profiles.

We are working on processing procurement data to so the university can analyze its spending patterns, loading protrav data  for analysis and HR and benefits data as well.

Contact: Kevan Forest

 

Status: 
Archived
Start Date: 
January, 2016
  • ITTC 36
  • (319) 273-5555
  • Service Hub