The University Data Warehouse Plus (UDW+) will replace the current University Data Warehouse. Established as a Program, UDW+ continues to evolve and grow through:
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.
* Financial reporting has transitioned from Brio to UDW+ as of October 31st, 2013.
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.
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.
In conjunction with the launch of PeopleSync at NYU, the UDW+ HR Reporting and Analytics project kicked off in 2014. The primary goal is to provision HR data in the warehouse 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.
During the initial development phase, reporting needs of deans, school HR and financial administrators, and grants managers will be addressed through the creation of new dashboard contents and enhancements to existing dashboards. Salary expense reporting has also been enhanced to increase report performance and to provide ad hoc reporting capabilities.
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.