IT Connect

Information technology tools and resources at the UW

Archive for category: Business Intelligence

Tuition Dashboards on Public UW Website

On August 14, 2018, the Enterprise Information, Integration and Analytics (EIIA) Business Intelligence (BI) Team released the Office of Planning and Budgeting (OPB) Public Profile Tuition Dashboards for current and prospective undergraduate and graduate students! This work was completed in partnership with OPB.

It’s now easier than ever for potential and current undergraduates and graduates to see their University of Washington (UW) quarterly or annual education costs. It also provides UW analysts with an easy-to-use tool for tracking tuition changes over time.

The value we delivered supports the UW-IT Strategic Pillars:

  • Advance the Data-Driven Environment:
    • Delivered UW department coordinators and analysts a dashboard to see tuition changes over time.
    • Introduced new tools for helping UW make data-informed decisions.
    • Provided tools to help current and prospective UW students make choices about their UW education.
  • Create Capacity
    • Provided campus users with a public resource to help answer questions.
    • Centralized data into a single location for accuracy, consistency, and transparency

For more information, please email help@uw.edu.

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).

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.

EIIA team contributes to EDUCAUSE business intelligence guidance

The Enterprise Information, Integration & Analytics team helped develop content for the EDUCAUSE Review’s “Running a BI Shop” series of four how-to papers on creating business intelligence (BI) programs at higher education institutions. Anja Canfield-Budde, Interim Associate Vice President for Information Management, coauthored the articles along with a fellow BI expert at Purdue University. The articles compare BI planning efforts at Purdue University and the UW, revealing common themes: the value of framing the discussion, obtaining broad stakeholder input, and producing a simple, easily communicated strategy. Aimed at new and seasoned BI professionals, the articles are focused on the following:

  1. Strategic Planning
  2. Building the Organization
  3. Managing the Work
  4. Marketing Your Products