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
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.
Tableau Rollout Meeting on December 10th
Tableau 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.
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.
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.
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 firstname.lastname@example.org.
UW Today Article highlights culture change in strategic decision-making
A 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
UW-IT staffer contributes chapter to book Tribal SQL
Dev 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.
EdTech Magazine Publishes UW Business Intelligence Article by Anja Canfield-Budde
UW’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.
2013 Biennium Financial Cube now available
The 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.
Three Classroom Workshops Available
EDW 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.
Our Special Interest Group Turns 5!
At 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.
UW Tableau Pilot Update and Tableau Demo on April 25
UW'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.
EDW's Academic Data Store (UWSDBDataStore) Reorg on May 4
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 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.
Tableau data visualization software available to students and faculty via UWare
Tableau 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.
Using EDW Data was a featured topic at the first UW Code Camp
Through 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.
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.
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!.
Archive of Previous Headlines