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.
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).
- Training sessions can be scheduled upon request
Training WORKBOOKS
Cognos Workspace Advanced Manual from IBM | IBM_Cognos_Workspace_Advanced_User_Guide |
Cognos 10 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 10 Workspace Advanced | Cognos Workspace Advanced - Basic Student Report |
How to create a basic Finance report using Cognos 10 Workspace Advanced | Cognos Workspace Advanced - Basic Finance Report |
FERPA Policy for Cognos | FERPA for Cognos |
Training VIDEOS
Cognos 11 Basic Navigation |
Cognos 11 Report Development |
Cognos 10 Basics: General Navigation and how to run reports |
Cognos 10 Workspace Advanced – Basic Student Report Build |
Cognos 10 Tips & Tricks |
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
Warehouse Programmer, Banner Human Resources Expert, Cognos Reports Guru
Alan Phillips
Programmer Analyst, Oracle Database Administrator
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