Office of Research

Research Administration Data

Individual on a laptop using the BI Portal Tools to interact with EDW data

Research Administration Data (RAD) is available in a variety of formats on UW's Business Intelligence (BI) Portal. RAD is built using research data captured from UW's System to Administer Grants Electronically (SAGE). SAGE data is exported to the Enterprise Data Warehouse (EDW) and represented by three comprehensive BI Portal reporting tools: Reports, Visualizations and a Cube.

Go To the BI Portal

Why use RAD:

The three tools within the BI Portal allow you to improve the quality of your reports by using actual SAGE data and include additional analysis parameters. Answer questions such as:

  • Which grants during last fiscal year were allocated to our college and by what subdepartment?
  • How do the last three fiscal years compare with respect to grant awards/proposals?
  • Are industry grants in my department going up?
  • How many proposals involve human subjects?
  • Within my department/college, who is submitting proposals and for how much?

RAD Benefits:

  • Look at a cross-cutting view of proposals and awards across departments or within departments.
  • Quickly see trends and outliers in funding and conduct customized analyses.
  • Forecast future funding opportunities based on success factors.

RAD Overview

Three reporting tools offer the following information:

  • BI Portal Reports (see details below)
    • Research Awards
    • Research Proposal Details
    • Research Proposals
    • Research Subawards
  • BI Portal Visualizations (see details below)
    • Summary of Research Award Counts and Amounts
    • Summary of Research Proposal Counts and Amounts
  • BI Portal Cube (see details below)
    • All SAGE research administration data, compiled into a cube, available for analysis and customized report building.

BI Portal Tool Details

Reports

Screen capture of data from the BI Portal RAD Reports

The BI Portal RAD Reports offer ready-to-view, detailed reporting of award status, compliance and eGC1 summaries, including Principal Investigator information. Create customized lists for summaries, then download to perform additional analysis. Learn how to use reports by attending Handling Data 101. Reports will answer questions such as:

  • How many proposals involve human subjects?
  • Within my department/college, who is submitting proposals and for how much?

Visualizations

Screen capture of the BI Portal RAD Visualizations tool showing research data.

The BI Portal RAD Visualizations provide high-level views of department/college research grants. Filter the data to capture the information you need and quickly generate a visual report. Visualizations will answer questions such as:

  • Are industry grants in my department going up?
  • Are there year-over-year award changes in my college/department?

Cube

Screen capture of the BI Portal RAD Cube data in Excel

The BI Portal RAD Cube allows for a deep-dive, drag and drop analysis to answer complex questions regarding sponsor details, department and subdepartment data as well as specific date comparisons. Users who analyze data and are familiar with pivot tables will benefit the most from the Cube. If these concepts are new to you, attend Handling Data 101 to get started. The Cube will answer questions such as:

  • Which grants during last fiscal year were allocated to our college and by what subdepartment?
  • How do the last three fiscal years compare with respect to grant awards/proposals?