IT Connect

Information technology tools and resources at the UW

Archive for category: Tableau

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

What Business Intelligence Tech Do I Need?

There are a lot of options in the Business Intelligence (BI) world. It can be confusing trying to sort out which solution is right for which project.

One of the largest division lines is speed. Are you able to wait 30 seconds for your data to show up or no you need to immediately see your data rendered so you can move on to your next query?

Here is a light-hearted but handy flow chart reference detailing what SQL, reports, Tableau, and Cubes are good for.

BI Tech Infographic

Let me know what you think at help@uw.edu!

UW Profiles

Becka Poppe of OPB is finding great success with UW Profiles.

Here is what she has to say about it.

UW Profiles

I use UW Profiles on a regular basis for a variety of projects. It is particularly helpful when I receive requests from the state legislature for information or for fiscal notes (i.e. estimates of how proposed legislation would fiscally impact the UW) as these types of requests typically have very tight turnarounds and require highly specific and accurate data. UW Profiles allows me to retrieve whatever information I need, without having to go through a middleman, which makes a huge difference when time is scarce.

I also use UW Profiles when writing policy briefs, as I often want to cite facts to support my position or analysis of a proposed bill. For example, when writing briefs about affordability and access, I often mention the number of Pell-eligible students in the UW’s undergraduate population and cite relevant trends in underrepresented minority student enrollments.

Lastly, UW Profiles is one of my key data sources when I provide the President’s Office with updates on institutional goals.

The “Export” feature is fantastic as it allows me to download the data and make my own pivot tables. I also really appreciate the new “Switch to Tables” / “Switch to Visualization” feature that lets me toggle back and forth between the two data views.

All in all, I’ve found UW Profiles to be an incredibly valuable tool that helps me do my work more efficiently and effectively.

-Becka Johnson Poppe
Office of Planning & Budgeting

Notes

Her favorite dashboards are:

  • Key Facts – Academics:
    • Enrollment Summary
    • Degree Summary
  • Student Enrollment:
    • Diversity Profile & Trends
  • Student Academic Performance:
    • Undergraduate Retention and Graduation Rates
    • Undergraduate Graduation Patterns and Time to Degree

Summary

Thanks so much Becka for the detailed account of how you find value in the UW Profiles visualizations. If anyone else uses UW Profiles to great affect please tell us about it at help@uw.edu!

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.

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

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.

Tableau Software logo

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.