Service News Category: Enterprise Data Warehouse

  • EDW for Finance Transformation Release 17 is Now Available

    January 30, 2023

    Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. What’s New in EDW Release 17 Database Overview of Release…

  • UWSDBDataStore Reorgs on January 28, 2023

    January 23, 2023

    UWSDBDataStore Reorgs on January 28, 2023 The student database (SDB) will go through a reorganization on January 28, 2023 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 30, 2023. However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data. Last Updated – 01.23.2023 Column Adds to Existing…

  • EDW for Finance Transformation Release 16 is Now Available

    January 10, 2023

    Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. What’s New in EDW Release…

  • EDW for Finance Transformation Release 15 is Now Available

    December 5, 2022

    Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Reminder for ODS users: When UW Finance Transformation (UWFT) goes live, the current state ODS database will be frozen and the UWODS database will be introduced. For more information, refer to Transitioning HR Data from ODS to UWODS. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows…

  • Support Available to Transition Human Resource/Payroll Data from ODS to UWODS

    November 15, 2022

    The Enterprise Data Warehouse (EDW) recently introduced two new databases to support UW Finance Transformation (UWFT): UWODS and WDFinDataMart. For more information, refer to EDW Databases and Resources Available to Support Finance Transformation. The UWODS database, which goes live with UWFT, will enable EDW users to access Finance and Human Resource/Payroll (HRP) data from Workday. The UWODS will replace the current ODS database as the EDW resource for this data. In the UWODS, the HRP data model is different than…

  • EDW Databases and Resources Available to Support Finance Transformation

    November 14, 2022

    The Enterprise Data Warehouse (EDW) is a secure central repository that integrates data from many sources across the University. It stores current and historical data that are used to support operational reporting and strategic analysis. The goal of the EDW is to support better and faster data-informed decision making. For more information about the EDW and how it fits within the Enterprise Data Platform, refer to Enterprise Data Platform. EDW and UW Finance Transformation (UWFT) UW Finance Transformation (UWFT) is much more…

  • How To: URM Status SQL Function in the EDW

    November 6, 2022

    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…

  • UWSDBDataStore Reorgs on October 22, 2022 and December 21, 2022

    September 30, 2022

    UWSDBDataStore Reorgs on October 22, 2022  & December 21, 2022 The student database (SDB) will go through a reorganization on October 22, 2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 24, 2022. However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data. Please Note: The following…

  • Knowledge Navigator Metadata Update Spring Qtr 2022

    July 13, 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…

  • UWSDBDataStore Reorg on June 4, 2022

    May 31, 2022

    UWSDBDataStore Reorg on June 4, 2022 The student database (SDB) will go through a reorganization on June 4, 2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on June 6. 2022. However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data. Last Updated – 5.31.22 Columns to be Added…