IT Connect

Information technology tools and resources at the UW

Understand Data

The University’s Enterprise Data Warehouse (EDW) integrates data from many sources across the University into a central repository. The EDW stores current and historical data that are used to support operational reporting and strategic analysis.

The goal of the EDW Program is to support better, faster, data-informed decision making.

UW Data Map - 7 subject areas are Academics, Research, University Advancement, Services and Resources, Financial Resources, Human Resources and Master Data

What happens in the Enterprise Data Warehouse? Data comes from many source systems around UW. In the Enterprise Data Warehouse, that data is organized, integrated and history is saved. We then partner with subject matter experts to produce tools for users of all skill levels.

EDW Components - The Enterprise Data Warehouse is big and growing. 15 server instances managed, 36 databases maintained, 1,700 tables stored, 36,000 columns of data stored, 5,200,000 records stored, 100,000 records added or changed daily, 177,000 lines of code maintained, 11,900 load jobs run in 2012, 5,000 users with EDW access

Data In, Decisions Out

Hundreds of reporting and analysis tools foster better, faster, data-informed decision-making.

Reports

Scores of reports help you do your work, understand your business, and make data-informed decisions.

Cubes

Flexible and powerful data cubes make it possible for everyone to perform analysis.

Data Models

Enterprise Information, Integration & Analytics (EIIA) data models help you understand high level university business process relationships and low level data relationships.  Pictures do tell a thousand words.

Learn more about EDW data models.

EDW model screenshot

Data Definitions and Information

Answering questions with data are not always easy. Especially when there is disagreement across subject areas on the meaning of key terms. Use Knowledge Navigator as your guide to UW data and information.

Learn more about Knowledge Navigator.

Data Security

UW Data Management Committee Structure - The foundation is overall guidance. 4 parts are policy, standards, and guidelines, data authority, trustees and custodians, data access and use, data classification and definitions.

Securing UW’s data is of prime importance. The Data Management Committee works to ensure data assets are secure while making data available to all who need it.

From our patented data security model to its inclusive membership across UW, our governance program is key to creating a single source of institutional data to support University decision-making.

Learn more about governance at UW.