Reports and Analytics News
June 28, 2023
Reimagining Reporting: The BI Portal and Workday Finance
To support UW Finance Transformation and the implementation of Workday Finance, the BI Portal report catalog has expanded to include Workday Finance and My Financial Desktop (MyFD) reports, providing a one-stop shop for users across the UW Academy. These updates deployed to the BI Portal on 7/18/23. Setting the Stage: The New UW Reporting Landscape Workday Finance, which went live on 7/6/23, offers various financial reports, which users can access from within the Workday application. While these reports provide valuable insights into important data, there are some caveats. Workday reports: Reflect data from limited subject areas: human resources/payroll and finance....
Read Reimagining Reporting: The BI Portal and Workday Finance
April 24, 2023
Knowledge Navigator: Winter Quarter 2023 Metadata Update
UW Metadata Manager, Keith A. Van Eaton, from Information Management’s Enterprise Reporting & Analytics team, has added or updated metadata objects in Knowledge Navigator. In their ongoing partnership, the UW’s data domain stewards, subject matter experts, and metadata manager ensure metadata objects are vetted and approved so that UW data users have a common understanding around UW data. New terms added 20 UW Workday Terms 3 Academic Terms Existing terms updated per Core Term Vetting Group and Data Governance Approval Please refer to the Metadata > CTVG wiki and expand the Published Core Terms section to see the latest approvals....
Read Knowledge Navigator: Winter Quarter 2023 Metadata Update
February 16, 2023
Redesigned Knowledge Navigator launches with enhancements
UW-IT's Information Management team members, in collaboration with the Program Management Office, successfully launched the redesigned Knowledge Navigator (KN) application. Over the course of the past six months, development, interface refinement, testing and debugging have resulted in backend efficiencies and a streamlined experience for users. Redesign launch and enhancements Knowledge Navigator’s redesign launched on Feb. 14 and while most of the work affected the backend of the application, KN users benefit from some enhancements: Streamlined home page Improved search features Better Help functionality Infrastructure improvements and efficiencies Increased security Updated Home page Knowledge Navigator's new Home page boasts a clean, contemporary...
Read Redesigned Knowledge Navigator launches with enhancements
January 23, 2023
Knowledge Navigator gets a refresh, modernizes for information and business excellence
— Data freeze starting Feb 6 — What is Knowledge Navigator? Knowledge Navigator (KN) is the University of Washington’s web-based application that displays business terms, their definitions, and data relationships used by everyone at UW. KN provides context to data used across the University and is UW’s one source for finding and understanding information across critical subject areas (Student/Academic, Human Resources, Financial, Research Administration) which enables informed decision-making. Knowledge Navigator Why is Knowledge Navigator being redesigned? Since 2015, when Knowledge Navigator first launched, it has run in Microsoft Azure using a classic virtual machine. This virtual machine will no longer...
Read Knowledge Navigator gets a refresh, modernizes for information and business excellence
January 12, 2023
Knowledge Navigator: Autumn Quarter 2022 Metadata Update
UW Metadata Manager, Keith A. Van Eaton, from Information Management’s Enterprise Reporting & Analytics team, has added or updated metadata objects in Knowledge Navigator. In their ongoing partnership, the UW’s data domain stewards, subject matter experts, and metadata manager ensure metadata objects are vetted and approved so that UW data users have a common understanding around UW data. New terms added 45 UW Workday Terms 7 Finance Terms 5 Research Terms 1 Academic Term New structured objects or reports or other added 1 Diagram 2 Enterprise Reports 17 columns EDWPresentation database 26 columns UWSDBDataStore database 48 tables & 570 columns...
Read Knowledge Navigator: Autumn Quarter 2022 Metadata Update
November 6, 2022
How To: URM Status SQL Function in the EDW
Do you get tired of maintaining the same business logic in many data products and spending too much time updating the logic in all those products? Are you looking for one version of the truth across all your academic reports, data cubes, and dashboards? The BI Team has great news for you. The EDW supports the first academic data-related SQL function, URM (Underrepresented Minority) Status, to help you reduce business logic maintenance, improve code readability, and keep one version of the truth for Underrepresented Minority students. Imagine that instead of spending time on updating, let's say, 12 academic reports with...
October 10, 2022
UW GL Cube undergoes redesign
We’re happy to announce the release of the newly redesigned UW GL (General Ledger) Cube. Kicked off in February 2021, the project is now completed and ready for use. Thanks to all the hard work of our developers from the DATAGroup and UW-IT ERA (Enterprise Reporting and Analytics), we updated the cube’s schema, making it easier to maintain, and making it more intuitive for finance users at all levels. Why was the UW GL Cube redesigned? To attain increased cost efficiency To facilitate UW Finance Transformation To make general ledger data accessible across the UW Users can expect the redesigned...
October 7, 2022
RPG New Dashboard Release: Time Schedule Course Enrollment Trends and Details
The Enterprise Reporting and Analytics team with the collaboration of the Report Prioritization Group released the newest addition to the BI Portal: Time Schedule Course Enrollment Trends What is the Time Schedule? The UW Time Schedule application lists credit classes offered at the University of Washington. The UW Time Schedule is updated daily and includes the following information and more: Status of courses Times, days, or locations of courses Instructors for all courses Section types (Lecture; Lab; Quiz; etc.) Learning types (Hybrid; All On-Line; No On-Line Learning) The Enterprise Data Warehouse (EDW) imports data from the UW Time Schedule system...
Read RPG New Dashboard Release: Time Schedule Course Enrollment Trends and Details
October 4, 2022
Knowledge Navigator: Summer Quarter 2022 Metadata Update
UW Metadata Manager, Keith A. Van Eaton, from Information Management’s Enterprise Reporting & Analytics team, has added or updated metadata objects in Knowledge Navigator. In their ongoing partnership, the UW’s data domain stewards, subject matter experts, and metadata manager ensure metadata objects are vetted and approved so that UW data users have a common understanding around UW data. New terms added 13 UW Workday Terms 5 Academic Terms New structured objects or reports added 1 Enterprise Report 2 Enterprise Dashboards 1 HRP Web Service 1 table & 18 columns UWSDBDataStore database 48 tables & 614 columns UWODS database 5 tables...
Read Knowledge Navigator: Summer Quarter 2022 Metadata Update
July 29, 2022
UW Finance Cube undergoes redesign
We’re happy to announce the release of the newly redesigned UW Finance Cube, formerly known as the Financial Activity Cube. Kicked off in August 2021, the project is now completed and ready for use. Developers and testers across UWFT (UW Finance Transformation) and UW-IT ERA (Enterprise Reporting and Analytics) collaborated closely with users to update the schema, making it easier to maintain, and making it more intuitive for finance users at all levels. The current Financial Activity Cube will no longer be available after October 30th. Please read on to learn: What is the UW Finance Cube? Why was it...