Background

Information%20Delivery%20Image

With an historical focus on providing information for decisionā€makers across all viceā€presidential areas and levels of the institution and a strong technical background in report applications development, in 2010 the Office of Institutional Analysis and Planning was given the responsibility for developing the UNLV Data Warehouse and BI tool set. The central presence of both institutional research and data governance functions in the office helps to ensure that there is close collaboration with the academic and business units.


Historical Timeline


Summer 2008: iNtegrate I Implementation Begins

As one of two NSHE pilot institutions, UNLV began the work of implementing PeopleSoft Campus Solutions as its new system of record for student information.


Fall 2009: Fundamental Principles for Data Warehouse

The UNLV Project Lead for Integrate l assembled a Data Warehouse Planning Team representing academic and business areas across campus. The team was charged with developing a set of fundamental principles that would represent the interests of data users, and guide the development of an enterprise data warehouse.


Winter 2010: Data Warehouse Assigned to IAP

In January 2010, UNLV President Smatresk assigned responsibility for both data warehouse and BI development to the Office of Institutional Analysis and Planning.  Possessing a strong technical and analytical skill set, the staff were well-suited to assist in the development of the data definitions and structures.  Experienced as both users and providers of data, the IAP team would make timely access to data a priority in developing the new business intelligence and analytical tools.


Early Spring 2010: IAP Hires ASU Consultant to Conduct Assessment

In February 2010, IAP hired a consultant from ASU to evaluate UNLV's current position with regard to technical tools and staffing, and to assist in establishing short and long-term plans.


Spring and Summer 2010: Initial Data Discovery, Requirements Gathering and Foundational Work

The DW/BI team analyzed the delivered repository and EPM tools, began work on a census snapshot solution to ensure availability of enrollment reports in fall, and worked with functional data stewards to identify required source tables from the student system. We created tables and ETLs to support a custom Enrollment Census data mart, developed a shared metadata collection tool for the data discovery and definition segment of the census project, working with stewards to define strategic informational elements for extraction and eventual listing in a data dictionary. Development work also began to prepare the BI reporting environment.


Fall 2010: Census Snapshot

Go-live for the new PeopleSoft Student System. First data warehouse census snapshot taken on September 10th, with all official reporting requirements met for fall 2010 using a combination of SQL and the BI tool.


Spring 2011

Worked with functional stewards to review and approve data definitions, including lineage mapping,  for the enrollment and admissions marts. Worked with the data stewards and OIT to develop a process of requesting access to the data warehouse reporting environment, and authentication of users through the MyUNLV portal.  Created IAP Web Content to support requests for access, explain the role of BI and data warehousing under the umbrella of Decision Support. Built out OBIEE repository to allow reporting and presentation of data through the BI tool. Delivered pilot training to selected individuals to test.

Late Spring 2011: UNLV Analytics Go-Live

Rolled out the admissions and enrollment data marts and data dictionary. Go-Live training for the UNLV Data Warehouse and UNLV Analytics reporting tool was scheduled for two days in June to provide currently available data to those individuals with and the skills and knowledge to use them. The first training was limited to invited individuals, who were selected based on their job responsibilities, advanced knowledge of student data, and analytical and technical expertise. This group broadly represented both administrative and academic areas, and has continued to inform development of the UNLV Data Warehouse.


Information on more recent activities, current projects and upcoming plans is provided on our Projects page.