Reports and Analytics News
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...
July 20, 2022
A consolidated, redesigned BI Portal launched on June 27
With a new interface and backend code base, UW-IT Information Management’s Enterprise Reporting and Analytics team has concluded over two years of work to consolidate and redesign two separate portals — BI Portal and UW Profiles. The main objectives of consolidating these two portals were to improve the customer experience and reduce the overall cost of running two separate infrastructures. The new BI Portal user experience enhancements include: Improved search capability Logical grouping of BI products (reports, cubes, dashboard) by tagging Simpler user interface Future integration of report catalogs from external platforms, like Workday Faster time to deliver new reports...
Read A consolidated, redesigned BI Portal launched on June 27
July 13, 2022
Knowledge Navigator Metadata Update Spring Qtr 2022
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 16 UW Workday Terms 9 Research Terms 7 Academic Terms New structured objects or reports added 17 Enterprise Dashboards 1 UW Finance Cube 1 UW General Ledger Cube 3 tables & 70 columns EFECSDataStore database 6 tables & 100...