Reports and Analytics News
January 3, 2020
New Report: General Ledger Transactions by Month
Enterprise Reporting and Analytics has partnered with the DATAgroup in Financial Management to release a new report to the BI Portal: General Ledger Transactions by Month. Report Summary: This report gives users who are responsible for auditing and reconciling GLs a way to see individual transaction data for a specific GL Account/Fund Code combination by accounting month. The report sources data from the Enterprise Data Warehouse and refreshes nightly. What has Changed? If you previously ran this report on the Financial Management site, you might be wondering, “what has changed?” Nothing has changed with the report, only where you go...
December 26, 2019
Tableau Server Upgraded to Version 2019.4
We have completed the upgrade of the UW Tableau Public, Transitional, and Production servers to Version 2019.4.0. You can read about the new features in the latest version here: Tableau 2019.4 What You Need to Know: Latest Version: If you're ever curious what is the latest server version, you can see for yourself. Follow the steps on our Tableau FAQ Ask Data: If you were previously using Ask Data for your data source, you will need to explicitly enable it as the server default is to have Ask Data disabled. The process to enable is as follows: Navigate to your...
December 24, 2019
RPG Release: New Filters and Fields on Study Abroad Report
In July, we added the Study Abroad Students by Unit Report to the BI Portal. Following that release, we received feedback from many users on how to make the report better. Based on this user feedback, the Report Prioritization Group just released several updates to the report. Run the report to see for yourself: Study Abroad Students by Unit Report. Change Summary: Based on user requests, we added several new filters to the Study Abroad report. Quarter Filter: The filter allows you to narrow down to specific UW Quarters of interest. Since some study abroad programs span multiple quarters, the...
Read RPG Release: New Filters and Fields on Study Abroad Report
December 3, 2019
UW Profiles Release: Updates to Size of Academic Units and Type of Students Served
Based on user feedback, the UW Profiles team released updates to the Size of Academic Units and Type of Student Served dashboard. Change Summary: Undergraduate Major Status Filter: A new “Undergraduate Major Status” filter was added to allow users to filter Undergraduate students by Declared Major and Pre-Major. This filter allows you to answer new questions like: “how many students have a declared major in our college?” New features: Bars representing Baccalaureate data in the College and Department bar charts are separated into sections for Pre-Declared and Declared Major. Hovering these sections will display a tool tip with data for...
Read UW Profiles Release: Updates to Size of Academic Units and Type of Students Served
December 2, 2019
Archiving Report: 2013 Base Year Paid FTE Report
On November 19, 2019, the ERA Team archived the 2013 Base Year Paid FTE Report due to low usage and outdated information. Archiving: What does that mean? Archiving simply means that we removed this report from the BI Portal, and it will no longer be accessible. The purpose of archiving is to allow our team to reduce the volume of redundant or unnecessary tools that we support, and to focus on building new higher value solutions for you! Replacement: Where can I get this info after the report is archived? You can still access this information by connecting to Research...
November 18, 2019
RPG Release: New Fields Added to Time Schedule Information Report
We recently shared that you can now access Jointly-listed course information in the Time Schedule Report. Based on user feedback, the Report Prioritization Group just released several more updates to the BI Portal report, Time Schedule Information. Change Summary: Based on user requests, we added several new columns to the Time Schedule report. You can find these fields in the Columns to Display dropdown: Instructor Netid Displays the UW Netid for the instructor(s) associated with this course. Census Major Enrollment Displays total enrollments of major students in a course on census day of the quarter. Census Non-Major Enrollment Displays total...
Read RPG Release: New Fields Added to Time Schedule Information Report
October 29, 2019
RPG Release: Updates to Time Schedule Information report
Based on user feedback, the Report Prioritization Group released updates to the BI Portal report, Time Schedule Information. Change Summary: The Time Schedule Information report now includes summary and detailed joint course loop information. Joint Course Summary Info: New Filters The following filters have been added to the Columns to Display parameter: Loop Joint Course Flag Loop Current Enrollment Loop Limit / Est Enrollment Loop Joint Limit Loop Joint Courses Joint Course Detail Info: You can now drill down to a subreport that contains detailed course loop info. Look for the column “Loop Jnt Course Flag”, and click the hyperlinked...
Read RPG Release: Updates to Time Schedule Information report
October 24, 2019
RPG: Updates to Student Course Distribution
Based on user feedback, the Report Prioritization Group released updates to the BI Portal visualization, Student Course Distribution. Change Summary: This is the first major update to the Course Progress in Major/Student Course Distribution visualization since it was implemented about 3 years ago. The changes discussed below are mostly usability enhancements based on feedback we collected from users. Before After Display: Changed cells from circles to squares Removed Course Names from being displayed vertically on the top of a viz. Course information is now available in the tooltip. Updated the colors to be more intuitive (i.e. gray for “no activity”)...
October 16, 2019
EDW Disaster Recovery Exercise on October 23, 2019
On Wednesday, October 23, 2019 from 8 a.m. to 10:30 a.m. the Enterprise Data Warehouse team will complete our Annual Disaster Recovery Exercise. Because this exercise affects the EDWPUB SQL Server as well as Reporting Services Reports hosted on the BI Portal, your user experience may be impacted in the following ways: System performance issues may occur during this time Potential service disruptions Potential delayed data This exercise has been rescheduled from its original date of October 9, 2019. If you have any questions or concerns, please contact us at help@uw.edu. Update October 23, 9:22 a.m.: The EDW Annual DR...
October 3, 2019
EDW Disaster Recovery Exercise Rescheduled
Update Oct 9 2019 8:21AM: The EDW DR Exercise previously scheduled for this morning has been cancelled and will be rescheduled for a later date. On Wednesday, October 9, 2019 from 8 a.m. to 10:30 a.m. the Enterprise Data Warehouse team will complete our Annual Disaster Recovery Exercise. Because this exercise affects the EDWPUB SQL Server as well as Reporting Services Reports hosted on the BI Portal, your user experience may be impacted in the following ways: System performance issues may occur during this time Potential service disruptions Potential delayed data If you have any questions or concerns, please contact...