The goal of the EDW is to support better, faster, data-informed decision making. Sometimes what you seek is available among the scores of off-the-shelf reports and analytics in the BI Portal. But when it’s not, you can query the data directly in the EDW.

Learn more about the EDW and check out our Case Study

Get access to the data

You need to be authorized via ASTRA with an EDW role to access EDW data. Follow this link to review or update your access.

Request Permission and Access Data

Understand the data

If you’re a query-writer, you know one of the biggest challenges to success is understanding the meaning of the data and how to apply the business rules to get the correct information. These resources can help you get started.

Knowledge Navigator

EDW Data Models

Connect to the data

In order to query EDW data, you need to first connect to it using your UW NetID credentials. The process to connect to EDW data can vary depending on:

• Your computer’s operating system
• The type and version of your query tool
• The network domain in which your computer resides

If you are unable to connect after following our recommended steps, please contact help@uw.edu.

Connect to the EDW