IT Connect

Information technology tools and resources at the UW

Archive for month: July, 2015

Explore New Dashboards for UW Research Awards and Proposals

Two new dashboards make it as simple as clicking a mouse to explore information on UW research awards and proposals at an overall summary or individual unit level and answer questions like:

  • From year to year, what’s the change in proposal dollars for my college?
  • Are industry grants in my department going up over time? How do foreign grants compare to domestic?
  • How many awards did my college receive this year, and how does that compare to five years ago?
  • Who were the top 10 funding entities for my department’s award dollars in Fiscal Year 2015?

Many more questions can now easily be answered by using the Research Awards and Research Proposals data dashboards, which are the latest additions to the suite of UW Profiles dashboards, produced in partnership with the Office of Research Information Systems (ORIS) and UW-IT’s Enterprise Data & Analytics (EDA) team.

With these data dashboards, there are now three types of research data exploration tools available to the UW community. Each of the three tools serve specific purposes and audiences:

These tools are available to faculty and staff, through access to the Enterprise Data Warehouse. The EDA team also offers a two-hour, hands-on Handling Data 101 class to help people get started using reports and cubes, using the research cube and reports as example data.

Please send questions to help@uw.edu.

Research Data Cube Updated

The Research Administration Data (RAD) cube was recently updated to reflect changes in the SAGE database, and to support the upcoming release of research awards and proposals dashboards. The following is a list of those changes.

  • Change to values in dimDate
    • The date dimension used to display dates outside of the range of dates that contained transactions. As a result of this update, you won’t see a list of dates prior to the earliest transaction or later than the most recent transaction
  • Attribute name change
    • Funding Entity Category Description was shortened to Funding Entity Category in the Sponsor and Originating Sponsor dimensions, so it fits into the soon-to-be-released UW Profiles Research dashboards
  • Dropped Attributes
    • Funding Purpose – Dropped from the Research Funding Action dimension
    • Proposal Funding Purpose – Dropped from the Research Proposal dimension
  • Added Attributes
    • AwardSponsoredProgramActivityTypeDescription - Added to the Research Funding Action dimension
    • ProposalSponsoredProgramActivityType – Added to the Research Proposal dimension

Key Benefit

Historically, Awards and Proposals have had different, but related Funding Purpose fields (also known as Type of Award).  These fields were used to determine Facility & Administrative (F&A) rates, as well as in reporting to the Federal Government.  To streamline the Research Administration process, these two different fields were revised in unison, and have been harmonized, such that the values available in both are identical.  This new field is now known as the ‘Sponsored Program Activity Type’, and it will be replacing the deprecated Funding Purpose fields in the RAD Cube.  A comprehensive back-fill mapping has been developed, in partnership with Office of Sponsored Programs and Grand and Contract Accounting, so this new field will contain values for old Proposals and Awards, based on all available information from those eGC1s and FAs and the relationships between the two.

2015 Biennium Crossover and EDW Data, Reports & Cubes

On July 1, the University of Washington entered the 2015 biennium. With this came updates Enterprise Data Warehouse (EDW) data, and BI Portal reports and cubes.

Data and Reports

In the data, references to ‘CurrentBiennium’ will now draw from the 2015 biennium data. Likewise in reports, you will now see 2015 as a biennium selection option.

Cubes

The Financial Activity 2015 Biennium was released this week. The EDW now supports financial cubes for 5 biennia, going back to 2007. The 2013 Biennium cube will continue to refresh until August 10, 2015, then will be frozen.

Visit the Business Intelligence Portal to learn more about these and other available cubes. And check out our Handling Data 101 workshop to learn how easy it is to get started slicing, dicing, and charting your data to build comparisons and spot trends. All University faculty and staff are welcome to participate – visit our Workshops page to learn more. If you want to get started now, visit the Analyze Data Using Cubes page.