EDW Data has Moved
On August 11, 2014, the Enterprise Data Warehouse data and cubes moved onto more powerful hardware and updated software, and relocated to the NetID domain. This move to the new hardware and Microsoft SQL Server 2012 platform means:
- 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 EDW Tech Refresh 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.
Posted 7/18/2014, updated 8/11/2014
EDW's Academic Data Store (UWSDBDataStore) Reorg on Saturday, August 9, 2014
The EDW's Academic Data Store, also known as UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg. The SDB reorg is scheduled for Saturday, August 8th, which is followed by the UWSDBDataStore reorg. The UWSDBDataStore will be available normal business hours on Monday, August 11th.
BI Portal Now Includes Visualizations
We are pleased to announce the latest release of UW's Business Intelligence (BI) Portal. With the addition of data visualizations, the BI Portal is now positioned to be your one stop catalog for all central reports and analytics using Enterprise Data Warehouse data as well as departmental analytics from around the University.
Additional features in this release include:
- Links to a growing repository of Knowledge Base articles on new EDW data releases are available under the Glossary tab
- A more granular Alerts system tells you if there are issues with the individual reports, cubes, and visualizations
- Several other enhancements that improve tablet users' experience
Coming soon: New data definitions search functionality
Tableau Data Visualization Software Now Available for Macs
Tableau 8.2, released June 19, is the first version of this easy-to-use data analysis visualization tool to run natively on the Mac. It provides faster loading and new map designs and supports high resolution images, letting you display large data sets and communicate information in a powerful way. License agreements make Tableau products available at reduced or no cost to full-time UW students, as well as faculty and staff. .
UW's Tableau deployment picked up by the Wall Street Journal
UW's choice to use Tableau software as its primary data visualization tool, and the development of UW Profiles dashboards for exploring and understanding basic University data was reported in a recent issue of the Wall Street Journal. Tableau is used to easily create interactive graphics, reports and dashboards that allow you to ask questions and see and understand data in meaningful ways. To develop UW Profiles, UW-IT partnered with the Office of Planning and Budgeting. UW Profiles and Tableau also were featured in the November 2013 Special Edition of UW-IT Insights.
EDW's Academic Data Store (UWSDBDataStore) Reorg on May 3, 2014
The EDW's Academic Data Store, also known as UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg. The SDB reorg is scheduled for Saturday, May 3rd, which is followed by the UWSDBDataStore reorg. The UWSDBDataStore will be available normal business hours on Monday, May 5th.
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
EDW's Academic Data Store (UWSDBDataStore) Reorg on February 1, 2014
The EDW's Academic Data Store, also known as UWSDBDataStore, will be reorganized as a result of the mainframe Student Data Base (SDB) reorg. The SDB reorg is scheduled for Saturday, February 1st, which is followed by the UWSDBDataStore reorg. The UWSDBDataStore will be available normal business hours on Monday, February 3rd.
EDA Staffers Present at Annual Tableau Conference
Bart Pietrzak and Ann Wunderlin, two members of the University of Washington's Enterprise Data & Analytics team, will present on one of the largest higher education Tableau deployments. From the initial charter to the rollout and community-building, they will share how data visualization is changing the culture of UW by empowering users with their data. Read the Speaker Spotlight.
Archive of Previous Headlines