Transform Data & Analytic Resources IT Strategic Initiative

Overview

The Transform Data and Analytic Resources initiative is focused on developing a university-based analytical service and data hub that leverages current data repositories. There are a wide variety of databases (Enterprise and Academic) throughout the University. The ability to access these data will provide the opportunity for the community to develop knowledge based on their field of interest. The initiative will also develop a common data vocabulary and governance model to bridge the gap between functional data owners at the institutional level.

Progress

May 25, 2018, from the Interim Report

In FY 2016, OIRP undertook a partnership with OIT and SAS to establish an institution-wide reporting database accessible by all university software platforms and users. The team organized a Data Architecture Group to identify the best storage mechanisms and organizational structure for the data needed to conduct effective analytics and produce useful, actionable information.  Subsequent work undertaken in FY 2017 and continuing into FY 2018 includes:

  • Creation of a new language agnostic Oracle based enterprise reporting database to allow access from all university software platforms
  • Definition of database policies and conventions for ease of use and management across campus units and audiences
  • Identification of commonalities in data requests to continually refine data storage and database organization
  • Documentation of data tables, security policies, usage guidelines, and best practices
  • Work with internal stakeholders to properly link data management procedures and analytic information needs

The pilot project focused on the existing well-defined catalog of student information developed to comply with the UNC system Student Data Mart requirements as the logical starting point.  The initial product roll-out includes new online tools with a consistent graphical presentation layer of summary reports and drill-down capability.

Building on the above platform, OIRPin partnership with OIT, Enrollment Management (EMAS) and the Graduate Schoolis in the final stages of implementing an institution-wide online admissions status reporting (ASR) system.  

  • The new reporting environment will replace the static summaries of undergraduate and graduate recruitment cycle progress and tie them to ongoing long-range and biennial enrollment planning processes.  
  • The new ASRslated for go-live in spring 2018will provide colleges and departments with a comprehensive enrollment management dashboard for just-in-time unit-level admissions status updates.
  • A second concurrent project is underway to develop and deliver optimal enrollment forecasting methods for incorporation with the ASR and offer “what-if” analysis capabilities to enrollment planners.

Building on the framework of the Data Architecture Group process and its student information pilot project, a second data validation effort has begun with a focus on NC State Human Resources information needs.  This new effort is comprised of two elements: a Data Review Group to assess the adequacy of current data resources to meet institutional reporting needs and a Process & Policy Group charged with identifying enterprise goals for faculty/staff data reporting at NC State and providing guidance to the Data Review Group on high-priority data questions or investigations.  Like the student data initiative, the HR data project includes representation from a core cross-functional team including HR, OIRP, and OIT, as well as other campus stakeholders engaged in employee data maintenance, validation and reporting activities.

Concomitant goals of the Human Resources Data Validation Project are to:

  • Improve documentation of faculty/staff reporting items including an internal data dictionary to complement the UNC System HRDM data dictionary;
  • Provide consistency in the way employee data are maintained in enterprise data systems and portrayed across the institution; and
  • Increase stakeholder confidence in the accuracy of faculty/staff reporting used for decision-making.

June 6, 2016

Significant progress has taken place over the year on a number of fronts, with Mary Lelik leading this initiative. The data hub is in the process of being constructed, focusing first on pulling together student data resources. The student success-related projects underway include the EAB student success collaborative, with OIRP partnering with DASA, OIT and the Provost’s Office, the Open Academic Analytics Initiative model with DELTA and OIRP working with data from the learning management system, and the piloting of the data hub using SAS Visual Analytics.

Creation of a data dictionary is underway that will highlight available university data sets.

Finally, early discussions are taking place to explore the potential use of data visualizations using a network analysis to see if diagnostics can be strengthened for advising support to improve student success.