IT Connect

Information technology tools and resources at the UW

Tag Archive for: data

Posts

2015 Biennium Crossover and EDW Data, Reports & Cubes

On July 1, the University of Washington entered the 2015 biennium. With this came updates Enterprise Data Warehouse (EDW) data, and BI Portal reports and cubes.

Data and Reports

In the data, references to ‘CurrentBiennium’ will now draw from the 2015 biennium data. Likewise in reports, you will now see 2015 as a biennium selection option.

Cubes

The Financial Activity 2015 Biennium was released this week. The EDW now supports financial cubes for 5 biennia, going back to 2007. The 2013 Biennium cube will continue to refresh until August 10, 2015, then will be frozen.

Visit the Business Intelligence Portal to learn more about these and other available cubes. And check out our Handling Data 101 workshop to learn how easy it is to get started slicing, dicing, and charting your data to build comparisons and spot trends. All University faculty and staff are welcome to participate – visit our Workshops page to learn more. If you want to get started now, visit the Analyze Data Using Cubes page.

EDW Data has Moved

Tableau Project Owners are now able to self-manage who has access to your visualizations. Using free UW Active Directory (AD) Groups, you can assign people directly to the publisher, editor and viewer security roles within your Tableau projects.

  • Queries to the Enterprise Data Warehouse (EDW) will be faster and simpler
  • Users will have upgraded SQL databases with new SQL tools
  • A single server location for all EDW data eliminates the need for cross-server joins
  • Geographical redundancy of critical data provides business continuity and disaster preparedness

More information is available in the FAQ.

The EDW technology refresh is part of a wider effort to simplify infrastructure management for UW-IT, as all data and Web servers move into the UW NetID domain. These ongoing enhancements reflect UW-IT’s goal to provide access to excellent infrastructure for the University, as outlined in UW-IT’s 2014 Strategic Investment Plan.

New STEM and High Demand Data Resource Released

UW-IT, in partnership with the Office of Planning & Budgeting and the Office of the Registrar, is pleased to announce that a new data resource for Classification of Instructional Programming (CIP) has been released.

This new data table will allow you to compare the UW with other institutions in the delivery of science, technology, engineering and math (STEM) and high demand programs.

For the first time, you will be able to classify your curriculum and majors by Federal or State STEM, National Science Foundation STEM, and Washington State high demand programs via a consistent, centrally available data source.

Detailed information about this data and how it helps UW is available on the newly introduced Enterprise Data & Analytics Knowledge Base.