IT Connect

Information technology tools and resources at the UW

Tag Archive for: new release

Posts

Share your data visualizations via the new UW Tableau Public Server

Now you can share your data visualization dashboards with colleagues anywhere in the world, with the new UW Tableau Public Server. Hosted by UW-IT, the server keeps your data safe and secure; viewers interact with your dashboard but do not download it or the data behind it, and a UW NetID is not required for access. Now it is easy to share UW information, research data and analyses with peer and other institutions as well as the media. Learn more.

New Peer Dashboards Now Available

Ever wonder how the University of Washington measures up against other similar schools? Using the eleven Peer dashboards on the UW Profiles website, you can now see for yourself. Four dashboards focus on student measures (graduation, retention, enrollment, and awards) and seven dashboards focus on finance data (expenses, revenue and endowment). Among the newest dashboards, Expenses Story leads the reader through a step-by-step analysis that compares shares of expenditures between research and instruction, while Revenue Total Breakdown compares per FTE tuition revenue with other revenue sources.

Data for these dashboards come from the federal Integrated Postsecondary Education Data System (IPEDS) Data Center, a publicly-available repository of self-reported institutional data for US colleges and universities. These dashboards, built in partnership by the Office of Planning & Budgeting’s Institutional Analysis team and UW-IT’s Enterprise Information, Integration & Analytics unit, are the latest additions to the growing suite of UW Profiles interactive dashboards.

Explore all peer comparison dashboards in the UW Profiles Portal. Insights are just a few clicks away.

  Graduation Rates
The Graduation Rate dashboard displays 4-, 5-, and 6-year graduation rates for institutions that are part of one of the University of Washington’s peer groups.
Retention Rates
The Retention Rate dashboard displays one-year retention rates for institutions that are part of one of the University of Washington’s peer groups.
Fall Enrollment
The Fall Enrollment dashboard displays total student enrollment, as of the official fall reporting date, at institutions that are part of one of the University of Washington’s peer groups.
Awards Granted and Completers
The Awards Granted dashboard displays the total number of degrees or certificates granted in the latest available academic year by institutions that are part of one of the University of Washington’s peer groups. The Completers dashboard displays the total number of students earning degrees or certificates in the latest available academic year at institutions that are part of one of the University of Washington’s peer groups.
Expenses Story
The Expenses Story dashboards explore multiple ways to visualize and compare expense data.
Expenses by Category
The Expenses by Category dashboard displays expenses per student full-time equivalent (FTE).
Modified Expenses by Category
The Modified Expenses by Category dashboard displays expenses per student full-time equivalent (FTE).
Revenue by Category
The Revenue by Category dashboard displays revenue per student full-time equivalent (FTE).
Revenue Total Breakdown
The Revenue Total Breakdown dashboard displays total tuition revenue and state and local appropriations per student full-time equivalent (FTE).
Revenue Percent Breakdown
The Revenue Percent Breakdown dashboard displays the relative contribution of tuition revenue and state and local appropriations as sources of institutional revenue.
Endowment Values
The Endowment Values dashboard displays the total values of institutions’ endowments at the beginning and at the end of the most recent fiscal year.

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.

UW Profiles Underlying Data Now Available

UW Profiles data visualizations (http://uwprofiles.uw.edu) have greatly enhanced how the University can use data to understand key metrics about students. We are pleased to announce that the data used to create these dashboards is now available for download.

Anyone with Tableau software and access to student data in the Enterprise Data Warehouse can download these data files to craft customized visualizations meaningful to their constituents, using the same UW Profiles data. Detailed definitions and source information are available for each of the four data models (Degrees, Graduation/Retention, Student Credit Hours, and Student).  Visit the Data Models tab (https://uwprofiles.uw.edu/#tab2) in the Portal to get started.

This joint effort between the Office of Planning & Budgeting and Enterprise Data & Analytics represents the 3rd major release of UW Profiles. In the pipeline are dashboards using research administration data, expected to release later this summer.

See the UW Profiles help page for more information and please send questions to uwprofiles@uw.edu.

Handy reference links:

Public Version of UW Profiles Now Available

Interactive UW data dashboards enable prospective students, higher education institutions and the general public to explore UW enrollment and degree trends, and undergraduate graduation and retention rates. Called Public Profiles, it was developed by the Office of Planning & Budgeting and was released this summer. More extensive UW data dashboards, UW Profiles, have been available to the UW community since fall 2013.

Tableau Data Visualization Software Now Available for the Mac

Tableau 8.2, released June 19, is the first version of this easy-to-use data analysis visualization tool to run natively on the Mac. It provides faster loading and new map designs and supports high resolution images, letting you display large data sets and communicate information in a powerful way. License agreements make Tableau products available at reduced or no cost to full-time UW students, as well as faculty and staff.

New STEM and High Demand Data Resource Released

UW-IT, in partnership with the Office of Planning & Budgeting and the Office of the Registrar, is pleased to announce that a new data resource for Classification of Instructional Programming (CIP) has been released.

This new data table will allow you to compare the UW with other institutions in the delivery of science, technology, engineering and math (STEM) and high demand programs.

For the first time, you will be able to classify your curriculum and majors by Federal or State STEM, National Science Foundation STEM, and Washington State high demand programs via a consistent, centrally available data source.

Detailed information about this data and how it helps UW is available on the newly introduced Enterprise Data & Analytics Knowledge Base.