UNLV Data Warehousing - Fundamental Principles


The following principles were developed by the UNLV Data Warehouse Implementation Team and approved by the UNLV iNtegrate Steering Committee in 2009.


1. Data Integrity

The UNLV Data Warehouse consists of one official, comprehensive, centralized data repository providing information consistency and integration through a single, commonly defined view of institutional data.

2. Operational Effectiveness

The UNLV Data Warehouse forms the basis for executive planning and decision-making, as well as operational reporting at the enterprise level. As data are needed to support these functions, they are incorporated and optimized in the institutional warehouse.

3. Access

Data in the UNLV Data Warehouse are accessible to any UNLV employee that needs them to perform the duties of their position. Documentation, interpretation, security and training are all strategies used at UNLV to enable access among a broad range of employees.

4. User Friendliness

The development, selection, and deployment of Data Warehouse querying tools, reporting tools, and custom applications will promote usability by a wide variety of campus users of varying skill-levels.

5. Implementation and Operational Efficiency

To meet the needs of the institution as early as possible and to minimize project costs, the UNLV Data Warehouse will be straightforward and efficient to implement. Once implemented it will be easy to support, facilitate rapid responses to business change requests and exceptions, and incur moderate support costs over the life of the data warehouse.

6. Institutional Consensus

Consistent with these principles, UNLV recognizes the fundamental roles of user input and collaborative stewardship among the following roles:

a. Institutional Warehouse Stewardship: Steward(s) of the UNLV Data Warehouse is (are) responsible for the logical design of the warehouse, assessing which data are included, and for achieving data quality through coordination among operational stewards, technical stewards, and the Data Governance Council.  The Institutional Steward(s) structure data appropriately for querying, reporting, and analysis through the development and management of warehouse ETL (extract, transform, and load) processes.

b. Technical Warehouse Stewardship: Technical Stewards are responsible for managing and maintaining the UNLV Data Warehouse technical environment, including server administration, software updates, implementing backup and recovery strategies, and optimizing data storage and retrieval.

c. Operational Data Stewardship: Operational Stewards are responsible for providing documentation, training, and timely communication to support the proper interpretation of the data originating in the systems under their charge. They provide their expert opinions on which data should be included in the institutional warehouse and on how to structure warehoused data and build in interpretive value to ensure accessibility to UNLV employees.