ZU Data Transformation Journey


September 2022
  • DASS Project Kick Off.

Discovery

  • Requirement Document

  • Understanding document containing specifications of data sources, existing data platform, etc.

  • In-Scope and Out-of-scope validation document

  • Data Model and Architecture documents

  • Design Documents

September 2022

November 28, 2023

Design & Build

  • Build Azure data eco system

  • Build Azure components

  • Build Data Lake

  • Build and Deploy ETL

  • Build Security Framework

  • Create Dashboards and Reports

Challenges

  • ZU faces challenges including: absence of a centralised data library, absence of data governance framework, data quality inconsistencies, missing data classification protocols, limited advanced predictive analytics integration, no self-service capability for ad-hoc reporting, high latency in data processing, and reliance on manual data consolidation.

  • Data is siloed and unintegrated. Data analysis is ad-hoc and performed by a few individuals.

December 1, 2023
December 2023

Data Governance Charter

  • Data Governance Initiative is formally initiated at Zayed University.

  • Objectives of the Data Governance Program under DASS are defined.

  • Key components of Data Governance are established, including Data Catalog, Data Lineage, Data Security, Data Quality, Business Glossary, Data Classification, Policies & Procedures and MDM.

  • Current challenges at ZU are discussed, including absence of data security and classification, lack of a data catalog, and unavailability of self-service data discovery.

  • Alignment of the DG program with departments and colleges and onboarding users begins.
December 22, 2023
January 2024

VP Decree

  • Forming the Data Governance Committee (DGC) and Approval of Charter.

DGC Kick-Off Meeting (12Mar2024)

  • Data Governance Committee and Data Governance Lead confirm Data Stewards and Owners for each source system (Phase 1).

  • Data Governance Committee and Data Governance Lead confirm Data Stewards and Owners for each individual business term.

  • Purview production environment setup begins.

  • Priority of source systems for MDM determined.

  • SFD-IR, IT and Nagarro work to setup Purview Production Environment.

  • Data Governance Committee signs off on the initial business glossary.

  • Data Governance Committee approves the Classification Matrix.

  • Solution Architect, Data Owners and Data Stewards provide priority of source systems for MDM.

  • Data Owners and Data Stewards provide approvals for each business term.

February 2, 2024
February 2024
  • Data Catalog Scan begins from Phase 1 Source Systems.

  • Business Glossary on Purview is enriched.

  • Automatic Workflows on Purview are built.

  • Custom Data Quality Framework is built.

  • Nagarro is to perform Data Catalog Scan from Phase 1 Source Systems.

DGC Second Meeting (7May2024)

  • Data Governance Committee validates and signs-off on Policies and Procedures.

  • Policies and Procedures creation begins.

  • Custom MDM Framework to be developed.

  • Data Lineage creation to be developed.

  • Data Owners, SFD-IR, Legal and Nagarro are involved in developing Policies and Procedures.

Ongoing (Starting November 2023)
February 2024
  • DGC Third Meeting (28May2024)

Phase 1 goes live: Admissions, Registrations, Graduate Studies, CIS, All colleges.

  • Presentation for the Board of Trustees on DASS.

  • DASS Dashboard is designed to centralize data from various sources and provide intuitive data visualizations.

  • Focus on Student Enrolment, Cohort Life Cycle, Attrition Rate, Grade Distribution, and Just-in-time Graduation, Faculty by Workload, and Strategic KPIs.

August 2024
November 2024
  • DGC Fourth Meeting (18Sept2024)

  • DGC Fifth Meeting (24Oct2024)

December 2024
Continuous
  • Phase 2 goes live: Research, Rankings, Student Affairs, CHEDS, Survey, Evaluations, Advising, and Employment Rate.

  • Phase 3 goes live: HR, Finance, Procurement, Rankings, KPI.

• Spring 2023 & Fall 2023
September 2025
  • Training, maintenance, and updates of the DASS model.

  • Building Relationships between Business Glossary and Data Catalog.

  • Resolution on Data Quality issues.

  • Maintain Data Governance assets on Azure Purview

  • Data Stewards provide Data Quality checks/rules.

  • Data Stewards view errored records and correct in the source systems.

Ongoing (Starting November 2023)