Enterprise Data Management

The Enterprise Data Management team will ensure the availability and integrity of authoritative institutional data in support of critical, strategic, and operational functions throughout ASMP and beyond. Specifically, Enterprise Data Management initiatives address Recommendation 1.2 of the Administrative Systems Master Plan: "Improve Design and Management of Data to Enhance Decision-Making."

Current Status:

  • Successfully deployed Information Quest (IQ) web services providing Institutional Data Store (IDS) data for the Texas Advanced Computing Center (TACC), the College of Natural Sciences, and....
  • Created a reports inventory of the most critical institutional, statutory, and strategic reports and data and are actively tracking the provision of key data concepts in Workday; for more information, refer to Reports Inventory Frequently Asked Questions
  • Evaluating Workday reporting capabilities and performing gap analyses against reporting requirements for go-live and post-go-live deliverables
  • Developing custom Workday reports to support HCM/PR/FIN business processes
  • Working with TXADMIN to gather custom Workday financial report requirements to provide departmental operational reports at go-live
  • Actively mapping Workday fields to legacy concepts (to be published to web site)
  • Supporting data conversion activities for Workday HCM/Payroll and Finance via the IDS
  • Piloting the integration of Workday data into the IDS and expanding data models
  • Piloting the use of the IDS and new web services as viable solutions for some of the Application Modernization projects
  • Data Management Committee (DMC) workgroups developing and adopting risk-based data access and use guidelines and procedures
  • Populating the Data Cookbook data-definition management tool with data definitions as they are mapped
  • Developing an intake process for data requests/requirements
  • Developing a Reporting Portal to provide campus with searchable lists of reports and data definitions

Resources:

About Enterprise Data Management:

Enterprise Data Management (EDM) consists of:

  • Data Continuity (DC) – internally focused on the movement and conversion of data between enterprise systems
  • Data Access (DA) and Reporting – externally focused on the data consumption requirements of our campus and access to data from both Workday and the IDS
  • Data Governance (DG) – implementation of guidelines and procedures established by the Data Management Committee (DMC)
  • Institutional Data Store (IDS) Alignment – ASMP partnership with the Information Quest (IQ) to leverage and expand the IDS and IQ data services to achieve program objectives

EDM initiatives include:

  • "Data as a Service" ("DaaS") using a robust suite of data access tools and methods that are stratified based on a variety of consumer roles, end-products, and required levels of data granularity
  • Continuous and uninterrupted access to institutional data for strategic management information and statutory reporting, regardless of source, platform, or location
  • Clear data governance guidelines and procedures, established by the Data Management Committee (DMC), for accessing institutional data throughout the university
  • Assisting with the Workday ERP implementation, including data conversions, mapping, and custom business process report development
  • A comprehensive Reports Inventory to support Workday design and configuration activities
  • IDS as a repository for historical data and maps/crosswalks to facilitate multi-year trending of institutional data
  • IDS as an alternative integration solution for systems being replaced as part of the Application Modernization effort; specifically, those that (a) do not require real-time access to data, or (b) need access to historical or cross-platform institutional data
  • Integration of data across business domains and sources
  • Access to institutional data through multiple central access tools and methods in order to help reduce redundant data stores across campus
  • Reporting Portal - web content to facilitate campus-wide access and discovery of available reports across administrative systems (Workday, IQ, etc.)
  • Business glossaries, rules, and methodologies; accessible documentation for data consumers
  • Data tracking and transparency; documentation of the meaning and location of institutional data across systems, as well as data ownership and authoritative sources and uses, using the Data Cookbook data definition management tool