Decision Support

Recent News

EDW's Academic Data Store (UWSDBDataStore) Reorg on May 3, 2014

Data ReorgThe 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.

Posted 4/15/2014

New STEM and High Demand Data Resource Released

STEM StudentUW-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.

Posted 3/28/2014

EDW's Academic Data Store (UWSDBDataStore) Reorg on February 1, 2014

Data ReorgThe 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.

Posted 01/22/2014

EDA Staffers Present at Annual Tableau Conference

Ann WunderlinBart PietrzakBart 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.

Posted 1/9/2014

Tableau Server Upgraded to Version 8.1.1

UW's Tableau Servers were upgraded this week to Version 8.1.1. This upgrade enables several new features, including R integration, box & whisker plots, and more. Visit the Tableau website for more information.

If you have a Tableau Desktop license and want to learn more about this upgrade, visit the UW Tableau User Group website.

Posted 12/19/2013

Tableau Rollout Meeting on December 10th

Tableau visualizationTableau Software has been in university news a lot lately, most recently in this week's UW Today article about the new UW Profiles dashboards and their effect on strategic decision-making.

Behind the scenes, the rollout of Tableau Software is progressing well. Another information session is scheduled for December 10th. Join us to see how other institutions in the Pacific Northwest are using Tableau, hear the latest on the Tableau rollout, learn about UW Tableau User Groups that are starting, and get answers to your questions.

Agenda

11:00 - 12:30 - Broadcast of the Pacific Northwest Tableau User Group meeting
12:30 - 12:40 - updates on the rollout of Tableau software at UW
12:40 - 1:00 - Open mic Q & A

  • Where: UW Tower 22nd floor Boardroom
  • When: December 10, 2013 11:00 - 1:00pm

For more information on the meeting, including how to attend remotely, visit our wiki.

Posted 12/2/2013

Decision Support Servcies becomes Enterprise Data & Analytics

To recognize the increasingly important role that data is playing in strategic planning and decision-making for the University, Decision Support Services has become a separate unit within Information Management. As part of this move it has been renamed Enterprise Data & Analytics (EDA), to better reflect its scope and highlight the importance of this work to the institution. The new unit continues to be led by Anja Canfield-Budde, now in a Director role. EDA will broaden its scope to respond to emerging trends within information management inside and outside of the University.

Posted 11/26/2013

New Student Applicant & Application Data in the EDW

In partnership with the Office of Planning & Budgeting and the Office of the University Registrar, we are pleased to announce the migration of Application History data (appl_history) into to the Enterprise Data Warehouse (EDW).

Benefits of bringing these data into the EDW include:

  • Making quarterly census day application and applicant data, dating back to Autumn 1997, available for enterprise reporting and analysis
  • Securing the data under the same institutional access security model as all other EDW data.
  • Co-locating historical application and applicant data with other student data in the UWSDBDataStore database makes it easier to query

For more information on the migration, please contact help@uw.edu.

Posted 11/25/2013

UW Today Article highlights culture change in strategic decision-making

UW Today bannerA UW Today article shares the benefits of the UW Profiles interactive dashboards and the culture change coming about in strategic decision-making.

"Years of work on building a system at the University of Washington that will ensure the integrity of key institutional data is paying off. That work, combined with a new tool for visualizing and analyzing the data and new dashboards for exploring trends, is bringing about a culture change in strategic decision-making at the university."

Read the full article

Posted 11/25/2013

UW-IT staffer contributes chapter to book Tribal SQL

Dev NambiDev Nambi, developer for Decision Support Services, has contributed a chapter to a new book, Tribal SQL that features 15 first-time authors sharing their passion for working with SQL Server. The book includes community or “tribal” knowledge that won’t be found in other traditional training materials. When asked how he got involved with this project, Dev responded: “Many of the best and brightest in the SQL Server community are on Twitter and a request was made for contributors. For some odd reason they included me.” Dev’s chapter is “Agile Database Development” about how to do rapid development in a stable and efficient way even when demands are constantly changing. Find out more about the book, including which charity gets all the proceeds.

Posted 11/1/2013

EdTech Magazine Publishes UW Business Intelligence Article by Anja Canfield-Budde

EdTech logoUW’s leading-edge work on improving data quality and increasing confidence in data across the University was featured in the summer issue of EdTech Magazine. “Business Intelligence: Why Does It Take So Long?” authored by Anja Canfield-Budde, UW-IT senior manager of Decision Support Services, explains how the UW is working to deliver faster and better business information and why it’s such a complex endeavor.

