IT Connect

Information technology tools and resources at the UW

Archive for category: News

Enterprise Data & Analytics and Enterprise Data Warehouse news item

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.

UW Profiles Underlying Data Now Available

UW Profiles data visualizations (http://uwprofiles.uw.edu) have greatly enhanced how the University can use data to understand key metrics about students. We are pleased to announce that the data used to create these dashboards is now available for download.

Anyone with Tableau software and access to student data in the Enterprise Data Warehouse can download these data files to craft customized visualizations meaningful to their constituents, using the same UW Profiles data. Detailed definitions and source information are available for each of the four data models (Degrees, Graduation/Retention, Student Credit Hours, and Student).  Visit the Data Models tab (https://uwprofiles.uw.edu/#tab2) in the Portal to get started.

This joint effort between the Office of Planning & Budgeting and Enterprise Data & Analytics represents the 3rd major release of UW Profiles. In the pipeline are dashboards using research administration data, expected to release later this summer.

See the UW Profiles help page for more information and please send questions to uwprofiles@uw.edu.

Handy reference links:

When Having the Right Data Counts: New UW Data & Analytics Website

Our new UW IT Data & Analytics website showcases how UW faculty and staff can use central UW data to inform their decision-making. On this mobile friendly, accessible site you can request access to enterprise reports, analytics and data, browse online and workshop training or join a user group, and subscribe to news and alerts. The site provides quick links to the Business Intelligence Portal and the UW Profiles data visualization tool, as well as information to better understand, work with, and use data.

UW is a recognized leader in higher education data warehousing and business intelligence and often consults with other institutions. With this audience in mind, the website also features a timeline of major program milestones and list of products and services.

Stay Informed – Subscribe to Alerts, News, & More

System alerts, new releases, maintenance notifications, and new learning opportunities – all the news is right here on our news page!

Have the news delivered straight to your RSS reader. Subscribe to any news category that interests you by selecting its orange RSS feed icon in the right sidebar on the main News page.

Talk involving UW Profiles wins best presentation at conference

A talk about UW Profiles, the UW’s interactive dashboards for accessing and understanding basic UW data, was honored as “Best Presentation” at the Pacific Northwest Association for Institutional Research and Planning’s annual conference. The talk last month by Nevena Lalic of the Office of Planning & Management’s Institutional Analysis team and Bart Pietrzak of UW-IT’s Enterprise Data & Analytics was selected from among 30 presentations for its especially helpful ‘how to’ content on using Tableau with institutional data and working with the IT organization to structure that data. Pietrzak, a Business Intelligence Architect, and Lalic, a Senior Analyst, are collaborating on a proposal to adapt the presentation, “Exposing Basic Institutional Stats Using Interactive Tableau Dashboards,” for the Association’s national conference in May. UW Profiles was created jointly by UW-IT and the Office of Planning & Budgeting, now a unit within the newly named Planning & Management office.

PNAIRP logo

UW Profiles: Requested Enhancements Now Available

It is easier to understand trends in UW student enrollment, course-taking, academic progress and degrees with new enhancements to UW Profiles, the Web-based dashboards of University data. Now you can drill down to explore trends at the major, degree or curriculum level, and display information in tabular—as well as visual—format. Also, all dashboards now provide new filters and breakdown options. Faculty and staff can log into UW Profiles to learn how to access and use the tool.

UW Course Demand Analytics Now Available

UW colleges and departments can use three new data visualizations in the UW Business Intelligence (BI) portal to understand how many spaces are needed to accommodate the demand for each course, based on Notify.UW data. All academic units are included and information is available for the current quarter—refreshed each weekday at 6:30 a.m.—and for each quarter since winter 2013. To access the Current Course Demand, Current Notify Course Demand or Trends in Course Demand visualizations, you must have access to the Enterprise Data Warehouse and the Tableau Server.

Public Version of UW Profiles Now Available

Interactive UW data dashboards enable prospective students, higher education institutions and the general public to explore UW enrollment and degree trends, and undergraduate graduation and retention rates. Called Public Profiles, it was developed by the Office of Planning & Budgeting and was released this summer. More extensive UW data dashboards, UW Profiles, have been available to the UW community since fall 2013.

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.

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