The University of Memphis Data Warehouse

What is a Data Warehouse?

The Data Warehouse is a database designed for analytical and information processing. Data are extracted from our business systems such as Banner, DegreeWorks, etc and loaded into a single integrated information asset. It contains data from system prior to Banner too, such as SIS, HRS, CashNet, etc. The warehouse is a read-only collection of data intended to answer business questions.

Why do we need a Data Warehouse?

A Data Warehouse can:

  • Enable users with better information
  • Improve accessibility to integrated data
  • Enable informed decision-making leading to increased or improved service
  • Improve data quality in the OLTP (On-Line Transaction Processing) systems
  • Improve consistency with data from multiple systems
  • Help identify hidden business opportunities
  • Act as a strategic planning tool

How does the Data Warehouse differ from other University systems?

The Data Warehouse is an On-Line Analytical Processing (OLAP) system that is populated using data from the University's operational systems--also known as an On-Line Transaction Processing (OLTP) systems. An OLAP system provides a means of archiving data gathered over time by OLTP systems, and then analyzing that data for trends. OLAP and OLTP can be compared in the following ways:

OLTP OLAP
Data is updated Data is read-only
Uncontrolled redundancy Managed redundancy
Current data Historical and current data
Repetitive processing "What if" processing
Limited history Trends over time
Response in seconds Response in minutes

What data is contained in the Data Warehouse?

Data contained in the Data Warehouse is organized by subject area.  Currently, there are student, course, ACT, employee, financial aid, advancement, finance and person subject areas.

How frequently is the Data Warehouse updated?

Every weekday-campus users determine how frequently the Data Warehouse is updated, based on their information needs and the confines of the systems that run the University's daily business.

Who may access the Data Warehouse?

After completing a short training course, University of Memphis faculty or staff members may access information stored in the Data Warehouse, based on individual need.  There are two types of users.  The first type are power users who are proficient in SQL and query building.  This type of users will build data blocks in Argos.  The second type of users can build reports off of these data blocks or simply consume reports.  Majority of users fall in this second category.  Both types of users will need to understand the data they are dealing with.

How do I access the Data Warehouse?

The Data Warehouse can be accessed from your desktop through a web-based application. The data can also be exported into data formats such as csv or pdf files.

How do I receive more information?

For more information, send e-mail to dw@memphis.edu.