University Data Warehouse Plus
The University Data Warehouse Plus (UDW+) is gradually replacing the former 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) is gradually replacing the 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+ stores major components of financial, student, HR, and research data. The UDW+ Program will continue to expand to include other areas. 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+:
Financial Reporting and Analytics
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. With the expanding use of the Departmental Metrics Dashboard, additional pages have been added to provide information on doctoral time-to-degree, class enrollment, program enrollment trends, department course instructors, and technology enhanced education.
The Departmental Metrics Dashboard will continue to evolve based on feedback from Deans and Department Chairs.
HR Reporting and Analytics
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 was 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.
Student Reporting and Analytics
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.
The previously used Brio student dashboard (no longer available as of November 2016) has been gradually replaced with a more robust, interactive and graphic UDW+ Student Academic Management Dashboard.
In addition to the UDW+ Student Academic Management Dashboard, student reporting users are also given access to the UDW+ Registration Pipeline Dashboard, Retention Dashboard, and Academic Planner Dashboard.
The subject areas that are currently available in UDW+ include Term Registration, Class Enrollment, Degrees (conferred), Test Scores, Class Meeting Pattern, Registration Pipeline, Retention, Retention Summary, and Academic Planner.