New York University Skip to Content Skip to Search Skip to Navigation Skip to Sub Navigation

University Data Warehouse Plus


Program Overview

The University Data Warehouse Plus (UDW+) will replace the current University Data Warehouse. Established as a Program, UDW+ continues to evolve and grow through:

  • Rebuilding existing University Data Warehouse architecture for more intuitive and integrated access to University data.
  • Decision Support Services around reporting and analytics.
  • Formalizing Data Management Policies and Practices that ensure integrity and accessibility.
  • Building a detailed and well executed ongoing internal Training Program.

The Oracle Business Intelligence Enterprise Edition (OBIEE) will eventually replace the current Brio reporting tool*. OBIEE is a reporting tool that pulls data from UDW+ to deliver a full range of reporting and analytical capabilities, including interactive dashboards, full ad hoc report capabilities, and alerts.

UDW+ Architecture Overview

UDW+ Architecture Overview

UDW+ will eventually store all financial, student, HR, fundraising, and other data. From the initial planning phases of the project to the design, requirements, and functionality of the new interactive dashboards, administrators, staff, department heads, and faculty from across NYU are collaborating to ensure the University will have timely access to accurate and integrated information for making critical decisions.

Currently available through UDW+:

The first project of the UDW+ Program is Financial Reporting and Analytics. One of the primary goals of the UDW+ program is improving financial reporting and analytics by providing more intuitive and flexible access to financial data. This project has impacted the entire financial reporting community, as Brio will eventually be replaced by UDW+. Deans, department heads, principal investigators, grant administrators, fiscal officers, executive leadership, and many others collaborated to design a variety of financial dashboards and reports tailored to meet the needs and requirements of groups throughout the University. ITS then developed and incorporated them into the new service.

To address specific needs of a school/division, advanced financial reporting users have the ability to create and share custom ad hoc reports. Ad hoc reports can be created with basic and complex analysis, adding graphs, formatting reports, as well as other advanced functions of the reporting tool.

To ensure continued improvements, the financial reporting and analytical capabilities are enhanced on a quarterly basis.

The Departmental Metrics Dashboard compiles data on faculty, sponsored research activity, student enrollment and instruction, for department chairs, deans, and university leadership. The metrics include research indicators identified by the Provost's Council on Science and Technology as "Principal Markers of Success: Priority Academic Metrics for Assessing Science and Engineering at New York University."

The Departmental Metrics Dashboard was originally created for selected academic departments identified by the Provost's Council on Science and Technology, and included information on the department's faculty and research staff, faculty achievements, proposal submissions, grants and students, as well as external comparative metrics. Due to popular demand, the Departmental Metrics Dashboard has been expanded and made available to all departments. Furthermore, additional pages have been added to provide information on doctoral time-to-degree and class enrollment.

With the expanding use of the Departmental Metrics Dashboard, we plan to add pages on faculty instruction, as well as global education data. The Departmental Metrics Dashboard will continue to evolve based on feedback from Deans and Department Chairs.

The UDW+ HR Reporting and Analytics project provisions HR data around people, positions, labor distribution, and payroll salary expenses. The development of new HR reporting content at NYU is a collaborative effort between PeopleSync and UDW+. Whereas PeopleSync is used for operational HR reporting, the focus of UDW+ development is centered around analytical and cross-functional reporting.

The UDW+ HR Administration Dashboard provides Human Resources Officers and Fiscal Officers with key information related to positions, compensation and costing allocations. The Dashboard sources data from PeopleSync, fame and legacy HRIS systems.

Coming soon to UDW+:

The addition of student data to UDW+ began in spring 2014. The goal of the UDW+ Student Reporting and Analytics is to provide a comprehensive source of data about students and instructional activity that is accurate, documented, user-friendly and integrated with financial and human resources data.

Currently, the Departmental Metrics Dashboard provides deans and department chairs with summary analytics describing the students in their programs, enrollment in their courses, and doctoral time to degree.  

Here's what some of the
UDW+ users are saying:

“This is the holy grail!”

“In the time it takes you to read this email, your UDW+ report would have displayed results.”

“This is wonderful... this is outstanding... this is what we use to spend days and days trying to figure out!”

“I love the dashboards, I love the ad hoc reports, its soooo easy. I’m never going back to Brio.”  

“I can leave each day and not feel like there’s so much  I couldn't accomplish. I feel so much more productive!”

"This gives me 99% of what I need."

How to get access to UDW+

NYU Footer