Western Oregon University

Page Content   Main Menu   Utility Links   Quick Links   Social Links   Footer   What is this view?


WOU Enterprise Data Warehouse

About the Warehouse

WOU’s Enterprise Data Warehouse began in July 2013 when the university’s CIO, Bill Kernan, asked then UCS Operating Systems/Security Analyist Richard Kavanagh to work with him and UCS Assistant Director Michael Ellis on a little project. Kavanagh agreed, so the trio sequestered themselves into the department’s only conference room for several months to develop the university's first data warehouse. After they got the ball rolling, Ellis and Kernan were able to return to their regular duties and the team was expanded to include Nick Miller, Shea Hawes, and Max Chartier.

WOU’s Enterprise Data Warehouse was launched on June 2, 2014. The warehouse currently houses data from Banner Accounts Recievable, Admissions, Finance, HR/Payroll, Registration and General Student with more areas being added regularly. There are over 125 reports available for use in Cognos, with more being created on a regular basis. For a list of some of the reports available in production, please visit our report catalog.

Getting Started

  • To gain access to Cognos and the Data Warehouse, please email datasecurity@wou.edu
  • For those that already have access, you may login to Cognos from the launch button in the Portal (near the Banner icon) or at: https://cognos.wou.edu/warehouse
  • Training sessions can be scheduled upon request

Training WORKBOOKS

Cognos Workspace Advanced Manual from IBM    IBM_Cognos_Workspace_Advanced_User_Guide   
Cognos Basics: General Navigation and how to run reports    Cognos Basics   
Report Scheduling: How to schedule a report to be sent via email on a schedule    Report Scheduling   
How to create a basic Student report using Cognos Workspace Advanced    Cognos Workspace Advanced - Basic Student Report   
How to create a basic Finance report using Cognos Workspace Advanced    Cognos Workspace Advanced - Basic Finance Report   
FERPA Policy for Cognos    FERPA for Cognos   

Training VIDEOS

Cognos Basics: General Navigation and how to run reports   
Cognos Workspace Advanced – Basic Student Report Build   
Cognos Tips & Tricks   

Please contact Max Chartier with any questions or to schedule a one-on-one training session at chartierm@wou.edu or extension 8-8538.

The TEAM

Bill Kernan

Chief Information Officer, Director of University Computing Services

Michael Ellis

Assistant Director of University Computing Services, Team Lead, Oracle Consultant

Richard Kavanagh

Programmer Analyst, Dimensional Model Expert, Kimball Rules Expert, ODI Guru

Nick Miller

Programmer Analyst, Banner Finance & Human Resources Expert, Cognos Framework Manager Guru

Shea Hawes

Programmer Analyst, Banner Student Expert, Student Modeler Guru

Max Chartier

Data Architect, Banner Human Resources Expert, Cognos Reports Guru

Mike Ross (Former Member)

Programmer Analyst, Oracle Database Administrator

Alan Phillips

Programmer Analyst, Oracle Database Administrator

Jared Petersen

Student Programmer and Web Developer, Honors Student


CONTACT US

WOU Enterprise Data Warehouse

Please contact Max Chartier with any questions or to schedule a one-on-one training session at
503-838-8538 | or e-mail: chartierm@wou.edu| Location: ITC 004


Main Links

Utility Links

Quick Links

Social Links

What is this view?

You are using a dynamic assistive view of the Western Oregon University site. It has all the same data and features of the original site but formatted just with assistive users in mind. It has links and content reorganized to aid assistive users and has controls at the bottom under assistive options that allow you to control key aspects such as font size and contrast colors etc.
This is not a separate text-only site, it's a dynamic view that uses unique technology from Usablenet to give assistive users better, more accessible access to the same content and features as all users that use the graphic view of the site.

Assistive Options

Top of page


Assistive Options

Open the original version of this page.

Usablenet Assistive is a Usablenet product. Usablenet Assistive Main Page.