IT Connect

Information technology tools and resources at the UW

Archive for category: New Release

Release of new data resource

Inflation Adjustments Available for Data Analysts

Answer these questions:

Do you…

  • present nominal dollar values over time?
  • want to add inflation-adjusted values in your analysis?

We have some exciting news! Query the Enterprise Data Warehouse (EDW) to include inflation adjustment values in your analysis project.

Get It in the EDW

If you already have access to the EDW, find the CPI data stored in the sec.dimConsumerPriceIndex view in the FinancialSumMart Database.

See Examples:

See inflation adjustment examples in our research expenditure dashboards in UW Profiles:

  1. Overview of Research Total Expenditures
  2. Summary of Research Total Expenditures by Funding Entities

How It Works

Every month the EDW Team pulls consumer price index (CPI) data from the Bureau of Labor Statistics giving you access to this data through EDW queries. We use CPI to adjust nominal expense data for inflation.

The Math Behind It All

For an annual (fiscal year) analysis:

  1. Annual Average: Adjust a nominal value for inflation by first taking the average of each of the CPI values for each month in the Fiscal Year.
  2. Inflation Adjustment: Divide the CPI average for the period the transaction occurred (e.g. 2010) by the CPI value for the current time (e.g. 2018).

EDW Access

If you don’t already have access to the EDW, then you can request access here. If you have any questions please don’t hesitate to write us at help@uw.edu.

Inflation Adjustments Available in UW Profiles

In UW Profiles, under the Research category, run analysis on both inflation and non-inflation adjusted expenditure data.

UW Profiles Examples:

Using UW Profiles, you can click on the “Research Dashboards” tab (on the right) and see the dashboards.

  1. Overview of Research Total Expenditures
  2. Summary of Research Total Expenditures by Funding Entities

What does this mean?

Inflation means the price for goods and services are going up. “Inflation adjusted” is sometimes referred to as “real expenses.” “Non-inflation adjusted” is sometimes referred to as “nominal expenses.” So when you see “inflation adjusted” or “non-inflation adjusted” you know that either inflation has or has not been applied to the data.

The way inflation is applied to the data is by including Consumer Price Index (CPI) data. The CPI measures the change in prices of a predetermined “market basket” of goods and services over time.

Why is this important?

By looking at data over time that includes inflation, you are able to compare with accuracy. By not including inflation adjustments, the data skews making trends appear when they are not real.

Where does this data come from?

The expenditure data is sourced from multiple areas on campus which end up in the EDWPresentation database. The CPI data is from the Bureau of Labor Statistics.

Example – How CPI is calculated

For an annual (fiscal year) analysis:

  1. Annual Average: Adjust a nominal value for inflation by first taking the average of each of the CPI values for each month in the Fiscal Year.
  2. Inflation Adjustment: Divide the CPI average for the period the transaction occurred (e.g. 2010) by the CPI value for the current time (e.g. 2018).

Public Profiles – New Interactive Dashboards Now Available!

In May 2018, in collaboration with the Office of Planning and Budgeting (OPB), we assisted in the relaunched of Public Profiles, which are now five interactive dashboards including:

  1. FTE Enrollment Trends
  2. Headcount Enrollment Trends
  3. Degrees Production Trends
  4. Undergraduate Graduation Rates
  5. Undergraduate Retention and Persistence

All dashboards, except Degrees Production Trends (which is refreshed every August), are refreshed with new data every academic quarter after census day. The data is sourced from the University of Washington’s Enterprise Data Warehouse (EDW). The numbers presented in all dashboards have been approved by OPB and reconcile against internal institutional dashboards – UW Profiles (requires access to EDW).

These dashboards act as the University of Washington’s “Institutional Fact Book.”  Anyone with the access to the internet can view these dashboards using their preferred browser. Explore the dashboards: http://opb.washington.edu/uw-profiles-information

Please contact uwprofiles@uw.edu with any questions or for help using these dashboards.

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.

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.

New UW Profiles Release – Peer Dashboards and Global Filtering

Did you know the University of Washington ranks 1st in Biochemistry degrees conferred among the top 25 US News and World Reports-ranked public universities? That’s just one of many facts you can discover using new dashboards in UW Profiles. Four new Peer Dashboards show how UW compares with national cohorts, all US public and private institutions, Research 1 institutions, and more. In addition to degree information, you can also compare UW’s graduation, retention and enrollment rates with institutions across the country.

Carol Diem, Director of Institutional Research, shared, “Most universities employ peer comparisons to understand size and scope and performance relative to peer institutions. These dashboards allow the user to do just that.”

The Peer Dashboards are the latest addition to the suite of interactive dashboards available at the award-winning UW Profiles Portal. This joint effort between the Office of Planning & Budgeting and Enterprise Data & Analytics represents the fourth major release of UW Profiles.

This release also introduces new functionality—the ability to apply global unit (campus, college, department) and academic quarter filter selections across all academic dashboards. The dashboards will render faster and display the data you want to see, by default. Learn more in the Global Filters section of the User Guide.

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

New higher ed IT resources available to UW community

A new subscription to the Education Advisory Board (EAB) IT Forum is offering higher education-specific information technology resources to UW students, faculty and staff. For no individual charge, users with a UW NetID can access the service for white papers, webinars, peer articles and other research resources, as well as for in-person consultation, in topic areas such as data governance, measures and metrics, analytics, and student success.

“EAB is an excellent resource, with a long history of specializing in IT for higher education,” said Anja Canfield-Budde, Director of Enterprise Data & Analytics (EDA). “With their deep expertise, we don’t have to reinvent the wheel to solve institutional IT challenges. I wholeheartedly recommend their resources.”

The EAB is made up of 650-plus researchers, consultants and technologists, serving over 1,000 colleges and universities across North America. Earlier this year, UW-IT data leaders provided input to EAB on the paper, A Common Currency: Achieving Excellence in Data Governance and Adoption of Analytics. Read the paper (PDF) on the UW-IT intranet.

“As we continue to grow our ‘data culture’ at the University, we can rely on EAB for expert advice and collaboration opportunities,” said Canfield-Budde.

Learn more:

Activate your user account:

  • Account setup uses your UW email address. Get started by going to the EAB website and choosing “Log in now,” then choose “I’m a new user.” Follow the prompts to complete your log-in setup. Once you receive an email from EAB, navigate to “Services,” then “Research & Insights” and then “IT Forum.”