Posted 10/2/2013

2013 Biennium Financial Cube now available

2013 CubeThe latest financial cube was released this week - this one for the 2013 Biennium. The EDW now supports financial cubes for 4 biennia, going back to 2007. Learn more about these and other available cubes.

If you're intested in using cubes but need some data handling skills to do so, check out our Handling Data 101 workshop. You will learn how easy it is to get started slicing, dicing, and charting your data to build comparisons and spot trends. All University staff are welcome to participate - visit our Workshops page to learn more.

Posted 7/17//2013

Three Classroom Workshops Available

Happy Birthday visualizationEDW 101 is designed to get those new to the Enterprise Data Warehouse up to speed on the purpose of UW's EDW and how to get started using EDW reports and data.

Ever wished you knew how use data to answer questions quickly? Handling Data 101 will show you how easy it is to get started slicing, dicing, and charting your data to build comparisons and spot trends.

UW Profiles is a new workshop! Learn how to navigate this new institutional dashboard, powered by Tableau Software. Note: you must have access to Enterprise Data Warehouse.

All University staff are welcome to participate - visit our Workshops page to learn more.

Posted 04/29/2013

Our Special Interest Group Turns 5!

Happy Birthday visualizationAt 5 years old, the Enterprise Data Warehouse Business Intelligence Special Interest Group is perhaps starting to grow into it's ever-so-long name, and is also one of Information Management's oldest communities. Hundreds of you from around the University have helped grow EDW understanding and usage - in fact by over 3600% on the reporting front, as depicted by our birthday candle visualization to the right.

All University staff are welcome to participate in the SIG - just join our mailing list to stay informed of EDW activity and upcoming meetings.

Posted 04/29/2013

UW Tableau Pilot Update and Tableau Demo on April 25

Tableau visualizationUW's Pilot of Tableau data visualization software began in November and will wrap up in mid-summer. On Thursday, April 25, 75 UW staff attended a presentation which shared updates on the Pilot and demoed features of Tableau Desktop and Tableau Server. Get the presentation slide deck and watch the presentation and demo online.

Learn more about the pilot, including ways you can stay informed about pilot activities and get started exploring data with Tableau today.

Posted 04/26/2013

EDW's Academic Data Store (UWSDBDataStore) Reorg on May 4

Data ReorgThe 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 4th and the UWSDBDataStore reorg is scheduled for Sunday, May 5. The changes resulting from the reorg will be available in UWSDBDataStore on Monday, May 6th.

Posted 04/19/2013

Tableau data visualization software available to students and faculty via UWare

Tableau logoTableau data visualization software is based on breakthrough technology from Stanford University that lets you drag and drop to analyze data. Users can connect to data in a few clicks, then visualize and create interactive dashboards with a few more and then easily share with Tableau Public. Visual analytics is at the core of the Tableau experience. Users must be able to ask questions and see data in meaningful ways in order to understand it. With traditional business intelligence, users have been challenged to easily visualize data and spot trends that answer their own questions.

Tableau offers full-time students free access to Tableau Desktop through the Tableau for Students program. Alternatively, UW faculty members can request a group license for a specific class through the Tableau for Teaching program.

Posted 03/28/2013

Using EDW Data was a featured topic at the first UW Code Camp

Code CampThrough a grass roots vote, 4 topics were selected to be featured at the 1st UW Code Camp - Using Enterprise Data Warehouse Data was one of those. EDW staff and subject matter experts from around the university fielded questions from 60 attendees.

Couldn't make it to Code Camp? Visit the EDW training site for more info on existing training resources.

And to learn more about Code Camp, visit the wiki for more information on how it got started and how the topics were selected.

Posted 03/28/2013

EDW Access & Use Agreement Updated

A new version of Information Management's Access & Use Agreement takes effect today in support of updated UW policies. EDW reports are covered by this Agreement, so next time you log into run reports you will be prompted to accept the new Agreement. A preview version of the Agreement is available here.
Posted 02/19/2013

EDW released My_Reports

The one-stop shop for your reports is now available! Go straight to the reports that matter most to you using the new My_Reports report. This helpful report contains links to all reports you've run during the timeframe of your choice. You can sort by report folder, report name, run frequency, and run date. Try it out today!.
Posted 02/11/2013

Archive of Previous Headlines