IT Connect

Information technology tools and resources at the UW

Tag Archive for: dashboards

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 Portal Honored

The UW Profiles Portal, the single access point to a set of Web-based dashboards featuring core UW data, has received the business intelligence industry’s most prestigious honor—The Data Warehousing Institute (TDWI) Best Practices Award. The international award recognizes excellence and innovation in developing business intelligence, data warehousing and related data management applications. UW Profiles Portal provides a dynamic way to access, explore and understand core UW data through 21 summary and comparison visual dashboards, as well as a searchable catalog and robust documentation.

Campus Technology Innovators also bestowed honors on the UW Profiles Portal and Dashboards, citing “the University of Washington developed an intuitive, user-friendly portal that provides a single point of access to data and visualizations for faculty and staff.”

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!

UW Course Demand Analytics Now Available

UW colleges and departments can use three new data visualizations in the UW Business Intelligence (BI) portal to understand how many spaces are needed to accommodate the demand for each course, based on Notify.UW data. All academic units are included and information is available for the current quarter—refreshed each weekday at 6:30 a.m.—and for each quarter since winter 2013. To access the Current Course Demand, Current Notify Course Demand or Trends in Course Demand visualizations, you must have access to the Enterprise Data Warehouse and the Tableau Server.

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