IT Connect

Information technology tools and resources at the UW

Archive for year: 2017

Enterprise Integration Platform facilitates use of data by UW applications

With Workday, the UW now has access to a rich array of human resources and payroll data not previously available — a significant institutional improvement for data-driven decision making. But the UW faced a major challenge in ensuring that data derived from Workday could integrate with less flexible, older University administrative systems that still must also consume data directly from the UW mainframe. That’s where UW-IT’s Enterprise Integration Platform (EIP) comes in.

Created by members of Enterprise Information, Integration & Analytics (EIIA), the EIP functions as a data hub able to consume data from newer source systems like Workday, apply business rules to make the data consistent, and deliver it efficiently to those existing “downstream” UW applications.

“In a nutshell, the EIP acts to insulate source systems and consuming systems from one another so that data changes or increases in load on one system won’t adversely affect the other,” said Paul Schurr, EIIA Integration Architect.

Besides Workday for HR and Payroll, other new systems with their own data sources will be adopted at the UW, such as for the UW Finance Transformation Program. “These future applications also will take advantage of the EIP in its role to ensure information for the University is timely, accurate, clear, secure and consistent so that applications and their users can make informed decisions,” said Schurr.

The EIP and the partnership between its team and the Integrated Service Center (ISC) have helped ensure a level of data quality that UW customers can rely on.

Each nightmore than 1,000 data quality tests run against Workday data, and alert the EIP team if there are issues,” said Schurr. “Sometimes, we discover data entry violates an existing business rule in an application — such as when users incorrectly enter foreign characters and hyphens into Workday that the older systems can’t accept.”

If a data issue or break occurs, the EIP and ISC teams quickly work together to resolve the problem.

“The collaboration with EIP has been invaluable, and we look forward to more of it as we continue to work toward Workday stabilization,” said Josh Levine, ISC Application Manager.

In addition, data experts from the EIP, ISC, UW Human Resources, Academic Human Resources, Payroll, Benefits, and others meet regularly to discuss data issues, impacts, rule definitions, data corrections and training improvements.

“Overall, the EIP is a central component of an enterprise data integration strategy and framework for the University,” said Anja Canfield-Budde, Associate Vice President for Information Management.

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.