Skip to main content

Enterprise Reporting becomes its own unit


In April 2019, ITS Enterprise Reporting & Departmental Systems was moved from ITS Enterprise Applications and became its own distinct operating unit.

Enterprise Reporting & Departmental Systems now reports directly to the Office of the CIO. The team has 16 members, six of whom have been added in the last year. Rachel Serrano, who has worked in management of data warehousing and analytics for more than a dozen years, continues on as the group’s director.

team photo
The Enterprise Reporting & Departmental Systems team

The team moved out of Enterprise Applications for four primary reasons, said J. Michael Barker, Interim Vice Chancellor for Information Technology and Chief Information Officer. First, data reporting, analytics and the data warehouse are key to ITS’ work moving forward. This decoupling acknowledges the strategic significance of data reporting and analytics and prepares the organization for the realities of the IT landscape in higher education.

Second, the change enables the Enterprise Reporting & Departmental Systems team to align the development processes to its own needs and the needs of its customers.

Third, as its own unit, Enterprise Reporting & Departmental Systems can interact directly with a broader swath of the University’s units and projects, and thereby, increase engagement.

Finally, separating out Enterprise Reporting & Departmental Systems enables the unit to adjust governance and decision processes to suit the University’s priorities.

Rachel Serrano
Rachel Serrano

Data, then apply instinct

Higher education, Serrano said, often falls victim to anecdotes. “I know this is happening,” higher education professionals tend to say, “because we talked to students.” People working in higher ed make decisions to a large degree based on gut. That’s not a bad thing, Serrano said, but it’s much more helpful and reasonable to see a data picture and then apply instinct to drive action.

UNC-Chapel Hill and ITS want to create a data-informed campus. Enterprise Reporting & Departmental Systems (ERDS) aims to identify issues and opportunities that before might have been a story or a myth, like theories associated with the reasons for employee turnover or why one major or another is losing students. The advantage of a data warehouse is the ability to measure the lifecycle of employees and students, relate those to each other and include the impact of finances.

If the University can become more analytical, it can begin to predict when certain changes will occur. By looking at the data and asking why or why not, UNC-Chapel Hill can take more control over actions, Serrano said. Being able to measure is a powerful tool to understand what’s working and what’s not.

The ERDS team can accelerate delivering the products and capabilities the campus requires by designing a development process that is tailored to their customers, the outputs the team must produce, and the methods the team must apply.

More nimble means more responsive

Decoupling from Enterprise Applications enables Enterprise Reporting & Departmental Systems to meet its separate needs and use its own appropriate workflow. For Enterprise Applications, work in ConnectCarolina is transaction focused, so everything goes through a set planning process designed to minimally disrupt the business of the University. Enterprise Applications also has a specific audit needs for its transaction-based system that doesn’t necessarily translate to ERDS’ needs.

There are many changes that need to or can be made on the fly in reporting, that do not affect data input or output, and only relate to the visualization of data. The change management steps necessary for Enterprise Applications to maintain the sanctity of transaction processing don’t translate well to these kind of visualization changes and allowing people to truly explore data.

Decoupling governance enables ERDS to be responsive to these kind of requests. It’s not the Wild West — ERDS still has change management and migration processes. But with its own governance, the group can track changes and still be responsive while maneuvering with adequate speed through the planning process.

As a separate group with its own processes and governance, Serrano said, “We can be more nimble in how we respond to work requests.”

Benefiting from its own data structure

Enterprise Reporting & Departmental Systems and Enterprise Applications also require different platforms for its information. Enterprise Applications works in ConnectCarolina. ERDS needs a data warehouse, which has a different data structure than what one finds in ConnectCarolina.

ERDS can take data and build in business rules in the data, enabling use in any platform customers want, such as Tableau, SAS Visual Analytics or Microsoft’s Power BI business analytics service, to get the repeatable results they want. Before, ERDS had to dig the data out of ConnectCarolina and make manual manipulations.


Comments are closed.