The new dimensional data warehouse was launched June 2, 2014.  The WOU model uses the Kimball approach to modeling.  The current warehouse contains data from Finance, Student and Human Resources.  Both canned reports and ad-hoc query capability are available.  The data is refreshed on a nightly basis.

The model was developed using a product called Oracle ODI.  ODI is the same tool that is used to perform the nightly data refresh.  Historical data is preserved during the refresh process.  The modeled data is then transformed into a business friendly format utilizing Cognos Framework Manager.  Cognos Connection is the web-based end-user reporting tool.

The warehouse team includes:

• Richard Kavanagh — Kimball modeling expert
• Shea Hawes — SIS expert
• Nick Miller — FIS/HR expert
• Max Chartier — Reports guru
• Jared Petersen — Reports, web docs, etc.  (student employee, honors student)
• Michael Ellis — Project development

For access to the data warehouse contact datasecurity@wou.edu

Data warehouse resources can be found here.

Available warehouse reports can be found here.

The warehouse can be found here.