• GETTING SUPPORT
  • Policies and Procedures
    • BACK
      • Acceptable Use of University Computing Resources Policy
      • Banner FIS-HRIS-SIS
      • File Sharing Information
      • Pawprint Accounts
      • Secondary Email Account Agreement
      • From
      • WOU Account Lifecycle Policy
  • Data Warehouse
    • BACK
      • WOU Enterprise Data Warehouse
      • Cognos Reporting
  • Solutions
    • BACK
      • Classrooms/Computer Labs
      • Classroom equipment
      • Audio-Visual Equipment Charges
      • Classroom equipment reservation form
      • Customer Services and Support
      • Computer Labs
      • Google Workspace for Education
      • General features
      • Google Apps FAQs
      • Tips & Tricks
      • Resources
      • Banner Cloud FAQ
      • Cybersecurity
      • Infrastructure Statistics
      • Other FAQs
      • Request Secondary Email
      • Resource List
      • Technology Support Center
      • Request Computer Replacement
      • Tutorials
      • University Technology Advisory Committee
      • WouTV – Digital Production Services
      • Document Management
      • About Document Management
      • Document Management Project Request
      • DocStar User Access Request Form
      • DocStar How-To
      • Purchasing
      • Educational Discounts
      • Purchase Request System
      • Unified Communications
      • Unified Communications
      • Audio Conferencing
      • Webinars
      • Desktop Videoconferencing
      • Room Videoconferencing
      • Zoom at Western Oregon University
      • Remote Access
      • Information on working remotely
  • People
    • BACK
      • List of people in the department

  • Portal
  • Academics
  • Current Students
  • Employees
  • Give
  • Maps
  • Admission:
    • BACK
    • Admission
    • Apply
    • Get Info
    • Visit Us
Western Oregon University
search
  • Admission
  • Cost
  • Academics
  • Life at WOU
  • Athletics
  • Give
  • Portal
  • search

University Computing Solutions

Home » Data Warehouse

Menu
  • GETTING SUPPORT
  • Policies and Procedures
    • Back
      • Acceptable Use of University Computing Resources Policy
      • Banner FIS-HRIS-SIS
      • File Sharing Information
      • Pawprint Accounts
      • Secondary Email Account Agreement
      • From
      • WOU Account Lifecycle Policy
  • Data Warehouse
    • Back
      • WOU Enterprise Data Warehouse
      • Cognos Reporting
  • Solutions
    • Back
      • Classrooms/Computer Labs
      • Classroom equipment
      • Audio-Visual Equipment Charges
      • Classroom equipment reservation form
      • Customer Services and Support
      • Computer Labs
      • Google Workspace for Education
      • General features
      • Google Apps FAQs
      • Tips & Tricks
      • Resources
      • Banner Cloud FAQ
      • Cybersecurity
      • Infrastructure Statistics
      • Other FAQs
      • Request Secondary Email
      • Resource List
      • Technology Support Center
      • Request Computer Replacement
      • Tutorials
      • University Technology Advisory Committee
      • WouTV – Digital Production Services
      • Document Management
      • About Document Management
      • Document Management Project Request
      • DocStar User Access Request Form
      • DocStar How-To
      • Purchasing
      • Educational Discounts
      • Purchase Request System
      • Unified Communications
      • Unified Communications
      • Audio Conferencing
      • Webinars
      • Desktop Videoconferencing
      • Room Videoconferencing
      • Zoom at Western Oregon University
      • Remote Access
      • Information on working remotely
  • People
    • Back
      • List of people in the department

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.

 

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 VIDEOS

Cognos 11 Basic Navigation
Cognos 11 Report Development

 

WAREHOUSE DEVELOPMENT

For new warehouse development, please click below to submit a UCS Project Request.

UCS Project Request

THE TEAM

Bill Kernan

Chief Information Officer, Director of University Computing Services

Michael Ellis

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

Samantha Brubaker

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

Western Oregon University

Facebook   Instagram   X  YouTube

WESTERN OREGON UNIVERSITY
345 Monmouth Ave. N.
Monmouth OR 97361

503-838-8000 | 1-877-877-1593

Tools

Campus Maps
Canvas
Find People
Portal
WOU Email
Technical Support

Resources

A-Z Index
Accessibility
Academic Calendar
Class Schedule
Jobs at WOU
News
Explore WOU
Partnerships
Student Services
Freedom of Expression

Western Oregon University’s Land Acknowledgement
Western Oregon University in Monmouth, OR is located within the traditional homelands of the Luckiamute Band of Kalapuya. Following the Willamette Valley Treaty of 1855 (Kalapuya etc. Treaty), Kalapuya people were forcibly removed to reservations in Western Oregon. Today, living descendants of these people are a part of the Confederated Tribes of Grand Ronde Community of Oregon and the Confederated Tribes of the Siletz Indians.

Accessibility    Public Records    Privacy    Student Consumer Information

WOU prohibits discrimination on the basis of race, color, sex, national or ethnic origin, age, religion, marital status, disability, veteran status, sexual orientation, gender identity, and gender expression in all programs, activities and employment practices as required by Title IX, other applicable laws, and policies. Retaliation is prohibited by WOU.