Team # 893 -- Liberal Arts Data Warehouse Queries Process Improvement Team
College of the Liberal Arts

November 2009


To determine how much time is spent querying the Data Warehouse across the college and how this data is used. Our goal is to determine if greater efficiencies can be gained and used to relieve overall workloads.

Team Membership

  • Vicki Blazer, Leader
  • Tanya Hockman, Member
  • Erin Murtha, Member
  • Robin Robinson, Member
  • Sandy Wingard, Member

Results Achieved to Date

  • August 3, 2010

    Objective: Our team is looking at ways to improve the processes used by staff in the college to run Data Warehouse queries. Our goal was to find a way to simplify the query process by possibly coming up with pre-written queries for reports that are done frequently across all departments. Our secondary goal was to write a training manual that would help employees to understand the ins/outs of the data warehouse.

    ExpectedResults: We are currently in the process of gathering information from all our departments about the reports they need. Once that is complete, we will compile a list of them and then write queries (or gather successful queries from departments) to put in a notebook that will be given to all staff. In addition, at some point, we plan to offer training sessions for Liberal Arts staff.




Office of Planning and Institutional Assessment
The Pennsylvania State University
502 Rider Building
University Park, PA 16802-4819
Phone: (814) 863-8721
Fax: (814) 863-7031

Copyright 2006-2014 The Pennsylvania State University

This publication is available in alternative media upon request

Questions regarding web issues, please contact