Reports and Analytics News
July 14, 2021
UW Spend Cube Now Available
The UW Spend cube is now available. This story will prepare you to connect to and analyze UW Spend data! Jump to a section to learn more: What is the UW Spend Cube? Who should use it? How to connect to the UW Spend Cube How to learn more What is the UW Spend Cube? The UW Spend cube is a powerful and flexible data and reporting tool that helps you easily access and analyze UW Spend data. Beginning in Summer 2020, the UW-IT Business Intelligence Team partnered with the Finance DATAGroup to prototype, build, and publish the "UW Spend...
June 29, 2021
RPG Release: Student Grade Reports – Missing “W” Grades Bug Resolved
The Report Prioritization Group (RPG) just released bug fixes on these BI Portal reports: Student Grade Report by Curriculum, Course and Section Student Grade Report by Major In this news story we provide a summary of the changes. If you have any questions, please don’t hesitate to write help@uw.edu and put “BI Portal Report Question: Student Grade report” in the subject line. Change Summary: A user of the student grade report let us know that the two reports were excluding students that received a “W” grade. When they ran the report and chose “W” from the Course Grade Filter, the...
Read RPG Release: Student Grade Reports – Missing “W” Grades Bug Resolved
April 27, 2021
BI Portal Finance Report Changes: Budget Group Code Update
Enterprise Reporting and Analytics just released an update that affects several finance reports in the BI Portal. Here is a summary of the changes and their impact to finance report users. This work was completed in partnership with the Enterprise Data Warehouse team in UW-IT and the DATAGroup in UW Finance. What has Changed? We've updated the categories for the Budget Group Codes (Funding Sources) for several BI Portal Finance reports (see list below). These updated categories better reflect the consensus view of budget group code groupings in use today. Specifically, some budgets that have historically been classified as 'Grants...
Read BI Portal Finance Report Changes: Budget Group Code Update
March 31, 2021
RPG Release: Filter Bug Fix on UG Transcript Course Search by Major
The Report Prioritization Group (RPG) just released a bug fix on the BI Portal report Undergraduate Transcript Course Search by Major In this news story we provide a summary of the change. If you have any questions, please don’t hesitate to write help@uw.edu and put “BI Portal Report Question: UG Transcript Course Search by Major” in the subject line. Change Summary: The report was not working correctly when a user selected more than one course from the Course Number filter. Even if a user selected multiple courses, the report only ran for 1 course. This issue is now resolved! By...
Read RPG Release: Filter Bug Fix on UG Transcript Course Search by Major
March 26, 2021
RPG New Report Release: Academic Scholarship List
The Report Prioritization Group (RPG) just released the newest addition to the BI Portal: Academic Scholarship List In this news story we explain the purpose and benefits of the new report. If you have any questions, please don’t hesitate to write help@uw.edu and put “BI Portal Report Question: Academic Scholarship List” in the subject line. Meaning and Purpose The new report evolved from a very specific purpose to a more general-use tool for the entire tri-campus academic user community! RPG heard this request: "Will you please build us a report that will help us identify undergraduate students on visas that...
March 4, 2021
BI Portal Update: Consolidated Budget Status Reports
Update (5/26/2021): This work is complete and now the following reports are no longer available on the BI Portal: Consolidated Budget Status Report Menu and Consolidated Budget Status Report by MyFinancialDesktop Static Budget List. The Enterprise Reporting and Analytics team just released an update to the BI Portal Consolidated Budget Status reports. This update contributes to our goal of preparing for Finance Transformation by simplifying and consolidating reports in our BI Portal report catalog. There are three Budget Status reports currently accessed from the Consolidated Budget Status Report Menu in the BI Portal. The updates described below apply to these 3...
February 24, 2021
BI Portal Update: New Filters on Fiscal Year Income and Expense Summary
The Enterprise Reporting and Analytics team just released an update that combines two BI Portal Finance reports: Fiscal Year Income and Expense Summary by OrgCode and Funding Source Fiscal Year Income and Expense Summary by OrgCode and Function Into one report, now called Fiscal Year Income and Expense Summary Why Should You Care? If you use the ...by Org Code and Funding Source report you'll notice it now has new filters and a new (shorter) name! If you use the ...by OrgCode and Function report, you should now use the updated report (Fiscal Year Income and Expense Summary). Please note:...
Read BI Portal Update: New Filters on Fiscal Year Income and Expense Summary
February 22, 2021
How To: Finance Date Functions in EDW
Do you ever get tired of building complicated date logic in your EDW queries? The EDW now supports several finance date functions to help you simplify your queries! These functions help enterprise data users to easily convert calendar dates, months, and years to UW fiscal calendar objects. These functions are most helpful to SQL developers working on reports and visualizations that use fiscal calendar parameters/variables. Context: In SQL, a function is a program that takes some input and generates a value. SQL has many built-in functions that you get out-of-the-box. For example, one of the built-in system functions is GETDATE(). ...
February 12, 2021
Financial Activity 2019 Cube Update: New Attributes on Finance Cube
Based on input from users, we just published updates to the Financial Activity Biennium 2019 cube (finance cube). We added several new attributes to the cube that make it easier to get the finance data you need to do your work. In addition to the cube changes, we also want you to know about some other great content we recently published! Data Definitions: Finance cube data definitions are now in Knowledge Navigator Training/Help Videos: We recently published a suite of videos to help you answer several common use cases with the finance cube. Check out our Finance Data Cube Resources...
Read Financial Activity 2019 Cube Update: New Attributes on Finance Cube
February 10, 2021
RPG Release: Student Groups on Satisfactory Progress Policy Report
Based on user feedback, the Report Prioritization Group just released an update to the report: Satisfactory Progress Policy List The report now allows you to filter down to specific SDB Student Groups! This helps users answer the question, "are any students in a group I care about currently or projected to be in danger of producing unsatisfactory progress?" Please note, in order to align with BI Portal naming standards, in this release we also updated the report's BI Portal title: From: Satisfactory Progress Policy Report To: Satisfactory Progress Policy List Background: The SDB includes a feature called "Student Groups". The...
Read RPG Release: Student Groups on Satisfactory Progress Policy Report