Document Type

Closed Project

Publication Date

Winter 2017


Mike Freiling & Daniel Sagalowicz

Course Title

Data Warehousing

Course Number

ETM 538


Virtual Vikings is a weekly e- newsletter sent to Portland state university students by the internal office of university Communications every Sunday. The newsletter is published in the fall, winter and spring of each academic school year. It contains information about the recent past week and upcoming week in form of snippets and links .The main aim of the Virtual Viking is to keep students engaged with the campus news, events, achievements etc. This project was done on the data provided by the BI team at PSU which manages the enterprise data warehouse and reporting suite (IBM Cognos) along with the university's budgeting and planning software (IBM Cognos TM1). The enterprise data warehouse consists of data from the university's ERP system Banner along with data brought in from additional campus systems such as the campus CRM Talisma. One of the Key business Goals of the Analytics Department at Portland State University is to engage students in attempts to help them achieve better outcomes. This is done through reporting all sorts of data being collected by the University.


In Copyright. URI: This Item is protected by copyright and/or related rights. You are free to use this Item in any way that is permitted by the copyright and related rights legislation that applies to your use. For other uses you need to obtain permission from the rights-holder(s).


This project is only available to students, staff, and faculty of Portland State University

Persistent Identifier