IT Connect

Information technology tools and resources at the UW

Tag Archive for: UW Profiles

Posts

Interactive map shows UW’s global engagement, uses Tableau

UW Global EngagementA new interactive global map uses data visualizations to demonstrate the University’s engagement around the world. The online map, hosted on UW-IT’s Tableau server, extracts key datasets from the UW’s Enterprise Data Warehouse (EDW) and displays them in a visual format, available to the public. UW-IT’s Enterprise Information, Integration & Analytics (EIIA) group helped build the architecture that supports the global map, and provided quality assurance, security and data governance.

“This is a collaborative project between UW-IT and the UW Office of Global Affairs (OGA),” said Sudha Sharma, Senior Computer Specialist in OGA. “There were five isolated data sets to start with, and merging them was a challenge, particularly being able to have a common country names list that will work across data from various units. The EIIA team was a great ally as we dealt with all the data issues and brought this map to life.”

An information page about the global map explains its purpose, data sources and how to use it.

Discover UW’s Global Impact with New UW Profiles Dashboards

The measure of the University of Washington’s true worth comes in the impact we have on the world. Our impact is broad and truly global, with projects and partnerships in more than 130 countries and with students and alumni engaged in efforts in nearly 200 countries.

The new Global Engagement dashboards can help UW leaders, faculty and staff better understand the UW’s networks worldwide, and help fuel data-driven decisions and stories about the University’s global reach and impact. As part of the interactive dashboard portal, UW Profiles, these new dashboards illustrate UW’s global footprint in research, study abroad opportunities, and recruiting and graduating international students.

Take a moment to explore the new Global Engagement dashboards, which are the result of a collaboration between the Office of Global Affairs and UW-IT. Access to the Enterprise Data Warehouse is required.

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.

UW Profiles Tour

Description

The UW Profiles suite of interactive dashboards enable users to explore and aggregate basic University data. Learn how to explore all offerings through this informative tour of the UW Profiles Portal.

 

Length:

4:48

Read more

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:

Talk involving UW Profiles wins best presentation at conference

A talk about UW Profiles, the UW’s interactive dashboards for accessing and understanding basic UW data, was honored as “Best Presentation” at the Pacific Northwest Association for Institutional Research and Planning’s annual conference. The talk last month by Nevena Lalic of the Office of Planning & Management’s Institutional Analysis team and Bart Pietrzak of UW-IT’s Enterprise Data & Analytics was selected from among 30 presentations for its especially helpful ‘how to’ content on using Tableau with institutional data and working with the IT organization to structure that data. Pietrzak, a Business Intelligence Architect, and Lalic, a Senior Analyst, are collaborating on a proposal to adapt the presentation, “Exposing Basic Institutional Stats Using Interactive Tableau Dashboards,” for the Association’s national conference in May. UW Profiles was created jointly by UW-IT and the Office of Planning & Budgeting, now a unit within the newly named Planning & Management office.

PNAIRP logo

UW Profiles

Becka Poppe of OPB is finding great success with UW Profiles.

Here is what she has to say about it.

UW Profiles

I use UW Profiles on a regular basis for a variety of projects. It is particularly helpful when I receive requests from the state legislature for information or for fiscal notes (i.e. estimates of how proposed legislation would fiscally impact the UW) as these types of requests typically have very tight turnarounds and require highly specific and accurate data. UW Profiles allows me to retrieve whatever information I need, without having to go through a middleman, which makes a huge difference when time is scarce.

I also use UW Profiles when writing policy briefs, as I often want to cite facts to support my position or analysis of a proposed bill. For example, when writing briefs about affordability and access, I often mention the number of Pell-eligible students in the UW’s undergraduate population and cite relevant trends in underrepresented minority student enrollments.

Lastly, UW Profiles is one of my key data sources when I provide the President’s Office with updates on institutional goals.

The “Export” feature is fantastic as it allows me to download the data and make my own pivot tables. I also really appreciate the new “Switch to Tables” / “Switch to Visualization” feature that lets me toggle back and forth between the two data views.

All in all, I’ve found UW Profiles to be an incredibly valuable tool that helps me do my work more efficiently and effectively.

-Becka Johnson Poppe
Office of Planning & Budgeting

Notes

Her favorite dashboards are:

  • Key Facts – Academics:
    • Enrollment Summary
    • Degree Summary
  • Student Enrollment:
    • Diversity Profile & Trends
  • Student Academic Performance:
    • Undergraduate Retention and Graduation Rates
    • Undergraduate Graduation Patterns and Time to Degree

Summary

Thanks so much Becka for the detailed account of how you find value in the UW Profiles visualizations. If anyone else uses UW Profiles to great affect please tell us about it at help@uw.edu!

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.

UW’s Tableau deployment picked up by the Wall Street Journal

UW’s choice to use Tableau software as its primary data visualization tool, and the development of UW Profiles dashboards for exploring and understanding basic University data was reported in a recent issue of the Wall Street Journal. Tableau is used to easily create interactive graphics, reports and dashboards that allow you to ask questions and see and understand data in meaningful ways. To develop UW Profiles, UW-IT partnered with the Office of Planning and Budgeting. UW Profiles and Tableau also were featured in the November 2013 Special Edition of UW-IT Insights.

Tableau Software logo