IT Connect

Information technology tools and resources at the UW

Videos

Jump start your reporting, analysis, and data querying efforts by watching these informative videos.

Videos

Get Started

BI-Portal-marketing

BI Portal Overview

This overview of the BI Portal illustrates the value it provides over traditional reporting.
BI Portal Video

BI Portal Tour

See how to get the most out of the University’s catalog of business intelligence tools
UW-Profiles-Marketing-Poster

UW Profiles Overview

The UW Profiles suite of dashboards put University data at your fingertips.
Analyze Your Time Spent In Meetings video thumbnail

Analyze Your Time Spent In Meetings (and Learn Pivot Table Skills)

Build your Excel pivot table skills using your own Microsoft Outlook calendar data.

Analysis

vlcsnap-2016-06-01-12h55m59s345

Analyze Your Time Spent In Meetings With Tableau

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.
Analyze Your Time Spent In Meetings video thumbnail

Analyze Your Time Spent In Meetings (and Learn Pivot Table Skills)

Build your Excel pivot table skills using your own Microsoft Outlook calendar data.
Analyze report data

Analyze Report Data

You’ve run your report, now take that data to the next level with these analysis tips
Prepare to connect to EDW

Connect To The EDW Using Your UW NETID

This video details how to set up your computer to connect to the EDW.
Connect Excel to a data cube

Connect Excel to the Research Administration Data Cube

Using Excel’s familiar interface, connect to data cubes to dig into finance and research data
Data cube analysis

Slice and Dice Research Awards Data

Explore Research Administration data using Excel pivot tables and the Research Cube.
excel-mac-edw

Querying the EDW with Excel 2016 for Mac

Connect directly to EDW data from your Mac

Metadata

KN Overivew video image

Knowledge Navigator Overview

Get a quick overview of Knowledge Navigator, UW's metadata repository for Enterprise Data Warehouse data.
smat-tool-tile

SMAT Tool

This video explains what SMAT & DAC are and how data custodians can use the SMAT to keep our data safe.
KN-understand

Understand HR/P Changes in the ODS

A Knowledge Navigator overview of HR/P changes and the ODS
KN-interpret-HRP

Using Knowledge Navigator to Interpret HR/P Changes

Using Knowledge Navigator to Interpret HR/P Changes

Services

EAB Beneifts video

Research IT Solutions Through EAB subscription

EAB subscription provides valuable IT resources to campus