IT Connect

Information technology tools and resources at the UW

Tag Archive for: tableau


Helpful New Tool: UW Calendar Lookup

This morning you probably arrived at work and thought to yourself, “what Biennium are we in?” Or maybe you already knew that, but got hung up on the fact that the 2020 FY is in the 2019 Biennium (WHAT!?). You panicked, feverishly googled, got frustrated, lost confidence, and moved on to an easier pursuit, like contemplating infinity.

If you’re thinking, “there’s got to be a better way!” Well, now there is, with a new calendar lookup tool built by Data Architect, Courtney Drake, in Office of Planning and Budgeting (OPB).  It’s using EDW data and is hosted on our Tableau servers. Check it out yourself, and never get confused by the 5 overlapping UW calendars again!

You can find it in a couple of places –

Check Out an Awesome New Tool: Tableau Prep

Are you tired of manually cleaning and preparing datasets before you can begin your data analysis? It’s a rule of thumb among data analysts that 3/4 of any analysis project is spent on sourcing and preparing data. But it doesn’t have to be this way!

A new self-service data preparation toolset from Tableau now makes it easier than ever to connect to, union, join, pivot, and clean your data: Check out Tableau Prep

Use Cases:

If you source all of the data for your solution from the EDW, then this solution may not be right for you.

But if you’re one of the many Tableau users who sources data from the EDW and merges it with local data, or if your analysis is built on a spreadsheet, CSV, or multiple disparate sources, and you spend hours merging spreadsheets, and writing complicated functions to clean and prepare the data, then Tableau Prep may help save you time on your next project!

Learn More:

You can access these online resources to learn more about Tableau Prep:

Get Started:

If you have a Tableau Desktop license distributed and managed by UW-IT, then Tableau Prep is available to you. Here’s what you need to do to get started: 

  1. Confirm that you have a UW-IT managed Tableau Desktop license.
  2. Request a product key. To request your Tableau Prep product key simply write with “Request: Tableau Prep Product Key” in the subject line.
  3. Download the latest version of the software here on Tableau’s site to get started
  4. Install the software and begin prepping your data

Important to Know:

  • You must already have a UW-IT managed Tableau desktop license to use Tableau Prep. If you don’t have a UW-IT managed Tableau desktop license, UW-IT will not be able to provide you with a Tableau Prep license. You can learn more about how to request a Tableau Desktop license here.
  • If you work for UW Medicine or its affiliates and are interested in using Tableau Prep, you should contact UW Medicine IT to learn more.
  • If you are a student and you are interested in using Tableau Prep, you should contact Tableau directly to learn what options are available.

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.

Analyze Your Time Spent In Meetings With Tableau


This video uses familiar Microsoft Outlook calendar data as the basis for learning how to analyze data using Tableau. Tableau makes it easy to create visualizations and provides a powerful way to analyze data. Every analyst, accidental or otherwise, will benefit from this tool.

You’ll learn how to export your Microsoft Outlook calendar to a CSV file, open the CSV file in Tableau and massage the data, and analyze your data using a Tableau visualizations.



Read more

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

New Tableau License and Maintenance Fees Mean Lower Total Cost of Ownership

Negotiations on rates for Tableau Desktop licenses and monthly maintenance fees recently concluded and we are pleased to share the total cost of ownership has gone down. The new rates are:

  • New Tableau Desktop license – $1,167 (was $900)
  • Ongoing Tableau monthly maintenance – $33 (includes Tableau support, software upgrades, and online publishing to UW’s Tableau Server; was $44.10)

For those who already own a Tableau Desktop license (which includes upgrades), the only impact to your department’s budget is lower monthly maintenance fees.

For those considering purchasing a license, note that the cost to purchase a new Tableau Desktop license has gone up. However, because the monthly maintenance fee has gone down, the purchase cost difference is recouped in 2 years and the overall cost of ownership is lower because of the maintenance fee reduction.

The new rates took effect July 1, 2015. Learn more about UW’s Tableau licensing and Tableau User Group.

Contact with questions.

Free Tableau and Excel Workshops From UW-IT

We have added several free UW-IT workshops! Our workshops teach UW staff and faculty how to visualize their data using Tableau software and do drag and drop analysis using Microsoft Excel PivotTables. Sessions last from one to three hours and no programming skills are required. Learn more and register online for upcoming sessions on the UW Data & Analytics website.