Decision Support

End User Access Requests to Run Reports or Perform Ad hoc Queries

There are many pre-built reports that provide access to data in the Enterprise Data Warehouse (EDW).  For a list and description of the reports available please refer to the Decision Support Services web site. 

Users needing to perform ad hoc queries against central data in the Enterprise Data Warehouse must be knowledgeable about the potential impact their queries may have on other users and applications that access the same data.  Users doing ad hoc queries should be experienced in SQL programming and use appropriate query tools and techniques, as documented on the Query Data page of the Decision Support Services Web site.  This includes querying data through the secured views provided in the EDW.     

To request end user access to run these reports or query data please review the instructions below and fill out the request form.

In order to request a role that will permit you to access the Enterprise Data Warehouse (EDW), review the Security Access and Roles Matrix to determine your appropriate role.

For any of the following roles, you can contact the ASTRA authorizer in your department or unit to request access. If you don't know your ASTRA Authorizer, contact the ASTRA team at astra@uw.edu for assistance.

  • Administrator/Manager/Fiscal Tech
  • Administrative Analyst
  • Payroll Coordinator
  • Advisors/Academic Staff
  • Faculty/Principal Investigator

For any of the following centrally authorized roles, please fill in the form provided below:

  • Chancellor/Dean/Dean's Analyst
  • Academic Analyst
  • Institutional Analyst
  • Student Aid Analyst
  • Student Fiscal Analyst
  • Payroll Analyst
  • Academic Personnel/HR Analyst
  • Auditor
  • EDW Administrator

If you need help determining which role is appropriate for your data needs, please email dmc-support@uw.edu.

Request Form:

Your Name:
Your UW NetID:
Your Job Title:
UW E-mail Address:
Access Role:
Your Dept/Unit:
Brief (1-2 sentence)
description of business need and types of reports:
Your Supervisor's Name
and UW NetID: