Decision Support

Alerts

RSS Feed

No system alerts at this time.

Events

News

EDW Data is Moving
The Enterprise Data Warehouse data and cubes are moving in August
Learn more... (07/18/2014)

EDW's Academic Data Store (UWSDBDataStore) Reorg on Aug 9
UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg.
Learn more... (07/15/2014)

BI Portal Now Includes Visualizations
BI Portal now positioned to be your one stop business intelligence catalog
Learn more... (6/27/2014)

Tableau for Macs released
Tableau now available for Macs
Learn more... (6/23/2014)

UW featured in Wall Street Journal
UW's selection of Tableau reported in the Wall Street Journal
Learn more... (6/12/2014)

EDW's Academic Data Store (UWSDBDataStore) Reorg on May 3
UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg.
Learn more... (04/15/2014)

New STEM and High Demand Data Available
New data helps UW track and deliver STEM and high demand programs
Learn more... (03/28/2014)

EDW's Academic Data Store (UWSDBDataStore) Reorg on Feb 1
UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg.
Learn more... (01/22/2014)

EDA Staffers Presenting at Tableau Conference
Tableau's Speaker Spotlight features Ann Wunderlin and Bart Pietrzak
Learn more... (1/9/2014)

Other Recent Headlines

The Decision Support Web site provides a single point of access to information for users and developers of Enterprise Data Warehouse (EDW) data and tools. It addresses questions about access, database connections, report writing and deployment, query writing, available data, and more. Here you will find answers, with self-service access to a centralized set of data and tools, standards and best practices, to help ensure consistent use of institutional data across multiple functional areas and units.

Tableau Data Visualization

Tableau Software is the data visualization platform chosen for use with UW Enterprise Data Warehouse data, following a multi-month pilot in partnership with 20 academic and administrative units. Tableau is used to visualize large data sets and helps simplify their meaning, promote understanding of those data sets, and communicate important concepts and ideas. Valuable information is stored in the University of Washington's growing data repositories and data visualization software is used to clearly convey that information using images, providing opportunities for understanding that data and for data-informed decision-making.

Learn more about Tableau at UW

UW Profiles

The Office of Planning and Budgeting and UW Information Technology's Enterprise Data & Analytics worked together to create UW Profiles. Powered by Tableau data visualization software, UW Profiles is a suite of institutional dashboards which provide a dynamic way to easily access, explore and understand basic University data. Access the UW Profiles dashboards through the UW Profiles Portal, the searchable, personalized catalog of dashboards offerings and documentation.

Learn more about UW Profiles

UW Business Intelligence Portal

 

The new, feature-packed Business Intelligence (BI) Portal is now live. This intuitive site connects you to UW Enterprise Data Warehouse central reports and analytics.

 


Star your favorites, see what's trending, get report recommendations, stay abreast of new releases, see the underlying SQL queries, peruse data definitions, read how others are using reports, add your feedback, and more. This guided tour shows you how.


(UW NetID required)


Data Availability Summary

The following chart shows when data was last loaded, how frequently the data is loaded (Load Freq), displayed by Subject Area and Data Component.

EDW Data Availability
Subject Area Data Component Load Freq Last Loaded
Academics Academic Data Store daily 07/26/14 4:33AM
Financial Budget Index daily 07/26/14 10:24PM
GL transactions daily 07/25/14 7:44PM
Financial transactions daily 07/25/14 7:54PM
Financial Activity cube daily 07/25/14 8:05PM
Human Resources Person, Employment, Financial (Projected Distributions) daily 07/25/14 8:50PM
Payment (Actual Distributions), Benefits, Faculty Bio pay calc 07/22/14 1:41AM
Check Register (Payment Verification) pay calc 07/21/14 10:04PM
Institutional Base Salary IBS Projected/Pre-Award daily 07/27/14 12:01AM
IBS UW Actual & Projected pay calc 07/22/14 1:42AM
IBS Actual monthly (day 5) 07/05/14 12:31AM
Master Data Organization daily 07/26/14 10:19PM
Research Administration Data Proposals & Awards daily 07/27/14 4:04AM
Research Awards Cube daily 07/27/14 2:24PM
1