The Enterprise Information, Integration & Analytics team helped develop content for the EDUCAUSE Review’s “Running a BI Shop” series of four how-to papers on creating business intelligence (BI) programs at higher education institutions. Anja Canfield-Budde, Interim Associate Vice President for Information Management, coauthored the articles along with a fellow BI expert at Purdue University. The articles compare BI planning efforts at Purdue University and the UW, revealing common themes: the value of framing the discussion, obtaining broad stakeholder input, and producing a simple, easily communicated strategy. Aimed at new and seasoned BI professionals, the articles are focused on the following:
Archive for year: 2016
Now it’s easier than ever to understand UW administrative data, with the latest Knowledge Navigator, the UW’s metadata repository tool. It can help you navigate data changes related to moving from the UW’s old HR/Payroll mainframe system to cloud-based Workday. Use interactive maps to understand the relationships between business concepts and do impact analysis to learn the ramifications of data changes to data tables and columns. Visit the Knowledge Navigator features page to learn more.
This video explains what SMAT & DAC are and how data custodians can use the SMAT to keep our data safe.
1. What are SMAT & DAC (0:38)
2. What is an ASTRA role (1:25)
3. How to change a security definition (2:26)
Now you can share your data visualization dashboards with colleagues anywhere in the world, with the new UW Tableau Public Server. Hosted by UW-IT, the server keeps your data safe and secure; viewers interact with your dashboard but do not download it or the data behind it, and a UW NetID is not required for access. Now it is easy to share UW information, research data and analyses with peer and other institutions as well as the media. Learn more.
The benefits of using Knowledge Navigator (KN), the graphical metadata repository created in response to changes to data definitions driven by the HR/P Modernization program, are explained by Pieter Visser in a new blog post. The article appears on the website of the Neo Technology company, maker of the Neo4j database adopted for use by UW-IT for KN.
Ever wonder how the University of Washington measures up against other similar schools? Using the eleven Peer dashboards on the UW Profiles website, you can now see for yourself. Four dashboards focus on student measures (graduation, retention, enrollment, and awards) and seven dashboards focus on finance data (expenses, revenue and endowment). Among the newest dashboards, Expenses Story leads the reader through a step-by-step analysis that compares shares of expenditures between research and instruction, while Revenue Total Breakdown compares per FTE tuition revenue with other revenue sources.
Data for these dashboards come from the federal Integrated Postsecondary Education Data System (IPEDS) Data Center, a publicly-available repository of self-reported institutional data for US colleges and universities. These dashboards, built in partnership by the Office of Planning & Budgeting’s Institutional Analysis team and UW-IT’s Enterprise Information, Integration & Analytics unit, are the latest additions to the growing suite of UW Profiles interactive dashboards.
Explore all peer comparison dashboards in the UW Profiles Portal. Insights are just a few clicks away.
The Graduation Rate dashboard displays 4-, 5-, and 6-year graduation rates for institutions that are part of one of the University of Washington’s peer groups.
The Retention Rate dashboard displays one-year retention rates for institutions that are part of one of the University of Washington’s peer groups.
The Fall Enrollment dashboard displays total student enrollment, as of the official fall reporting date, at institutions that are part of one of the University of Washington’s peer groups.
|Awards Granted and Completers
The Awards Granted dashboard displays the total number of degrees or certificates granted in the latest available academic year by institutions that are part of one of the University of Washington’s peer groups. The Completers dashboard displays the total number of students earning degrees or certificates in the latest available academic year at institutions that are part of one of the University of Washington’s peer groups.
The Expenses Story dashboards explore multiple ways to visualize and compare expense data.
|Expenses by Category
The Expenses by Category dashboard displays expenses per student full-time equivalent (FTE).
|Modified Expenses by Category
The Modified Expenses by Category dashboard displays expenses per student full-time equivalent (FTE).
|Revenue by Category
The Revenue by Category dashboard displays revenue per student full-time equivalent (FTE).
|Revenue Total Breakdown
The Revenue Total Breakdown dashboard displays total tuition revenue and state and local appropriations per student full-time equivalent (FTE).
|Revenue Percent Breakdown
The Revenue Percent Breakdown dashboard displays the relative contribution of tuition revenue and state and local appropriations as sources of institutional revenue.
The Endowment Values dashboard displays the total values of institutions’ endowments at the beginning and at the end of the most recent fiscal year.
This video uses familiar Microsoft Outlook calendar data as the basis for learning how to analyze data using Tableau. Tableau makes it easy to create visualizations and provides a powerful way to analyze data. Every analyst, accidental or otherwise, will benefit from this tool.
You’ll learn how to export your Microsoft Outlook calendar to a CSV file, open the CSV file in Tableau and massage the data, and analyze your data using a Tableau visualizations.
UW’s subscription to the Education Advisory Board (EAB) IT Forum offers higher education-specific information technology resources to UW students, faculty and staff. For no individual charge, users with a UW NetID can access the service for white papers, webinars, peer articles and other research resources, as well as for in-person consultation, in topic areas such as data governance, measures and metrics, analytics, and student success.
This video highlights the benefits of the subscription and this article contains links to more information.