IT Connect

Information technology tools and resources at the UW

News

tableau icon

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 […]

ERAReports

Report Update: Student Degree Information

The Report Prioritization Group released two updates to the Student Degree Information Report. This post summarizes those changes. Change Summary: Bug Fix: There was a bug in the report code that was causing valid majors to be excluded from the majors dropdown. This bug has been resolved. First Generation Attributes added: by request two new student […]

Now Available in the EDW: Finance Date Functions

We are proud to announce the release of pre-defined date functions in the EDW. These functions help enterprise data users to easily convert calendar dates, months, and years to UW fiscal calendar objects. These functions are most helpful to developers working on reports and visualizations that use fiscal calendar parameters/variables. Context: In SQL, a function […]

New Features in the 2019.1 Tableau Version

As you may know, we recently upgraded our Tableau server version from 2018.1 to 2019.1. This new version includes several features that we want to summarize here: Mixed content: Tableau has improved the browsing experience by offering a mixed content view.  Workbooks, projects, and data sources within a project are now displayed in a single, […]

sql-server-reporting-services

BI Portal Update: Reporting Services Update Completed

The audience for this message is all BI Portal Report users. On Sunday March 10 the Business Intelligence Team and UW-IT Windows Engineering team completed the update and testing of our reporting software. After the update, reports have a new look and feel, but there are no changes to the report parameters or the underlying data […]

sql-server-reporting-services

BI Portal Software Update: Reporting Services

The audience for this message is all BI Portal Report users. In the coming days, the Business Intelligence Team will update our reporting software version. After the update, reports will have a new look and feel, but there will be no changes to the report parameters or the underlying data that you use to do […]

New Release: Helping Users Find Their EDW Authorizers

We are proud to announce the release of a new solution that helps enterprise data users find their ASTRA authorizers, to request access, and begin querying and analyzing UW enterprise data. Background: Enterprise data users need permission to access reports and visualizations on the BI Portal, UW Profiles, or to directly query the Enterprise Data […]

Report Update: Student Degree Information

The Report Prioritization Group released a small update to the Student Degree Information Report. This post summarizes those changes. Change Summary: Based on user feedback, we added 2 new data elements to the report: Student Visa Type External Email (A Student’s non-UW email) To include these columns in the report, simply select them from the “columns to display” […]

Report Update: SEVIS Immigration Reporting

The Report Prioritization Group released important updates to the SEVIS Immigration Reporting Report. This post summarizes those changes. Change Summary: Based on user feedback, we made the following changes: Bug Fixes: Fixed a formatting error on CIP codes Fixed erroneous values that were displaying in the CSV export Fixed an error that was causing pending […]